연습

테이블 (7)

Board

  • boardno — NUMBER — 기본 키 — NOT NULL
  • cateno — NUMBER — 외래 키 → board_cate.cateno — NOT NULL
  • title — VARCHAR2(500)
  • content — VARCHAR2(4000)
  • insert_dat — DATE
  • update_dat — DATE
  • hit — NUMBER
  • 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
  • userno — NUMBER — 외래 키 → userTb.userno — NOT NULL
  • boardno — NUMBER — 외래 키 → Board.boardno — NOT NULL
  • content — VARCHAR2(4000)
  • insert_dat — DATE

filetb

  • fileno — NUMBER — 기본 키 — NOT NULL
  • boardno — NUMBER — 외래 키 → Board.boardno — NOT NULL
  • filename — VARCHAR2(500)
  • filepathV — VARCHAR2(1000)
  • filesize — NUMBER
  • filetype — VARCHAR2(50)

grade

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

report

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

userTb

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