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