Back to Openemr

procedure_answers

Documentation/EHI_Export/docs/tables/procedure_answers.html

latest1.2 KB
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
procedure_order_idBIGINT190

|

| procedure_order.procedure_order_id | Defined in XML | R |

|

references procedure_order.procedure_order_id

| | procedure_order_seq | INT | 10 | | | 0 |

|

|

references procedure_order_code.procedure_order_seq

| | question_code | VARCHAR | 31 | | | '' |

|

| procedure_questions.question_code | Defined in XML | R |

|

references procedure_questions.question_code

| | answer_seq | INT | 10 | | | null |

|

|

supports multiple-choice questions. answer_seq, incremented in code

| | answer | VARCHAR | 255 | | | '' |

|

|

answer data

| | procedure_code | VARCHAR | 31 | √ | | NULL |

|

| |

Indexes

Constraint NameTypeSortColumn(s)
PRIMARYPrimary keyAsc/Asc/Asc/Ascprocedure_order_id + procedure_order_seq + question_code + answer_seq

Relationships

Close relationships within degrees of separation