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