BetGether ERD

Tables (8)

challenge

  • id — BIGINT — Primary key — NOT NULL
  • gether_id — BIGINT — Foreign key → gether.id — NOT NULL
  • title — VARCHAR(20) — NOT NULL
  • bet_point — INT — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_message

  • id — BIGINT — Primary key — NOT NULL
  • gether_id — BIGINT — Foreign key → gether.id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

gether

  • id — BIGINT — Primary key — NOT NULL
  • host_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • image_url — VARCHAR(255)
  • invite_code — VARCHAR(10) — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

participation

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • gether_id — BIGINT — Foreign key → gether.id — NOT NULL
  • joined_at — DATETIME — NOT NULL

point_transaction

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • session_id — BIGINT — Foreign key → verification_session.id — NOT NULL
  • amount — INT — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

users

  • id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • point — INT — NOT NULL
  • last_login — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

verification_log

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • session_id — BIGINT — Foreign key → verification_session.id — NOT NULL
  • verified_at — DATETIME — NOT NULL

verification_session

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL — 방장 ID
  • gether_id — BIGINT — NOT NULL
  • challenge_id — BIGINT — Foreign key → challenge.id — NOT NULL
  • token — VARCHAR(64) — NOT NULL
  • bet_point — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — ACTIVE, EXPIRED, CLOSED
  • created_at — DATETIME — NOT NULL
  • expired_at — DATETIME — NOT NULL