123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508 |
- <?xml version="1.0" encoding="utf-8"?>
- <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
- <!-- EF Runtime content -->
- <edmx:Runtime>
- <!-- SSDL content -->
- <edmx:StorageModels>
- <Schema Namespace="Хранилище DataBaseModel" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
- <EntityType Name="Delivery_Points">
- <Key>
- <PropertyRef Name="Code_Point" />
- </Key>
- <Property Name="Code_Point" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Name_Point" Type="nvarchar" MaxLength="100" Nullable="false" />
- </EntityType>
- <EntityType Name="Manufacturer">
- <Key>
- <PropertyRef Name="Code_Manufacturer" />
- </Key>
- <Property Name="Code_Manufacturer" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Name_Manufacturer" Type="nvarchar" MaxLength="50" Nullable="false" />
- </EntityType>
- <EntityType Name="Orders">
- <Key>
- <PropertyRef Name="Code_Order" />
- </Key>
- <Property Name="Code_Order" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Date_Order" Type="date" Nullable="false" />
- <Property Name="Amount_Order" Type="decimal" Precision="10" Scale="2" Nullable="false" />
- <Property Name="Amount_Discount" Type="decimal" Precision="3" Scale="2" Nullable="false" />
- <Property Name="Code_Point" Type="int" Nullable="false" />
- <Property Name="Get_Code" Type="int" Nullable="false" />
- <Property Name="Date_Delivery" Type="date" Nullable="false" />
- </EntityType>
- <!--Ошибки, обнаруженные при создании:
- предупреждение 6002: В таблице или представлении "userNew.dbo.Orders_Products" не определен первичный ключ. Ключ был выведен, а определение таблицы или представления было создано в режиме только для чтения.-->
- <EntityType Name="Orders_Products">
- <Key>
- <PropertyRef Name="Code_Order" />
- <PropertyRef Name="Code_Product" />
- <PropertyRef Name="Count_Product_Order" />
- </Key>
- <Property Name="Code_Order" Type="int" Nullable="false" />
- <Property Name="Code_Product" Type="int" Nullable="false" />
- <Property Name="Count_Product_Order" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="Products">
- <Key>
- <PropertyRef Name="Code_Product" />
- </Key>
- <Property Name="Code_Product" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Name_Product" Type="nvarchar" MaxLength="50" Nullable="false" />
- <Property Name="Description_Product" Type="nvarchar(max)" />
- <Property Name="Code_Manufacturer" Type="int" />
- <Property Name="Price_Product" Type="decimal" Precision="10" Scale="2" Nullable="false" />
- <Property Name="Discount_Product" Type="decimal" Precision="3" Scale="2" Nullable="false" />
- <Property Name="Photo_Product" Type="nvarchar(max)" />
- </EntityType>
- <EntityType Name="Roles">
- <Key>
- <PropertyRef Name="Code_Role" />
- </Key>
- <Property Name="Code_Role" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Name_Role" Type="nvarchar" MaxLength="25" Nullable="false" />
- </EntityType>
- <EntityType Name="Users">
- <Key>
- <PropertyRef Name="Code_User" />
- </Key>
- <Property Name="Code_User" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Code_Role" Type="int" Nullable="false" />
- <Property Name="Surname_User" Type="nvarchar" MaxLength="25" Nullable="false" />
- <Property Name="Name_User" Type="nvarchar" MaxLength="25" Nullable="false" />
- <Property Name="Midname_User" Type="nvarchar" MaxLength="25" Nullable="false" />
- <Property Name="Login_User" Type="nvarchar" MaxLength="25" Nullable="false" />
- <Property Name="Password_User" Type="nvarchar" MaxLength="25" Nullable="false" />
- </EntityType>
- <!--Ошибки, обнаруженные при создании:
- предупреждение 6002: В таблице или представлении "userNew.dbo.Warehouse" не определен первичный ключ. Ключ был выведен, а определение таблицы или представления было создано в режиме только для чтения.-->
- <EntityType Name="Warehouse">
- <Key>
- <PropertyRef Name="Count_Product" />
- </Key>
- <Property Name="Code_Product" Type="int" />
- <Property Name="Count_Product" Type="int" Nullable="false" />
- </EntityType>
- <Association Name="FK__Orders__Code_Poi__31EC6D26">
- <End Role="Delivery_Points" Type="Self.Delivery_Points" Multiplicity="1" />
- <End Role="Orders" Type="Self.Orders" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Delivery_Points">
- <PropertyRef Name="Code_Point" />
- </Principal>
- <Dependent Role="Orders">
- <PropertyRef Name="Code_Point" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Orders_Pr__Code___33D4B598">
- <End Role="Orders" Type="Self.Orders" Multiplicity="1" />
- <End Role="Orders_Products" Type="Self.Orders_Products" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Orders">
- <PropertyRef Name="Code_Order" />
- </Principal>
- <Dependent Role="Orders_Products">
- <PropertyRef Name="Code_Order" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Orders_Pr__Code___34C8D9D1">
- <End Role="Products" Type="Self.Products" Multiplicity="1" />
- <End Role="Orders_Products" Type="Self.Orders_Products" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Products">
- <PropertyRef Name="Code_Product" />
- </Principal>
- <Dependent Role="Orders_Products">
- <PropertyRef Name="Code_Product" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Products__Code_M__2B3F6F97">
- <End Role="Manufacturer" Type="Self.Manufacturer" Multiplicity="0..1" />
- <End Role="Products" Type="Self.Products" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Manufacturer">
- <PropertyRef Name="Code_Manufacturer" />
- </Principal>
- <Dependent Role="Products">
- <PropertyRef Name="Code_Manufacturer" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Users__Code_Role__267ABA7A">
- <End Role="Roles" Type="Self.Roles" Multiplicity="1" />
- <End Role="Users" Type="Self.Users" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Roles">
- <PropertyRef Name="Code_Role" />
- </Principal>
- <Dependent Role="Users">
- <PropertyRef Name="Code_Role" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Warehouse__Code___2D27B809">
- <End Role="Products" Type="Self.Products" Multiplicity="0..1" />
- <End Role="Warehouse" Type="Self.Warehouse" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Products">
- <PropertyRef Name="Code_Product" />
- </Principal>
- <Dependent Role="Warehouse">
- <PropertyRef Name="Code_Product" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <EntityContainer Name="Хранилище DataBaseModelContainer">
- <EntitySet Name="Delivery_Points" EntityType="Self.Delivery_Points" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Manufacturer" EntityType="Self.Manufacturer" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Orders" EntityType="Self.Orders" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Products" EntityType="Self.Products" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Roles" EntityType="Self.Roles" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Users" EntityType="Self.Users" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="Orders_Products" EntityType="Self.Orders_Products" store:Type="Tables" store:Schema="dbo">
- <DefiningQuery>SELECT
- [Orders_Products].[Code_Order] AS [Code_Order],
- [Orders_Products].[Code_Product] AS [Code_Product],
- [Orders_Products].[Count_Product_Order] AS [Count_Product_Order]
- FROM [dbo].[Orders_Products] AS [Orders_Products]</DefiningQuery>
- </EntitySet>
- <EntitySet Name="Warehouse" EntityType="Self.Warehouse" store:Type="Tables" store:Schema="dbo">
- <DefiningQuery>SELECT
- [Warehouse].[Code_Product] AS [Code_Product],
- [Warehouse].[Count_Product] AS [Count_Product]
- FROM [dbo].[Warehouse] AS [Warehouse]</DefiningQuery>
- </EntitySet>
- <AssociationSet Name="FK__Orders__Code_Poi__31EC6D26" Association="Self.FK__Orders__Code_Poi__31EC6D26">
- <End Role="Delivery_Points" EntitySet="Delivery_Points" />
- <End Role="Orders" EntitySet="Orders" />
- </AssociationSet>
- <AssociationSet Name="FK__Orders_Pr__Code___33D4B598" Association="Self.FK__Orders_Pr__Code___33D4B598">
- <End Role="Orders" EntitySet="Orders" />
- <End Role="Orders_Products" EntitySet="Orders_Products" />
- </AssociationSet>
- <AssociationSet Name="FK__Orders_Pr__Code___34C8D9D1" Association="Self.FK__Orders_Pr__Code___34C8D9D1">
- <End Role="Products" EntitySet="Products" />
- <End Role="Orders_Products" EntitySet="Orders_Products" />
- </AssociationSet>
- <AssociationSet Name="FK__Products__Code_M__2B3F6F97" Association="Self.FK__Products__Code_M__2B3F6F97">
- <End Role="Manufacturer" EntitySet="Manufacturer" />
- <End Role="Products" EntitySet="Products" />
- </AssociationSet>
- <AssociationSet Name="FK__Users__Code_Role__267ABA7A" Association="Self.FK__Users__Code_Role__267ABA7A">
- <End Role="Roles" EntitySet="Roles" />
- <End Role="Users" EntitySet="Users" />
- </AssociationSet>
- <AssociationSet Name="FK__Warehouse__Code___2D27B809" Association="Self.FK__Warehouse__Code___2D27B809">
- <End Role="Products" EntitySet="Products" />
- <End Role="Warehouse" EntitySet="Warehouse" />
- </AssociationSet>
- </EntityContainer>
- </Schema></edmx:StorageModels>
- <!-- CSDL content -->
- <edmx:ConceptualModels>
- <Schema Namespace="DataBaseModel" 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">
- <EntityContainer Name="DataBaseEntities" annotation:LazyLoadingEnabled="true">
- <EntitySet Name="Delivery_Points" EntityType="DataBaseModel.Delivery_Points" />
- <EntitySet Name="Manufacturer" EntityType="DataBaseModel.Manufacturer" />
- <EntitySet Name="Orders" EntityType="DataBaseModel.Orders" />
- <EntitySet Name="Products" EntityType="DataBaseModel.Products" />
- <EntitySet Name="Roles" EntityType="DataBaseModel.Roles" />
- <EntitySet Name="Users" EntityType="DataBaseModel.Users" />
- <EntitySet Name="Orders_Products" EntityType="DataBaseModel.Orders_Products" />
- <EntitySet Name="Warehouse" EntityType="DataBaseModel.Warehouse" />
- <AssociationSet Name="FK__Orders__Code_Poi__31EC6D26" Association="DataBaseModel.FK__Orders__Code_Poi__31EC6D26">
- <End Role="Delivery_Points" EntitySet="Delivery_Points" />
- <End Role="Orders" EntitySet="Orders" />
- </AssociationSet>
- <AssociationSet Name="FK__Products__Code_M__2B3F6F97" Association="DataBaseModel.FK__Products__Code_M__2B3F6F97">
- <End Role="Manufacturer" EntitySet="Manufacturer" />
- <End Role="Products" EntitySet="Products" />
- </AssociationSet>
- <AssociationSet Name="FK__Orders_Pr__Code___33D4B598" Association="DataBaseModel.FK__Orders_Pr__Code___33D4B598">
- <End Role="Orders" EntitySet="Orders" />
- <End Role="Orders_Products" EntitySet="Orders_Products" />
- </AssociationSet>
- <AssociationSet Name="FK__Orders_Pr__Code___34C8D9D1" Association="DataBaseModel.FK__Orders_Pr__Code___34C8D9D1">
- <End Role="Products" EntitySet="Products" />
- <End Role="Orders_Products" EntitySet="Orders_Products" />
- </AssociationSet>
- <AssociationSet Name="FK__Warehouse__Code___2D27B809" Association="DataBaseModel.FK__Warehouse__Code___2D27B809">
- <End Role="Products" EntitySet="Products" />
- <End Role="Warehouse" EntitySet="Warehouse" />
- </AssociationSet>
- <AssociationSet Name="FK__Users__Code_Role__267ABA7A" Association="DataBaseModel.FK__Users__Code_Role__267ABA7A">
- <End Role="Roles" EntitySet="Roles" />
- <End Role="Users" EntitySet="Users" />
- </AssociationSet>
- </EntityContainer>
- <EntityType Name="Delivery_Points">
- <Key>
- <PropertyRef Name="Code_Point" />
- </Key>
- <Property Name="Code_Point" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Name_Point" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="Orders" Relationship="DataBaseModel.FK__Orders__Code_Poi__31EC6D26" FromRole="Delivery_Points" ToRole="Orders" />
- </EntityType>
- <EntityType Name="Manufacturer">
- <Key>
- <PropertyRef Name="Code_Manufacturer" />
- </Key>
- <Property Name="Code_Manufacturer" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Name_Manufacturer" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="Products" Relationship="DataBaseModel.FK__Products__Code_M__2B3F6F97" FromRole="Manufacturer" ToRole="Products" />
- </EntityType>
- <EntityType Name="Orders">
- <Key>
- <PropertyRef Name="Code_Order" />
- </Key>
- <Property Name="Code_Order" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Date_Order" Type="DateTime" Nullable="false" Precision="0" />
- <Property Name="Amount_Order" Type="Decimal" Nullable="false" Precision="10" Scale="2" />
- <Property Name="Amount_Discount" Type="Decimal" Nullable="false" Precision="3" Scale="2" />
- <Property Name="Code_Point" Type="Int32" Nullable="false" />
- <Property Name="Get_Code" Type="Int32" Nullable="false" />
- <Property Name="Date_Delivery" Type="DateTime" Nullable="false" Precision="0" />
- <NavigationProperty Name="Delivery_Points" Relationship="DataBaseModel.FK__Orders__Code_Poi__31EC6D26" FromRole="Orders" ToRole="Delivery_Points" />
- <NavigationProperty Name="Orders_Products" Relationship="DataBaseModel.FK__Orders_Pr__Code___33D4B598" FromRole="Orders" ToRole="Orders_Products" />
- </EntityType>
- <EntityType Name="Products">
- <Key>
- <PropertyRef Name="Code_Product" />
- </Key>
- <Property Name="Code_Product" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Name_Product" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="Description_Product" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
- <Property Name="Code_Manufacturer" Type="Int32" />
- <Property Name="Price_Product" Type="Decimal" Nullable="false" Precision="10" Scale="2" />
- <Property Name="Discount_Product" Type="Decimal" Nullable="false" Precision="3" Scale="2" />
- <Property Name="Photo_Product" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="Manufacturer" Relationship="DataBaseModel.FK__Products__Code_M__2B3F6F97" FromRole="Products" ToRole="Manufacturer" />
- <NavigationProperty Name="Orders_Products" Relationship="DataBaseModel.FK__Orders_Pr__Code___34C8D9D1" FromRole="Products" ToRole="Orders_Products" />
- <NavigationProperty Name="Warehouse" Relationship="DataBaseModel.FK__Warehouse__Code___2D27B809" FromRole="Products" ToRole="Warehouse" />
- </EntityType>
- <EntityType Name="Roles">
- <Key>
- <PropertyRef Name="Code_Role" />
- </Key>
- <Property Name="Code_Role" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Name_Role" Type="String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="Users" Relationship="DataBaseModel.FK__Users__Code_Role__267ABA7A" FromRole="Roles" ToRole="Users" />
- </EntityType>
- <EntityType Name="Users">
- <Key>
- <PropertyRef Name="Code_User" />
- </Key>
- <Property Name="Code_User" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Code_Role" Type="Int32" Nullable="false" />
- <Property Name="Surname_User" Type="String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true" />
- <Property Name="Name_User" Type="String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true" />
- <Property Name="Midname_User" Type="String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true" />
- <Property Name="Login_User" Type="String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true" />
- <Property Name="Password_User" Type="String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="Roles" Relationship="DataBaseModel.FK__Users__Code_Role__267ABA7A" FromRole="Users" ToRole="Roles" />
- </EntityType>
- <EntityType Name="Orders_Products">
- <Key>
- <PropertyRef Name="Code_Order" />
- <PropertyRef Name="Code_Product" />
- <PropertyRef Name="Count_Product_Order" />
- </Key>
- <Property Name="Code_Order" Type="Int32" Nullable="false" />
- <Property Name="Code_Product" Type="Int32" Nullable="false" />
- <Property Name="Count_Product_Order" Type="Int32" Nullable="false" />
- <NavigationProperty Name="Orders" Relationship="DataBaseModel.FK__Orders_Pr__Code___33D4B598" FromRole="Orders_Products" ToRole="Orders" />
- <NavigationProperty Name="Products" Relationship="DataBaseModel.FK__Orders_Pr__Code___34C8D9D1" FromRole="Orders_Products" ToRole="Products" />
- </EntityType>
- <EntityType Name="Warehouse">
- <Key>
- <PropertyRef Name="Count_Product" />
- </Key>
- <Property Name="Code_Product" Type="Int32" />
- <Property Name="Count_Product" Type="Int32" Nullable="false" />
- <NavigationProperty Name="Products" Relationship="DataBaseModel.FK__Warehouse__Code___2D27B809" FromRole="Warehouse" ToRole="Products" />
- </EntityType>
- <Association Name="FK__Orders__Code_Poi__31EC6D26">
- <End Type="DataBaseModel.Delivery_Points" Role="Delivery_Points" Multiplicity="1" />
- <End Type="DataBaseModel.Orders" Role="Orders" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Delivery_Points">
- <PropertyRef Name="Code_Point" />
- </Principal>
- <Dependent Role="Orders">
- <PropertyRef Name="Code_Point" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Products__Code_M__2B3F6F97">
- <End Type="DataBaseModel.Manufacturer" Role="Manufacturer" Multiplicity="0..1" />
- <End Type="DataBaseModel.Products" Role="Products" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Manufacturer">
- <PropertyRef Name="Code_Manufacturer" />
- </Principal>
- <Dependent Role="Products">
- <PropertyRef Name="Code_Manufacturer" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Orders_Pr__Code___33D4B598">
- <End Type="DataBaseModel.Orders" Role="Orders" Multiplicity="1" />
- <End Type="DataBaseModel.Orders_Products" Role="Orders_Products" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Orders">
- <PropertyRef Name="Code_Order" />
- </Principal>
- <Dependent Role="Orders_Products">
- <PropertyRef Name="Code_Order" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Orders_Pr__Code___34C8D9D1">
- <End Type="DataBaseModel.Products" Role="Products" Multiplicity="1" />
- <End Type="DataBaseModel.Orders_Products" Role="Orders_Products" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Products">
- <PropertyRef Name="Code_Product" />
- </Principal>
- <Dependent Role="Orders_Products">
- <PropertyRef Name="Code_Product" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Warehouse__Code___2D27B809">
- <End Type="DataBaseModel.Products" Role="Products" Multiplicity="0..1" />
- <End Type="DataBaseModel.Warehouse" Role="Warehouse" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Products">
- <PropertyRef Name="Code_Product" />
- </Principal>
- <Dependent Role="Warehouse">
- <PropertyRef Name="Code_Product" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__Users__Code_Role__267ABA7A">
- <End Type="DataBaseModel.Roles" Role="Roles" Multiplicity="1" />
- <End Type="DataBaseModel.Users" Role="Users" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Roles">
- <PropertyRef Name="Code_Role" />
- </Principal>
- <Dependent Role="Users">
- <PropertyRef Name="Code_Role" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- </Schema>
- </edmx:ConceptualModels>
- <!-- C-S mapping content -->
- <edmx:Mappings>
- <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
- <EntityContainerMapping StorageEntityContainer="Хранилище DataBaseModelContainer" CdmEntityContainer="DataBaseEntities">
- <EntitySetMapping Name="Delivery_Points">
- <EntityTypeMapping TypeName="DataBaseModel.Delivery_Points">
- <MappingFragment StoreEntitySet="Delivery_Points">
- <ScalarProperty Name="Name_Point" ColumnName="Name_Point" />
- <ScalarProperty Name="Code_Point" ColumnName="Code_Point" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Manufacturer">
- <EntityTypeMapping TypeName="DataBaseModel.Manufacturer">
- <MappingFragment StoreEntitySet="Manufacturer">
- <ScalarProperty Name="Name_Manufacturer" ColumnName="Name_Manufacturer" />
- <ScalarProperty Name="Code_Manufacturer" ColumnName="Code_Manufacturer" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Orders">
- <EntityTypeMapping TypeName="DataBaseModel.Orders">
- <MappingFragment StoreEntitySet="Orders">
- <ScalarProperty Name="Date_Delivery" ColumnName="Date_Delivery" />
- <ScalarProperty Name="Get_Code" ColumnName="Get_Code" />
- <ScalarProperty Name="Code_Point" ColumnName="Code_Point" />
- <ScalarProperty Name="Amount_Discount" ColumnName="Amount_Discount" />
- <ScalarProperty Name="Amount_Order" ColumnName="Amount_Order" />
- <ScalarProperty Name="Date_Order" ColumnName="Date_Order" />
- <ScalarProperty Name="Code_Order" ColumnName="Code_Order" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Products">
- <EntityTypeMapping TypeName="DataBaseModel.Products">
- <MappingFragment StoreEntitySet="Products">
- <ScalarProperty Name="Photo_Product" ColumnName="Photo_Product" />
- <ScalarProperty Name="Discount_Product" ColumnName="Discount_Product" />
- <ScalarProperty Name="Price_Product" ColumnName="Price_Product" />
- <ScalarProperty Name="Code_Manufacturer" ColumnName="Code_Manufacturer" />
- <ScalarProperty Name="Description_Product" ColumnName="Description_Product" />
- <ScalarProperty Name="Name_Product" ColumnName="Name_Product" />
- <ScalarProperty Name="Code_Product" ColumnName="Code_Product" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Roles">
- <EntityTypeMapping TypeName="DataBaseModel.Roles">
- <MappingFragment StoreEntitySet="Roles">
- <ScalarProperty Name="Name_Role" ColumnName="Name_Role" />
- <ScalarProperty Name="Code_Role" ColumnName="Code_Role" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Users">
- <EntityTypeMapping TypeName="DataBaseModel.Users">
- <MappingFragment StoreEntitySet="Users">
- <ScalarProperty Name="Password_User" ColumnName="Password_User" />
- <ScalarProperty Name="Login_User" ColumnName="Login_User" />
- <ScalarProperty Name="Midname_User" ColumnName="Midname_User" />
- <ScalarProperty Name="Name_User" ColumnName="Name_User" />
- <ScalarProperty Name="Surname_User" ColumnName="Surname_User" />
- <ScalarProperty Name="Code_Role" ColumnName="Code_Role" />
- <ScalarProperty Name="Code_User" ColumnName="Code_User" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Orders_Products">
- <EntityTypeMapping TypeName="DataBaseModel.Orders_Products">
- <MappingFragment StoreEntitySet="Orders_Products">
- <ScalarProperty Name="Count_Product_Order" ColumnName="Count_Product_Order" />
- <ScalarProperty Name="Code_Product" ColumnName="Code_Product" />
- <ScalarProperty Name="Code_Order" ColumnName="Code_Order" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Warehouse">
- <EntityTypeMapping TypeName="DataBaseModel.Warehouse">
- <MappingFragment StoreEntitySet="Warehouse">
- <ScalarProperty Name="Count_Product" ColumnName="Count_Product" />
- <ScalarProperty Name="Code_Product" ColumnName="Code_Product" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- </EntityContainerMapping>
- </Mapping>
- </edmx:Mappings>
- </edmx:Runtime>
- <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
- <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
- <Connection>
- <DesignerInfoPropertySet>
- <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
- </DesignerInfoPropertySet>
- </Connection>
- <Options>
- <DesignerInfoPropertySet>
- <DesignerProperty Name="ValidateOnBuild" Value="true" />
- <DesignerProperty Name="EnablePluralization" Value="false" />
- <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
- <DesignerProperty Name="UseLegacyProvider" Value="false" />
- <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
- </DesignerInfoPropertySet>
- </Options>
- <!-- Diagram content (shape and connector positions) -->
- <Diagrams></Diagrams>
- </Designer>
- </edmx:Edmx>
|