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" Provider="System.Data.SqlClient" ProviderManifestToken="2012" 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="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" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="ActionEduMissions">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Code" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Nom" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Description" Type="nvarchar(max)" />
          <Property Name="ActionEduCollegeId" 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" />
          <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="Numero" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Nom" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Montant" Type="decimal" Precision="18" Scale="0" />
          <Property Name="TiersSid" Type="nvarchar" MaxLength="7" />
          <Property Name="Description" Type="nvarchar(max)" />
          <Property Name="CommentaireInterne" Type="nvarchar(max)" />
          <Property Name="CommentairePublic" Type="nvarchar(max)" />
          <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>
        <EntityType Name="ActionsEduColleges">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Commentaire" Type="nvarchar(max)" />
          <Property Name="NbEleves" Type="bigint" />
          <Property Name="CollegeId" Type="int" Nullable="false" />
          <Property Name="ActionEduId" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Annees">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="12" Nullable="false" />
          <Property Name="AnneeRentree" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Colleges">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Annee_Id" Type="int" Nullable="false" />
          <Property Name="CodeRne" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Adresse" Type="nvarchar" MaxLength="255" />
          <Property Name="Code_Postal" Type="nvarchar" MaxLength="5" />
          <Property Name="TypeCollege_Id" Type="int" Nullable="false" />
          <Property Name="Commune_Insee" Type="nvarchar" MaxLength="5" />
          <Property Name="Commune" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Canton" Type="nvarchar" MaxLength="255" />
          <Property Name="Territoire_Id" Type="nvarchar" MaxLength="10" />
          <Property Name="TAD" Type="nvarchar" MaxLength="255" />
          <Property Name="CDC" Type="nvarchar" MaxLength="255" />
          <Property Name="Tel" Type="nvarchar" MaxLength="255" />
          <Property Name="Fax" Type="nvarchar" MaxLength="255" />
          <Property Name="Email" Type="nvarchar" MaxLength="255" />
          <Property Name="PrincipalSid" Type="nvarchar" MaxLength="64" />
          <Property Name="AdjointSid" Type="nvarchar" MaxLength="64" />
          <Property Name="Gestionnaire1Sid" Type="nvarchar" MaxLength="64" />
          <Property Name="Gestionnaire2Sid" Type="nvarchar" MaxLength="64" />
        </EntityType>
        <EntityType Name="Territoires">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Referent_SID" Type="nvarchar" MaxLength="64" />
          <Property Name="Referent_Nom" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Prenom" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Structure" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Login" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Email" Type="nvarchar" MaxLength="255" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="TypesCollege">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </EntityType>
        <Association Name="FK_ActionEduAnnee">
          <End Role="Annees" Type="Self.Annees" Multiplicity="1" />
          <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Annees">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionsEdu">
              <PropertyRef Name="AnneeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ActionEduAxeActionEduThematique">
          <End Role="ActionEduAxes" Type="Self.ActionEduAxes" Multiplicity="1" />
          <End Role="ActionEduThematiques" Type="Self.ActionEduThematiques" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEduAxes">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduThematiques">
              <PropertyRef Name="ActionEduAxeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ActionEduCollegeActionEdu">
          <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="1" />
          <End Role="ActionsEduColleges" Type="Self.ActionsEduColleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionsEdu">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionsEduColleges">
              <PropertyRef Name="ActionEduId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ActionEduCollegeActionEduMission">
          <End Role="ActionsEduColleges" Type="Self.ActionsEduColleges" Multiplicity="1" />
          <End Role="ActionEduMissions" Type="Self.ActionEduMissions" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionsEduColleges">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduMissions">
              <PropertyRef Name="ActionEduCollegeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ActionEduCollegeCollege">
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="1" />
          <End Role="ActionsEduColleges" Type="Self.ActionsEduColleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Colleges">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionsEduColleges">
              <PropertyRef Name="CollegeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ActionEduThematiqueActionEdu">
          <End Role="ActionEduThematiques" Type="Self.ActionEduThematiques" Multiplicity="1" />
          <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEduThematiques">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionsEdu">
              <PropertyRef Name="ActionEduThematiqueId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_AnneeCollege">
          <End Role="Annees" Type="Self.Annees" Multiplicity="1" />
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Annees">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Colleges">
              <PropertyRef Name="Annee_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Colleges_Territoires">
          <End Role="Territoires" Type="Self.Territoires" Multiplicity="0..1" />
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Territoires">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Colleges">
              <PropertyRef Name="Territoire_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Colleges_TypesCollege">
          <End Role="TypesCollege" Type="Self.TypesCollege" Multiplicity="1" />
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="TypesCollege">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Colleges">
              <PropertyRef Name="TypeCollege_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="CD67FicheCollegeStoreContainer">
          <EntitySet Name="ActionEduAxes" EntityType="Self.ActionEduAxes" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ActionEduMissions" EntityType="Self.ActionEduMissions" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ActionEduThematiques" EntityType="Self.ActionEduThematiques" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ActionsEdu" EntityType="Self.ActionsEdu" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ActionsEduColleges" EntityType="Self.ActionsEduColleges" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Annees" EntityType="Self.Annees" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Colleges" EntityType="Self.Colleges" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Territoires" EntityType="Self.Territoires" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="TypesCollege" EntityType="Self.TypesCollege" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_ActionEduAnnee" Association="Self.FK_ActionEduAnnee">
            <End Role="Annees" EntitySet="Annees" />
            <End Role="ActionsEdu" EntitySet="ActionsEdu" />
          </AssociationSet>
          <AssociationSet Name="FK_ActionEduAxeActionEduThematique" Association="Self.FK_ActionEduAxeActionEduThematique">
            <End Role="ActionEduAxes" EntitySet="ActionEduAxes" />
            <End Role="ActionEduThematiques" EntitySet="ActionEduThematiques" />
          </AssociationSet>
          <AssociationSet Name="FK_ActionEduCollegeActionEdu" Association="Self.FK_ActionEduCollegeActionEdu">
            <End Role="ActionsEdu" EntitySet="ActionsEdu" />
            <End Role="ActionsEduColleges" EntitySet="ActionsEduColleges" />
          </AssociationSet>
          <AssociationSet Name="FK_ActionEduCollegeActionEduMission" Association="Self.FK_ActionEduCollegeActionEduMission">
            <End Role="ActionsEduColleges" EntitySet="ActionsEduColleges" />
            <End Role="ActionEduMissions" EntitySet="ActionEduMissions" />
          </AssociationSet>
          <AssociationSet Name="FK_ActionEduCollegeCollege" Association="Self.FK_ActionEduCollegeCollege">
            <End Role="Colleges" EntitySet="Colleges" />
            <End Role="ActionsEduColleges" EntitySet="ActionsEduColleges" />
          </AssociationSet>
          <AssociationSet Name="FK_ActionEduThematiqueActionEdu" Association="Self.FK_ActionEduThematiqueActionEdu">
            <End Role="ActionEduThematiques" EntitySet="ActionEduThematiques" />
            <End Role="ActionsEdu" EntitySet="ActionsEdu" />
          </AssociationSet>
          <AssociationSet Name="FK_AnneeCollege" Association="Self.FK_AnneeCollege">
            <End Role="Annees" EntitySet="Annees" />
            <End Role="Colleges" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="FK_Colleges_Territoires" Association="Self.FK_Colleges_Territoires">
            <End Role="Territoires" EntitySet="Territoires" />
            <End Role="Colleges" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="FK_Colleges_TypesCollege" Association="Self.FK_Colleges_TypesCollege">
            <End Role="TypesCollege" EntitySet="TypesCollege" />
            <End Role="Colleges" EntitySet="Colleges" />
          </AssociationSet>
        </EntityContainer>
      </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="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>
          <EntitySet Name="ActionsEduColleges" EntityType="CD67.FicheCollege.ActionEduCollege" />
          <EntitySet Name="ActionEduMissions" EntityType="CD67.FicheCollege.ActionEduMission" />
          <AssociationSet Name="ActionEduCollegeActionEduMission" Association="CD67.FicheCollege.ActionEduCollegeActionEduMission">
            <End Role="ActionEduCollege" EntitySet="ActionsEduColleges" />
            <End Role="ActionEduMission" EntitySet="ActionEduMissions" />
          </AssociationSet>
          <AssociationSet Name="ActionEduCollegeCollege" Association="CD67.FicheCollege.ActionEduCollegeCollege">
            <End Role="ActionEduCollege" EntitySet="ActionsEduColleges" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="ActionEduCollegeActionEdu" Association="CD67.FicheCollege.ActionEduCollegeActionEdu">
            <End Role="ActionEduCollege" EntitySet="ActionsEduColleges" />
            <End Role="ActionEdu" EntitySet="ActionsEdu" />
          </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" annotation:StoreGeneratedPattern="Identity" />
          <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="Annee" Relationship="CD67.FicheCollege.AnneeCollege" FromRole="College" ToRole="Annee" />
          <NavigationProperty Name="ActionsEduColleges" Relationship="CD67.FicheCollege.ActionEduCollegeCollege" FromRole="College" ToRole="ActionEduCollege" />
          <Property Name="PrincipalSid" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="AdjointSid" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire1Sid" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2Sid" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
        </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="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" />
          <Property Name="AnneeRentree" Type="Int32" Nullable="false" />
        </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="Numero" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="Montant" Type="Decimal" Precision="18" Scale="0" Nullable="true" />
          <Property Name="TiersSid" Type="String" MaxLength="7" Unicode="true" FixedLength="false" />
          <Property Name="Description" Type="String" Nullable="true" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="CommentairePublic" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="CommentaireInterne" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <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" />
          <NavigationProperty Name="ActionsEduColleges" Relationship="CD67.FicheCollege.ActionEduCollegeActionEdu" FromRole="ActionEdu" ToRole="ActionEduCollege" />
        </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>
        <EntityType Name="ActionEduCollege">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="NbEleves" Type="Int64" Nullable="true" />
          <NavigationProperty Name="ActionEduMissions" Relationship="CD67.FicheCollege.ActionEduCollegeActionEduMission" FromRole="ActionEduCollege" ToRole="ActionEduMission" />
          <NavigationProperty Name="College" Relationship="CD67.FicheCollege.ActionEduCollegeCollege" FromRole="ActionEduCollege" ToRole="College" />
          <Property Name="Commentaire" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="CollegeId" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionEdu" Relationship="CD67.FicheCollege.ActionEduCollegeActionEdu" FromRole="ActionEduCollege" ToRole="ActionEdu" />
          <Property Name="ActionEduId" Type="Int32" Nullable="false" />
        </EntityType>
        <EntityType Name="ActionEduMission">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Code" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="Description" Type="String" Nullable="true" MaxLength="Max" Unicode="true" FixedLength="false" />
          <NavigationProperty Name="ActionEduCollege" Relationship="CD67.FicheCollege.ActionEduCollegeActionEduMission" FromRole="ActionEduMission" ToRole="ActionEduCollege" />
          <Property Name="ActionEduCollegeId" Type="Int32" Nullable="false" />
        </EntityType>
        <Association Name="ActionEduCollegeActionEduMission">
          <End Type="CD67.FicheCollege.ActionEduCollege" Role="ActionEduCollege" Multiplicity="1" />
          <End Type="CD67.FicheCollege.ActionEduMission" Role="ActionEduMission" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEduCollege">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduMission">
              <PropertyRef Name="ActionEduCollegeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="ActionEduCollegeCollege">
          <End Type="CD67.FicheCollege.ActionEduCollege" Role="ActionEduCollege" Multiplicity="*" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="1" />
          <ReferentialConstraint>
            <Principal Role="College">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduCollege">
              <PropertyRef Name="CollegeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="ActionEduCollegeActionEdu">
          <End Type="CD67.FicheCollege.ActionEduCollege" Role="ActionEduCollege" Multiplicity="*" />
          <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="1" />
          <ReferentialConstraint>
            <Principal Role="ActionEdu">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduCollege">
              <PropertyRef Name="ActionEduId" />
            </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="Gestionnaire2Sid" ColumnName="Gestionnaire2Sid" />
                <ScalarProperty Name="Gestionnaire1Sid" ColumnName="Gestionnaire1Sid" />
                <ScalarProperty Name="AdjointSid" ColumnName="AdjointSid" />
                <ScalarProperty Name="PrincipalSid" ColumnName="PrincipalSid" />
                <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="Annees">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Annee)">
        <MappingFragment StoreEntitySet="Annees">
          <ScalarProperty Name="AnneeRentree" ColumnName="AnneeRentree" />
                <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="CommentairePublic" ColumnName="CommentairePublic" />
                <ScalarProperty Name="CommentaireInterne" ColumnName="CommentaireInterne" />
                <ScalarProperty Name="TiersSid" ColumnName="TiersSid" />
                <ScalarProperty Name="Montant" ColumnName="Montant" />
                <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Numero" ColumnName="Numero" />
          <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>
    <EntitySetMapping Name="ActionsEduColleges">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEduCollege)">
        <MappingFragment StoreEntitySet="ActionsEduColleges">
          <ScalarProperty Name="Commentaire" ColumnName="Commentaire" />
                <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="NbEleves" ColumnName="NbEleves" />
          <ScalarProperty Name="CollegeId" ColumnName="CollegeId" />
          <ScalarProperty Name="ActionEduId" ColumnName="ActionEduId" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="ActionEduMissions">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEduMission)">
        <MappingFragment StoreEntitySet="ActionEduMissions">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Code" ColumnName="Code" />
          <ScalarProperty Name="Nom" ColumnName="Nom" />
          <ScalarProperty Name="Description" ColumnName="Description" />
          <ScalarProperty Name="ActionEduCollegeId" ColumnName="ActionEduCollegeId" />
        </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>