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