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