Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-8"?>
- <Schema Namespace="ShoppingModel" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
- <EntityContainer Name="ShoppingModelContainer">
- <EntitySet Name="Categories" EntityType="ShoppingModel.Categories" store:Type="Tables" Schema="dbo" />
- <EntitySet Name="Customers" EntityType="ShoppingModel.Customers" store:Type="Tables" Schema="dbo" />
- <EntitySet Name="OrderItems" EntityType="ShoppingModel.OrderItems" store:Type="Tables" Schema="dbo" />
- <EntitySet Name="Orders" EntityType="ShoppingModel.Orders" store:Type="Tables" Schema="dbo" />
- <EntitySet Name="Products" EntityType="ShoppingModel.Products" store:Type="Tables" Schema="dbo" />
- <EntitySet Name="sysdiagrams" EntityType="ShoppingModel.sysdiagrams" store:Type="Tables" Schema="dbo" />
- <AssociationSet Name="ForeignKeyItemsToOrder" Association="ShoppingModel.ForeignKeyItemsToOrder">
- <End Role="Orders" EntitySet="Orders" />
- <End Role="OrderItems" EntitySet="OrderItems" />
- </AssociationSet>
- <AssociationSet Name="ForeignKeyItemToProduct" Association="ShoppingModel.ForeignKeyItemToProduct">
- <End Role="Products" EntitySet="Products" />
- <End Role="OrderItems" EntitySet="OrderItems" />
- </AssociationSet>
- <AssociationSet Name="ForeignKeyOrdersToCustomers" Association="ShoppingModel.ForeignKeyOrdersToCustomers">
- <End Role="Customers" EntitySet="Customers" />
- <End Role="Orders" EntitySet="Orders" />
- </AssociationSet>
- <AssociationSet Name="ForeignKeyProductToCategory" Association="ShoppingModel.ForeignKeyProductToCategory">
- <End Role="Categories" EntitySet="Categories" />
- <End Role="Products" EntitySet="Products" />
- </AssociationSet>
- </EntityContainer>
- <EntityType Name="Categories">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="uniqueidentifier" Nullable="false" />
- <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="256" />
- </EntityType>
- <EntityType Name="Customers">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="uniqueidentifier" Nullable="false" />
- <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="256" />
- <Property Name="Surname" Type="nvarchar" Nullable="false" MaxLength="256" />
- </EntityType>
- <EntityType Name="OrderItems">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="uniqueidentifier" Nullable="false" />
- <Property Name="OrderId" Type="uniqueidentifier" Nullable="false" />
- <Property Name="ProductId" Type="uniqueidentifier" Nullable="false" />
- <Property Name="Count" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="Orders">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="uniqueidentifier" Nullable="false" />
- <Property Name="CustomerId" Type="uniqueidentifier" Nullable="false" />
- <Property Name="TotalPrice" Type="decimal" Nullable="false" />
- </EntityType>
- <EntityType Name="Products">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="uniqueidentifier" Nullable="false" />
- <Property Name="CategoryId" Type="uniqueidentifier" Nullable="false" />
- <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="256" />
- <Property Name="Price" Type="decimal" Nullable="false" />
- </EntityType>
- <EntityType Name="sysdiagrams">
- <Key>
- <PropertyRef Name="diagram_id" />
- </Key>
- <Property Name="name" Type="nvarchar" Nullable="false" MaxLength="128" />
- <Property Name="principal_id" Type="int" Nullable="false" />
- <Property Name="diagram_id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
- <Property Name="version" Type="int" />
- <Property Name="definition" Type="varbinary(max)" />
- </EntityType>
- <Association Name="ForeignKeyItemsToOrder">
- <End Role="Orders" Type="ShoppingModel.Orders" Multiplicity="1">
- <OnDelete Action="Cascade" />
- </End>
- <End Role="OrderItems" Type="ShoppingModel.OrderItems" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Orders">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="OrderItems">
- <PropertyRef Name="OrderId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="ForeignKeyItemToProduct">
- <End Role="Products" Type="ShoppingModel.Products" Multiplicity="1">
- <OnDelete Action="Cascade" />
- </End>
- <End Role="OrderItems" Type="ShoppingModel.OrderItems" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Products">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="OrderItems">
- <PropertyRef Name="ProductId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="ForeignKeyOrdersToCustomers">
- <End Role="Customers" Type="ShoppingModel.Customers" Multiplicity="1">
- <OnDelete Action="Cascade" />
- </End>
- <End Role="Orders" Type="ShoppingModel.Orders" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Customers">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="Orders">
- <PropertyRef Name="CustomerId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="ForeignKeyProductToCategory">
- <End Role="Categories" Type="ShoppingModel.Categories" Multiplicity="1">
- <OnDelete Action="Cascade" />
- </End>
- <End Role="Products" Type="ShoppingModel.Products" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="Categories">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="Products">
- <PropertyRef Name="CategoryId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Function Name="fn_diagramobjects" ReturnType="int" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
- <Function Name="sp_alterdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
- <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
- <Parameter Name="owner_id" Type="int" Mode="In" />
- <Parameter Name="version" Type="int" Mode="In" />
- <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
- </Function>
- <Function Name="sp_creatediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
- <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
- <Parameter Name="owner_id" Type="int" Mode="In" />
- <Parameter Name="version" Type="int" Mode="In" />
- <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
- </Function>
- <Function Name="sp_dropdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
- <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
- <Parameter Name="owner_id" Type="int" Mode="In" />
- </Function>
- <Function Name="sp_helpdiagramdefinition" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
- <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
- <Parameter Name="owner_id" Type="int" Mode="In" />
- </Function>
- <Function Name="sp_helpdiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
- <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
- <Parameter Name="owner_id" Type="int" Mode="In" />
- </Function>
- <Function Name="sp_renamediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
- <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
- <Parameter Name="owner_id" Type="int" Mode="In" />
- <Parameter Name="new_diagramname" Type="nvarchar" Mode="In" />
- </Function>
- <Function Name="sp_upgraddiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
- </Schema>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement