popninfo
Tables (3)
chart
- chart_id (Key) — NOT NULL — Primary key — NOT NULL
- song_hash (Field) — NOT NULL
- genre_name (Field2) — NOT NULL
- song_name (Field3) — NOT NULL
- version (Field4) — NOT NULL
- difficulty (Field5) — NOT NULL
- level (Field6) — NOT NULL
- jacket (Field7) — NULL
- is_deleted (Field8) — NOT NULL
- is_upper (Field9) — NOT NULL
playdata (Untitled2)
- playdata_id (Key) — NOT NULL — Primary key — NOT NULL
- user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL
- chart_id (Key2) — NOT NULL — Foreign key → chart.chart_id — NOT NULL
- rank (Field) — NOT NULL
- medal (Field2) — NOT NULL
- score (Field3) — NOT NULL
- pop_class (Field4) — NOT NULL
user (Untitled)
- user_id (Key) — NOT NULL — Primary key — NOT NULL
- user_name (Field) — NOT NULL
- poptomo_id (Field2) — NOT NULL
- pop_class (Field3) — NOT NULL
- character (Field4) — NOT NULL
- comment (Field5) — NULL
- is_hidden (Field6) — NOT NULL
- password (Field7) — NULL
- created_at (Field8) — NOT NULL
- updated_at (Field9) — NOT NULL
- normal_credit (Field10) — NOT NULL
- battle_credit (Field11) — NOT NULL
- local_credit (Field12) — NOT NULL
- role (Field13) — NOT NULL