Board
Tables (3)
COMMENT (comment)
- COMMENT_ID (comment_id) — Long — Primary key — NOT NULL
- CONTENT (content) — VARCHAR(255)
- GOOD (good) — INT
- POST_ID (post_id) — Long — Foreign key → POST.POST_ID — NOT NULL
- USERS_ID (users_id) — Long — Foreign key → USERS.USERS_ID — NOT NULL
POST (post)
- POST_ID (post_id) — Long — Primary key — NOT NULL
- TITLE (title) — VARCHAR(255)
- CONTENTS (contents) — VARCHAR(255)
- GOOD (good) — INT
- USERS_ID (users_id) — Long — Foreign key → USERS.USERS_ID — NOT NULL
USERS (users)
- USERS_ID (users_id) — Long — Primary key — NOT NULL
- USERNAME (username) — VARCHAR(10)
- PASSWORD (password) — VARCHAR(15)
- ROLE (role) — VARCHAR(255)