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)