s_list Table (344)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
A list, dynamic or static
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | Primary key | PK | |
| type | Dynamic/static | type | |
| name | The name of the list | String(255) | |
| washed | Date when this list was last washed(not used until v2) | DateTime | ● |
| washing_percent | How far the washing has gotten (not used until v2) | Short | ● |
| flag | Not used | Short | ● |
| number_of_elements | How many elements this list contains | Int | ● |
| folder_id | The folder which this link belongs to. -1 indicates that the link is on the root | Int | |
| dbi_agent_id | Integration agent (eJournal) | FK dbi_agent | |
| dbi_key | The primary key for the integrated entry in the external datasource. | String(255) | |
| dbi_last_syncronized | Last external syncronization. | DateTime | |
| dbi_last_modified | When the entry was last modified. | DateTime |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| dbi_agent_id | FK | Index |
| dbi_key | String(255) | Index |
| dbi_last_syncronized | DateTime | Index |
| dbi_last_modified | DateTime | Index |
Relationships
| Table | Description |
|---|---|
| dbi_agent | DBI agent settings |
| s_dyn_criteria | Contains criterias for a dynamic list. |
| s_list_customer | Elements in a customer list. |
| s_list_element | Elements in a static list. |
| s_list_shipment | A connector between shipment and list so that one shipment can have many lists, and one list can have many shipments |
| s_washing_list | Unused table that is ment to be used for active washing in spm v2 |
Replication Flags
- None
Security Flags
- No access control via user's Role.