popnggv2
Tables (8)
account
- account_id — bigint — Primary key
- account_name — varchar(100) — NOT NULL
- poptomo_id — varchar(100) — NOT NULL
- popclass_old — int
- popclass — int — NOT NULL
- chara — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- comment — varchar(255) — archar(255) nul
- is_hidden — int — NOT NULL
- password — varchar(100)
- playcount — int
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- role — varchar(20)
chart
- chart_id — bigint — Primary key — NOT NULL
- song_id — bigint — Foreign key → song.song_id — NOT NULL
- difficulty — int — NOT NULL
- level — int — NOT NULL
- spicy_judgement — int — NOT NULL
- spicy_gauge — int — NOT NULL
history
- history_id — bigint — Primary key — NOT NULL
- chart_id — bigint — Foreign key → chart.chart_id
- account_id — bigint — Foreign key → account.account_id
- rank_code — int
- medal_code — int
- score — int
- popclass — int
- created_at — timestamp
login_log
- login_id — bigint — Primary key
- created_at — timestamp
- poptomo_id — varchar(100)
- password — varchar(100)
- is_succeeded — int
- failure_reason — varchar(200)
- ip — varchar(200)
playdata
- version_playdata_id — bigint — Primary key — NOT NULL
- chart_id — bigint — Foreign key → chart.chart_id
- account_id — bigint — Foreign key → account.account_id
- rank_code — int
- medal_code — int
- score — int
- popclass — int
- created_at — timestamp
- version — int
renew_log
- renew_id — bigint — Primary key
- created_at — timestamp
- poptomo_id — varchar(100)
- is_succeeded — int
- is_register — int
- failure_reason — varchar(200)
- chart_count — int
- ip — varchar(200)
song
- song_id — bigint — Primary key
- song_name — varchar(255)
- genre_name — varchar(255)
- song_hash — varchar(255)
- jacket — varchar(255)
- version — int — NOT NULL
- is_deleted — int — NOT NULL
- is_upper — int — NOT NULL
- created_at — timestamp
song_tag
- song_tag_id — bigint — Primary key — NOT NULL
- song_id — bigint — Foreign key → song.song_id
- tag — varchar(100)