Salary.edmx 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291
  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="Хранилище Exam19Model" 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="EarningsDeductions">
  9. <Key>
  10. <PropertyRef Name="Tab_number" />
  11. </Key>
  12. <Property Name="Tab_number" Type="int" Nullable="false" />
  13. <Property Name="Earning_deduction_code" Type="int" Nullable="false" />
  14. </EntityType>
  15. <EntityType Name="EarningsDiductionsDirectory">
  16. <Key>
  17. <PropertyRef Name="Earning_deduction_code" />
  18. </Key>
  19. <Property Name="Earning_deduction_code" Type="int" Nullable="false" />
  20. <Property Name="Percentage" Type="decimal" Precision="5" Scale="2" Nullable="false" />
  21. </EntityType>
  22. <EntityType Name="PersonalInfo">
  23. <Key>
  24. <PropertyRef Name="Tab_number" />
  25. </Key>
  26. <Property Name="Tab_number" Type="int" Nullable="false" />
  27. <Property Name="Surname" Type="nvarchar" MaxLength="50" Nullable="false" />
  28. <Property Name="Name" Type="nvarchar" MaxLength="50" Nullable="false" />
  29. <Property Name="Patronymic" Type="nvarchar" MaxLength="50" Nullable="false" />
  30. <Property Name="Position_code" Type="int" Nullable="false" />
  31. <Property Name="Salary" Type="decimal" Precision="10" Scale="2" Nullable="false" />
  32. <Property Name="Worked_hours" Type="decimal" Precision="5" Scale="2" Nullable="false" />
  33. </EntityType>
  34. <EntityType Name="Positions">
  35. <Key>
  36. <PropertyRef Name="Positin_code" />
  37. </Key>
  38. <Property Name="Positin_code" Type="int" Nullable="false" />
  39. <Property Name="Position_name" Type="nvarchar" MaxLength="50" Nullable="false" />
  40. </EntityType>
  41. <EntityType Name="sysdiagrams">
  42. <Key>
  43. <PropertyRef Name="diagram_id" />
  44. </Key>
  45. <Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
  46. <Property Name="principal_id" Type="int" Nullable="false" />
  47. <Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  48. <Property Name="version" Type="int" />
  49. <Property Name="definition" Type="varbinary(max)" />
  50. </EntityType>
  51. <Association Name="FK_EarningsDeductions_EarningsDiductionsDirectory">
  52. <End Role="EarningsDiductionsDirectory" Type="Self.EarningsDiductionsDirectory" Multiplicity="1" />
  53. <End Role="EarningsDeductions" Type="Self.EarningsDeductions" Multiplicity="*" />
  54. <ReferentialConstraint>
  55. <Principal Role="EarningsDiductionsDirectory">
  56. <PropertyRef Name="Earning_deduction_code" />
  57. </Principal>
  58. <Dependent Role="EarningsDeductions">
  59. <PropertyRef Name="Earning_deduction_code" />
  60. </Dependent>
  61. </ReferentialConstraint>
  62. </Association>
  63. <Association Name="FK_EarningsDeductions_PersonalInfo">
  64. <End Role="PersonalInfo" Type="Self.PersonalInfo" Multiplicity="1" />
  65. <End Role="EarningsDeductions" Type="Self.EarningsDeductions" Multiplicity="*" />
  66. <ReferentialConstraint>
  67. <Principal Role="PersonalInfo">
  68. <PropertyRef Name="Tab_number" />
  69. </Principal>
  70. <Dependent Role="EarningsDeductions">
  71. <PropertyRef Name="Earning_deduction_code" />
  72. </Dependent>
  73. </ReferentialConstraint>
  74. </Association>
  75. <Association Name="FK_PersonalInfo_Positions">
  76. <End Role="Positions" Type="Self.Positions" Multiplicity="1" />
  77. <End Role="PersonalInfo" Type="Self.PersonalInfo" Multiplicity="*" />
  78. <ReferentialConstraint>
  79. <Principal Role="Positions">
  80. <PropertyRef Name="Positin_code" />
  81. </Principal>
  82. <Dependent Role="PersonalInfo">
  83. <PropertyRef Name="Position_code" />
  84. </Dependent>
  85. </ReferentialConstraint>
  86. </Association>
  87. <EntityContainer Name="Хранилище Exam19ModelContainer">
  88. <EntitySet Name="EarningsDeductions" EntityType="Self.EarningsDeductions" Schema="dbo" store:Type="Tables" />
  89. <EntitySet Name="EarningsDiductionsDirectory" EntityType="Self.EarningsDiductionsDirectory" Schema="dbo" store:Type="Tables" />
  90. <EntitySet Name="PersonalInfo" EntityType="Self.PersonalInfo" Schema="dbo" store:Type="Tables" />
  91. <EntitySet Name="Positions" EntityType="Self.Positions" Schema="dbo" store:Type="Tables" />
  92. <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
  93. <AssociationSet Name="FK_EarningsDeductions_EarningsDiductionsDirectory" Association="Self.FK_EarningsDeductions_EarningsDiductionsDirectory">
  94. <End Role="EarningsDiductionsDirectory" EntitySet="EarningsDiductionsDirectory" />
  95. <End Role="EarningsDeductions" EntitySet="EarningsDeductions" />
  96. </AssociationSet>
  97. <AssociationSet Name="FK_EarningsDeductions_PersonalInfo" Association="Self.FK_EarningsDeductions_PersonalInfo">
  98. <End Role="PersonalInfo" EntitySet="PersonalInfo" />
  99. <End Role="EarningsDeductions" EntitySet="EarningsDeductions" />
  100. </AssociationSet>
  101. <AssociationSet Name="FK_PersonalInfo_Positions" Association="Self.FK_PersonalInfo_Positions">
  102. <End Role="Positions" EntitySet="Positions" />
  103. <End Role="PersonalInfo" EntitySet="PersonalInfo" />
  104. </AssociationSet>
  105. </EntityContainer>
  106. </Schema></edmx:StorageModels>
  107. <!-- CSDL content -->
  108. <edmx:ConceptualModels>
  109. <Schema Namespace="Exam19Model" 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">
  110. <EntityContainer Name="Exam19Entities" annotation:LazyLoadingEnabled="true">
  111. <EntitySet Name="EarningsDeductions" EntityType="Exam19Model.EarningsDeduction" />
  112. <EntitySet Name="EarningsDiductionsDirectories" EntityType="Exam19Model.EarningsDiductionsDirectory" />
  113. <EntitySet Name="PersonalInfoes" EntityType="Exam19Model.PersonalInfo" />
  114. <EntitySet Name="Positions" EntityType="Exam19Model.Position" />
  115. <EntitySet Name="sysdiagrams" EntityType="Exam19Model.sysdiagram" />
  116. <AssociationSet Name="FK_EarningsDeductions_EarningsDiductionsDirectory" Association="Exam19Model.FK_EarningsDeductions_EarningsDiductionsDirectory">
  117. <End Role="EarningsDiductionsDirectory" EntitySet="EarningsDiductionsDirectories" />
  118. <End Role="EarningsDeduction" EntitySet="EarningsDeductions" />
  119. </AssociationSet>
  120. <AssociationSet Name="FK_EarningsDeductions_PersonalInfo" Association="Exam19Model.FK_EarningsDeductions_PersonalInfo">
  121. <End Role="PersonalInfo" EntitySet="PersonalInfoes" />
  122. <End Role="EarningsDeduction" EntitySet="EarningsDeductions" />
  123. </AssociationSet>
  124. <AssociationSet Name="FK_PersonalInfo_Positions" Association="Exam19Model.FK_PersonalInfo_Positions">
  125. <End Role="Position" EntitySet="Positions" />
  126. <End Role="PersonalInfo" EntitySet="PersonalInfoes" />
  127. </AssociationSet>
  128. </EntityContainer>
  129. <EntityType Name="EarningsDeduction">
  130. <Key>
  131. <PropertyRef Name="Tab_number" />
  132. </Key>
  133. <Property Name="Tab_number" Type="Int32" Nullable="false" />
  134. <Property Name="Earning_deduction_code" Type="Int32" Nullable="false" />
  135. <NavigationProperty Name="EarningsDiductionsDirectory" Relationship="Exam19Model.FK_EarningsDeductions_EarningsDiductionsDirectory" FromRole="EarningsDeduction" ToRole="EarningsDiductionsDirectory" />
  136. <NavigationProperty Name="PersonalInfo" Relationship="Exam19Model.FK_EarningsDeductions_PersonalInfo" FromRole="EarningsDeduction" ToRole="PersonalInfo" />
  137. </EntityType>
  138. <EntityType Name="EarningsDiductionsDirectory">
  139. <Key>
  140. <PropertyRef Name="Earning_deduction_code" />
  141. </Key>
  142. <Property Name="Earning_deduction_code" Type="Int32" Nullable="false" />
  143. <Property Name="Percentage" Type="Decimal" Nullable="false" Precision="5" Scale="2" />
  144. <NavigationProperty Name="EarningsDeductions" Relationship="Exam19Model.FK_EarningsDeductions_EarningsDiductionsDirectory" FromRole="EarningsDiductionsDirectory" ToRole="EarningsDeduction" />
  145. </EntityType>
  146. <EntityType Name="PersonalInfo">
  147. <Key>
  148. <PropertyRef Name="Tab_number" />
  149. </Key>
  150. <Property Name="Tab_number" Type="Int32" Nullable="false" />
  151. <Property Name="Surname" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  152. <Property Name="Name" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  153. <Property Name="Patronymic" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  154. <Property Name="Position_code" Type="Int32" Nullable="false" />
  155. <Property Name="Salary" Type="Decimal" Nullable="false" Precision="10" Scale="2" />
  156. <Property Name="Worked_hours" Type="Decimal" Nullable="false" Precision="5" Scale="2" />
  157. <NavigationProperty Name="EarningsDeductions" Relationship="Exam19Model.FK_EarningsDeductions_PersonalInfo" FromRole="PersonalInfo" ToRole="EarningsDeduction" />
  158. <NavigationProperty Name="Position" Relationship="Exam19Model.FK_PersonalInfo_Positions" FromRole="PersonalInfo" ToRole="Position" />
  159. </EntityType>
  160. <EntityType Name="Position">
  161. <Key>
  162. <PropertyRef Name="Positin_code" />
  163. </Key>
  164. <Property Name="Positin_code" Type="Int32" Nullable="false" />
  165. <Property Name="Position_name" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  166. <NavigationProperty Name="PersonalInfoes" Relationship="Exam19Model.FK_PersonalInfo_Positions" FromRole="Position" ToRole="PersonalInfo" />
  167. </EntityType>
  168. <EntityType Name="sysdiagram">
  169. <Key>
  170. <PropertyRef Name="diagram_id" />
  171. </Key>
  172. <Property Name="name" Type="String" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" />
  173. <Property Name="principal_id" Type="Int32" Nullable="false" />
  174. <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  175. <Property Name="version" Type="Int32" />
  176. <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
  177. </EntityType>
  178. <Association Name="FK_EarningsDeductions_EarningsDiductionsDirectory">
  179. <End Type="Exam19Model.EarningsDiductionsDirectory" Role="EarningsDiductionsDirectory" Multiplicity="1" />
  180. <End Type="Exam19Model.EarningsDeduction" Role="EarningsDeduction" Multiplicity="*" />
  181. <ReferentialConstraint>
  182. <Principal Role="EarningsDiductionsDirectory">
  183. <PropertyRef Name="Earning_deduction_code" />
  184. </Principal>
  185. <Dependent Role="EarningsDeduction">
  186. <PropertyRef Name="Earning_deduction_code" />
  187. </Dependent>
  188. </ReferentialConstraint>
  189. </Association>
  190. <Association Name="FK_EarningsDeductions_PersonalInfo">
  191. <End Type="Exam19Model.PersonalInfo" Role="PersonalInfo" Multiplicity="1" />
  192. <End Type="Exam19Model.EarningsDeduction" Role="EarningsDeduction" Multiplicity="*" />
  193. <ReferentialConstraint>
  194. <Principal Role="PersonalInfo">
  195. <PropertyRef Name="Tab_number" />
  196. </Principal>
  197. <Dependent Role="EarningsDeduction">
  198. <PropertyRef Name="Earning_deduction_code" />
  199. </Dependent>
  200. </ReferentialConstraint>
  201. </Association>
  202. <Association Name="FK_PersonalInfo_Positions">
  203. <End Type="Exam19Model.Position" Role="Position" Multiplicity="1" />
  204. <End Type="Exam19Model.PersonalInfo" Role="PersonalInfo" Multiplicity="*" />
  205. <ReferentialConstraint>
  206. <Principal Role="Position">
  207. <PropertyRef Name="Positin_code" />
  208. </Principal>
  209. <Dependent Role="PersonalInfo">
  210. <PropertyRef Name="Position_code" />
  211. </Dependent>
  212. </ReferentialConstraint>
  213. </Association>
  214. </Schema>
  215. </edmx:ConceptualModels>
  216. <!-- C-S mapping content -->
  217. <edmx:Mappings>
  218. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  219. <EntityContainerMapping StorageEntityContainer="Хранилище Exam19ModelContainer" CdmEntityContainer="Exam19Entities">
  220. <EntitySetMapping Name="EarningsDeductions">
  221. <EntityTypeMapping TypeName="Exam19Model.EarningsDeduction">
  222. <MappingFragment StoreEntitySet="EarningsDeductions">
  223. <ScalarProperty Name="Earning_deduction_code" ColumnName="Earning_deduction_code" />
  224. <ScalarProperty Name="Tab_number" ColumnName="Tab_number" />
  225. </MappingFragment>
  226. </EntityTypeMapping>
  227. </EntitySetMapping>
  228. <EntitySetMapping Name="EarningsDiductionsDirectories">
  229. <EntityTypeMapping TypeName="Exam19Model.EarningsDiductionsDirectory">
  230. <MappingFragment StoreEntitySet="EarningsDiductionsDirectory">
  231. <ScalarProperty Name="Percentage" ColumnName="Percentage" />
  232. <ScalarProperty Name="Earning_deduction_code" ColumnName="Earning_deduction_code" />
  233. </MappingFragment>
  234. </EntityTypeMapping>
  235. </EntitySetMapping>
  236. <EntitySetMapping Name="PersonalInfoes">
  237. <EntityTypeMapping TypeName="Exam19Model.PersonalInfo">
  238. <MappingFragment StoreEntitySet="PersonalInfo">
  239. <ScalarProperty Name="Worked_hours" ColumnName="Worked_hours" />
  240. <ScalarProperty Name="Salary" ColumnName="Salary" />
  241. <ScalarProperty Name="Position_code" ColumnName="Position_code" />
  242. <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
  243. <ScalarProperty Name="Name" ColumnName="Name" />
  244. <ScalarProperty Name="Surname" ColumnName="Surname" />
  245. <ScalarProperty Name="Tab_number" ColumnName="Tab_number" />
  246. </MappingFragment>
  247. </EntityTypeMapping>
  248. </EntitySetMapping>
  249. <EntitySetMapping Name="Positions">
  250. <EntityTypeMapping TypeName="Exam19Model.Position">
  251. <MappingFragment StoreEntitySet="Positions">
  252. <ScalarProperty Name="Position_name" ColumnName="Position_name" />
  253. <ScalarProperty Name="Positin_code" ColumnName="Positin_code" />
  254. </MappingFragment>
  255. </EntityTypeMapping>
  256. </EntitySetMapping>
  257. <EntitySetMapping Name="sysdiagrams">
  258. <EntityTypeMapping TypeName="Exam19Model.sysdiagram">
  259. <MappingFragment StoreEntitySet="sysdiagrams">
  260. <ScalarProperty Name="definition" ColumnName="definition" />
  261. <ScalarProperty Name="version" ColumnName="version" />
  262. <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
  263. <ScalarProperty Name="principal_id" ColumnName="principal_id" />
  264. <ScalarProperty Name="name" ColumnName="name" />
  265. </MappingFragment>
  266. </EntityTypeMapping>
  267. </EntitySetMapping>
  268. </EntityContainerMapping>
  269. </Mapping>
  270. </edmx:Mappings>
  271. </edmx:Runtime>
  272. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  273. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  274. <Connection>
  275. <DesignerInfoPropertySet>
  276. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  277. </DesignerInfoPropertySet>
  278. </Connection>
  279. <Options>
  280. <DesignerInfoPropertySet>
  281. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  282. <DesignerProperty Name="EnablePluralization" Value="True" />
  283. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  284. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  285. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  286. </DesignerInfoPropertySet>
  287. </Options>
  288. <!-- Diagram content (shape and connector positions) -->
  289. <Diagrams></Diagrams>
  290. </Designer>
  291. </edmx:Edmx>