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 ''