123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899 |
- <?xml version="1.0" encoding="utf-8"?>
- <Schema Namespace="TestProductModel" 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="TestProductEntities" annotation:LazyLoadingEnabled="true">
- <EntitySet Name="Basket" EntityType="TestProductModel.Basket" />
- <EntitySet Name="PickPoint" EntityType="TestProductModel.PickPoint" />
- <EntitySet Name="Product" EntityType="TestProductModel.Product" />
- <EntitySet Name="ProductBaskets" EntityType="TestProductModel.ProductBaskets" />
- <AssociationSet Name="FK_Basket_PickPoint" Association="TestProductModel.FK_Basket_PickPoint">
- <End Role="PickPoint" EntitySet="PickPoint" />
- <End Role="Basket" EntitySet="Basket" />
- </AssociationSet>
- <AssociationSet Name="FK_ProductBaskets_Basket" Association="TestProductModel.FK_ProductBaskets_Basket">
- <End Role="Basket" EntitySet="Basket" />
- <End Role="ProductBaskets" EntitySet="ProductBaskets" />
- </AssociationSet>
- <AssociationSet Name="FK_ProductBaskets_Product" Association="TestProductModel.FK_ProductBaskets_Product">
- <End Role="Product" EntitySet="Product" />
- <End Role="ProductBaskets" EntitySet="ProductBaskets" />
- </AssociationSet>
- </EntityContainer>
- <EntityType Name="Basket">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Price" Type="Double" Nullable="false" />
- <Property Name="CountProduct" Type="Int32" Nullable="false" />
- <Property Name="IdPickPoint" Type="Int32" Nullable="false" />
- <Property Name="Date" Type="DateTime" Precision="0" />
- <NavigationProperty Name="PickPoint" Relationship="TestProductModel.FK_Basket_PickPoint" FromRole="Basket" ToRole="PickPoint" />
- <NavigationProperty Name="ProductBaskets" Relationship="TestProductModel.FK_ProductBaskets_Basket" FromRole="Basket" ToRole="ProductBaskets" />
- </EntityType>
- <EntityType Name="PickPoint">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Kind" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="Basket" Relationship="TestProductModel.FK_Basket_PickPoint" FromRole="PickPoint" ToRole="Basket" />
- </EntityType>
- <EntityType Name="Product">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="ProductName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="ProductDescription" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
- <Property Name="ProductPhoto" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
- <Property Name="ProductCost" Type="Double" Nullable="false" />
- <Property Name="ProductDiscount" Type="Int32" />
- <NavigationProperty Name="ProductBaskets" Relationship="TestProductModel.FK_ProductBaskets_Product" FromRole="Product" ToRole="ProductBaskets" />
- </EntityType>
- <EntityType Name="ProductBaskets">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdProduct" Type="Int32" Nullable="false" />
- <Property Name="IdBasket" Type="Int32" Nullable="false" />
- <NavigationProperty Name="Basket" Relationship="TestProductModel.FK_ProductBaskets_Basket" FromRole="ProductBaskets" ToRole="Basket" />
- <NavigationProperty Name="Product" Relationship="TestProductModel.FK_ProductBaskets_Product" FromRole="ProductBaskets" ToRole="Product" />
- </EntityType>
- <Association Name="FK_Basket_PickPoint">
- <End Type="TestProductModel.PickPoint" Role="PickPoint" Multiplicity="1" />
- <End Type="TestProductModel.Basket" Role="Basket" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="PickPoint">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="Basket">
- <PropertyRef Name="IdPickPoint" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_ProductBaskets_Basket">
- <End Type="TestProductModel.Basket" Role="Basket" Multiplicity="1" />
- <End Type="TestProductModel.ProductBaskets" Role="ProductBaskets" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Basket">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="ProductBaskets">
- <PropertyRef Name="IdBasket" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_ProductBaskets_Product">
- <End Type="TestProductModel.Product" Role="Product" Multiplicity="1" />
- <End Type="TestProductModel.ProductBaskets" Role="ProductBaskets" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Product">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="ProductBaskets">
- <PropertyRef Name="IdProduct" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- </Schema>
|