hospital_reservation

Tables (3)

Doctor (의사)

  • doctorId (의사 id) — Primary key — NOT NULL
  • name (의사명)
  • specialization (전공)

Patient (환자)

  • patientId (환자 id) — Primary key — NOT NULL
  • name (환자명)
  • age (나이)

Reservation (예약)

  • reservationId (예약 id) — Primary key — NOT NULL
  • doctorId (의사 id2) — Foreign key → Doctor.doctorId — NOT NULL
  • patientId (환자 id2) — Foreign key → Patient.patientId — NOT NULL
  • reservationStartTime (예약 시작 시간)
  • reservationEndTime (예약 종료 시간)
  • reason (예약 사유)
  • fee (금액)