Back to Openemr

customlists

Documentation/EHI_Export/docs/tables/customlists.html

latest1.2 KB
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
cl_list_slnoINT UNSIGNED10null

|

| | | 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 NameTypeSortColumn(s)
PRIMARYPrimary keyAsccl_list_slno

Relationships

Close relationships within degrees of separation