fakeJumpingBattle

Tables (6)

admin_user

  • id — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • store_id — BIGINT — Foreign key → store.id — 스토어 아이디 설정하기

map

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • is_active — BOOLEAN DEFAULT TRUE
  • created_at — DATETIME
  • description (descrption) — VARCHAR(150)
  • size — ENUM
  • difficulty (dificulty) — ENUM
  • order_num — INT NOT NULL

match_log

  • id — BIGINT — Primary key — NOT NULL
  • uuid — VARCHAR(36) — NOT NULL — 외부 노출용 UUID
  • created_at — DATETIME — NOT NULL — 플레이 생성 시각
  • score — INT — NOT NULL — 플레이 점수
  • store_id — BIGINT — Foreign key → store.id — NOT NULL
  • player_id — BIGINT — Foreign key → player.id — NOT NULL
  • map_id — BIGINT — Foreign key → map.id — NOT NULL
  • season_id — BIGINT — Foreign key → seasons.id — NOT NULL

player (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • Field
  • store_id — BIGINT — Foreign key → store.id — NOT NULL

seasons (Untitled2)

  • id — BIGINT — Primary key — NOT NULL
  • created_by — BIGINT — Foreign key → admin_user.id — NOT NULL
  • name — VARCHAR(100)
  • created_date — DATETIME
  • start_date — DATETIME
  • end_date — DATETIEME

store

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(100)
  • address — VARCHAR(255)
  • created_at — DATETIME — NOT NULL