커뮤니티

테이블 (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