ㄴㄴ
Tables (5)
COMMENT
- comment_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- parent_comment_id — BIGINT
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
POST
- post_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- view_count — INT — NOT NULL
- like_count — INT — NOT NULL
POST_CATEGORY
- category_id — BIGINT — Primary key — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- description — TEXT
POST_LIKE
- post_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
- is_liked — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
POST_REPORT
- report_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- reason — VARCHAR(255)
- status — ENUM('OPEN','REVIEWED','DISMISSED') — NOT NULL
- created_at — DATETIME — NOT NULL