import 테스트

테이블 (12)

DEPARTMENT

  • DEP_CODE — VARCHAR2(4)
  • DEP_NAME — VARCHAR2(100) — NOT NULL

DOCTOR

  • DOC_CODE — NUMBER
  • DOC_NAME — VARCHAR2(50) — NOT NULL
  • DEP_CODE — VARCHAR2(4) — 외래 키 → DEPARTMENT.DEP_CODE — NOT NULL

INPATIENT

  • INP_CODE — NUMBER
  • PAT_CODE — NUMBER — 외래 키 → PATIENT.PAT_CODE — NOT NULL
  • INP_YEAR — VARCHAR2(4) — NOT NULL
  • INP_DATE — VARCHAR2(4) — NOT NULL
  • INP_TIME — VARCHAR2(4) — NOT NULL

PATIENT

  • PAT_CODE — NUMBER
  • PAT_NAME — VARCHAR2(50) — NOT NULL
  • PAT_BIRTH — NUMBER(8) — NOT NULL
  • PAT_GENDER — VARCHAR2(1) — NOT NULL
  • PAT_TEL — VARCHAR2(11)
  • PAT_POSTCODE — VARCHAR2(5)
  • PAT_ADDR1 — VARCHAR2(300)
  • PAT_ADDR2 — VARCHAR2(200)

TREAT

  • TRT_CODE — NUMBER
  • PAT_CODE — NUMBER — 외래 키 → PATIENT.PAT_CODE — NOT NULL
  • TRT_YEAR — VARCHAR2(4) — NOT NULL
  • TRT_DATE — VARCHAR2(4) — NOT NULL
  • TRT_TIME — VARCHAR2(4) — NOT NULL
  • TRT_RECEIPT — VARCHAR2(4) — NOT NULL
  • DOC_CODE — NUMBER — 외래 키 → DOCTOR.DOC_CODE — NOT NULL

board

  • boardno — NUMBER — 기본 키 — NOT NULL
  • title — VARCHAR2(300)
  • content — VARCHAR2(500)
  • insert_dat — DATE
  • update_dat — DATE
  • hit — NUMBER
  • cateno — NUMBER — 외래 키 → board_cate.cateno — NOT NULL
  • userno — NUMBER — 외래 키 → userTb.userno — NOT NULL

board_cate

  • cateno — NUMBER — 기본 키 — NOT NULL
  • cate_name — VARCHAR2(100) — NOT NULL
  • cate_dat — DATE — NOT NULL

commenttb

  • commentno — NUMBER — 기본 키 — NOT NULL
  • content — VARCHAR2(500)
  • insert_dat — DATE
  • boardno — NUMBER — 외래 키 → board.boardno — NOT NULL
  • userno — NUMBER — 외래 키 → userTb.userno — NOT NULL

filetb

  • fileno — NUMBER — 기본 키 — NOT NULL
  • filename — VARCHAR2(100)
  • filepath — VARCHAR2(100)
  • filesize — NUMBER
  • filetype — VARCHAR2(100)
  • boardno — NUMBER — 외래 키 → board.boardno — NOT NULL

grade

  • grade — NUMBER — 기본 키 — NOT NULL
  • gradename — VARCHAR2(100)

report

  • report — NUMBER — 기본 키 — NOT NULL
  • report_dat — DATE — NOT NULL
  • report_reason — VARCHAR2(500) — NOT NULL

userTb

  • userno — NUMBER — 기본 키 — NOT NULL
  • userid — VARCHAR2(500) — NOT NULL
  • userpw — VARCHAR2(500) — NOT NULL
  • gender — VARCHAR2(100)
  • email — VARCHAR2(500)
  • phone — VARCHAR2(500)
  • grade — NUMBER — 외래 키 → grade.grade — NOT NULL
  • report — NUMBER — 외래 키 → report.report — NOT NULL