BetGether
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 — NOT NULL
- session_id — BIGINT — NOT NULL
- verified_at — DATETIME — NOT NULL
- id (id2) — BIGINT — Foreign key → users.id — NOT NULL
- id (id3) — BIGINT — Foreign key → verification_session.id — 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