justboard
Tables (7)
Board (board)
- id (board_id) — Long — Primary key — NOT NULL
- categoryId (category_id) — Long — Foreign key → Category.id — NOT NULL
- member (member_id) — Long — Foreign key → Member.id — NOT NULL — 게시판 작성자
- boardName (board_name) — String — NOT NULL
Category (category)
- id (category_id) — Long — Primary key — NOT NULL
- name — String — NOT NULL
- depth — int — NOT NULL — 계층형 구조
- parent (parent_id) — Long — Foreign key → Category.id — NOT NULL — 부모id
- child (child_id) — Long — Foreign key → Category.id — NOT NULL — 자식id
ChatRoom (chatroom)
- id (chatroom_id) — Long — Primary key — NOT NULL
- board (board_id) — Long — Foreign key → Board.id — NOT NULL
- category (category_id) — Long — Foreign key → Board.categoryId — NOT NULL
- member (member_id) — Long — Foreign key → Member.id — NOT NULL
- content — String — NOT NULL
Comment (comment)
- id (comment_id) — Long — Primary key — NOT NULL
- id (post_id) — Long — Foreign key → Post.id — NOT NULL
- member (member_id) — Long — Foreign key → Post.member — NOT NULL — 글 작성자
- board (board_id) — Long — Foreign key → Post.board — NOT NULL — 속한 게시판
- categoryId (category_id) — Long — Foreign key → Post.categoryId — NOT NULL — 게시판이 속한 카테고리
- content — String — NOT NULL
- depth — NOT NULL — 계층형 구조
- parent (parent_id) — Long — Foreign key → Comment.id — NOT NULL — 부모 id
- child (child_id) — Long — Foreign key → Comment.id — NOT NULL — 자식 id
Image
- id (image_id) — Long — Primary key — NOT NULL
- id (post_id) — Long — Foreign key → Post.id — NOT NULL
- member (member_id) — Long — Foreign key → Post.member — NOT NULL — 글 작성자
- board (board_id) — Long — Foreign key → Post.board — NOT NULL — 속한 게시판
- categoryId (category_id) — Long — Foreign key → Post.categoryId — NOT NULL — 게시판이 속한 카테고리
- url — String — NOT NULL
Member (member)
- id (member_id) — Long — Primary key — NOT NULL
- markMember (mark_member_id) — Long — Foreign key → Member.id — NOT NULL
- username (usernmae) — String — NOT NULL — 이메일 형식 아이디
- password — String — NOT NULL
- nickname — String — NOT NULL — 닉네임
- role — ENUM — NOT NULL — 역할
- grade — ENUM — NOT NULL — 유저 등급
Post (post)
- id (post_id) — Long — Primary key — NOT NULL
- member (member_id) — Long — Foreign key → Member.id — NOT NULL — 글 작성자
- board (board_id) — Long — Foreign key → Board.id — NOT NULL — 속한 게시판
- categoryId (category_id) — Long — Foreign key → Board.categoryId — NOT NULL — 게시판이 속한 카테고리
- title — String — NOT NULL
- content — String — NOT NULL
- like — long