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