hongik_hospital
Tables (6)
Department (department)
- Name (name) — String — Primary key — NOT NULL — PK
- HospitalId (hospital_id) — Long — Foreign key → Hospital.HospitalId — NOT NULL — PK
- TelephoneNumber (tel) — String
Doctor (doctor)
- DoctorId (doctor_id) — Long — Primary key — NOT NULL
- DepartmentName (department_name) — String — Foreign key → Department.Name — NOT NULL
- HospitalId (hospital_id) — Long — Foreign key → Department.HospitalId — NOT NULL
- Name (name) — String
Hospital (hospital)
- HospitalId (hospital_id) — Long — Primary key — NOT NULL
- Name (name) — String
- City (city) — String — Address
- Street (street) — String — Address
- Zipcode (zipcode) — String — Address
Patient (patient)
- PatientId (patient_id) — Long — Primary key — NOT NULL
- Name (name) — String
- Age (age) — int
- Gender (gender) — Gender — Enum(M, F)
Reservation (reservation)
- ReservationId (reservation_id) — Long — Primary key — NOT NULL
- DoctorId (doctor_id) — Long — Foreign key → Doctor.DoctorId — NOT NULL
- PatientId (patient_id) — Long — Foreign key → Patient.PatientId — NOT NULL
- ReserveDate (reserve_date) — Date — Class
- ReservationStatus (satatus) — LocalDateTime
Treatment (treatment)
- TreatmentId (treatment_id) — Long — Primary key — NOT NULL
- DoctorId (doctor_id) — Long — Foreign key → Doctor.DoctorId — NOT NULL
- PatientId (patient_id) — Long — Foreign key → Patient.PatientId — NOT NULL
- TreatDate (treat_date) — Date — Class
- Fee (fee) — int