fichecollege/CD67.FicheCollege.Entity/EntityModel.edmx

<?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="CD67.FicheCollege.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2012" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
  <EntityContainer Name="CD67FicheCollegeStoreContainer">
    <EntitySet Name="TypesCollege" EntityType="CD67.FicheCollege.Store.TypesCollege" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="Territoires" EntityType="CD67.FicheCollege.Store.Territoires" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="Colleges" EntityType="CD67.FicheCollege.Store.Colleges" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="Identites" EntityType="CD67.FicheCollege.Store.Identites" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="Annees" EntityType="CD67.FicheCollege.Store.Annees" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="ActionAxes" EntityType="CD67.FicheCollege.Store.ActionAxes" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="ActionThematiques" EntityType="CD67.FicheCollege.Store.ActionThematiques" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="Actions" EntityType="CD67.FicheCollege.Store.Actions" store:Type="Tables" Schema="dbo" />
    <AssociationSet Name="FK_Colleges_Territoires" Association="CD67.FicheCollege.Store.FK_Colleges_Territoires">
      <End Role="Territoire" EntitySet="Territoires" />
      <End Role="College" EntitySet="Colleges" />
    </AssociationSet>
    <AssociationSet Name="FK_Colleges_TypesCollege" Association="CD67.FicheCollege.Store.FK_Colleges_TypesCollege">
      <End Role="TypeCollege" EntitySet="TypesCollege" />
      <End Role="College" EntitySet="Colleges" />
    </AssociationSet>
    <AssociationSet Name="FK_FicheIdentite_College" Association="CD67.FicheCollege.Store.FK_FicheIdentite_College">
      <End Role="College" EntitySet="Colleges" />
      <End Role="Identite" EntitySet="Identites" />
    </AssociationSet>
    <AssociationSet Name="AnneeCollege" Association="CD67.FicheCollege.Store.AnneeCollege">
      <End Role="Annee" EntitySet="Annees" />
      <End Role="College" EntitySet="Colleges" />
    </AssociationSet>
    <AssociationSet Name="ActionAxeActionThematique" Association="CD67.FicheCollege.Store.ActionAxeActionThematique">
      <End Role="ActionAxe" EntitySet="ActionAxes" />
      <End Role="ActionThematique" EntitySet="ActionThematiques" />
    </AssociationSet>
    <AssociationSet Name="ActionThematiqueAction" Association="CD67.FicheCollege.Store.ActionThematiqueAction">
      <End Role="ActionThematique" EntitySet="ActionThematiques" />
      <End Role="Action" EntitySet="Actions" />
    </AssociationSet>
  </EntityContainer>
  <EntityType Name="TypesCollege">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Libelle" Type="nvarchar" Nullable="false" MaxLength="255" />
    <Property Name="Ordre" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="Territoires">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="nvarchar" Nullable="false" MaxLength="10" />
    <Property Name="Libelle" Type="nvarchar" Nullable="false" MaxLength="255" />
    <Property Name="Referent_SID" Type="nvarchar" Nullable="true" MaxLength="64" />
    <Property Name="Referent_Nom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Referent_Prenom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Referent_Structure" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Referent_Login" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Referent_Email" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Ordre" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="Colleges">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="int" Nullable="false" />
    <Property Name="Annee_Id" Type="int" Nullable="false" />
    <Property Name="CodeRne" Type="nvarchar" Nullable="false" MaxLength="10" />
    <Property Name="Libelle" Type="nvarchar" Nullable="false" MaxLength="255" />
    <Property Name="Adresse" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Code_Postal" Type="nvarchar" Nullable="true" MaxLength="5" />
    <Property Name="TypeCollege_Id" Type="int" Nullable="false" />
    <Property Name="Commune_Insee" Type="nvarchar" Nullable="true" MaxLength="5" />
    <Property Name="Commune" Type="nvarchar" Nullable="false" MaxLength="255" />
    <Property Name="Canton" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Territoire_Id" Type="nvarchar" Nullable="true" MaxLength="10" />
    <Property Name="TAD" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="CDC" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Tel" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Fax" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Email" Type="nvarchar" Nullable="true" MaxLength="255" />
  </EntityType>
  <EntityType Name="Identites">
    <Key>
      <PropertyRef Name="College_Id" />
    </Key>
    <Property Name="College_Id" Type="int" Nullable="false" />
    <Property Name="Principal_SID" Type="nvarchar" Nullable="true" MaxLength="64" />
    <Property Name="Principal_Login" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Principal_Nom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Principal_Prenom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Principal_Email" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Principal_Tel" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Principal_Structure" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Adjoint_SID" Type="nvarchar" Nullable="true" MaxLength="64" />
    <Property Name="Adjoint_Login" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Adjoint_Nom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Adjoint_Prenom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Adjoint_Email" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Adjoint_Tel" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Adjoint_Structure" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire_SID" Type="nvarchar" Nullable="true" MaxLength="64" />
    <Property Name="Gestionnaire_Login" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire_Nom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire_Prenom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire_Email" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire_Tel" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire_Structure" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire2_SID" Type="nvarchar" Nullable="true" MaxLength="64" />
    <Property Name="Gestionnaire2_Login" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire2_Nom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire2_Prenom" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire2_Email" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire2_Tel" Type="nvarchar" Nullable="true" MaxLength="255" />
    <Property Name="Gestionnaire2_Structure" Type="nvarchar" Nullable="true" MaxLength="255" />
  </EntityType>
  <EntityType Name="Annees">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Libelle" Type="nvarchar" Nullable="false" MaxLength="12" />
  </EntityType>
  <EntityType Name="ActionAxes">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Nom" Type="nvarchar(max)" Nullable="false" />
    <Property Name="Neutralise" Type="bit" Nullable="false" DefaultValue="false" />
    <Property Name="Ordre" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="ActionThematiques">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Nom" Type="nvarchar(max)" Nullable="false" />
    <Property Name="Neutralise" Type="bit" Nullable="false" DefaultValue="false" />
    <Property Name="Ordre" Type="int" Nullable="false" />
    <Property Name="ActionAxeId" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="Actions">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Nom" Type="nvarchar(max)" Nullable="false" />
    <Property Name="Description" Type="nvarchar(max)" Nullable="false" />
    <Property Name="Neutralise" Type="bit" Nullable="false" />
    <Property Name="Ordre" Type="int" Nullable="false" />
    <Property Name="ActionThematiqueId" Type="int" Nullable="false" />
  </EntityType>
  <Association Name="FK_Colleges_Territoires">
    <End Role="Territoire" Type="CD67.FicheCollege.Store.Territoires" Multiplicity="0..1" />
    <End Role="College" Type="CD67.FicheCollege.Store.Colleges" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Territoire">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="College">
        <PropertyRef Name="Territoire_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Colleges_TypesCollege">
    <End Role="TypeCollege" Type="CD67.FicheCollege.Store.TypesCollege" Multiplicity="1" />
    <End Role="College" Type="CD67.FicheCollege.Store.Colleges" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="TypeCollege">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="College">
        <PropertyRef Name="TypeCollege_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_FicheIdentite_College">
    <End Role="College" Type="CD67.FicheCollege.Store.Colleges" Multiplicity="1" />
    <End Role="Identite" Type="CD67.FicheCollege.Store.Identites" Multiplicity="0..1" />
    <ReferentialConstraint>
      <Principal Role="College">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="Identite">
        <PropertyRef Name="College_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="AnneeCollege">
    <End Role="Annee" Type="CD67.FicheCollege.Store.Annees" Multiplicity="1" />
    <End Role="College" Type="CD67.FicheCollege.Store.Colleges" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Annee">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="College">
        <PropertyRef Name="Annee_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="ActionAxeActionThematique">
    <End Role="ActionAxe" Type="CD67.FicheCollege.Store.ActionAxes" Multiplicity="1" />
    <End Role="ActionThematique" Type="CD67.FicheCollege.Store.ActionThematiques" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="ActionAxe">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="ActionThematique">
        <PropertyRef Name="ActionAxeId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="ActionThematiqueAction">
    <End Role="ActionThematique" Type="CD67.FicheCollege.Store.ActionThematiques" Multiplicity="1" />
    <End Role="Action" Type="CD67.FicheCollege.Store.Actions" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="ActionThematique">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="Action">
        <PropertyRef Name="ActionThematiqueId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
</Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="CD67.FicheCollege" 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="Entities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="TypesCollege" EntityType="CD67.FicheCollege.TypeCollege" />
          <EntitySet Name="Territoires" EntityType="CD67.FicheCollege.Territoire" />
          <EntitySet Name="Colleges" EntityType="CD67.FicheCollege.College" />
          <AssociationSet Name="FK_Colleges_Territoires" Association="CD67.FicheCollege.FK_Colleges_Territoires">
            <End Role="Territoire" EntitySet="Territoires" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="FK_Colleges_TypesCollege" Association="CD67.FicheCollege.FK_Colleges_TypesCollege">
            <End Role="TypeCollege" EntitySet="TypesCollege" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          <EntitySet Name="Identites" EntityType="CD67.FicheCollege.Identite" />
          <AssociationSet Name="FK_FicheIdentite_College" Association="CD67.FicheCollege.FK_FicheIdentite_College">
            <End Role="College" EntitySet="Colleges" />
            <End Role="Identite" EntitySet="Identites" />
          </AssociationSet>
          <EntitySet Name="Annees" EntityType="CD67.FicheCollege.Annee" />
          <AssociationSet Name="AnneeCollege" Association="CD67.FicheCollege.AnneeCollege">
            <End Role="Annee" EntitySet="Annees" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          <EntitySet Name="ActionAxes" EntityType="CD67.FicheCollege.ActionAxe" />
          <EntitySet Name="ActionThematiques" EntityType="CD67.FicheCollege.ActionThematique" />
          <EntitySet Name="Actions" EntityType="CD67.FicheCollege.Action" />
          <AssociationSet Name="ActionAxeActionThematique" Association="CD67.FicheCollege.ActionAxeActionThematique">
            <End Role="ActionAxe" EntitySet="ActionAxes" />
            <End Role="ActionThematique" EntitySet="ActionThematiques" />
          </AssociationSet>
          <AssociationSet Name="ActionThematiqueAction" Association="CD67.FicheCollege.ActionThematiqueAction">
            <End Role="ActionThematique" EntitySet="ActionThematiques" />
            <End Role="Action" EntitySet="Actions" />
          </AssociationSet>
          </EntityContainer>
        <EntityType Name="TypeCollege">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.FK_Colleges_TypesCollege" FromRole="TypeCollege" ToRole="College" />
        </EntityType>
        <EntityType Name="Territoire">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.FK_Colleges_Territoires" FromRole="Territoire" ToRole="College" />
        </EntityType>
        <EntityType Name="College">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" />
          <Property Name="Annee_Id" Type="Int32" Nullable="false" />
          <Property Name="CodeRne" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adresse" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Code_Postal" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
          <Property Name="TypeCollege_Id" Type="Int32" Nullable="false" />
          <Property Name="Commune_Insee" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
          <Property Name="Commune" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Canton" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Territoire_Id" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="TAD" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="CDC" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Fax" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Territoire" Relationship="CD67.FicheCollege.FK_Colleges_Territoires" FromRole="College" ToRole="Territoire" />
          <NavigationProperty Name="TypeCollege" Relationship="CD67.FicheCollege.FK_Colleges_TypesCollege" FromRole="College" ToRole="TypeCollege" />
          <NavigationProperty Name="Identite" Relationship="CD67.FicheCollege.FK_FicheIdentite_College" FromRole="College" ToRole="Identite" />
          <NavigationProperty Name="Annee" Relationship="CD67.FicheCollege.AnneeCollege" FromRole="College" ToRole="Annee" />
        </EntityType>
        <Association Name="FK_Colleges_Territoires">
          <End Type="CD67.FicheCollege.Territoire" Role="Territoire" Multiplicity="0..1" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Territoire">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="College">
              <PropertyRef Name="Territoire_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Colleges_TypesCollege">
          <End Type="CD67.FicheCollege.TypeCollege" Role="TypeCollege" Multiplicity="1" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="TypeCollege">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="College">
              <PropertyRef Name="TypeCollege_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="Identite">
          <Key>
            <PropertyRef Name="College_Id" />
          </Key>
          <Property Name="College_Id" Type="Int32" Nullable="false" />
          <Property Name="Principal_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="College" Relationship="CD67.FicheCollege.FK_FicheIdentite_College" FromRole="Identite" ToRole="College" />
        </EntityType>
        <Association Name="FK_FicheIdentite_College">
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="1" />
          <End Type="CD67.FicheCollege.Identite" Role="Identite" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="College">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Identite">
              <PropertyRef Name="College_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="Annee">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.AnneeCollege" FromRole="Annee" ToRole="College" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="12" FixedLength="false" Unicode="true" />
        </EntityType>
        <Association Name="AnneeCollege">
          <End Type="CD67.FicheCollege.Annee" Role="Annee" Multiplicity="1" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Annee">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="College">
              <PropertyRef Name="Annee_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="ActionAxe">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Nom" Type="String" Nullable="false" />
          <Property Name="Neutralise" Type="Boolean" Nullable="false" DefaultValue="False" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionThematiques" Relationship="CD67.FicheCollege.ActionAxeActionThematique" FromRole="ActionAxe" ToRole="ActionThematique" />
        </EntityType>
        <EntityType Name="ActionThematique">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Nom" Type="String" Nullable="false" />
          <Property Name="Neutralise" Type="Boolean" Nullable="false" DefaultValue="False" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionAxe" Relationship="CD67.FicheCollege.ActionAxeActionThematique" FromRole="ActionThematique" ToRole="ActionAxe" />
          <Property Name="ActionAxeId" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Actions" Relationship="CD67.FicheCollege.ActionThematiqueAction" FromRole="ActionThematique" ToRole="Action" />
        </EntityType>
        <EntityType Name="Action">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Nom" Type="String" Nullable="false" />
          <Property Name="Description" Type="String" Nullable="false" MaxLength="Max" />
          <Property Name="Neutralise" Type="Boolean" Nullable="false" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionThematique" Relationship="CD67.FicheCollege.ActionThematiqueAction" FromRole="Action" ToRole="ActionThematique" />
          <Property Name="ActionThematiqueId" Type="Int32" Nullable="false" />
        </EntityType>
        <Association Name="ActionAxeActionThematique">
          <End Type="CD67.FicheCollege.ActionAxe" Role="ActionAxe" Multiplicity="1" />
          <End Type="CD67.FicheCollege.ActionThematique" Role="ActionThematique" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionAxe">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionThematique">
              <PropertyRef Name="ActionAxeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="ActionThematiqueAction">
          <End Type="CD67.FicheCollege.ActionThematique" Role="ActionThematique" Multiplicity="1" />
          <End Type="CD67.FicheCollege.Action" Role="Action" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionThematique">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Action">
              <PropertyRef Name="ActionThematiqueId" />
            </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="CD67FicheCollegeStoreContainer" CdmEntityContainer="Entities">
    <EntitySetMapping Name="TypesCollege">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.TypeCollege)">
        <MappingFragment StoreEntitySet="TypesCollege">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Libelle" ColumnName="Libelle" />
          <ScalarProperty Name="Ordre" ColumnName="Ordre" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Territoires">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Territoire)">
        <MappingFragment StoreEntitySet="Territoires">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Libelle" ColumnName="Libelle" />
          <ScalarProperty Name="Referent_SID" ColumnName="Referent_SID" />
          <ScalarProperty Name="Referent_Nom" ColumnName="Referent_Nom" />
          <ScalarProperty Name="Referent_Prenom" ColumnName="Referent_Prenom" />
          <ScalarProperty Name="Referent_Structure" ColumnName="Referent_Structure" />
          <ScalarProperty Name="Referent_Login" ColumnName="Referent_Login" />
          <ScalarProperty Name="Referent_Email" ColumnName="Referent_Email" />
          <ScalarProperty Name="Ordre" ColumnName="Ordre" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Colleges">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.College)">
        <MappingFragment StoreEntitySet="Colleges">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Annee_Id" ColumnName="Annee_Id" />
          <ScalarProperty Name="CodeRne" ColumnName="CodeRne" />
          <ScalarProperty Name="Libelle" ColumnName="Libelle" />
          <ScalarProperty Name="Adresse" ColumnName="Adresse" />
          <ScalarProperty Name="Code_Postal" ColumnName="Code_Postal" />
          <ScalarProperty Name="TypeCollege_Id" ColumnName="TypeCollege_Id" />
          <ScalarProperty Name="Commune_Insee" ColumnName="Commune_Insee" />
          <ScalarProperty Name="Commune" ColumnName="Commune" />
          <ScalarProperty Name="Canton" ColumnName="Canton" />
          <ScalarProperty Name="Territoire_Id" ColumnName="Territoire_Id" />
          <ScalarProperty Name="TAD" ColumnName="TAD" />
          <ScalarProperty Name="CDC" ColumnName="CDC" />
          <ScalarProperty Name="Tel" ColumnName="Tel" />
          <ScalarProperty Name="Fax" ColumnName="Fax" />
          <ScalarProperty Name="Email" ColumnName="Email" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Identites">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Identite)">
        <MappingFragment StoreEntitySet="Identites">
          <ScalarProperty Name="College_Id" ColumnName="College_Id" />
          <ScalarProperty Name="Principal_SID" ColumnName="Principal_SID" />
          <ScalarProperty Name="Principal_Login" ColumnName="Principal_Login" />
          <ScalarProperty Name="Principal_Nom" ColumnName="Principal_Nom" />
          <ScalarProperty Name="Principal_Prenom" ColumnName="Principal_Prenom" />
          <ScalarProperty Name="Principal_Email" ColumnName="Principal_Email" />
          <ScalarProperty Name="Principal_Tel" ColumnName="Principal_Tel" />
          <ScalarProperty Name="Principal_Structure" ColumnName="Principal_Structure" />
          <ScalarProperty Name="Adjoint_SID" ColumnName="Adjoint_SID" />
          <ScalarProperty Name="Adjoint_Login" ColumnName="Adjoint_Login" />
          <ScalarProperty Name="Adjoint_Nom" ColumnName="Adjoint_Nom" />
          <ScalarProperty Name="Adjoint_Prenom" ColumnName="Adjoint_Prenom" />
          <ScalarProperty Name="Adjoint_Email" ColumnName="Adjoint_Email" />
          <ScalarProperty Name="Adjoint_Tel" ColumnName="Adjoint_Tel" />
          <ScalarProperty Name="Adjoint_Structure" ColumnName="Adjoint_Structure" />
          <ScalarProperty Name="Gestionnaire_SID" ColumnName="Gestionnaire_SID" />
          <ScalarProperty Name="Gestionnaire_Login" ColumnName="Gestionnaire_Login" />
          <ScalarProperty Name="Gestionnaire_Nom" ColumnName="Gestionnaire_Nom" />
          <ScalarProperty Name="Gestionnaire_Prenom" ColumnName="Gestionnaire_Prenom" />
          <ScalarProperty Name="Gestionnaire_Email" ColumnName="Gestionnaire_Email" />
          <ScalarProperty Name="Gestionnaire_Tel" ColumnName="Gestionnaire_Tel" />
          <ScalarProperty Name="Gestionnaire_Structure" ColumnName="Gestionnaire_Structure" />
          <ScalarProperty Name="Gestionnaire2_SID" ColumnName="Gestionnaire2_SID" />
          <ScalarProperty Name="Gestionnaire2_Login" ColumnName="Gestionnaire2_Login" />
          <ScalarProperty Name="Gestionnaire2_Nom" ColumnName="Gestionnaire2_Nom" />
          <ScalarProperty Name="Gestionnaire2_Prenom" ColumnName="Gestionnaire2_Prenom" />
          <ScalarProperty Name="Gestionnaire2_Email" ColumnName="Gestionnaire2_Email" />
          <ScalarProperty Name="Gestionnaire2_Tel" ColumnName="Gestionnaire2_Tel" />
          <ScalarProperty Name="Gestionnaire2_Structure" ColumnName="Gestionnaire2_Structure" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Annees">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Annee)">
        <MappingFragment StoreEntitySet="Annees">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Libelle" ColumnName="Libelle" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="ActionAxes">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionAxe)">
        <MappingFragment StoreEntitySet="ActionAxes">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Nom" ColumnName="Nom" />
          <ScalarProperty Name="Neutralise" ColumnName="Neutralise" />
          <ScalarProperty Name="Ordre" ColumnName="Ordre" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="ActionThematiques">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionThematique)">
        <MappingFragment StoreEntitySet="ActionThematiques">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Nom" ColumnName="Nom" />
          <ScalarProperty Name="Neutralise" ColumnName="Neutralise" />
          <ScalarProperty Name="Ordre" ColumnName="Ordre" />
          <ScalarProperty Name="ActionAxeId" ColumnName="ActionAxeId" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Actions">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Action)">
        <MappingFragment StoreEntitySet="Actions">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Nom" ColumnName="Nom" />
          <ScalarProperty Name="Description" ColumnName="Description" />
          <ScalarProperty Name="Neutralise" ColumnName="Neutralise" />
          <ScalarProperty Name="Ordre" ColumnName="Ordre" />
          <ScalarProperty Name="ActionThematiqueId" ColumnName="ActionThematiqueId" />
        </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="True" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="False" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="Aucun" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>