KTB-5주차-과제

테이블 (8)

comment

  • id — BIGINT — 기본 키 — NOT NULL
  • post_id — BIGINT — 외래 키 → post.id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • content — TEXT — NOT NULL
  • edited — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • deleted — BOOLEAN — NOT NULL

edit_revision

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • image_url — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • deleted — BOOLEAN — NOT NULL

member

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • encoded_password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • img_url — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • deleted — BOOLEAN — NOT NULL

post

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — VARCHAR(500)
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • view_count — BIGINT — NOT NULL
  • report_count — BIGINT — NOT NULL
  • edited — BOOLEAN — NOT NULL
  • blinded — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • deleted — BOOLEAN — NOT NULL

post_draft

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • image_url — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • deleted — BOOLEAN — NOT NULL

post_like

  • id — BIGINT — 기본 키 — NOT NULL
  • post_id — BIGINT — 외래 키 → post.id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • deleted — BOOLEAN — NOT NULL

post_view_log

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT
  • post_id — BIGINT
  • viewed_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • deleted — BOOLEAN — NOT NULL

report

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • target_id — BIGINT — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(30) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • deleted — BOOLEAN — NOT NULL