Columns
| 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 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | cl_list_slno |