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>