Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
|||||
| uuid | BINARY | 16 | √ | NULL |
|
|
|||||
| response_id | VARCHAR | 255 | √ | NULL |
|
|
A globally unique id for answer set. String version of UUID |
||||
| questionnaire_foreign_id | BIGINT | 19 | √ | NULL |
|
|
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 |
|
|
The internal patient identifier |
||||
| encounter | INT | 10 | √ | NULL |
|
|
May or may not be associated with an encounter |
||||
| audit_user_id | INT | 10 | √ | NULL |
|
|
|||||
| creator_user_id | INT | 10 | √ | NULL |
|
|
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 |
Indexes
| 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 |