Changes between Version 6 and Version 7 of RelationalDesign


Ignore:
Timestamp:
09/19/26 15:25:46 (4 days ago)
Author:
236021
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v6 v7  
    1414USERS & ROLES
    1515}}}
    16  1. users(user_id [PK], username [UQ], password, role, first_name, last_name, is_active, patient_id*(PATIENTS), doctor_id*(DOCTORS), admin_id*(ADMIN), technician_id*(LAB_TECHNICIAN))
     16 1. users(user_id [PK], username [UQ], password, role, first_name, last_name, is_active, patient_id*(PATIENTS), doctor_id*(DOCTORS), admin_id*(ADMIN), lab_technician_id*(LAB_TECHNICIAN))
    1717
    1818{{{
    … …  
    6161 22. lab_tests(test_id [PK], test_name, description, cost)
    6262 23. lab_results(result_id [PK], results, result_date, test_id*(LAB_TESTS))
    63  24. performed_lab_tests(performed_test_id [PK], test_date, notes, test_id*(LAB_TESTS), patient_id*(PATIENTS), doctor_id*(DOCTORS), technician_id*(LAB_TECHNICIAN))
     63 24. performed_lab_tests(performed_test_id [PK], test_date, notes, created_at, test_id*(LAB_TESTS), patient_id*(PATIENTS), doctor_id*(DOCTORS), technician_id*(LAB_TECHNICIAN))
    6464
    6565{{{
    … …  
    7878 31. prescription_medical_records(prescription_id*(PRESCRIPTIONS), record_id*(MEDICAL_RECORDS), dosage, frequency, duration, notes)
    7979 32. medical_record_lab_results(record_id*(MEDICAL_RECORDS), result_id*(LAB_RESULTS))
    80  33. medical_record_procedure_results(record_id*(MEDICAL_RECORDS), result_id*(PROCEDURE_RESULTS))
    81  34. medical_record_procedures(record_id*(MEDICAL_RECORDS), procedure_id*(PROCEDURES))
    82  35. medical_record_symptoms(record_id*(MEDICAL_RECORDS), symptom_id*(SYMPTOMS), severity)
    83  36. medical_record_allergies(record_id*(MEDICAL_RECORDS), allergy_id*(ALLERGIES), reaction, severity)
     80 33. medical_record_procedures(record_id*(MEDICAL_RECORDS), procedure_id*(PROCEDURES))
     81 34. medical_record_symptoms(record_id*(MEDICAL_RECORDS), symptom_id*(SYMPTOMS), severity)
     82 35. medical_record_allergies(record_id*(MEDICAL_RECORDS), allergy_id*(ALLERGIES), reaction, severity)
    8483
    8584{{{
    8685REPORTS & REFERRALS
    8786}}}
    88  37. medical_report(report_id [PK], description, report_date, record_id*(MEDICAL_RECORDS), doctor_id*(DOCTORS))
    89  38. medical_report_lab_results(report_id*(MEDICAL_REPORT), result_id*(LAB_RESULTS))
    90  39. referrals(referral_id [PK], reason, referral_date, record_id*(MEDICAL_RECORDS), from_doctor_id*(DOCTORS), to_doctor_id*(DOCTORS))
     87 36. medical_report(report_id [PK], description, report_date, record_id*(MEDICAL_RECORDS), doctor_id*(DOCTORS))
     88 37. medical_report_lab_results(report_id*(MEDICAL_REPORT), result_id*(LAB_RESULTS))
     89 38. referrals(referral_id [PK], reason, referral_date, record_id*(MEDICAL_RECORDS), from_doctor_id*(DOCTORS), to_doctor_id*(DOCTORS))
    9190
    9291{{{
    9392BILLING
    9493}}}
    95  40. billing(bill_id [PK], total_cost, payment_status, payment_date, record_id*(MEDICAL_RECORDS), admin_id*(ADMIN))
    96  41. billing_procedures(bill_id*(BILLING), procedure_id*(PROCEDURES))
    97  42. billing_lab_tests(bill_id*(BILLING), test_id*(LAB_TESTS))
     94 39. billing(bill_id [PK], total_cost, payment_status, payment_date, created_at, record_id*(MEDICAL_RECORDS), admin_id*(ADMIN))
     95 40. billing_procedures(bill_id*(BILLING), procedure_id*(PROCEDURES))
     96 41. billing_lab_tests(bill_id*(BILLING), test_id*(LAB_TESTS))
    9897
    9998== DDL ==