커뮤
테이블 (4)
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