과제
테이블 (5)
Chart
- ChartID — INT
- ConsultationID — VARCHAR(20)
- DoctorID — INT
- NurseID — INT
- PatientID — INT
- Content — TEXT
Consultation
- ConsultationID — VARCHAR(20)
- DoctorID — INT
- PatientID — INT
- Content — TEXT
- Date — DATE
Doctor
- DoctorID — INT
- Name — VARCHAR(50)
- Gender — CHAR(1)
- Contact — VARCHAR(15)
- Email — VARCHAR(100)
- Rank — VARCHAR(50)
- Specialty — VARCHAR(100)
Nurse
- NurseID — INT
- Name — VARCHAR(50)
- Gender — CHAR(1)
- Phone — VARCHAR(15)
- Email — VARCHAR(100)
- Rank — VARCHAR(50)
- Duty — VARCHAR(100)
Patient
- PatientID — INT
- Name — VARCHAR(50)
- ResidentNumber — CHAR(13)
- Gender — CHAR(1)
- Address — VARCHAR(255)
- Contact — VARCHAR(15)
- Email — VARCHAR(100)
- Job — VARCHAR(50)
- DoctorID — INT
- NurseID — INT