MediCompile_최종
테이블 (15)
banner
- banner_idx — NUMBER(10) — NOT NULL
- banner_name — VARCHAR2(100)
- banner_file — VARCHAR2(200)
- banner_chk — NUMBER(3)
calling
- calling_idx — NUMBER(10) — NOT NULL
- calling_name — VARCHAR2(100)
- calling_tel — VARCHAR2(200)
- calling_chk — NUMBER(3)
department
- dept_idx — NUMBER(10)
- dept_name — VARCHAR2(100)
- dept_payment — NUMBER(10)
- dept_loc — VARCHAR2(20)
- dept_category — VARCHAR2(20)
device
- dev_idx — NUMBER(3)
- dev_name — VARCHAR2(100)
- dev_content — CLOB
- dev_filename — VARCHAR2(200)
floor
- floor_idx — NUMBER(10)
- floor_name — VARCHAR2(300) — NOT NULL
- floor_info — NUMBER(10) — NOT NULL
illness
- ill_idx — NUMBER(3)
- ill_name — VARCHAR2(50)
- ill_des — CLOB
notice
- not_idx — NUMBER(3)
- not_title — VARCHAR2(300)
- not_content — CLOB
- not_date — DATE
- not_hits — NUMBER(9)
- not_file — VARCHAR2(200) — NOT NULL
patBoard
- board_idx — NUMBER(10)
- pat_idx — NUMBER(3) — 외래 키 → patient.pat_idx — NOT NULL
- board_title — VARCHAR2(300)
- board_content — CLOB
- board_file — VARCHAR2(200)
- board_email — VARCHAR2(200)
- board_phone — VARCHAR2(20)
- board_type — VARCHAR2(100)
- board_date — DATE
- board_name — VARCHAR2(30)
patient
- pat_idx — NUMBER(3)
- pat_name — VARCHAR2(30)
- pat_id — VARCHAR2(100)
- pat_pwd — VARCHAR2(100)
- pat_email — VARCHAR2(200)
- pat_address_post — NUMBER(10)
- pat_address_road — VARCHAR2(100)
- pat_address_detail — VARCHAR2(100)
- pat_phone — VARCHAR2(20)
- pat_phone2 — VARCHAR2(20) — NOT NULL
- pat_birthday — DATE
- pat_gender — VARCHAR2(10)
professor
- pro_idx — NUMBER(3)
- dept_idx — NUMBER(10) — 외래 키 → department.dept_idx
- pro_name — VARCHAR2(30)
- pro_field — CLOB
- pro_file — VARCHAR2(200)
reservation
- res_idx — NUMBER(4) — NOT NULL
- pat_idx — NUMBER(3) — 외래 키 → patient.pat_idx
- pro_idx — NUMBER(3) — 외래 키 → professor.pro_idx
- res_time — DATE
- res_chk — NUMBER(1)
- pay_chk — NUMBER(1)
- contact — VARCHAR2(20)
schedule
- pro_idx — NUMBER(10) — 기본 키 — NOT NULL
- weekday — NUMBER(1) — 기본 키 — NOT NULL
volcomment
- comm_idx — NUMBER(3)
- vol_idx — NUMBER(3) — 외래 키 → volunteer.vol_idx
- comm_content — CLOB
- comm_date — DATE
- pat_idx — NUMBER(3) — 외래 키 → patient.pat_idx
- comm_name — VARCHAR2(30)
volreply
- reply_idx — NUMBER(3)
- vol_idx — NUMBER(3)
- comm_idx — NUMBER(3)
- reply_content — CLOB
- reply_date — DATE
- pat_idx — NUMBER(3)
- reply_name — VARCHAR2(30)
volunteer
- vol_idx — NUMBER(3)
- vol_title — VARCHAR2(300)
- vol_content — CLOB
- vol_date — DATE
- vol_hits — NUMBER(9)
- vol_file — VARCHAR2(200)
- ref — NUMBER(3)
- step — NUMBER(2)
- depth — NUMBER(3)
- vol_start_date — DATE
- vol_end_date — DATE