Changes between Version 10 and Version 11 of ERModel


Ignore:
Timestamp:
09/18/26 15:14:47 (5 days ago)
Author:
236021
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERModel

    v10 v11  
    581581each doctor belongs to one department, a department employs many doctors.
    582582
    583 === identifies (Users ↔ Patients / Doctors / Admin / Lab_Technician, 1:1) ===
    584 a user account links to exactly one underlying person record, depending on role.
     583=== identifies_patient (Users ↔ Patients, 1:1) ===
     584a Users row optionally links to one Patients row, when the account belongs to a patient.
     585
     586=== identifies_doctor (Users ↔ Doctors, 1:1) ===
     587a Users row optionally links to one Doctors row, when the account belongs to a doctor.
     588
     589=== identifies_admin (Users ↔ Admin, 1:1) ===
     590a Users row optionally links to one Admin row, when the account belongs to an administrator.
     591
     592=== identifies_lab_technician (Users ↔ Lab_Technician, 1:1) ===
     593a Users row optionally links to one Lab_Technician row, when the account belongs to a lab technician.
     594
     595Constraint for identifies relations: Exactly one of the four relationships above must be populated for a given Users row, depending on its role.
    585596
    586597=== has_allergies (Patients ↔ Allergies, M:N via Patient_Allergies) ===
    … …  
    612623
    613624=== requires (Diagnosis ↔ Procedures, M:N via Diagnosis_Procedures) ===
    614 a diagnosis can require multiple procedures, and the same procedure can be linked to multiple diagnoses ,in addition to the direct diagnosis_id FK each procedure row already carries.
     625a diagnosis can require multiple procedures, and the same procedure can be linked to multiple diagnoses, in addition to the direct 1:N relationship each procedure already has with its primary diagnosis.
    615626
    616627=== produces (Procedures ↔ Procedure_Results, 1:N) ===
    … …  
    627638
    628639=== tested_as (Lab_Tests ↔ Performed_Lab_Tests, 1:N) ===
    629 a catalog test can be performed many times; each performed test refers to one catalog test.
     640a catalog test can be performed many times, each performed test refers to one catalog test.
    630641
    631642=== takes_test (Patients ↔ Performed_Lab_Tests, 1:N) ===
    … …  
    700711=== generates_bill (Medical_Records ↔ Billing, 1:N) ===
    701712a record can generate multiple bills, each bill is tied to one record.
    702