Documentation/EHI_Export/docs/tables/questionnaire_response.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
| | | uuid | BINARY | 16 | √ | | NULL |
|
| | | response_id | VARCHAR | 255 | √ | | NULL |
| form_questionnaire_assessments.response_id | Defined in XML | R |
|
|
A globally unique id for answer set. String version of UUID
| | questionnaire_foreign_id | BIGINT | 19 | √ | | NULL |
|
| questionnaire_repository.id | Defined in XML | R |
|
questionnaire_repository id for subject questionnaire
| | questionnaire_id | VARCHAR | 255 | √ | | NULL |
|
|
Id for questionnaire content. String version of UUID
| | questionnaire_name | VARCHAR | 255 | √ | | NULL |
|
| | | patient_id | INT | 10 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | encounter | INT | 10 | √ | | NULL |
|
| form_encounter.encounter | Defined in XML | R |
|
May or may not be associated with an encounter
| | audit_user_id | INT | 10 | √ | | NULL |
|
| users.id | Defined in XML | R |
| | | creator_user_id | INT | 10 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
user id if answers are provider
| | create_time | DATETIME | 19 | √ | | current_timestamp() |
|
| | | last_updated | DATETIME | 19 | √ | | NULL |
|
| | | version | INT | 10 | | | 1 |
|
| | | status | VARCHAR | 63 | √ | | NULL |
|
|
form current status. completed,active,incomplete
| | questionnaire | LONGTEXT | 2147483647 | √ | | NULL |
|
|
the subject questionnaire json
| | questionnaire_response | LONGTEXT | 2147483647 | √ | | NULL |
|
|
questionnaire response json
| | form_response | LONGTEXT | 2147483647 | √ | | NULL |
|
|
lform answers array json
| | form_score | INT | 10 | √ | | NULL |
|
|
Arithmetic scoring of questionnaires
| | tscore | DOUBLE | 22 | √ | | NULL |
|
|
T-Score
| | error | DOUBLE | 22 | √ | | NULL |
|
|
Standard error for the T-Score
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| response_index | Performance | Asc/Asc/Asc/Asc | response_id + patient_id + questionnaire_id + questionnaire_name |
| uuid | Must be unique | Asc | uuid |