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
  }