Documentation/EHI_Export/docs/tables/pro_assessments.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
| | | form_oid | VARCHAR | 255 | | | null |
|
|
unique id for specific instrument, pulled from assessment center API
| | form_name | VARCHAR | 255 | | | null |
|
|
pulled from assessment center API
| | user_id | INT | 10 | | | null |
|
| users.id | Defined in XML | R |
|
ID for user that orders the form
| | deadline | DATETIME | 19 | | | null |
|
|
deadline to complete the form, will be used when sending notification and reminders
| | patient_id | INT | 10 | | | null |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | assessment_oid | VARCHAR | 255 | | | null |
|
|
unique id for this specific assessment, pulled from assessment center API
| | status | VARCHAR | 255 | | | null |
|
|
ordered or completed
| | score | DOUBLE | 22 | | | null |
|
|
T-Score for the assessment
| | error | DOUBLE | 22 | | | null |
|
|
Standard error for the score
| | created_at | DATETIME | 19 | | | null |
|
|
timestamp recording the creation time of this assessment
| | updated_at | DATETIME | 19 | | | null |
|
|
this field indicates the completion time when the status is completed
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |