123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173 |
- <?xml version="1.0" encoding="utf-8"?>
- <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
- <EntityContainerMapping StorageEntityContainer="Хранилище KadroviYshotModelContainer" CdmEntityContainer="KadroviYshotEntities">
- <EntitySetMapping Name="Childrens">
- <EntityTypeMapping TypeName="KadroviYshotModel.Childrens">
- <MappingFragment StoreEntitySet="Childrens">
- <ScalarProperty Name="IdChildren" ColumnName="IdChildren" />
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- <ScalarProperty Name="Type" ColumnName="Type" />
- <ScalarProperty Name="FullName" ColumnName="FullName" />
- <ScalarProperty Name="DateBirth" ColumnName="DateBirth" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Dolzhnosts">
- <EntityTypeMapping TypeName="KadroviYshotModel.Dolzhnosts">
- <MappingFragment StoreEntitySet="Dolzhnosts">
- <ScalarProperty Name="IdDolzhnost" ColumnName="IdDolzhnost" />
- <ScalarProperty Name="NameDolzhnost" ColumnName="NameDolzhnost" />
- <ScalarProperty Name="Salary" ColumnName="Salary" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Educations">
- <EntityTypeMapping TypeName="KadroviYshotModel.Educations">
- <MappingFragment StoreEntitySet="Educations">
- <ScalarProperty Name="IdEducation" ColumnName="IdEducation" />
- <ScalarProperty Name="Establishment" ColumnName="Establishment" />
- <ScalarProperty Name="YearEnding" ColumnName="YearEnding" />
- <ScalarProperty Name="Qualification" ColumnName="Qualification" />
- <ScalarProperty Name="Speciality" ColumnName="Speciality" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Employees">
- <EntityTypeMapping TypeName="KadroviYshotModel.Employees">
- <MappingFragment StoreEntitySet="Employees">
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- <ScalarProperty Name="Surname" ColumnName="Surname" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="Otchestvo" ColumnName="Otchestvo" />
- <ScalarProperty Name="DateBirth" ColumnName="DateBirth" />
- <ScalarProperty Name="IdDolzhnost" ColumnName="IdDolzhnost" />
- <ScalarProperty Name="IdFamilyStatus" ColumnName="IdFamilyStatus" />
- <ScalarProperty Name="AddressResidence" ColumnName="AddressResidence" />
- <ScalarProperty Name="Telephone" ColumnName="Telephone" />
- <ScalarProperty Name="DateReceipt" ColumnName="DateReceipt" />
- <ScalarProperty Name="IdEducation" ColumnName="IdEducation" />
- <ScalarProperty Name="IdChildren" ColumnName="IdChildren" />
- <ScalarProperty Name="IdMilitaryDuty" ColumnName="IdMilitaryDuty" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="FamilyStatuses">
- <EntityTypeMapping TypeName="KadroviYshotModel.FamilyStatuses">
- <MappingFragment StoreEntitySet="FamilyStatuses">
- <ScalarProperty Name="IdFamilyStatus" ColumnName="IdFamilyStatus" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="MilitaryDuties">
- <EntityTypeMapping TypeName="KadroviYshotModel.MilitaryDuties">
- <MappingFragment StoreEntitySet="MilitaryDuties">
- <ScalarProperty Name="IdMilitaryDuty" ColumnName="IdMilitaryDuty" />
- <ScalarProperty Name="MilitaryIdNumber" ColumnName="MilitaryIdNumber" />
- <ScalarProperty Name="AccountingGroup" ColumnName="AccountingGroup" />
- <ScalarProperty Name="MilitaryRank" ColumnName="MilitaryRank" />
- <ScalarProperty Name="Profile" ColumnName="Profile" />
- <ScalarProperty Name="ReserveRank" ColumnName="ReserveRank" />
- <ScalarProperty Name="DateReceipt" ColumnName="DateReceipt" />
- <ScalarProperty Name="DateWithdrawal" ColumnName="DateWithdrawal" />
- <ScalarProperty Name="Base" ColumnName="Base" />
- <ScalarProperty Name="SpecialAccount" ColumnName="SpecialAccount" />
- <ScalarProperty Name="MilitaryRegistrationNumber" ColumnName="MilitaryRegistrationNumber" />
- <ScalarProperty Name="MilitaryPositionCode" ColumnName="MilitaryPositionCode" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="OrdersDismissal">
- <EntityTypeMapping TypeName="KadroviYshotModel.OrdersDismissal">
- <MappingFragment StoreEntitySet="OrdersDismissal">
- <ScalarProperty Name="IdDismissal" ColumnName="IdDismissal" />
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- <ScalarProperty Name="DateApproval" ColumnName="DateApproval" />
- <ScalarProperty Name="Grounds" ColumnName="Grounds" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="OrdersEmployment">
- <EntityTypeMapping TypeName="KadroviYshotModel.OrdersEmployment">
- <MappingFragment StoreEntitySet="OrdersEmployment">
- <ScalarProperty Name="IdAcceptanceWork" ColumnName="IdAcceptanceWork" />
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- <ScalarProperty Name="IdStaffingTable" ColumnName="IdStaffingTable" />
- <ScalarProperty Name="IdDolzhnost" ColumnName="IdDolzhnost" />
- <ScalarProperty Name="DateApproval" ColumnName="DateApproval" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Roles">
- <EntityTypeMapping TypeName="KadroviYshotModel.Roles">
- <MappingFragment StoreEntitySet="Roles">
- <ScalarProperty Name="IdRole" ColumnName="IdRole" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="StaffingTables">
- <EntityTypeMapping TypeName="KadroviYshotModel.StaffingTables">
- <MappingFragment StoreEntitySet="StaffingTables">
- <ScalarProperty Name="IdStaffingTable" ColumnName="IdStaffingTable" />
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- <ScalarProperty Name="IdSubdivision" ColumnName="IdSubdivision" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Subdivisions">
- <EntityTypeMapping TypeName="KadroviYshotModel.Subdivisions">
- <MappingFragment StoreEntitySet="Subdivisions">
- <ScalarProperty Name="IdSubdivision" ColumnName="IdSubdivision" />
- <ScalarProperty Name="NameSubdivision" ColumnName="NameSubdivision" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="sysdiagrams">
- <EntityTypeMapping TypeName="KadroviYshotModel.sysdiagrams">
- <MappingFragment StoreEntitySet="sysdiagrams">
- <ScalarProperty Name="name" ColumnName="name" />
- <ScalarProperty Name="principal_id" ColumnName="principal_id" />
- <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
- <ScalarProperty Name="version" ColumnName="version" />
- <ScalarProperty Name="definition" ColumnName="definition" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Users">
- <EntityTypeMapping TypeName="KadroviYshotModel.Users">
- <MappingFragment StoreEntitySet="Users">
- <ScalarProperty Name="IdUser" ColumnName="IdUser" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="Login" ColumnName="Login" />
- <ScalarProperty Name="Password" ColumnName="Password" />
- <ScalarProperty Name="IdRole" ColumnName="IdRole" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <FunctionImportMapping FunctionImportName="sp_alterdiagram" FunctionName="Хранилище KadroviYshotModel.sp_alterdiagram" />
- <FunctionImportMapping FunctionImportName="sp_creatediagram" FunctionName="Хранилище KadroviYshotModel.sp_creatediagram" />
- <FunctionImportMapping FunctionImportName="sp_dropdiagram" FunctionName="Хранилище KadroviYshotModel.sp_dropdiagram" />
- <FunctionImportMapping FunctionImportName="sp_helpdiagramdefinition" FunctionName="Хранилище KadroviYshotModel.sp_helpdiagramdefinition">
- <ResultMapping>
- <ComplexTypeMapping TypeName="KadroviYshotModel.sp_helpdiagramdefinition_Result">
- <ScalarProperty Name="version" ColumnName="version" />
- <ScalarProperty Name="definition" ColumnName="definition" />
- </ComplexTypeMapping>
- </ResultMapping>
- </FunctionImportMapping>
- <FunctionImportMapping FunctionImportName="sp_helpdiagrams" FunctionName="Хранилище KadroviYshotModel.sp_helpdiagrams">
- <ResultMapping>
- <ComplexTypeMapping TypeName="KadroviYshotModel.sp_helpdiagrams_Result">
- <ScalarProperty Name="Database" ColumnName="Database" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Owner" ColumnName="Owner" />
- <ScalarProperty Name="OwnerID" ColumnName="OwnerID" />
- </ComplexTypeMapping>
- </ResultMapping>
- </FunctionImportMapping>
- <FunctionImportMapping FunctionImportName="sp_renamediagram" FunctionName="Хранилище KadroviYshotModel.sp_renamediagram" />
- <FunctionImportMapping FunctionImportName="sp_upgraddiagrams" FunctionName="Хранилище KadroviYshotModel.sp_upgraddiagrams" />
- </EntityContainerMapping>
- </Mapping>
|