v_epcr_history

v_epcr_history

Purpose

  1. Patient medical history records.

Relationships


  • f_epcr: Many-to-One (N:1)

    • Many history records link to one EPCR

    • Referenced through epcr_id

  • v_epcr_history_medication: One-to-Many (1:N)

    • One history record can have many medication records

    • Referenced through historical relationship



Table


Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

client_code

varchar(28)

Organization ID

created_at

timestamp

Creation timestamp

patient_first_name

varchar(50)

Patient first name

patient_last_name

varchar(60)

Patient last name




    • Related Articles

    • v_epcr_history_medication

      Purpose Patient medication history records. Relationships f_epcr: Many-to-One (N:1) Many medication histories link to one EPCR Referenced through epcr_id v_epcr_history: Many-to-One (N:1) Many medications link to one history record Referenced through ...

    • v_epcr_exam

      Purpose Patient examination records. Relationships f_epcr: Many-to-One (N:1) Many exams link to one EPCR Referenced through epcr_id v_epcr_vital: One-to-Many (1:N) One exam can have many vital sign records Referenced through timeline relationship ...

    • v_epcr_disposition_team

      Purpose Patient care team disposition records. Relationships f_epcr: Many-to-One (N:1) Many dispositions link to one EPCR Referenced through epcr_id v_personnel: Many-to-Many (N:M) Many dispositions can involve many personnel Referenced through team ...

    • v_epcr_other_crew

      Purpose Additional crew member records for patient care. Relationships f_epcr: Many-to-One (N:1) Many crew records link to one EPCR Referenced through epcr_id v_personnel: Many-to-One (N:1) Many crew records link to one personnel Referenced through ...

    • v_epcr_medication

      Purpose Current medication administration records. Relationships f_epcr: Many-to-One (N:1) Many medications link to one EPCR Referenced through epcr_id v_personnel: Many-to-One (N:1) Many medications administered by one personnel Referenced through ...