디비 플젝
테이블 (9)
Doctor
- doctor_id — BIGINT — 기본 키 — NOT NULL
- Field (name)
- Field (address)
- Field2 (phone_number)
- Field (password)
- Field (status) — 1
- Key (department_id) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MedicalSpecialty)
- Key (department_id) — 기본 키 — NOT NULL
- Field (department_name)
- Field2 (phone_number)
Untitled (Nurse)
- Key (nurse_id) — 기본 키 — NOT NULL
- Field (name)
- Field2 (address)
- Field3 (phone_number)
- Field (password)
- Field (status) — 2
- Key (department_id) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Patient)
- Key (patient_id) — 기본 키 — NOT NULL
- Field (name)
- Field2 (ssn)
- Field3 (gender)
- Field4 (address)
- Field5 (blood_type)
- Field6 (height)
- Field (weight)
- Field2 (phone_number)
- Field (password)
- Field (status) — 3
- doctor_id — BIGINT — 외래 키 → Doctor.doctor_id — NOT NULL
- Key (nurse_id) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Inpatient)
- Key (patient_id) — 외래 키 → Untitled.Key — NOT NULL
- Field (room_information)
- Field2 (admission_date_time)
- Field3 (discharge_date_time)
Untitled (Reservation)
- Key (reservation_number) — 기본 키 — NOT NULL
- Field (reservation_date_time)
- Key (department_id) — 외래 키 → Untitled.Key — NOT NULL
- Key (patient_id) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Examination)
- Key — 기본 키 — NOT NULL
- Field (examination_date_time)
- Field2 (examination_details)
- doctor_id — BIGINT — 외래 키 → Doctor.doctor_id — NOT NULL
- Key (patient_id) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Treatment)
- Key — 기본 키 — NOT NULL
- Field (treatment_date_time)
- Field2 (treatment_details)
- Key (nurse_id) — 외래 키 → Untitled.Key — NOT NULL
- Key (patient_id) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Manager)
- Key (manager_id) — 기본 키 — NOT NULL
- Field (name)
- Field (password)
- Field (status) — 0
- Field