fichecollege/CD67.FicheCollege.Entity/EducfModel.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="educfModel.Store" Provider="Npgsql" ProviderManifestToken="9.2.8" 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="commune">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="200" />
          <Property Name="code" Type="varchar" MaxLength="7" />
          <Property Name="insee" Type="varchar" MaxLength="30" />
          <Property Name="superficie" Type="numeric" Precision="10" Scale="0" />
          <Property Name="maire" Type="varchar" MaxLength="100" />
          <Property Name="adresse" Type="varchar" MaxLength="100" />
          <Property Name="tel" Type="varchar" MaxLength="100" />
          <Property Name="fax" Type="varchar" MaxLength="100" />
          <Property Name="email" Type="varchar" MaxLength="250" />
          <Property Name="urbanisationemail" Type="varchar" MaxLength="250" />
          <Property Name="urbanisationinterlocuteur" Type="varchar" MaxLength="100" />
          <Property Name="urbanisationtel" Type="varchar" MaxLength="100" />
          <Property Name="optcommunecollege" Type="numeric" Precision="1" Scale="0" />
          <Property Name="rpi" Type="varchar" MaxLength="50" />
          <Property Name="web" Type="varchar" MaxLength="100" />
          <Property Name="idcanton" Type="int4" />
        </EntityType>
        <EntityType Name="eleveannee">
          <Key>
            <PropertyRef Name="code" />
            <PropertyRef Name="annee" />
          </Key>
          <Property Name="code" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="idetablissement" Type="float8" />
          <Property Name="annee" Type="float8" Nullable="false" />
          <Property Name="idniveau" Type="float8" />
          <Property Name="inscritrs" Type="float8" />
          <Property Name="inscritts" Type="float8" />
          <Property Name="interne" Type="float8" />
          <Property Name="ititransport" Type="float8" />
          <Property Name="arret8h" Type="float8" />
          <Property Name="arret12h" Type="float8" />
          <Property Name="arret14h" Type="float8" />
          <Property Name="arret17h" Type="float8" />
          <Property Name="classe" Type="varchar" MaxLength="30" />
          <Property Name="idfiliere" Type="float8" />
          <Property Name="optboursier" Type="numeric" Precision="1" Scale="0" />
          <Property Name="typebourse" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optderogation" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optcl" Type="numeric" Precision="1" Scale="0" />
          <Property Name="idetabprec" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idniveauprec" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idoption1" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idoption2" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idoption3" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idoption4" Type="numeric" Precision="10" Scale="0" />
          <Property Name="nonredoublant" Type="numeric" Precision="1" Scale="0" />
          <Property Name="idclasse" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idsousgroupe" Type="numeric" Precision="10" Scale="0" />
          <Property Name="qf" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idoption5" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idmef" Type="numeric" Precision="5" Scale="0" />
        </EntityType>
        <EntityType Name="etabeffectifannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="int4" />
          <Property Name="annee" Type="float8" />
          <Property Name="effectif" Type="float8" />
          <Property Name="idniveau" Type="float8" />
          <Property Name="tap" Type="float8" />
          <Property Name="tevit" Type="float8" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nbclasses" Type="numeric" Precision="5" Scale="0" />
          <Property Name="effectifdp" Type="float8" />
          <Property Name="effectifderog" Type="float8" />
          <Property Name="tapsec" Type="float8" />
        </EntityType>
        <EntityType Name="etablissement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="250" />
          <Property Name="numero" Type="varchar" MaxLength="20" />
          <Property Name="idtype" Type="float8" />
          <Property Name="privepublic" Type="float8" />
          <Property Name="numadresse" Type="varchar" MaxLength="20" />
          <Property Name="idrue" Type="float8" />
          <Property Name="adresse2" Type="varchar" MaxLength="250" />
          <Property Name="tel" Type="varchar" MaxLength="20" />
          <Property Name="fax" Type="varchar" MaxLength="20" />
          <Property Name="tel2" Type="varchar" MaxLength="20" />
          <Property Name="numabrege" Type="varchar" MaxLength="10" />
          <Property Name="email" Type="varchar" MaxLength="250" />
          <Property Name="anneeconstruction" Type="float8" />
          <Property Name="idclassement" Type="float8" />
          <Property Name="web" Type="varchar" MaxLength="250" />
          <Property Name="surface" Type="varchar" MaxLength="20" />
          <Property Name="accueilhandicape" Type="numeric" Precision="1" Scale="0" />
          <Property Name="idelementairesecteur" Type="text" />
          <Property Name="horaires1" Type="varchar" MaxLength="100" />
          <Property Name="horaires2" Type="varchar" MaxLength="100" />
          <Property Name="horaires3" Type="varchar" MaxLength="100" />
          <Property Name="horaires4" Type="varchar" MaxLength="100" />
          <Property Name="optdplundi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optdpmardi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optdpmercredi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optdpjeudi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optdpvendredi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="idregierestauration" Type="numeric" Precision="3" Scale="0" />
          <Property Name="idbassin" Type="numeric" Precision="5" Scale="0" />
          <Property Name="couleur" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idcouleur" Type="int4" />
          <Property Name="optulis" Type="int4" />
          <Property Name="cp" Type="varchar" MaxLength="10" />
          <Property Name="anneerestructuration" Type="varchar" MaxLength="4" />
          <Property Name="libellecarte1" Type="varchar" MaxLength="200" />
          <Property Name="libellecarte2" Type="varchar" MaxLength="200" />
        </EntityType>
        <EntityType Name="etablissementannee">
          <Key>
            <PropertyRef Name="idetablissement" />
            <PropertyRef Name="annee" />
          </Key>
          <Property Name="idetablissement" Type="int4" Nullable="false" />
          <Property Name="annee" Type="float8" Nullable="false" />
          <Property Name="nbeleves" Type="float8" />
          <Property Name="capaciteinternes" Type="float8" />
          <Property Name="capacitedemipension" Type="float8" />
          <Property Name="capaciteeleves" Type="float8" />
          <Property Name="effectifmaximal" Type="float8" />
          <Property Name="classesprevues" Type="float8" />
          <Property Name="elevessecteur" Type="float8" />
          <Property Name="eleveshorssecteur" Type="float8" />
          <Property Name="niveauremplissage" Type="float8" />
          <Property Name="demipensionnaires" Type="float8" />
          <Property Name="responsable" Type="varchar" MaxLength="250" />
          <Property Name="gestionnaire" Type="varchar" MaxLength="250" />
          <Property Name="nbenseignants" Type="float8" />
          <Property Name="nbadministratifs" Type="float8" />
          <Property Name="nbautrepersonnel" Type="float8" />
          <Property Name="optzep" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optrep" Type="numeric" Precision="1" Scale="0" />
          <Property Name="capacitearchi" Type="int4" />
          <Property Name="optrar" Type="numeric" Precision="1" Scale="0" />
          <Property Name="ien" Type="varchar" MaxLength="200" />
          <Property Name="capacitesegpa" Type="int4" />
          <Property Name="internes" Type="int4" />
          <Property Name="nbsegpa" Type="int4" />
          <Property Name="rpi" Type="varchar" MaxLength="50" />
          <Property Name="optrpi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="nbhandi" Type="int4" />
          <Property Name="nbtechno" Type="int4" />
          <Property Name="nbupi" Type="int4" />
          <Property Name="nbcham" Type="int4" />
          <Property Name="nbsport" Type="int4" />
          <Property Name="capacitedivisions" Type="int4" />
          <Property Name="nbdivisions" Type="int4" />
          <Property Name="nbgene" Type="int4" />
          <Property Name="nbulis" Type="int4" />
          <Property Name="nbdima" Type="int4" />
          <Property Name="principaladjoint" Type="varchar" MaxLength="100" />
          <Property Name="mailgestionnaire" Type="varchar" MaxLength="100" />
          <Property Name="mailresponsable" Type="varchar" MaxLength="100" />
          <Property Name="nbupe2a" Type="int4" />
          <Property Name="dotation" Type="numeric" Precision="12" Scale="0" />
          <Property Name="nbcpsfavorisea" Type="int4" />
          <Property Name="nbcpsfavoriseb" Type="int4" />
          <Property Name="nbcpsdefavorise" Type="int4" />
          <Property Name="nbcpsmoyenne" Type="int4" />
          <Property Name="optrpiconcentre" Type="varchar" MaxLength="1" />
        </EntityType>
        <EntityType Name="etaboptionsannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="int4" />
          <Property Name="idoption" Type="numeric" Precision="5" Scale="0" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
        </EntityType>
        <EntityType Name="filiere">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="60" />
          <Property Name="libelle" Type="varchar" MaxLength="100" />
        </EntityType>
        <EntityType Name="matiereoption">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="code" Type="varchar" MaxLength="20" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="nomcourt" Type="varchar" MaxLength="50" />
          <Property Name="nomlong" Type="varchar" MaxLength="200" />
        </EntityType>
        <EntityType Name="mef">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="code" Type="varchar" MaxLength="11" />
          <Property Name="mefst11" Type="varchar" MaxLength="11" />
          <Property Name="nomcourt" Type="varchar" MaxLength="6" />
          <Property Name="nomlong" Type="varchar" MaxLength="40" />
          <Property Name="idniveau" Type="numeric" Precision="5" Scale="0" />
          <Property Name="idfiliere" Type="numeric" Precision="5" Scale="0" />
        </EntityType>
        <EntityType Name="niveau">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="typeetablissement" Type="float8" />
          <Property Name="nom" Type="varchar" MaxLength="20" />
          <Property Name="ordre" Type="float8" />
          <Property Name="idniveaumontee" Type="numeric" Precision="5" Scale="0" />
          <Property Name="capacite" Type="numeric" Precision="3" Scale="0" />
          <Property Name="capacitezep" Type="numeric" Precision="3" Scale="0" />
        </EntityType>
        <EntityType Name="rues">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="idcommune" Type="int4" />
          <Property Name="typerue" Type="varchar" MaxLength="100" />
          <Property Name="rivoli" Type="varchar" MaxLength="10" />
        </EntityType>
        <Association Name="FK_EtabAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etablissementannee" Type="Self.etablissementannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etablissementannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabEffectifAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabeffectifannee" Type="Self.etabeffectifannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabeffectifannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabOptionsAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etaboptionsannee" Type="Self.etaboptionsannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etaboptionsannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RuesCommunes">
          <End Role="commune" Type="Self.commune" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="rues" Type="Self.rues" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="commune">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="rues">
              <PropertyRef Name="idcommune" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="educfModelStoreContainer">
          <EntitySet Name="commune" EntityType="Self.commune" Schema="educf" store:Type="Tables" />
          <EntitySet Name="eleveannee" EntityType="Self.eleveannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabeffectifannee" EntityType="Self.etabeffectifannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etablissement" EntityType="Self.etablissement" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etablissementannee" EntityType="Self.etablissementannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etaboptionsannee" EntityType="Self.etaboptionsannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="filiere" EntityType="Self.filiere" Schema="educf" store:Type="Tables" />
          <EntitySet Name="matiereoption" EntityType="Self.matiereoption" Schema="educf" store:Type="Tables" />
          <EntitySet Name="mef" EntityType="Self.mef" Schema="educf" store:Type="Tables" />
          <EntitySet Name="niveau" EntityType="Self.niveau" Schema="educf" store:Type="Tables" />
          <EntitySet Name="rues" EntityType="Self.rues" Schema="educf" store:Type="Tables" />
          <AssociationSet Name="FK_EtabAnnee" Association="Self.FK_EtabAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etablissementannee" EntitySet="etablissementannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabEffectifAnnee" Association="Self.FK_EtabEffectifAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabeffectifannee" EntitySet="etabeffectifannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabOptionsAnnee" Association="Self.FK_EtabOptionsAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etaboptionsannee" EntitySet="etaboptionsannee" />
          </AssociationSet>
          <AssociationSet Name="FK_RuesCommunes" Association="Self.FK_RuesCommunes">
            <End Role="commune" EntitySet="commune" />
            <End Role="rues" EntitySet="rues" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="educfModel" 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">
        <EntityType Name="commune">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="code" Type="String" MaxLength="7" FixedLength="false" Unicode="true" />
          <Property Name="insee" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="superficie" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="maire" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="adresse" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="tel" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="fax" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="email" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="urbanisationemail" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="urbanisationinterlocuteur" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="urbanisationtel" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="optcommunecollege" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="rpi" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="web" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="idcanton" Type="Int32" />
          <NavigationProperty Name="rues" Relationship="Self.FK_RuesCommunes" FromRole="commune" ToRole="rues" />
        </EntityType>
        <EntityType Name="etabeffectifannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="annee" Type="Double" />
          <Property Name="effectif" Type="Double" />
          <Property Name="idniveau" Type="Int32" />
          <Property Name="tap" Type="Double" />
          <Property Name="tevit" Type="Double" />
          <Property Name="nbclasses" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="effectifdp" Type="Double" />
          <Property Name="effectifderog" Type="Double" />
          <Property Name="tapsec" Type="Double" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_EtabEffectifAnnee" FromRole="etabeffectifannee" ToRole="etablissement" />
          <NavigationProperty Name="niveau" Relationship="educfModel.niveauetabeffectifannee" FromRole="etabeffectifannee" ToRole="niveau" />
        </EntityType>
        <EntityType Name="etablissement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="numero" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="idtype" Type="Double" />
          <Property Name="privepublic" Type="Double" />
          <Property Name="numadresse" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="idrue" Type="Int32" />
          <Property Name="adresse2" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="tel" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="fax" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="tel2" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="numabrege" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="email" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="anneeconstruction" Type="Double" />
          <Property Name="idclassement" Type="Double" />
          <Property Name="web" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="surface" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="accueilhandicape" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="idelementairesecteur" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="horaires1" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="horaires2" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="horaires3" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="horaires4" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="optdplundi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optdpmardi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optdpmercredi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optdpjeudi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optdpvendredi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="idregierestauration" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="idbassin" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="couleur" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idcouleur" Type="Int32" />
          <Property Name="optulis" Type="Int32" />
          <Property Name="cp" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="anneerestructuration" Type="String" MaxLength="4" FixedLength="false" Unicode="true" />
          <Property Name="libellecarte1" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="libellecarte2" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="etabeffectifannees" Relationship="Self.FK_EtabEffectifAnnee" FromRole="etablissement" ToRole="etabeffectifannee" />
          <NavigationProperty Name="rue" Relationship="educfModel.etablissementrue" FromRole="etablissement" ToRole="rue" />
          <NavigationProperty Name="etaboptionsannees" Relationship="educfModel.FK_EtabOptionsAnnee" FromRole="etablissement" ToRole="etaboptionsannee" />
          <NavigationProperty Name="etablissementannees" Relationship="educfModel.FK_EtabAnnee" FromRole="etablissement" ToRole="etablissementannee" />
          <NavigationProperty Name="eleveannees" Relationship="educfModel.etablissementeleveannee" FromRole="etablissement" ToRole="eleveannee" />
        </EntityType>
        <EntityType Name="niveau">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="typeetablissement" Type="Double" />
          <Property Name="nom" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="ordre" Type="Double" />
          <Property Name="idniveaumontee" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="capacite" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="capacitezep" Type="Decimal" Precision="3" Scale="0" />
          <NavigationProperty Name="etabeffectifannees" Relationship="educfModel.niveauetabeffectifannee" FromRole="niveau" ToRole="etabeffectifannee" />
        </EntityType>
        <EntityType Name="rue">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="idcommune" Type="Int32" />
          <Property Name="typerue" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="rivoli" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="commune" Relationship="Self.FK_RuesCommunes" FromRole="rues" ToRole="commune" />
          <NavigationProperty Name="etablissements" Relationship="educfModel.etablissementrue" FromRole="rue" ToRole="etablissement" />
        </EntityType>
        <Association Name="FK_RuesCommunes">
          <End Role="commune" Type="Self.commune" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="rues" Type="Self.rue" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="commune">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="rues">
              <PropertyRef Name="idcommune" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabEffectifAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabeffectifannee" Type="Self.etabeffectifannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabeffectifannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="EducfEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="communes" EntityType="Self.commune" />
          <EntitySet Name="etabeffectifannees" EntityType="Self.etabeffectifannee" />
          <EntitySet Name="etablissements" EntityType="Self.etablissement" />
          <EntitySet Name="niveaux" EntityType="Self.niveau" />
          <EntitySet Name="rues" EntityType="Self.rue" />
          <AssociationSet Name="FK_RuesCommunes" Association="Self.FK_RuesCommunes">
            <End Role="commune" EntitySet="communes" />
            <End Role="rues" EntitySet="rues" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabEffectifAnnee" Association="Self.FK_EtabEffectifAnnee">
            <End Role="etablissement" EntitySet="etablissements" />
            <End Role="etabeffectifannee" EntitySet="etabeffectifannees" />
          </AssociationSet>
          <AssociationSet Name="etablissementrue" Association="educfModel.etablissementrue">
            <End Role="etablissement" EntitySet="etablissements" />
            <End Role="rue" EntitySet="rues" />
          </AssociationSet>
          <AssociationSet Name="niveauetabeffectifannee" Association="educfModel.niveauetabeffectifannee">
            <End Role="niveau" EntitySet="niveaux" />
            <End Role="etabeffectifannee" EntitySet="etabeffectifannees" />
          </AssociationSet>
          <EntitySet Name="filieres" EntityType="educfModel.filiere" />
          <EntitySet Name="mefs" EntityType="educfModel.mef" />
          <AssociationSet Name="filieremef" Association="educfModel.filieremef">
            <End Role="filiere" EntitySet="filieres" />
            <End Role="mef" EntitySet="mefs" />
          </AssociationSet>
          <EntitySet Name="etaboptionsannees" EntityType="educfModel.etaboptionsannee" />
          <EntitySet Name="matiereoptions" EntityType="educfModel.matiereoption" />
          <AssociationSet Name="FK_EtabOptionsAnnee" Association="educfModel.FK_EtabOptionsAnnee">
            <End Role="etablissement" EntitySet="etablissements" />
            <End Role="etaboptionsannee" EntitySet="etaboptionsannees" />
          </AssociationSet>
          <AssociationSet Name="matiereoptionetaboptionsannee" Association="educfModel.matiereoptionetaboptionsannee">
            <End Role="etaboptionsannee" EntitySet="etaboptionsannees" />
            <End Role="matiereoption" EntitySet="matiereoptions" />
          </AssociationSet>
          <EntitySet Name="eleveannees" EntityType="educfModel.eleveannee" />
          <EntitySet Name="etablissementannees" EntityType="educfModel.etablissementannee" />
          <AssociationSet Name="FK_EtabAnnee" Association="educfModel.FK_EtabAnnee">
            <End Role="etablissement" EntitySet="etablissements" />
            <End Role="etablissementannee" EntitySet="etablissementannees" />
          </AssociationSet>
          <AssociationSet Name="etablissementeleveannee" Association="educfModel.etablissementeleveannee">
            <End Role="etablissement" EntitySet="etablissements" />
            <End Role="eleveannee" EntitySet="eleveannees" />
          </AssociationSet>
        </EntityContainer>
        <Association Name="etablissementrue">
          <End Type="educfModel.etablissement" Role="etablissement" Multiplicity="*" />
          <End Type="educfModel.rue" Role="rue" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="rue">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etablissement">
              <PropertyRef Name="idrue" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="niveauetabeffectifannee">
          <End Type="educfModel.niveau" Role="niveau" Multiplicity="0..1" />
          <End Type="educfModel.etabeffectifannee" Role="etabeffectifannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="niveau">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabeffectifannee">
              <PropertyRef Name="idniveau" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="filiere">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
          <Property Name="libelle" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="mefs" Relationship="educfModel.filieremef" FromRole="filiere" ToRole="mef" />
        </EntityType>
        <EntityType Name="mef">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="code" Type="String" MaxLength="11" FixedLength="false" Unicode="true" />
          <Property Name="mefst11" Type="String" MaxLength="11" FixedLength="false" Unicode="true" />
          <Property Name="nomcourt" Type="String" MaxLength="6" FixedLength="false" Unicode="true" />
          <Property Name="nomlong" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
          <Property Name="idniveau" Type="Int32" />
          <Property Name="idfiliere" Type="Int32" />
          <NavigationProperty Name="filiere" Relationship="educfModel.filieremef" FromRole="mef" ToRole="filiere" />
        </EntityType>
        <Association Name="filieremef">
          <End Type="educfModel.filiere" Role="filiere" Multiplicity="0..1" />
          <End Type="educfModel.mef" Role="mef" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="filiere">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="mef">
              <PropertyRef Name="idfiliere" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="etaboptionsannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="idoption" Type="Int32" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="etablissement" Relationship="educfModel.FK_EtabOptionsAnnee" FromRole="etaboptionsannee" ToRole="etablissement" />
          <NavigationProperty Name="matiereoption" Relationship="educfModel.matiereoptionetaboptionsannee" FromRole="etaboptionsannee" ToRole="matiereoption" />
        </EntityType>
        <EntityType Name="matiereoption">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="code" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="nom" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="nomcourt" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="nomlong" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="etaboptionsannees" Relationship="educfModel.matiereoptionetaboptionsannee" FromRole="matiereoption" ToRole="etaboptionsannee" />
        </EntityType>
        <Association Name="FK_EtabOptionsAnnee">
          <End Type="educfModel.etablissement" Role="etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="educfModel.etaboptionsannee" Role="etaboptionsannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etaboptionsannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="matiereoptionetaboptionsannee">
          <End Type="educfModel.etaboptionsannee" Role="etaboptionsannee" Multiplicity="*" />
          <End Type="educfModel.matiereoption" Role="matiereoption" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="matiereoption">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etaboptionsannee">
              <PropertyRef Name="idoption" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="eleveannee">
          <Key>
            <PropertyRef Name="code" />
            <PropertyRef Name="annee" />
          </Key>
          <Property Name="code" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="annee" Type="Double" Nullable="false" />
          <Property Name="idniveau" Type="Double" />
          <Property Name="inscritrs" Type="Double" />
          <Property Name="inscritts" Type="Double" />
          <Property Name="interne" Type="Double" />
          <Property Name="ititransport" Type="Double" />
          <Property Name="arret8h" Type="Double" />
          <Property Name="arret12h" Type="Double" />
          <Property Name="arret14h" Type="Double" />
          <Property Name="arret17h" Type="Double" />
          <Property Name="classe" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="idfiliere" Type="Double" />
          <Property Name="optboursier" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="typebourse" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optderogation" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optcl" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="idetabprec" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idniveauprec" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idoption1" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idoption2" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idoption3" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idoption4" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="nonredoublant" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="idclasse" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idsousgroupe" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="qf" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idoption5" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idmef" Type="Decimal" Precision="5" Scale="0" />
          <NavigationProperty Name="etablissement" Relationship="educfModel.etablissementeleveannee" FromRole="eleveannee" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etablissementannee">
          <Key>
            <PropertyRef Name="idetablissement" />
            <PropertyRef Name="annee" />
          </Key>
          <Property Name="idetablissement" Type="Int32" Nullable="false" />
          <Property Name="annee" Type="Double" Nullable="false" />
          <Property Name="nbeleves" Type="Double" />
          <Property Name="capaciteinternes" Type="Double" />
          <Property Name="capacitedemipension" Type="Double" />
          <Property Name="capaciteeleves" Type="Double" />
          <Property Name="effectifmaximal" Type="Double" />
          <Property Name="classesprevues" Type="Double" />
          <Property Name="elevessecteur" Type="Double" />
          <Property Name="eleveshorssecteur" Type="Double" />
          <Property Name="niveauremplissage" Type="Double" />
          <Property Name="demipensionnaires" Type="Double" />
          <Property Name="responsable" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="gestionnaire" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="nbenseignants" Type="Double" />
          <Property Name="nbadministratifs" Type="Double" />
          <Property Name="nbautrepersonnel" Type="Double" />
          <Property Name="optzep" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optrep" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="capacitearchi" Type="Int32" />
          <Property Name="optrar" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="ien" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="capacitesegpa" Type="Int32" />
          <Property Name="internes" Type="Int32" />
          <Property Name="nbsegpa" Type="Int32" />
          <Property Name="rpi" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="optrpi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="nbhandi" Type="Int32" />
          <Property Name="nbtechno" Type="Int32" />
          <Property Name="nbupi" Type="Int32" />
          <Property Name="nbcham" Type="Int32" />
          <Property Name="nbsport" Type="Int32" />
          <Property Name="capacitedivisions" Type="Int32" />
          <Property Name="nbdivisions" Type="Int32" />
          <Property Name="nbgene" Type="Int32" />
          <Property Name="nbulis" Type="Int32" />
          <Property Name="nbdima" Type="Int32" />
          <Property Name="principaladjoint" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="mailgestionnaire" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="mailresponsable" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="nbupe2a" Type="Int32" />
          <Property Name="dotation" Type="Decimal" Precision="12" Scale="0" />
          <Property Name="nbcpsfavorisea" Type="Int32" />
          <Property Name="nbcpsfavoriseb" Type="Int32" />
          <Property Name="nbcpsdefavorise" Type="Int32" />
          <Property Name="nbcpsmoyenne" Type="Int32" />
          <Property Name="optrpiconcentre" Type="String" MaxLength="1" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="etablissement" Relationship="educfModel.FK_EtabAnnee" FromRole="etablissementannee" ToRole="etablissement" />
        </EntityType>
        <Association Name="FK_EtabAnnee">
          <End Type="educfModel.etablissement" Role="etablissement" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="educfModel.etablissementannee" Role="etablissementannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etablissementannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="etablissementeleveannee">
          <End Type="educfModel.etablissement" Role="etablissement" Multiplicity="0..1" />
          <End Type="educfModel.eleveannee" Role="eleveannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="eleveannee">
              <PropertyRef Name="idetablissement" />
            </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="educfModelStoreContainer" CdmEntityContainer="EducfEntities">
          <EntitySetMapping Name="communes">
            <EntityTypeMapping TypeName="educfModel.commune">
              <MappingFragment StoreEntitySet="commune">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="insee" ColumnName="insee" />
                <ScalarProperty Name="superficie" ColumnName="superficie" />
                <ScalarProperty Name="maire" ColumnName="maire" />
                <ScalarProperty Name="adresse" ColumnName="adresse" />
                <ScalarProperty Name="tel" ColumnName="tel" />
                <ScalarProperty Name="fax" ColumnName="fax" />
                <ScalarProperty Name="email" ColumnName="email" />
                <ScalarProperty Name="urbanisationemail" ColumnName="urbanisationemail" />
                <ScalarProperty Name="urbanisationinterlocuteur" ColumnName="urbanisationinterlocuteur" />
                <ScalarProperty Name="urbanisationtel" ColumnName="urbanisationtel" />
                <ScalarProperty Name="optcommunecollege" ColumnName="optcommunecollege" />
                <ScalarProperty Name="rpi" ColumnName="rpi" />
                <ScalarProperty Name="web" ColumnName="web" />
                <ScalarProperty Name="idcanton" ColumnName="idcanton" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabeffectifannees">
            <EntityTypeMapping TypeName="educfModel.etabeffectifannee">
              <MappingFragment StoreEntitySet="etabeffectifannee">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="effectif" ColumnName="effectif" />
                <ScalarProperty Name="idniveau" ColumnName="idniveau" />
                <ScalarProperty Name="tap" ColumnName="tap" />
                <ScalarProperty Name="tevit" ColumnName="tevit" />
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nbclasses" ColumnName="nbclasses" />
                <ScalarProperty Name="effectifdp" ColumnName="effectifdp" />
                <ScalarProperty Name="effectifderog" ColumnName="effectifderog" />
                <ScalarProperty Name="tapsec" ColumnName="tapsec" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etablissements">
            <EntityTypeMapping TypeName="educfModel.etablissement">
              <MappingFragment StoreEntitySet="etablissement">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="numero" ColumnName="numero" />
                <ScalarProperty Name="idtype" ColumnName="idtype" />
                <ScalarProperty Name="privepublic" ColumnName="privepublic" />
                <ScalarProperty Name="numadresse" ColumnName="numadresse" />
                <ScalarProperty Name="idrue" ColumnName="idrue" />
                <ScalarProperty Name="adresse2" ColumnName="adresse2" />
                <ScalarProperty Name="tel" ColumnName="tel" />
                <ScalarProperty Name="fax" ColumnName="fax" />
                <ScalarProperty Name="tel2" ColumnName="tel2" />
                <ScalarProperty Name="numabrege" ColumnName="numabrege" />
                <ScalarProperty Name="email" ColumnName="email" />
                <ScalarProperty Name="anneeconstruction" ColumnName="anneeconstruction" />
                <ScalarProperty Name="idclassement" ColumnName="idclassement" />
                <ScalarProperty Name="web" ColumnName="web" />
                <ScalarProperty Name="surface" ColumnName="surface" />
                <ScalarProperty Name="accueilhandicape" ColumnName="accueilhandicape" />
                <ScalarProperty Name="idelementairesecteur" ColumnName="idelementairesecteur" />
                <ScalarProperty Name="horaires1" ColumnName="horaires1" />
                <ScalarProperty Name="horaires2" ColumnName="horaires2" />
                <ScalarProperty Name="horaires3" ColumnName="horaires3" />
                <ScalarProperty Name="horaires4" ColumnName="horaires4" />
                <ScalarProperty Name="optdplundi" ColumnName="optdplundi" />
                <ScalarProperty Name="optdpmardi" ColumnName="optdpmardi" />
                <ScalarProperty Name="optdpmercredi" ColumnName="optdpmercredi" />
                <ScalarProperty Name="optdpjeudi" ColumnName="optdpjeudi" />
                <ScalarProperty Name="optdpvendredi" ColumnName="optdpvendredi" />
                <ScalarProperty Name="idregierestauration" ColumnName="idregierestauration" />
                <ScalarProperty Name="idbassin" ColumnName="idbassin" />
                <ScalarProperty Name="couleur" ColumnName="couleur" />
                <ScalarProperty Name="idcouleur" ColumnName="idcouleur" />
                <ScalarProperty Name="optulis" ColumnName="optulis" />
                <ScalarProperty Name="cp" ColumnName="cp" />
                <ScalarProperty Name="anneerestructuration" ColumnName="anneerestructuration" />
                <ScalarProperty Name="libellecarte1" ColumnName="libellecarte1" />
                <ScalarProperty Name="libellecarte2" ColumnName="libellecarte2" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="niveaux">
            <EntityTypeMapping TypeName="educfModel.niveau">
              <MappingFragment StoreEntitySet="niveau">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="typeetablissement" ColumnName="typeetablissement" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="ordre" ColumnName="ordre" />
                <ScalarProperty Name="idniveaumontee" ColumnName="idniveaumontee" />
                <ScalarProperty Name="capacite" ColumnName="capacite" />
                <ScalarProperty Name="capacitezep" ColumnName="capacitezep" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="rues">
            <EntityTypeMapping TypeName="educfModel.rue">
              <MappingFragment StoreEntitySet="rues">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="idcommune" ColumnName="idcommune" />
                <ScalarProperty Name="typerue" ColumnName="typerue" />
                <ScalarProperty Name="rivoli" ColumnName="rivoli" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="filieres">
            <EntityTypeMapping TypeName="educfModel.filiere">
              <MappingFragment StoreEntitySet="filiere">
                <ScalarProperty Name="libelle" ColumnName="libelle" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="mefs">
            <EntityTypeMapping TypeName="educfModel.mef">
              <MappingFragment StoreEntitySet="mef">
                <ScalarProperty Name="idfiliere" ColumnName="idfiliere" />
                <ScalarProperty Name="idniveau" ColumnName="idniveau" />
                <ScalarProperty Name="nomlong" ColumnName="nomlong" />
                <ScalarProperty Name="nomcourt" ColumnName="nomcourt" />
                <ScalarProperty Name="mefst11" ColumnName="mefst11" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etaboptionsannees">
            <EntityTypeMapping TypeName="educfModel.etaboptionsannee">
              <MappingFragment StoreEntitySet="etaboptionsannee">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idoption" ColumnName="idoption" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="matiereoptions">
            <EntityTypeMapping TypeName="educfModel.matiereoption">
              <MappingFragment StoreEntitySet="matiereoption">
                <ScalarProperty Name="nomlong" ColumnName="nomlong" />
                <ScalarProperty Name="nomcourt" ColumnName="nomcourt" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="eleveannees">
            <EntityTypeMapping TypeName="educfModel.eleveannee">
              <MappingFragment StoreEntitySet="eleveannee">
                <ScalarProperty Name="idmef" ColumnName="idmef" />
                <ScalarProperty Name="idoption5" ColumnName="idoption5" />
                <ScalarProperty Name="qf" ColumnName="qf" />
                <ScalarProperty Name="idsousgroupe" ColumnName="idsousgroupe" />
                <ScalarProperty Name="idclasse" ColumnName="idclasse" />
                <ScalarProperty Name="nonredoublant" ColumnName="nonredoublant" />
                <ScalarProperty Name="idoption4" ColumnName="idoption4" />
                <ScalarProperty Name="idoption3" ColumnName="idoption3" />
                <ScalarProperty Name="idoption2" ColumnName="idoption2" />
                <ScalarProperty Name="idoption1" ColumnName="idoption1" />
                <ScalarProperty Name="idniveauprec" ColumnName="idniveauprec" />
                <ScalarProperty Name="idetabprec" ColumnName="idetabprec" />
                <ScalarProperty Name="optcl" ColumnName="optcl" />
                <ScalarProperty Name="optderogation" ColumnName="optderogation" />
                <ScalarProperty Name="typebourse" ColumnName="typebourse" />
                <ScalarProperty Name="optboursier" ColumnName="optboursier" />
                <ScalarProperty Name="idfiliere" ColumnName="idfiliere" />
                <ScalarProperty Name="classe" ColumnName="classe" />
                <ScalarProperty Name="arret17h" ColumnName="arret17h" />
                <ScalarProperty Name="arret14h" ColumnName="arret14h" />
                <ScalarProperty Name="arret12h" ColumnName="arret12h" />
                <ScalarProperty Name="arret8h" ColumnName="arret8h" />
                <ScalarProperty Name="ititransport" ColumnName="ititransport" />
                <ScalarProperty Name="interne" ColumnName="interne" />
                <ScalarProperty Name="inscritts" ColumnName="inscritts" />
                <ScalarProperty Name="inscritrs" ColumnName="inscritrs" />
                <ScalarProperty Name="idniveau" ColumnName="idniveau" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="code" ColumnName="code" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etablissementannees">
            <EntityTypeMapping TypeName="educfModel.etablissementannee">
              <MappingFragment StoreEntitySet="etablissementannee">
                <ScalarProperty Name="optrpiconcentre" ColumnName="optrpiconcentre" />
                <ScalarProperty Name="nbcpsmoyenne" ColumnName="nbcpsmoyenne" />
                <ScalarProperty Name="nbcpsdefavorise" ColumnName="nbcpsdefavorise" />
                <ScalarProperty Name="nbcpsfavoriseb" ColumnName="nbcpsfavoriseb" />
                <ScalarProperty Name="nbcpsfavorisea" ColumnName="nbcpsfavorisea" />
                <ScalarProperty Name="dotation" ColumnName="dotation" />
                <ScalarProperty Name="nbupe2a" ColumnName="nbupe2a" />
                <ScalarProperty Name="mailresponsable" ColumnName="mailresponsable" />
                <ScalarProperty Name="mailgestionnaire" ColumnName="mailgestionnaire" />
                <ScalarProperty Name="principaladjoint" ColumnName="principaladjoint" />
                <ScalarProperty Name="nbdima" ColumnName="nbdima" />
                <ScalarProperty Name="nbulis" ColumnName="nbulis" />
                <ScalarProperty Name="nbgene" ColumnName="nbgene" />
                <ScalarProperty Name="nbdivisions" ColumnName="nbdivisions" />
                <ScalarProperty Name="capacitedivisions" ColumnName="capacitedivisions" />
                <ScalarProperty Name="nbsport" ColumnName="nbsport" />
                <ScalarProperty Name="nbcham" ColumnName="nbcham" />
                <ScalarProperty Name="nbupi" ColumnName="nbupi" />
                <ScalarProperty Name="nbtechno" ColumnName="nbtechno" />
                <ScalarProperty Name="nbhandi" ColumnName="nbhandi" />
                <ScalarProperty Name="optrpi" ColumnName="optrpi" />
                <ScalarProperty Name="rpi" ColumnName="rpi" />
                <ScalarProperty Name="nbsegpa" ColumnName="nbsegpa" />
                <ScalarProperty Name="internes" ColumnName="internes" />
                <ScalarProperty Name="capacitesegpa" ColumnName="capacitesegpa" />
                <ScalarProperty Name="ien" ColumnName="ien" />
                <ScalarProperty Name="optrar" ColumnName="optrar" />
                <ScalarProperty Name="capacitearchi" ColumnName="capacitearchi" />
                <ScalarProperty Name="optrep" ColumnName="optrep" />
                <ScalarProperty Name="optzep" ColumnName="optzep" />
                <ScalarProperty Name="nbautrepersonnel" ColumnName="nbautrepersonnel" />
                <ScalarProperty Name="nbadministratifs" ColumnName="nbadministratifs" />
                <ScalarProperty Name="nbenseignants" ColumnName="nbenseignants" />
                <ScalarProperty Name="gestionnaire" ColumnName="gestionnaire" />
                <ScalarProperty Name="responsable" ColumnName="responsable" />
                <ScalarProperty Name="demipensionnaires" ColumnName="demipensionnaires" />
                <ScalarProperty Name="niveauremplissage" ColumnName="niveauremplissage" />
                <ScalarProperty Name="eleveshorssecteur" ColumnName="eleveshorssecteur" />
                <ScalarProperty Name="elevessecteur" ColumnName="elevessecteur" />
                <ScalarProperty Name="classesprevues" ColumnName="classesprevues" />
                <ScalarProperty Name="effectifmaximal" ColumnName="effectifmaximal" />
                <ScalarProperty Name="capaciteeleves" ColumnName="capaciteeleves" />
                <ScalarProperty Name="capacitedemipension" ColumnName="capacitedemipension" />
                <ScalarProperty Name="capaciteinternes" ColumnName="capaciteinternes" />
                <ScalarProperty Name="nbeleves" ColumnName="nbeleves" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
              </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>