<?xml version="1.0" encoding="iso-8859-1" standalone="yes"?>
<edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">
  <edmx:DataServices xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:DataServiceVersion="1.0">
    <Schema Namespace="BaseballStatsModel" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
      <EntityType Name="Appearance">
        <Key>
          <PropertyRef Name="yearID" />
          <PropertyRef Name="teamID" />
          <PropertyRef Name="lgID" />
          <PropertyRef Name="playerID" />
        </Key>
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="teamID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="G_all" Type="Edm.Int16" Nullable="true" />
        <Property Name="GS" Type="Edm.Int32" Nullable="true" />
        <Property Name="G_batting" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_defense" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_p" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_c" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_1b" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_2b" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_3b" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_ss" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_lf" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_cf" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_rf" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_of" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_dh" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_ph" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_pr" Type="Edm.Int16" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_Appearances_Player" FromRole="Appearance" ToRole="Player" />
        <NavigationProperty Name="Team" Relationship="BaseballStatsModel.FK_Appearances_Teams" FromRole="Appearance" ToRole="Team" />
      </EntityType>
      <EntityType Name="AwardPlayer">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="awardID" />
          <PropertyRef Name="yearID" />
          <PropertyRef Name="lgID" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="awardID" Type="Edm.String" Nullable="false" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="tie" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="notes" Type="Edm.String" Nullable="true" MaxLength="100" Unicode="true" FixedLength="false" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_AwardsPlayers_Player" FromRole="AwardPlayer" ToRole="Player" />
      </EntityType>
      <EntityType Name="AwardSharePlayer">
        <Key>
          <PropertyRef Name="awardID" />
          <PropertyRef Name="yearID" />
          <PropertyRef Name="lgID" />
          <PropertyRef Name="playerID" />
        </Key>
        <Property Name="awardID" Type="Edm.String" Nullable="false" MaxLength="25" Unicode="true" FixedLength="false" />
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="pointsWon" Type="Edm.Double" Nullable="true" />
        <Property Name="pointsMax" Type="Edm.Int16" Nullable="true" />
        <Property Name="votesFirst" Type="Edm.Double" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_AwardsSharePlayers_Player" FromRole="AwardSharePlayer" ToRole="Player" />
      </EntityType>
      <EntityType Name="Batting">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="yearID" />
          <PropertyRef Name="stint" />
          <PropertyRef Name="teamID" />
          <PropertyRef Name="lgID" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="stint" Type="Edm.Int16" Nullable="false" />
        <Property Name="teamID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="G" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_batting" Type="Edm.Int16" Nullable="true" />
        <Property Name="AB" Type="Edm.Int16" Nullable="true" />
        <Property Name="R" Type="Edm.Int16" Nullable="true" />
        <Property Name="H" Type="Edm.Int16" Nullable="true" />
        <Property Name="Dbl" Type="Edm.Int16" Nullable="true" />
        <Property Name="Tpl" Type="Edm.Int16" Nullable="true" />
        <Property Name="HR" Type="Edm.Int16" Nullable="true" />
        <Property Name="RBI" Type="Edm.Int16" Nullable="true" />
        <Property Name="SB" Type="Edm.Int16" Nullable="true" />
        <Property Name="CS" Type="Edm.Int16" Nullable="true" />
        <Property Name="BB" Type="Edm.Int16" Nullable="true" />
        <Property Name="SO" Type="Edm.Int16" Nullable="true" />
        <Property Name="IBB" Type="Edm.Int16" Nullable="true" />
        <Property Name="HBP" Type="Edm.Int16" Nullable="true" />
        <Property Name="SH" Type="Edm.Int16" Nullable="true" />
        <Property Name="SF" Type="Edm.Int16" Nullable="true" />
        <Property Name="GIDP" Type="Edm.Int16" Nullable="true" />
        <Property Name="G_old" Type="Edm.Int16" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_Batting_Player" FromRole="Batting" ToRole="Player" />
        <NavigationProperty Name="Team" Relationship="BaseballStatsModel.FK_Batting_Teams" FromRole="Batting" ToRole="Team" />
      </EntityType>
      <EntityType Name="BattingPost">
        <Key>
          <PropertyRef Name="yearID" />
          <PropertyRef Name="round" />
          <PropertyRef Name="playerID" />
          <PropertyRef Name="teamID" />
          <PropertyRef Name="lgID" />
        </Key>
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="round" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="teamID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="G" Type="Edm.Int16" Nullable="true" />
        <Property Name="AB" Type="Edm.Int16" Nullable="true" />
        <Property Name="R" Type="Edm.Int16" Nullable="true" />
        <Property Name="H" Type="Edm.Int16" Nullable="true" />
        <Property Name="Dbl" Type="Edm.Int16" Nullable="true" />
        <Property Name="Tpl" Type="Edm.Int16" Nullable="true" />
        <Property Name="HR" Type="Edm.Int16" Nullable="true" />
        <Property Name="RBI" Type="Edm.Int16" Nullable="true" />
        <Property Name="SB" Type="Edm.Int16" Nullable="true" />
        <Property Name="CS" Type="Edm.Int16" Nullable="true" />
        <Property Name="BB" Type="Edm.Int16" Nullable="true" />
        <Property Name="SO" Type="Edm.Int16" Nullable="true" />
        <Property Name="IBB" Type="Edm.Int16" Nullable="true" />
        <Property Name="HBP" Type="Edm.Int16" Nullable="true" />
        <Property Name="SH" Type="Edm.Int16" Nullable="true" />
        <Property Name="SF" Type="Edm.Int16" Nullable="true" />
        <Property Name="GIDP" Type="Edm.Int16" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_BattingPost_Player" FromRole="BattingPost" ToRole="Player" />
        <NavigationProperty Name="Team" Relationship="BaseballStatsModel.FK_BattingPost_Teams" FromRole="BattingPost" ToRole="Team" />
      </EntityType>
      <EntityType Name="Fielding">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="yearID" />
          <PropertyRef Name="stint" />
          <PropertyRef Name="teamID" />
          <PropertyRef Name="lgID" />
          <PropertyRef Name="POS" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="stint" Type="Edm.Int16" Nullable="false" />
        <Property Name="teamID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="POS" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="G" Type="Edm.Int16" Nullable="true" />
        <Property Name="GS" Type="Edm.Int16" Nullable="true" />
        <Property Name="InnOuts" Type="Edm.Int16" Nullable="true" />
        <Property Name="PO" Type="Edm.Int16" Nullable="true" />
        <Property Name="A" Type="Edm.Int16" Nullable="true" />
        <Property Name="E" Type="Edm.Int16" Nullable="true" />
        <Property Name="DP" Type="Edm.Int16" Nullable="true" />
        <Property Name="PB" Type="Edm.Int16" Nullable="true" />
        <Property Name="WP" Type="Edm.Int16" Nullable="true" />
        <Property Name="SB" Type="Edm.Int16" Nullable="true" />
        <Property Name="CS" Type="Edm.Int16" Nullable="true" />
        <Property Name="ZR" Type="Edm.Double" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_Fielding_Player" FromRole="Fielding" ToRole="Player" />
        <NavigationProperty Name="Team" Relationship="BaseballStatsModel.FK_Fielding_Teams" FromRole="Fielding" ToRole="Team" />
      </EntityType>
      <EntityType Name="FieldingOF">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="yearID" />
          <PropertyRef Name="stint" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="stint" Type="Edm.Int16" Nullable="false" />
        <Property Name="Glf" Type="Edm.Int16" Nullable="true" />
        <Property Name="Gcf" Type="Edm.Int16" Nullable="true" />
        <Property Name="Grf" Type="Edm.Int16" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_FieldingOF_Player" FromRole="FieldingOF" ToRole="Player" />
      </EntityType>
      <EntityType Name="FieldingPost">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="yearID" />
          <PropertyRef Name="teamID" />
          <PropertyRef Name="lgID" />
          <PropertyRef Name="round" />
          <PropertyRef Name="POS" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="teamID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="round" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="POS" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="G" Type="Edm.Int16" Nullable="true" />
        <Property Name="GS" Type="Edm.Int16" Nullable="true" />
        <Property Name="InnOuts" Type="Edm.Int16" Nullable="true" />
        <Property Name="PO" Type="Edm.Int16" Nullable="true" />
        <Property Name="A" Type="Edm.Int16" Nullable="true" />
        <Property Name="E" Type="Edm.Int16" Nullable="true" />
        <Property Name="DP" Type="Edm.Int16" Nullable="true" />
        <Property Name="TP" Type="Edm.Int16" Nullable="true" />
        <Property Name="PB" Type="Edm.Int16" Nullable="true" />
        <Property Name="SB" Type="Edm.Int16" Nullable="true" />
        <Property Name="CS" Type="Edm.Int16" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_FieldingPost_Player" FromRole="FieldingPost" ToRole="Player" />
        <NavigationProperty Name="Team" Relationship="BaseballStatsModel.FK_FieldingPost_Teams" FromRole="FieldingPost" ToRole="Team" />
      </EntityType>
      <EntityType Name="Pitching">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="yearID" />
          <PropertyRef Name="stint" />
          <PropertyRef Name="teamID" />
          <PropertyRef Name="lgID" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="stint" Type="Edm.Int16" Nullable="false" />
        <Property Name="teamID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="W" Type="Edm.Int16" Nullable="true" />
        <Property Name="L" Type="Edm.Int16" Nullable="true" />
        <Property Name="G" Type="Edm.Int16" Nullable="true" />
        <Property Name="GS" Type="Edm.Int16" Nullable="true" />
        <Property Name="CG" Type="Edm.Int16" Nullable="true" />
        <Property Name="SHO" Type="Edm.Int16" Nullable="true" />
        <Property Name="SV" Type="Edm.Int16" Nullable="true" />
        <Property Name="IPouts" Type="Edm.Int32" Nullable="true" />
        <Property Name="H" Type="Edm.Int16" Nullable="true" />
        <Property Name="ER" Type="Edm.Int16" Nullable="true" />
        <Property Name="HR" Type="Edm.Int16" Nullable="true" />
        <Property Name="BB" Type="Edm.Int16" Nullable="true" />
        <Property Name="SO" Type="Edm.Int16" Nullable="true" />
        <Property Name="BAOpp" Type="Edm.Double" Nullable="true" />
        <Property Name="ERA" Type="Edm.Double" Nullable="true" />
        <Property Name="IBB" Type="Edm.Int16" Nullable="true" />
        <Property Name="WP" Type="Edm.Int16" Nullable="true" />
        <Property Name="HBP" Type="Edm.Int16" Nullable="true" />
        <Property Name="BK" Type="Edm.Int16" Nullable="true" />
        <Property Name="BFP" Type="Edm.Int16" Nullable="true" />
        <Property Name="GF" Type="Edm.Int16" Nullable="true" />
        <Property Name="R" Type="Edm.Int16" Nullable="true" />
        <Property Name="SH" Type="Edm.Int16" Nullable="true" />
        <Property Name="SF" Type="Edm.Int16" Nullable="true" />
        <Property Name="GIDP" Type="Edm.Int16" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_Pitching_Player" FromRole="Pitching" ToRole="Player" />
        <NavigationProperty Name="Team" Relationship="BaseballStatsModel.FK_Pitching_Teams" FromRole="Pitching" ToRole="Team" />
      </EntityType>
      <EntityType Name="PitchingPost">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="yearID" />
          <PropertyRef Name="round" />
          <PropertyRef Name="teamID" />
          <PropertyRef Name="lgID" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="round" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="teamID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="W" Type="Edm.Int16" Nullable="true" />
        <Property Name="L" Type="Edm.Int16" Nullable="true" />
        <Property Name="G" Type="Edm.Int16" Nullable="true" />
        <Property Name="GS" Type="Edm.Int16" Nullable="true" />
        <Property Name="CG" Type="Edm.Int16" Nullable="true" />
        <Property Name="SHO" Type="Edm.Int16" Nullable="true" />
        <Property Name="SV" Type="Edm.Int16" Nullable="true" />
        <Property Name="IPouts" Type="Edm.Int32" Nullable="true" />
        <Property Name="H" Type="Edm.Int16" Nullable="true" />
        <Property Name="ER" Type="Edm.Int16" Nullable="true" />
        <Property Name="HR" Type="Edm.Int16" Nullable="true" />
        <Property Name="BB" Type="Edm.Int16" Nullable="true" />
        <Property Name="SO" Type="Edm.Int16" Nullable="true" />
        <Property Name="BAOpp" Type="Edm.Double" Nullable="true" />
        <Property Name="ERA" Type="Edm.Double" Nullable="true" />
        <Property Name="IBB" Type="Edm.Int16" Nullable="true" />
        <Property Name="WP" Type="Edm.Int16" Nullable="true" />
        <Property Name="HBP" Type="Edm.Int16" Nullable="true" />
        <Property Name="BK" Type="Edm.Int16" Nullable="true" />
        <Property Name="BFP" Type="Edm.Int16" Nullable="true" />
        <Property Name="GF" Type="Edm.Int16" Nullable="true" />
        <Property Name="R" Type="Edm.Int16" Nullable="true" />
        <Property Name="SH" Type="Edm.Int16" Nullable="true" />
        <Property Name="SF" Type="Edm.Int16" Nullable="true" />
        <Property Name="GIDP" Type="Edm.Int16" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_PitchingPost_Player" FromRole="PitchingPost" ToRole="Player" />
        <NavigationProperty Name="Team" Relationship="BaseballStatsModel.FK_PitchingPost_Teams" FromRole="PitchingPost" ToRole="Team" />
      </EntityType>
      <EntityType Name="Player">
        <Key>
          <PropertyRef Name="playerID" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="hofID" Type="Edm.String" Nullable="true" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="birthYear" Type="Edm.Int16" Nullable="true" />
        <Property Name="birthMonth" Type="Edm.Int16" Nullable="true" />
        <Property Name="birthDay" Type="Edm.Int16" Nullable="true" />
        <Property Name="birthCountry" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="birthState" Type="Edm.String" Nullable="true" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="birthCity" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="deathYear" Type="Edm.Int16" Nullable="true" />
        <Property Name="deathMonth" Type="Edm.Int16" Nullable="true" />
        <Property Name="deathDay" Type="Edm.Int16" Nullable="true" />
        <Property Name="deathCountry" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="deathState" Type="Edm.String" Nullable="true" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="deathCity" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="nameFirst" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="nameLast" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="nameNote" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="nameGiven" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="nameNick" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="weight" Type="Edm.Int16" Nullable="true" />
        <Property Name="height" Type="Edm.Double" Nullable="true" />
        <Property Name="bats" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="throws" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="debut" Type="Edm.DateTime" Nullable="true" />
        <Property Name="finalGame" Type="Edm.DateTime" Nullable="true" />
        <Property Name="college" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <NavigationProperty Name="Appearance" Relationship="BaseballStatsModel.FK_Appearances_Player" FromRole="Player" ToRole="Appearance" />
        <NavigationProperty Name="AwardPlayer" Relationship="BaseballStatsModel.FK_AwardsPlayers_Player" FromRole="Player" ToRole="AwardPlayer" />
        <NavigationProperty Name="AwardSharePlayer" Relationship="BaseballStatsModel.FK_AwardsSharePlayers_Player" FromRole="Player" ToRole="AwardSharePlayer" />
        <NavigationProperty Name="Batting" Relationship="BaseballStatsModel.FK_Batting_Player" FromRole="Player" ToRole="Batting" />
        <NavigationProperty Name="BattingPost" Relationship="BaseballStatsModel.FK_BattingPost_Player" FromRole="Player" ToRole="BattingPost" />
        <NavigationProperty Name="Fielding" Relationship="BaseballStatsModel.FK_Fielding_Player" FromRole="Player" ToRole="Fielding" />
        <NavigationProperty Name="FieldingOF" Relationship="BaseballStatsModel.FK_FieldingOF_Player" FromRole="Player" ToRole="FieldingOF" />
        <NavigationProperty Name="FieldingPost" Relationship="BaseballStatsModel.FK_FieldingPost_Player" FromRole="Player" ToRole="FieldingPost" />
        <NavigationProperty Name="Pitching" Relationship="BaseballStatsModel.FK_Pitching_Player" FromRole="Player" ToRole="Pitching" />
        <NavigationProperty Name="PitchingPost" Relationship="BaseballStatsModel.FK_PitchingPost_Player" FromRole="Player" ToRole="PitchingPost" />
        <NavigationProperty Name="Salaries" Relationship="BaseballStatsModel.FK_Salaries_Player" FromRole="Player" ToRole="Salaries" />
        <NavigationProperty Name="SchoolsPlayers" Relationship="BaseballStatsModel.FK_SchoolsPlayers_Player" FromRole="Player" ToRole="SchoolsPlayers" />
      </EntityType>
      <EntityType Name="Salaries">
        <Key>
          <PropertyRef Name="yearID" />
          <PropertyRef Name="teamID" />
          <PropertyRef Name="lgID" />
          <PropertyRef Name="playerID" />
        </Key>
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="teamID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="salary" Type="Edm.Double" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_Salaries_Player" FromRole="Salaries" ToRole="Player" />
      </EntityType>
      <EntityType Name="Schools">
        <Key>
          <PropertyRef Name="schoolID" />
        </Key>
        <Property Name="schoolID" Type="Edm.String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
        <Property Name="schoolName" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="schoolCity" Type="Edm.String" Nullable="true" MaxLength="55" Unicode="true" FixedLength="false" />
        <Property Name="schoolState" Type="Edm.String" Nullable="true" MaxLength="55" Unicode="true" FixedLength="false" />
        <Property Name="schoolNick" Type="Edm.String" Nullable="true" MaxLength="55" Unicode="true" FixedLength="false" />
        <NavigationProperty Name="SchoolsPlayers" Relationship="BaseballStatsModel.FK_SchoolsPlayers_Schools" FromRole="Schools" ToRole="SchoolsPlayers" />
      </EntityType>
      <EntityType Name="SchoolsPlayers">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="schoolID" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="schoolID" Type="Edm.String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
        <Property Name="yearMin" Type="Edm.Int16" Nullable="true" />
        <Property Name="yearMax" Type="Edm.Int16" Nullable="true" />
        <NavigationProperty Name="Player" Relationship="BaseballStatsModel.FK_SchoolsPlayers_Player" FromRole="SchoolsPlayers" ToRole="Player" />
        <NavigationProperty Name="Schools" Relationship="BaseballStatsModel.FK_SchoolsPlayers_Schools" FromRole="SchoolsPlayers" ToRole="Schools" />
      </EntityType>
      <EntityType Name="SeriesPost">
        <Key>
          <PropertyRef Name="yearID" />
          <PropertyRef Name="round" />
          <PropertyRef Name="teamIDwinner" />
          <PropertyRef Name="lgIDwinner" />
        </Key>
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="round" Type="Edm.String" Nullable="false" MaxLength="5" Unicode="true" FixedLength="false" />
        <Property Name="teamIDwinner" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgIDwinner" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="teamIDloser" Type="Edm.String" Nullable="true" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="lgIDloser" Type="Edm.String" Nullable="true" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="wins" Type="Edm.Int16" Nullable="true" />
        <Property Name="losses" Type="Edm.Int16" Nullable="true" />
        <Property Name="ties" Type="Edm.Int16" Nullable="true" />
        <NavigationProperty Name="Team" Relationship="BaseballStatsModel.FK_SeriesPost_Team" FromRole="SeriesPost" ToRole="Team" />
        <NavigationProperty Name="Team1" Relationship="BaseballStatsModel.FK_SeriesPost_Team1" FromRole="SeriesPost" ToRole="Team" />
      </EntityType>
      <EntityType Name="Team">
        <Key>
          <PropertyRef Name="yearID" />
          <PropertyRef Name="lgID" />
          <PropertyRef Name="teamID" />
        </Key>
        <Property Name="yearID" Type="Edm.Int16" Nullable="false" />
        <Property Name="lgID" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="teamID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="franchID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="divID" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="Rank" Type="Edm.Int16" Nullable="true" />
        <Property Name="G" Type="Edm.Int16" Nullable="true" />
        <Property Name="Ghome" Type="Edm.Int16" Nullable="true" />
        <Property Name="W" Type="Edm.Int16" Nullable="true" />
        <Property Name="L" Type="Edm.Int16" Nullable="true" />
        <Property Name="DivWin" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="WCWin" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="LgWin" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="WSWin" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="R" Type="Edm.Int16" Nullable="true" />
        <Property Name="AB" Type="Edm.Int16" Nullable="true" />
        <Property Name="H" Type="Edm.Int16" Nullable="true" />
        <Property Name="Dbl" Type="Edm.Int16" Nullable="true" />
        <Property Name="Tpl" Type="Edm.Int16" Nullable="true" />
        <Property Name="HR" Type="Edm.Int16" Nullable="true" />
        <Property Name="BB" Type="Edm.Int16" Nullable="true" />
        <Property Name="SO" Type="Edm.Int16" Nullable="true" />
        <Property Name="SB" Type="Edm.Int16" Nullable="true" />
        <Property Name="CS" Type="Edm.Int16" Nullable="true" />
        <Property Name="HBP" Type="Edm.Int16" Nullable="true" />
        <Property Name="SF" Type="Edm.Int16" Nullable="true" />
        <Property Name="RA" Type="Edm.Int16" Nullable="true" />
        <Property Name="ER" Type="Edm.Int16" Nullable="true" />
        <Property Name="ERA" Type="Edm.Double" Nullable="true" />
        <Property Name="CG" Type="Edm.Int16" Nullable="true" />
        <Property Name="SHO" Type="Edm.Int16" Nullable="true" />
        <Property Name="SV" Type="Edm.Int16" Nullable="true" />
        <Property Name="IPouts" Type="Edm.Int32" Nullable="true" />
        <Property Name="HA" Type="Edm.Int16" Nullable="true" />
        <Property Name="HRA" Type="Edm.Int16" Nullable="true" />
        <Property Name="BBA" Type="Edm.Int16" Nullable="true" />
        <Property Name="SOA" Type="Edm.Int16" Nullable="true" />
        <Property Name="E" Type="Edm.Int32" Nullable="true" />
        <Property Name="DP" Type="Edm.Int32" Nullable="true" />
        <Property Name="FP" Type="Edm.Double" Nullable="true" />
        <Property Name="name" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="park" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="attendance" Type="Edm.Int32" Nullable="true" />
        <Property Name="BPF" Type="Edm.Int32" Nullable="true" />
        <Property Name="PPF" Type="Edm.Int32" Nullable="true" />
        <Property Name="teamIDBR" Type="Edm.String" Nullable="true" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="teamIDlahman45" Type="Edm.String" Nullable="true" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="teamIDretro" Type="Edm.String" Nullable="true" MaxLength="3" Unicode="true" FixedLength="false" />
        <NavigationProperty Name="Appearance" Relationship="BaseballStatsModel.FK_Appearances_Teams" FromRole="Team" ToRole="Appearance" />
        <NavigationProperty Name="Batting" Relationship="BaseballStatsModel.FK_Batting_Teams" FromRole="Team" ToRole="Batting" />
        <NavigationProperty Name="BattingPost" Relationship="BaseballStatsModel.FK_BattingPost_Teams" FromRole="Team" ToRole="BattingPost" />
        <NavigationProperty Name="Fielding" Relationship="BaseballStatsModel.FK_Fielding_Teams" FromRole="Team" ToRole="Fielding" />
        <NavigationProperty Name="FieldingPost" Relationship="BaseballStatsModel.FK_FieldingPost_Teams" FromRole="Team" ToRole="FieldingPost" />
        <NavigationProperty Name="Pitching" Relationship="BaseballStatsModel.FK_Pitching_Teams" FromRole="Team" ToRole="Pitching" />
        <NavigationProperty Name="PitchingPost" Relationship="BaseballStatsModel.FK_PitchingPost_Teams" FromRole="Team" ToRole="PitchingPost" />
        <NavigationProperty Name="TeamFranchise" Relationship="BaseballStatsModel.FK_Teams_TeamsFranchises" FromRole="Team" ToRole="TeamFranchise" />
        <NavigationProperty Name="SeriesPosts" Relationship="BaseballStatsModel.FK_SeriesPost_Team" FromRole="Team" ToRole="SeriesPost" />
        <NavigationProperty Name="SeriesPosts1" Relationship="BaseballStatsModel.FK_SeriesPost_Team1" FromRole="Team" ToRole="SeriesPost" />
      </EntityType>
      <EntityType Name="TeamFranchise">
        <Key>
          <PropertyRef Name="franchID" />
        </Key>
        <Property Name="franchID" Type="Edm.String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
        <Property Name="franchName" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="active" Type="Edm.String" Nullable="true" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="NAassoc" Type="Edm.String" Nullable="true" MaxLength="3" Unicode="true" FixedLength="false" />
        <NavigationProperty Name="Team" Relationship="BaseballStatsModel.FK_Teams_TeamsFranchises" FromRole="TeamFranchise" ToRole="Team" />
      </EntityType>
      <EntityType Name="BattingTotals">
        <Key>
          <PropertyRef Name="playerID" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="G" Type="Edm.Int32" Nullable="true" />
        <Property Name="G_batting" Type="Edm.Int32" Nullable="true" />
        <Property Name="AB" Type="Edm.Int32" Nullable="true" />
        <Property Name="R" Type="Edm.Int32" Nullable="true" />
        <Property Name="H" Type="Edm.Int32" Nullable="true" />
        <Property Name="Dbl" Type="Edm.Int32" Nullable="true" />
        <Property Name="Tpl" Type="Edm.Int32" Nullable="true" />
        <Property Name="HR" Type="Edm.Int32" Nullable="true" />
        <Property Name="RBI" Type="Edm.Int32" Nullable="true" />
        <Property Name="SB" Type="Edm.Int32" Nullable="true" />
        <Property Name="CS" Type="Edm.Int32" Nullable="true" />
        <Property Name="BB" Type="Edm.Int32" Nullable="true" />
        <Property Name="SO" Type="Edm.Int32" Nullable="true" />
        <Property Name="IBB" Type="Edm.Int32" Nullable="true" />
        <Property Name="HPB" Type="Edm.Int32" Nullable="true" />
        <Property Name="SH" Type="Edm.Int32" Nullable="true" />
        <Property Name="SF" Type="Edm.Int32" Nullable="true" />
        <Property Name="GIDP" Type="Edm.Int32" Nullable="true" />
      </EntityType>
      <EntityType Name="FieldingTotals">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="POS" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="POS" Type="Edm.String" Nullable="false" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="G" Type="Edm.Int32" Nullable="true" />
        <Property Name="GS" Type="Edm.Int32" Nullable="true" />
        <Property Name="InnOuts" Type="Edm.Int32" Nullable="true" />
        <Property Name="PO" Type="Edm.Int32" Nullable="true" />
        <Property Name="A" Type="Edm.Int32" Nullable="true" />
        <Property Name="E" Type="Edm.Int32" Nullable="true" />
        <Property Name="DP" Type="Edm.Int32" Nullable="true" />
        <Property Name="PB" Type="Edm.Int32" Nullable="true" />
        <Property Name="WP" Type="Edm.Int32" Nullable="true" />
        <Property Name="SB" Type="Edm.Int32" Nullable="true" />
        <Property Name="CS" Type="Edm.Int32" Nullable="true" />
        <Property Name="ZR" Type="Edm.Double" Nullable="true" />
      </EntityType>
      <EntityType Name="PitchingTotals">
        <Key>
          <PropertyRef Name="playerID" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="W" Type="Edm.Int32" Nullable="true" />
        <Property Name="L" Type="Edm.Int32" Nullable="true" />
        <Property Name="G" Type="Edm.Int32" Nullable="true" />
        <Property Name="GS" Type="Edm.Int32" Nullable="true" />
        <Property Name="CG" Type="Edm.Int32" Nullable="true" />
        <Property Name="SHO" Type="Edm.Int32" Nullable="true" />
        <Property Name="SV" Type="Edm.Int32" Nullable="true" />
        <Property Name="IPouts" Type="Edm.Int32" Nullable="true" />
        <Property Name="H" Type="Edm.Int32" Nullable="true" />
        <Property Name="ER" Type="Edm.Int32" Nullable="true" />
        <Property Name="HR" Type="Edm.Int32" Nullable="true" />
        <Property Name="BB" Type="Edm.Int32" Nullable="true" />
        <Property Name="SO" Type="Edm.Int32" Nullable="true" />
        <Property Name="BAOpp" Type="Edm.Double" Nullable="true" />
        <Property Name="IBB" Type="Edm.Int32" Nullable="true" />
        <Property Name="WP" Type="Edm.Int32" Nullable="true" />
        <Property Name="HBP" Type="Edm.Int32" Nullable="true" />
        <Property Name="BK" Type="Edm.Int32" Nullable="true" />
        <Property Name="BFP" Type="Edm.Int32" Nullable="true" />
        <Property Name="GF" Type="Edm.Int32" Nullable="true" />
        <Property Name="R" Type="Edm.Int32" Nullable="true" />
        <Property Name="SH" Type="Edm.Int32" Nullable="true" />
        <Property Name="SF" Type="Edm.Int32" Nullable="true" />
        <Property Name="GIDP" Type="Edm.Int32" Nullable="true" />
      </EntityType>
      <EntityType Name="PlayerHOF">
        <Key>
          <PropertyRef Name="playerID" />
          <PropertyRef Name="yearid" />
          <PropertyRef Name="votedBy" />
        </Key>
        <Property Name="playerID" Type="Edm.String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="hofID" Type="Edm.String" Nullable="true" MaxLength="10" Unicode="true" FixedLength="false" />
        <Property Name="birthYear" Type="Edm.Int16" Nullable="true" />
        <Property Name="birthMonth" Type="Edm.Int16" Nullable="true" />
        <Property Name="birthDay" Type="Edm.Int16" Nullable="true" />
        <Property Name="birthCountry" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="birthState" Type="Edm.String" Nullable="true" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="birthCity" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="deathYear" Type="Edm.Int16" Nullable="true" />
        <Property Name="deathMonth" Type="Edm.Int16" Nullable="true" />
        <Property Name="deathDay" Type="Edm.Int16" Nullable="true" />
        <Property Name="deathCountry" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="deathState" Type="Edm.String" Nullable="true" MaxLength="2" Unicode="true" FixedLength="false" />
        <Property Name="deathCity" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="nameFirst" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="nameLast" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="nameNote" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="nameGiven" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="nameNick" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="weight" Type="Edm.Int16" Nullable="true" />
        <Property Name="height" Type="Edm.Double" Nullable="true" />
        <Property Name="bats" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="throws" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="debut" Type="Edm.DateTime" Nullable="true" />
        <Property Name="finalGame" Type="Edm.DateTime" Nullable="true" />
        <Property Name="college" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="yearid" Type="Edm.Int16" Nullable="false" />
        <Property Name="votedBy" Type="Edm.String" Nullable="false" MaxLength="64" Unicode="true" FixedLength="false" />
        <Property Name="ballots" Type="Edm.Int16" Nullable="true" />
        <Property Name="votes" Type="Edm.Int16" Nullable="true" />
        <Property Name="inducted" Type="Edm.String" Nullable="true" MaxLength="1" Unicode="true" FixedLength="false" />
        <Property Name="category" Type="Edm.String" Nullable="true" MaxLength="20" Unicode="true" FixedLength="false" />
      </EntityType>
      <Association Name="FK_Appearances_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="Appearance" Type="BaseballStatsModel.Appearance" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="Appearance">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_Appearances_Teams">
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="1" />
        <End Role="Appearance" Type="BaseballStatsModel.Appearance" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Team">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Principal>
          <Dependent Role="Appearance">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_AwardsPlayers_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="AwardPlayer" Type="BaseballStatsModel.AwardPlayer" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="AwardPlayer">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_AwardsSharePlayers_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="AwardSharePlayer" Type="BaseballStatsModel.AwardSharePlayer" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="AwardSharePlayer">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_Batting_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="Batting" Type="BaseballStatsModel.Batting" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="Batting">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_Batting_Teams">
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="1" />
        <End Role="Batting" Type="BaseballStatsModel.Batting" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Team">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Principal>
          <Dependent Role="Batting">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_BattingPost_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="BattingPost" Type="BaseballStatsModel.BattingPost" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="BattingPost">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_BattingPost_Teams">
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="1" />
        <End Role="BattingPost" Type="BaseballStatsModel.BattingPost" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Team">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Principal>
          <Dependent Role="BattingPost">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_Fielding_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="Fielding" Type="BaseballStatsModel.Fielding" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="Fielding">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_Fielding_Teams">
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="1" />
        <End Role="Fielding" Type="BaseballStatsModel.Fielding" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Team">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Principal>
          <Dependent Role="Fielding">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_FieldingOF_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="FieldingOF" Type="BaseballStatsModel.FieldingOF" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="FieldingOF">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_FieldingPost_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="FieldingPost" Type="BaseballStatsModel.FieldingPost" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="FieldingPost">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_FieldingPost_Teams">
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="1" />
        <End Role="FieldingPost" Type="BaseballStatsModel.FieldingPost" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Team">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Principal>
          <Dependent Role="FieldingPost">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_Pitching_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="Pitching" Type="BaseballStatsModel.Pitching" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="Pitching">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_Pitching_Teams">
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="1" />
        <End Role="Pitching" Type="BaseballStatsModel.Pitching" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Team">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Principal>
          <Dependent Role="Pitching">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_PitchingPost_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="PitchingPost" Type="BaseballStatsModel.PitchingPost" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="PitchingPost">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_PitchingPost_Teams">
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="1" />
        <End Role="PitchingPost" Type="BaseballStatsModel.PitchingPost" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Team">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Principal>
          <Dependent Role="PitchingPost">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_Salaries_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="Salaries" Type="BaseballStatsModel.Salaries" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="Salaries">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_SchoolsPlayers_Player">
        <End Role="Player" Type="BaseballStatsModel.Player" Multiplicity="1" />
        <End Role="SchoolsPlayers" Type="BaseballStatsModel.SchoolsPlayers" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Player">
            <PropertyRef Name="playerID" />
          </Principal>
          <Dependent Role="SchoolsPlayers">
            <PropertyRef Name="playerID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_SchoolsPlayers_Schools">
        <End Role="Schools" Type="BaseballStatsModel.Schools" Multiplicity="1" />
        <End Role="SchoolsPlayers" Type="BaseballStatsModel.SchoolsPlayers" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Schools">
            <PropertyRef Name="schoolID" />
          </Principal>
          <Dependent Role="SchoolsPlayers">
            <PropertyRef Name="schoolID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_Teams_TeamsFranchises">
        <End Role="TeamFranchise" Type="BaseballStatsModel.TeamFranchise" Multiplicity="1" />
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="TeamFranchise">
            <PropertyRef Name="franchID" />
          </Principal>
          <Dependent Role="Team">
            <PropertyRef Name="franchID" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_SeriesPost_Team">
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="1" />
        <End Role="SeriesPost" Type="BaseballStatsModel.SeriesPost" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Team">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Principal>
          <Dependent Role="SeriesPost">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgIDwinner" />
            <PropertyRef Name="teamIDwinner" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
      <Association Name="FK_SeriesPost_Team1">
        <End Role="Team" Type="BaseballStatsModel.Team" Multiplicity="0..1" />
        <End Role="SeriesPost" Type="BaseballStatsModel.SeriesPost" Multiplicity="*" />
        <ReferentialConstraint>
          <Principal Role="Team">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgID" />
            <PropertyRef Name="teamID" />
          </Principal>
          <Dependent Role="SeriesPost">
            <PropertyRef Name="yearID" />
            <PropertyRef Name="lgIDloser" />
            <PropertyRef Name="teamIDloser" />
          </Dependent>
        </ReferentialConstraint>
      </Association>
    </Schema>
    <Schema Namespace="BaseballStatsOData11" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
      <EntityContainer Name="BaseballStatsEntities" p7:LazyLoadingEnabled="true" m:IsDefaultEntityContainer="true" xmlns:p7="http://schemas.microsoft.com/ado/2009/02/edm/annotation">
        <EntitySet Name="Appearance" EntityType="BaseballStatsModel.Appearance" />
        <EntitySet Name="AwardPlayer" EntityType="BaseballStatsModel.AwardPlayer" />
        <EntitySet Name="AwardSharePlayer" EntityType="BaseballStatsModel.AwardSharePlayer" />
        <EntitySet Name="Batting" EntityType="BaseballStatsModel.Batting" />
        <EntitySet Name="BattingPost" EntityType="BaseballStatsModel.BattingPost" />
        <EntitySet Name="Fielding" EntityType="BaseballStatsModel.Fielding" />
        <EntitySet Name="FieldingOF" EntityType="BaseballStatsModel.FieldingOF" />
        <EntitySet Name="FieldingPost" EntityType="BaseballStatsModel.FieldingPost" />
        <EntitySet Name="Pitching" EntityType="BaseballStatsModel.Pitching" />
        <EntitySet Name="PitchingPost" EntityType="BaseballStatsModel.PitchingPost" />
        <EntitySet Name="Player" EntityType="BaseballStatsModel.Player" />
        <EntitySet Name="Salaries" EntityType="BaseballStatsModel.Salaries" />
        <EntitySet Name="Schools" EntityType="BaseballStatsModel.Schools" />
        <EntitySet Name="SchoolsPlayers" EntityType="BaseballStatsModel.SchoolsPlayers" />
        <EntitySet Name="SeriesPost" EntityType="BaseballStatsModel.SeriesPost" />
        <EntitySet Name="Team" EntityType="BaseballStatsModel.Team" />
        <EntitySet Name="TeamFranchise" EntityType="BaseballStatsModel.TeamFranchise" />
        <EntitySet Name="BattingTotals" EntityType="BaseballStatsModel.BattingTotals" />
        <EntitySet Name="FieldingTotals" EntityType="BaseballStatsModel.FieldingTotals" />
        <EntitySet Name="PitchingTotals" EntityType="BaseballStatsModel.PitchingTotals" />
        <EntitySet Name="PlayerHOF" EntityType="BaseballStatsModel.PlayerHOF" />
        <AssociationSet Name="FK_Appearances_Player" Association="BaseballStatsModel.FK_Appearances_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="Appearance" EntitySet="Appearance" />
        </AssociationSet>
        <AssociationSet Name="FK_Appearances_Teams" Association="BaseballStatsModel.FK_Appearances_Teams">
          <End Role="Team" EntitySet="Team" />
          <End Role="Appearance" EntitySet="Appearance" />
        </AssociationSet>
        <AssociationSet Name="FK_AwardsPlayers_Player" Association="BaseballStatsModel.FK_AwardsPlayers_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="AwardPlayer" EntitySet="AwardPlayer" />
        </AssociationSet>
        <AssociationSet Name="FK_AwardsSharePlayers_Player" Association="BaseballStatsModel.FK_AwardsSharePlayers_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="AwardSharePlayer" EntitySet="AwardSharePlayer" />
        </AssociationSet>
        <AssociationSet Name="FK_Batting_Player" Association="BaseballStatsModel.FK_Batting_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="Batting" EntitySet="Batting" />
        </AssociationSet>
        <AssociationSet Name="FK_Batting_Teams" Association="BaseballStatsModel.FK_Batting_Teams">
          <End Role="Team" EntitySet="Team" />
          <End Role="Batting" EntitySet="Batting" />
        </AssociationSet>
        <AssociationSet Name="FK_BattingPost_Player" Association="BaseballStatsModel.FK_BattingPost_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="BattingPost" EntitySet="BattingPost" />
        </AssociationSet>
        <AssociationSet Name="FK_BattingPost_Teams" Association="BaseballStatsModel.FK_BattingPost_Teams">
          <End Role="Team" EntitySet="Team" />
          <End Role="BattingPost" EntitySet="BattingPost" />
        </AssociationSet>
        <AssociationSet Name="FK_Fielding_Player" Association="BaseballStatsModel.FK_Fielding_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="Fielding" EntitySet="Fielding" />
        </AssociationSet>
        <AssociationSet Name="FK_Fielding_Teams" Association="BaseballStatsModel.FK_Fielding_Teams">
          <End Role="Team" EntitySet="Team" />
          <End Role="Fielding" EntitySet="Fielding" />
        </AssociationSet>
        <AssociationSet Name="FK_FieldingOF_Player" Association="BaseballStatsModel.FK_FieldingOF_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="FieldingOF" EntitySet="FieldingOF" />
        </AssociationSet>
        <AssociationSet Name="FK_FieldingPost_Player" Association="BaseballStatsModel.FK_FieldingPost_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="FieldingPost" EntitySet="FieldingPost" />
        </AssociationSet>
        <AssociationSet Name="FK_FieldingPost_Teams" Association="BaseballStatsModel.FK_FieldingPost_Teams">
          <End Role="Team" EntitySet="Team" />
          <End Role="FieldingPost" EntitySet="FieldingPost" />
        </AssociationSet>
        <AssociationSet Name="FK_Pitching_Player" Association="BaseballStatsModel.FK_Pitching_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="Pitching" EntitySet="Pitching" />
        </AssociationSet>
        <AssociationSet Name="FK_Pitching_Teams" Association="BaseballStatsModel.FK_Pitching_Teams">
          <End Role="Team" EntitySet="Team" />
          <End Role="Pitching" EntitySet="Pitching" />
        </AssociationSet>
        <AssociationSet Name="FK_PitchingPost_Player" Association="BaseballStatsModel.FK_PitchingPost_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="PitchingPost" EntitySet="PitchingPost" />
        </AssociationSet>
        <AssociationSet Name="FK_PitchingPost_Teams" Association="BaseballStatsModel.FK_PitchingPost_Teams">
          <End Role="Team" EntitySet="Team" />
          <End Role="PitchingPost" EntitySet="PitchingPost" />
        </AssociationSet>
        <AssociationSet Name="FK_Salaries_Player" Association="BaseballStatsModel.FK_Salaries_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="Salaries" EntitySet="Salaries" />
        </AssociationSet>
        <AssociationSet Name="FK_SchoolsPlayers_Player" Association="BaseballStatsModel.FK_SchoolsPlayers_Player">
          <End Role="Player" EntitySet="Player" />
          <End Role="SchoolsPlayers" EntitySet="SchoolsPlayers" />
        </AssociationSet>
        <AssociationSet Name="FK_SchoolsPlayers_Schools" Association="BaseballStatsModel.FK_SchoolsPlayers_Schools">
          <End Role="Schools" EntitySet="Schools" />
          <End Role="SchoolsPlayers" EntitySet="SchoolsPlayers" />
        </AssociationSet>
        <AssociationSet Name="FK_Teams_TeamsFranchises" Association="BaseballStatsModel.FK_Teams_TeamsFranchises">
          <End Role="TeamFranchise" EntitySet="TeamFranchise" />
          <End Role="Team" EntitySet="Team" />
        </AssociationSet>
        <AssociationSet Name="FK_SeriesPost_Team" Association="BaseballStatsModel.FK_SeriesPost_Team">
          <End Role="Team" EntitySet="Team" />
          <End Role="SeriesPost" EntitySet="SeriesPost" />
        </AssociationSet>
        <AssociationSet Name="FK_SeriesPost_Team1" Association="BaseballStatsModel.FK_SeriesPost_Team1">
          <End Role="Team" EntitySet="Team" />
          <End Role="SeriesPost" EntitySet="SeriesPost" />
        </AssociationSet>
      </EntityContainer>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>
