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)