Documentation/EHI_Export/docs/tables/onsite_signatures.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
| | | status | VARCHAR | 128 | | | 'waiting' |
|
| | | type | VARCHAR | 128 | | | null |
|
|
witness-signature
| | created | INT | 10 | | | null |
|
| | | lastmod | DATETIME | 19 | | | null |
|
| | | pid | BIGINT | 19 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | encounter | INT | 10 | √ | | NULL |
|
| form_encounter.encounter | Defined in XML | R |
| | | user | VARCHAR | 255 | √ | | NULL |
|
|
User who created the esignature. If the signature is a staff member (administrator/witness) it will come from the users.username. If it is a patient signature the value will be ‘-patient-’
| | activity | TINYINT | 3 | | | 0 |
|
| | | authorized | TINYINT | 3 | √ | | NULL |
|
| | | signator | VARCHAR | 255 | | | null |
|
| | | sig_image | TEXT | 65535 | √ | | NULL |
|
|
The image of the signature as a Data URI created from a browser Canvas object representing an image/png image of the signature
| | signature | TEXT | 65535 | √ | | NULL |
|
| | | sig_hash | VARCHAR | 255 | | | null |
|
|
sha3-512 hash of the sig_image
| | ip | VARCHAR | 46 | | | null |
|
| | | signer | Unknown | 0 | | | null |
|
|
If type=witness-signature signer will be ‘Witness Signature’ if type=‘admin-signature’ then signer will be the Username of the clinical staff member that signed, if type=‘patient-signature’ then the value will be the patient’s name
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| encounter | Performance | Asc | encounter |
| pid | Must be unique | Asc/Asc | pid + user |