회원

테이블 (7)

board (게시판)

  • boardno (Field) — NUMBER — 기본 키
  • title (Field2) — VARCHAR2
  • content (Field3) — VARCHAR2
  • insert_dat (Field4) — DATE
  • update_dat (Field5) — DATE
  • hit (Field6) — NUMBER
  • userno (Key) — NUMBER — 외래 키 → userTb.userno — NOT NULL
  • cateno (Field7) — NUMBER — 외래 키 → board_cate.cateno

board_cate (게시판 종류)

  • cateno (Field) — NUMBER — 기본 키
  • cate_name (Field2) — VARCHAR2 — NOT NULL
  • cate_dat (Field3) — DATE — NOT NULL

commenttb (댓글)

  • commentno (Field) — NUMBER — 기본 키
  • content (Field2) — VARCHAR2
  • insert_dat (Field3) — DATE
  • boardno (Field4) — NUMBER — 외래 키 → board.boardno
  • userno (Key) — NUMBER — 외래 키 → userTb.userno — NOT NULL

filetb (첨부파일)

  • fileno (Field) — NUMBER — 기본 키
  • filename (Field2) — VARCHAR2
  • filepath (Field3) — VARCHAR2
  • filesize (Field4) — NUMBER
  • filetype (Field5) — VARCHAR2
  • boardno (Field6) — NUMBER — 외래 키 → board.boardno

grade (회원등급)

  • grade (Field) — NUMBER — 기본 키
  • gradename (Field2) — VARCHAR2 — NOT NULL
  • userno (Key) — NUMBER — NOT NULL

report (회원신고)

  • report (Field) — NUMBER — 기본 키
  • report_dat (Field2) — DATE — NOT NULL
  • report_reason (Field3) — VARCHAR2 — NOT NULL

userTb (회원)

  • userno (Key) — NUMBER — 기본 키 — NOT NULL
  • userid (Field) — VARCHAR2 — NOT NULL
  • userpw (Field2) — VARCHAR2 — NOT NULL
  • gender (Field3) — VARCHAR2
  • email (Field4) — VARCHAR2
  • phone (Field5) — VARCHAR2
  • grade (Field6) — NUMBER — 외래 키 → grade.grade
  • report (Field7) — NUMBER — 외래 키 → report.report