병원예약시스템
테이블 (9)
Appointment
- appointment_id — INT
- patient_id — INT
- doctor_id — INT
- appointment_date — DATE — NOT NULL
- appointment_time — TIME — NOT NULL
- status — VARCHAR(20)
Doctor
- doctor_id — INT
- name — VARCHAR(50) — NOT NULL
- specialty — VARCHAR(50)
- hospital — VARCHAR(100)
- phone — VARCHAR(15)
MedicalRecord
- record_id — INT
- patient_id — INT
- doctor_id — INT
- visit_date — DATE — NOT NULL
- diagnosis — TEXT
- prescription — TEXT
Patient
- patient_id — INT
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- phone — VARCHAR(15)
- email — VARCHAR(100)
- registration_date — DATE
course
- cno — INT
- cname — VARCHAR(50)
- dname — VARCHAR(50)
professor
- pno — INT
- pname — VARCHAR(50)
- salary — INT
- dname — VARCHAR(50)
student
- sno — INT
- sname — VARCHAR(50)
- eyear — INT
- dname — VARCHAR(50)
take_course
- sno — INT
- cno — INT
- pno — INT
teach_course
- pno — INT
- cno — INT
- dname — VARCHAR(50)
- term — INT
- year — INT