| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| lab_id | BIGINT | 19 | 0 |
|
|
references procedure_providers.ppid to identify the lab |
|||||
| procedure_code | VARCHAR | 31 | '' |
|
|
references procedure_type.procedure_code to identify this order type |
|||||
| question_code | VARCHAR | 31 | '' |
|
|
code identifying this question |
|||||
| seq | INT | 10 | 0 |
|
|
sequence number for ordering |
|||||
| question_text | VARCHAR | 255 | '' |
|
|
descriptive text for question_code |
|||||
| required | BOOLEAN | 3 | 0 |
|
|
1 = required, 0 = not |
|||||
| maxsize | INT | 10 | 0 |
|
|
maximum length if text input field |
|||||
| fldtype | CHAR | 1 | 'T' |
|
|
Text, Number, Select, Multiselect, Date, Gestational-age |
|||||
| options | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
choices for fldtype S and T |
||||
| tips | VARCHAR | 255 | '' |
|
|
Additional instructions for answering the question |
|||||
| activity | BOOLEAN | 3 | 1 |
|
|
1 = active, 0 = inactive |
Showing 1 to 11 of 11 entries