ex1
Tables (5)
Chart
- chartID — number — Primary key — NOT NULL — 차트ID
- doctorID — number — NOT NULL — 의사ID
- nurseID — number — 간호사ID
- patientID — number — NOT NULL — 환자ID
- treatmentID — number — NOT NULL — 진료ID
- content — varchar2 — NOT NULL — 의사소견
- treatmentID (treatmentID2) — number — Foreign key → Treatment.treatmentID — NOT NULL — 진료ID
- nurseID (nurseID2) — number — Foreign key → Nurse.nurseID — NOT NULL — 간호사ID
- patientID (patientID2) — number — Foreign key → Patient.patientID — NOT NULL — 환자ID
Doctor
- doctorID — number — Primary key — NOT NULL — 의사ID
- specialty — varchar2 — NOT NULL — 담당진료과목
- d_name — varchar2 — NOT NULL — 의사이름
- d_phone — varchar2 — 의사연락처
- d_email — varchar2 — NOT NULL — 의사이메일
- d_position — varchar2 — NOT NULL — 의사직급
Nurse
- nurseID — number — Primary key — NOT NULL — 간호사ID
- n_duty — varchar2 — NOT NULL — 담당업무
- n_name — varchar2 — NOT NULL — 간호사이름
- n_gender — varchar2 — NOT NULL — 간호사성별
- n_phone — varchar2 — NOT NULL — 간호사연락처
- n_email — varchar2 — NOT NULL — 간호사이메일
- n_position — varchar2 — NOT NULL — 간호사직급
Patient
- patientID — number — Primary key — NOT NULL — 환자ID
- doctorID — number — NOT NULL — 의사ID
- nurseID — number — 간호사ID
- p_name — varchar2 — NOT NULL — 환자이름
- p_ssn — number(13) — NOT NULL — 환자주민등록번호
- p_gender — varchar2 — NOT NULL — 환자성별
- p_address — varchar2 — 환자주소
- p_phone — varchar2 — 환자연락처
- p_email — varchar2 — 환자이메일
- p_occupation — varchar2 — 환자직업
- doctorID (doctorID2) — number — Foreign key → Doctor.doctorID — NOT NULL — 의사ID
- nurseID (nurseID2) — number — Foreign key → Nurse.nurseID — NOT NULL — 간호사ID
Treatment
- treatmentID — number — Primary key — NOT NULL — 진료ID
- doctorID — number — NOT NULL — 의사ID
- patientID — number — NOT NULL — 환자ID
- c_description — varchar2 — NOT NULL — 진료내용
- c_date — number — NOT NULL — 진료날짜
- doctorID (doctorID2) — number — Foreign key → Doctor.doctorID — NOT NULL — 의사ID