v_nfirs_ems: Many-to-One (N:1)
Many signatures link to one EMS record
Referenced through nfirs_ems_id
v_personnel: Many-to-One (N:1)
Many signatures created by one provider
Referenced through provider
Column | Type | Description |
id | integer | Primary key |
client_code | varchar(28) | Organization ID |
nfirs_ems_id | integer | EMS record reference |
performed_date | date | Signature date |
performed_time | time | Signature time |
person_type_code | varchar(10) | Signer type |
representative_type_code | varchar(10) | Representative type |
provider | integer | Provider reference |
signing_reason_codes | jsonb | Reason codes |
first_name | varchar(50) | Signer first name |
mid_name | varchar(50) | Signer middle name |
last_name | varchar(50) | Signer last name |
ems_signature_status_code | varchar(10) | Status code |
no_signature_reason | varchar(10) | Missing reason |
signature_data | text | Signature data |
created_by | integer | Creator reference |
created_at | timestamp | Creation time |
updated_at | timestamp | Update time |