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="ActionEduAxes" EntityType="CD67.FicheCollege.Store.ActionEduAxes" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="ActionEduThematiques" EntityType="CD67.FicheCollege.Store.ActionEduThematiques" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="ActionsEdu" EntityType="CD67.FicheCollege.Store.ActionsEdu" 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="ActionEduAxeActionEduThematique" Association="CD67.FicheCollege.Store.ActionEduAxeActionEduThematique">
      <End Role="ActionEduAxe" EntitySet="ActionEduAxes" />
      <End Role="ActionEduThematique" EntitySet="ActionEduThematiques" />
    </AssociationSet>
    <AssociationSet Name="ActionEduThematiqueActionEdu" Association="CD67.FicheCollege.Store.ActionEduThematiqueActionEdu">
      <End Role="ActionEduThematique" EntitySet="ActionEduThematiques" />
      <End Role="ActionEdu" EntitySet="ActionsEdu" />
    </AssociationSet>
    <AssociationSet Name="ActionEduAnnee" Association="CD67.FicheCollege.Store.ActionEduAnnee">
      <End Role="ActionEdu" EntitySet="ActionsEdu" />
      <End Role="Annee" EntitySet="Annees" />
    </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="ActionEduAxes">
    <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="ActionEduThematiques">
    <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="ActionEduAxeId" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="ActionsEdu">
    <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="ActionEduThematiqueId" Type="int" Nullable="false" />
    <Property Name="AnneeId" 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="ActionEduAxeActionEduThematique">
    <End Role="ActionEduAxe" Type="CD67.FicheCollege.Store.ActionEduAxes" Multiplicity="1" />
    <End Role="ActionEduThematique" Type="CD67.FicheCollege.Store.ActionEduThematiques" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="ActionEduAxe">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="ActionEduThematique">
        <PropertyRef Name="ActionEduAxeId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="ActionEduThematiqueActionEdu">
    <End Role="ActionEduThematique" Type="CD67.FicheCollege.Store.ActionEduThematiques" Multiplicity="1" />
    <End Role="ActionEdu" Type="CD67.FicheCollege.Store.ActionsEdu" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="ActionEduThematique">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="ActionEdu">
        <PropertyRef Name="ActionEduThematiqueId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="ActionEduAnnee">
    <End Role="ActionEdu" Type="CD67.FicheCollege.Store.ActionsEdu" Multiplicity="*" />
    <End Role="Annee" Type="CD67.FicheCollege.Store.Annees" Multiplicity="1" />
    <ReferentialConstraint>
      <Principal Role="Annee">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="ActionEdu">
        <PropertyRef Name="AnneeId" />
      </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="ActionEduAxes" EntityType="CD67.FicheCollege.ActionEduAxe" />
          <EntitySet Name="ActionEduThematiques" EntityType="CD67.FicheCollege.ActionEduThematique" />
          <EntitySet Name="ActionsEdu" EntityType="CD67.FicheCollege.ActionEdu" />
          <AssociationSet Name="ActionEduAxeActionEduThematique" Association="CD67.FicheCollege.ActionEduAxeActionEduThematique">
            <End Role="ActionEduAxe" EntitySet="ActionEduAxes" />
            <End Role="ActionEduThematique" EntitySet="ActionEduThematiques" />
          </AssociationSet>
          <AssociationSet Name="ActionEduThematiqueActionEdu" Association="CD67.FicheCollege.ActionEduThematiqueActionEdu">
            <End Role="ActionEduThematique" EntitySet="ActionEduThematiques" />
            <End Role="ActionEdu" EntitySet="ActionsEdu" />
          </AssociationSet>
          <AssociationSet Name="ActionEduAnnee" Association="CD67.FicheCollege.ActionEduAnnee">
            <End Role="ActionEdu" EntitySet="ActionsEdu" />
            <End Role="Annee" EntitySet="Annees" />
          </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" />
          <NavigationProperty Name="ActionsEdu" Relationship="CD67.FicheCollege.ActionEduAnnee" FromRole="Annee" ToRole="ActionEdu" />
        </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="ActionEduAxe">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="Neutralise" Type="Boolean" Nullable="false" DefaultValue="False" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionEduThematiques" Relationship="CD67.FicheCollege.ActionEduAxeActionEduThematique" FromRole="ActionEduAxe" ToRole="ActionEduThematique" />
        </EntityType>
        <EntityType Name="ActionEduThematique">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="Neutralise" Type="Boolean" Nullable="false" DefaultValue="False" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionEduAxe" Relationship="CD67.FicheCollege.ActionEduAxeActionEduThematique" FromRole="ActionEduThematique" ToRole="ActionEduAxe" />
          <Property Name="ActionEduAxeId" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionEdus" Relationship="CD67.FicheCollege.ActionEduThematiqueActionEdu" FromRole="ActionEduThematique" ToRole="ActionEdu" />
        </EntityType>
        <EntityType Name="ActionEdu">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="Description" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="Neutralise" Type="Boolean" Nullable="false" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionEduThematique" Relationship="CD67.FicheCollege.ActionEduThematiqueActionEdu" FromRole="ActionEdu" ToRole="ActionEduThematique" />
          <Property Name="ActionEduThematiqueId" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Annee" Relationship="CD67.FicheCollege.ActionEduAnnee" FromRole="ActionEdu" ToRole="Annee" />
          <Property Name="AnneeId" Type="Int32" Nullable="false" />
        </EntityType>
        <Association Name="ActionEduAxeActionEduThematique">
          <End Type="CD67.FicheCollege.ActionEduAxe" Role="ActionEduAxe" Multiplicity="1" />
          <End Type="CD67.FicheCollege.ActionEduThematique" Role="ActionEduThematique" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEduAxe">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduThematique">
              <PropertyRef Name="ActionEduAxeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="ActionEduThematiqueActionEdu">
          <End Type="CD67.FicheCollege.ActionEduThematique" Role="ActionEduThematique" Multiplicity="1" />
          <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEduThematique">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEdu">
              <PropertyRef Name="ActionEduThematiqueId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="ActionEduAnnee">
          <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="*" />
          <End Type="CD67.FicheCollege.Annee" Role="Annee" Multiplicity="1" />
          <ReferentialConstraint>
            <Principal Role="Annee">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEdu">
              <PropertyRef Name="AnneeId" />
            </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="ActionEduAxes">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEduAxe)">
        <MappingFragment StoreEntitySet="ActionEduAxes">
          <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="ActionEduThematiques">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEduThematique)">
        <MappingFragment StoreEntitySet="ActionEduThematiques">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Nom" ColumnName="Nom" />
          <ScalarProperty Name="Neutralise" ColumnName="Neutralise" />
          <ScalarProperty Name="Ordre" ColumnName="Ordre" />
          <ScalarProperty Name="ActionEduAxeId" ColumnName="ActionEduAxeId" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="ActionsEdu">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEdu)">
        <MappingFragment StoreEntitySet="ActionsEdu">
          <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="ActionEduThematiqueId" ColumnName="ActionEduThematiqueId" />
          <ScalarProperty Name="AnneeId" ColumnName="AnneeId" />
        </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>