ㄴㄴ

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