Nfl database mermaid
classDiagram
lu_player "1" -- "N" j_award_received : has
lu_player "1" -- "N" j_player_team : has
lu_player "1" -- "N" j_coach_favorite_player : has
lu_award "1" -- "N" j_award_received : has
lu_team "1" -- "N" d_match : has
lu_team "1" -- "N" lu_coach : has
lu_position "1" -- "N" lu_player : has
lu_team "1" -- "N" lu_player : belongs to
lu_player "0..1" -- "1" lu_coach : has
lu_team "1" -- "N" j_player_team : has
lu_player "1" -- "N" j_player_team : has
lu_coach "1" -- "N" j_coach_favorite_player : has
lu_player "1" -- "N" j_coach_favorite_player : has
d_match "1" -- "N" j_player_team : involves
d_match "1" -- "N" lu_team : home team
d_match "1" -- "N" lu_team : away team
class lu_award{
+bigint id
+String name
+String description
}
class j_award_received{
+int season
+bigint award_id
+bigint player_id
+String notes
}
class lu_coach{
+bigint id
+bigint team_id
+String first_name
+String last_name
}
class lu_player{
+bit franchise_tagged
+bigint id
+bigint team_id
+String first_name
+String last_name
+String position_id
}
class lu_position{
String id
String name
}
class lu_team{
+BOOLEAN active
+String abbreviation
+bigint id
+String color
+String city
+String display_name
+String name
}
class d_match{
+int away_score
+int home_score
+int season
+int week
+bigint away_team_id
+bigint home_team_id
+bigint id
}
class j_player_team{
+bigint player_id
+bigint team_id
}
class j_coach_favorite_player{
+bigint coach_id
+bigint player_id
}