Documentation/EHI_Export/docs/tables/customlists.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| cl_list_slno | INT UNSIGNED | 10 | √ | null |
|
| | | cl_list_id | INT UNSIGNED | 10 | | | null |
|
|
ID OF THE lIST FOR NEW TAKE SELECT MAX(cl_list_id)+1
| | cl_list_item_id | INT UNSIGNED | 10 | √ | | NULL |
|
|
ID OF THE lIST FOR NEW TAKE SELECT MAX(cl_list_item_id)+1
| | cl_list_type | INT UNSIGNED | 10 | | | null |
|
|
0=>List Name 1=>list items 2=>Context 3=>Template 4=>Sentence 5=> SavedTemplate 6=>CustomButton
| | cl_list_item_short | VARCHAR | 10 | √ | | NULL |
|
| | | cl_list_item_long | TEXT | 65535 | √ | | NULL |
|
| | | cl_list_item_level | INT | 10 | √ | | NULL |
|
|
Flow level for List Designation
| | cl_order | INT | 10 | √ | | NULL |
|
| | | cl_deleted | BOOLEAN | 3 | √ | | 0 |
|
| | | cl_creator | INT | 10 | √ | | NULL |
|
| |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | cl_list_slno |