v_nfirs_ems: Many-to-One (N:1)
Many treatments link to one EMS record
Referenced through nfirs_ems_id
v_personnel: Many-to-One (N:1)
Many treatments performed 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 |
ems_treatment_code | varchar(50) | Treatment code |
performed_date | date | Treatment date |
performed_time | time | Treatment time |
performed_code | varchar(10) | Performance code |
provider | integer | Provider reference |
number_of_attempts | integer | Attempt count |
attempts_code | varchar(10) | Attempts code |
successful_code | varchar(10) | Success code |
created_by | integer | Creator reference |
created_at | timestamp | Creation time |
updated_at | timestamp | Update time |