FREEBOARD

테이블 (6)

게시글 (TBL_BOARD)

  • bno — number(10,0) — 기본 키 — NOT NULL
  • mid — varchar2(255) — 외래 키 → 카테고리.mid — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — varchar2(2000) — NOT NULL
  • writer — varchar2(50) — NOT NULL
  • regDate (regdate) — date
  • updateDate (updatedate) — date
  • replyCnt (replycnt) — number

댓글 (TBL_REPLY)

  • rno — number(10,0) — 기본 키 — NOT NULL
  • bno — number(10,0) — 외래 키 → 게시글.bno — NOT NULL
  • reply — varchar2(1000) — NOT NULL
  • replyer — varchar2(50) — NOT NULL
  • replyDate (replydate) — date
  • updateDate (updatedate) — date

멤버 (TBL_MEMBER)

  • userID (userid) — varchar2(50) — 기본 키 — NOT NULL
  • userPW (userpw) — varchar2(100) — NOT NULL
  • userName (username) — varchar2(100) — NOT NULL
  • regDate (regdate) — date
  • updateDate (updatedate) — date
  • enabled — char(1)

멤버 권한 (TBL_MEMBER_AUTH)

  • userID (userid) — varchar2(50) — 외래 키 → 멤버.userID — NOT NULL
  • auth — varchar2(50) — NOT NULL

첨부파일 (TBL_ATTACH)

  • uuid — varchar2(100) — 기본 키 — NOT NULL
  • bno — number(10,0) — 외래 키 → 게시글.bno — NOT NULL
  • uploadPath (uploadpath) — varchar2(200) — NOT NULL
  • fileName (filename) — varchar2(100)
  • fileType (filetype) — char(1)

카테고리 (TBL_MENU_CATEGORY)

  • mid — varchar2(255) — 기본 키 — NOT NULL
  • name — varchar2(255) — NOT NULL
  • parent — varchar2(255)
  • Field (morder) — number