BackendProject
Tables (8)
decoration_entity
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(255)
- name — VARCHAR(255)
- price — INT
game_log_entity
- id — BIGINT — Primary key — NOT NULL
- game_type — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- bet — INT — NOT NULL
- payout — INT — NOT NULL
- result — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
member_decoration_entity
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member_entity.id — NOT NULL
- decoration_id — BIGINT — Foreign key → decoration_entity.id — NOT NULL
- bought_at — DATETIME(6)
member_entity
- id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(255)
- point — INT — NOT NULL
- role — VARCHAR(255) — NOT NULL
- equipped_title_id — BIGINT — NOT NULL
- equipped_decoration_id — BIGINT — NOT NULL
member_stats_entity
- id — BIGINT — Foreign key → member_entity.id — NOT NULL
- chicken_wins — INT
- chicken_losses — INT
- chicken_win_streak — INT
- chicken_lose_streak — INT
- chicken_high_cashout_streak — INT
- chicken_total_loss — INT
- tic_wins — INT
- tic_losses — INT
- tic_draws — INT
- tic_win_streak — INT
- tic_lose_streak — INT
- tic_bully_wins — INT
- roulette_plays — INT
- roulette_daily_count — INT
- roulette_daily_date — DATE
- relief_count — INT
- relief_last_date — DATE
member_title_entity
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member_entity.id — NOT NULL
- title_id — BIGINT — Foreign key → title_entity.id — NOT NULL
- unlocked_at — DATETIME(6)
- notified — TINYINT(1) — NOT NULL
roulette_entity
- id — BIGINT — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → member_entity.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- items — VARCHAR(255)
- shared — TINYINT(1)
title_entity
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(255)
- name — VARCHAR(255)
- description — VARCHAR(255)