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