Documentation/EHI_Export/docs/tables/layout_options.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| form_id | VARCHAR | 31 | '' |
|
| layout_group_properties.grp_form_id | Defined in XML | R |
| | | field_id | VARCHAR | 31 | | | '' |
| lbf_data.field_id | Defined in XML | R | | lbt_data.field_id | Defined in XML | R | | shared_attributes.field_id | Defined in XML | R |
|
| | | group_id | VARCHAR | 31 | | | '' |
|
| layout_group_properties.grp_group_id | Defined in XML | R |
| | | title | TEXT | 65535 | √ | | NULL |
|
| | | seq | INT | 10 | | | 0 |
|
| | | data_type | TINYINT | 3 | | | 0 |
|
| | | uor | BOOLEAN | 3 | | | 1 |
|
| | | fld_length | INT | 10 | | | 15 |
|
| | | max_length | INT | 10 | | | 0 |
|
| | | list_id | VARCHAR | 100 | | | '' |
|
| | | titlecols | TINYINT | 3 | | | 1 |
|
| | | datacols | TINYINT | 3 | | | 1 |
|
| | | default_value | VARCHAR | 255 | | | '' |
|
| | | edit_options | VARCHAR | 36 | | | '' |
|
| | | description | TEXT | 65535 | √ | | NULL |
|
| | | fld_rows | INT | 10 | | | 0 |
|
| | | list_backup_id | VARCHAR | 100 | | | '' |
|
| | | source | CHAR | 1 | | | 'F' |
|
|
F=Form, D=Demographics, H=History, E=Encounter
| | conditions | TEXT | 65535 | √ | | NULL |
|
|
serialized array of skip conditions
| | validation | VARCHAR | 100 | √ | | NULL |
|
| | | codes | VARCHAR | 255 | | | '' |
|
| |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | form_id + field_id + seq |