db
Tables (9)
doctor (Untitled)
- doctor_id (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
- phone_number (Field3)
- password (Field4)
- department_id (Key2) — Foreign key → medical_department.department_id — NOT NULL
examination (Untitled8)
- Key — Primary key — NOT NULL
- examination_datetime (Field)
- examination_details (Field2)
- doctor_id (Key2) — Foreign key → doctor.doctor_id — NOT NULL
- patient_id (Key3) — Foreign key → patient.patient_id — NOT NULL
inpatient (Untitled6)
- Key — Primary key — NOT NULL
- room_information (Field)
- admission_datetime (Field2)
- discharge_datetime (Field3)
- patient_id (Key2) — Foreign key → patient.patient_id — NOT NULL
medical_department (Untitled5)
- department_id (Key) — Primary key — NOT NULL
medical_speciality (Untitled4)
- department_id (Key) — Foreign key → medical_department.department_id — NOT NULL
- department_name (Field)
- department_phone_number (Field2)
nurse (Untitled2)
- nurse_id (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
- phone_number (Field3)
- password (Field4)
- department_id (Key2) — Foreign key → medical_department.department_id — NOT NULL
patient (Untitled3)
- patient_id (Key) — Primary key — NOT NULL
- name (Field)
- ssn (Field2)
- gender (Field3)
- address (Field4)
- blood_type (Field5)
- height (Field6)
- weight (Field7)
- phone_number (Field8)
- password (Field9)
- nurse_id (Key2) — Foreign key → nurse.nurse_id — NOT NULL
- doctor_id (Key3) — Foreign key → doctor.doctor_id — NOT NULL
reservation (Untitled7)
- reservation_number (Key) — Primary key — NOT NULL
- reservation_datetime (Field)
- patient_id (Key2) — Foreign key → patient.patient_id — NOT NULL
- department_id (Key3) — Foreign key → medical_speciality.department_id — NOT NULL
treatment (Untitled9)
- Key — Primary key — NOT NULL
- treatment_datetime (Field)
- treatment_details (Field2)
- nurse_id (Key2) — Foreign key → nurse.nurse_id — NOT NULL
- patient_id (Key3) — Foreign key → patient.patient_id — NOT NULL