NBAshka.edmx 97 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  3. <!-- EF Runtime content -->
  4. <edmx:Runtime>
  5. <!-- SSDL content -->
  6. <edmx:StorageModels>
  7. <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">
  8. <EntityType Name="ActionType">
  9. <Key>
  10. <PropertyRef Name="IdActionType" />
  11. </Key>
  12. <Property Name="IdActionType" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="NameActionType" Type="varchar" MaxLength="50" />
  14. </EntityType>
  15. <EntityType Name="Conference">
  16. <Key>
  17. <PropertyRef Name="IdConference" />
  18. </Key>
  19. <Property Name="IdConference" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  20. <Property Name="NameConference" Type="varchar" MaxLength="50" />
  21. </EntityType>
  22. <EntityType Name="Country">
  23. <Key>
  24. <PropertyRef Name="IdCountry" />
  25. </Key>
  26. <Property Name="IdCountry" Type="int" Nullable="false" />
  27. <Property Name="NameCountry" Type="varchar" MaxLength="50" />
  28. <Property Name="CodeCountry" Type="char" MaxLength="3" />
  29. </EntityType>
  30. <EntityType Name="Department">
  31. <Key>
  32. <PropertyRef Name="IdDepartment" />
  33. </Key>
  34. <Property Name="IdDepartment" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  35. <Property Name="NameDepartment" Type="varchar" MaxLength="50" />
  36. <Property Name="IdOrganization" Type="int" />
  37. </EntityType>
  38. <EntityType Name="Division">
  39. <Key>
  40. <PropertyRef Name="IdDivision" />
  41. </Key>
  42. <Property Name="IdDivision" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  43. <Property Name="NameDivision" Type="varchar" MaxLength="50" />
  44. <Property Name="IdConference" Type="int" />
  45. </EntityType>
  46. <EntityType Name="Gender">
  47. <Key>
  48. <PropertyRef Name="IdGender" />
  49. </Key>
  50. <Property Name="IdGender" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  51. <Property Name="NameGender" Type="varchar" MaxLength="50" />
  52. </EntityType>
  53. <EntityType Name="Image">
  54. <Key>
  55. <PropertyRef Name="IdImage" />
  56. </Key>
  57. <Property Name="IdImage" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  58. <Property Name="Image" Type="varbinary(max)" Nullable="false" />
  59. <Property Name="Description" Type="varchar" MaxLength="50" />
  60. <Property Name="NumberOfLikes" Type="int" />
  61. <Property Name="CreateTime" Type="datetime" />
  62. </EntityType>
  63. <EntityType Name="Matchup">
  64. <Key>
  65. <PropertyRef Name="IdMatchup" />
  66. </Key>
  67. <Property Name="IdMatchup" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  68. <Property Name="IdSeason" Type="int" />
  69. <Property Name="IdMatchupType" Type="int" />
  70. <Property Name="IdTeamAway" Type="int" />
  71. <Property Name="IdTeamHome" Type="int" />
  72. <Property Name="Starttime" Type="datetime" />
  73. <Property Name="TeamAwayScore" Type="int" />
  74. <Property Name="TeamHomeScore" Type="int" />
  75. <Property Name="Location" Type="varchar" MaxLength="200" />
  76. <Property Name="IdStatus" Type="int" />
  77. </EntityType>
  78. <EntityType Name="MatchupDetail">
  79. <Key>
  80. <PropertyRef Name="IdMatchupDetail" />
  81. </Key>
  82. <Property Name="IdMatchupDetail" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  83. <Property Name="IdMatchup" Type="int" />
  84. <Property Name="IdQuarter" Type="int" />
  85. <Property Name="TeamAwayScore" Type="int" />
  86. <Property Name="TeamHomeScore" Type="int" />
  87. </EntityType>
  88. <EntityType Name="MatchupLogs">
  89. <Key>
  90. <PropertyRef Name="IdMatchupLogs" />
  91. </Key>
  92. <Property Name="IdMatchupLogs" Type="int" Nullable="false" />
  93. <Property Name="IdMatchup" Type="int" />
  94. <Property Name="IdQuarter" Type="int" />
  95. <Property Name="OccurTime" Type="varchar" MaxLength="10" />
  96. <Property Name="IdTeam" Type="int" />
  97. <Property Name="IdPlayer" Type="int" />
  98. <Property Name="IdActionType" Type="int" />
  99. <Property Name="Remark" Type="varchar" MaxLength="300" />
  100. </EntityType>
  101. <EntityType Name="MatchupType">
  102. <Key>
  103. <PropertyRef Name="IdMatchupType" />
  104. </Key>
  105. <Property Name="IdMatchupType" Type="int" Nullable="false" />
  106. <Property Name="NameMatchupType" Type="varchar" MaxLength="50" />
  107. </EntityType>
  108. <EntityType Name="Organization">
  109. <Key>
  110. <PropertyRef Name="IdOrganization" />
  111. </Key>
  112. <Property Name="IdOrganization" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  113. <Property Name="OrganizationName" Type="varchar" MaxLength="50" />
  114. <Property Name="Info" Type="text" />
  115. <Property Name="IdStatusOrganization" Type="int" />
  116. </EntityType>
  117. <EntityType Name="Player">
  118. <Key>
  119. <PropertyRef Name="IdPlayer" />
  120. </Key>
  121. <Property Name="IdPlayer" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  122. <Property Name="Surename" Type="varchar" MaxLength="50" />
  123. <Property Name="Name" Type="varchar" MaxLength="50" />
  124. <Property Name="Patronymic" Type="varchar" MaxLength="50" />
  125. <Property Name="IdPosition" Type="int" />
  126. <Property Name="JoinYear" Type="date" />
  127. <Property Name="IdGender" Type="int" />
  128. <Property Name="Height" Type="decimal" Precision="10" Scale="2" />
  129. <Property Name="Weight" Type="decimal" Precision="10" Scale="2" />
  130. <Property Name="DateOfBirth" Type="date" />
  131. <Property Name="College" Type="varchar" MaxLength="50" />
  132. <Property Name="Email" Type="varchar" MaxLength="50" />
  133. <Property Name="IdCountry" Type="int" />
  134. <Property Name="IsRetiment" Type="bit" />
  135. <Property Name="RetirmentTime" Type="date" />
  136. <Property Name="Image" Type="image" />
  137. </EntityType>
  138. <EntityType Name="PlayerInTeam">
  139. <Key>
  140. <PropertyRef Name="IdPlayerInTeam" />
  141. </Key>
  142. <Property Name="IdPlayerInTeam" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  143. <Property Name="IdPlayer" Type="int" />
  144. <Property Name="IdTeam" Type="int" />
  145. <Property Name="IdSeason" Type="int" />
  146. <Property Name="ShirtNumber" Type="varchar" MaxLength="10" />
  147. <Property Name="Salary" Type="decimal" Precision="10" Scale="2" />
  148. <Property Name="StarterIndex" Type="int" />
  149. </EntityType>
  150. <EntityType Name="PlayerStatistic">
  151. <Key>
  152. <PropertyRef Name="IdPlayerStatistic" />
  153. </Key>
  154. <Property Name="IdPlayerStatistic" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  155. <Property Name="IdMatchup" Type="int" />
  156. <Property Name="IdTeam" Type="int" />
  157. <Property Name="IdPlayer" Type="int" />
  158. <Property Name="IsStarting" Type="int" />
  159. <Property Name="Min" Type="decimal" Precision="10" Scale="2" />
  160. <Property Name="Point" Type="int" />
  161. <Property Name="Assist" Type="int" />
  162. <Property Name="FieldGoalMade" Type="int" />
  163. <Property Name="FieldGoalMissed" Type="int" />
  164. <Property Name="ThreePointFieldGoalMade" Type="int" />
  165. <Property Name="ThreePointFieldGoalMissed" Type="int" />
  166. <Property Name="FreeThrowMade" Type="int" />
  167. <Property Name="FreeThrowMissed" Type="int" />
  168. <Property Name="Rebound" Type="int" />
  169. <Property Name="OFFR" Type="int" />
  170. <Property Name="DFFR" Type="int" />
  171. <Property Name="Steal" Type="int" />
  172. <Property Name="Block" Type="int" />
  173. <Property Name="Turnover" Type="int" />
  174. <Property Name="Foul" Type="int" />
  175. </EntityType>
  176. <EntityType Name="Position">
  177. <Key>
  178. <PropertyRef Name="IdPosition" />
  179. </Key>
  180. <Property Name="IdPosition" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  181. <Property Name="NamePosition" Type="varchar" MaxLength="50" />
  182. <Property Name="Abbr" Type="char" MaxLength="3" />
  183. </EntityType>
  184. <EntityType Name="PostSeason">
  185. <Key>
  186. <PropertyRef Name="IdPostSeason" />
  187. </Key>
  188. <Property Name="IdPostSeason" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  189. <Property Name="IdSeason" Type="int" />
  190. <Property Name="IdTeam" Type="int" />
  191. <Property Name="Rank" Type="int" />
  192. </EntityType>
  193. <EntityType Name="Quarter">
  194. <Key>
  195. <PropertyRef Name="IdQuarter" />
  196. </Key>
  197. <Property Name="IdQuarter" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  198. <Property Name="NameQuarter" Type="varchar" MaxLength="50" />
  199. </EntityType>
  200. <EntityType Name="Role">
  201. <Key>
  202. <PropertyRef Name="IdRole" />
  203. </Key>
  204. <Property Name="IdRole" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  205. <Property Name="RoleName" Type="varchar" MaxLength="50" />
  206. </EntityType>
  207. <EntityType Name="Season">
  208. <Key>
  209. <PropertyRef Name="IdSeason" />
  210. </Key>
  211. <Property Name="IdSeason" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  212. <Property Name="NameSeason" Type="varchar" MaxLength="50" />
  213. </EntityType>
  214. <EntityType Name="Status">
  215. <Key>
  216. <PropertyRef Name="IdStatus" />
  217. </Key>
  218. <Property Name="IdStatus" Type="int" Nullable="false" />
  219. <Property Name="NameStatus" Type="varchar" MaxLength="50" />
  220. </EntityType>
  221. <EntityType Name="StatusOrganization">
  222. <Key>
  223. <PropertyRef Name="IdStatusOrganization" />
  224. </Key>
  225. <Property Name="IdStatusOrganization" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  226. <Property Name="NameStatusOrganization" Type="varchar" MaxLength="50" />
  227. </EntityType>
  228. <EntityType Name="sysdiagrams">
  229. <Key>
  230. <PropertyRef Name="diagram_id" />
  231. </Key>
  232. <Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
  233. <Property Name="principal_id" Type="int" Nullable="false" />
  234. <Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  235. <Property Name="version" Type="int" />
  236. <Property Name="definition" Type="varbinary(max)" />
  237. </EntityType>
  238. <EntityType Name="Team">
  239. <Key>
  240. <PropertyRef Name="IdTeam" />
  241. </Key>
  242. <Property Name="IdTeam" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  243. <Property Name="TeamName" Type="varchar" MaxLength="50" />
  244. <Property Name="IdDivision" Type="int" />
  245. <Property Name="Couch" Type="varchar" MaxLength="50" />
  246. <Property Name="Abbr" Type="char" MaxLength="3" />
  247. <Property Name="Stadium" Type="varchar" MaxLength="100" />
  248. <Property Name="Logo" Type="image" />
  249. </EntityType>
  250. <EntityType Name="User">
  251. <Key>
  252. <PropertyRef Name="IdUser" />
  253. </Key>
  254. <Property Name="IdUser" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  255. <Property Name="Surename" Type="varchar" MaxLength="50" />
  256. <Property Name="Name" Type="varchar" MaxLength="50" />
  257. <Property Name="Patronymic" Type="varchar" MaxLength="50" />
  258. <Property Name="LoginName" Type="varchar" MaxLength="100" />
  259. <Property Name="Password" Type="varchar" MaxLength="50" />
  260. <Property Name="IdGender" Type="int" />
  261. <Property Name="DateOfBirth" Type="date" />
  262. <Property Name="Phone" Type="varchar" MaxLength="20" />
  263. <Property Name="Email" Type="varchar" MaxLength="50" />
  264. <Property Name="IdRole" Type="int" />
  265. </EntityType>
  266. <Association Name="FK_Department_Organization">
  267. <End Role="Organization" Type="Self.Organization" Multiplicity="0..1" />
  268. <End Role="Department" Type="Self.Department" Multiplicity="*" />
  269. <ReferentialConstraint>
  270. <Principal Role="Organization">
  271. <PropertyRef Name="IdOrganization" />
  272. </Principal>
  273. <Dependent Role="Department">
  274. <PropertyRef Name="IdOrganization" />
  275. </Dependent>
  276. </ReferentialConstraint>
  277. </Association>
  278. <Association Name="FK_Division_Conference">
  279. <End Role="Conference" Type="Self.Conference" Multiplicity="0..1" />
  280. <End Role="Division" Type="Self.Division" Multiplicity="*" />
  281. <ReferentialConstraint>
  282. <Principal Role="Conference">
  283. <PropertyRef Name="IdConference" />
  284. </Principal>
  285. <Dependent Role="Division">
  286. <PropertyRef Name="IdConference" />
  287. </Dependent>
  288. </ReferentialConstraint>
  289. </Association>
  290. <Association Name="FK_Matchup_MatchupType">
  291. <End Role="MatchupType" Type="Self.MatchupType" Multiplicity="0..1" />
  292. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  293. <ReferentialConstraint>
  294. <Principal Role="MatchupType">
  295. <PropertyRef Name="IdMatchupType" />
  296. </Principal>
  297. <Dependent Role="Matchup">
  298. <PropertyRef Name="IdMatchupType" />
  299. </Dependent>
  300. </ReferentialConstraint>
  301. </Association>
  302. <Association Name="FK_Matchup_Season">
  303. <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
  304. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  305. <ReferentialConstraint>
  306. <Principal Role="Season">
  307. <PropertyRef Name="IdSeason" />
  308. </Principal>
  309. <Dependent Role="Matchup">
  310. <PropertyRef Name="IdSeason" />
  311. </Dependent>
  312. </ReferentialConstraint>
  313. </Association>
  314. <Association Name="FK_Matchup_Status">
  315. <End Role="Status" Type="Self.Status" Multiplicity="0..1" />
  316. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  317. <ReferentialConstraint>
  318. <Principal Role="Status">
  319. <PropertyRef Name="IdStatus" />
  320. </Principal>
  321. <Dependent Role="Matchup">
  322. <PropertyRef Name="IdStatus" />
  323. </Dependent>
  324. </ReferentialConstraint>
  325. </Association>
  326. <Association Name="FK_Matchup_Team">
  327. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  328. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  329. <ReferentialConstraint>
  330. <Principal Role="Team">
  331. <PropertyRef Name="IdTeam" />
  332. </Principal>
  333. <Dependent Role="Matchup">
  334. <PropertyRef Name="IdTeamAway" />
  335. </Dependent>
  336. </ReferentialConstraint>
  337. </Association>
  338. <Association Name="FK_Matchup_Team1">
  339. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  340. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  341. <ReferentialConstraint>
  342. <Principal Role="Team">
  343. <PropertyRef Name="IdTeam" />
  344. </Principal>
  345. <Dependent Role="Matchup">
  346. <PropertyRef Name="IdTeamHome" />
  347. </Dependent>
  348. </ReferentialConstraint>
  349. </Association>
  350. <Association Name="FK_MatchupDetail_Matchup">
  351. <End Role="Matchup" Type="Self.Matchup" Multiplicity="0..1" />
  352. <End Role="MatchupDetail" Type="Self.MatchupDetail" Multiplicity="*" />
  353. <ReferentialConstraint>
  354. <Principal Role="Matchup">
  355. <PropertyRef Name="IdMatchup" />
  356. </Principal>
  357. <Dependent Role="MatchupDetail">
  358. <PropertyRef Name="IdMatchup" />
  359. </Dependent>
  360. </ReferentialConstraint>
  361. </Association>
  362. <Association Name="FK_MatchupDetail_Quarter">
  363. <End Role="Quarter" Type="Self.Quarter" Multiplicity="0..1" />
  364. <End Role="MatchupDetail" Type="Self.MatchupDetail" Multiplicity="*" />
  365. <ReferentialConstraint>
  366. <Principal Role="Quarter">
  367. <PropertyRef Name="IdQuarter" />
  368. </Principal>
  369. <Dependent Role="MatchupDetail">
  370. <PropertyRef Name="IdQuarter" />
  371. </Dependent>
  372. </ReferentialConstraint>
  373. </Association>
  374. <Association Name="FK_MatchupLogs_ActionType">
  375. <End Role="ActionType" Type="Self.ActionType" Multiplicity="0..1" />
  376. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  377. <ReferentialConstraint>
  378. <Principal Role="ActionType">
  379. <PropertyRef Name="IdActionType" />
  380. </Principal>
  381. <Dependent Role="MatchupLogs">
  382. <PropertyRef Name="IdActionType" />
  383. </Dependent>
  384. </ReferentialConstraint>
  385. </Association>
  386. <Association Name="FK_MatchupLogs_Matchup">
  387. <End Role="Matchup" Type="Self.Matchup" Multiplicity="0..1" />
  388. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  389. <ReferentialConstraint>
  390. <Principal Role="Matchup">
  391. <PropertyRef Name="IdMatchup" />
  392. </Principal>
  393. <Dependent Role="MatchupLogs">
  394. <PropertyRef Name="IdMatchup" />
  395. </Dependent>
  396. </ReferentialConstraint>
  397. </Association>
  398. <Association Name="FK_MatchupLogs_Player">
  399. <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
  400. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  401. <ReferentialConstraint>
  402. <Principal Role="Player">
  403. <PropertyRef Name="IdPlayer" />
  404. </Principal>
  405. <Dependent Role="MatchupLogs">
  406. <PropertyRef Name="IdPlayer" />
  407. </Dependent>
  408. </ReferentialConstraint>
  409. </Association>
  410. <Association Name="FK_MatchupLogs_Quarter">
  411. <End Role="Quarter" Type="Self.Quarter" Multiplicity="0..1" />
  412. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  413. <ReferentialConstraint>
  414. <Principal Role="Quarter">
  415. <PropertyRef Name="IdQuarter" />
  416. </Principal>
  417. <Dependent Role="MatchupLogs">
  418. <PropertyRef Name="IdQuarter" />
  419. </Dependent>
  420. </ReferentialConstraint>
  421. </Association>
  422. <Association Name="FK_MatchupLogs_Team">
  423. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  424. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  425. <ReferentialConstraint>
  426. <Principal Role="Team">
  427. <PropertyRef Name="IdTeam" />
  428. </Principal>
  429. <Dependent Role="MatchupLogs">
  430. <PropertyRef Name="IdTeam" />
  431. </Dependent>
  432. </ReferentialConstraint>
  433. </Association>
  434. <Association Name="FK_Organization_StatusOrganization">
  435. <End Role="StatusOrganization" Type="Self.StatusOrganization" Multiplicity="0..1" />
  436. <End Role="Organization" Type="Self.Organization" Multiplicity="*" />
  437. <ReferentialConstraint>
  438. <Principal Role="StatusOrganization">
  439. <PropertyRef Name="IdStatusOrganization" />
  440. </Principal>
  441. <Dependent Role="Organization">
  442. <PropertyRef Name="IdStatusOrganization" />
  443. </Dependent>
  444. </ReferentialConstraint>
  445. </Association>
  446. <Association Name="FK_Player_Country">
  447. <End Role="Country" Type="Self.Country" Multiplicity="0..1" />
  448. <End Role="Player" Type="Self.Player" Multiplicity="*" />
  449. <ReferentialConstraint>
  450. <Principal Role="Country">
  451. <PropertyRef Name="IdCountry" />
  452. </Principal>
  453. <Dependent Role="Player">
  454. <PropertyRef Name="IdCountry" />
  455. </Dependent>
  456. </ReferentialConstraint>
  457. </Association>
  458. <Association Name="FK_Player_Gender">
  459. <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
  460. <End Role="Player" Type="Self.Player" Multiplicity="*" />
  461. <ReferentialConstraint>
  462. <Principal Role="Gender">
  463. <PropertyRef Name="IdGender" />
  464. </Principal>
  465. <Dependent Role="Player">
  466. <PropertyRef Name="IdGender" />
  467. </Dependent>
  468. </ReferentialConstraint>
  469. </Association>
  470. <Association Name="FK_Player_Position">
  471. <End Role="Position" Type="Self.Position" Multiplicity="0..1" />
  472. <End Role="Player" Type="Self.Player" Multiplicity="*" />
  473. <ReferentialConstraint>
  474. <Principal Role="Position">
  475. <PropertyRef Name="IdPosition" />
  476. </Principal>
  477. <Dependent Role="Player">
  478. <PropertyRef Name="IdPosition" />
  479. </Dependent>
  480. </ReferentialConstraint>
  481. </Association>
  482. <Association Name="FK_PlayerInTeam_Player">
  483. <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
  484. <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
  485. <ReferentialConstraint>
  486. <Principal Role="Player">
  487. <PropertyRef Name="IdPlayer" />
  488. </Principal>
  489. <Dependent Role="PlayerInTeam">
  490. <PropertyRef Name="IdPlayer" />
  491. </Dependent>
  492. </ReferentialConstraint>
  493. </Association>
  494. <Association Name="FK_PlayerInTeam_Season">
  495. <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
  496. <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
  497. <ReferentialConstraint>
  498. <Principal Role="Season">
  499. <PropertyRef Name="IdSeason" />
  500. </Principal>
  501. <Dependent Role="PlayerInTeam">
  502. <PropertyRef Name="IdSeason" />
  503. </Dependent>
  504. </ReferentialConstraint>
  505. </Association>
  506. <Association Name="FK_PlayerInTeam_Team">
  507. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  508. <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
  509. <ReferentialConstraint>
  510. <Principal Role="Team">
  511. <PropertyRef Name="IdTeam" />
  512. </Principal>
  513. <Dependent Role="PlayerInTeam">
  514. <PropertyRef Name="IdTeam" />
  515. </Dependent>
  516. </ReferentialConstraint>
  517. </Association>
  518. <Association Name="FK_PlayerStatistic_Player">
  519. <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
  520. <End Role="PlayerStatistic" Type="Self.PlayerStatistic" Multiplicity="*" />
  521. <ReferentialConstraint>
  522. <Principal Role="Player">
  523. <PropertyRef Name="IdPlayer" />
  524. </Principal>
  525. <Dependent Role="PlayerStatistic">
  526. <PropertyRef Name="IdPlayer" />
  527. </Dependent>
  528. </ReferentialConstraint>
  529. </Association>
  530. <Association Name="FK_PlayerStatistic_Team">
  531. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  532. <End Role="PlayerStatistic" Type="Self.PlayerStatistic" Multiplicity="*" />
  533. <ReferentialConstraint>
  534. <Principal Role="Team">
  535. <PropertyRef Name="IdTeam" />
  536. </Principal>
  537. <Dependent Role="PlayerStatistic">
  538. <PropertyRef Name="IdTeam" />
  539. </Dependent>
  540. </ReferentialConstraint>
  541. </Association>
  542. <Association Name="FK_PostSeason_Season">
  543. <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
  544. <End Role="PostSeason" Type="Self.PostSeason" Multiplicity="*" />
  545. <ReferentialConstraint>
  546. <Principal Role="Season">
  547. <PropertyRef Name="IdSeason" />
  548. </Principal>
  549. <Dependent Role="PostSeason">
  550. <PropertyRef Name="IdSeason" />
  551. </Dependent>
  552. </ReferentialConstraint>
  553. </Association>
  554. <Association Name="FK_PostSeason_Team">
  555. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  556. <End Role="PostSeason" Type="Self.PostSeason" Multiplicity="*" />
  557. <ReferentialConstraint>
  558. <Principal Role="Team">
  559. <PropertyRef Name="IdTeam" />
  560. </Principal>
  561. <Dependent Role="PostSeason">
  562. <PropertyRef Name="IdTeam" />
  563. </Dependent>
  564. </ReferentialConstraint>
  565. </Association>
  566. <Association Name="FK_Team_Division">
  567. <End Role="Division" Type="Self.Division" Multiplicity="0..1" />
  568. <End Role="Team" Type="Self.Team" Multiplicity="*" />
  569. <ReferentialConstraint>
  570. <Principal Role="Division">
  571. <PropertyRef Name="IdDivision" />
  572. </Principal>
  573. <Dependent Role="Team">
  574. <PropertyRef Name="IdDivision" />
  575. </Dependent>
  576. </ReferentialConstraint>
  577. </Association>
  578. <Association Name="FK_User_Gender">
  579. <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
  580. <End Role="User" Type="Self.User" Multiplicity="*" />
  581. <ReferentialConstraint>
  582. <Principal Role="Gender">
  583. <PropertyRef Name="IdGender" />
  584. </Principal>
  585. <Dependent Role="User">
  586. <PropertyRef Name="IdGender" />
  587. </Dependent>
  588. </ReferentialConstraint>
  589. </Association>
  590. <Association Name="FK_User_Role">
  591. <End Role="Role" Type="Self.Role" Multiplicity="0..1" />
  592. <End Role="User" Type="Self.User" Multiplicity="*" />
  593. <ReferentialConstraint>
  594. <Principal Role="Role">
  595. <PropertyRef Name="IdRole" />
  596. </Principal>
  597. <Dependent Role="User">
  598. <PropertyRef Name="IdRole" />
  599. </Dependent>
  600. </ReferentialConstraint>
  601. </Association>
  602. <EntityContainer Name="Хранилище PracticeNBAModelContainer">
  603. <EntitySet Name="ActionType" EntityType="Self.ActionType" Schema="dbo" store:Type="Tables" />
  604. <EntitySet Name="Conference" EntityType="Self.Conference" Schema="dbo" store:Type="Tables" />
  605. <EntitySet Name="Country" EntityType="Self.Country" Schema="dbo" store:Type="Tables" />
  606. <EntitySet Name="Department" EntityType="Self.Department" Schema="dbo" store:Type="Tables" />
  607. <EntitySet Name="Division" EntityType="Self.Division" Schema="dbo" store:Type="Tables" />
  608. <EntitySet Name="Gender" EntityType="Self.Gender" Schema="dbo" store:Type="Tables" />
  609. <EntitySet Name="Image" EntityType="Self.Image" Schema="dbo" store:Type="Tables" />
  610. <EntitySet Name="Matchup" EntityType="Self.Matchup" Schema="dbo" store:Type="Tables" />
  611. <EntitySet Name="MatchupDetail" EntityType="Self.MatchupDetail" Schema="dbo" store:Type="Tables" />
  612. <EntitySet Name="MatchupLogs" EntityType="Self.MatchupLogs" Schema="dbo" store:Type="Tables" />
  613. <EntitySet Name="MatchupType" EntityType="Self.MatchupType" Schema="dbo" store:Type="Tables" />
  614. <EntitySet Name="Organization" EntityType="Self.Organization" Schema="dbo" store:Type="Tables" />
  615. <EntitySet Name="Player" EntityType="Self.Player" Schema="dbo" store:Type="Tables" />
  616. <EntitySet Name="PlayerInTeam" EntityType="Self.PlayerInTeam" Schema="dbo" store:Type="Tables" />
  617. <EntitySet Name="PlayerStatistic" EntityType="Self.PlayerStatistic" Schema="dbo" store:Type="Tables" />
  618. <EntitySet Name="Position" EntityType="Self.Position" Schema="dbo" store:Type="Tables" />
  619. <EntitySet Name="PostSeason" EntityType="Self.PostSeason" Schema="dbo" store:Type="Tables" />
  620. <EntitySet Name="Quarter" EntityType="Self.Quarter" Schema="dbo" store:Type="Tables" />
  621. <EntitySet Name="Role" EntityType="Self.Role" Schema="dbo" store:Type="Tables" />
  622. <EntitySet Name="Season" EntityType="Self.Season" Schema="dbo" store:Type="Tables" />
  623. <EntitySet Name="Status" EntityType="Self.Status" Schema="dbo" store:Type="Tables" />
  624. <EntitySet Name="StatusOrganization" EntityType="Self.StatusOrganization" Schema="dbo" store:Type="Tables" />
  625. <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
  626. <EntitySet Name="Team" EntityType="Self.Team" Schema="dbo" store:Type="Tables" />
  627. <EntitySet Name="User" EntityType="Self.User" Schema="dbo" store:Type="Tables" />
  628. <AssociationSet Name="FK_Department_Organization" Association="Self.FK_Department_Organization">
  629. <End Role="Organization" EntitySet="Organization" />
  630. <End Role="Department" EntitySet="Department" />
  631. </AssociationSet>
  632. <AssociationSet Name="FK_Division_Conference" Association="Self.FK_Division_Conference">
  633. <End Role="Conference" EntitySet="Conference" />
  634. <End Role="Division" EntitySet="Division" />
  635. </AssociationSet>
  636. <AssociationSet Name="FK_Matchup_MatchupType" Association="Self.FK_Matchup_MatchupType">
  637. <End Role="MatchupType" EntitySet="MatchupType" />
  638. <End Role="Matchup" EntitySet="Matchup" />
  639. </AssociationSet>
  640. <AssociationSet Name="FK_Matchup_Season" Association="Self.FK_Matchup_Season">
  641. <End Role="Season" EntitySet="Season" />
  642. <End Role="Matchup" EntitySet="Matchup" />
  643. </AssociationSet>
  644. <AssociationSet Name="FK_Matchup_Status" Association="Self.FK_Matchup_Status">
  645. <End Role="Status" EntitySet="Status" />
  646. <End Role="Matchup" EntitySet="Matchup" />
  647. </AssociationSet>
  648. <AssociationSet Name="FK_Matchup_Team" Association="Self.FK_Matchup_Team">
  649. <End Role="Team" EntitySet="Team" />
  650. <End Role="Matchup" EntitySet="Matchup" />
  651. </AssociationSet>
  652. <AssociationSet Name="FK_Matchup_Team1" Association="Self.FK_Matchup_Team1">
  653. <End Role="Team" EntitySet="Team" />
  654. <End Role="Matchup" EntitySet="Matchup" />
  655. </AssociationSet>
  656. <AssociationSet Name="FK_MatchupDetail_Matchup" Association="Self.FK_MatchupDetail_Matchup">
  657. <End Role="Matchup" EntitySet="Matchup" />
  658. <End Role="MatchupDetail" EntitySet="MatchupDetail" />
  659. </AssociationSet>
  660. <AssociationSet Name="FK_MatchupDetail_Quarter" Association="Self.FK_MatchupDetail_Quarter">
  661. <End Role="Quarter" EntitySet="Quarter" />
  662. <End Role="MatchupDetail" EntitySet="MatchupDetail" />
  663. </AssociationSet>
  664. <AssociationSet Name="FK_MatchupLogs_ActionType" Association="Self.FK_MatchupLogs_ActionType">
  665. <End Role="ActionType" EntitySet="ActionType" />
  666. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  667. </AssociationSet>
  668. <AssociationSet Name="FK_MatchupLogs_Matchup" Association="Self.FK_MatchupLogs_Matchup">
  669. <End Role="Matchup" EntitySet="Matchup" />
  670. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  671. </AssociationSet>
  672. <AssociationSet Name="FK_MatchupLogs_Player" Association="Self.FK_MatchupLogs_Player">
  673. <End Role="Player" EntitySet="Player" />
  674. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  675. </AssociationSet>
  676. <AssociationSet Name="FK_MatchupLogs_Quarter" Association="Self.FK_MatchupLogs_Quarter">
  677. <End Role="Quarter" EntitySet="Quarter" />
  678. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  679. </AssociationSet>
  680. <AssociationSet Name="FK_MatchupLogs_Team" Association="Self.FK_MatchupLogs_Team">
  681. <End Role="Team" EntitySet="Team" />
  682. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  683. </AssociationSet>
  684. <AssociationSet Name="FK_Organization_StatusOrganization" Association="Self.FK_Organization_StatusOrganization">
  685. <End Role="StatusOrganization" EntitySet="StatusOrganization" />
  686. <End Role="Organization" EntitySet="Organization" />
  687. </AssociationSet>
  688. <AssociationSet Name="FK_Player_Country" Association="Self.FK_Player_Country">
  689. <End Role="Country" EntitySet="Country" />
  690. <End Role="Player" EntitySet="Player" />
  691. </AssociationSet>
  692. <AssociationSet Name="FK_Player_Gender" Association="Self.FK_Player_Gender">
  693. <End Role="Gender" EntitySet="Gender" />
  694. <End Role="Player" EntitySet="Player" />
  695. </AssociationSet>
  696. <AssociationSet Name="FK_Player_Position" Association="Self.FK_Player_Position">
  697. <End Role="Position" EntitySet="Position" />
  698. <End Role="Player" EntitySet="Player" />
  699. </AssociationSet>
  700. <AssociationSet Name="FK_PlayerInTeam_Player" Association="Self.FK_PlayerInTeam_Player">
  701. <End Role="Player" EntitySet="Player" />
  702. <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
  703. </AssociationSet>
  704. <AssociationSet Name="FK_PlayerInTeam_Season" Association="Self.FK_PlayerInTeam_Season">
  705. <End Role="Season" EntitySet="Season" />
  706. <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
  707. </AssociationSet>
  708. <AssociationSet Name="FK_PlayerInTeam_Team" Association="Self.FK_PlayerInTeam_Team">
  709. <End Role="Team" EntitySet="Team" />
  710. <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
  711. </AssociationSet>
  712. <AssociationSet Name="FK_PlayerStatistic_Player" Association="Self.FK_PlayerStatistic_Player">
  713. <End Role="Player" EntitySet="Player" />
  714. <End Role="PlayerStatistic" EntitySet="PlayerStatistic" />
  715. </AssociationSet>
  716. <AssociationSet Name="FK_PlayerStatistic_Team" Association="Self.FK_PlayerStatistic_Team">
  717. <End Role="Team" EntitySet="Team" />
  718. <End Role="PlayerStatistic" EntitySet="PlayerStatistic" />
  719. </AssociationSet>
  720. <AssociationSet Name="FK_PostSeason_Season" Association="Self.FK_PostSeason_Season">
  721. <End Role="Season" EntitySet="Season" />
  722. <End Role="PostSeason" EntitySet="PostSeason" />
  723. </AssociationSet>
  724. <AssociationSet Name="FK_PostSeason_Team" Association="Self.FK_PostSeason_Team">
  725. <End Role="Team" EntitySet="Team" />
  726. <End Role="PostSeason" EntitySet="PostSeason" />
  727. </AssociationSet>
  728. <AssociationSet Name="FK_Team_Division" Association="Self.FK_Team_Division">
  729. <End Role="Division" EntitySet="Division" />
  730. <End Role="Team" EntitySet="Team" />
  731. </AssociationSet>
  732. <AssociationSet Name="FK_User_Gender" Association="Self.FK_User_Gender">
  733. <End Role="Gender" EntitySet="Gender" />
  734. <End Role="User" EntitySet="User" />
  735. </AssociationSet>
  736. <AssociationSet Name="FK_User_Role" Association="Self.FK_User_Role">
  737. <End Role="Role" EntitySet="Role" />
  738. <End Role="User" EntitySet="User" />
  739. </AssociationSet>
  740. </EntityContainer>
  741. </Schema></edmx:StorageModels>
  742. <!-- CSDL content -->
  743. <edmx:ConceptualModels>
  744. <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">
  745. <EntityType Name="ActionType">
  746. <Key>
  747. <PropertyRef Name="IdActionType" />
  748. </Key>
  749. <Property Name="IdActionType" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  750. <Property Name="NameActionType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  751. <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_ActionType" FromRole="ActionType" ToRole="MatchupLogs" />
  752. </EntityType>
  753. <EntityType Name="Conference">
  754. <Key>
  755. <PropertyRef Name="IdConference" />
  756. </Key>
  757. <Property Name="IdConference" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  758. <Property Name="NameConference" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  759. <NavigationProperty Name="Division" Relationship="Self.FK_Division_Conference" FromRole="Conference" ToRole="Division" />
  760. </EntityType>
  761. <EntityType Name="Country">
  762. <Key>
  763. <PropertyRef Name="IdCountry" />
  764. </Key>
  765. <Property Name="IdCountry" Type="Int32" Nullable="false" />
  766. <Property Name="NameCountry" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  767. <Property Name="CodeCountry" Type="String" MaxLength="3" FixedLength="true" Unicode="false" />
  768. <NavigationProperty Name="Player" Relationship="Self.FK_Player_Country" FromRole="Country" ToRole="Player" />
  769. </EntityType>
  770. <EntityType Name="Department">
  771. <Key>
  772. <PropertyRef Name="IdDepartment" />
  773. </Key>
  774. <Property Name="IdDepartment" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  775. <Property Name="NameDepartment" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  776. <Property Name="IdOrganization" Type="Int32" />
  777. <NavigationProperty Name="Organization" Relationship="Self.FK_Department_Organization" FromRole="Department" ToRole="Organization" />
  778. </EntityType>
  779. <EntityType Name="Division">
  780. <Key>
  781. <PropertyRef Name="IdDivision" />
  782. </Key>
  783. <Property Name="IdDivision" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  784. <Property Name="NameDivision" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  785. <Property Name="IdConference" Type="Int32" />
  786. <NavigationProperty Name="Conference" Relationship="Self.FK_Division_Conference" FromRole="Division" ToRole="Conference" />
  787. <NavigationProperty Name="Team" Relationship="Self.FK_Team_Division" FromRole="Division" ToRole="Team" />
  788. </EntityType>
  789. <EntityType Name="Gender">
  790. <Key>
  791. <PropertyRef Name="IdGender" />
  792. </Key>
  793. <Property Name="IdGender" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  794. <Property Name="NameGender" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  795. <NavigationProperty Name="Player" Relationship="Self.FK_Player_Gender" FromRole="Gender" ToRole="Player" />
  796. <NavigationProperty Name="User" Relationship="Self.FK_User_Gender" FromRole="Gender" ToRole="User" />
  797. </EntityType>
  798. <EntityType Name="Image">
  799. <Key>
  800. <PropertyRef Name="IdImage" />
  801. </Key>
  802. <Property Name="IdImage" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  803. <Property Name="Image1" Type="Binary" MaxLength="Max" FixedLength="false" Nullable="false" />
  804. <Property Name="Description" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  805. <Property Name="NumberOfLikes" Type="Int32" />
  806. <Property Name="CreateTime" Type="DateTime" Precision="3" />
  807. </EntityType>
  808. <EntityType Name="Matchup">
  809. <Key>
  810. <PropertyRef Name="IdMatchup" />
  811. </Key>
  812. <Property Name="IdMatchup" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  813. <Property Name="IdSeason" Type="Int32" />
  814. <Property Name="IdMatchupType" Type="Int32" />
  815. <Property Name="IdTeamAway" Type="Int32" />
  816. <Property Name="IdTeamHome" Type="Int32" />
  817. <Property Name="Starttime" Type="DateTime" Precision="3" />
  818. <Property Name="TeamAwayScore" Type="Int32" />
  819. <Property Name="TeamHomeScore" Type="Int32" />
  820. <Property Name="Location" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
  821. <Property Name="IdStatus" Type="Int32" />
  822. <NavigationProperty Name="MatchupType" Relationship="Self.FK_Matchup_MatchupType" FromRole="Matchup" ToRole="MatchupType" />
  823. <NavigationProperty Name="Season" Relationship="Self.FK_Matchup_Season" FromRole="Matchup" ToRole="Season" />
  824. <NavigationProperty Name="Status" Relationship="Self.FK_Matchup_Status" FromRole="Matchup" ToRole="Status" />
  825. <NavigationProperty Name="Team" Relationship="Self.FK_Matchup_Team" FromRole="Matchup" ToRole="Team" />
  826. <NavigationProperty Name="Team1" Relationship="Self.FK_Matchup_Team1" FromRole="Matchup" ToRole="Team" />
  827. <NavigationProperty Name="MatchupDetail" Relationship="Self.FK_MatchupDetail_Matchup" FromRole="Matchup" ToRole="MatchupDetail" />
  828. <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_Matchup" FromRole="Matchup" ToRole="MatchupLogs" />
  829. </EntityType>
  830. <EntityType Name="MatchupDetail">
  831. <Key>
  832. <PropertyRef Name="IdMatchupDetail" />
  833. </Key>
  834. <Property Name="IdMatchupDetail" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  835. <Property Name="IdMatchup" Type="Int32" />
  836. <Property Name="IdQuarter" Type="Int32" />
  837. <Property Name="TeamAwayScore" Type="Int32" />
  838. <Property Name="TeamHomeScore" Type="Int32" />
  839. <NavigationProperty Name="Matchup" Relationship="Self.FK_MatchupDetail_Matchup" FromRole="MatchupDetail" ToRole="Matchup" />
  840. <NavigationProperty Name="Quarter" Relationship="Self.FK_MatchupDetail_Quarter" FromRole="MatchupDetail" ToRole="Quarter" />
  841. </EntityType>
  842. <EntityType Name="MatchupLogs">
  843. <Key>
  844. <PropertyRef Name="IdMatchupLogs" />
  845. </Key>
  846. <Property Name="IdMatchupLogs" Type="Int32" Nullable="false" />
  847. <Property Name="IdMatchup" Type="Int32" />
  848. <Property Name="IdQuarter" Type="Int32" />
  849. <Property Name="OccurTime" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
  850. <Property Name="IdTeam" Type="Int32" />
  851. <Property Name="IdPlayer" Type="Int32" />
  852. <Property Name="IdActionType" Type="Int32" />
  853. <Property Name="Remark" Type="String" MaxLength="300" FixedLength="false" Unicode="false" />
  854. <NavigationProperty Name="ActionType" Relationship="Self.FK_MatchupLogs_ActionType" FromRole="MatchupLogs" ToRole="ActionType" />
  855. <NavigationProperty Name="Matchup" Relationship="Self.FK_MatchupLogs_Matchup" FromRole="MatchupLogs" ToRole="Matchup" />
  856. <NavigationProperty Name="Player" Relationship="Self.FK_MatchupLogs_Player" FromRole="MatchupLogs" ToRole="Player" />
  857. <NavigationProperty Name="Quarter" Relationship="Self.FK_MatchupLogs_Quarter" FromRole="MatchupLogs" ToRole="Quarter" />
  858. <NavigationProperty Name="Team" Relationship="Self.FK_MatchupLogs_Team" FromRole="MatchupLogs" ToRole="Team" />
  859. </EntityType>
  860. <EntityType Name="MatchupType">
  861. <Key>
  862. <PropertyRef Name="IdMatchupType" />
  863. </Key>
  864. <Property Name="IdMatchupType" Type="Int32" Nullable="false" />
  865. <Property Name="NameMatchupType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  866. <NavigationProperty Name="Matchup" Relationship="Self.FK_Matchup_MatchupType" FromRole="MatchupType" ToRole="Matchup" />
  867. </EntityType>
  868. <EntityType Name="Organization">
  869. <Key>
  870. <PropertyRef Name="IdOrganization" />
  871. </Key>
  872. <Property Name="IdOrganization" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  873. <Property Name="OrganizationName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  874. <Property Name="Info" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
  875. <Property Name="IdStatusOrganization" Type="Int32" />
  876. <NavigationProperty Name="Department" Relationship="Self.FK_Department_Organization" FromRole="Organization" ToRole="Department" />
  877. <NavigationProperty Name="StatusOrganization" Relationship="Self.FK_Organization_StatusOrganization" FromRole="Organization" ToRole="StatusOrganization" />
  878. </EntityType>
  879. <EntityType Name="Player">
  880. <Key>
  881. <PropertyRef Name="IdPlayer" />
  882. </Key>
  883. <Property Name="IdPlayer" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  884. <Property Name="Surename" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  885. <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  886. <Property Name="Patronymic" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  887. <Property Name="IdPosition" Type="Int32" />
  888. <Property Name="JoinYear" Type="DateTime" Precision="0" />
  889. <Property Name="IdGender" Type="Int32" />
  890. <Property Name="Height" Type="Decimal" Precision="10" Scale="2" />
  891. <Property Name="Weight" Type="Decimal" Precision="10" Scale="2" />
  892. <Property Name="DateOfBirth" Type="DateTime" Precision="0" />
  893. <Property Name="College" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  894. <Property Name="Email" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  895. <Property Name="IdCountry" Type="Int32" />
  896. <Property Name="IsRetiment" Type="Boolean" />
  897. <Property Name="RetirmentTime" Type="DateTime" Precision="0" />
  898. <Property Name="Image" Type="Binary" MaxLength="Max" FixedLength="false" />
  899. <NavigationProperty Name="Country" Relationship="Self.FK_Player_Country" FromRole="Player" ToRole="Country" />
  900. <NavigationProperty Name="Gender" Relationship="Self.FK_Player_Gender" FromRole="Player" ToRole="Gender" />
  901. <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_Player" FromRole="Player" ToRole="MatchupLogs" />
  902. <NavigationProperty Name="Position" Relationship="Self.FK_Player_Position" FromRole="Player" ToRole="Position" />
  903. <NavigationProperty Name="PlayerInTeam" Relationship="Self.FK_PlayerInTeam_Player" FromRole="Player" ToRole="PlayerInTeam" />
  904. <NavigationProperty Name="PlayerStatistic" Relationship="Self.FK_PlayerStatistic_Player" FromRole="Player" ToRole="PlayerStatistic" />
  905. </EntityType>
  906. <EntityType Name="PlayerInTeam">
  907. <Key>
  908. <PropertyRef Name="IdPlayerInTeam" />
  909. </Key>
  910. <Property Name="IdPlayerInTeam" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  911. <Property Name="IdPlayer" Type="Int32" />
  912. <Property Name="IdTeam" Type="Int32" />
  913. <Property Name="IdSeason" Type="Int32" />
  914. <Property Name="ShirtNumber" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
  915. <Property Name="Salary" Type="Decimal" Precision="10" Scale="2" />
  916. <Property Name="StarterIndex" Type="Int32" />
  917. <NavigationProperty Name="Player" Relationship="Self.FK_PlayerInTeam_Player" FromRole="PlayerInTeam" ToRole="Player" />
  918. <NavigationProperty Name="Season" Relationship="Self.FK_PlayerInTeam_Season" FromRole="PlayerInTeam" ToRole="Season" />
  919. <NavigationProperty Name="Team" Relationship="Self.FK_PlayerInTeam_Team" FromRole="PlayerInTeam" ToRole="Team" />
  920. </EntityType>
  921. <EntityType Name="PlayerStatistic">
  922. <Key>
  923. <PropertyRef Name="IdPlayerStatistic" />
  924. </Key>
  925. <Property Name="IdPlayerStatistic" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  926. <Property Name="IdMatchup" Type="Int32" />
  927. <Property Name="IdTeam" Type="Int32" />
  928. <Property Name="IdPlayer" Type="Int32" />
  929. <Property Name="IsStarting" Type="Int32" />
  930. <Property Name="Min" Type="Decimal" Precision="10" Scale="2" />
  931. <Property Name="Point" Type="Int32" />
  932. <Property Name="Assist" Type="Int32" />
  933. <Property Name="FieldGoalMade" Type="Int32" />
  934. <Property Name="FieldGoalMissed" Type="Int32" />
  935. <Property Name="ThreePointFieldGoalMade" Type="Int32" />
  936. <Property Name="ThreePointFieldGoalMissed" Type="Int32" />
  937. <Property Name="FreeThrowMade" Type="Int32" />
  938. <Property Name="FreeThrowMissed" Type="Int32" />
  939. <Property Name="Rebound" Type="Int32" />
  940. <Property Name="OFFR" Type="Int32" />
  941. <Property Name="DFFR" Type="Int32" />
  942. <Property Name="Steal" Type="Int32" />
  943. <Property Name="Block" Type="Int32" />
  944. <Property Name="Turnover" Type="Int32" />
  945. <Property Name="Foul" Type="Int32" />
  946. <NavigationProperty Name="Player" Relationship="Self.FK_PlayerStatistic_Player" FromRole="PlayerStatistic" ToRole="Player" />
  947. <NavigationProperty Name="Team" Relationship="Self.FK_PlayerStatistic_Team" FromRole="PlayerStatistic" ToRole="Team" />
  948. </EntityType>
  949. <EntityType Name="Position">
  950. <Key>
  951. <PropertyRef Name="IdPosition" />
  952. </Key>
  953. <Property Name="IdPosition" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  954. <Property Name="NamePosition" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  955. <Property Name="Abbr" Type="String" MaxLength="3" FixedLength="true" Unicode="false" />
  956. <NavigationProperty Name="Player" Relationship="Self.FK_Player_Position" FromRole="Position" ToRole="Player" />
  957. </EntityType>
  958. <EntityType Name="PostSeason">
  959. <Key>
  960. <PropertyRef Name="IdPostSeason" />
  961. </Key>
  962. <Property Name="IdPostSeason" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  963. <Property Name="IdSeason" Type="Int32" />
  964. <Property Name="IdTeam" Type="Int32" />
  965. <Property Name="Rank" Type="Int32" />
  966. <NavigationProperty Name="Season" Relationship="Self.FK_PostSeason_Season" FromRole="PostSeason" ToRole="Season" />
  967. <NavigationProperty Name="Team" Relationship="Self.FK_PostSeason_Team" FromRole="PostSeason" ToRole="Team" />
  968. </EntityType>
  969. <EntityType Name="Quarter">
  970. <Key>
  971. <PropertyRef Name="IdQuarter" />
  972. </Key>
  973. <Property Name="IdQuarter" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  974. <Property Name="NameQuarter" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  975. <NavigationProperty Name="MatchupDetail" Relationship="Self.FK_MatchupDetail_Quarter" FromRole="Quarter" ToRole="MatchupDetail" />
  976. <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_Quarter" FromRole="Quarter" ToRole="MatchupLogs" />
  977. </EntityType>
  978. <EntityType Name="Role">
  979. <Key>
  980. <PropertyRef Name="IdRole" />
  981. </Key>
  982. <Property Name="IdRole" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  983. <Property Name="RoleName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  984. <NavigationProperty Name="User" Relationship="Self.FK_User_Role" FromRole="Role" ToRole="User" />
  985. </EntityType>
  986. <EntityType Name="Season">
  987. <Key>
  988. <PropertyRef Name="IdSeason" />
  989. </Key>
  990. <Property Name="IdSeason" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  991. <Property Name="NameSeason" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  992. <NavigationProperty Name="Matchup" Relationship="Self.FK_Matchup_Season" FromRole="Season" ToRole="Matchup" />
  993. <NavigationProperty Name="PlayerInTeam" Relationship="Self.FK_PlayerInTeam_Season" FromRole="Season" ToRole="PlayerInTeam" />
  994. <NavigationProperty Name="PostSeason" Relationship="Self.FK_PostSeason_Season" FromRole="Season" ToRole="PostSeason" />
  995. </EntityType>
  996. <EntityType Name="Status">
  997. <Key>
  998. <PropertyRef Name="IdStatus" />
  999. </Key>
  1000. <Property Name="IdStatus" Type="Int32" Nullable="false" />
  1001. <Property Name="NameStatus" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1002. <NavigationProperty Name="Matchup" Relationship="Self.FK_Matchup_Status" FromRole="Status" ToRole="Matchup" />
  1003. </EntityType>
  1004. <EntityType Name="StatusOrganization">
  1005. <Key>
  1006. <PropertyRef Name="IdStatusOrganization" />
  1007. </Key>
  1008. <Property Name="IdStatusOrganization" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1009. <Property Name="NameStatusOrganization" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1010. <NavigationProperty Name="Organization" Relationship="Self.FK_Organization_StatusOrganization" FromRole="StatusOrganization" ToRole="Organization" />
  1011. </EntityType>
  1012. <EntityType Name="sysdiagrams">
  1013. <Key>
  1014. <PropertyRef Name="diagram_id" />
  1015. </Key>
  1016. <Property Name="name" Type="String" MaxLength="128" FixedLength="false" Unicode="true" Nullable="false" />
  1017. <Property Name="principal_id" Type="Int32" Nullable="false" />
  1018. <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1019. <Property Name="version" Type="Int32" />
  1020. <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
  1021. </EntityType>
  1022. <EntityType Name="Team">
  1023. <Key>
  1024. <PropertyRef Name="IdTeam" />
  1025. </Key>
  1026. <Property Name="IdTeam" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1027. <Property Name="TeamName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1028. <Property Name="IdDivision" Type="Int32" />
  1029. <Property Name="Couch" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1030. <Property Name="Abbr" Type="String" MaxLength="3" FixedLength="true" Unicode="false" />
  1031. <Property Name="Stadium" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
  1032. <Property Name="Logo" Type="Binary" MaxLength="Max" FixedLength="false" />
  1033. <NavigationProperty Name="Division" Relationship="Self.FK_Team_Division" FromRole="Team" ToRole="Division" />
  1034. <NavigationProperty Name="Matchup" Relationship="Self.FK_Matchup_Team" FromRole="Team" ToRole="Matchup" />
  1035. <NavigationProperty Name="Matchup1" Relationship="Self.FK_Matchup_Team1" FromRole="Team" ToRole="Matchup" />
  1036. <NavigationProperty Name="MatchupLogs" Relationship="Self.FK_MatchupLogs_Team" FromRole="Team" ToRole="MatchupLogs" />
  1037. <NavigationProperty Name="PlayerInTeam" Relationship="Self.FK_PlayerInTeam_Team" FromRole="Team" ToRole="PlayerInTeam" />
  1038. <NavigationProperty Name="PlayerStatistic" Relationship="Self.FK_PlayerStatistic_Team" FromRole="Team" ToRole="PlayerStatistic" />
  1039. <NavigationProperty Name="PostSeason" Relationship="Self.FK_PostSeason_Team" FromRole="Team" ToRole="PostSeason" />
  1040. </EntityType>
  1041. <EntityType Name="User">
  1042. <Key>
  1043. <PropertyRef Name="IdUser" />
  1044. </Key>
  1045. <Property Name="IdUser" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1046. <Property Name="Surename" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1047. <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1048. <Property Name="Patronymic" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1049. <Property Name="LoginName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
  1050. <Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1051. <Property Name="IdGender" Type="Int32" />
  1052. <Property Name="DateOfBirth" Type="DateTime" Precision="0" />
  1053. <Property Name="Phone" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
  1054. <Property Name="Email" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1055. <Property Name="IdRole" Type="Int32" />
  1056. <NavigationProperty Name="Gender" Relationship="Self.FK_User_Gender" FromRole="User" ToRole="Gender" />
  1057. <NavigationProperty Name="Role" Relationship="Self.FK_User_Role" FromRole="User" ToRole="Role" />
  1058. </EntityType>
  1059. <Association Name="FK_MatchupLogs_ActionType">
  1060. <End Role="ActionType" Type="Self.ActionType" Multiplicity="0..1" />
  1061. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  1062. <ReferentialConstraint>
  1063. <Principal Role="ActionType">
  1064. <PropertyRef Name="IdActionType" />
  1065. </Principal>
  1066. <Dependent Role="MatchupLogs">
  1067. <PropertyRef Name="IdActionType" />
  1068. </Dependent>
  1069. </ReferentialConstraint>
  1070. </Association>
  1071. <Association Name="FK_Division_Conference">
  1072. <End Role="Conference" Type="Self.Conference" Multiplicity="0..1" />
  1073. <End Role="Division" Type="Self.Division" Multiplicity="*" />
  1074. <ReferentialConstraint>
  1075. <Principal Role="Conference">
  1076. <PropertyRef Name="IdConference" />
  1077. </Principal>
  1078. <Dependent Role="Division">
  1079. <PropertyRef Name="IdConference" />
  1080. </Dependent>
  1081. </ReferentialConstraint>
  1082. </Association>
  1083. <Association Name="FK_Player_Country">
  1084. <End Role="Country" Type="Self.Country" Multiplicity="0..1" />
  1085. <End Role="Player" Type="Self.Player" Multiplicity="*" />
  1086. <ReferentialConstraint>
  1087. <Principal Role="Country">
  1088. <PropertyRef Name="IdCountry" />
  1089. </Principal>
  1090. <Dependent Role="Player">
  1091. <PropertyRef Name="IdCountry" />
  1092. </Dependent>
  1093. </ReferentialConstraint>
  1094. </Association>
  1095. <Association Name="FK_Department_Organization">
  1096. <End Role="Organization" Type="Self.Organization" Multiplicity="0..1" />
  1097. <End Role="Department" Type="Self.Department" Multiplicity="*" />
  1098. <ReferentialConstraint>
  1099. <Principal Role="Organization">
  1100. <PropertyRef Name="IdOrganization" />
  1101. </Principal>
  1102. <Dependent Role="Department">
  1103. <PropertyRef Name="IdOrganization" />
  1104. </Dependent>
  1105. </ReferentialConstraint>
  1106. </Association>
  1107. <Association Name="FK_Team_Division">
  1108. <End Role="Division" Type="Self.Division" Multiplicity="0..1" />
  1109. <End Role="Team" Type="Self.Team" Multiplicity="*" />
  1110. <ReferentialConstraint>
  1111. <Principal Role="Division">
  1112. <PropertyRef Name="IdDivision" />
  1113. </Principal>
  1114. <Dependent Role="Team">
  1115. <PropertyRef Name="IdDivision" />
  1116. </Dependent>
  1117. </ReferentialConstraint>
  1118. </Association>
  1119. <Association Name="FK_Player_Gender">
  1120. <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
  1121. <End Role="Player" Type="Self.Player" Multiplicity="*" />
  1122. <ReferentialConstraint>
  1123. <Principal Role="Gender">
  1124. <PropertyRef Name="IdGender" />
  1125. </Principal>
  1126. <Dependent Role="Player">
  1127. <PropertyRef Name="IdGender" />
  1128. </Dependent>
  1129. </ReferentialConstraint>
  1130. </Association>
  1131. <Association Name="FK_User_Gender">
  1132. <End Role="Gender" Type="Self.Gender" Multiplicity="0..1" />
  1133. <End Role="User" Type="Self.User" Multiplicity="*" />
  1134. <ReferentialConstraint>
  1135. <Principal Role="Gender">
  1136. <PropertyRef Name="IdGender" />
  1137. </Principal>
  1138. <Dependent Role="User">
  1139. <PropertyRef Name="IdGender" />
  1140. </Dependent>
  1141. </ReferentialConstraint>
  1142. </Association>
  1143. <Association Name="FK_Matchup_MatchupType">
  1144. <End Role="MatchupType" Type="Self.MatchupType" Multiplicity="0..1" />
  1145. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  1146. <ReferentialConstraint>
  1147. <Principal Role="MatchupType">
  1148. <PropertyRef Name="IdMatchupType" />
  1149. </Principal>
  1150. <Dependent Role="Matchup">
  1151. <PropertyRef Name="IdMatchupType" />
  1152. </Dependent>
  1153. </ReferentialConstraint>
  1154. </Association>
  1155. <Association Name="FK_Matchup_Season">
  1156. <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
  1157. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  1158. <ReferentialConstraint>
  1159. <Principal Role="Season">
  1160. <PropertyRef Name="IdSeason" />
  1161. </Principal>
  1162. <Dependent Role="Matchup">
  1163. <PropertyRef Name="IdSeason" />
  1164. </Dependent>
  1165. </ReferentialConstraint>
  1166. </Association>
  1167. <Association Name="FK_Matchup_Status">
  1168. <End Role="Status" Type="Self.Status" Multiplicity="0..1" />
  1169. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  1170. <ReferentialConstraint>
  1171. <Principal Role="Status">
  1172. <PropertyRef Name="IdStatus" />
  1173. </Principal>
  1174. <Dependent Role="Matchup">
  1175. <PropertyRef Name="IdStatus" />
  1176. </Dependent>
  1177. </ReferentialConstraint>
  1178. </Association>
  1179. <Association Name="FK_Matchup_Team">
  1180. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  1181. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  1182. <ReferentialConstraint>
  1183. <Principal Role="Team">
  1184. <PropertyRef Name="IdTeam" />
  1185. </Principal>
  1186. <Dependent Role="Matchup">
  1187. <PropertyRef Name="IdTeamAway" />
  1188. </Dependent>
  1189. </ReferentialConstraint>
  1190. </Association>
  1191. <Association Name="FK_Matchup_Team1">
  1192. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  1193. <End Role="Matchup" Type="Self.Matchup" Multiplicity="*" />
  1194. <ReferentialConstraint>
  1195. <Principal Role="Team">
  1196. <PropertyRef Name="IdTeam" />
  1197. </Principal>
  1198. <Dependent Role="Matchup">
  1199. <PropertyRef Name="IdTeamHome" />
  1200. </Dependent>
  1201. </ReferentialConstraint>
  1202. </Association>
  1203. <Association Name="FK_MatchupDetail_Matchup">
  1204. <End Role="Matchup" Type="Self.Matchup" Multiplicity="0..1" />
  1205. <End Role="MatchupDetail" Type="Self.MatchupDetail" Multiplicity="*" />
  1206. <ReferentialConstraint>
  1207. <Principal Role="Matchup">
  1208. <PropertyRef Name="IdMatchup" />
  1209. </Principal>
  1210. <Dependent Role="MatchupDetail">
  1211. <PropertyRef Name="IdMatchup" />
  1212. </Dependent>
  1213. </ReferentialConstraint>
  1214. </Association>
  1215. <Association Name="FK_MatchupLogs_Matchup">
  1216. <End Role="Matchup" Type="Self.Matchup" Multiplicity="0..1" />
  1217. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  1218. <ReferentialConstraint>
  1219. <Principal Role="Matchup">
  1220. <PropertyRef Name="IdMatchup" />
  1221. </Principal>
  1222. <Dependent Role="MatchupLogs">
  1223. <PropertyRef Name="IdMatchup" />
  1224. </Dependent>
  1225. </ReferentialConstraint>
  1226. </Association>
  1227. <Association Name="FK_MatchupDetail_Quarter">
  1228. <End Role="Quarter" Type="Self.Quarter" Multiplicity="0..1" />
  1229. <End Role="MatchupDetail" Type="Self.MatchupDetail" Multiplicity="*" />
  1230. <ReferentialConstraint>
  1231. <Principal Role="Quarter">
  1232. <PropertyRef Name="IdQuarter" />
  1233. </Principal>
  1234. <Dependent Role="MatchupDetail">
  1235. <PropertyRef Name="IdQuarter" />
  1236. </Dependent>
  1237. </ReferentialConstraint>
  1238. </Association>
  1239. <Association Name="FK_MatchupLogs_Player">
  1240. <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
  1241. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  1242. <ReferentialConstraint>
  1243. <Principal Role="Player">
  1244. <PropertyRef Name="IdPlayer" />
  1245. </Principal>
  1246. <Dependent Role="MatchupLogs">
  1247. <PropertyRef Name="IdPlayer" />
  1248. </Dependent>
  1249. </ReferentialConstraint>
  1250. </Association>
  1251. <Association Name="FK_MatchupLogs_Quarter">
  1252. <End Role="Quarter" Type="Self.Quarter" Multiplicity="0..1" />
  1253. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  1254. <ReferentialConstraint>
  1255. <Principal Role="Quarter">
  1256. <PropertyRef Name="IdQuarter" />
  1257. </Principal>
  1258. <Dependent Role="MatchupLogs">
  1259. <PropertyRef Name="IdQuarter" />
  1260. </Dependent>
  1261. </ReferentialConstraint>
  1262. </Association>
  1263. <Association Name="FK_MatchupLogs_Team">
  1264. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  1265. <End Role="MatchupLogs" Type="Self.MatchupLogs" Multiplicity="*" />
  1266. <ReferentialConstraint>
  1267. <Principal Role="Team">
  1268. <PropertyRef Name="IdTeam" />
  1269. </Principal>
  1270. <Dependent Role="MatchupLogs">
  1271. <PropertyRef Name="IdTeam" />
  1272. </Dependent>
  1273. </ReferentialConstraint>
  1274. </Association>
  1275. <Association Name="FK_Organization_StatusOrganization">
  1276. <End Role="StatusOrganization" Type="Self.StatusOrganization" Multiplicity="0..1" />
  1277. <End Role="Organization" Type="Self.Organization" Multiplicity="*" />
  1278. <ReferentialConstraint>
  1279. <Principal Role="StatusOrganization">
  1280. <PropertyRef Name="IdStatusOrganization" />
  1281. </Principal>
  1282. <Dependent Role="Organization">
  1283. <PropertyRef Name="IdStatusOrganization" />
  1284. </Dependent>
  1285. </ReferentialConstraint>
  1286. </Association>
  1287. <Association Name="FK_Player_Position">
  1288. <End Role="Position" Type="Self.Position" Multiplicity="0..1" />
  1289. <End Role="Player" Type="Self.Player" Multiplicity="*" />
  1290. <ReferentialConstraint>
  1291. <Principal Role="Position">
  1292. <PropertyRef Name="IdPosition" />
  1293. </Principal>
  1294. <Dependent Role="Player">
  1295. <PropertyRef Name="IdPosition" />
  1296. </Dependent>
  1297. </ReferentialConstraint>
  1298. </Association>
  1299. <Association Name="FK_PlayerInTeam_Player">
  1300. <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
  1301. <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
  1302. <ReferentialConstraint>
  1303. <Principal Role="Player">
  1304. <PropertyRef Name="IdPlayer" />
  1305. </Principal>
  1306. <Dependent Role="PlayerInTeam">
  1307. <PropertyRef Name="IdPlayer" />
  1308. </Dependent>
  1309. </ReferentialConstraint>
  1310. </Association>
  1311. <Association Name="FK_PlayerStatistic_Player">
  1312. <End Role="Player" Type="Self.Player" Multiplicity="0..1" />
  1313. <End Role="PlayerStatistic" Type="Self.PlayerStatistic" Multiplicity="*" />
  1314. <ReferentialConstraint>
  1315. <Principal Role="Player">
  1316. <PropertyRef Name="IdPlayer" />
  1317. </Principal>
  1318. <Dependent Role="PlayerStatistic">
  1319. <PropertyRef Name="IdPlayer" />
  1320. </Dependent>
  1321. </ReferentialConstraint>
  1322. </Association>
  1323. <Association Name="FK_PlayerInTeam_Season">
  1324. <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
  1325. <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
  1326. <ReferentialConstraint>
  1327. <Principal Role="Season">
  1328. <PropertyRef Name="IdSeason" />
  1329. </Principal>
  1330. <Dependent Role="PlayerInTeam">
  1331. <PropertyRef Name="IdSeason" />
  1332. </Dependent>
  1333. </ReferentialConstraint>
  1334. </Association>
  1335. <Association Name="FK_PlayerInTeam_Team">
  1336. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  1337. <End Role="PlayerInTeam" Type="Self.PlayerInTeam" Multiplicity="*" />
  1338. <ReferentialConstraint>
  1339. <Principal Role="Team">
  1340. <PropertyRef Name="IdTeam" />
  1341. </Principal>
  1342. <Dependent Role="PlayerInTeam">
  1343. <PropertyRef Name="IdTeam" />
  1344. </Dependent>
  1345. </ReferentialConstraint>
  1346. </Association>
  1347. <Association Name="FK_PlayerStatistic_Team">
  1348. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  1349. <End Role="PlayerStatistic" Type="Self.PlayerStatistic" Multiplicity="*" />
  1350. <ReferentialConstraint>
  1351. <Principal Role="Team">
  1352. <PropertyRef Name="IdTeam" />
  1353. </Principal>
  1354. <Dependent Role="PlayerStatistic">
  1355. <PropertyRef Name="IdTeam" />
  1356. </Dependent>
  1357. </ReferentialConstraint>
  1358. </Association>
  1359. <Association Name="FK_PostSeason_Season">
  1360. <End Role="Season" Type="Self.Season" Multiplicity="0..1" />
  1361. <End Role="PostSeason" Type="Self.PostSeason" Multiplicity="*" />
  1362. <ReferentialConstraint>
  1363. <Principal Role="Season">
  1364. <PropertyRef Name="IdSeason" />
  1365. </Principal>
  1366. <Dependent Role="PostSeason">
  1367. <PropertyRef Name="IdSeason" />
  1368. </Dependent>
  1369. </ReferentialConstraint>
  1370. </Association>
  1371. <Association Name="FK_PostSeason_Team">
  1372. <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
  1373. <End Role="PostSeason" Type="Self.PostSeason" Multiplicity="*" />
  1374. <ReferentialConstraint>
  1375. <Principal Role="Team">
  1376. <PropertyRef Name="IdTeam" />
  1377. </Principal>
  1378. <Dependent Role="PostSeason">
  1379. <PropertyRef Name="IdTeam" />
  1380. </Dependent>
  1381. </ReferentialConstraint>
  1382. </Association>
  1383. <Association Name="FK_User_Role">
  1384. <End Role="Role" Type="Self.Role" Multiplicity="0..1" />
  1385. <End Role="User" Type="Self.User" Multiplicity="*" />
  1386. <ReferentialConstraint>
  1387. <Principal Role="Role">
  1388. <PropertyRef Name="IdRole" />
  1389. </Principal>
  1390. <Dependent Role="User">
  1391. <PropertyRef Name="IdRole" />
  1392. </Dependent>
  1393. </ReferentialConstraint>
  1394. </Association>
  1395. <EntityContainer Name="PracticeNBAEntities" annotation:LazyLoadingEnabled="true">
  1396. <EntitySet Name="ActionType" EntityType="Self.ActionType" />
  1397. <EntitySet Name="Conference" EntityType="Self.Conference" />
  1398. <EntitySet Name="Country" EntityType="Self.Country" />
  1399. <EntitySet Name="Department" EntityType="Self.Department" />
  1400. <EntitySet Name="Division" EntityType="Self.Division" />
  1401. <EntitySet Name="Gender" EntityType="Self.Gender" />
  1402. <EntitySet Name="Image" EntityType="Self.Image" />
  1403. <EntitySet Name="Matchup" EntityType="Self.Matchup" />
  1404. <EntitySet Name="MatchupDetail" EntityType="Self.MatchupDetail" />
  1405. <EntitySet Name="MatchupLogs" EntityType="Self.MatchupLogs" />
  1406. <EntitySet Name="MatchupType" EntityType="Self.MatchupType" />
  1407. <EntitySet Name="Organization" EntityType="Self.Organization" />
  1408. <EntitySet Name="Player" EntityType="Self.Player" />
  1409. <EntitySet Name="PlayerInTeam" EntityType="Self.PlayerInTeam" />
  1410. <EntitySet Name="PlayerStatistic" EntityType="Self.PlayerStatistic" />
  1411. <EntitySet Name="Position" EntityType="Self.Position" />
  1412. <EntitySet Name="PostSeason" EntityType="Self.PostSeason" />
  1413. <EntitySet Name="Quarter" EntityType="Self.Quarter" />
  1414. <EntitySet Name="Role" EntityType="Self.Role" />
  1415. <EntitySet Name="Season" EntityType="Self.Season" />
  1416. <EntitySet Name="Status" EntityType="Self.Status" />
  1417. <EntitySet Name="StatusOrganization" EntityType="Self.StatusOrganization" />
  1418. <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" />
  1419. <EntitySet Name="Team" EntityType="Self.Team" />
  1420. <EntitySet Name="User" EntityType="Self.User" />
  1421. <AssociationSet Name="FK_MatchupLogs_ActionType" Association="Self.FK_MatchupLogs_ActionType">
  1422. <End Role="ActionType" EntitySet="ActionType" />
  1423. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  1424. </AssociationSet>
  1425. <AssociationSet Name="FK_Division_Conference" Association="Self.FK_Division_Conference">
  1426. <End Role="Conference" EntitySet="Conference" />
  1427. <End Role="Division" EntitySet="Division" />
  1428. </AssociationSet>
  1429. <AssociationSet Name="FK_Player_Country" Association="Self.FK_Player_Country">
  1430. <End Role="Country" EntitySet="Country" />
  1431. <End Role="Player" EntitySet="Player" />
  1432. </AssociationSet>
  1433. <AssociationSet Name="FK_Department_Organization" Association="Self.FK_Department_Organization">
  1434. <End Role="Organization" EntitySet="Organization" />
  1435. <End Role="Department" EntitySet="Department" />
  1436. </AssociationSet>
  1437. <AssociationSet Name="FK_Team_Division" Association="Self.FK_Team_Division">
  1438. <End Role="Division" EntitySet="Division" />
  1439. <End Role="Team" EntitySet="Team" />
  1440. </AssociationSet>
  1441. <AssociationSet Name="FK_Player_Gender" Association="Self.FK_Player_Gender">
  1442. <End Role="Gender" EntitySet="Gender" />
  1443. <End Role="Player" EntitySet="Player" />
  1444. </AssociationSet>
  1445. <AssociationSet Name="FK_User_Gender" Association="Self.FK_User_Gender">
  1446. <End Role="Gender" EntitySet="Gender" />
  1447. <End Role="User" EntitySet="User" />
  1448. </AssociationSet>
  1449. <AssociationSet Name="FK_Matchup_MatchupType" Association="Self.FK_Matchup_MatchupType">
  1450. <End Role="MatchupType" EntitySet="MatchupType" />
  1451. <End Role="Matchup" EntitySet="Matchup" />
  1452. </AssociationSet>
  1453. <AssociationSet Name="FK_Matchup_Season" Association="Self.FK_Matchup_Season">
  1454. <End Role="Season" EntitySet="Season" />
  1455. <End Role="Matchup" EntitySet="Matchup" />
  1456. </AssociationSet>
  1457. <AssociationSet Name="FK_Matchup_Status" Association="Self.FK_Matchup_Status">
  1458. <End Role="Status" EntitySet="Status" />
  1459. <End Role="Matchup" EntitySet="Matchup" />
  1460. </AssociationSet>
  1461. <AssociationSet Name="FK_Matchup_Team" Association="Self.FK_Matchup_Team">
  1462. <End Role="Team" EntitySet="Team" />
  1463. <End Role="Matchup" EntitySet="Matchup" />
  1464. </AssociationSet>
  1465. <AssociationSet Name="FK_Matchup_Team1" Association="Self.FK_Matchup_Team1">
  1466. <End Role="Team" EntitySet="Team" />
  1467. <End Role="Matchup" EntitySet="Matchup" />
  1468. </AssociationSet>
  1469. <AssociationSet Name="FK_MatchupDetail_Matchup" Association="Self.FK_MatchupDetail_Matchup">
  1470. <End Role="Matchup" EntitySet="Matchup" />
  1471. <End Role="MatchupDetail" EntitySet="MatchupDetail" />
  1472. </AssociationSet>
  1473. <AssociationSet Name="FK_MatchupLogs_Matchup" Association="Self.FK_MatchupLogs_Matchup">
  1474. <End Role="Matchup" EntitySet="Matchup" />
  1475. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  1476. </AssociationSet>
  1477. <AssociationSet Name="FK_MatchupDetail_Quarter" Association="Self.FK_MatchupDetail_Quarter">
  1478. <End Role="Quarter" EntitySet="Quarter" />
  1479. <End Role="MatchupDetail" EntitySet="MatchupDetail" />
  1480. </AssociationSet>
  1481. <AssociationSet Name="FK_MatchupLogs_Player" Association="Self.FK_MatchupLogs_Player">
  1482. <End Role="Player" EntitySet="Player" />
  1483. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  1484. </AssociationSet>
  1485. <AssociationSet Name="FK_MatchupLogs_Quarter" Association="Self.FK_MatchupLogs_Quarter">
  1486. <End Role="Quarter" EntitySet="Quarter" />
  1487. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  1488. </AssociationSet>
  1489. <AssociationSet Name="FK_MatchupLogs_Team" Association="Self.FK_MatchupLogs_Team">
  1490. <End Role="Team" EntitySet="Team" />
  1491. <End Role="MatchupLogs" EntitySet="MatchupLogs" />
  1492. </AssociationSet>
  1493. <AssociationSet Name="FK_Organization_StatusOrganization" Association="Self.FK_Organization_StatusOrganization">
  1494. <End Role="StatusOrganization" EntitySet="StatusOrganization" />
  1495. <End Role="Organization" EntitySet="Organization" />
  1496. </AssociationSet>
  1497. <AssociationSet Name="FK_Player_Position" Association="Self.FK_Player_Position">
  1498. <End Role="Position" EntitySet="Position" />
  1499. <End Role="Player" EntitySet="Player" />
  1500. </AssociationSet>
  1501. <AssociationSet Name="FK_PlayerInTeam_Player" Association="Self.FK_PlayerInTeam_Player">
  1502. <End Role="Player" EntitySet="Player" />
  1503. <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
  1504. </AssociationSet>
  1505. <AssociationSet Name="FK_PlayerStatistic_Player" Association="Self.FK_PlayerStatistic_Player">
  1506. <End Role="Player" EntitySet="Player" />
  1507. <End Role="PlayerStatistic" EntitySet="PlayerStatistic" />
  1508. </AssociationSet>
  1509. <AssociationSet Name="FK_PlayerInTeam_Season" Association="Self.FK_PlayerInTeam_Season">
  1510. <End Role="Season" EntitySet="Season" />
  1511. <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
  1512. </AssociationSet>
  1513. <AssociationSet Name="FK_PlayerInTeam_Team" Association="Self.FK_PlayerInTeam_Team">
  1514. <End Role="Team" EntitySet="Team" />
  1515. <End Role="PlayerInTeam" EntitySet="PlayerInTeam" />
  1516. </AssociationSet>
  1517. <AssociationSet Name="FK_PlayerStatistic_Team" Association="Self.FK_PlayerStatistic_Team">
  1518. <End Role="Team" EntitySet="Team" />
  1519. <End Role="PlayerStatistic" EntitySet="PlayerStatistic" />
  1520. </AssociationSet>
  1521. <AssociationSet Name="FK_PostSeason_Season" Association="Self.FK_PostSeason_Season">
  1522. <End Role="Season" EntitySet="Season" />
  1523. <End Role="PostSeason" EntitySet="PostSeason" />
  1524. </AssociationSet>
  1525. <AssociationSet Name="FK_PostSeason_Team" Association="Self.FK_PostSeason_Team">
  1526. <End Role="Team" EntitySet="Team" />
  1527. <End Role="PostSeason" EntitySet="PostSeason" />
  1528. </AssociationSet>
  1529. <AssociationSet Name="FK_User_Role" Association="Self.FK_User_Role">
  1530. <End Role="Role" EntitySet="Role" />
  1531. <End Role="User" EntitySet="User" />
  1532. </AssociationSet>
  1533. </EntityContainer>
  1534. </Schema>
  1535. </edmx:ConceptualModels>
  1536. <!-- C-S mapping content -->
  1537. <edmx:Mappings>
  1538. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  1539. <EntityContainerMapping StorageEntityContainer="Хранилище PracticeNBAModelContainer" CdmEntityContainer="PracticeNBAEntities">
  1540. <EntitySetMapping Name="ActionType">
  1541. <EntityTypeMapping TypeName="PracticeNBAModel.ActionType">
  1542. <MappingFragment StoreEntitySet="ActionType">
  1543. <ScalarProperty Name="IdActionType" ColumnName="IdActionType" />
  1544. <ScalarProperty Name="NameActionType" ColumnName="NameActionType" />
  1545. </MappingFragment>
  1546. </EntityTypeMapping>
  1547. </EntitySetMapping>
  1548. <EntitySetMapping Name="Conference">
  1549. <EntityTypeMapping TypeName="PracticeNBAModel.Conference">
  1550. <MappingFragment StoreEntitySet="Conference">
  1551. <ScalarProperty Name="IdConference" ColumnName="IdConference" />
  1552. <ScalarProperty Name="NameConference" ColumnName="NameConference" />
  1553. </MappingFragment>
  1554. </EntityTypeMapping>
  1555. </EntitySetMapping>
  1556. <EntitySetMapping Name="Country">
  1557. <EntityTypeMapping TypeName="PracticeNBAModel.Country">
  1558. <MappingFragment StoreEntitySet="Country">
  1559. <ScalarProperty Name="IdCountry" ColumnName="IdCountry" />
  1560. <ScalarProperty Name="NameCountry" ColumnName="NameCountry" />
  1561. <ScalarProperty Name="CodeCountry" ColumnName="CodeCountry" />
  1562. </MappingFragment>
  1563. </EntityTypeMapping>
  1564. </EntitySetMapping>
  1565. <EntitySetMapping Name="Department">
  1566. <EntityTypeMapping TypeName="PracticeNBAModel.Department">
  1567. <MappingFragment StoreEntitySet="Department">
  1568. <ScalarProperty Name="IdDepartment" ColumnName="IdDepartment" />
  1569. <ScalarProperty Name="NameDepartment" ColumnName="NameDepartment" />
  1570. <ScalarProperty Name="IdOrganization" ColumnName="IdOrganization" />
  1571. </MappingFragment>
  1572. </EntityTypeMapping>
  1573. </EntitySetMapping>
  1574. <EntitySetMapping Name="Division">
  1575. <EntityTypeMapping TypeName="PracticeNBAModel.Division">
  1576. <MappingFragment StoreEntitySet="Division">
  1577. <ScalarProperty Name="IdDivision" ColumnName="IdDivision" />
  1578. <ScalarProperty Name="NameDivision" ColumnName="NameDivision" />
  1579. <ScalarProperty Name="IdConference" ColumnName="IdConference" />
  1580. </MappingFragment>
  1581. </EntityTypeMapping>
  1582. </EntitySetMapping>
  1583. <EntitySetMapping Name="Gender">
  1584. <EntityTypeMapping TypeName="PracticeNBAModel.Gender">
  1585. <MappingFragment StoreEntitySet="Gender">
  1586. <ScalarProperty Name="IdGender" ColumnName="IdGender" />
  1587. <ScalarProperty Name="NameGender" ColumnName="NameGender" />
  1588. </MappingFragment>
  1589. </EntityTypeMapping>
  1590. </EntitySetMapping>
  1591. <EntitySetMapping Name="Image">
  1592. <EntityTypeMapping TypeName="PracticeNBAModel.Image">
  1593. <MappingFragment StoreEntitySet="Image">
  1594. <ScalarProperty Name="IdImage" ColumnName="IdImage" />
  1595. <ScalarProperty Name="Image1" ColumnName="Image" />
  1596. <ScalarProperty Name="Description" ColumnName="Description" />
  1597. <ScalarProperty Name="NumberOfLikes" ColumnName="NumberOfLikes" />
  1598. <ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
  1599. </MappingFragment>
  1600. </EntityTypeMapping>
  1601. </EntitySetMapping>
  1602. <EntitySetMapping Name="Matchup">
  1603. <EntityTypeMapping TypeName="PracticeNBAModel.Matchup">
  1604. <MappingFragment StoreEntitySet="Matchup">
  1605. <ScalarProperty Name="IdMatchup" ColumnName="IdMatchup" />
  1606. <ScalarProperty Name="IdSeason" ColumnName="IdSeason" />
  1607. <ScalarProperty Name="IdMatchupType" ColumnName="IdMatchupType" />
  1608. <ScalarProperty Name="IdTeamAway" ColumnName="IdTeamAway" />
  1609. <ScalarProperty Name="IdTeamHome" ColumnName="IdTeamHome" />
  1610. <ScalarProperty Name="Starttime" ColumnName="Starttime" />
  1611. <ScalarProperty Name="TeamAwayScore" ColumnName="TeamAwayScore" />
  1612. <ScalarProperty Name="TeamHomeScore" ColumnName="TeamHomeScore" />
  1613. <ScalarProperty Name="Location" ColumnName="Location" />
  1614. <ScalarProperty Name="IdStatus" ColumnName="IdStatus" />
  1615. </MappingFragment>
  1616. </EntityTypeMapping>
  1617. </EntitySetMapping>
  1618. <EntitySetMapping Name="MatchupDetail">
  1619. <EntityTypeMapping TypeName="PracticeNBAModel.MatchupDetail">
  1620. <MappingFragment StoreEntitySet="MatchupDetail">
  1621. <ScalarProperty Name="IdMatchupDetail" ColumnName="IdMatchupDetail" />
  1622. <ScalarProperty Name="IdMatchup" ColumnName="IdMatchup" />
  1623. <ScalarProperty Name="IdQuarter" ColumnName="IdQuarter" />
  1624. <ScalarProperty Name="TeamAwayScore" ColumnName="TeamAwayScore" />
  1625. <ScalarProperty Name="TeamHomeScore" ColumnName="TeamHomeScore" />
  1626. </MappingFragment>
  1627. </EntityTypeMapping>
  1628. </EntitySetMapping>
  1629. <EntitySetMapping Name="MatchupLogs">
  1630. <EntityTypeMapping TypeName="PracticeNBAModel.MatchupLogs">
  1631. <MappingFragment StoreEntitySet="MatchupLogs">
  1632. <ScalarProperty Name="IdMatchupLogs" ColumnName="IdMatchupLogs" />
  1633. <ScalarProperty Name="IdMatchup" ColumnName="IdMatchup" />
  1634. <ScalarProperty Name="IdQuarter" ColumnName="IdQuarter" />
  1635. <ScalarProperty Name="OccurTime" ColumnName="OccurTime" />
  1636. <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
  1637. <ScalarProperty Name="IdPlayer" ColumnName="IdPlayer" />
  1638. <ScalarProperty Name="IdActionType" ColumnName="IdActionType" />
  1639. <ScalarProperty Name="Remark" ColumnName="Remark" />
  1640. </MappingFragment>
  1641. </EntityTypeMapping>
  1642. </EntitySetMapping>
  1643. <EntitySetMapping Name="MatchupType">
  1644. <EntityTypeMapping TypeName="PracticeNBAModel.MatchupType">
  1645. <MappingFragment StoreEntitySet="MatchupType">
  1646. <ScalarProperty Name="IdMatchupType" ColumnName="IdMatchupType" />
  1647. <ScalarProperty Name="NameMatchupType" ColumnName="NameMatchupType" />
  1648. </MappingFragment>
  1649. </EntityTypeMapping>
  1650. </EntitySetMapping>
  1651. <EntitySetMapping Name="Organization">
  1652. <EntityTypeMapping TypeName="PracticeNBAModel.Organization">
  1653. <MappingFragment StoreEntitySet="Organization">
  1654. <ScalarProperty Name="IdOrganization" ColumnName="IdOrganization" />
  1655. <ScalarProperty Name="OrganizationName" ColumnName="OrganizationName" />
  1656. <ScalarProperty Name="Info" ColumnName="Info" />
  1657. <ScalarProperty Name="IdStatusOrganization" ColumnName="IdStatusOrganization" />
  1658. </MappingFragment>
  1659. </EntityTypeMapping>
  1660. </EntitySetMapping>
  1661. <EntitySetMapping Name="Player">
  1662. <EntityTypeMapping TypeName="PracticeNBAModel.Player">
  1663. <MappingFragment StoreEntitySet="Player">
  1664. <ScalarProperty Name="IdPlayer" ColumnName="IdPlayer" />
  1665. <ScalarProperty Name="Surename" ColumnName="Surename" />
  1666. <ScalarProperty Name="Name" ColumnName="Name" />
  1667. <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
  1668. <ScalarProperty Name="IdPosition" ColumnName="IdPosition" />
  1669. <ScalarProperty Name="JoinYear" ColumnName="JoinYear" />
  1670. <ScalarProperty Name="IdGender" ColumnName="IdGender" />
  1671. <ScalarProperty Name="Height" ColumnName="Height" />
  1672. <ScalarProperty Name="Weight" ColumnName="Weight" />
  1673. <ScalarProperty Name="DateOfBirth" ColumnName="DateOfBirth" />
  1674. <ScalarProperty Name="College" ColumnName="College" />
  1675. <ScalarProperty Name="Email" ColumnName="Email" />
  1676. <ScalarProperty Name="IdCountry" ColumnName="IdCountry" />
  1677. <ScalarProperty Name="IsRetiment" ColumnName="IsRetiment" />
  1678. <ScalarProperty Name="RetirmentTime" ColumnName="RetirmentTime" />
  1679. <ScalarProperty Name="Image" ColumnName="Image" />
  1680. </MappingFragment>
  1681. </EntityTypeMapping>
  1682. </EntitySetMapping>
  1683. <EntitySetMapping Name="PlayerInTeam">
  1684. <EntityTypeMapping TypeName="PracticeNBAModel.PlayerInTeam">
  1685. <MappingFragment StoreEntitySet="PlayerInTeam">
  1686. <ScalarProperty Name="IdPlayerInTeam" ColumnName="IdPlayerInTeam" />
  1687. <ScalarProperty Name="IdPlayer" ColumnName="IdPlayer" />
  1688. <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
  1689. <ScalarProperty Name="IdSeason" ColumnName="IdSeason" />
  1690. <ScalarProperty Name="ShirtNumber" ColumnName="ShirtNumber" />
  1691. <ScalarProperty Name="Salary" ColumnName="Salary" />
  1692. <ScalarProperty Name="StarterIndex" ColumnName="StarterIndex" />
  1693. </MappingFragment>
  1694. </EntityTypeMapping>
  1695. </EntitySetMapping>
  1696. <EntitySetMapping Name="PlayerStatistic">
  1697. <EntityTypeMapping TypeName="PracticeNBAModel.PlayerStatistic">
  1698. <MappingFragment StoreEntitySet="PlayerStatistic">
  1699. <ScalarProperty Name="IdPlayerStatistic" ColumnName="IdPlayerStatistic" />
  1700. <ScalarProperty Name="IdMatchup" ColumnName="IdMatchup" />
  1701. <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
  1702. <ScalarProperty Name="IdPlayer" ColumnName="IdPlayer" />
  1703. <ScalarProperty Name="IsStarting" ColumnName="IsStarting" />
  1704. <ScalarProperty Name="Min" ColumnName="Min" />
  1705. <ScalarProperty Name="Point" ColumnName="Point" />
  1706. <ScalarProperty Name="Assist" ColumnName="Assist" />
  1707. <ScalarProperty Name="FieldGoalMade" ColumnName="FieldGoalMade" />
  1708. <ScalarProperty Name="FieldGoalMissed" ColumnName="FieldGoalMissed" />
  1709. <ScalarProperty Name="ThreePointFieldGoalMade" ColumnName="ThreePointFieldGoalMade" />
  1710. <ScalarProperty Name="ThreePointFieldGoalMissed" ColumnName="ThreePointFieldGoalMissed" />
  1711. <ScalarProperty Name="FreeThrowMade" ColumnName="FreeThrowMade" />
  1712. <ScalarProperty Name="FreeThrowMissed" ColumnName="FreeThrowMissed" />
  1713. <ScalarProperty Name="Rebound" ColumnName="Rebound" />
  1714. <ScalarProperty Name="OFFR" ColumnName="OFFR" />
  1715. <ScalarProperty Name="DFFR" ColumnName="DFFR" />
  1716. <ScalarProperty Name="Steal" ColumnName="Steal" />
  1717. <ScalarProperty Name="Block" ColumnName="Block" />
  1718. <ScalarProperty Name="Turnover" ColumnName="Turnover" />
  1719. <ScalarProperty Name="Foul" ColumnName="Foul" />
  1720. </MappingFragment>
  1721. </EntityTypeMapping>
  1722. </EntitySetMapping>
  1723. <EntitySetMapping Name="Position">
  1724. <EntityTypeMapping TypeName="PracticeNBAModel.Position">
  1725. <MappingFragment StoreEntitySet="Position">
  1726. <ScalarProperty Name="IdPosition" ColumnName="IdPosition" />
  1727. <ScalarProperty Name="NamePosition" ColumnName="NamePosition" />
  1728. <ScalarProperty Name="Abbr" ColumnName="Abbr" />
  1729. </MappingFragment>
  1730. </EntityTypeMapping>
  1731. </EntitySetMapping>
  1732. <EntitySetMapping Name="PostSeason">
  1733. <EntityTypeMapping TypeName="PracticeNBAModel.PostSeason">
  1734. <MappingFragment StoreEntitySet="PostSeason">
  1735. <ScalarProperty Name="IdPostSeason" ColumnName="IdPostSeason" />
  1736. <ScalarProperty Name="IdSeason" ColumnName="IdSeason" />
  1737. <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
  1738. <ScalarProperty Name="Rank" ColumnName="Rank" />
  1739. </MappingFragment>
  1740. </EntityTypeMapping>
  1741. </EntitySetMapping>
  1742. <EntitySetMapping Name="Quarter">
  1743. <EntityTypeMapping TypeName="PracticeNBAModel.Quarter">
  1744. <MappingFragment StoreEntitySet="Quarter">
  1745. <ScalarProperty Name="IdQuarter" ColumnName="IdQuarter" />
  1746. <ScalarProperty Name="NameQuarter" ColumnName="NameQuarter" />
  1747. </MappingFragment>
  1748. </EntityTypeMapping>
  1749. </EntitySetMapping>
  1750. <EntitySetMapping Name="Role">
  1751. <EntityTypeMapping TypeName="PracticeNBAModel.Role">
  1752. <MappingFragment StoreEntitySet="Role">
  1753. <ScalarProperty Name="IdRole" ColumnName="IdRole" />
  1754. <ScalarProperty Name="RoleName" ColumnName="RoleName" />
  1755. </MappingFragment>
  1756. </EntityTypeMapping>
  1757. </EntitySetMapping>
  1758. <EntitySetMapping Name="Season">
  1759. <EntityTypeMapping TypeName="PracticeNBAModel.Season">
  1760. <MappingFragment StoreEntitySet="Season">
  1761. <ScalarProperty Name="IdSeason" ColumnName="IdSeason" />
  1762. <ScalarProperty Name="NameSeason" ColumnName="NameSeason" />
  1763. </MappingFragment>
  1764. </EntityTypeMapping>
  1765. </EntitySetMapping>
  1766. <EntitySetMapping Name="Status">
  1767. <EntityTypeMapping TypeName="PracticeNBAModel.Status">
  1768. <MappingFragment StoreEntitySet="Status">
  1769. <ScalarProperty Name="IdStatus" ColumnName="IdStatus" />
  1770. <ScalarProperty Name="NameStatus" ColumnName="NameStatus" />
  1771. </MappingFragment>
  1772. </EntityTypeMapping>
  1773. </EntitySetMapping>
  1774. <EntitySetMapping Name="StatusOrganization">
  1775. <EntityTypeMapping TypeName="PracticeNBAModel.StatusOrganization">
  1776. <MappingFragment StoreEntitySet="StatusOrganization">
  1777. <ScalarProperty Name="IdStatusOrganization" ColumnName="IdStatusOrganization" />
  1778. <ScalarProperty Name="NameStatusOrganization" ColumnName="NameStatusOrganization" />
  1779. </MappingFragment>
  1780. </EntityTypeMapping>
  1781. </EntitySetMapping>
  1782. <EntitySetMapping Name="sysdiagrams">
  1783. <EntityTypeMapping TypeName="PracticeNBAModel.sysdiagrams">
  1784. <MappingFragment StoreEntitySet="sysdiagrams">
  1785. <ScalarProperty Name="name" ColumnName="name" />
  1786. <ScalarProperty Name="principal_id" ColumnName="principal_id" />
  1787. <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
  1788. <ScalarProperty Name="version" ColumnName="version" />
  1789. <ScalarProperty Name="definition" ColumnName="definition" />
  1790. </MappingFragment>
  1791. </EntityTypeMapping>
  1792. </EntitySetMapping>
  1793. <EntitySetMapping Name="Team">
  1794. <EntityTypeMapping TypeName="PracticeNBAModel.Team">
  1795. <MappingFragment StoreEntitySet="Team">
  1796. <ScalarProperty Name="IdTeam" ColumnName="IdTeam" />
  1797. <ScalarProperty Name="TeamName" ColumnName="TeamName" />
  1798. <ScalarProperty Name="IdDivision" ColumnName="IdDivision" />
  1799. <ScalarProperty Name="Couch" ColumnName="Couch" />
  1800. <ScalarProperty Name="Abbr" ColumnName="Abbr" />
  1801. <ScalarProperty Name="Stadium" ColumnName="Stadium" />
  1802. <ScalarProperty Name="Logo" ColumnName="Logo" />
  1803. </MappingFragment>
  1804. </EntityTypeMapping>
  1805. </EntitySetMapping>
  1806. <EntitySetMapping Name="User">
  1807. <EntityTypeMapping TypeName="PracticeNBAModel.User">
  1808. <MappingFragment StoreEntitySet="User">
  1809. <ScalarProperty Name="IdUser" ColumnName="IdUser" />
  1810. <ScalarProperty Name="Surename" ColumnName="Surename" />
  1811. <ScalarProperty Name="Name" ColumnName="Name" />
  1812. <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
  1813. <ScalarProperty Name="LoginName" ColumnName="LoginName" />
  1814. <ScalarProperty Name="Password" ColumnName="Password" />
  1815. <ScalarProperty Name="IdGender" ColumnName="IdGender" />
  1816. <ScalarProperty Name="DateOfBirth" ColumnName="DateOfBirth" />
  1817. <ScalarProperty Name="Phone" ColumnName="Phone" />
  1818. <ScalarProperty Name="Email" ColumnName="Email" />
  1819. <ScalarProperty Name="IdRole" ColumnName="IdRole" />
  1820. </MappingFragment>
  1821. </EntityTypeMapping>
  1822. </EntitySetMapping>
  1823. </EntityContainerMapping>
  1824. </Mapping>
  1825. </edmx:Mappings>
  1826. </edmx:Runtime>
  1827. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  1828. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  1829. <Connection>
  1830. <DesignerInfoPropertySet>
  1831. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  1832. </DesignerInfoPropertySet>
  1833. </Connection>
  1834. <Options>
  1835. <DesignerInfoPropertySet>
  1836. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  1837. <DesignerProperty Name="EnablePluralization" Value="false" />
  1838. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  1839. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  1840. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  1841. </DesignerInfoPropertySet>
  1842. </Options>
  1843. <!-- Diagram content (shape and connector positions) -->
  1844. <Diagrams></Diagrams>
  1845. </Designer>
  1846. </edmx:Edmx>