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