Documentation/EHI_Export/docs/tables/procedure_questions.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| lab_id | BIGINT | 19 | 0 |
|
| procedure_providers.ppid | Defined in XML | R |
|
references procedure_providers.ppid to identify the lab
| | procedure_code | VARCHAR | 31 | | | '' |
|
| procedure_type.procedure_code | Defined in XML | R |
|
references procedure_type.procedure_code to identify this order type
| | question_code | VARCHAR | 31 | | | '' |
| procedure_answers.question_code | Defined in XML | R |
|
|
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 | TEXT | 65535 | √ | | NULL |
|
|
choices for fldtype S and T
| | tips | VARCHAR | 255 | | | '' |
|
|
Additional instructions for answering the question
| | activity | BOOLEAN | 3 | | | 1 |
|
|
1 = active, 0 = inactive
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | lab_id + procedure_code + question_code |