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