MediBooker

Tables (10)

Departments

  • department_id — INT
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • department_phone_number — VARCHAR(15) — NOT NULL
  • del_yn — ENUM('N', 'Y')

Doctors

  • doctor_id — INT
  • doctor_name — VARCHAR(10) — NOT NULL
  • department_id — INT — Foreign key → Departments.department_id — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • office_number — VARCHAR(10) — NOT NULL
  • avg_rating — FLOAT
  • del_yn — ENUM('N', 'Y')

Feedback

  • feedback_id — int
  • record_id — int — NOT NULL
  • rating — int
  • feedback_text — VARCHAR(255)
  • del_yn — enum('N', 'Y')

Manager

  • manager_id — INT
  • department_id — INT — Foreign key → Departments.department_id
  • manager_name — VARCHAR(20) — NOT NULL
  • del_yn — ENUM('N', 'Y')

Medical_Records

  • record_id — INT
  • patient_id — INT — Foreign key → Patients.patient_id — NOT NULL
  • doctor_id — INT — Foreign key → Doctors.doctor_id — NOT NULL
  • department_id — INT — Foreign key → Departments.department_id — NOT NULL
  • manager_id — INT — Foreign key → Manager.manager_id — NOT NULL
  • diagnosis — VARCHAR(255) — NOT NULL
  • treatment — TEXT — NOT NULL
  • prescription — VARCHAR(255) — NOT NULL
  • visit_date — TIMESTAMP
  • del_yn — ENUM('N', 'Y')

Patients

  • patient_id — INT
  • patient_name — VARCHAR(30) — NOT NULL
  • identity_number — VARCHAR(20) — NOT NULL
  • patient_phone — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • patient_authentication — ENUM('N', 'Y')
  • del_yn — ENUM('N', 'Y')

Payments

  • record_id — INT — Foreign key → Medical_Records.record_id
  • amount — FLOAT
  • payment_date — DATETIME — NOT NULL
  • payment_method — ENUM('온라인', '오프라인') — NOT NULL
  • del_yn — ENUM('N', 'Y')

Registrations

  • registration_id — INT
  • doctor_id — INT — Foreign key → Doctors.doctor_id — NOT NULL
  • symptom — VARCHAR(255)
  • created_time — TIMESTAMP

Schedules

  • doctor_id — INT — Foreign key → Doctors.doctor_id
  • vacation_date — ENUM( 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday' )
  • del_yn — ENUM('N', 'Y')

Waiting

  • waiting_id — INT
  • doctor_id — INT — Foreign key → Doctors.doctor_id — NOT NULL
  • registration_id — INT — Foreign key → Registrations.registration_id
  • patient_id — INT — Foreign key → Patients.patient_id
  • waiting_count — INT
  • created_time — TIMESTAMP