test
Tables (5)
BOARD
- board_id — INT
- board_name — VARCHAR(50) — NOT NULL
- description — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
MEMBER
- member_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
POST
- post_id — INT
- board_id — INT — Foreign key → BOARD.board_id — NOT NULL
- member_id — INT — Foreign key → MEMBER.member_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT — NOT NULL
- is_deleted — CHAR(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
POST_COMMENT
- comment_id — INT
- post_id — INT — Foreign key → POST.post_id — NOT NULL
- member_id — INT — Foreign key → MEMBER.member_id — NOT NULL
- parent_comment_id — INT
- content — VARCHAR(1000) — NOT NULL
- is_deleted — CHAR(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
POST_LIKE
- member_id — INT — Foreign key → MEMBER.member_id — NOT NULL
- post_id — INT — Foreign key → POST.post_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL