Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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="ArmoireOutils.Model.Store" Provider="MySql.Data.MySqlClient" ProviderManifestToken="5.6" 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="cupboards">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="GUID" Type="longtext" Nullable="false" />
- </EntityType>
- <EntityType Name="cupboarduser">
- <Key>
- <PropertyRef Name="Cupboards_Id" />
- <PropertyRef Name="Users_Id" />
- </Key>
- <Property Name="Cupboards_Id" Type="int" Nullable="false" />
- <Property Name="Users_Id" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="langs">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="smallint" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="CountryCode" Type="longtext" Nullable="false" />
- <Property Name="DisplayName" Type="longtext" Nullable="false" />
- </EntityType>
- <EntityType Name="tools">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Tag" Type="longtext" Nullable="false" />
- <Property Name="HomeCupboardId" Type="int" />
- <Property Name="CupboardId" Type="int" />
- <Property Name="UserId" Type="int" />
- <Property Name="Photo" Type="longtext" Nullable="false" />
- <Property Name="Name" Type="longtext" Nullable="false" />
- <Property Name="CreationDate" Type="datetime" Precision="0" Nullable="false" />
- <Property Name="ModificationDate" Type="datetime" Precision="0" />
- <Property Name="IsActive" Type="bool" Nullable="false" DefaultValue="true"/>
- </EntityType>
- <EntityType Name="users">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Type" Type="smallint" Nullable="false" />
- <Property Name="Firstname" Type="longtext" Nullable="false" />
- <Property Name="LastName" Type="longtext" Nullable="false" />
- <Property Name="Login" Type="longtext" Nullable="false" />
- <Property Name="Gender" Type="smallint" Nullable="false" />
- <Property Name="LangId" Type="smallint" Nullable="false" />
- <Property Name="Photo" Type="longtext" Nullable="false" />
- <Property Name="CreationDate" Type="datetime" Precision="0" Nullable="false" />
- <Property Name="ModificationDate" Type="datetime" Precision="0" />
- <Property Name="LastConnection" Type="datetime" Precision="0" />
- <Property Name="DisableDate" Type="datetime" Precision="0" />
- <Property Name="Active" Type="bool" Nullable="false" DefaultValue="true"/>
- </EntityType>
- <Association Name="FK_CupboardTool">
- <End Role="cupboards" Type="Self.cupboards" Multiplicity="0..1" />
- <End Role="tools" Type="Self.tools" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="cupboards">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="tools">
- <PropertyRef Name="HomeCupboardId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_CupboardTool1">
- <End Role="cupboards" Type="Self.cupboards" Multiplicity="0..1" />
- <End Role="tools" Type="Self.tools" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="cupboards">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="tools">
- <PropertyRef Name="CupboardId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_CupboardUser_Cupboard">
- <End Role="cupboards" Type="Self.cupboards" Multiplicity="1" />
- <End Role="cupboarduser" Type="Self.cupboarduser" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="cupboards">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="cupboarduser">
- <PropertyRef Name="Cupboards_Id" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_CupboardUser_User">
- <End Role="users" Type="Self.users" Multiplicity="1" />
- <End Role="cupboarduser" Type="Self.cupboarduser" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="users">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="cupboarduser">
- <PropertyRef Name="Users_Id" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_LangUser">
- <End Role="langs" Type="Self.langs" Multiplicity="1" />
- <End Role="users" Type="Self.users" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="langs">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="users">
- <PropertyRef Name="LangId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_UserTool">
- <End Role="users" Type="Self.users" Multiplicity="0..1" />
- <End Role="tools" Type="Self.tools" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="users">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="tools">
- <PropertyRef Name="UserId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <EntityContainer Name="ArmoireOutilsModelStoreContainer">
- <EntitySet Name="cupboards" EntityType="Self.cupboards" Schema="armoireoutils" store:Type="Tables" />
- <EntitySet Name="cupboarduser" EntityType="Self.cupboarduser" Schema="armoireoutils" store:Type="Tables" />
- <EntitySet Name="langs" EntityType="Self.langs" Schema="armoireoutils" store:Type="Tables" />
- <EntitySet Name="tools" EntityType="Self.tools" Schema="armoireoutils" store:Type="Tables" />
- <EntitySet Name="users" EntityType="Self.users" Schema="armoireoutils" store:Type="Tables" />
- <AssociationSet Name="FK_CupboardTool" Association="Self.FK_CupboardTool">
- <End Role="cupboards" EntitySet="cupboards" />
- <End Role="tools" EntitySet="tools" />
- </AssociationSet>
- <AssociationSet Name="FK_CupboardTool1" Association="Self.FK_CupboardTool1">
- <End Role="cupboards" EntitySet="cupboards" />
- <End Role="tools" EntitySet="tools" />
- </AssociationSet>
- <AssociationSet Name="FK_CupboardUser_Cupboard" Association="Self.FK_CupboardUser_Cupboard">
- <End Role="cupboards" EntitySet="cupboards" />
- <End Role="cupboarduser" EntitySet="cupboarduser" />
- </AssociationSet>
- <AssociationSet Name="FK_CupboardUser_User" Association="Self.FK_CupboardUser_User">
- <End Role="users" EntitySet="users" />
- <End Role="cupboarduser" EntitySet="cupboarduser" />
- </AssociationSet>
- <AssociationSet Name="FK_LangUser" Association="Self.FK_LangUser">
- <End Role="langs" EntitySet="langs" />
- <End Role="users" EntitySet="users" />
- </AssociationSet>
- <AssociationSet Name="FK_UserTool" Association="Self.FK_UserTool">
- <End Role="users" EntitySet="users" />
- <End Role="tools" EntitySet="tools" />
- </AssociationSet>
- </EntityContainer>
- </Schema>
- </edmx:StorageModels>
- <!-- CSDL content -->
- <edmx:ConceptualModels>
- <Schema Namespace="ArmoireOutils.Model" 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">
- <EntityType Name="Cupboard">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="GUID" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <NavigationProperty Name="ResidentTools" Relationship="Self.FK_CupboardTool" FromRole="cupboards" ToRole="tools" />
- <NavigationProperty Name="Tools" Relationship="Self.FK_CupboardTool1" FromRole="cupboards" ToRole="tools" />
- <NavigationProperty Name="Users" Relationship="Self.cupboarduser" FromRole="cupboards" ToRole="users" />
- </EntityType>
- <EntityType Name="Lang">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="Int16" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="CountryCode" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="DisplayName" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <NavigationProperty Name="Users" Relationship="Self.FK_LangUser" FromRole="langs" ToRole="users" />
- </EntityType>
- <EntityType Name="Tool">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Tag" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="HomeCupboardId" Type="Int32" />
- <Property Name="CupboardId" Type="Int32" />
- <Property Name="UserId" Type="Int32" />
- <Property Name="Photo" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="Name" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="CreationDate" Type="DateTime" Nullable="false" />
- <Property Name="ModificationDate" Type="DateTime" />
- <Property Name="IsActive" Type="Boolean" Nullable="false" />
- <NavigationProperty Name="HomeCupboard" Relationship="Self.FK_CupboardTool" FromRole="tools" ToRole="cupboards" />
- <NavigationProperty Name="Cupboard" Relationship="Self.FK_CupboardTool1" FromRole="tools" ToRole="cupboards" />
- <NavigationProperty Name="User" Relationship="Self.FK_UserTool" FromRole="tools" ToRole="users" />
- </EntityType>
- <EntityType Name="User">
- <Key>
- <PropertyRef Name="Id" />
- </Key>
- <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Type" Type="Int16" Nullable="false" />
- <Property Name="Firstname" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="LastName" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="Login" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="Gender" Type="Int16" Nullable="false" />
- <Property Name="LangId" Type="Int16" Nullable="false" />
- <Property Name="Photo" Type="String" MaxLength="1073741823" FixedLength="false" Unicode="false" Nullable="false" />
- <Property Name="CreationDate" Type="DateTime" Nullable="false" />
- <Property Name="ModificationDate" Type="DateTime" />
- <Property Name="LastConnection" Type="DateTime" />
- <Property Name="DisableDate" Type="DateTime" />
- <Property Name="Active" Type="Boolean" Nullable="false" />
- <NavigationProperty Name="Lang" Relationship="Self.FK_LangUser" FromRole="users" ToRole="langs" />
- <NavigationProperty Name="Tools" Relationship="Self.FK_UserTool" FromRole="users" ToRole="tools" />
- <NavigationProperty Name="Cupboards" Relationship="Self.cupboarduser" FromRole="users" ToRole="cupboards" />
- </EntityType>
- <Association Name="FK_CupboardTool">
- <End Role="cupboards" Type="ArmoireOutils.Model.Cupboard" Multiplicity="0..1" />
- <End Role="tools" Type="ArmoireOutils.Model.Tool" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="cupboards">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="tools">
- <PropertyRef Name="HomeCupboardId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_CupboardTool1">
- <End Role="cupboards" Type="ArmoireOutils.Model.Cupboard" Multiplicity="0..1" />
- <End Role="tools" Type="ArmoireOutils.Model.Tool" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="cupboards">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="tools">
- <PropertyRef Name="CupboardId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_LangUser">
- <End Role="langs" Type="ArmoireOutils.Model.Lang" Multiplicity="1" />
- <End Role="users" Type="ArmoireOutils.Model.User" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="langs">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="users">
- <PropertyRef Name="LangId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_UserTool">
- <End Role="users" Type="ArmoireOutils.Model.User" Multiplicity="0..1" />
- <End Role="tools" Type="ArmoireOutils.Model.Tool" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="users">
- <PropertyRef Name="Id" />
- </Principal>
- <Dependent Role="tools">
- <PropertyRef Name="UserId" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="cupboarduser">
- <End Role="cupboards" Type="ArmoireOutils.Model.Cupboard" Multiplicity="*" />
- <End Role="users" Type="ArmoireOutils.Model.User" Multiplicity="*" />
- </Association>
- <EntityContainer Name="ArmoireOutilsEntities" annotation:LazyLoadingEnabled="true">
- <EntitySet Name="Cupboards" EntityType="ArmoireOutils.Model.Cupboard" />
- <EntitySet Name="Langs" EntityType="ArmoireOutils.Model.Lang" />
- <EntitySet Name="Tools" EntityType="ArmoireOutils.Model.Tool" />
- <EntitySet Name="Users" EntityType="ArmoireOutils.Model.User" />
- <AssociationSet Name="FK_CupboardTool" Association="Self.FK_CupboardTool">
- <End Role="cupboards" EntitySet="Cupboards" />
- <End Role="tools" EntitySet="Tools" />
- </AssociationSet>
- <AssociationSet Name="FK_CupboardTool1" Association="Self.FK_CupboardTool1">
- <End Role="cupboards" EntitySet="Cupboards" />
- <End Role="tools" EntitySet="Tools" />
- </AssociationSet>
- <AssociationSet Name="FK_LangUser" Association="Self.FK_LangUser">
- <End Role="langs" EntitySet="Langs" />
- <End Role="users" EntitySet="Users" />
- </AssociationSet>
- <AssociationSet Name="FK_UserTool" Association="Self.FK_UserTool">
- <End Role="users" EntitySet="Users" />
- <End Role="tools" EntitySet="Tools" />
- </AssociationSet>
- <AssociationSet Name="cupboarduser" Association="Self.cupboarduser">
- <End Role="cupboards" EntitySet="Cupboards" />
- <End Role="users" EntitySet="Users" />
- </AssociationSet>
- </EntityContainer>
- </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="ArmoireOutilsModelStoreContainer" CdmEntityContainer="ArmoireOutilsEntities">
- <EntitySetMapping Name="Cupboards">
- <EntityTypeMapping TypeName="ArmoireOutils.Model.Cupboard">
- <MappingFragment StoreEntitySet="cupboards">
- <ScalarProperty Name="Id" ColumnName="Id" />
- <ScalarProperty Name="GUID" ColumnName="GUID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Langs">
- <EntityTypeMapping TypeName="ArmoireOutils.Model.Lang">
- <MappingFragment StoreEntitySet="langs">
- <ScalarProperty Name="Id" ColumnName="Id" />
- <ScalarProperty Name="CountryCode" ColumnName="CountryCode" />
- <ScalarProperty Name="DisplayName" ColumnName="DisplayName" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Tools">
- <EntityTypeMapping TypeName="ArmoireOutils.Model.Tool">
- <MappingFragment StoreEntitySet="tools">
- <ScalarProperty Name="Id" ColumnName="Id" />
- <ScalarProperty Name="Tag" ColumnName="Tag" />
- <ScalarProperty Name="HomeCupboardId" ColumnName="HomeCupboardId" />
- <ScalarProperty Name="CupboardId" ColumnName="CupboardId" />
- <ScalarProperty Name="UserId" ColumnName="UserId" />
- <ScalarProperty Name="Photo" ColumnName="Photo" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="CreationDate" ColumnName="CreationDate" />
- <ScalarProperty Name="ModificationDate" ColumnName="ModificationDate" />
- <ScalarProperty Name="IsActive" ColumnName="IsActive" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Users">
- <EntityTypeMapping TypeName="ArmoireOutils.Model.User">
- <MappingFragment StoreEntitySet="users">
- <ScalarProperty Name="Id" ColumnName="Id" />
- <ScalarProperty Name="Type" ColumnName="Type" />
- <ScalarProperty Name="Firstname" ColumnName="Firstname" />
- <ScalarProperty Name="LastName" ColumnName="LastName" />
- <ScalarProperty Name="Login" ColumnName="Login" />
- <ScalarProperty Name="Gender" ColumnName="Gender" />
- <ScalarProperty Name="LangId" ColumnName="LangId" />
- <ScalarProperty Name="Photo" ColumnName="Photo" />
- <ScalarProperty Name="CreationDate" ColumnName="CreationDate" />
- <ScalarProperty Name="ModificationDate" ColumnName="ModificationDate" />
- <ScalarProperty Name="LastConnection" ColumnName="LastConnection" />
- <ScalarProperty Name="DisableDate" ColumnName="DisableDate" />
- <ScalarProperty Name="Active" ColumnName="Active" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <AssociationSetMapping Name="cupboarduser" TypeName="ArmoireOutils.Model.cupboarduser" StoreEntitySet="cupboarduser">
- <EndProperty Name="cupboards">
- <ScalarProperty Name="Id" ColumnName="Cupboards_Id" />
- </EndProperty>
- <EndProperty Name="users">
- <ScalarProperty Name="Id" ColumnName="Users_Id" />
- </EndProperty>
- </AssociationSetMapping>
- </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="true" />
- <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
- <DesignerProperty Name="UseLegacyProvider" Value="false" />
- <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
- </DesignerInfoPropertySet>
- </Options>
- <!-- Diagram content (shape and connector positions) -->
- <Diagrams></Diagrams>
- </Designer>
- </edmx:Edmx>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement