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="ActionEduActeurRoles">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Libelle" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="ActionEduActeurs">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Nom" Type="varchar(max)" Nullable="false" />
          <Property Name="Sid" Type="nvarchar" MaxLength="7" />
          <Property Name="RoleId" Type="int" Nullable="false" />
          <Property Name="Commentaire" Type="varchar(max)" />
          <Property Name="ActionEduId" Type="int" Nullable="false" />
        </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" />
          <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="ActionEduStatuts">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" Nullable="false" />
          <Property Name="Nom" Type="varchar" MaxLength="50" 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="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="StatutId" Type="int" Nullable="false" />
          <Property Name="AnneeId" Type="int" Nullable="false" />
          <Property Name="TokenId" Type="uniqueidentifier" 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" />
          <Property Name="TokenId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="RestaurationType_Id" Type="int" />
        </EntityType>
        <EntityType Name="Groupes">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Nom" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Description" Type="nvarchar(max)" />
        </EntityType>
        <EntityType Name="RestaurationFormulaires">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="uniqueidentifier" Nullable="false" />
          <Property Name="College_Id" Type="int" Nullable="false" />
          <Property Name="Statut" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="NbDP_College" Type="int" Nullable="false" />
          <Property Name="NbDP_Lycee" Type="int" />
          <Property Name="NbDP_MatPrimPeri" Type="int" />
          <Property Name="NbDP_Commensaux" Type="int" />
          <Property Name="NbDP_ATC" Type="int" />
          <Property Name="NbDP_AgentC" Type="int" />
          <Property Name="Prix_Forfait5j" Type="decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait5j" Type="int" />
          <Property Name="Prix_Forfait4j" Type="decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait4j" Type="int" />
          <Property Name="Prix_Forfait3j" Type="decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait3j" Type="int" />
          <Property Name="Prix_Forfait2j" Type="decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait2j" Type="int" />
          <Property Name="Prix_Forfait1j" Type="decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait1j" Type="int" />
          <Property Name="Prix_Ticket" Type="decimal" Precision="18" Scale="2" Nullable="false" />
          <Property Name="Tarif_Pension" Type="decimal" Precision="18" Scale="2" />
          <Property Name="Prix_ATC" Type="decimal" Precision="18" Scale="2" Nullable="false" />
          <Property Name="Prix_AgentC" Type="decimal" Precision="18" Scale="2" Nullable="false" />
          <Property Name="Prix_Commensaux" Type="decimal" Precision="18" Scale="2" />
          <Property Name="Prix_EcolePeri" Type="decimal" Precision="18" Scale="2" />
          <Property Name="NbEleves_FondSocial" Type="int" />
          <Property Name="Montant_FondSocial" Type="decimal" Precision="18" Scale="2" />
          <Property Name="NbEleves_Impayes" Type="int" />
          <Property Name="Montant_Impayes" Type="decimal" Precision="18" Scale="2" />
          <Property Name="Date_AvisCA" Type="datetime2" Precision="7" />
          <Property Name="Ind_Signature" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="RestaurationFormulairesRepas">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="RestaurationFormulaires_Id" Type="uniqueidentifier" Nullable="false" />
          <Property Name="RestaurationTypesRepas_Id" Type="int" Nullable="false" />
          <Property Name="NbRepas" Type="int" />
          <Property Name="NbJours" Type="int" />
          <Property Name="NomEtablissement" Type="nvarchar" MaxLength="255" />
        </EntityType>
        <EntityType Name="RestaurationParametres">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Annee_Id" Type="int" Nullable="false" />
          <Property Name="Campagne" Type="bit" Nullable="false" />
          <Property Name="Prix_Mini" Type="decimal" Precision="18" Scale="2" />
          <Property Name="Prix_ATC" Type="decimal" Precision="18" Scale="2" />
          <Property Name="Prix_AgentC" Type="decimal" Precision="18" Scale="2" />
          <Property Name="Prix_MiniAutres" Type="decimal" Precision="18" Scale="2" />
        </EntityType>
        <EntityType Name="RestaurationParametresRepas">
          <Key>
            <PropertyRef Name="RestaurationParametres_Id" />
            <PropertyRef Name="RestaurationTypesRepas_Id" />
          </Key>
          <Property Name="RestaurationParametres_Id" Type="int" Nullable="false" />
          <Property Name="RestaurationTypesRepas_Id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="RestaurationTypes">
          <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="Valid" Type="bit" Nullable="false" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="RestaurationTypesRepas">
          <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="Valid" Type="bit" Nullable="false" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </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>
        <EntityType Name="Utilisateurs">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" Nullable="false" />
          <Property Name="Sid" Type="nvarchar" MaxLength="64" Nullable="false" />
          <Property Name="Login" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="mail" Type="nvarchar" MaxLength="100" />
        </EntityType>
        <EntityType Name="UtilisateursGroupes">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="GroupeId" Type="int" Nullable="false" />
          <Property Name="UtilisateurId" Type="int" Nullable="false" />
        </EntityType>
        <Association Name="FK_ActionEduActeurs_ActionEduActeurRoles">
          <End Role="ActionEduActeurRoles" Type="Self.ActionEduActeurRoles" Multiplicity="1" />
          <End Role="ActionEduActeurs" Type="Self.ActionEduActeurs" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEduActeurRoles">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduActeurs">
              <PropertyRef Name="RoleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ActionEduActionEduActeur">
          <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="1" />
          <End Role="ActionEduActeurs" Type="Self.ActionEduActeurs" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionsEdu">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduActeurs">
              <PropertyRef Name="ActionEduId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <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_ActionsEdu_ActionEduStatuts">
          <End Role="ActionEduStatuts" Type="Self.ActionEduStatuts" Multiplicity="1" />
          <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEduStatuts">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionsEdu">
              <PropertyRef Name="StatutId" />
            </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_RestaurationTypes">
          <End Role="RestaurationTypes" Type="Self.RestaurationTypes" Multiplicity="0..1" />
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RestaurationTypes">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Colleges">
              <PropertyRef Name="RestaurationType_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>
        <Association Name="FK_RestaurationFormulairesColleges">
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="1" />
          <End Role="RestaurationFormulaires" Type="Self.RestaurationFormulaires" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Colleges">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationFormulaires">
              <PropertyRef Name="College_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RestaurationFormulairesRepasForm">
          <End Role="RestaurationFormulaires" Type="Self.RestaurationFormulaires" Multiplicity="1" />
          <End Role="RestaurationFormulairesRepas" Type="Self.RestaurationFormulairesRepas" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RestaurationFormulaires">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationFormulairesRepas">
              <PropertyRef Name="RestaurationFormulaires_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RestaurationFormulairesTypesRepas">
          <End Role="RestaurationTypesRepas" Type="Self.RestaurationTypesRepas" Multiplicity="1" />
          <End Role="RestaurationFormulairesRepas" Type="Self.RestaurationFormulairesRepas" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RestaurationTypesRepas">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationFormulairesRepas">
              <PropertyRef Name="RestaurationTypesRepas_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RestaurationParametresAnnee">
          <End Role="Annees" Type="Self.Annees" Multiplicity="1" />
          <End Role="RestaurationParametres" Type="Self.RestaurationParametres" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Annees">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationParametres">
              <PropertyRef Name="Annee_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RestaurationParametresRepas_Param">
          <End Role="RestaurationParametres" Type="Self.RestaurationParametres" Multiplicity="1" />
          <End Role="RestaurationParametresRepas" Type="Self.RestaurationParametresRepas" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RestaurationParametres">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationParametresRepas">
              <PropertyRef Name="RestaurationParametres_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RestaurationParametresRepas_Repas">
          <End Role="RestaurationTypesRepas" Type="Self.RestaurationTypesRepas" Multiplicity="1" />
          <End Role="RestaurationParametresRepas" Type="Self.RestaurationParametresRepas" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RestaurationTypesRepas">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationParametresRepas">
              <PropertyRef Name="RestaurationTypesRepas_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UtilisateursGroupesGroupes">
          <End Role="Groupes" Type="Self.Groupes" Multiplicity="1" />
          <End Role="UtilisateursGroupes" Type="Self.UtilisateursGroupes" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groupes">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="UtilisateursGroupes">
              <PropertyRef Name="GroupeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UtilisateursGroupesUtilisateurs">
          <End Role="Utilisateurs" Type="Self.Utilisateurs" Multiplicity="1" />
          <End Role="UtilisateursGroupes" Type="Self.UtilisateursGroupes" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Utilisateurs">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="UtilisateursGroupes">
              <PropertyRef Name="UtilisateurId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="CD67FicheCollegeStoreContainer">
          <EntitySet Name="ActionEduActeurRoles" EntityType="Self.ActionEduActeurRoles" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ActionEduActeurs" EntityType="Self.ActionEduActeurs" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ActionEduAxes" EntityType="Self.ActionEduAxes" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ActionEduMissions" EntityType="Self.ActionEduMissions" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ActionEduStatuts" EntityType="Self.ActionEduStatuts" 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="Groupes" EntityType="Self.Groupes" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RestaurationFormulaires" EntityType="Self.RestaurationFormulaires" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RestaurationFormulairesRepas" EntityType="Self.RestaurationFormulairesRepas" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RestaurationParametres" EntityType="Self.RestaurationParametres" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RestaurationParametresRepas" EntityType="Self.RestaurationParametresRepas" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RestaurationTypes" EntityType="Self.RestaurationTypes" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RestaurationTypesRepas" EntityType="Self.RestaurationTypesRepas" 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" />
          <EntitySet Name="Utilisateurs" EntityType="Self.Utilisateurs" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="UtilisateursGroupes" EntityType="Self.UtilisateursGroupes" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_ActionEduActeurs_ActionEduActeurRoles" Association="Self.FK_ActionEduActeurs_ActionEduActeurRoles">
            <End Role="ActionEduActeurRoles" EntitySet="ActionEduActeurRoles" />
            <End Role="ActionEduActeurs" EntitySet="ActionEduActeurs" />
          </AssociationSet>
          <AssociationSet Name="FK_ActionEduActionEduActeur" Association="Self.FK_ActionEduActionEduActeur">
            <End Role="ActionsEdu" EntitySet="ActionsEdu" />
            <End Role="ActionEduActeurs" EntitySet="ActionEduActeurs" />
          </AssociationSet>
          <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_ActionsEdu_ActionEduStatuts" Association="Self.FK_ActionsEdu_ActionEduStatuts">
            <End Role="ActionEduStatuts" EntitySet="ActionEduStatuts" />
            <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_RestaurationTypes" Association="Self.FK_Colleges_RestaurationTypes">
            <End Role="RestaurationTypes" EntitySet="RestaurationTypes" />
            <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>
          <AssociationSet Name="FK_RestaurationFormulairesColleges" Association="Self.FK_RestaurationFormulairesColleges">
            <End Role="Colleges" EntitySet="Colleges" />
            <End Role="RestaurationFormulaires" EntitySet="RestaurationFormulaires" />
          </AssociationSet>
          <AssociationSet Name="FK_RestaurationFormulairesRepasForm" Association="Self.FK_RestaurationFormulairesRepasForm">
            <End Role="RestaurationFormulaires" EntitySet="RestaurationFormulaires" />
            <End Role="RestaurationFormulairesRepas" EntitySet="RestaurationFormulairesRepas" />
          </AssociationSet>
          <AssociationSet Name="FK_RestaurationFormulairesTypesRepas" Association="Self.FK_RestaurationFormulairesTypesRepas">
            <End Role="RestaurationTypesRepas" EntitySet="RestaurationTypesRepas" />
            <End Role="RestaurationFormulairesRepas" EntitySet="RestaurationFormulairesRepas" />
          </AssociationSet>
          <AssociationSet Name="FK_RestaurationParametresAnnee" Association="Self.FK_RestaurationParametresAnnee">
            <End Role="Annees" EntitySet="Annees" />
            <End Role="RestaurationParametres" EntitySet="RestaurationParametres" />
          </AssociationSet>
          <AssociationSet Name="FK_RestaurationParametresRepas_Param" Association="Self.FK_RestaurationParametresRepas_Param">
            <End Role="RestaurationParametres" EntitySet="RestaurationParametres" />
            <End Role="RestaurationParametresRepas" EntitySet="RestaurationParametresRepas" />
          </AssociationSet>
          <AssociationSet Name="FK_RestaurationParametresRepas_Repas" Association="Self.FK_RestaurationParametresRepas_Repas">
            <End Role="RestaurationTypesRepas" EntitySet="RestaurationTypesRepas" />
            <End Role="RestaurationParametresRepas" EntitySet="RestaurationParametresRepas" />
          </AssociationSet>
          <AssociationSet Name="FK_UtilisateursGroupesGroupes" Association="Self.FK_UtilisateursGroupesGroupes">
            <End Role="Groupes" EntitySet="Groupes" />
            <End Role="UtilisateursGroupes" EntitySet="UtilisateursGroupes" />
          </AssociationSet>
          <AssociationSet Name="FK_UtilisateursGroupesUtilisateurs" Association="Self.FK_UtilisateursGroupesUtilisateurs">
            <End Role="Utilisateurs" EntitySet="Utilisateurs" />
            <End Role="UtilisateursGroupes" EntitySet="UtilisateursGroupes" />
          </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>
          <EntitySet Name="ActionEduActeurs" EntityType="CD67.FicheCollege.ActionEduActeur" />
          <EntitySet Name="ActionEduStatuts" EntityType="CD67.FicheCollege.ActionEduStatut" />
          <AssociationSet Name="FK_ActionEduActionEduActeur" Association="CD67.FicheCollege.FK_ActionEduActionEduActeur">
            <End Role="ActionEdu" EntitySet="ActionsEdu" />
            <End Role="ActionEduActeur" EntitySet="ActionEduActeurs" />
          </AssociationSet>
          <AssociationSet Name="FK_ActionsEdu_ActionEduStatuts" Association="CD67.FicheCollege.FK_ActionsEdu_ActionEduStatuts">
            <End Role="ActionEduStatut1" EntitySet="ActionEduStatuts" />
            <End Role="ActionEdu" EntitySet="ActionsEdu" />
          </AssociationSet>
          <EntitySet Name="ActionEduActeurRoles" EntityType="CD67.FicheCollege.ActionEduActeurRole" />
          <AssociationSet Name="FK_ActionEduActeurs_ActionEduActeurRoles" Association="CD67.FicheCollege.FK_ActionEduActeurs_ActionEduActeurRoles">
            <End Role="ActionEduActeurRole" EntitySet="ActionEduActeurRoles" />
            <End Role="ActionEduActeur" EntitySet="ActionEduActeurs" />
          </AssociationSet>
          <EntitySet Name="RestaurationTypes" EntityType="CD67.FicheCollege.RestaurationType" />
          <AssociationSet Name="FK_Colleges_RestaurationTypes" Association="CD67.FicheCollege.FK_Colleges_RestaurationTypes">
            <End Role="RestaurationType" EntitySet="RestaurationTypes" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          <EntitySet Name="RestaurationParametres" EntityType="CD67.FicheCollege.RestaurationParametre" />
          <AssociationSet Name="FK_RestaurationParametresAnnee" Association="CD67.FicheCollege.FK_RestaurationParametresAnnee">
            <End Role="Annee" EntitySet="Annees" />
            <End Role="RestaurationParametre" EntitySet="RestaurationParametres" />
          </AssociationSet>
          <EntitySet Name="RestaurationTypesRepas" EntityType="CD67.FicheCollege.RestaurationTypesRepa" />
          <AssociationSet Name="RestaurationParametresRepas1" Association="CD67.FicheCollege.RestaurationParametresRepas1">
            <End Role="RestaurationParametre" EntitySet="RestaurationParametres" />
            <End Role="RestaurationTypesRepa" EntitySet="RestaurationTypesRepas" />
          </AssociationSet>
          <EntitySet Name="RestaurationFormulaires" EntityType="CD67.FicheCollege.RestaurationFormulaire" />
          <EntitySet Name="RestaurationFormulairesRepas" EntityType="CD67.FicheCollege.RestaurationFormulairesRepa" />
          <AssociationSet Name="FK_RestaurationFormulairesColleges" Association="CD67.FicheCollege.FK_RestaurationFormulairesColleges">
            <End Role="College" EntitySet="Colleges" />
            <End Role="RestaurationFormulaire" EntitySet="RestaurationFormulaires" />
          </AssociationSet>
          <AssociationSet Name="FK_RestaurationFormulairesRepasForm" Association="CD67.FicheCollege.FK_RestaurationFormulairesRepasForm">
            <End Role="RestaurationFormulaire" EntitySet="RestaurationFormulaires" />
            <End Role="RestaurationFormulairesRepa" EntitySet="RestaurationFormulairesRepas" />
          </AssociationSet>
          <AssociationSet Name="FK_RestaurationFormulairesTypesRepas" Association="CD67.FicheCollege.FK_RestaurationFormulairesTypesRepas">
            <End Role="RestaurationTypesRepa" EntitySet="RestaurationTypesRepas" />
            <End Role="RestaurationFormulairesRepa" EntitySet="RestaurationFormulairesRepas" />
          </AssociationSet>
          <EntitySet Name="Groupes" EntityType="CD67.FicheCollege.Groupe" />
          <EntitySet Name="Utilisateurs" EntityType="CD67.FicheCollege.Utilisateur" />
          <EntitySet Name="UtilisateursGroupes" EntityType="CD67.FicheCollege.UtilisateursGroupe" />
          <AssociationSet Name="FK_UtilisateursGroupesGroupes" Association="CD67.FicheCollege.FK_UtilisateursGroupesGroupes">
            <End Role="Groupe" EntitySet="Groupes" />
            <End Role="UtilisateursGroupe" EntitySet="UtilisateursGroupes" />
          </AssociationSet>
          <AssociationSet Name="FK_UtilisateursGroupesUtilisateurs" Association="CD67.FicheCollege.FK_UtilisateursGroupesUtilisateurs">
            <End Role="Utilisateur" EntitySet="Utilisateurs" />
            <End Role="UtilisateursGroupe" EntitySet="UtilisateursGroupes" />
          </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" />
          <Property Name="TokenId" Type="Guid" Nullable="false" />
          <Property Name="RestaurationType_Id" Type="Int32" />
          <NavigationProperty Name="RestaurationType" Relationship="CD67.FicheCollege.FK_Colleges_RestaurationTypes" FromRole="College" ToRole="RestaurationType" />
          <NavigationProperty Name="RestaurationFormulaires" Relationship="CD67.FicheCollege.FK_RestaurationFormulairesColleges" FromRole="College" ToRole="RestaurationFormulaire" />
        </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" />
          <NavigationProperty Name="RestaurationParametres" Relationship="CD67.FicheCollege.FK_RestaurationParametresAnnee" FromRole="Annee" ToRole="RestaurationParametre" />
        </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="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" />
          <Property Name="TokenId" Type="Guid" Nullable="false" />
          <Property Name="StatutId" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionEduActeurs" Relationship="CD67.FicheCollege.FK_ActionEduActionEduActeur" FromRole="ActionEdu" ToRole="ActionEduActeur" />
          <NavigationProperty Name="ActionEduStatut" Relationship="CD67.FicheCollege.FK_ActionsEdu_ActionEduStatuts" FromRole="ActionEdu" ToRole="ActionEduStatut1" />
        </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="Int32" 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>
        <EntityType Name="ActionEduActeur">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="Sid" Type="String" MaxLength="7" FixedLength="false" Unicode="true" />
          <Property Name="RoleId" Type="Int32" Nullable="false" />
          <Property Name="Commentaire" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="ActionEduId" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionEdu" Relationship="CD67.FicheCollege.FK_ActionEduActionEduActeur" FromRole="ActionEduActeur" ToRole="ActionEdu" />
          <NavigationProperty Name="ActionEduActeurRole" Relationship="CD67.FicheCollege.FK_ActionEduActeurs_ActionEduActeurRoles" FromRole="ActionEduActeur" ToRole="ActionEduActeurRole" />
        </EntityType>
        <EntityType Name="ActionEduStatut">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" />
          <Property Name="Nom" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <NavigationProperty Name="ActionsEdus" Relationship="CD67.FicheCollege.FK_ActionsEdu_ActionEduStatuts" FromRole="ActionEduStatut1" ToRole="ActionEdu" />
        </EntityType>
        <Association Name="FK_ActionEduActionEduActeur">
          <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="1" />
          <End Type="CD67.FicheCollege.ActionEduActeur" Role="ActionEduActeur" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEdu">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduActeur">
              <PropertyRef Name="ActionEduId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ActionsEdu_ActionEduStatuts">
          <End Type="CD67.FicheCollege.ActionEduStatut" Role="ActionEduStatut1" Multiplicity="1" />
          <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEduStatut1">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEdu">
              <PropertyRef Name="StatutId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="ActionEduActeurRole">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ActionEduActeurs" Relationship="CD67.FicheCollege.FK_ActionEduActeurs_ActionEduActeurRoles" FromRole="ActionEduActeurRole" ToRole="ActionEduActeur" />
        </EntityType>
        <Association Name="FK_ActionEduActeurs_ActionEduActeurRoles">
          <End Type="CD67.FicheCollege.ActionEduActeurRole" Role="ActionEduActeurRole" Multiplicity="1" />
          <End Type="CD67.FicheCollege.ActionEduActeur" Role="ActionEduActeur" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ActionEduActeurRole">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="ActionEduActeur">
              <PropertyRef Name="RoleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="RestaurationType">
          <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="Valid" Type="Boolean" Nullable="false" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.FK_Colleges_RestaurationTypes" FromRole="RestaurationType" ToRole="College" />
        </EntityType>
        <Association Name="FK_Colleges_RestaurationTypes">
          <End Type="CD67.FicheCollege.RestaurationType" Role="RestaurationType" Multiplicity="0..1" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RestaurationType">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="College">
              <PropertyRef Name="RestaurationType_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="RestaurationParametre">
          <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="Campagne" Type="Boolean" Nullable="false" />
          <Property Name="Prix_Mini" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="Prix_ATC" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="Prix_AgentC" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="Prix_MiniAutres" Type="Decimal" Precision="18" Scale="2" />
          <NavigationProperty Name="Annee" Relationship="CD67.FicheCollege.FK_RestaurationParametresAnnee" FromRole="RestaurationParametre" ToRole="Annee" />
          <NavigationProperty Name="RestaurationTypesRepas" Relationship="CD67.FicheCollege.RestaurationParametresRepas1" FromRole="RestaurationParametre" ToRole="RestaurationTypesRepa" />
        </EntityType>
        <Association Name="FK_RestaurationParametresAnnee">
          <End Type="CD67.FicheCollege.Annee" Role="Annee" Multiplicity="1" />
          <End Type="CD67.FicheCollege.RestaurationParametre" Role="RestaurationParametre" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Annee">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationParametre">
              <PropertyRef Name="Annee_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="RestaurationTypesRepa">
          <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="Valid" Type="Boolean" Nullable="false" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="RestaurationParametres" Relationship="CD67.FicheCollege.RestaurationParametresRepas1" FromRole="RestaurationTypesRepa" ToRole="RestaurationParametre" />
          <NavigationProperty Name="RestaurationFormulairesRepas" Relationship="CD67.FicheCollege.FK_RestaurationFormulairesTypesRepas" FromRole="RestaurationTypesRepa" ToRole="RestaurationFormulairesRepa" />
        </EntityType>
        <Association Name="RestaurationParametresRepas1">
          <End Type="CD67.FicheCollege.RestaurationParametre" Role="RestaurationParametre" Multiplicity="*" />
          <End Type="CD67.FicheCollege.RestaurationTypesRepa" Role="RestaurationTypesRepa" Multiplicity="*" />
        </Association>
        <EntityType Name="RestaurationFormulaire">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Guid" Nullable="false" />
          <Property Name="College_Id" Type="Int32" Nullable="false" />
          <Property Name="Statut" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="NbDP_College" Type="Int32" Nullable="false" />
          <Property Name="NbDP_Lycee" Type="Int32" />
          <Property Name="NbDP_MatPrimPeri" Type="Int32" />
          <Property Name="NbDP_Commensaux" Type="Int32" />
          <Property Name="NbDP_ATC" Type="Int32" />
          <Property Name="NbDP_AgentC" Type="Int32" />
          <Property Name="Prix_Forfait5j" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait5j" Type="Int32" />
          <Property Name="Prix_Forfait4j" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait4j" Type="Int32" />
          <Property Name="Prix_Forfait3j" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait3j" Type="Int32" />
          <Property Name="Prix_Forfait2j" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait2j" Type="Int32" />
          <Property Name="Prix_Forfait1j" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="NbJours_Forfait1j" Type="Int32" />
          <Property Name="Prix_Ticket" Type="Decimal" Nullable="false" Precision="18" Scale="2" />
          <Property Name="Tarif_Pension" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="Prix_ATC" Type="Decimal" Nullable="false" Precision="18" Scale="2" />
          <Property Name="Prix_AgentC" Type="Decimal" Nullable="false" Precision="18" Scale="2" />
          <Property Name="Prix_Commensaux" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="Prix_EcolePeri" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="NbEleves_FondSocial" Type="Int32" />
          <Property Name="Montant_FondSocial" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="NbEleves_Impayes" Type="Int32" />
          <Property Name="Montant_Impayes" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="Date_AvisCA" Type="DateTime" Precision="7" />
          <Property Name="Ind_Signature" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="College" Relationship="CD67.FicheCollege.FK_RestaurationFormulairesColleges" FromRole="RestaurationFormulaire" ToRole="College" />
          <NavigationProperty Name="RestaurationFormulairesRepas" Relationship="CD67.FicheCollege.FK_RestaurationFormulairesRepasForm" FromRole="RestaurationFormulaire" ToRole="RestaurationFormulairesRepa" />
        </EntityType>
        <EntityType Name="RestaurationFormulairesRepa">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="RestaurationFormulaires_Id" Type="Guid" Nullable="false" />
          <Property Name="RestaurationTypesRepas_Id" Type="Int32" Nullable="false" />
          <Property Name="NbRepas" Type="Int32" />
          <Property Name="NbJours" Type="Int32" />
          <Property Name="NomEtablissement" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="RestaurationFormulaire" Relationship="CD67.FicheCollege.FK_RestaurationFormulairesRepasForm" FromRole="RestaurationFormulairesRepa" ToRole="RestaurationFormulaire" />
          <NavigationProperty Name="RestaurationTypesRepa" Relationship="CD67.FicheCollege.FK_RestaurationFormulairesTypesRepas" FromRole="RestaurationFormulairesRepa" ToRole="RestaurationTypesRepa" />
        </EntityType>
        <Association Name="FK_RestaurationFormulairesColleges">
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="1" />
          <End Type="CD67.FicheCollege.RestaurationFormulaire" Role="RestaurationFormulaire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="College">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationFormulaire">
              <PropertyRef Name="College_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RestaurationFormulairesRepasForm">
          <End Type="CD67.FicheCollege.RestaurationFormulaire" Role="RestaurationFormulaire" Multiplicity="1" />
          <End Type="CD67.FicheCollege.RestaurationFormulairesRepa" Role="RestaurationFormulairesRepa" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RestaurationFormulaire">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationFormulairesRepa">
              <PropertyRef Name="RestaurationFormulaires_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RestaurationFormulairesTypesRepas">
          <End Type="CD67.FicheCollege.RestaurationTypesRepa" Role="RestaurationTypesRepa" Multiplicity="1" />
          <End Type="CD67.FicheCollege.RestaurationFormulairesRepa" Role="RestaurationFormulairesRepa" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RestaurationTypesRepa">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="RestaurationFormulairesRepa">
              <PropertyRef Name="RestaurationTypesRepas_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="Groupe">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Nom" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="UtilisateursGroupes" Relationship="CD67.FicheCollege.FK_UtilisateursGroupesGroupes" FromRole="Groupe" ToRole="UtilisateursGroupe" />
        </EntityType>
        <EntityType Name="Utilisateur">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" />
          <Property Name="Sid" Type="String" Nullable="false" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Login" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="mail" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="UtilisateursGroupes" Relationship="CD67.FicheCollege.FK_UtilisateursGroupesUtilisateurs" FromRole="Utilisateur" ToRole="UtilisateursGroupe" />
        </EntityType>
        <EntityType Name="UtilisateursGroupe">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="GroupeId" Type="Int32" Nullable="false" />
          <Property Name="UtilisateurId" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Groupe" Relationship="CD67.FicheCollege.FK_UtilisateursGroupesGroupes" FromRole="UtilisateursGroupe" ToRole="Groupe" />
          <NavigationProperty Name="Utilisateur" Relationship="CD67.FicheCollege.FK_UtilisateursGroupesUtilisateurs" FromRole="UtilisateursGroupe" ToRole="Utilisateur" />
        </EntityType>
        <Association Name="FK_UtilisateursGroupesGroupes">
          <End Type="CD67.FicheCollege.Groupe" Role="Groupe" Multiplicity="1" />
          <End Type="CD67.FicheCollege.UtilisateursGroupe" Role="UtilisateursGroupe" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groupe">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="UtilisateursGroupe">
              <PropertyRef Name="GroupeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UtilisateursGroupesUtilisateurs">
          <End Type="CD67.FicheCollege.Utilisateur" Role="Utilisateur" Multiplicity="1" />
          <End Type="CD67.FicheCollege.UtilisateursGroupe" Role="UtilisateursGroupe" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Utilisateur">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="UtilisateursGroupe">
              <PropertyRef Name="UtilisateurId" />
            </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="RestaurationType_Id" ColumnName="RestaurationType_Id" />
                <ScalarProperty Name="TokenId" ColumnName="TokenId" />
                <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="StatutId" ColumnName="StatutId" />
                <ScalarProperty Name="TokenId" ColumnName="TokenId" />
                <ScalarProperty Name="CommentairePublic" ColumnName="CommentairePublic" />
                <ScalarProperty Name="CommentaireInterne" ColumnName="CommentaireInterne" />
                <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>
          <EntitySetMapping Name="ActionEduActeurs">
            <EntityTypeMapping TypeName="CD67.FicheCollege.ActionEduActeur">
              <MappingFragment StoreEntitySet="ActionEduActeurs">
                <ScalarProperty Name="Commentaire" ColumnName="Commentaire" />
                <ScalarProperty Name="ActionEduId" ColumnName="ActionEduId" />
                <ScalarProperty Name="RoleId" ColumnName="RoleId" />
                <ScalarProperty Name="Sid" ColumnName="Sid" />
                <ScalarProperty Name="Nom" ColumnName="Nom" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ActionEduStatuts">
            <EntityTypeMapping TypeName="CD67.FicheCollege.ActionEduStatut">
              <MappingFragment StoreEntitySet="ActionEduStatuts">
                <ScalarProperty Name="Nom" ColumnName="Nom" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ActionEduActeurRoles">
            <EntityTypeMapping TypeName="CD67.FicheCollege.ActionEduActeurRole">
              <MappingFragment StoreEntitySet="ActionEduActeurRoles">
                <ScalarProperty Name="Ordre" ColumnName="Ordre" />
                <ScalarProperty Name="Libelle" ColumnName="Libelle" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RestaurationTypes">
            <EntityTypeMapping TypeName="CD67.FicheCollege.RestaurationType">
              <MappingFragment StoreEntitySet="RestaurationTypes">
                <ScalarProperty Name="Ordre" ColumnName="Ordre" />
                <ScalarProperty Name="Valid" ColumnName="Valid" />
                <ScalarProperty Name="Libelle" ColumnName="Libelle" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RestaurationParametres">
            <EntityTypeMapping TypeName="CD67.FicheCollege.RestaurationParametre">
              <MappingFragment StoreEntitySet="RestaurationParametres">
                <ScalarProperty Name="Prix_MiniAutres" ColumnName="Prix_MiniAutres" />
                <ScalarProperty Name="Prix_AgentC" ColumnName="Prix_AgentC" />
                <ScalarProperty Name="Prix_ATC" ColumnName="Prix_ATC" />
                <ScalarProperty Name="Prix_Mini" ColumnName="Prix_Mini" />
                <ScalarProperty Name="Campagne" ColumnName="Campagne" />
                <ScalarProperty Name="Annee_Id" ColumnName="Annee_Id" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RestaurationTypesRepas">
            <EntityTypeMapping TypeName="CD67.FicheCollege.RestaurationTypesRepa">
              <MappingFragment StoreEntitySet="RestaurationTypesRepas">
                <ScalarProperty Name="Ordre" ColumnName="Ordre" />
                <ScalarProperty Name="Valid" ColumnName="Valid" />
                <ScalarProperty Name="Libelle" ColumnName="Libelle" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <AssociationSetMapping Name="RestaurationParametresRepas1" TypeName="CD67.FicheCollege.RestaurationParametresRepas1" StoreEntitySet="RestaurationParametresRepas">
            <EndProperty Name="RestaurationTypesRepa">
              <ScalarProperty Name="Id" ColumnName="RestaurationTypesRepas_Id" />
            </EndProperty>
            <EndProperty Name="RestaurationParametre">
              <ScalarProperty Name="Id" ColumnName="RestaurationParametres_Id" />
            </EndProperty>
          </AssociationSetMapping>
          <EntitySetMapping Name="RestaurationFormulaires">
            <EntityTypeMapping TypeName="CD67.FicheCollege.RestaurationFormulaire">
              <MappingFragment StoreEntitySet="RestaurationFormulaires">
                <ScalarProperty Name="Ind_Signature" ColumnName="Ind_Signature" />
                <ScalarProperty Name="Date_AvisCA" ColumnName="Date_AvisCA" />
                <ScalarProperty Name="Montant_Impayes" ColumnName="Montant_Impayes" />
                <ScalarProperty Name="NbEleves_Impayes" ColumnName="NbEleves_Impayes" />
                <ScalarProperty Name="Montant_FondSocial" ColumnName="Montant_FondSocial" />
                <ScalarProperty Name="NbEleves_FondSocial" ColumnName="NbEleves_FondSocial" />
                <ScalarProperty Name="Prix_EcolePeri" ColumnName="Prix_EcolePeri" />
                <ScalarProperty Name="Prix_Commensaux" ColumnName="Prix_Commensaux" />
                <ScalarProperty Name="Prix_AgentC" ColumnName="Prix_AgentC" />
                <ScalarProperty Name="Prix_ATC" ColumnName="Prix_ATC" />
                <ScalarProperty Name="Tarif_Pension" ColumnName="Tarif_Pension" />
                <ScalarProperty Name="Prix_Ticket" ColumnName="Prix_Ticket" />
                <ScalarProperty Name="NbJours_Forfait1j" ColumnName="NbJours_Forfait1j" />
                <ScalarProperty Name="Prix_Forfait1j" ColumnName="Prix_Forfait1j" />
                <ScalarProperty Name="NbJours_Forfait2j" ColumnName="NbJours_Forfait2j" />
                <ScalarProperty Name="Prix_Forfait2j" ColumnName="Prix_Forfait2j" />
                <ScalarProperty Name="NbJours_Forfait3j" ColumnName="NbJours_Forfait3j" />
                <ScalarProperty Name="Prix_Forfait3j" ColumnName="Prix_Forfait3j" />
                <ScalarProperty Name="NbJours_Forfait4j" ColumnName="NbJours_Forfait4j" />
                <ScalarProperty Name="Prix_Forfait4j" ColumnName="Prix_Forfait4j" />
                <ScalarProperty Name="NbJours_Forfait5j" ColumnName="NbJours_Forfait5j" />
                <ScalarProperty Name="Prix_Forfait5j" ColumnName="Prix_Forfait5j" />
                <ScalarProperty Name="NbDP_AgentC" ColumnName="NbDP_AgentC" />
                <ScalarProperty Name="NbDP_ATC" ColumnName="NbDP_ATC" />
                <ScalarProperty Name="NbDP_Commensaux" ColumnName="NbDP_Commensaux" />
                <ScalarProperty Name="NbDP_MatPrimPeri" ColumnName="NbDP_MatPrimPeri" />
                <ScalarProperty Name="NbDP_Lycee" ColumnName="NbDP_Lycee" />
                <ScalarProperty Name="NbDP_College" ColumnName="NbDP_College" />
                <ScalarProperty Name="Statut" ColumnName="Statut" />
                <ScalarProperty Name="College_Id" ColumnName="College_Id" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RestaurationFormulairesRepas">
            <EntityTypeMapping TypeName="CD67.FicheCollege.RestaurationFormulairesRepa">
              <MappingFragment StoreEntitySet="RestaurationFormulairesRepas">
                <ScalarProperty Name="NomEtablissement" ColumnName="NomEtablissement" />
                <ScalarProperty Name="NbJours" ColumnName="NbJours" />
                <ScalarProperty Name="NbRepas" ColumnName="NbRepas" />
                <ScalarProperty Name="RestaurationTypesRepas_Id" ColumnName="RestaurationTypesRepas_Id" />
                <ScalarProperty Name="RestaurationFormulaires_Id" ColumnName="RestaurationFormulaires_Id" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Groupes">
            <EntityTypeMapping TypeName="CD67.FicheCollege.Groupe">
              <MappingFragment StoreEntitySet="Groupes">
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Nom" ColumnName="Nom" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Utilisateurs">
            <EntityTypeMapping TypeName="CD67.FicheCollege.Utilisateur">
              <MappingFragment StoreEntitySet="Utilisateurs">
                <ScalarProperty Name="mail" ColumnName="mail" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="Sid" ColumnName="Sid" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UtilisateursGroupes">
            <EntityTypeMapping TypeName="CD67.FicheCollege.UtilisateursGroupe">
              <MappingFragment StoreEntitySet="UtilisateursGroupes">
                <ScalarProperty Name="UtilisateurId" ColumnName="UtilisateurId" />
                <ScalarProperty Name="GroupeId" ColumnName="GroupeId" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </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>