159 lines
9.0 KiB
XML
159 lines
9.0 KiB
XML
<?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 xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl" Namespace="DataModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2005">
|
|
<EntityContainer Name="DataModelTargetContainer" >
|
|
</EntityContainer>
|
|
</Schema>
|
|
</edmx:StorageModels>
|
|
<!-- CSDL content -->
|
|
<edmx:ConceptualModels>
|
|
<Schema xmlns="http://schemas.microsoft.com/ado/2009/11/edm" xmlns:cg="http://schemas.microsoft.com/ado/2006/04/codegeneration" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" Namespace="DataModel" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" annotation:UseStrongSpatialTypes="false">
|
|
<EntityContainer Name="DataModelContainer" annotation:LazyLoadingEnabled="true">
|
|
<EntitySet Name="PersonneSet" EntityType="DataModel.Personne" />
|
|
<EntitySet Name="FicheSuivitSet" EntityType="DataModel.FicheSuivit" />
|
|
<AssociationSet Name="FicheSuivitBeneficiaire" Association="DataModel.FicheSuivitBeneficiaire">
|
|
<End Role="FicheSuivit" EntitySet="FicheSuivitSet" />
|
|
<End Role="Beneficiaire" EntitySet="PersonneSet" />
|
|
</AssociationSet>
|
|
<EntitySet Name="CourrielSet" EntityType="DataModel.Courriel" />
|
|
<AssociationSet Name="CourrielPersonne" Association="DataModel.CourrielPersonne">
|
|
<End Role="Courriel" EntitySet="CourrielSet" />
|
|
<End Role="Personne" EntitySet="PersonneSet" />
|
|
</AssociationSet>
|
|
<EntitySet Name="TelephoneSet" EntityType="DataModel.Telephone" />
|
|
<AssociationSet Name="PersonneTelephone" Association="DataModel.PersonneTelephone">
|
|
<End Role="Personne" EntitySet="PersonneSet" />
|
|
<End Role="Telephone" EntitySet="TelephoneSet" />
|
|
</AssociationSet>
|
|
<EntitySet Name="PermisSet" EntityType="DataModel.Permis" />
|
|
<AssociationSet Name="PersonnePermis" Association="DataModel.PersonnePermis">
|
|
<End Role="Personne" EntitySet="PersonneSet" />
|
|
<End Role="Permis" EntitySet="PermisSet" />
|
|
</AssociationSet>
|
|
<EntitySet Name="EtiquetteSet" EntityType="DataModel.Etiquette" />
|
|
<AssociationSet Name="FicheSuivitEtiquette" Association="DataModel.FicheSuivitEtiquette">
|
|
<End Role="FicheSuivit" EntitySet="FicheSuivitSet" />
|
|
<End Role="Etiquette" EntitySet="EtiquetteSet" />
|
|
</AssociationSet>
|
|
</EntityContainer>
|
|
<EntityType Name="Personne">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Prenom" Type="String" Nullable="false" />
|
|
<Property Name="Nom" Type="String" Nullable="false" />
|
|
<Property Name="Genre" Type="Boolean" Nullable="false" />
|
|
<Property Name="DateNaissance" Type="DateTime" Nullable="false" />
|
|
<Property Name="EstHandicape" Type="Boolean" Nullable="false" />
|
|
<Property Name="DateInscription" Type="DateTime" Nullable="false" />
|
|
<NavigationProperty Name="Courriel" Relationship="DataModel.CourrielPersonne" FromRole="Personne" ToRole="Courriel" />
|
|
<NavigationProperty Name="Telephone" Relationship="DataModel.PersonneTelephone" FromRole="Personne" ToRole="Telephone" />
|
|
<NavigationProperty Name="Permis" Relationship="DataModel.PersonnePermis" FromRole="Personne" ToRole="Permis" />
|
|
</EntityType>
|
|
<EntityType Name="Utilisateur" BaseType="DataModel.Personne">
|
|
<Property Name="Identifiant" Type="String" Nullable="false" />
|
|
<Property Name="MotDePasse" Type="String" Nullable="false" />
|
|
<Property Name="Privilege" Type="Int16" Nullable="false" />
|
|
<Property Name="EstActif" Type="Boolean" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="Beneficiaire" BaseType="DataModel.Personne">
|
|
<NavigationProperty Name="FicheSuivit" Relationship="DataModel.FicheSuivitBeneficiaire" FromRole="Beneficiaire" ToRole="FicheSuivit" />
|
|
</EntityType>
|
|
<EntityType Name="FicheSuivit">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="DateCreation" Type="DateTime" Nullable="false" />
|
|
<Property Name="Commentaire" Type="String" Nullable="false" />
|
|
<NavigationProperty Name="Beneficiaire" Relationship="DataModel.FicheSuivitBeneficiaire" FromRole="FicheSuivit" ToRole="Beneficiaire" />
|
|
<NavigationProperty Name="Etiquette" Relationship="DataModel.FicheSuivitEtiquette" FromRole="FicheSuivit" ToRole="Etiquette" />
|
|
</EntityType>
|
|
<Association Name="FicheSuivitBeneficiaire">
|
|
<End Type="DataModel.FicheSuivit" Role="FicheSuivit" Multiplicity="*" />
|
|
<End Type="DataModel.Beneficiaire" Role="Beneficiaire" Multiplicity="1" />
|
|
</Association>
|
|
<EntityType Name="Courriel">
|
|
<Key>
|
|
<PropertyRef Name="Adresse" />
|
|
</Key>
|
|
<Property Name="Adresse" Type="String" Nullable="false" />
|
|
<Property Name="MotDePasse" Type="String" Nullable="false" />
|
|
<NavigationProperty Name="Personne" Relationship="DataModel.CourrielPersonne" FromRole="Courriel" ToRole="Personne" />
|
|
</EntityType>
|
|
<Association Name="CourrielPersonne">
|
|
<End Type="DataModel.Courriel" Role="Courriel" Multiplicity="*" />
|
|
<End Type="DataModel.Personne" Role="Personne" Multiplicity="1" />
|
|
</Association>
|
|
<EntityType Name="Telephone">
|
|
<Key>
|
|
<PropertyRef Name="Numero" />
|
|
</Key>
|
|
<Property Name="Numero" Type="String" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<NavigationProperty Name="Personne" Relationship="DataModel.PersonneTelephone" FromRole="Telephone" ToRole="Personne" />
|
|
</EntityType>
|
|
<Association Name="PersonneTelephone">
|
|
<End Type="DataModel.Personne" Role="Personne" Multiplicity="1" />
|
|
<End Type="DataModel.Telephone" Role="Telephone" Multiplicity="*" />
|
|
</Association>
|
|
<EntityType Name="Permis">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Nom" Type="String" Nullable="false" />
|
|
<NavigationProperty Name="Personne" Relationship="DataModel.PersonnePermis" FromRole="Permis" ToRole="Personne" />
|
|
</EntityType>
|
|
<Association Name="PersonnePermis">
|
|
<End Type="DataModel.Personne" Role="Personne" Multiplicity="*" />
|
|
<End Type="DataModel.Permis" Role="Permis" Multiplicity="*" />
|
|
</Association>
|
|
<EntityType Name="Etiquette">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Nom" Type="String" Nullable="false" />
|
|
<NavigationProperty Name="FicheSuivit" Relationship="DataModel.FicheSuivitEtiquette" FromRole="Etiquette" ToRole="FicheSuivit" />
|
|
</EntityType>
|
|
<Association Name="FicheSuivitEtiquette">
|
|
<End Type="DataModel.FicheSuivit" Role="FicheSuivit" Multiplicity="*" />
|
|
<End Type="DataModel.Etiquette" Role="Etiquette" Multiplicity="*" />
|
|
</Association>
|
|
</Schema>
|
|
</edmx:ConceptualModels>
|
|
<!-- C-S mapping content -->
|
|
<edmx:Mappings>
|
|
<Mapping xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs" Space="C-S">
|
|
<Alias Key="Model" Value="DataModel" />
|
|
<Alias Key="Target" Value="DataModel.Store" />
|
|
<EntityContainerMapping CdmEntityContainer="DataModelContainer" StorageEntityContainer="DataModelTargetContainer">
|
|
</EntityContainerMapping>
|
|
</Mapping>
|
|
</edmx:Mappings>
|
|
</edmx:Runtime>
|
|
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
|
|
<edmx:Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
|
|
<edmx:Connection>
|
|
<DesignerInfoPropertySet>
|
|
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
|
|
</DesignerInfoPropertySet>
|
|
</edmx:Connection>
|
|
<edmx:Options>
|
|
<DesignerInfoPropertySet>
|
|
<DesignerProperty Name="ValidateOnBuild" Value="true" />
|
|
<DesignerProperty Name="EnablePluralization" Value="False" />
|
|
<DesignerProperty Name="CodeGenerationStrategy" Value="Aucun" />
|
|
</DesignerInfoPropertySet>
|
|
</edmx:Options>
|
|
<!-- Diagram content (shape and connector positions) -->
|
|
<edmx:Diagrams>
|
|
</edmx:Diagrams>
|
|
</edmx:Designer>
|
|
</edmx:Edmx>
|