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)