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 (금액)