KH 3조

테이블 (7)

board

  • boardno — NUMBER — NOT NULL
  • titile — VARCHAR2(30)
  • content — VARCHAR2(50)
  • insert_dat — DATE
  • update_dat — DATE
  • hit — NUMBER
  • cateno — NUMBER — NOT NULL
  • userno — NUMBER — NOT NULL

board_cate

  • cateno — NUMBER — NOT NULL
  • cate_name — VARCHAR2(20)
  • cate_dat — DATE

commenttb

  • commentno — NUMBER — NOT NULL
  • content — VARCHAR2(50)
  • insert_date — DATE
  • boardno — NUMBER — NOT NULL
  • userno — NUMBER — NOT NULL

filetb

  • fileno — NUMBER — NOT NULL
  • filename — VARCHAR2(20)
  • filepath — VARCHAR2(30)
  • filesize — NUMBER
  • filetype — VARCHAR2(10)
  • boardno — NUMBER — NOT NULL

grade

  • grade — NUMBER — NOT NULL
  • gradename — VARCHAR2(10) — NOT NULL

report

  • report — NUMBER — NOT NULL
  • report_dat — DATE — NOT NULL
  • report_reason — VARCHAR2(50) — NOT NULL

userTb

  • userno — NUMBER — NOT NULL
  • userid — VARCHAR2(20) — NOT NULL
  • userpw — VARCHAR2(20) — NOT NULL
  • gender — VARCHAR2(5)
  • email — VARCHAR2(20)
  • phone — VARCHAR2(10)
  • grade — NUMBER — NOT NULL
  • report — NUMBER — NOT NULL