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