Documentation/EHI_Export/docs/tables/onsite_documents.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
| | | pid | BIGINT UNSIGNED | 20 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | facility | INT UNSIGNED | 10 | √ | | NULL |
|
| facility.id | Defined in XML | R |
| | | provider | INT UNSIGNED | 10 | √ | | NULL |
|
| | | encounter | INT UNSIGNED | 10 | √ | | NULL |
|
| form_encounter.encounter | Defined in XML | R |
| | | create_date | TIMESTAMP | 19 | | | current_timestamp() |
|
| | | doc_type | VARCHAR | 255 | | | null |
|
| | | patient_signed_status | SMALLINT UNSIGNED | 5 | | | null |
|
| | | patient_signed_time | DATETIME | 19 | √ | | NULL |
|
| | | authorize_signed_time | DATETIME | 19 | √ | | NULL |
|
| | | accept_signed_status | SMALLINT | 5 | | | null |
|
| | | authorizing_signator | VARCHAR | 50 | | | null |
|
| | | review_date | DATETIME | 19 | √ | | NULL |
|
| | | denial_reason | VARCHAR | 255 | | | null |
|
| | | authorized_signature | TEXT | 65535 | √ | | NULL |
|
| | | patient_signature | TEXT | 65535 | √ | | NULL |
|
| | | full_document | MEDIUMBLOB | 16777215 | √ | | NULL |
|
| | | file_name | VARCHAR | 255 | | | null |
|
| | | file_path | VARCHAR | 255 | | | null |
|
| | | template_data | LONGTEXT | 2147483647 | √ | | NULL |
|
| | | user | Unknown | 0 | | | null |
|
| users.id | Defined in XML | R |
|
User who created the esignature
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |