Players System ER Diagram
Use immediately

Players System ER Diagram

Actions

Playerid INT(11)

MatchID INT(11)

TeamlD INT(11)

FirstGoal INT(11)

WinningGoal INT(11)

Shotson Targetincgoals INT(11)

SavesMode INT(11)

TimePlayed INT(11)

PostitionID INT(11)

date DATETIME

Starts INT(11)

SubstituteOn INT(11)

SubstituteOff INT(11)

Goals INT(11)

  ShotsOffTargetincwoodwork INT(11)

BlockedShorts INT(11)

PenaltiesTaken INT(11)

PenaltyGoals INT(11)

PenaltimesSaved INT(11)

PenaltimesOffTarget INT(11)

PenaltimeNotScored INT(11)

DirectFreekickGoals INT(11)

DirectFreekickOnTarget INT(11)

DirectFreekickOffTarget INT(11)

BlockedDirectFreekick INT(11)

GoalsfromlnsideBox INT(11)

ShotsOnfromlnsideBox INT(11)

ShotsOfffromlnsideBox INT(11)

BlockedShotsfromInside Box INT(11)

GoalsfromOutsideBox INT(11)

177 more...

Indexes

Player

PlayerID INT(11)

Name VARCHAR(100)

Indexes

Matches

MatchID INT(11)

Team1HomeID INT(11)

TeamAwayID INT(11)

TeamHomeFormation INT(11)

TeamAwayFormation INT(11)

ResultOfTeamHome INT(11)

Date DATETIME

Indexes

Team

TeamlD INT(11)

Name VARCHAR(40)

Indexes

12
0
0
publish time: 2021-06-04
Captain O Captain

Players System Entity-Relationship (ER) diagram has three main components: entities, attributes, and relationships. Use EdrawMax to create a factually correct player system ER diagram. The below ER diagram has entities like Player, Team, Matches, and Actions. It has attributes like Player_ID, Team_ID, Match_ID, Team_1_Home_ID, Team_Away_ID, Team_Home_Formation, Winning_Goal, Saves_Mode, Time_Played, and others. It should be noted here that entity-relationship diagrams provide a visual starting point for database design that can also be used to help determine information system requirements throughout an organization. These ER diagrams created using EdrawMax can later be shared among your peers to understand players and matches better.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
22
0
0
DILSHAN SACHINDRA