ㅇㄹ
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
- 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 — Foreign key → Medical_Records.record_id — NOT NULL
- rating — int
- feedback_text — VARCHAR(255)
- del_yn — enum('N', 'Y')
Manager
- manager_id — INT
- 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
- 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