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.