BetGether ERD

Tables (5)

chat_message

  • id — BIGINT — Primary key — NOT NULL
  • gether_id — BIGINT — Foreign key → gether.id — NOT NULL
  • sender_id — BIGINT — Foreign key → user.id — NOT NULL
  • content — TEXT — NOT NULL
  • type — VARCHAR(20) — NOT NULL — TALK, VERIFY_START
  • created_at — DATETIME — NOT NULL

gether

  • id — BIGINT — Primary key — NOT NULL
  • host_id — BIGINT — Foreign key → user.id — NOT NULL — 방장 유저 ID
  • 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

participation

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

user

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

verification_log

  • id — BIGINT — Primary key — NOT NULL
  • gether_id — BIGINT — Foreign key → gether.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • point_earned — INT — NOT NULL
  • created_at — DATETIME — NOT NULL