test

Tables (3)

MatchType Status (matchtype_status)

  • Account Number (accountno) — VARCHAR — Foreign key → User.Account Number — NOT NULL
  • Season Type (seasontype) — VARCHAR
  • Match Type (matchtype) — VARCHAR — NOT NULL
  • Match Count (matchcount) — BIGINT — NOT NULL
  • Match Win Count (matchwincount) — BIGINT — NOT NULL
  • First Rank Count (firstrankcount) — BIGINT — NOT NULL
  • In-Third Rank Count (inthirdrankcount) — BIGINT — NOT NULL
  • Rank Sum (ranksum) — BIGINT — NOT NULL
  • Record Time Sum (recordtimesum) — BIGINT — NOT NULL
  • Wall Collision Count (wallcollisioncount) — BIGINT — NOT NULL
  • User Collision Count (usercollisioncount) — BIGINT — NOT NULL
  • Single Boost Count (singleboostcount) — BIGINT — NOT NULL
  • Team Boost Count (teamboostcount) — BIGINT — NOT NULL
  • Record Distance Sum (recorddistancesum) — BIGINT — NOT NULL
  • Item Attack Count (itemattackcount) — BIGINT — NOT NULL
  • Item Attack Success Count (itemattacksuccesscount) — BIGINT — NOT NULL
  • Item Attacked Count (itemattackedcount) — BIGINT — NOT NULL
  • Item Defense Success Count (itemdefensesuccesscount) — BIGINT — NOT NULL

SeasonStatus (season_status)

  • Account Number (accountno) — VARCHAR — Foreign key → User.Account Number — NOT NULL
  • Season Type (seasontype) — VARCHAR
  • Balloon Use Count (balloonusecount) — BIGINT — NOT NULL

User (user)

  • Account Number (accountno) — VARCHAR — Primary key — NOT NULL
  • User Create Date (usercreatedate) — DATETIME — NOT NULL
  • Total Login Time (totallogintime) — BIGINT — NOT NULL