1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846 |
- <?xml version="1.0" encoding="utf-8"?>
- <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
- <!-- EF Runtime content -->
- <edmx:Runtime>
- <!-- SSDL content -->
- <edmx:StorageModels>
- <Schema Namespace="Хранилище PracticeNBAModel" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
- <EntityType Name="ActionType">
- <Key>
- <PropertyRef Name="IdActionType" />
- </Key>
- <Property Name="IdActionType" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NameActionType" Type="varchar" MaxLength="50" />
- </EntityType>
- <EntityType Name="Conference">
- <Key>
- <PropertyRef Name="IdConference" />
- </Key>
- <Property Name="IdConference" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NameConference" Type="varchar" MaxLength="50" />
- </EntityType>
- <EntityType Name="Country">
- <Key>
- <PropertyRef Name="IdCountry" />
- </Key>
- <Property Name="IdCountry" Type="int" Nullable="false" />
- <Property Name="NameCountry" Type="varchar" MaxLength="50" />
- <Property Name="CodeCountry" Type="char" MaxLength="3" />
- </EntityType>
- <EntityType Name="Department">
- <Key>
- <PropertyRef Name="IdDepartment" />
- </Key>
- <Property Name="IdDepartment" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NameDepartment" Type="varchar" MaxLength="50" />
- <Property Name="IdOrganization" Type="int" />
- </EntityType>
- <EntityType Name="Division">
- <Key>
- <PropertyRef Name="IdDivision" />
- </Key>
- <Property Name="IdDivision" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NameDivision" Type="varchar" MaxLength="50" />
- <Property Name="IdConference" Type="int" />
- </EntityType>
- <EntityType Name="Gender">
- <Key>
- <PropertyRef Name="IdGender" />
- </Key>
- <Property Name="IdGender" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NameGender" Type="varchar" MaxLength="50" />
- </EntityType>
- <EntityType Name="Image">
- <Key>
- <PropertyRef Name="IdImage" />
- </Key>
- <Property Name="IdImage" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Image" Type="varbinary(max)" Nullable="false" />
- <Property Name="Description" Type="varchar" MaxLength="50" />
- <Property Name="NumberOfLikes" Type="int" />
- <Property Name="CreateTime" Type="datetime" />
- </EntityType>
- <EntityType Name="Matchup">
- <Key>
- <PropertyRef Name="IdMatchup" />
- </Key>
- <Property Name="IdMatchup" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="IdSeason" Type="int" />
- <Property Name="IdMatchupType" Type="int" />
- <Property Name="IdTeamAway" Type="int" />
- <Property Name="IdTeamHome" Type="int" />
- <Property Name="Starttime" Type="datetime" />
- <Property Name="TeamAwayScore" Type="int" />
- <Property Name="TeamHomeScore" Type="int" />
- <Property Name="Location" Type="varchar" MaxLength="200" />
- <Property Name="IdStatus" Type="int" />
- </EntityType>
- <EntityType Name="MatchupDetail">
- <Key>
- <PropertyRef Name="IdMatchupDetail" />
- </Key>
- <Property Name="IdMatchupDetail" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="IdMatchup" Type="int" />
- <Property Name="IdQuarter" Type="int" />
- <Property Name="TeamAwayScore" Type="int" />
- <Property Name="TeamHomeScore" Type="int" />
- </EntityType>
- <EntityType Name="MatchupLogs">
- <Key>
- <PropertyRef Name="IdMatchupLogs" />
- </Key>
- <Property Name="IdMatchupLogs" Type="int" Nullable="false" />
- <Property Name="IdMatchup" Type="int" />
- <Property Name="IdQuarter" Type="int" />
- <Property Name="OccurTime" Type="varchar" MaxLength="10" />
- <Property Name="IdTeam" Type="int" />
- <Property Name="IdPlayer" Type="int" />
- <Property Name="IdActionType" Type="int" />
- <Property Name="Remark" Type="varchar" MaxLength="300" />
- </EntityType>
- <EntityType Name="MatchupType">
- <Key>
- <PropertyRef Name="IdMatchupType" />
- </Key>
- <Property Name="IdMatchupType" Type="int" Nullable="false" />
- <Property Name="NameMatchupType" Type="varchar" MaxLength="50" />
- </EntityType>
- <EntityType Name="Organization">
- <Key>
- <PropertyRef Name="IdOrganization" />
- </Key>
- <Property Name="IdOrganization" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="OrganizationName" Type="varchar" MaxLength="50" />
- <Property Name="Info" Type="text" />
- <Property Name="IdStatusOrganization" Type="int" />
- </EntityType>
- <EntityType Name="Player">
- <Key>
- <PropertyRef Name="IdPlayer" />
- </Key>
- <Property Name="IdPlayer" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Surename" Type="varchar" MaxLength="50" />
- <Property Name="Name" Type="varchar" MaxLength="50" />
- <Property Name="Patronymic" Type="varchar" MaxLength="50" />
- <Property Name="IdPosition" Type="int" />
- <Property Name="JoinYear" Type="date" />
- <Property Name="IdGender" Type="int" />
- <Property Name="Height" Type="decimal" Precision="10" Scale="2" />
- <Property Name="Weight" Type="decimal" Precision="10" Scale="2" />
- <Property Name="DateOfBirth" Type="date" />
- <Property Name="College" Type="varchar" MaxLength="50" />
- <Property Name="Email" Type="varchar" MaxLength="50" />
- <Property Name="IdCountry" Type="int" />
- <Property Name="IsRetiment" Type="bit" />
- <Property Name="RetirmentTime" Type="date" />
- <Property Name="Image" Type="image" />
- </EntityType>
- <EntityType Name="PlayerInTeam">
- <Key>
- <PropertyRef Name="IdPlayerInTeam" />
- </Key>
- <Property Name="IdPlayerInTeam" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="IdPlayer" Type="int" />
- <Property Name="IdTeam" Type="int" />
- <Property Name="IdSeason" Type="int" />
- <Property Name="ShirtNumber" Type="varchar" MaxLength="10" />
- <Property Name="Salary" Type="decimal" Precision="10" Scale="2" />
- <Property Name="StarterIndex" Type="int" />
- </EntityType>
- <EntityType Name="PlayerStatistic">
- <Key>
- <PropertyRef Name="IdPlayerStatistic" />
- </Key>
- <Property Name="IdPlayerStatistic" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="IdMatchup" Type="int" />
- <Property Name="IdTeam" Type="int" />
- <Property Name="IdPlayer" Type="int" />
- <Property Name="IsStarting" Type="int" />
- <Property Name="Min" Type="decimal" Precision="10" Scale="2" />
- <Property Name="Point" Type="int" />
- <Property Name="Assist" Type="int" />
- <Property Name="FieldGoalMade" Type="int" />
- <Property Name="FieldGoalMissed" Type="int" />
- <Property Name="ThreePointFieldGoalMade" Type="int" />
- <Property Name="ThreePointFieldGoalMissed" Type="int" />
- <Property Name="FreeThrowMade" Type="int" />
- <Property Name="FreeThrowMissed" Type="int" />
- <Property Name="Rebound" Type="int" />
- <Property Name="OFFR" Type="int" />
- <Property Name="DFFR" Type="int" />
- <Property Name="Steal" Type="int" />
- <Property Name="Block" Type="int" />
- <Property Name="Turnover" Type="int" />
- <Property Name="Foul" Type="int" />
- </EntityType>
- <EntityType Name="Position">
- <Key>
- <PropertyRef Name="IdPosition" />
- </Key>
- <Property Name="IdPosition" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NamePosition" Type="varchar" MaxLength="50" />
- <Property Name="Abbr" Type="char" MaxLength="3" />
- </EntityType>
- <EntityType Name="PostSeason">
- <Key>
- <PropertyRef Name="IdPostSeason" />
- </Key>
- <Property Name="IdPostSeason" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="IdSeason" Type="int" />
- <Property Name="IdTeam" Type="int" />
- <Property Name="Rank" Type="int" />
- </EntityType>
- <EntityType Name="Quarter">
- <Key>
- <PropertyRef Name="IdQuarter" />
- </Key>
- <Property Name="IdQuarter" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NameQuarter" Type="varchar" MaxLength="50" />
- </EntityType>
- <EntityType Name="Role">
- <Key>
- <PropertyRef Name="IdRole" />
- </Key>
- <Property Name="IdRole" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="RoleName" Type="varchar" MaxLength="50" />
- </EntityType>
- <EntityType Name="Season">
- <Key>
- <PropertyRef Name="IdSeason" />
- </Key>
- <Property Name="IdSeason" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NameSeason" Type="varchar" MaxLength="50" />
- </EntityType>
- <EntityType Name="Status">
- <Key>
- <PropertyRef Name="IdStatus" />
- </Key>
- <Property Name="IdStatus" Type="int" Nullable="false" />
- <Property Name="NameStatus" Type="varchar" MaxLength="50" />
- </EntityType>
- <EntityType Name="StatusOrganization">
- <Key>
- <PropertyRef Name="IdStatusOrganization" />
- </Key>
- <Property Name="IdStatusOrganization" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NameStatusOrganization" Type="varchar" MaxLength="50" />
- </EntityType>
- <EntityType Name="sysdiagrams">
- <Key>
- <PropertyRef Name="diagram_id" />
- </Key>
- <Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
- <Property Name="principal_id" Type="int" Nullable="false" />
- <Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="version" Type="int" />
- <Property Name="definition" Type="varbinary(max)" />
- </EntityType>
- <EntityType Name="Team">
- <Key>
- <PropertyRef Name="IdTeam" />
- </Key>
- <Property Name="IdTeam" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="TeamName" Type="varchar" MaxLength="50" />
- <Property Name="IdDivision" Type="int" />
- <Property Name="Couch" Type="varchar" MaxLength="50" />
- <Property Name="Abbr" Type="char" MaxLength="3" />
- <Property Name="Stadium" Type="varchar" MaxLength="100" />
- <Property Name="Logo" Type="image" />
- </EntityType>
- <EntityType Name="User">
- <Key>
- <PropertyRef Name="IdUser" />
- </Key>
- <Property Name="IdUser" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Surename" Type="varchar" MaxLength="50" />
- <Property Name="Name" Type="varchar" MaxLength="50" />
- <Property Name="Patronymic" Type="varchar" MaxLength="50" />
- <Property Name="LoginName" Type="varchar" MaxLength="100" />
- <Property Name="Password" Type="varchar" MaxLength="50" />
- <Property Name="IdGender" Type="int" />
- <Property Name="DateOfBirth" Type="date" />
- <Property Name="Phone" Type="varchar" MaxLength="20" />
- <Property Name="Email" Type="varchar" MaxLength="50" />
- <Property Name="IdRole" Type="int" />
- </EntityType>
- <Association Name="FK_Department_Organization">
- <End Role="Organization" Type="Self.Organization" Multiplicity="0..1" />
- <End Role="Department" Type="Self.Department" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Organization">
- <PropertyRef Name="IdOrganization" />
- </Principal>
- <Dependent Role="Department">
- <PropertyRef Name="IdOrganization" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Division_Conference">
- <End Role="Conference" Type="Self.Conference" Multiplicity="0..1" />
- <End Role="Division" Type="Self.Division" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Conference">
- <PropertyRef Name="IdConference" />
- </Principal>
- <Dependent Role="Division">
- <PropertyRef Name="IdConference" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_MatchupType">
- <End Role="MatchupType" Type="Self.MatchupType" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="MatchupType">
- <PropertyRef Name="IdMatchupType" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdMatchupType" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_Season">
- <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Season">
- <PropertyRef Name="IdSeason" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdSeason" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_Status">
- <End Role="Status" Type="Self.Status" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Status">
- <PropertyRef Name="IdStatus" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdStatus" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdTeamAway" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_Team1">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdTeamHome" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupDetail_Matchup">
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="0..1" />
- <End Role="MatchupDetail" Type="Self.MatchupDetail" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Matchup">
- <PropertyRef Name="IdMatchup" />
- </Principal>
- <Dependent Role="MatchupDetail">
- <PropertyRef Name="IdMatchup" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupDetail_Quarter">
- <End Role="Quarter" Type="Self.Quarter" Multiplicity="0..1" />
- <End Role="MatchupDetail" Type="Self.MatchupDetail" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Quarter">
- <PropertyRef Name="IdQuarter" />
- </Principal>
- <Dependent Role="MatchupDetail">
- <PropertyRef Name="IdQuarter" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupLogs_ActionType">
- <End Role="ActionType" Type="Self.ActionType" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="ActionType">
- <PropertyRef Name="IdActionType" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdActionType" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupLogs_Matchup">
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Matchup">
- <PropertyRef Name="IdMatchup" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdMatchup" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupLogs_Player">
- <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Player">
- <PropertyRef Name="IdPlayer" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdPlayer" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupLogs_Quarter">
- <End Role="Quarter" Type="Self.Quarter" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Quarter">
- <PropertyRef Name="IdQuarter" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdQuarter" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupLogs_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdTeam" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Organization_StatusOrganization">
- <End Role="StatusOrganization" Type="Self.StatusOrganization" Multiplicity="0..1" />
- <End Role="Organization" Type="Self.Organization" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="StatusOrganization">
- <PropertyRef Name="IdStatusOrganization" />
- </Principal>
- <Dependent Role="Organization">
- <PropertyRef Name="IdStatusOrganization" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Player_Country">
- <End Role="Country" Type="Self.Country" Multiplicity="0..1" />
- <End Role="Player" Type="Self.Player" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Country">
- <PropertyRef Name="IdCountry" />
- </Principal>
- <Dependent Role="Player">
- <PropertyRef Name="IdCountry" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Player_Gender">
- <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
- <End Role="Player" Type="Self.Player" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Gender">
- <PropertyRef Name="IdGender" />
- </Principal>
- <Dependent Role="Player">
- <PropertyRef Name="IdGender" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Player_Position">
- <End Role="Position" Type="Self.Position" Multiplicity="0..1" />
- <End Role="Player" Type="Self.Player" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Position">
- <PropertyRef Name="IdPosition" />
- </Principal>
- <Dependent Role="Player">
- <PropertyRef Name="IdPosition" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerInTeam_Player">
- <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
- <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Player">
- <PropertyRef Name="IdPlayer" />
- </Principal>
- <Dependent Role="PlayerInTeam">
- <PropertyRef Name="IdPlayer" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerInTeam_Season">
- <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
- <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Season">
- <PropertyRef Name="IdSeason" />
- </Principal>
- <Dependent Role="PlayerInTeam">
- <PropertyRef Name="IdSeason" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerInTeam_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="PlayerInTeam">
- <PropertyRef Name="IdTeam" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerStatistic_Player">
- <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
- <End Role="PlayerStatistic" Type="Self.PlayerStatistic" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Player">
- <PropertyRef Name="IdPlayer" />
- </Principal>
- <Dependent Role="PlayerStatistic">
- <PropertyRef Name="IdPlayer" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerStatistic_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="PlayerStatistic" Type="Self.PlayerStatistic" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="PlayerStatistic">
- <PropertyRef Name="IdTeam" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PostSeason_Season">
- <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
- <End Role="PostSeason" Type="Self.PostSeason" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Season">
- <PropertyRef Name="IdSeason" />
- </Principal>
- <Dependent Role="PostSeason">
- <PropertyRef Name="IdSeason" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PostSeason_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="PostSeason" Type="Self.PostSeason" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="PostSeason">
- <PropertyRef Name="IdTeam" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Team_Division">
- <End Role="Division" Type="Self.Division" Multiplicity="0..1" />
- <End Role="Team" Type="Self.Team" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Division">
- <PropertyRef Name="IdDivision" />
- </Principal>
- <Dependent Role="Team">
- <PropertyRef Name="IdDivision" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_User_Gender">
- <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
- <End Role="User" Type="Self.User" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Gender">
- <PropertyRef Name="IdGender" />
- </Principal>
- <Dependent Role="User">
- <PropertyRef Name="IdGender" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_User_Role">
- <End Role="Role" Type="Self.Role" Multiplicity="0..1" />
- <End Role="User" Type="Self.User" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Role">
- <PropertyRef Name="IdRole" />
- </Principal>
- <Dependent Role="User">
- <PropertyRef Name="IdRole" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <EntityContainer Name="Хранилище PracticeNBAModelContainer">
- <EntitySet Name="ActionType" EntityType="Self.ActionType" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Conference" EntityType="Self.Conference" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Country" EntityType="Self.Country" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Department" EntityType="Self.Department" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Division" EntityType="Self.Division" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Gender" EntityType="Self.Gender" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Image" EntityType="Self.Image" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Matchup" EntityType="Self.Matchup" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="MatchupDetail" EntityType="Self.MatchupDetail" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="MatchupLogs" EntityType="Self.MatchupLogs" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="MatchupType" EntityType="Self.MatchupType" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Organization" EntityType="Self.Organization" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Player" EntityType="Self.Player" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="PlayerInTeam" EntityType="Self.PlayerInTeam" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="PlayerStatistic" EntityType="Self.PlayerStatistic" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Position" EntityType="Self.Position" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="PostSeason" EntityType="Self.PostSeason" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Quarter" EntityType="Self.Quarter" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Role" EntityType="Self.Role" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Season" EntityType="Self.Season" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Status" EntityType="Self.Status" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="StatusOrganization" EntityType="Self.StatusOrganization" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Team" EntityType="Self.Team" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="User" EntityType="Self.User" Schema="dbo" store:Type="Tables" />
- <AssociationSet Name="FK_Department_Organization" Association="Self.FK_Department_Organization">
- <End Role="Organization" EntitySet="Organization" />
- <End Role="Department" EntitySet="Department" />
- </AssociationSet>
- <AssociationSet Name="FK_Division_Conference" Association="Self.FK_Division_Conference">
- <End Role="Conference" EntitySet="Conference" />
- <End Role="Division" EntitySet="Division" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_MatchupType" Association="Self.FK_Matchup_MatchupType">
- <End Role="MatchupType" EntitySet="MatchupType" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_Season" Association="Self.FK_Matchup_Season">
- <End Role="Season" EntitySet="Season" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_Status" Association="Self.FK_Matchup_Status">
- <End Role="Status" EntitySet="Status" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_Team" Association="Self.FK_Matchup_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_Team1" Association="Self.FK_Matchup_Team1">
- <End Role="Team" EntitySet="Team" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupDetail_Matchup" Association="Self.FK_MatchupDetail_Matchup">
- <End Role="Matchup" EntitySet="Matchup" />
- <End Role="MatchupDetail" EntitySet="MatchupDetail" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupDetail_Quarter" Association="Self.FK_MatchupDetail_Quarter">
- <End Role="Quarter" EntitySet="Quarter" />
- <End Role="MatchupDetail" EntitySet="MatchupDetail" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupLogs_ActionType" Association="Self.FK_MatchupLogs_ActionType">
- <End Role="ActionType" EntitySet="ActionType" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupLogs_Matchup" Association="Self.FK_MatchupLogs_Matchup">
- <End Role="Matchup" EntitySet="Matchup" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupLogs_Player" Association="Self.FK_MatchupLogs_Player">
- <End Role="Player" EntitySet="Player" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupLogs_Quarter" Association="Self.FK_MatchupLogs_Quarter">
- <End Role="Quarter" EntitySet="Quarter" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupLogs_Team" Association="Self.FK_MatchupLogs_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_Organization_StatusOrganization" Association="Self.FK_Organization_StatusOrganization">
- <End Role="StatusOrganization" EntitySet="StatusOrganization" />
- <End Role="Organization" EntitySet="Organization" />
- </AssociationSet>
- <AssociationSet Name="FK_Player_Country" Association="Self.FK_Player_Country">
- <End Role="Country" EntitySet="Country" />
- <End Role="Player" EntitySet="Player" />
- </AssociationSet>
- <AssociationSet Name="FK_Player_Gender" Association="Self.FK_Player_Gender">
- <End Role="Gender" EntitySet="Gender" />
- <End Role="Player" EntitySet="Player" />
- </AssociationSet>
- <AssociationSet Name="FK_Player_Position" Association="Self.FK_Player_Position">
- <End Role="Position" EntitySet="Position" />
- <End Role="Player" EntitySet="Player" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerInTeam_Player" Association="Self.FK_PlayerInTeam_Player">
- <End Role="Player" EntitySet="Player" />
- <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerInTeam_Season" Association="Self.FK_PlayerInTeam_Season">
- <End Role="Season" EntitySet="Season" />
- <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerInTeam_Team" Association="Self.FK_PlayerInTeam_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerStatistic_Player" Association="Self.FK_PlayerStatistic_Player">
- <End Role="Player" EntitySet="Player" />
- <End Role="PlayerStatistic" EntitySet="PlayerStatistic" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerStatistic_Team" Association="Self.FK_PlayerStatistic_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="PlayerStatistic" EntitySet="PlayerStatistic" />
- </AssociationSet>
- <AssociationSet Name="FK_PostSeason_Season" Association="Self.FK_PostSeason_Season">
- <End Role="Season" EntitySet="Season" />
- <End Role="PostSeason" EntitySet="PostSeason" />
- </AssociationSet>
- <AssociationSet Name="FK_PostSeason_Team" Association="Self.FK_PostSeason_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="PostSeason" EntitySet="PostSeason" />
- </AssociationSet>
- <AssociationSet Name="FK_Team_Division" Association="Self.FK_Team_Division">
- <End Role="Division" EntitySet="Division" />
- <End Role="Team" EntitySet="Team" />
- </AssociationSet>
- <AssociationSet Name="FK_User_Gender" Association="Self.FK_User_Gender">
- <End Role="Gender" EntitySet="Gender" />
- <End Role="User" EntitySet="User" />
- </AssociationSet>
- <AssociationSet Name="FK_User_Role" Association="Self.FK_User_Role">
- <End Role="Role" EntitySet="Role" />
- <End Role="User" EntitySet="User" />
- </AssociationSet>
- </EntityContainer>
- </Schema></edmx:StorageModels>
- <!-- CSDL content -->
- <edmx:ConceptualModels>
- <Schema Namespace="PracticeNBAModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
- <EntityType Name="ActionType">
- <Key>
- <PropertyRef Name="IdActionType" />
- </Key>
- <Property Name="IdActionType" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NameActionType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_ActionType" FromRole="ActionType" ToRole="MatchupLogs" />
- </EntityType>
- <EntityType Name="Conference">
- <Key>
- <PropertyRef Name="IdConference" />
- </Key>
- <Property Name="IdConference" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NameConference" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="Division" Relationship="Self.FK_Division_Conference" FromRole="Conference" ToRole="Division" />
- </EntityType>
- <EntityType Name="Country">
- <Key>
- <PropertyRef Name="IdCountry" />
- </Key>
- <Property Name="IdCountry" Type="Int32" Nullable="false" />
- <Property Name="NameCountry" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="CodeCountry" Type="String" MaxLength="3" FixedLength="true" Unicode="false" />
- <NavigationProperty Name="Player" Relationship="Self.FK_Player_Country" FromRole="Country" ToRole="Player" />
- </EntityType>
- <EntityType Name="Department">
- <Key>
- <PropertyRef Name="IdDepartment" />
- </Key>
- <Property Name="IdDepartment" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NameDepartment" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="IdOrganization" Type="Int32" />
- <NavigationProperty Name="Organization" Relationship="Self.FK_Department_Organization" FromRole="Department" ToRole="Organization" />
- </EntityType>
- <EntityType Name="Division">
- <Key>
- <PropertyRef Name="IdDivision" />
- </Key>
- <Property Name="IdDivision" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NameDivision" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="IdConference" Type="Int32" />
- <NavigationProperty Name="Conference" Relationship="Self.FK_Division_Conference" FromRole="Division" ToRole="Conference" />
- <NavigationProperty Name="Team" Relationship="Self.FK_Team_Division" FromRole="Division" ToRole="Team" />
- </EntityType>
- <EntityType Name="Gender">
- <Key>
- <PropertyRef Name="IdGender" />
- </Key>
- <Property Name="IdGender" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NameGender" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="Player" Relationship="Self.FK_Player_Gender" FromRole="Gender" ToRole="Player" />
- <NavigationProperty Name="User" Relationship="Self.FK_User_Gender" FromRole="Gender" ToRole="User" />
- </EntityType>
- <EntityType Name="Image">
- <Key>
- <PropertyRef Name="IdImage" />
- </Key>
- <Property Name="IdImage" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Image1" Type="Binary" MaxLength="Max" FixedLength="false" Nullable="false" />
- <Property Name="Description" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="NumberOfLikes" Type="Int32" />
- <Property Name="CreateTime" Type="DateTime" Precision="3" />
- </EntityType>
- <EntityType Name="Matchup">
- <Key>
- <PropertyRef Name="IdMatchup" />
- </Key>
- <Property Name="IdMatchup" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdSeason" Type="Int32" />
- <Property Name="IdMatchupType" Type="Int32" />
- <Property Name="IdTeamAway" Type="Int32" />
- <Property Name="IdTeamHome" Type="Int32" />
- <Property Name="Starttime" Type="DateTime" Precision="3" />
- <Property Name="TeamAwayScore" Type="Int32" />
- <Property Name="TeamHomeScore" Type="Int32" />
- <Property Name="Location" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
- <Property Name="IdStatus" Type="Int32" />
- <NavigationProperty Name="MatchupType" Relationship="Self.FK_Matchup_MatchupType" FromRole="Matchup" ToRole="MatchupType" />
- <NavigationProperty Name="Season" Relationship="Self.FK_Matchup_Season" FromRole="Matchup" ToRole="Season" />
- <NavigationProperty Name="Status" Relationship="Self.FK_Matchup_Status" FromRole="Matchup" ToRole="Status" />
- <NavigationProperty Name="Team" Relationship="Self.FK_Matchup_Team" FromRole="Matchup" ToRole="Team" />
- <NavigationProperty Name="Team1" Relationship="Self.FK_Matchup_Team1" FromRole="Matchup" ToRole="Team" />
- <NavigationProperty Name="MatchupDetail" Relationship="Self.FK_MatchupDetail_Matchup" FromRole="Matchup" ToRole="MatchupDetail" />
- <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_Matchup" FromRole="Matchup" ToRole="MatchupLogs" />
- </EntityType>
- <EntityType Name="MatchupDetail">
- <Key>
- <PropertyRef Name="IdMatchupDetail" />
- </Key>
- <Property Name="IdMatchupDetail" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdMatchup" Type="Int32" />
- <Property Name="IdQuarter" Type="Int32" />
- <Property Name="TeamAwayScore" Type="Int32" />
- <Property Name="TeamHomeScore" Type="Int32" />
- <NavigationProperty Name="Matchup" Relationship="Self.FK_MatchupDetail_Matchup" FromRole="MatchupDetail" ToRole="Matchup" />
- <NavigationProperty Name="Quarter" Relationship="Self.FK_MatchupDetail_Quarter" FromRole="MatchupDetail" ToRole="Quarter" />
- </EntityType>
- <EntityType Name="MatchupLogs">
- <Key>
- <PropertyRef Name="IdMatchupLogs" />
- </Key>
- <Property Name="IdMatchupLogs" Type="Int32" Nullable="false" />
- <Property Name="IdMatchup" Type="Int32" />
- <Property Name="IdQuarter" Type="Int32" />
- <Property Name="OccurTime" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
- <Property Name="IdTeam" Type="Int32" />
- <Property Name="IdPlayer" Type="Int32" />
- <Property Name="IdActionType" Type="Int32" />
- <Property Name="Remark" Type="String" MaxLength="300" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="ActionType" Relationship="Self.FK_MatchupLogs_ActionType" FromRole="MatchupLogs" ToRole="ActionType" />
- <NavigationProperty Name="Matchup" Relationship="Self.FK_MatchupLogs_Matchup" FromRole="MatchupLogs" ToRole="Matchup" />
- <NavigationProperty Name="Player" Relationship="Self.FK_MatchupLogs_Player" FromRole="MatchupLogs" ToRole="Player" />
- <NavigationProperty Name="Quarter" Relationship="Self.FK_MatchupLogs_Quarter" FromRole="MatchupLogs" ToRole="Quarter" />
- <NavigationProperty Name="Team" Relationship="Self.FK_MatchupLogs_Team" FromRole="MatchupLogs" ToRole="Team" />
- </EntityType>
- <EntityType Name="MatchupType">
- <Key>
- <PropertyRef Name="IdMatchupType" />
- </Key>
- <Property Name="IdMatchupType" Type="Int32" Nullable="false" />
- <Property Name="NameMatchupType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="Matchup" Relationship="Self.FK_Matchup_MatchupType" FromRole="MatchupType" ToRole="Matchup" />
- </EntityType>
- <EntityType Name="Organization">
- <Key>
- <PropertyRef Name="IdOrganization" />
- </Key>
- <Property Name="IdOrganization" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="OrganizationName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="Info" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
- <Property Name="IdStatusOrganization" Type="Int32" />
- <NavigationProperty Name="Department" Relationship="Self.FK_Department_Organization" FromRole="Organization" ToRole="Department" />
- <NavigationProperty Name="StatusOrganization" Relationship="Self.FK_Organization_StatusOrganization" FromRole="Organization" ToRole="StatusOrganization" />
- </EntityType>
- <EntityType Name="Player">
- <Key>
- <PropertyRef Name="IdPlayer" />
- </Key>
- <Property Name="IdPlayer" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Surename" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="Patronymic" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="IdPosition" Type="Int32" />
- <Property Name="JoinYear" Type="DateTime" Precision="0" />
- <Property Name="IdGender" Type="Int32" />
- <Property Name="Height" Type="Decimal" Precision="10" Scale="2" />
- <Property Name="Weight" Type="Decimal" Precision="10" Scale="2" />
- <Property Name="DateOfBirth" Type="DateTime" Precision="0" />
- <Property Name="College" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="Email" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="IdCountry" Type="Int32" />
- <Property Name="IsRetiment" Type="Boolean" />
- <Property Name="RetirmentTime" Type="DateTime" Precision="0" />
- <Property Name="Image" Type="Binary" MaxLength="Max" FixedLength="false" />
- <NavigationProperty Name="Country" Relationship="Self.FK_Player_Country" FromRole="Player" ToRole="Country" />
- <NavigationProperty Name="Gender" Relationship="Self.FK_Player_Gender" FromRole="Player" ToRole="Gender" />
- <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_Player" FromRole="Player" ToRole="MatchupLogs" />
- <NavigationProperty Name="Position" Relationship="Self.FK_Player_Position" FromRole="Player" ToRole="Position" />
- <NavigationProperty Name="PlayerInTeam" Relationship="Self.FK_PlayerInTeam_Player" FromRole="Player" ToRole="PlayerInTeam" />
- <NavigationProperty Name="PlayerStatistic" Relationship="Self.FK_PlayerStatistic_Player" FromRole="Player" ToRole="PlayerStatistic" />
- </EntityType>
- <EntityType Name="PlayerInTeam">
- <Key>
- <PropertyRef Name="IdPlayerInTeam" />
- </Key>
- <Property Name="IdPlayerInTeam" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdPlayer" Type="Int32" />
- <Property Name="IdTeam" Type="Int32" />
- <Property Name="IdSeason" Type="Int32" />
- <Property Name="ShirtNumber" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
- <Property Name="Salary" Type="Decimal" Precision="10" Scale="2" />
- <Property Name="StarterIndex" Type="Int32" />
- <NavigationProperty Name="Player" Relationship="Self.FK_PlayerInTeam_Player" FromRole="PlayerInTeam" ToRole="Player" />
- <NavigationProperty Name="Season" Relationship="Self.FK_PlayerInTeam_Season" FromRole="PlayerInTeam" ToRole="Season" />
- <NavigationProperty Name="Team" Relationship="Self.FK_PlayerInTeam_Team" FromRole="PlayerInTeam" ToRole="Team" />
- </EntityType>
- <EntityType Name="PlayerStatistic">
- <Key>
- <PropertyRef Name="IdPlayerStatistic" />
- </Key>
- <Property Name="IdPlayerStatistic" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdMatchup" Type="Int32" />
- <Property Name="IdTeam" Type="Int32" />
- <Property Name="IdPlayer" Type="Int32" />
- <Property Name="IsStarting" Type="Int32" />
- <Property Name="Min" Type="Decimal" Precision="10" Scale="2" />
- <Property Name="Point" Type="Int32" />
- <Property Name="Assist" Type="Int32" />
- <Property Name="FieldGoalMade" Type="Int32" />
- <Property Name="FieldGoalMissed" Type="Int32" />
- <Property Name="ThreePointFieldGoalMade" Type="Int32" />
- <Property Name="ThreePointFieldGoalMissed" Type="Int32" />
- <Property Name="FreeThrowMade" Type="Int32" />
- <Property Name="FreeThrowMissed" Type="Int32" />
- <Property Name="Rebound" Type="Int32" />
- <Property Name="OFFR" Type="Int32" />
- <Property Name="DFFR" Type="Int32" />
- <Property Name="Steal" Type="Int32" />
- <Property Name="Block" Type="Int32" />
- <Property Name="Turnover" Type="Int32" />
- <Property Name="Foul" Type="Int32" />
- <NavigationProperty Name="Player" Relationship="Self.FK_PlayerStatistic_Player" FromRole="PlayerStatistic" ToRole="Player" />
- <NavigationProperty Name="Team" Relationship="Self.FK_PlayerStatistic_Team" FromRole="PlayerStatistic" ToRole="Team" />
- </EntityType>
- <EntityType Name="Position">
- <Key>
- <PropertyRef Name="IdPosition" />
- </Key>
- <Property Name="IdPosition" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NamePosition" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="Abbr" Type="String" MaxLength="3" FixedLength="true" Unicode="false" />
- <NavigationProperty Name="Player" Relationship="Self.FK_Player_Position" FromRole="Position" ToRole="Player" />
- </EntityType>
- <EntityType Name="PostSeason">
- <Key>
- <PropertyRef Name="IdPostSeason" />
- </Key>
- <Property Name="IdPostSeason" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdSeason" Type="Int32" />
- <Property Name="IdTeam" Type="Int32" />
- <Property Name="Rank" Type="Int32" />
- <NavigationProperty Name="Season" Relationship="Self.FK_PostSeason_Season" FromRole="PostSeason" ToRole="Season" />
- <NavigationProperty Name="Team" Relationship="Self.FK_PostSeason_Team" FromRole="PostSeason" ToRole="Team" />
- </EntityType>
- <EntityType Name="Quarter">
- <Key>
- <PropertyRef Name="IdQuarter" />
- </Key>
- <Property Name="IdQuarter" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NameQuarter" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="MatchupDetail" Relationship="Self.FK_MatchupDetail_Quarter" FromRole="Quarter" ToRole="MatchupDetail" />
- <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_Quarter" FromRole="Quarter" ToRole="MatchupLogs" />
- </EntityType>
- <EntityType Name="Role">
- <Key>
- <PropertyRef Name="IdRole" />
- </Key>
- <Property Name="IdRole" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="RoleName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="User" Relationship="Self.FK_User_Role" FromRole="Role" ToRole="User" />
- </EntityType>
- <EntityType Name="Season">
- <Key>
- <PropertyRef Name="IdSeason" />
- </Key>
- <Property Name="IdSeason" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NameSeason" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="Matchup" Relationship="Self.FK_Matchup_Season" FromRole="Season" ToRole="Matchup" />
- <NavigationProperty Name="PlayerInTeam" Relationship="Self.FK_PlayerInTeam_Season" FromRole="Season" ToRole="PlayerInTeam" />
- <NavigationProperty Name="PostSeason" Relationship="Self.FK_PostSeason_Season" FromRole="Season" ToRole="PostSeason" />
- </EntityType>
- <EntityType Name="Status">
- <Key>
- <PropertyRef Name="IdStatus" />
- </Key>
- <Property Name="IdStatus" Type="Int32" Nullable="false" />
- <Property Name="NameStatus" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="Matchup" Relationship="Self.FK_Matchup_Status" FromRole="Status" ToRole="Matchup" />
- </EntityType>
- <EntityType Name="StatusOrganization">
- <Key>
- <PropertyRef Name="IdStatusOrganization" />
- </Key>
- <Property Name="IdStatusOrganization" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NameStatusOrganization" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <NavigationProperty Name="Organization" Relationship="Self.FK_Organization_StatusOrganization" FromRole="StatusOrganization" ToRole="Organization" />
- </EntityType>
- <EntityType Name="sysdiagrams">
- <Key>
- <PropertyRef Name="diagram_id" />
- </Key>
- <Property Name="name" Type="String" MaxLength="128" FixedLength="false" Unicode="true" Nullable="false" />
- <Property Name="principal_id" Type="Int32" Nullable="false" />
- <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="version" Type="Int32" />
- <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
- </EntityType>
- <EntityType Name="Team">
- <Key>
- <PropertyRef Name="IdTeam" />
- </Key>
- <Property Name="IdTeam" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="TeamName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="IdDivision" Type="Int32" />
- <Property Name="Couch" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="Abbr" Type="String" MaxLength="3" FixedLength="true" Unicode="false" />
- <Property Name="Stadium" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
- <Property Name="Logo" Type="Binary" MaxLength="Max" FixedLength="false" />
- <NavigationProperty Name="Division" Relationship="Self.FK_Team_Division" FromRole="Team" ToRole="Division" />
- <NavigationProperty Name="Matchup" Relationship="Self.FK_Matchup_Team" FromRole="Team" ToRole="Matchup" />
- <NavigationProperty Name="Matchup1" Relationship="Self.FK_Matchup_Team1" FromRole="Team" ToRole="Matchup" />
- <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_Team" FromRole="Team" ToRole="MatchupLogs" />
- <NavigationProperty Name="PlayerInTeam" Relationship="Self.FK_PlayerInTeam_Team" FromRole="Team" ToRole="PlayerInTeam" />
- <NavigationProperty Name="PlayerStatistic" Relationship="Self.FK_PlayerStatistic_Team" FromRole="Team" ToRole="PlayerStatistic" />
- <NavigationProperty Name="PostSeason" Relationship="Self.FK_PostSeason_Team" FromRole="Team" ToRole="PostSeason" />
- </EntityType>
- <EntityType Name="User">
- <Key>
- <PropertyRef Name="IdUser" />
- </Key>
- <Property Name="IdUser" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Surename" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="Patronymic" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="LoginName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
- <Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="IdGender" Type="Int32" />
- <Property Name="DateOfBirth" Type="DateTime" Precision="0" />
- <Property Name="Phone" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
- <Property Name="Email" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="IdRole" Type="Int32" />
- <NavigationProperty Name="Gender" Relationship="Self.FK_User_Gender" FromRole="User" ToRole="Gender" />
- <NavigationProperty Name="Role" Relationship="Self.FK_User_Role" FromRole="User" ToRole="Role" />
- </EntityType>
- <Association Name="FK_MatchupLogs_ActionType">
- <End Role="ActionType" Type="Self.ActionType" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="ActionType">
- <PropertyRef Name="IdActionType" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdActionType" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Division_Conference">
- <End Role="Conference" Type="Self.Conference" Multiplicity="0..1" />
- <End Role="Division" Type="Self.Division" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Conference">
- <PropertyRef Name="IdConference" />
- </Principal>
- <Dependent Role="Division">
- <PropertyRef Name="IdConference" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Player_Country">
- <End Role="Country" Type="Self.Country" Multiplicity="0..1" />
- <End Role="Player" Type="Self.Player" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Country">
- <PropertyRef Name="IdCountry" />
- </Principal>
- <Dependent Role="Player">
- <PropertyRef Name="IdCountry" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Department_Organization">
- <End Role="Organization" Type="Self.Organization" Multiplicity="0..1" />
- <End Role="Department" Type="Self.Department" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Organization">
- <PropertyRef Name="IdOrganization" />
- </Principal>
- <Dependent Role="Department">
- <PropertyRef Name="IdOrganization" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Team_Division">
- <End Role="Division" Type="Self.Division" Multiplicity="0..1" />
- <End Role="Team" Type="Self.Team" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Division">
- <PropertyRef Name="IdDivision" />
- </Principal>
- <Dependent Role="Team">
- <PropertyRef Name="IdDivision" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Player_Gender">
- <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
- <End Role="Player" Type="Self.Player" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Gender">
- <PropertyRef Name="IdGender" />
- </Principal>
- <Dependent Role="Player">
- <PropertyRef Name="IdGender" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_User_Gender">
- <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
- <End Role="User" Type="Self.User" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Gender">
- <PropertyRef Name="IdGender" />
- </Principal>
- <Dependent Role="User">
- <PropertyRef Name="IdGender" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_MatchupType">
- <End Role="MatchupType" Type="Self.MatchupType" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="MatchupType">
- <PropertyRef Name="IdMatchupType" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdMatchupType" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_Season">
- <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Season">
- <PropertyRef Name="IdSeason" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdSeason" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_Status">
- <End Role="Status" Type="Self.Status" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Status">
- <PropertyRef Name="IdStatus" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdStatus" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdTeamAway" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Matchup_Team1">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="Matchup">
- <PropertyRef Name="IdTeamHome" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupDetail_Matchup">
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="0..1" />
- <End Role="MatchupDetail" Type="Self.MatchupDetail" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Matchup">
- <PropertyRef Name="IdMatchup" />
- </Principal>
- <Dependent Role="MatchupDetail">
- <PropertyRef Name="IdMatchup" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupLogs_Matchup">
- <End Role="Matchup" Type="Self.Matchup" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Matchup">
- <PropertyRef Name="IdMatchup" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdMatchup" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupDetail_Quarter">
- <End Role="Quarter" Type="Self.Quarter" Multiplicity="0..1" />
- <End Role="MatchupDetail" Type="Self.MatchupDetail" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Quarter">
- <PropertyRef Name="IdQuarter" />
- </Principal>
- <Dependent Role="MatchupDetail">
- <PropertyRef Name="IdQuarter" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupLogs_Player">
- <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Player">
- <PropertyRef Name="IdPlayer" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdPlayer" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupLogs_Quarter">
- <End Role="Quarter" Type="Self.Quarter" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Quarter">
- <PropertyRef Name="IdQuarter" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdQuarter" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_MatchupLogs_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="MatchupLogs">
- <PropertyRef Name="IdTeam" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Organization_StatusOrganization">
- <End Role="StatusOrganization" Type="Self.StatusOrganization" Multiplicity="0..1" />
- <End Role="Organization" Type="Self.Organization" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="StatusOrganization">
- <PropertyRef Name="IdStatusOrganization" />
- </Principal>
- <Dependent Role="Organization">
- <PropertyRef Name="IdStatusOrganization" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_Player_Position">
- <End Role="Position" Type="Self.Position" Multiplicity="0..1" />
- <End Role="Player" Type="Self.Player" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Position">
- <PropertyRef Name="IdPosition" />
- </Principal>
- <Dependent Role="Player">
- <PropertyRef Name="IdPosition" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerInTeam_Player">
- <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
- <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Player">
- <PropertyRef Name="IdPlayer" />
- </Principal>
- <Dependent Role="PlayerInTeam">
- <PropertyRef Name="IdPlayer" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerStatistic_Player">
- <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
- <End Role="PlayerStatistic" Type="Self.PlayerStatistic" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Player">
- <PropertyRef Name="IdPlayer" />
- </Principal>
- <Dependent Role="PlayerStatistic">
- <PropertyRef Name="IdPlayer" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerInTeam_Season">
- <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
- <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Season">
- <PropertyRef Name="IdSeason" />
- </Principal>
- <Dependent Role="PlayerInTeam">
- <PropertyRef Name="IdSeason" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerInTeam_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="PlayerInTeam">
- <PropertyRef Name="IdTeam" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PlayerStatistic_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="PlayerStatistic" Type="Self.PlayerStatistic" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="PlayerStatistic">
- <PropertyRef Name="IdTeam" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PostSeason_Season">
- <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
- <End Role="PostSeason" Type="Self.PostSeason" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Season">
- <PropertyRef Name="IdSeason" />
- </Principal>
- <Dependent Role="PostSeason">
- <PropertyRef Name="IdSeason" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_PostSeason_Team">
- <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
- <End Role="PostSeason" Type="Self.PostSeason" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Team">
- <PropertyRef Name="IdTeam" />
- </Principal>
- <Dependent Role="PostSeason">
- <PropertyRef Name="IdTeam" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_User_Role">
- <End Role="Role" Type="Self.Role" Multiplicity="0..1" />
- <End Role="User" Type="Self.User" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Role">
- <PropertyRef Name="IdRole" />
- </Principal>
- <Dependent Role="User">
- <PropertyRef Name="IdRole" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <EntityContainer Name="PracticeNBAEntities" annotation:LazyLoadingEnabled="true">
- <EntitySet Name="ActionType" EntityType="Self.ActionType" />
- <EntitySet Name="Conference" EntityType="Self.Conference" />
- <EntitySet Name="Country" EntityType="Self.Country" />
- <EntitySet Name="Department" EntityType="Self.Department" />
- <EntitySet Name="Division" EntityType="Self.Division" />
- <EntitySet Name="Gender" EntityType="Self.Gender" />
- <EntitySet Name="Image" EntityType="Self.Image" />
- <EntitySet Name="Matchup" EntityType="Self.Matchup" />
- <EntitySet Name="MatchupDetail" EntityType="Self.MatchupDetail" />
- <EntitySet Name="MatchupLogs" EntityType="Self.MatchupLogs" />
- <EntitySet Name="MatchupType" EntityType="Self.MatchupType" />
- <EntitySet Name="Organization" EntityType="Self.Organization" />
- <EntitySet Name="Player" EntityType="Self.Player" />
- <EntitySet Name="PlayerInTeam" EntityType="Self.PlayerInTeam" />
- <EntitySet Name="PlayerStatistic" EntityType="Self.PlayerStatistic" />
- <EntitySet Name="Position" EntityType="Self.Position" />
- <EntitySet Name="PostSeason" EntityType="Self.PostSeason" />
- <EntitySet Name="Quarter" EntityType="Self.Quarter" />
- <EntitySet Name="Role" EntityType="Self.Role" />
- <EntitySet Name="Season" EntityType="Self.Season" />
- <EntitySet Name="Status" EntityType="Self.Status" />
- <EntitySet Name="StatusOrganization" EntityType="Self.StatusOrganization" />
- <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" />
- <EntitySet Name="Team" EntityType="Self.Team" />
- <EntitySet Name="User" EntityType="Self.User" />
- <AssociationSet Name="FK_MatchupLogs_ActionType" Association="Self.FK_MatchupLogs_ActionType">
- <End Role="ActionType" EntitySet="ActionType" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_Division_Conference" Association="Self.FK_Division_Conference">
- <End Role="Conference" EntitySet="Conference" />
- <End Role="Division" EntitySet="Division" />
- </AssociationSet>
- <AssociationSet Name="FK_Player_Country" Association="Self.FK_Player_Country">
- <End Role="Country" EntitySet="Country" />
- <End Role="Player" EntitySet="Player" />
- </AssociationSet>
- <AssociationSet Name="FK_Department_Organization" Association="Self.FK_Department_Organization">
- <End Role="Organization" EntitySet="Organization" />
- <End Role="Department" EntitySet="Department" />
- </AssociationSet>
- <AssociationSet Name="FK_Team_Division" Association="Self.FK_Team_Division">
- <End Role="Division" EntitySet="Division" />
- <End Role="Team" EntitySet="Team" />
- </AssociationSet>
- <AssociationSet Name="FK_Player_Gender" Association="Self.FK_Player_Gender">
- <End Role="Gender" EntitySet="Gender" />
- <End Role="Player" EntitySet="Player" />
- </AssociationSet>
- <AssociationSet Name="FK_User_Gender" Association="Self.FK_User_Gender">
- <End Role="Gender" EntitySet="Gender" />
- <End Role="User" EntitySet="User" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_MatchupType" Association="Self.FK_Matchup_MatchupType">
- <End Role="MatchupType" EntitySet="MatchupType" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_Season" Association="Self.FK_Matchup_Season">
- <End Role="Season" EntitySet="Season" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_Status" Association="Self.FK_Matchup_Status">
- <End Role="Status" EntitySet="Status" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_Team" Association="Self.FK_Matchup_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_Matchup_Team1" Association="Self.FK_Matchup_Team1">
- <End Role="Team" EntitySet="Team" />
- <End Role="Matchup" EntitySet="Matchup" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupDetail_Matchup" Association="Self.FK_MatchupDetail_Matchup">
- <End Role="Matchup" EntitySet="Matchup" />
- <End Role="MatchupDetail" EntitySet="MatchupDetail" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupLogs_Matchup" Association="Self.FK_MatchupLogs_Matchup">
- <End Role="Matchup" EntitySet="Matchup" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupDetail_Quarter" Association="Self.FK_MatchupDetail_Quarter">
- <End Role="Quarter" EntitySet="Quarter" />
- <End Role="MatchupDetail" EntitySet="MatchupDetail" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupLogs_Player" Association="Self.FK_MatchupLogs_Player">
- <End Role="Player" EntitySet="Player" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupLogs_Quarter" Association="Self.FK_MatchupLogs_Quarter">
- <End Role="Quarter" EntitySet="Quarter" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_MatchupLogs_Team" Association="Self.FK_MatchupLogs_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="MatchupLogs" EntitySet="MatchupLogs" />
- </AssociationSet>
- <AssociationSet Name="FK_Organization_StatusOrganization" Association="Self.FK_Organization_StatusOrganization">
- <End Role="StatusOrganization" EntitySet="StatusOrganization" />
- <End Role="Organization" EntitySet="Organization" />
- </AssociationSet>
- <AssociationSet Name="FK_Player_Position" Association="Self.FK_Player_Position">
- <End Role="Position" EntitySet="Position" />
- <End Role="Player" EntitySet="Player" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerInTeam_Player" Association="Self.FK_PlayerInTeam_Player">
- <End Role="Player" EntitySet="Player" />
- <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerStatistic_Player" Association="Self.FK_PlayerStatistic_Player">
- <End Role="Player" EntitySet="Player" />
- <End Role="PlayerStatistic" EntitySet="PlayerStatistic" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerInTeam_Season" Association="Self.FK_PlayerInTeam_Season">
- <End Role="Season" EntitySet="Season" />
- <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerInTeam_Team" Association="Self.FK_PlayerInTeam_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
- </AssociationSet>
- <AssociationSet Name="FK_PlayerStatistic_Team" Association="Self.FK_PlayerStatistic_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="PlayerStatistic" EntitySet="PlayerStatistic" />
- </AssociationSet>
- <AssociationSet Name="FK_PostSeason_Season" Association="Self.FK_PostSeason_Season">
- <End Role="Season" EntitySet="Season" />
- <End Role="PostSeason" EntitySet="PostSeason" />
- </AssociationSet>
- <AssociationSet Name="FK_PostSeason_Team" Association="Self.FK_PostSeason_Team">
- <End Role="Team" EntitySet="Team" />
- <End Role="PostSeason" EntitySet="PostSeason" />
- </AssociationSet>
- <AssociationSet Name="FK_User_Role" Association="Self.FK_User_Role">
- <End Role="Role" EntitySet="Role" />
- <End Role="User" EntitySet="User" />
- </AssociationSet>
- </EntityContainer>
- </Schema>
- </edmx:ConceptualModels>
- <!-- C-S mapping content -->
- <edmx:Mappings>
- <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
- <EntityContainerMapping StorageEntityContainer="Хранилище PracticeNBAModelContainer" CdmEntityContainer="PracticeNBAEntities">
- <EntitySetMapping Name="ActionType">
- <EntityTypeMapping TypeName="PracticeNBAModel.ActionType">
- <MappingFragment StoreEntitySet="ActionType">
- <ScalarProperty Name="IdActionType" ColumnName="IdActionType" />
- <ScalarProperty Name="NameActionType" ColumnName="NameActionType" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Conference">
- <EntityTypeMapping TypeName="PracticeNBAModel.Conference">
- <MappingFragment StoreEntitySet="Conference">
- <ScalarProperty Name="IdConference" ColumnName="IdConference" />
- <ScalarProperty Name="NameConference" ColumnName="NameConference" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Country">
- <EntityTypeMapping TypeName="PracticeNBAModel.Country">
- <MappingFragment StoreEntitySet="Country">
- <ScalarProperty Name="IdCountry" ColumnName="IdCountry" />
- <ScalarProperty Name="NameCountry" ColumnName="NameCountry" />
- <ScalarProperty Name="CodeCountry" ColumnName="CodeCountry" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Department">
- <EntityTypeMapping TypeName="PracticeNBAModel.Department">
- <MappingFragment StoreEntitySet="Department">
- <ScalarProperty Name="IdDepartment" ColumnName="IdDepartment" />
- <ScalarProperty Name="NameDepartment" ColumnName="NameDepartment" />
- <ScalarProperty Name="IdOrganization" ColumnName="IdOrganization" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Division">
- <EntityTypeMapping TypeName="PracticeNBAModel.Division">
- <MappingFragment StoreEntitySet="Division">
- <ScalarProperty Name="IdDivision" ColumnName="IdDivision" />
- <ScalarProperty Name="NameDivision" ColumnName="NameDivision" />
- <ScalarProperty Name="IdConference" ColumnName="IdConference" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Gender">
- <EntityTypeMapping TypeName="PracticeNBAModel.Gender">
- <MappingFragment StoreEntitySet="Gender">
- <ScalarProperty Name="IdGender" ColumnName="IdGender" />
- <ScalarProperty Name="NameGender" ColumnName="NameGender" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Image">
- <EntityTypeMapping TypeName="PracticeNBAModel.Image">
- <MappingFragment StoreEntitySet="Image">
- <ScalarProperty Name="IdImage" ColumnName="IdImage" />
- <ScalarProperty Name="Image1" ColumnName="Image" />
- <ScalarProperty Name="Description" ColumnName="Description" />
- <ScalarProperty Name="NumberOfLikes" ColumnName="NumberOfLikes" />
- <ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Matchup">
- <EntityTypeMapping TypeName="PracticeNBAModel.Matchup">
- <MappingFragment StoreEntitySet="Matchup">
- <ScalarProperty Name="IdMatchup" ColumnName="IdMatchup" />
- <ScalarProperty Name="IdSeason" ColumnName="IdSeason" />
- <ScalarProperty Name="IdMatchupType" ColumnName="IdMatchupType" />
- <ScalarProperty Name="IdTeamAway" ColumnName="IdTeamAway" />
- <ScalarProperty Name="IdTeamHome" ColumnName="IdTeamHome" />
- <ScalarProperty Name="Starttime" ColumnName="Starttime" />
- <ScalarProperty Name="TeamAwayScore" ColumnName="TeamAwayScore" />
- <ScalarProperty Name="TeamHomeScore" ColumnName="TeamHomeScore" />
- <ScalarProperty Name="Location" ColumnName="Location" />
- <ScalarProperty Name="IdStatus" ColumnName="IdStatus" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="MatchupDetail">
- <EntityTypeMapping TypeName="PracticeNBAModel.MatchupDetail">
- <MappingFragment StoreEntitySet="MatchupDetail">
- <ScalarProperty Name="IdMatchupDetail" ColumnName="IdMatchupDetail" />
- <ScalarProperty Name="IdMatchup" ColumnName="IdMatchup" />
- <ScalarProperty Name="IdQuarter" ColumnName="IdQuarter" />
- <ScalarProperty Name="TeamAwayScore" ColumnName="TeamAwayScore" />
- <ScalarProperty Name="TeamHomeScore" ColumnName="TeamHomeScore" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="MatchupLogs">
- <EntityTypeMapping TypeName="PracticeNBAModel.MatchupLogs">
- <MappingFragment StoreEntitySet="MatchupLogs">
- <ScalarProperty Name="IdMatchupLogs" ColumnName="IdMatchupLogs" />
- <ScalarProperty Name="IdMatchup" ColumnName="IdMatchup" />
- <ScalarProperty Name="IdQuarter" ColumnName="IdQuarter" />
- <ScalarProperty Name="OccurTime" ColumnName="OccurTime" />
- <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
- <ScalarProperty Name="IdPlayer" ColumnName="IdPlayer" />
- <ScalarProperty Name="IdActionType" ColumnName="IdActionType" />
- <ScalarProperty Name="Remark" ColumnName="Remark" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="MatchupType">
- <EntityTypeMapping TypeName="PracticeNBAModel.MatchupType">
- <MappingFragment StoreEntitySet="MatchupType">
- <ScalarProperty Name="IdMatchupType" ColumnName="IdMatchupType" />
- <ScalarProperty Name="NameMatchupType" ColumnName="NameMatchupType" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Organization">
- <EntityTypeMapping TypeName="PracticeNBAModel.Organization">
- <MappingFragment StoreEntitySet="Organization">
- <ScalarProperty Name="IdOrganization" ColumnName="IdOrganization" />
- <ScalarProperty Name="OrganizationName" ColumnName="OrganizationName" />
- <ScalarProperty Name="Info" ColumnName="Info" />
- <ScalarProperty Name="IdStatusOrganization" ColumnName="IdStatusOrganization" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Player">
- <EntityTypeMapping TypeName="PracticeNBAModel.Player">
- <MappingFragment StoreEntitySet="Player">
- <ScalarProperty Name="IdPlayer" ColumnName="IdPlayer" />
- <ScalarProperty Name="Surename" ColumnName="Surename" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
- <ScalarProperty Name="IdPosition" ColumnName="IdPosition" />
- <ScalarProperty Name="JoinYear" ColumnName="JoinYear" />
- <ScalarProperty Name="IdGender" ColumnName="IdGender" />
- <ScalarProperty Name="Height" ColumnName="Height" />
- <ScalarProperty Name="Weight" ColumnName="Weight" />
- <ScalarProperty Name="DateOfBirth" ColumnName="DateOfBirth" />
- <ScalarProperty Name="College" ColumnName="College" />
- <ScalarProperty Name="Email" ColumnName="Email" />
- <ScalarProperty Name="IdCountry" ColumnName="IdCountry" />
- <ScalarProperty Name="IsRetiment" ColumnName="IsRetiment" />
- <ScalarProperty Name="RetirmentTime" ColumnName="RetirmentTime" />
- <ScalarProperty Name="Image" ColumnName="Image" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="PlayerInTeam">
- <EntityTypeMapping TypeName="PracticeNBAModel.PlayerInTeam">
- <MappingFragment StoreEntitySet="PlayerInTeam">
- <ScalarProperty Name="IdPlayerInTeam" ColumnName="IdPlayerInTeam" />
- <ScalarProperty Name="IdPlayer" ColumnName="IdPlayer" />
- <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
- <ScalarProperty Name="IdSeason" ColumnName="IdSeason" />
- <ScalarProperty Name="ShirtNumber" ColumnName="ShirtNumber" />
- <ScalarProperty Name="Salary" ColumnName="Salary" />
- <ScalarProperty Name="StarterIndex" ColumnName="StarterIndex" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="PlayerStatistic">
- <EntityTypeMapping TypeName="PracticeNBAModel.PlayerStatistic">
- <MappingFragment StoreEntitySet="PlayerStatistic">
- <ScalarProperty Name="IdPlayerStatistic" ColumnName="IdPlayerStatistic" />
- <ScalarProperty Name="IdMatchup" ColumnName="IdMatchup" />
- <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
- <ScalarProperty Name="IdPlayer" ColumnName="IdPlayer" />
- <ScalarProperty Name="IsStarting" ColumnName="IsStarting" />
- <ScalarProperty Name="Min" ColumnName="Min" />
- <ScalarProperty Name="Point" ColumnName="Point" />
- <ScalarProperty Name="Assist" ColumnName="Assist" />
- <ScalarProperty Name="FieldGoalMade" ColumnName="FieldGoalMade" />
- <ScalarProperty Name="FieldGoalMissed" ColumnName="FieldGoalMissed" />
- <ScalarProperty Name="ThreePointFieldGoalMade" ColumnName="ThreePointFieldGoalMade" />
- <ScalarProperty Name="ThreePointFieldGoalMissed" ColumnName="ThreePointFieldGoalMissed" />
- <ScalarProperty Name="FreeThrowMade" ColumnName="FreeThrowMade" />
- <ScalarProperty Name="FreeThrowMissed" ColumnName="FreeThrowMissed" />
- <ScalarProperty Name="Rebound" ColumnName="Rebound" />
- <ScalarProperty Name="OFFR" ColumnName="OFFR" />
- <ScalarProperty Name="DFFR" ColumnName="DFFR" />
- <ScalarProperty Name="Steal" ColumnName="Steal" />
- <ScalarProperty Name="Block" ColumnName="Block" />
- <ScalarProperty Name="Turnover" ColumnName="Turnover" />
- <ScalarProperty Name="Foul" ColumnName="Foul" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Position">
- <EntityTypeMapping TypeName="PracticeNBAModel.Position">
- <MappingFragment StoreEntitySet="Position">
- <ScalarProperty Name="IdPosition" ColumnName="IdPosition" />
- <ScalarProperty Name="NamePosition" ColumnName="NamePosition" />
- <ScalarProperty Name="Abbr" ColumnName="Abbr" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="PostSeason">
- <EntityTypeMapping TypeName="PracticeNBAModel.PostSeason">
- <MappingFragment StoreEntitySet="PostSeason">
- <ScalarProperty Name="IdPostSeason" ColumnName="IdPostSeason" />
- <ScalarProperty Name="IdSeason" ColumnName="IdSeason" />
- <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
- <ScalarProperty Name="Rank" ColumnName="Rank" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Quarter">
- <EntityTypeMapping TypeName="PracticeNBAModel.Quarter">
- <MappingFragment StoreEntitySet="Quarter">
- <ScalarProperty Name="IdQuarter" ColumnName="IdQuarter" />
- <ScalarProperty Name="NameQuarter" ColumnName="NameQuarter" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Role">
- <EntityTypeMapping TypeName="PracticeNBAModel.Role">
- <MappingFragment StoreEntitySet="Role">
- <ScalarProperty Name="IdRole" ColumnName="IdRole" />
- <ScalarProperty Name="RoleName" ColumnName="RoleName" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Season">
- <EntityTypeMapping TypeName="PracticeNBAModel.Season">
- <MappingFragment StoreEntitySet="Season">
- <ScalarProperty Name="IdSeason" ColumnName="IdSeason" />
- <ScalarProperty Name="NameSeason" ColumnName="NameSeason" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Status">
- <EntityTypeMapping TypeName="PracticeNBAModel.Status">
- <MappingFragment StoreEntitySet="Status">
- <ScalarProperty Name="IdStatus" ColumnName="IdStatus" />
- <ScalarProperty Name="NameStatus" ColumnName="NameStatus" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="StatusOrganization">
- <EntityTypeMapping TypeName="PracticeNBAModel.StatusOrganization">
- <MappingFragment StoreEntitySet="StatusOrganization">
- <ScalarProperty Name="IdStatusOrganization" ColumnName="IdStatusOrganization" />
- <ScalarProperty Name="NameStatusOrganization" ColumnName="NameStatusOrganization" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="sysdiagrams">
- <EntityTypeMapping TypeName="PracticeNBAModel.sysdiagrams">
- <MappingFragment StoreEntitySet="sysdiagrams">
- <ScalarProperty Name="name" ColumnName="name" />
- <ScalarProperty Name="principal_id" ColumnName="principal_id" />
- <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
- <ScalarProperty Name="version" ColumnName="version" />
- <ScalarProperty Name="definition" ColumnName="definition" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Team">
- <EntityTypeMapping TypeName="PracticeNBAModel.Team">
- <MappingFragment StoreEntitySet="Team">
- <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
- <ScalarProperty Name="TeamName" ColumnName="TeamName" />
- <ScalarProperty Name="IdDivision" ColumnName="IdDivision" />
- <ScalarProperty Name="Couch" ColumnName="Couch" />
- <ScalarProperty Name="Abbr" ColumnName="Abbr" />
- <ScalarProperty Name="Stadium" ColumnName="Stadium" />
- <ScalarProperty Name="Logo" ColumnName="Logo" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="User">
- <EntityTypeMapping TypeName="PracticeNBAModel.User">
- <MappingFragment StoreEntitySet="User">
- <ScalarProperty Name="IdUser" ColumnName="IdUser" />
- <ScalarProperty Name="Surename" ColumnName="Surename" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
- <ScalarProperty Name="LoginName" ColumnName="LoginName" />
- <ScalarProperty Name="Password" ColumnName="Password" />
- <ScalarProperty Name="IdGender" ColumnName="IdGender" />
- <ScalarProperty Name="DateOfBirth" ColumnName="DateOfBirth" />
- <ScalarProperty Name="Phone" ColumnName="Phone" />
- <ScalarProperty Name="Email" ColumnName="Email" />
- <ScalarProperty Name="IdRole" ColumnName="IdRole" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- </EntityContainerMapping>
- </Mapping>
- </edmx:Mappings>
- </edmx:Runtime>
- <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
- <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
- <Connection>
- <DesignerInfoPropertySet>
- <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
- </DesignerInfoPropertySet>
- </Connection>
- <Options>
- <DesignerInfoPropertySet>
- <DesignerProperty Name="ValidateOnBuild" Value="true" />
- <DesignerProperty Name="EnablePluralization" Value="false" />
- <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
- <DesignerProperty Name="UseLegacyProvider" Value="false" />
- <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
- </DesignerInfoPropertySet>
- </Options>
- <!-- Diagram content (shape and connector positions) -->
- <Diagrams></Diagrams>
- </Designer>
- </edmx:Edmx>
|