Game Player Management ER Diagram
Use immediately

Game Player Management ER Diagram

users

uid INTEGER

users_bets

uid INTEGER

match_id INTEGER

outcome ENUM ('1',X',2)

matches

match_id INTEGER

date DATETIME

team_id_home INTEGER

team_id_away INTEGER

score_home INTEGER

score_away INTEGER

teams

team_id INTEGER

name VARCHAR(255)

Players

team_id INTEGER

Player_id INTEGER

name VARCHAR(255)

Postition ENUM('GK','DF','MF','FW')

6
0
0
publish time: 2021-06-04
easy diagrams

Game Player management entity-relationship (ER) diagram has entities like users, users_bets, matches, team, and players. It should be noted here that entity-relationship diagrams are used to analyze the structure of the database. It shows relationships between entities and their attributes. These entities have attributes like team_id, Player_id, name VARCHAR, Position ENUM, team_id, match_id, date, team_id_home, team_id_away, score_home, u_id INTEGER, and match_id INTEGER. As shown in the below image, the ER diagram is a graphical representation of an ER model. It is currently one of the most popular and widely used database design tools. As stated above, the three main components of the entity-relationship model are entities, attributes, and relationships.

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