게시판
테이블 (3)
Post
- id — BIGINT — 기본 키 — NOT NULL
- title — varchar
- content — varchar
- created date (created_date) — DATETIME
- modified date (modified_date) — DATETIME
- removed date (removed_dat3e) — DATETIME
- id (user_id) — BIGINT — 외래 키 → User.id — NOT NULL
Untitled (Comment)
- Key (id) — BIGINT — 기본 키 — NOT NULL
- Field (content) — varchar
- Field (created_date) — DATETIME
- Field (modified_date) — DATETIME
- Field (removed_date) — DATETIME
- Field
- id (post_id) — BIGINT — 외래 키 → Post.id — NOT NULL
- id (user_id) — BIGINT — 외래 키 → User.id — NOT NULL
User
- id — BIGINT — 기본 키 — NOT NULL
- user id (user_id) — varchar
- password — varchar
- created date (created_date) — DATETIME
- modified date (modified_date) — DATETIME
- removed date (removed_dat3e) — DATETIME
- role — varchar