ejselection Table (391)
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
This table stores selections, dynamic groups.
Fields
Name | Description | Type | Null |
---|---|---|---|
id | Primary key | PK | |
name | The name of this package | String(255) | ● |
include_id | A unique name used for refering to selections in scripts, url's etc. | String(255) | |
ej_table | The source table | String(255) | ● |
display_properties | The display properties of this selection | Clob | ● |
hierarchy_id | This extra table is inside this hierarchy folder | FK hierarchy | |
source_type | The source type of this selection | Int | |
source_id | The id of the source we links to | Int | |
access_level | Access level for this selection | Int | |
left_menu | Will this selection be listed in the left menu? | Bool | ● |
creator | The user who created this selection | FK ejuser | |
last_count | Last result count | Int | ● |
result_config | XML data | Clob | ● |
Indexes
Fields | Types | Description |
---|---|---|
id | PK | Clustered, Unique |
include_id | String(255) | Index |
hierarchy_id | FK | Index |
source_type | Int | Index |
source_id | Int | Index |
creator | FK | Index |
Relationships
Table | Description |
---|---|
ejsel_ejsel | This table defines sources for complex selections in a many/many relationship |
ejsel_meta_result | This table stores result meta data |
ejuser | This table contains entries for the users of the system. |
hierarchy | This table contains folders used to group the extra tables in the system. |
s_link | Links in messages to measure success rate of a campaign. |
Replication Flags
- None
Security Flags
- No access control via user's Role.