SoccerOnline

Tables (5)

Player (PlayerData)

  • PID (PlayerPID) — Int — Primary key — NOT NULL — PK
  • Name (playerName) — String — NOT NULL
  • Ability (playerAbilityATCK) — Int — NOT NULL
  • Ability (playerAbilityDEFEND) — Int — NOT NULL
  • Ability (playerAbilityMOBILITY) — Int — NOT NULL
  • Enchant (playerEnchant) — Int — NOT NULL
  • Price (playerPrice) — Int — NOT NULL

PlayerEquipRosters (PlayerEquipRostersData)

  • PID (playerEquipRostersPID) — Int — Primary key — NOT NULL — PK
  • PID (PlayerRostersPID) — Int — Foreign key → PlayerRosters.PID — NOT NULL — FK
  • PID (playerSquadsPID) — Int — Foreign key → PlayerSquads.PID — NOT NULL — FK
  • PID (userPID) — Int — Foreign key → PlayerSquads.PID — NOT NULL — FK
  • Position (position) — Int — NOT NULL

PlayerRosters (PlayerRostersData)

  • PID (PlayerRostersPID) — Int — Primary key — NOT NULL — PK
  • PID (userPID) — Int — Foreign key → User.PID — NOT NULL — FK
  • PID (PlayerPID) — Int — Foreign key → Player.PID — NOT NULL — FK
  • Enchant (playerEnchant) — String — NOT NULL

PlayerSquads (PlayerSquadsData)

  • PID (playerSquadsPID) — Int — Primary key — NOT NULL — PK
  • PID (userPID) — Int — Foreign key → User.PID — NOT NULL — FK

User (UserData)

  • PID (userPID) — Int — Primary key — NOT NULL — PK
  • ID (userID) — String — NOT NULL
  • Name (userName) — String — NOT NULL
  • Password (userPassword) — String — NOT NULL
  • Score (userScore) — Int — NOT NULL
  • Cash (userCash) — Int — NOT NULL