runners

테이블 (3)

users

  • id — bigint — 기본 키 — NOT NULL
  • email — varchar(320) — NOT NULL
  • google_sub — varchar(64) — NOT NULL
  • name — varchar(100)
  • picture — varchar(500)
  • role — varchar(50) — NOT NULL

게시글 조회 (community_post_views)

  • viewed_date — date — 기본 키 — NOT NULL
  • post_id — bigint — 외래 키 — NOT NULL
  • user_id — bigint — 외래 키 → users.id — NOT NULL
  • viewed_at — datetime(6) — NOT NULL

댓글 (community_comments)

  • id — BIGINT — 기본 키 — NOT NULL
  • post_id — BIGINT — 외래 키 — NOT NULL
  • author_id — bigint — 외래 키 → users.id — NOT NULL
  • parent_id — bigint — 외래 키 → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('ACTIVE','DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME