Hospital_Reservation_Management_System

Tables (3)

Doctor (의사)

  • 의사번호 (doctor_num) — VARCHAR2(6) — Primary key — NOT NULL — PRIMARY KEY
  • 비밀번호 (doctor_pwd) — VARCHAR2(20) — NOT NULL
  • 이름 (doctor_name) — VARCHAR2(8 CHAR) — NOT NULL
  • 전공 (doctor_major) — VARCHAR2(5 CHAR) — NOT NULL

Patient (일반회원)

  • 주민등록번호 (identity_num) — VARCHAR2(14) — Primary key — NOT NULL — PRIMARY KEY
  • 아이디 (patient_id) — VARCHAR2(8) — NOT NULL — UNIQUE
  • 비밀번호 (patient_pwd) — VARCHAR2(20) — NOT NULL
  • 이름 (patient_name) — VARCHAR2(8 CHAR) — NOT NULL
  • 나이 (patient_age) — NUMBER(3) — NOT NULL
  • 성별 (patient_gender) — VARCHAR2(1) — NOT NULL — CHECK IN('M','F')
  • 휴대전화번호 (patient_phone) — VARCHAR2(13) — NOT NULL
  • 가입날짜 (created_at) — VARCHAR2(19) — NOT NULL — YYYY-MM-DD HH24:MI:SS

Reservation (예약)

  • 예약날짜 (reserv_date) — VARCHAR2(10) — Primary key — NOT NULL — PRIMARY KEY YYYY.MM.DD
  • 예약시간 (reserv_time) — VARCHAR2(5) — Primary key — NOT NULL — PRIMARY KEY HH:MM
  • 주민등록번호 (identity_num) — VARCHAR2(14) — Foreign key → Patient.주민등록번호 — NOT NULL — FOREIGN KEY
  • 의사번호 (doctor_num) — VARCHAR2(6) — Foreign key → Doctor.의사번호 — NOT NULL — PRIMARY KEY FOREIGN KEY
  • 진료여부 (medical_check) — VARCHAR2(1) — NOT NULL — CHECK IN('Y','N') DEFAULT 'N'
  • 증상메모 (symptoms_memo) — VARCHAR2(50) — DEFAULT ''
  • 취소사유 (cancel_reason) — VARCHAR2(50) — DEFAULT ''