답정너 db 구조

테이블 (6)

Post

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → User.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('active', 'closed')
  • image_url — VARCHAR(255)
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • view_count

Reaction

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → User.id — NOT NULL
  • created_at — TIMESTAMP
  • post_id — BIGINT — 외래 키 → Post.id — NOT NULL
  • emoji_id — BIGINT — 외래 키 → emoji.id — NOT NULL

User

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Vote

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → User.id — NOT NULL
  • post_id — BIGINT — 외래 키 → Post.id — NOT NULL
  • vote_option_ids — BIGINT — 외래 키 → VoteOption.id — NOT NULL
  • created_at — TIMESTAMP

VoteOption

  • id — BIGINT — 기본 키 — NOT NULL
  • option_text — VARCHAR(255) — NOT NULL
  • vote_count — INT
  • created_at — TIMESTAMP
  • post_id — BIGINT — 외래 키 → Post.id — NOT NULL

emoji

  • id — BIGINT — 기본 키 — NOT NULL
  • content