Board

Tables (5)

Authority (authority)

  • User ID (userid) — Long — Foreign key → User.User ID — NOT NULL — AUTO_INCREMENT
  • Role (role) — VARCHAR(10)

Board (board)

  • Board ID (boardid) — Long — Primary key — NOT NULL
  • Board name (name) — VARCHAR(20)

Comment (comment)

  • Comment ID (commenid) — Long — Primary key — NOT NULL — AUTO_INCREMENT
  • Post ID (postid) — Long — Foreign key → Post.Post ID — NOT NULL — AUTO_INCREMENT
  • User ID (userid) — Long — Foreign key → User.User ID — NOT NULL — AUTO_INCREMENT
  • Content (content) — VARCHAR(300) — MongoDB Entity
  • Timestamp (timestamp) — Timestamp

Post (post)

  • Post ID (postid) — Long — Primary key — NOT NULL — AUTO_INCREMENT
  • User ID (userid) — Long — Foreign key → User.User ID — NOT NULL — AUTO_INCREMENT
  • Board ID (boardid) — Long — Foreign key → Board.Board ID — NOT NULL
  • Title (title) — VARCHAR(200)
  • Content (content) — LIST — MongoDB Entity
  • Timestamp (timestamp) — Timestamp

User (user)

  • User ID (userid) — Long — Primary key — NOT NULL — AUTO_INCREMENT
  • Nickname (nickname) — VARCHAR(35)
  • Email (email) — VARCHAR(40)
  • Password (password) — VARCHAR(200) — BCrypt
  • Enabled (enabled) — TINYINT