HOSPITAL_ERD

Tables (5)

DepartmentTbl (department_tbl)

  • Disease_Id (disease_id) — NUMBER(2) — Primary key — NOT NULL
  • Disease_Name (disease_name) — NCHAR(15)

DoctorTbl (doctor_tbl)

  • Doctor_Id (doctor_id) — CHAR(8 BYTE) — Primary key — NOT NULL
  • Disease_Id (disease_id) — NUMBER(2) — Foreign key → DepartmentTbl.Disease_Id — NOT NULL
  • D_Name (d_name) — NCHAR(6)
  • In_Time (in_time) — DATE
  • Out_Time (out_time) — DATE

HospitalizationTbl (hospitalization_tbl)

  • Patient_Id (patient_id) — CHAR(8 BYTE) — Foreign key → PatientTbl.Patient_Id — NOT NULL
  • Disease_Id (disease_id) — NUMBER(2) — Foreign key → PatientTbl.Disease_Id — NOT NULL
  • Hosp_Date (hosp_date) — DATE
  • HRoom_Id (hroom_id) — CHAR(8 BYTE)

PatientTbl (patient_tbl)

  • Patient_Id (patient_id) — CHAR(8 BYTE) — Primary key — NOT NULL
  • Disease_Id (disease_id) — NUMBER(2) — Foreign key → DepartmentTbl.Disease_Id — NOT NULL
  • Doctor_Id (doctor_id) — CHAR(8 BYTE) — Foreign key → DoctorTbl.Doctor_Id — NOT NULL
  • P_Name (p_name) — NCHAR(6)
  • P_Birth (p_birth) — NUMBER(6, 0)
  • G_Name (g_name) — NCHAR(6)
  • Surgery (surgery) — CHAR(1 BYTE)
  • Hospitalization (hospitalization) — CHAR(1 BYTE)
  • R_Date (r_date) — DATE

SurgeryTbl (surgery_tbl)

  • Patient_Id (patient_id) — CHAR(8 BYTE) — Foreign key → PatientTbl.Patient_Id — NOT NULL
  • Doctor_Id (doctor_id) — CHAR(8 BYTE) — Foreign key → PatientTbl.Doctor_Id — NOT NULL
  • Start_Time (start_time) — DATE
  • End_Time (end_time) — DATE
  • Surg_Date (surg_date) — DATE
  • SRoom_Id (sroom_id) — CHAR(8 BYTE)