| 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 |
|
|
The internal patient identifier |
||||
| encounter | INT | 10 | √ | NULL |
|
|
|||||
| 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 |
Showing 1 to 16 of 16 entries