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