커뮤니티
테이블 (5)
CATEGORY
- category_id — VARCHAR(255) — 기본 키 — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- description — TEXT
COMMENT
- comment_id — VARCHAR(255) — 기본 키 — NOT NULL
- post_id — VARCHAR(255) — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- parent_comment_id — VARCHAR(255)
- content — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- is_deleted — TINYINT(1) — NOT NULL
- report_count — INT — NOT NULL
POST
- post_id — VARCHAR(255) — 기본 키 — NOT NULL
- category_id — VARCHAR(255) — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- title — VARCHAR(200)
- content — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- view_count — INT — NOT NULL
- status — ENUM('PUBLISHED','DRAFT','HIDDEN') — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- report_count — INT — NOT NULL
POST_LIKE
- post_id — VARCHAR(255) — 기본 키 — NOT NULL
- user_id — VARCHAR(255) — 기본 키 — NOT NULL
- created_at — DATETIME — NOT NULL
REPORT
- report_id — VARCHAR(255) — 기본 키 — NOT NULL
- target_type — ENUM('POST','COMMENT','USER') — NOT NULL
- target_id — VARCHAR(255) — NOT NULL
- reporter_id — VARCHAR(255) — NOT NULL
- reason — TEXT
- created_at — DATETIME — NOT NULL
- status — ENUM('OPEN','REVIEWED','DISMISSED') — NOT NULL