db-홍익병원
테이블 (5)
Appointment
- appintment_id (Key) — Long — 기본 키 — NOT NULL
- doctor_id (Key3) — Long — 외래 키 → Doctor.doctor_id — NOT NULL
- patient_id (Key4) — Long — 외래 키 → Patient.patient_id — NOT NULL
- reserveTime (Field) — LocalDateTime
- isCompleted (Field2) — Boolean
- cost (Field3) — int
- hospital_id (Key2) — Long — 외래 키 → Hospital.hospital_id — NOT NULL
Department
- department_id (Key) — Long — 기본 키 — NOT NULL
- hospital_id (Key2) — Long — 외래 키 → Hospital.hospital_id — NOT NULL
- name (Field3) — String
- telNum (Field) — int
- doctors (Field2) — List<Doctor>
Doctor
- doctor_id (Key) — Long — 기본 키 — NOT NULL
- hospital_id (Key2) — Long — 외래 키 → Hospital.hospital_id — NOT NULL
- department_id (Key3) — Long — 외래 키 → Department.department_id — NOT NULL
- hospital_id (Key22) — Long — 외래 키 → Department.hospital_id — NOT NULL
- name (Field) — String
- career (Field2) — int
Hospital
- hospital_id (Key) — Long — 기본 키 — NOT NULL
- name (Field) — String
- address (Field2) — String
- doctors (Field3) — List<Doctor>
- departments (Field4) — List<Department>
Patient
- patient_id (Key) — Long — 기본 키 — NOT NULL
- age (Field) — int
- gender (Field2) — enum
- appointments (Field3) — List<Appointment>