s_list Table (344)
A list, dynamic or staticFields
| Name | Description | Type | Nullable |
|---|---|---|---|
| id | Primary key | PK | No |
| type | Dynamic/static | type | No |
| name | The name of the list | String(255) | No |
| washed | Date when this list was last washed(not used until v2) | DateTime | Yes |
| washing_percent | How far the washing has gotten (not used until v2) | Short | Yes |
| flag | Not used | Short | Yes |
| number_of_elements | How many elements this list contains | Int | Yes |
| folder_id | The folder which this link belongs to. -1 indicates that the link is on the root | Int | No |
| dbi_agent_id | Integration agent (eJournal) | FK dbi_agent | No |
| dbi_key | The primary key for the integrated entry in the external datasource. | String(255) | No |
| dbi_last_syncronized | Last external syncronization. | DateTime | No |
| dbi_last_modified | When the entry was last modified. | DateTime | No |
Indexes
| Fields | Types | Description |
|---|---|---|
| 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.