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