HIhospital

Tables (6)

Department

  • id (department_id) — Long — Primary key — NOT NULL
  • 병원 (hospital_id) — Long — Foreign key → Hospital.id — NOT NULL
  • 이름 (name) — varchar

Doctor

  • id (doctor_id) — Long — Primary key — NOT NULL
  • 진료과 (department_id) — Long — Foreign key → Department.id — NOT NULL
  • 이름 (name) — varchar
  • 경력 (career) — Int

Hospital

  • id (hospital_id) — Long — Primary key — NOT NULL
  • name — varchar
  • city — varchar
  • street — varchar
  • zipcode — varchar

Patient

  • id (patient_id) — Long — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 성별 (gender) — varchar
  • 성별 (age) — Int

Reservation

  • id (reservation_id) — Long — Primary key — NOT NULL
  • id (patient_id) — Long — Foreign key → Patient.id — NOT NULL
  • id (doctor_id) — Long — Foreign key → Doctor.id — NOT NULL
  • 진료과 (department_id) — Long — Foreign key → Doctor.진료과 — NOT NULL
  • 환자이름 (name) — varchar
  • 시간 (time) — Date
  • 예약상태 (status) — varchar

Treatment

  • id (treatment_id) — Long — Primary key — NOT NULL
  • id (doctor_id) — Long — Foreign key → Doctor.id — NOT NULL
  • id (patient_id) — Long — Foreign key → Patient.id — NOT NULL
  • 비용 (bill) — Int
  • 진료상태 (status) — varchar
  • 환자이름 (name) — varchar
  • 시간 (time) — Date