tree_explorer_entry Table (399)
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
This table stores the entries in a tree-explorer
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | Primary key | PK | |
| parent_id | The parent id of the entry | FK tree_explorer_entry | |
| name | The name of the entry | String(255) | |
| icon | The icon of the entry | String(255) | ● |
| onclick | The onclick action of the entry | String(255) | ● |
| href | The href of the entry | String(255) | ● |
| tooltip | The tooltip of the entry | Clob | ● |
| target | The target of the href of the entry | String(255) | ● |
| sort_order | The order of the entry | Int | ● |
| leaf | True if the entry is a leaf node | Bool | ● |
| session_key | The session this entry belongs to | String(255) | ● |
| expand_order | If > 0 then expanded and insertorder for the tree | Int | ● |
| tree_key | The key used for reloading | String(255) | ● |
| internal_id | The internal id for the tree | String(255) | ● |
| internal_parent | The internal parent id for the tree | String(255) | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| parent_id | FK | Index |
| session_key | String(255) | Index |
| expand_order | Int | Index |
| tree_key | String(255) | Index |
Relationships
| Table | Description |
|---|---|
| tree_explorer_entry | This table stores the entries in a tree-explorer |
| tree_explorer_link | This table stores the link of entries in a tree-explorer |
Replication Flags
- None
Security Flags
- No access control via user's Role.