import test

Tables (7)

board

  • boardno — NUMBER — Primary key — NOT NULL
  • cateno — NUMBER — Foreign key → board_cate.cateno — NOT NULL
  • title — VARCHAR2(1000)
  • content — VARCHAR2(4000)
  • insert_dat — DATE
  • update_dat — DATE
  • hit — NUMBER
  • userno — NUMBER — Foreign key → usertb.userno — NOT NULL

board_cate

  • cateno — NUMBER — Primary key — NOT NULL
  • cate_name — VARCHAR2(200) — NOT NULL
  • cate_date — DATE — NOT NULL

commenttb

  • commentno — NUMBER — Primary key — NOT NULL
  • boardno — NUMBER — Foreign key → board.boardno — NOT NULL
  • userno — NUMBER — Foreign key → usertb.userno — NOT NULL
  • content — VARCHAR2(2000)
  • insert_dat — DATE

filetb

  • fileno — NUMBER — Primary key — NOT NULL
  • boardno — NUMBER — Foreign key → board.boardno — NOT NULL
  • filename — VARCHAR2(1000)
  • filepath — VARCHAR2(2000)
  • filesize — NUMBER
  • filetype — VARCHAR2(50)

grade

  • grade — NUMBER — Primary key — NOT NULL
  • gradename — VARCHAR2(30) — NOT NULL

report

  • report — NUMBER — Primary key — NOT NULL
  • report_dat — DATE — NOT NULL
  • report_reason — VARCHAR2(4000) — NOT NULL

usertb

  • userno — NUMBER — Primary key — NOT NULL
  • userid — VARCHAR2(300) — NOT NULL
  • userpw — VARCHAR2(300) — NOT NULL
  • gender — VARCHAR2(1)
  • email — VARCHAR2(500)
  • phone — VARCHAR2(20)
  • grade — NUMBER — Foreign key → grade.grade
  • report — NUMBER — Foreign key → report.report — NOT NULL