ejselection Table (391)
This table stores selections, dynamic groups.Fields
| Name | Description | Type | Nullable |
|---|---|---|---|
| id | Primary key | PK | No |
| name | The name of this package | String(255) | Yes |
| include_id | A unique name used for refering to selections in scripts, url's etc. | String(255) | No |
| ej_table | The source table | String(255) | Yes |
| display_properties | The display properties of this selection | Clob | Yes |
| hierarchy_id | This extra table is inside this hierarchy folder | FK hierarchy | No |
| source_type | The source type of this selection | Int | No |
| source_id | The id of the source we links to | Int | No |
| access_level | Access level for this selection | Int | No |
| left_menu | Will this selection be listed in the left menu? | Bool | Yes |
| creator | The user who created this selection | FK ejuser | No |
| last_count | Last result count | Int | Yes |
| result_config | XML data | Clob | Yes |
Indexes
| Fields | Types | Description |
|---|---|---|
| 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.