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="anneescolaire">
          <Key>
            <PropertyRef Name="nom" />
          </Key>
          <Property Name="nom" Type="numeric" Precision="4" Scale="0" Nullable="false" />
          <Property Name="nbanscalcultap" Type="int4" />
          <Property Name="nbanscalcultap2" Type="int4" />
          <Property Name="datecalcultap" Type="date" />
        </EntityType>
        <EntityType Name="bassin">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="60" />
          <Property Name="idgrandbassin" Type="int4" />
        </EntityType>
        <EntityType Name="canton">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="code" Type="varchar" MaxLength="3" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="responsable1" Type="varchar" MaxLength="100" />
          <Property Name="responsable2" Type="varchar" MaxLength="100" />
        </EntityType>
        <EntityType Name="carte">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="posx" Type="float8" />
          <Property Name="posy" Type="float8" />
          <Property Name="zoom" Type="float8" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.cartecouche' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="cartecouche">
          <Property Name="idcarte" Type="int4" />
          <Property Name="nomcouche" Type="varchar" MaxLength="100" />
        </EntityType>-->
        <EntityType Name="cartescolaire">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="adresseoptbd" Type="numeric" Precision="1" Scale="0" />
          <Property Name="adressenomcouche" Type="varchar" MaxLength="30" />
          <Property Name="adressenomchamp" Type="varchar" MaxLength="30" />
          <Property Name="adressenomchampprim" Type="varchar" MaxLength="30" />
          <Property Name="voieoptbd" Type="numeric" Precision="1" Scale="0" />
          <Property Name="voienomcouche" Type="varchar" MaxLength="30" />
          <Property Name="voienomchamp" Type="varchar" MaxLength="30" />
          <Property Name="voienomchampprim" Type="varchar" MaxLength="30" />
          <Property Name="etablissementoptbd" Type="numeric" Precision="1" Scale="0" />
          <Property Name="etablissementnomcouche" Type="varchar" MaxLength="30" />
          <Property Name="etablissementnomchamp" Type="varchar" MaxLength="30" />
          <Property Name="etablissementnomchampprim" Type="varchar" MaxLength="30" />
          <Property Name="ecoleoptbd" Type="numeric" Precision="1" Scale="0" />
          <Property Name="ecolenomcouche" Type="varchar" MaxLength="30" />
          <Property Name="ecolenomchamp1" Type="varchar" MaxLength="30" />
          <Property Name="ecolenomchampratio1" Type="varchar" MaxLength="30" />
          <Property Name="ecolenomchamp2" Type="varchar" MaxLength="30" />
          <Property Name="ecolenomchampratio2" Type="varchar" MaxLength="30" />
          <Property Name="datederniercalcul" Type="timestamp" />
          <Property Name="adressenomchampdistance" Type="varchar" MaxLength="30" />
          <Property Name="adressenomchampdistanceprim" Type="varchar" MaxLength="30" />
          <Property Name="parcellenomchampdistance" Type="varchar" MaxLength="30" />
          <Property Name="parcellenomchampdistanceprim" Type="varchar" MaxLength="30" />
          <Property Name="parcellenomchamp" Type="varchar" MaxLength="30" />
          <Property Name="parcellenomchampprim" Type="varchar" MaxLength="30" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.cartescolaireecole' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="cartescolaireecole">
          <Property Name="idetab" Type="numeric" Precision="5" Scale="0" />
          <Property Name="idetabsecteur" Type="numeric" Precision="5" Scale="0" />
          <Property Name="idcartescolaire" Type="numeric" Precision="5" Scale="0" />
          <Property Name="idetabsecteur2" Type="numeric" Precision="10" Scale="0" />
          <Property Name="etabsecteurratio" Type="numeric" Precision="10" Scale="2" />
          <Property Name="etabsecteur2ratio" Type="numeric" Precision="10" Scale="2" />
        </EntityType>-->
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.choiximport' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="choiximport">
          <Property Name="typeimport" Type="numeric" Precision="2" Scale="0" />
          <Property Name="colimport" Type="numeric" Precision="2" Scale="0" />
          <Property Name="choix" Type="numeric" Precision="2" Scale="0" />
        </EntityType>-->
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.classement' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="classement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="40" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.classeniveau' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="classeniveau">
          <Key>
            <PropertyRef Name="idclasse" />
          </Key>
          <Property Name="idclasse" Type="numeric" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idniveau" Type="numeric" Precision="10" Scale="0" />
        </EntityType>
        <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>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.commune_ok' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="commune_ok">
          <Key>
            <PropertyRef Name="idcommuneok" />
            <PropertyRef Name="nom" />
          </Key>
          <Property Name="idcommuneok" Type="numeric" Precision="10" Scale="0" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="100" Nullable="false" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.communeannee' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="communeannee">
          <Key>
            <PropertyRef Name="idcommune" />
            <PropertyRef Name="annee" />
          </Key>
          <Property Name="idcommune" Type="float8" Nullable="false" />
          <Property Name="annee" Type="float8" Nullable="false" />
          <Property Name="prevcreationetab" Type="float8" />
          <Property Name="prevsuppressionetab" Type="float8" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.communeeffectifannee' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="communeeffectifannee">
          <Property Name="idcommune" Type="numeric" Precision="10" Scale="0" />
          <Property Name="effectif" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idniveau" Type="numeric" Precision="10" Scale="0" />
          <Property Name="annee" Type="numeric" Precision="4" Scale="0" />
          <Property Name="idcartescolaire" Type="int4" />
          <Property Name="effectifprive" Type="numeric" Precision="6" Scale="0" />
          <Property Name="effectifpublic" Type="numeric" Precision="6" Scale="0" />
        </EntityType>-->
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.communehabitants' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="communehabitants">
          <Key>
            <PropertyRef Name="idcommune" />
          </Key>
          <Property Name="idcommune" Type="numeric" Precision="5" Scale="0" Nullable="false" />
          <Property Name="annee" Type="numeric" Precision="4" Scale="0" />
          <Property Name="habitants" Type="numeric" Precision="7" Scale="0" />
          <Property Name="naissances" Type="numeric" Precision="6" Scale="0" />
        </EntityType>
        <EntityType Name="communeurbanisationannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idcommune" Type="float8" />
          <Property Name="annee" Type="float8" />
          <Property Name="nomprogramme" Type="varchar" MaxLength="50" />
          <Property Name="nature" Type="varchar" MaxLength="50" />
          <Property Name="adresse" Type="varchar" MaxLength="200" />
          <Property Name="debut" Type="varchar" MaxLength="20" />
          <Property Name="fin" Type="varchar" MaxLength="20" />
          <Property Name="budgetprevu" Type="varchar" MaxLength="50" />
          <Property Name="budgetreel" Type="varchar" MaxLength="50" />
          <Property Name="motifecart" Type="varchar" MaxLength="50" />
          <Property Name="subvention" Type="varchar" MaxLength="50" />
          <Property Name="typelogements" Type="varchar" MaxLength="50" />
          <Property Name="anneedebut" Type="numeric" Precision="4" Scale="0" />
          <Property Name="numadresse" Type="varchar" MaxLength="20" />
          <Property Name="idrue" Type="numeric" Precision="12" Scale="0" />
          <Property Name="dateimport" Type="timestamp" />
          <Property Name="datemodif" Type="timestamp" />
          <Property Name="nblogements" Type="numeric" Precision="5" Scale="0" />
          <Property Name="nbeleves" Type="numeric" Precision="5" Scale="0" />
          <Property Name="nblogementsrenouv" Type="numeric" Precision="5" Scale="0" />
          <Property Name="idtypelogement" Type="numeric" Precision="10" Scale="0" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.communeurbanisationeffectif' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="communeurbanisationeffectif">
          <Property Name="idurbanisation" Type="float8" />
          <Property Name="idniveau" Type="float8" />
          <Property Name="effectif" Type="float8" />
        </EntityType>-->
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.communeurbanisationparcelle' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="communeurbanisationparcelle">
          <Key>
            <PropertyRef Name="idurbanisation" />
          </Key>
          <Property Name="idurbanisation" Type="numeric" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idparcelle" Type="numeric" Precision="10" Scale="0" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.config' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="config">
          <Property Name="version" Type="varchar" MaxLength="20" />
          <Property Name="departement" Type="varchar" MaxLength="3" />
          <Property Name="idcartescolaire" Type="numeric" Precision="4" Scale="0" />
          <Property Name="module_sig" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optprimaire" Type="numeric" Precision="1" Scale="0" />
          <Property Name="baremetosrestauration" Type="numeric" Precision="6" Scale="3" />
          <Property Name="baremetosaccueil" Type="numeric" Precision="6" Scale="3" />
          <Property Name="baremetosentretien" Type="numeric" Precision="6" Scale="3" />
          <Property Name="optcommunal" Type="numeric" Precision="1" Scale="0" />
          <Property Name="coefurbanisation" Type="float8" />
          <Property Name="coefurbanisationmaternelle" Type="float8" />
          <Property Name="opturbanisationglobale" Type="float8" />
          <Property Name="tapnaissance1" Type="float8" />
          <Property Name="tapnaissance2" Type="float8" />
          <Property Name="idcommunedefaut" Type="numeric" Precision="10" Scale="0" />
          <Property Name="opteffectifsparcommune" Type="float8" />
          <Property Name="optaffnomprenom" Type="float8" />
          <Property Name="prefixe" Type="varchar" MaxLength="50" />
          <Property Name="base" Type="varchar" MaxLength="30" />
        </EntityType>-->
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.config_style' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="config_style">
          <Property Name="symbolbitmapname" Type="varchar" MaxLength="100" />
          <Property Name="symbolbitmapsize" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolsize" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolbitmaptransparent" Type="numeric" Precision="2" Scale="0" />
          <Property Name="symbolcharacter" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbol" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symboltype" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolcolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolfont" Type="varchar" MaxLength="100" />
          <Property Name="symbolangle" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolhalo" Type="numeric" Precision="2" Scale="0" />
          <Property Name="symbolbox" Type="numeric" Precision="2" Scale="0" />
          <Property Name="symbolbkgcolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolshadow" Type="numeric" Precision="2" Scale="0" />
          <Property Name="symbolitalic" Type="numeric" Precision="2" Scale="0" />
          <Property Name="symbolbold" Type="numeric" Precision="2" Scale="0" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="linestyle" Type="numeric" Precision="10" Scale="0" />
          <Property Name="linecolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="lineunit" Type="numeric" Precision="10" Scale="0" />
          <Property Name="linewidth" Type="numeric" Precision="10" Scale="0" />
          <Property Name="lineinterleaved" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionbackcolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionbordercolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionborderstyle" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionborderwidth" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionborderwidthunit" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regioncolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionpattern" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regiontransparent" Type="numeric" Precision="10" Scale="0" />
        </EntityType>-->
        <EntityType Name="couleur">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="code" Type="int4" />
          <Property Name="r" Type="int4" />
          <Property Name="v" Type="int4" />
          <Property Name="b" Type="int4" />
          <Property Name="nom" Type="varchar" MaxLength="60" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.csp' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="csp">
          <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="10" />
          <Property Name="favorise" Type="varchar" MaxLength="50" />
          <Property Name="qf" Type="numeric" Precision="10" Scale="0" />
        </EntityType>
        <EntityType Name="eleve">
          <Key>
            <PropertyRef Name="code" />
          </Key>
          <Property Name="code" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="numadresse" Type="varchar" MaxLength="20" />
          <Property Name="idrue" Type="float8" />
          <Property Name="adresse2" Type="varchar" MaxLength="250" />
          <Property Name="idcsp" Type="float8" />
          <Property Name="datenaissance" Type="timestamp" />
          <Property Name="nom" Type="varchar" MaxLength="50" />
          <Property Name="prenom" Type="varchar" MaxLength="50" />
          <Property Name="sexe" Type="numeric" Precision="1" Scale="0" />
          <Property Name="nationalite" Type="numeric" Precision="3" Scale="0" />
          <Property Name="ilotinsee" Type="varchar" MaxLength="9" />
          <Property Name="posx" Type="float8" />
          <Property Name="posy" Type="float8" />
          <Property Name="idfamille" 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="elevecartescolaire">
          <Key>
            <PropertyRef Name="id_elevecs" />
          </Key>
          <Property Name="code" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="idcartescolaire" Type="int4" />
          <Property Name="idetabsecteur" Type="numeric" Precision="5" Scale="0" />
          <Property Name="idetabsecteursuiv" Type="numeric" Precision="5" Scale="0" />
          <Property Name="id_elevecs" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idetabsecteurprec" Type="int4" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.etab_ok' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="etab_ok">
          <Key>
            <PropertyRef Name="idetabok" />
            <PropertyRef Name="nom" />
          </Key>
          <Property Name="idetabok" Type="numeric" Precision="10" Scale="0" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="150" Nullable="false" />
        </EntityType>
        <EntityType Name="etabcartescolaire">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idetablissement" Type="int4" Nullable="false" />
          <Property Name="idrue" Type="float8" />
          <Property Name="debut" Type="varchar" MaxLength="50" />
          <Property Name="fin" Type="varchar" MaxLength="50" />
          <Property Name="pairimpair" Type="float8" />
          <Property Name="proximite" Type="varchar" MaxLength="50" />
          <Property Name="accessibilite" Type="varchar" MaxLength="50" />
          <Property Name="idcartescolaire" Type="numeric" Precision="4" Scale="0" />
        </EntityType>
        <EntityType Name="etabcartescolairecommune">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idetablissement" Type="int4" Nullable="false" />
          <Property Name="idcommune" Type="float8" />
          <Property Name="idcartescolaire" Type="numeric" Precision="4" Scale="0" />
        </EntityType>
        <EntityType Name="etabclasseannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idsousgroupe" Type="numeric" Precision="10" Scale="0" />
          <Property Name="nom" Type="varchar" MaxLength="30" />
          <Property Name="effectif" 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="etabequipementannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idetablissement" Type="int4" />
          <Property Name="annee" Type="float8" />
          <Property Name="nom" Type="varchar" MaxLength="250" />
          <Property Name="capacite" Type="float8" />
          <Property Name="superficie" Type="float8" />
          <Property Name="nbsalles" Type="float8" />
          <Property Name="gardien" Type="varchar" MaxLength="70" />
          <Property Name="contact" Type="varchar" MaxLength="100" />
          <Property Name="vestiaire" Type="varchar" MaxLength="100" />
        </EntityType>
        <EntityType Name="etabequipementprocheannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="int4" />
          <Property Name="annee" Type="float8" />
          <Property Name="nom" Type="varchar" MaxLength="250" />
          <Property Name="capacite" Type="float8" />
          <Property Name="superficie" Type="float8" />
          <Property Name="nbsalles" Type="float8" />
          <Property Name="gardien" Type="varchar" MaxLength="70" />
          <Property Name="contact" Type="varchar" MaxLength="100" />
          <Property Name="vestiaire" Type="varchar" MaxLength="100" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
        </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="etablissementregie">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idetablissement" Type="int4" />
          <Property Name="idregie" Type="int4" />
          <Property Name="ratio" Type="float8" />
          <Property Name="annee" Type="int4" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.etablissementstyle' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="etablissementstyle">
          <Property Name="linestyle" Type="numeric" Precision="10" Scale="0" />
          <Property Name="linecolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="lineunit" Type="numeric" Precision="10" Scale="0" />
          <Property Name="linewidth" Type="numeric" Precision="10" Scale="0" />
          <Property Name="lineinterleaved" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionbackcolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionbordercolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionborderstyle" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionborderwidth" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionborderwidthunit" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regioncolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionpattern" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regiontransparent" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idetablissement" Type="numeric" Precision="10" Scale="0" />
        </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="etabsallesannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="int4" />
          <Property Name="annee" Type="float8" />
          <Property Name="nbsalles" Type="float8" />
          <Property Name="idtypesalle" Type="float8" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="surface" Type="numeric" Precision="5" Scale="0" />
        </EntityType>
        <EntityType Name="etabsegpa">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="int4" />
          <Property Name="idsegpa" Type="numeric" Precision="5" Scale="0" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
        </EntityType>
        <EntityType Name="etabsousgroupeannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idetablissement" Type="int4" />
          <Property Name="nom" Type="varchar" MaxLength="30" />
          <Property Name="annee" Type="int4" />
        </EntityType>
        <EntityType Name="etabtosannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="int4" />
          <Property Name="annee" Type="float8" />
          <Property Name="nom" Type="varchar" MaxLength="200" />
          <Property Name="mission1" Type="varchar" MaxLength="100" />
          <Property Name="quotite" Type="float8" />
          <Property Name="duree1" Type="varchar" MaxLength="50" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="mission2" Type="varchar" MaxLength="100" />
          <Property Name="duree2" Type="varchar" MaxLength="50" />
          <Property Name="mission3" Type="varchar" MaxLength="100" />
          <Property Name="duree3" Type="varchar" MaxLength="50" />
        </EntityType>
        <EntityType Name="etabtravauxannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="int4" />
          <Property Name="annee" Type="int4" />
          <Property Name="nature" Type="varchar" MaxLength="200" />
          <Property Name="previsibilite" Type="varchar" MaxLength="20" />
          <Property Name="motifurgence" Type="varchar" MaxLength="50" />
          <Property Name="debut" Type="varchar" MaxLength="20" />
          <Property Name="fin" Type="varchar" MaxLength="20" />
          <Property Name="budgetprevu" Type="varchar" MaxLength="50" />
          <Property Name="budgetreel" Type="varchar" MaxLength="50" />
          <Property Name="motifecart" Type="varchar" MaxLength="50" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.etabulis' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="etabulis">
          <Property Name="idetablissement" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idulis" Type="numeric" Precision="10" Scale="0" />
        </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="grandbassin">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="60" />
        </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="mission">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="nom" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
        </EntityType>
        <EntityType Name="nationalite">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="code" Type="numeric" Precision="3" Scale="0" />
          <Property Name="libelle" Type="varchar" MaxLength="100" />
        </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>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.parcelle' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="parcelle">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="10" />
          <Property Name="numadresse" Type="varchar" MaxLength="10" />
          <Property Name="idrue" Type="numeric" Precision="10" Scale="0" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.plan' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="plan">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="nom" Type="varchar" MaxLength="255" />
          <Property Name="chemincomplet" Type="varchar" MaxLength="250" />
          <Property Name="zoommin" Type="numeric" Precision="10" Scale="0" />
          <Property Name="zoommax" Type="numeric" Precision="10" Scale="0" />
          <Property Name="format" Type="varchar" MaxLength="50" />
          <Property Name="ordre" Type="numeric" Precision="5" Scale="0" />
          <Property Name="etiquette" Type="numeric" Precision="5" Scale="0" />
          <Property Name="tailleetiquette" Type="numeric" Precision="10" Scale="0" />
          <Property Name="champetiquette" Type="varchar" MaxLength="50" />
          <Property Name="symbol" Type="varchar" MaxLength="50" />
          <Property Name="symbolfont" Type="varchar" MaxLength="50" />
          <Property Name="symbolsize" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolcolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolangle" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolhalo" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolbox" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolbkgcolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolshadow" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolitalic" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolbold" Type="numeric" Precision="10" Scale="0" />
          <Property Name="linestyle" Type="numeric" Precision="10" Scale="0" />
          <Property Name="linecolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="lineunit" Type="numeric" Precision="10" Scale="0" />
          <Property Name="linewidth" Type="numeric" Precision="10" Scale="0" />
          <Property Name="lineinterleaved" Type="numeric" Precision="1" Scale="0" />
          <Property Name="regionbackcolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionbordercolor" Type="varchar" MaxLength="50" />
          <Property Name="regionborderstyle" Type="varchar" MaxLength="50" />
          <Property Name="regionborderwidth" Type="varchar" MaxLength="50" />
          <Property Name="regionborderwidthunit" Type="varchar" MaxLength="50" />
          <Property Name="regioncolor" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regionpattern" Type="numeric" Precision="10" Scale="0" />
          <Property Name="regiontransparent" Type="numeric" Precision="1" Scale="0" />
          <Property Name="sansrepgraphique" Type="numeric" Precision="1" Scale="0" />
          <Property Name="visible" Type="numeric" Precision="1" Scale="0" />
          <Property Name="policeetiquette" Type="varchar" MaxLength="255" />
          <Property Name="couleuretiquette" Type="numeric" Precision="10" Scale="0" />
          <Property Name="typereprgraphique" Type="numeric" Precision="10" Scale="0" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nomalias" Type="varchar" MaxLength="100" />
          <Property Name="symbolbitmapname" Type="varchar" MaxLength="100" />
          <Property Name="symbolbitmapsize" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symbolbitmaptransparent" Type="numeric" Precision="2" Scale="0" />
          <Property Name="symbolcharacter" Type="numeric" Precision="10" Scale="0" />
          <Property Name="symboltype" Type="numeric" Precision="10" Scale="0" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.plan_gestion' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="plan_gestion">
          <Property Name="geocodif" Type="numeric" Precision="1" Scale="0" />
          <Property Name="repplan" Type="varchar" MaxLength="200" />
          <Property Name="nomlyrcollege" Type="varchar" MaxLength="50" />
          <Property Name="nomchampcollege" Type="varchar" MaxLength="50" />
          <Property Name="nomlyrrue" Type="varchar" MaxLength="50" />
          <Property Name="nomchamprue" Type="varchar" MaxLength="50" />
          <Property Name="nomlyrnumerorue" Type="varchar" MaxLength="50" />
          <Property Name="nomchampnumerorue" Type="varchar" MaxLength="50" />
          <Property Name="nomlyrcommune" Type="varchar" MaxLength="50" />
          <Property Name="nomchampcommune" Type="varchar" MaxLength="150" />
          <Property Name="nomchamprivolirue" Type="varchar" MaxLength="50" />
          <Property Name="nomchampsecteur" Type="varchar" MaxLength="50" />
          <Property Name="nomlyrsecteur" Type="varchar" MaxLength="50" />
          <Property Name="nomchampecole" Type="varchar" MaxLength="50" />
          <Property Name="nomlyrecole" Type="varchar" MaxLength="50" />
          <Property Name="nomchampadresse_rivoli" Type="varchar" MaxLength="50" />
          <Property Name="nomchampadresseinsee" Type="varchar" MaxLength="50" />
          <Property Name="nomchampadresserivoli" Type="varchar" MaxLength="50" />
          <Property Name="nomchampadressenomrue" Type="varchar" MaxLength="50" />
          <Property Name="tailleeleve" Type="float8" />
          <Property Name="tailleurbanisation" Type="float8" />
          <Property Name="nomchampadresseparcelle" Type="varchar" MaxLength="50" />
          <Property Name="optoraclespatial" Type="float8" />
          <Property Name="nomchampnumerofin" Type="varchar" MaxLength="50" />
          <Property Name="nomchampparite" Type="varchar" MaxLength="50" />
          <Property Name="optthemcouches" Type="numeric" Precision="1" Scale="0" />
          <Property Name="nomchampadresseetabsecteur" Type="varchar" MaxLength="50" />
          <Property Name="nomchampadresseetabsecteurmat" Type="varchar" MaxLength="50" />
          <Property Name="nomlyrcommunecollege" Type="varchar" MaxLength="50" />
          <Property Name="nomchampcommunecollegeinsee" Type="varchar" MaxLength="50" />
          <Property Name="nomchampcommunecollegerne" Type="varchar" MaxLength="50" />
          <Property Name="plansituation" Type="varchar" MaxLength="200" />
          <Property Name="nomchamprueinsee" Type="varchar" MaxLength="50" />
          <Property Name="nomchampruenumero" Type="varchar" MaxLength="50" />
          <Property Name="nomchampruenumerofin" Type="varchar" MaxLength="50" />
          <Property Name="nomchampruenomrue" Type="varchar" MaxLength="50" />
          <Property Name="nomchamprueetab" Type="varchar" MaxLength="50" />
          <Property Name="nomchamprueetabmat" Type="varchar" MaxLength="50" />
          <Property Name="nomchamprueinsee2" Type="varchar" MaxLength="50" />
          <Property Name="nomchampruenumero2" Type="varchar" MaxLength="50" />
          <Property Name="nomchampruenumerofin2" Type="varchar" MaxLength="50" />
          <Property Name="nomchampruenomrue2" Type="varchar" MaxLength="50" />
          <Property Name="nomlyrparcelle" Type="varchar" MaxLength="50" />
          <Property Name="nomchampparcelleinsee" Type="varchar" MaxLength="50" />
          <Property Name="nomchampparcellenumero" Type="varchar" MaxLength="50" />
          <Property Name="nomchampparcellenumerofin" Type="varchar" MaxLength="50" />
          <Property Name="nomchampparcellerivoli" Type="varchar" MaxLength="50" />
          <Property Name="nomchampparcellenomrue" Type="varchar" MaxLength="50" />
          <Property Name="nomchampparcelleident" Type="varchar" MaxLength="50" />
          <Property Name="nomchamprue_rivoli2" Type="varchar" MaxLength="50" />
        </EntityType>-->
        <EntityType Name="previsibilite">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="40" />
        </EntityType>
        <EntityType Name="regierestauration">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idrue" Type="numeric" Precision="10" Scale="0" />
          <Property Name="numadresse" Type="varchar" MaxLength="20" />
          <Property Name="code" Type="varchar" MaxLength="20" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="capacite" Type="int4" />
        </EntityType>
        <EntityType Name="rpi">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="60" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.rue_ok' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="rue_ok">
          <Key>
            <PropertyRef Name="idrueok" />
          </Key>
          <Property Name="idrueok" Type="float8" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="commune" Type="varchar" MaxLength="200" />
        </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>
        <EntityType Name="ruescomplement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idrue" Type="int4" />
          <Property Name="complement" Type="varchar" MaxLength="100" />
        </EntityType>
        <EntityType Name="segpa">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="200" />
        </EntityType>
        <EntityType Name="simulationannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="annee" Type="float8" />
          <Property Name="nom" Type="varchar" MaxLength="200" />
          <Property Name="monteepedagogique" Type="float8" />
          <Property Name="tap" Type="float8" />
          <Property Name="ratios" Type="float8" />
          <Property Name="evitement" Type="float8" />
          <Property Name="idcartescolaire" Type="int4" />
          <Property Name="tapsec" Type="float8" />
          <Property Name="datecalcul" Type="timestamp" />
          <Property Name="apportprogressif" Type="numeric" Precision="1" Scale="0" />
          <Property Name="idcartescolaire2" Type="numeric" Precision="5" Scale="0" />
          <Property Name="anneecartescolaire2" Type="numeric" Precision="4" Scale="0" />
          <Property Name="optcartescolaire2" Type="numeric" Precision="2" Scale="0" />
          <Property Name="optapportglobal" Type="numeric" Precision="2" Scale="0" />
          <Property Name="optprevisionficheetab" Type="numeric" Precision="2" Scale="0" />
          <Property Name="opttapdepartemental" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optmonteeadresse" Type="int4" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.simulationetabcrees' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="simulationetabcrees">
          <Key>
            <PropertyRef Name="idsimulation" />
          </Key>
          <Property Name="idsimulation" Type="numeric" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idetablissement" Type="numeric" Precision="10" Scale="0" />
          <Property Name="annee" Type="numeric" Precision="4" Scale="0" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.simulationetabsupprimes' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="simulationetabsupprimes">
          <Key>
            <PropertyRef Name="idsimulation" />
          </Key>
          <Property Name="idsimulation" Type="numeric" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idetablissement" Type="numeric" Precision="10" Scale="0" />
          <Property Name="annee" Type="numeric" Precision="4" Scale="0" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.simulationniveauxreaffectes' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="simulationniveauxreaffectes">
          <Property Name="idsimulation" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idetablissement" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idniveau" Type="numeric" Precision="10" Scale="0" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" />
          <Property Name="idetablissementsortie" Type="numeric" Precision="10" Scale="0" />
          <Property Name="annee" Type="numeric" Precision="5" Scale="0" />
        </EntityType>-->
        <EntityType Name="simulationresultats">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idsimulation" Type="int4" />
          <Property Name="idetablissement" Type="int4" />
          <Property Name="idniveau" Type="float8" />
          <Property Name="effectif" Type="float8" />
          <Property Name="annee" Type="float8" />
          <Property Name="effectifurba" Type="float8" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
        </EntityType>
        <EntityType Name="simulationresurbanisation">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idsimulation" Type="int4" Nullable="false" />
          <Property Name="idetablissement" Type="int4" />
          <Property Name="effectif" Type="float4" />
          <Property Name="annee" Type="numeric" Precision="4" Scale="0" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6013: Aucune clé primaire n'est définie pour la table/vue 'educf.educf.tapniveau' ; en outre, aucune clé primaire valide n'a pu être déduite. Cette table/vue a été exclue. Pour utiliser l'entité, vous devez passer en revue votre schéma, ajouter les clés appropriées et supprimer le commentaire associé.
        <EntityType Name="tapniveau">
          <Property Name="idniveau" Type="numeric" Precision="5" Scale="0" />
          <Property Name="tap" Type="float8" />
          <Property Name="annee" Type="numeric" Precision="4" Scale="0" />
        </EntityType>-->
        <EntityType Name="thematique">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="200" />
          <Property Name="couleur" Type="varchar" MaxLength="50" />
          <Property Name="valeurmin" Type="numeric" Precision="10" Scale="2" />
          <Property Name="valeurmax" Type="numeric" Precision="10" Scale="2" />
        </EntityType>
        <EntityType Name="thematiques">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="couche" Type="varchar" MaxLength="100" />
        </EntityType>
        <EntityType Name="thematiquescommunes">
          <Key>
            <PropertyRef Name="insee" />
          </Key>
          <Property Name="insee" Type="varchar" MaxLength="5" Nullable="false" />
          <Property Name="nbelpublic" Type="float4" />
          <Property Name="nbelprive" Type="float4" />
          <Property Name="nbnaissances" Type="float4" />
          <Property Name="nbelprimaire" Type="float4" />
          <Property Name="nblogementsan1" Type="float4" />
          <Property Name="nblogementsan2" Type="float4" />
          <Property Name="nblogementsan3" Type="float4" />
          <Property Name="nblogementsan4" Type="float4" />
          <Property Name="nblogementsan5" Type="float4" />
          <Property Name="rneetabsecteur" Type="varchar" MaxLength="20" />
          <Property Name="anneereel" Type="float4" />
          <Property Name="anneesimu" Type="float4" />
          <Property Name="nbelpublicsimu" Type="float4" />
          <Property Name="nbelprivesimu" Type="float4" />
          <Property Name="superficie" Type="float4" />
          <Property Name="densitecollegiens" Type="float4" />
          <Property Name="nbhabitants" Type="float4" />
          <Property Name="densitepop" Type="float4" />
          <Property Name="nongeolocalises" Type="float4" />
          <Property Name="nongeolocalisesprive" Type="float4" />
          <Property Name="rpi" Type="varchar" MaxLength="50" />
          <Property Name="effreel2007" Type="float4" />
          <Property Name="effreel2008" Type="float4" />
          <Property Name="effreel2009" Type="float4" />
          <Property Name="effreel2010" Type="float4" />
          <Property Name="effreel2011" Type="float4" />
          <Property Name="effreel2012" Type="float4" />
          <Property Name="effreel2013" Type="float4" />
          <Property Name="excedentreel2007" Type="float8" />
          <Property Name="excedentreel2008" Type="float8" />
          <Property Name="excedentreel2009" Type="float8" />
          <Property Name="excedentreel2010" Type="float8" />
          <Property Name="excedentreel2011" Type="float8" />
          <Property Name="excedentreel2012" Type="float8" />
          <Property Name="excedentreel2013" Type="float8" />
          <Property Name="effreel2014" Type="float8" />
          <Property Name="excedentreel2014" Type="float8" />
          <Property Name="effreel2015" Type="float8" />
          <Property Name="excedentreel2015" Type="float8" />
          <Property Name="effreel2016" Type="float8" />
          <Property Name="excedentreel2016" Type="float8" />
          <Property Name="effreel2017" Type="float8" />
          <Property Name="excedentreel2017" Type="float8" />
        </EntityType>
        <EntityType Name="thematiqueseleves">
          <Key>
            <PropertyRef Name="oid" />
          </Key>
          <Property Name="numnominsee" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="nbelpublic" Type="int4" />
          <Property Name="nbelprive" Type="int4" />
          <Property Name="nbnaissances" Type="int4" />
          <Property Name="nbelprimaire" Type="int4" />
          <Property Name="nblogementsan1" Type="int4" />
          <Property Name="nblogementsan2" Type="int4" />
          <Property Name="nblogementsan3" Type="int4" />
          <Property Name="nblogementsan4" Type="int4" />
          <Property Name="nblogementsan5" Type="int4" />
          <Property Name="nbcpsfavorisea" Type="int4" />
          <Property Name="nbcpsfavoriseb" Type="int4" />
          <Property Name="nbcpsdefavorise" Type="int4" />
          <Property Name="nbcpsmoyenne" Type="int4" />
          <Property Name="rne" Type="varchar" MaxLength="20" />
          <Property Name="nblogementstotal" Type="int4" />
          <Property Name="rne1" Type="varchar" MaxLength="20" />
          <Property Name="rne2" Type="varchar" MaxLength="20" />
          <Property Name="rne3" Type="varchar" MaxLength="20" />
          <Property Name="rne4" Type="varchar" MaxLength="20" />
          <Property Name="rne5" Type="varchar" MaxLength="20" />
          <Property Name="rne6" Type="varchar" MaxLength="20" />
          <Property Name="effectif1" Type="int4" />
          <Property Name="effectif2" Type="int4" />
          <Property Name="effectif3" Type="int4" />
          <Property Name="effectif4" Type="int4" />
          <Property Name="effectif5" Type="int4" />
          <Property Name="effectif6" Type="int4" />
          <Property Name="ellogan1" Type="int4" />
          <Property Name="matlogan1" Type="int4" />
          <Property Name="ellogan2" Type="int4" />
          <Property Name="matlogan2" Type="int4" />
          <Property Name="ellogan3" Type="int4" />
          <Property Name="matlogan3" Type="int4" />
          <Property Name="ellogan4" Type="int4" />
          <Property Name="matlogan4" Type="int4" />
          <Property Name="ellogan5" Type="int4" />
          <Property Name="matlogan5" Type="int4" />
          <Property Name="ellogtotal" Type="int4" />
          <Property Name="matlogtotal" Type="int4" />
          <Property Name="oid" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nbelpublicapprox" Type="numeric" Precision="5" Scale="0" />
          <Property Name="nbelpriveapprox" Type="numeric" Precision="5" Scale="0" />
          <Property Name="numadresse" Type="varchar" MaxLength="20" />
          <Property Name="idrue" Type="int4" />
          <Property Name="totalpublic" Type="int4" />
          <Property Name="totalprive" Type="int4" />
          <Property Name="totalsecteur" Type="int4" />
          <Property Name="totalhorssecteur" Type="int4" />
          <Property Name="matnbelpublic" Type="int4" />
          <Property Name="matnbelprive" Type="int4" />
          <Property Name="matnbelpublicapprox" Type="int4" />
          <Property Name="matnbelpriveapprox" Type="int4" />
          <Property Name="mattotalpublic" Type="int4" />
          <Property Name="mattotalprive" Type="int4" />
          <Property Name="mattotalsecteur" Type="int4" />
          <Property Name="mattotalhorssecteur" Type="int4" />
          <Property Name="matrne1" Type="varchar" MaxLength="20" />
          <Property Name="matrne2" Type="varchar" MaxLength="20" />
          <Property Name="matrne3" Type="varchar" MaxLength="20" />
          <Property Name="matrne4" Type="varchar" MaxLength="20" />
          <Property Name="matrne5" Type="varchar" MaxLength="20" />
          <Property Name="matrne6" Type="varchar" MaxLength="20" />
          <Property Name="mateffectif1" Type="int4" />
          <Property Name="mateffectif2" Type="int4" />
          <Property Name="mateffectif3" Type="int4" />
          <Property Name="mateffectif4" Type="int4" />
          <Property Name="mateffectif5" Type="int4" />
          <Property Name="mateffectif6" Type="int4" />
          <Property Name="dist" Type="float8" />
        </EntityType>
        <EntityType Name="thematiquesetab">
          <Key>
            <PropertyRef Name="idetablissement" />
          </Key>
          <Property Name="idetablissement" Type="int4" Nullable="false" />
          <Property Name="anneereel" Type="float4" />
          <Property Name="anneesimu" Type="float4" />
          <Property Name="effectifreel" Type="float4" />
          <Property Name="effectifdpreel" Type="float4" />
          <Property Name="nblogementsan1" Type="float4" />
          <Property Name="nblogementsan2" Type="float4" />
          <Property Name="nblogementsan3" Type="float4" />
          <Property Name="nblogementsan4" Type="float4" />
          <Property Name="nblogementsan5" Type="float4" />
          <Property Name="effectifsimu" Type="float4" />
          <Property Name="capacite" Type="float4" />
          <Property Name="capacitedp" Type="float4" />
          <Property Name="nbderog" Type="float4" />
          <Property Name="nbcpsfavorisea" Type="float4" />
          <Property Name="nbcpsfavoriseb" Type="float4" />
          <Property Name="nbcpsdefavorise" Type="float4" />
          <Property Name="nbcpsmoyenne" Type="float4" />
          <Property Name="zep" Type="numeric" Precision="1" Scale="0" />
          <Property Name="handicap" Type="int4" />
          <Property Name="prive" Type="numeric" Precision="1" Scale="0" />
          <Property Name="rne" Type="varchar" MaxLength="20" />
          <Property Name="txremplireel" Type="float4" />
          <Property Name="txremplisimu" Type="float4" />
          <Property Name="txremplidpreel" Type="float4" />
          <Property Name="effectifsegpa" Type="float4" />
          <Property Name="capacitesegpa" Type="float4" />
          <Property Name="txremplisegpa" Type="float4" />
          <Property Name="nblogementstotal" Type="float4" />
          <Property Name="nomregierestauration" Type="varchar" MaxLength="100" />
          <Property Name="rne1" Type="varchar" MaxLength="20" />
          <Property Name="ratio1" Type="numeric" Precision="3" Scale="0" />
          <Property Name="rne2" Type="varchar" MaxLength="20" />
          <Property Name="ratio2" Type="numeric" Precision="3" Scale="0" />
          <Property Name="rne1h1" Type="varchar" MaxLength="20" />
          <Property Name="ratio1h1" Type="numeric" Precision="3" Scale="0" />
          <Property Name="rne2h1" Type="varchar" MaxLength="20" />
          <Property Name="ratio2h1" Type="numeric" Precision="3" Scale="0" />
          <Property Name="effreel2006" Type="float4" />
          <Property Name="excedentreel2006" Type="float4" />
          <Property Name="effreel2007" Type="float4" />
          <Property Name="excedentreel2007" Type="float4" />
          <Property Name="effreel2008" Type="float4" />
          <Property Name="excedentreel2008" Type="float4" />
          <Property Name="effreel2009" Type="float4" />
          <Property Name="excedentreel2009" Type="float4" />
          <Property Name="effreel2010" Type="float4" />
          <Property Name="excedentreel2010" Type="float4" />
          <Property Name="effreel2011" Type="float4" />
          <Property Name="excedentreel2011" Type="float4" />
          <Property Name="effreel2012" Type="float4" />
          <Property Name="excedentreel2012" Type="float4" />
          <Property Name="effreel2013" Type="float4" />
          <Property Name="excedentreel2013" Type="float4" />
          <Property Name="effsimu2013" Type="float8" />
          <Property Name="excedentsimu2013" Type="float8" />
          <Property Name="effsimu2014" Type="float8" />
          <Property Name="excedentsimu2014" Type="float8" />
          <Property Name="effsimu2015" Type="float8" />
          <Property Name="excedentsimu2015" Type="float8" />
          <Property Name="effsimu2016" Type="float8" />
          <Property Name="excedentsimu2016" Type="float8" />
          <Property Name="effsimu2017" Type="float8" />
          <Property Name="excedentsimu2017" Type="float8" />
          <Property Name="effsimu2018" Type="float8" />
          <Property Name="excedentsimu2018" Type="float8" />
          <Property Name="effsimu2019" Type="float8" />
          <Property Name="excedentsimu2019" Type="float8" />
          <Property Name="effsimu2020" Type="float8" />
          <Property Name="excedentsimu2020" Type="float8" />
          <Property Name="effsimu2021" Type="float8" />
          <Property Name="excedentsimu2021" Type="float8" />
          <Property Name="ulis" Type="int4" />
          <Property Name="secteur6" Type="int4" />
          <Property Name="horssecteur6" Type="int4" />
          <Property Name="effreel2014" Type="float8" />
          <Property Name="excedentreel2014" Type="float8" />
          <Property Name="effreel2015" Type="float8" />
          <Property Name="excedentreel2015" Type="float8" />
          <Property Name="effsimu2022" Type="float8" />
          <Property Name="excedentsimu2022" Type="float8" />
          <Property Name="effsimu2023" Type="float8" />
          <Property Name="excedentsimu2023" Type="float8" />
          <Property Name="effreel2016" Type="float8" />
          <Property Name="excedentreel2016" Type="float8" />
          <Property Name="effreel2017" Type="float8" />
          <Property Name="excedentreel2017" Type="float8" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.transport_iti_arret' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="transport_iti_arret">
          <Key>
            <PropertyRef Name="iditi" />
            <PropertyRef Name="idarret" />
          </Key>
          <Property Name="iditi" Type="numeric" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idarret" Type="numeric" Precision="10" Scale="0" Nullable="false" />
          <Property Name="ordre" Type="numeric" Precision="5" Scale="0" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.transportarret' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="transportarret">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="annee" Type="float8" />
          <Property Name="code" Type="varchar" MaxLength="20" />
          <Property Name="nom" Type="varchar" MaxLength="200" />
          <Property Name="idcommune" Type="numeric" Precision="10" Scale="0" />
          <Property Name="x" Type="float8" />
          <Property Name="y" Type="float8" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.transportitineraire' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="transportitineraire">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="annee" Type="float8" />
          <Property Name="code" Type="varchar" MaxLength="20" />
          <Property Name="nom" Type="varchar" MaxLength="200" />
          <Property Name="fonctionnement" Type="varchar" MaxLength="10" />
          <Property Name="typeservice" Type="varchar" MaxLength="50" />
          <Property Name="sens" Type="varchar" MaxLength="1" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.typebourse' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="typebourse">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="code" Type="numeric" Precision="2" Scale="0" />
          <Property Name="libelle" Type="varchar" MaxLength="100" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
avertissement 6002: La table/vue 'educf.educf.typeetablissement' n'a pas de clé primaire définie. La clé a été déduite et la définition a été créée en tant que table/vue en lecture seule.-->
        <EntityType Name="typeetablissement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="20" />
        </EntityType>
        <EntityType Name="typelogement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="coefcollege" Type="numeric" Precision="10" Scale="3" />
          <Property Name="coefprimaire" Type="numeric" Precision="10" Scale="3" />
          <Property Name="libelle" Type="varchar" MaxLength="60" />
        </EntityType>
        <EntityType Name="typesalle">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="40" />
        </EntityType>
        <EntityType Name="ulis">
          <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="3" />
        </EntityType>
        <EntityType Name="urbanisationcartescolaire">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idurbanisation" Type="int4" />
          <Property Name="idcartescolaire" Type="int4" />
          <Property Name="idetabsecteur" Type="numeric" Precision="5" Scale="0" />
          <Property Name="idecolesecteur" Type="numeric" Precision="5" Scale="0" />
          <Property Name="idmaternellesecteur" Type="numeric" Precision="5" Scale="0" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
        </EntityType>
        <EntityType Name="utilisateur">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="mdp" Type="varchar" MaxLength="50" />
          <Property Name="optetablissements" Type="float8" />
          <Property Name="optadministrateur" Type="float8" />
          <Property Name="optcommunes" Type="float8" />
          <Property Name="opteleves" Type="float8" />
          <Property Name="optsimulations" Type="float8" />
          <Property Name="optdonnees" Type="float8" />
          <Property Name="optsig" Type="float8" />
        </EntityType>
        <!--Erreurs détectées durant la génération :
erreur 6004: La table 'educf.educf.cartecouche' est référencée par une relation, mais elle est introuvable.
        <Association Name="fk_cartecouche_carte" />-->
        <!--Erreurs détectées durant la génération :
erreur 6004: La table 'educf.educf.communeeffectifannee' est référencée par une relation, mais elle est introuvable.
        <Association Name="fk_commeffannee_cs" />-->
        <Association Name="fk_commune_canton">
          <End Role="canton" Type="Self.canton" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="commune" Type="Self.commune" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="canton">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="commune">
              <PropertyRef Name="idcanton" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EleveAnneeCode">
          <End Role="eleve" Type="Self.eleve" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="eleveannee" Type="Self.eleveannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="eleve">
              <PropertyRef Name="code" />
            </Principal>
            <Dependent Role="eleveannee">
              <PropertyRef Name="code" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="fk_elevecs_cs">
          <End Role="cartescolaire" Type="Self.cartescolaire" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="elevecartescolaire" Type="Self.elevecartescolaire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="cartescolaire">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="elevecartescolaire">
              <PropertyRef Name="idcartescolaire" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <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_EtabCS">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabcartescolaire" Type="Self.etabcartescolaire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabcartescolaire">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabCSCommune">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabcartescolairecommune" Type="Self.etabcartescolairecommune" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabcartescolairecommune">
              <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_EtabEquipAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabequipementannee" Type="Self.etabequipementannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabequipementannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabEquipProcheAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabequipementprocheannee" Type="Self.etabequipementprocheannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabequipementprocheannee">
              <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_etabregie_etab">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etablissementregie" Type="Self.etablissementregie" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etablissementregie">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabsallesannee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabsallesannee" Type="Self.etabsallesannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabsallesannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabsegpa">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabsegpa" Type="Self.etabsegpa" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabsegpa">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabsousgroupeannee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabsousgroupeannee" Type="Self.etabsousgroupeannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabsousgroupeannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabtosannee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabtosannee" Type="Self.etabtosannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabtosannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabtravauxannee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabtravauxannee" Type="Self.etabtravauxannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabtravauxannee">
              <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>
        <Association Name="fk_simulationannee_cs">
          <End Role="cartescolaire" Type="Self.cartescolaire" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="simulationannee" Type="Self.simulationannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="cartescolaire">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="simulationannee">
              <PropertyRef Name="idcartescolaire" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_simulationresultats">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="simulationresultats" Type="Self.simulationresultats" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="simulationresultats">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_simulationresurbanisation">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="simulationresurbanisation" Type="Self.simulationresurbanisation" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="simulationresurbanisation">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_simulationresurbanisationsimu">
          <End Role="simulationannee" Type="Self.simulationannee" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="simulationresurbanisation" Type="Self.simulationresurbanisation" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="simulationannee">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="simulationresurbanisation">
              <PropertyRef Name="idsimulation" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UrbaCS">
          <End Role="communeurbanisationannee" Type="Self.communeurbanisationannee" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="urbanisationcartescolaire" Type="Self.urbanisationcartescolaire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="communeurbanisationannee">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="urbanisationcartescolaire">
              <PropertyRef Name="idurbanisation" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="fk_urbanisationcs_cs">
          <End Role="cartescolaire" Type="Self.cartescolaire" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="urbanisationcartescolaire" Type="Self.urbanisationcartescolaire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="cartescolaire">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="urbanisationcartescolaire">
              <PropertyRef Name="idcartescolaire" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="educfModelStoreContainer">
          <EntitySet Name="anneescolaire" EntityType="Self.anneescolaire" Schema="educf" store:Type="Tables" />
          <EntitySet Name="bassin" EntityType="Self.bassin" Schema="educf" store:Type="Tables" />
          <EntitySet Name="canton" EntityType="Self.canton" Schema="educf" store:Type="Tables" />
          <EntitySet Name="carte" EntityType="Self.carte" Schema="educf" store:Type="Tables" />
          <EntitySet Name="cartescolaire" EntityType="Self.cartescolaire" Schema="educf" store:Type="Tables" />
          <EntitySet Name="commune" EntityType="Self.commune" Schema="educf" store:Type="Tables" />
          <EntitySet Name="communeurbanisationannee" EntityType="Self.communeurbanisationannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="couleur" EntityType="Self.couleur" Schema="educf" store:Type="Tables" />
          <EntitySet Name="eleve" EntityType="Self.eleve" Schema="educf" store:Type="Tables" />
          <EntitySet Name="eleveannee" EntityType="Self.eleveannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="elevecartescolaire" EntityType="Self.elevecartescolaire" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabcartescolaire" EntityType="Self.etabcartescolaire" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabcartescolairecommune" EntityType="Self.etabcartescolairecommune" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabclasseannee" EntityType="Self.etabclasseannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabeffectifannee" EntityType="Self.etabeffectifannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabequipementannee" EntityType="Self.etabequipementannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabequipementprocheannee" EntityType="Self.etabequipementprocheannee" 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="etablissementregie" EntityType="Self.etablissementregie" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etaboptionsannee" EntityType="Self.etaboptionsannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabsallesannee" EntityType="Self.etabsallesannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabsegpa" EntityType="Self.etabsegpa" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabsousgroupeannee" EntityType="Self.etabsousgroupeannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabtosannee" EntityType="Self.etabtosannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabtravauxannee" EntityType="Self.etabtravauxannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="filiere" EntityType="Self.filiere" Schema="educf" store:Type="Tables" />
          <EntitySet Name="grandbassin" EntityType="Self.grandbassin" 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="mission" EntityType="Self.mission" Schema="educf" store:Type="Tables" />
          <EntitySet Name="nationalite" EntityType="Self.nationalite" Schema="educf" store:Type="Tables" />
          <EntitySet Name="niveau" EntityType="Self.niveau" Schema="educf" store:Type="Tables" />
          <EntitySet Name="previsibilite" EntityType="Self.previsibilite" Schema="educf" store:Type="Tables" />
          <EntitySet Name="regierestauration" EntityType="Self.regierestauration" Schema="educf" store:Type="Tables" />
          <EntitySet Name="rpi" EntityType="Self.rpi" Schema="educf" store:Type="Tables" />
          <EntitySet Name="rues" EntityType="Self.rues" Schema="educf" store:Type="Tables" />
          <EntitySet Name="ruescomplement" EntityType="Self.ruescomplement" Schema="educf" store:Type="Tables" />
          <EntitySet Name="segpa" EntityType="Self.segpa" Schema="educf" store:Type="Tables" />
          <EntitySet Name="simulationannee" EntityType="Self.simulationannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="simulationresultats" EntityType="Self.simulationresultats" Schema="educf" store:Type="Tables" />
          <EntitySet Name="simulationresurbanisation" EntityType="Self.simulationresurbanisation" Schema="educf" store:Type="Tables" />
          <EntitySet Name="thematique" EntityType="Self.thematique" Schema="educf" store:Type="Tables" />
          <EntitySet Name="thematiques" EntityType="Self.thematiques" Schema="educf" store:Type="Tables" />
          <EntitySet Name="thematiquescommunes" EntityType="Self.thematiquescommunes" Schema="educf" store:Type="Tables" />
          <EntitySet Name="thematiqueseleves" EntityType="Self.thematiqueseleves" Schema="educf" store:Type="Tables" />
          <EntitySet Name="thematiquesetab" EntityType="Self.thematiquesetab" Schema="educf" store:Type="Tables" />
          <EntitySet Name="typelogement" EntityType="Self.typelogement" Schema="educf" store:Type="Tables" />
          <EntitySet Name="typesalle" EntityType="Self.typesalle" Schema="educf" store:Type="Tables" />
          <EntitySet Name="ulis" EntityType="Self.ulis" Schema="educf" store:Type="Tables" />
          <EntitySet Name="urbanisationcartescolaire" EntityType="Self.urbanisationcartescolaire" Schema="educf" store:Type="Tables" />
          <EntitySet Name="utilisateur" EntityType="Self.utilisateur" Schema="educf" store:Type="Tables" />
          <EntitySet Name="classement" EntityType="Self.classement" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "classement"."id", "classement"."nom" FROM "educf"."classement" AS "classement"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="classeniveau" EntityType="Self.classeniveau" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "classeniveau"."idclasse", "classeniveau"."idniveau" FROM "educf"."classeniveau" AS "classeniveau"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="commune_ok" EntityType="Self.commune_ok" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "commune_ok"."idcommuneok", "commune_ok"."nom" FROM "educf"."commune_ok" AS "commune_ok"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="communeannee" EntityType="Self.communeannee" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "communeannee"."idcommune", "communeannee"."annee", "communeannee"."prevcreationetab", "communeannee"."prevsuppressionetab" FROM "educf"."communeannee" AS "communeannee"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="communehabitants" EntityType="Self.communehabitants" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "communehabitants"."idcommune", "communehabitants"."annee", "communehabitants"."habitants", "communehabitants"."naissances" FROM "educf"."communehabitants" AS "communehabitants"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="communeurbanisationparcelle" EntityType="Self.communeurbanisationparcelle" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "communeurbanisationparcelle"."idurbanisation", "communeurbanisationparcelle"."idparcelle" FROM "educf"."communeurbanisationparcelle" AS "communeurbanisationparcelle"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="csp" EntityType="Self.csp" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "csp"."id", "csp"."nom", "csp"."code", "csp"."favorise", "csp"."qf" FROM "educf"."csp" AS "csp"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="etab_ok" EntityType="Self.etab_ok" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "etab_ok"."idetabok", "etab_ok"."nom" FROM "educf"."etab_ok" AS "etab_ok"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="parcelle" EntityType="Self.parcelle" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "parcelle"."id", "parcelle"."nom", "parcelle"."numadresse", "parcelle"."idrue" FROM "educf"."parcelle" AS "parcelle"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="plan" EntityType="Self.plan" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "plan"."nom", "plan"."chemincomplet", "plan"."zoommin", "plan"."zoommax", "plan"."format", "plan"."ordre", "plan"."etiquette", "plan"."tailleetiquette", "plan"."champetiquette", "plan"."symbol", "plan"."symbolfont", "plan"."symbolsize", "plan"."symbolcolor", "plan"."symbolangle", "plan"."symbolhalo", "plan"."symbolbox", "plan"."symbolbkgcolor", "plan"."symbolshadow", "plan"."symbolitalic", "plan"."symbolbold", "plan"."linestyle", "plan"."linecolor", "plan"."lineunit", "plan"."linewidth", "plan"."lineinterleaved", "plan"."regionbackcolor", "plan"."regionbordercolor", "plan"."regionborderstyle", "plan"."regionborderwidth", "plan"."regionborderwidthunit", "plan"."regioncolor", "plan"."regionpattern", "plan"."regiontransparent", "plan"."sansrepgraphique", "plan"."visible", "plan"."policeetiquette", "plan"."couleuretiquette", "plan"."typereprgraphique", "plan"."id", "plan"."nomalias", "plan"."symbolbitmapname", "plan"."symbolbitmapsize", "plan"."symbolbitmaptransparent", "plan"."symbolcharacter", "plan"."symboltype" FROM "educf"."plan" AS "plan"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="rue_ok" EntityType="Self.rue_ok" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "rue_ok"."idrueok", "rue_ok"."nom", "rue_ok"."commune" FROM "educf"."rue_ok" AS "rue_ok"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="simulationetabcrees" EntityType="Self.simulationetabcrees" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "simulationetabcrees"."idsimulation", "simulationetabcrees"."idetablissement", "simulationetabcrees"."annee", "simulationetabcrees"."id" FROM "educf"."simulationetabcrees" AS "simulationetabcrees"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="simulationetabsupprimes" EntityType="Self.simulationetabsupprimes" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "simulationetabsupprimes"."idsimulation", "simulationetabsupprimes"."idetablissement", "simulationetabsupprimes"."annee", "simulationetabsupprimes"."id" FROM "educf"."simulationetabsupprimes" AS "simulationetabsupprimes"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="transport_iti_arret" EntityType="Self.transport_iti_arret" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "transport_iti_arret"."iditi", "transport_iti_arret"."idarret", "transport_iti_arret"."ordre" FROM "educf"."transport_iti_arret" AS "transport_iti_arret"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="transportarret" EntityType="Self.transportarret" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "transportarret"."id", "transportarret"."annee", "transportarret"."code", "transportarret"."nom", "transportarret"."idcommune", "transportarret"."x", "transportarret"."y" FROM "educf"."transportarret" AS "transportarret"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="transportitineraire" EntityType="Self.transportitineraire" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "transportitineraire"."id", "transportitineraire"."annee", "transportitineraire"."code", "transportitineraire"."nom", "transportitineraire"."fonctionnement", "transportitineraire"."typeservice", "transportitineraire"."sens" FROM "educf"."transportitineraire" AS "transportitineraire"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="typebourse" EntityType="Self.typebourse" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "typebourse"."id", "typebourse"."code", "typebourse"."libelle" FROM "educf"."typebourse" AS "typebourse"</DefiningQuery>
          </EntitySet>
          <EntitySet Name="typeetablissement" EntityType="Self.typeetablissement" store:Type="Tables" store:Schema="educf">
            <DefiningQuery>SELECT "typeetablissement"."id", "typeetablissement"."nom" FROM "educf"."typeetablissement" AS "typeetablissement"</DefiningQuery>
          </EntitySet>
          <AssociationSet Name="fk_commune_canton" Association="Self.fk_commune_canton">
            <End Role="canton" EntitySet="canton" />
            <End Role="commune" EntitySet="commune" />
          </AssociationSet>
          <AssociationSet Name="FK_EleveAnneeCode" Association="Self.FK_EleveAnneeCode">
            <End Role="eleve" EntitySet="eleve" />
            <End Role="eleveannee" EntitySet="eleveannee" />
          </AssociationSet>
          <AssociationSet Name="fk_elevecs_cs" Association="Self.fk_elevecs_cs">
            <End Role="cartescolaire" EntitySet="cartescolaire" />
            <End Role="elevecartescolaire" EntitySet="elevecartescolaire" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabAnnee" Association="Self.FK_EtabAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etablissementannee" EntitySet="etablissementannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabCS" Association="Self.FK_EtabCS">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabcartescolaire" EntitySet="etabcartescolaire" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabCSCommune" Association="Self.FK_EtabCSCommune">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabcartescolairecommune" EntitySet="etabcartescolairecommune" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabEffectifAnnee" Association="Self.FK_EtabEffectifAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabeffectifannee" EntitySet="etabeffectifannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabEquipAnnee" Association="Self.FK_EtabEquipAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabequipementannee" EntitySet="etabequipementannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabEquipProcheAnnee" Association="Self.FK_EtabEquipProcheAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabequipementprocheannee" EntitySet="etabequipementprocheannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabOptionsAnnee" Association="Self.FK_EtabOptionsAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etaboptionsannee" EntitySet="etaboptionsannee" />
          </AssociationSet>
          <AssociationSet Name="fk_etabregie_etab" Association="Self.fk_etabregie_etab">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etablissementregie" EntitySet="etablissementregie" />
          </AssociationSet>
          <AssociationSet Name="FK_etabsallesannee" Association="Self.FK_etabsallesannee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabsallesannee" EntitySet="etabsallesannee" />
          </AssociationSet>
          <AssociationSet Name="FK_etabsegpa" Association="Self.FK_etabsegpa">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabsegpa" EntitySet="etabsegpa" />
          </AssociationSet>
          <AssociationSet Name="FK_etabsousgroupeannee" Association="Self.FK_etabsousgroupeannee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabsousgroupeannee" EntitySet="etabsousgroupeannee" />
          </AssociationSet>
          <AssociationSet Name="FK_etabtosannee" Association="Self.FK_etabtosannee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabtosannee" EntitySet="etabtosannee" />
          </AssociationSet>
          <AssociationSet Name="FK_etabtravauxannee" Association="Self.FK_etabtravauxannee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabtravauxannee" EntitySet="etabtravauxannee" />
          </AssociationSet>
          <AssociationSet Name="FK_RuesCommunes" Association="Self.FK_RuesCommunes">
            <End Role="commune" EntitySet="commune" />
            <End Role="rues" EntitySet="rues" />
          </AssociationSet>
          <AssociationSet Name="fk_simulationannee_cs" Association="Self.fk_simulationannee_cs">
            <End Role="cartescolaire" EntitySet="cartescolaire" />
            <End Role="simulationannee" EntitySet="simulationannee" />
          </AssociationSet>
          <AssociationSet Name="FK_simulationresultats" Association="Self.FK_simulationresultats">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="simulationresultats" EntitySet="simulationresultats" />
          </AssociationSet>
          <AssociationSet Name="FK_simulationresurbanisation" Association="Self.FK_simulationresurbanisation">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="simulationresurbanisation" EntitySet="simulationresurbanisation" />
          </AssociationSet>
          <AssociationSet Name="FK_simulationresurbanisationsimu" Association="Self.FK_simulationresurbanisationsimu">
            <End Role="simulationannee" EntitySet="simulationannee" />
            <End Role="simulationresurbanisation" EntitySet="simulationresurbanisation" />
          </AssociationSet>
          <AssociationSet Name="FK_UrbaCS" Association="Self.FK_UrbaCS">
            <End Role="communeurbanisationannee" EntitySet="communeurbanisationannee" />
            <End Role="urbanisationcartescolaire" EntitySet="urbanisationcartescolaire" />
          </AssociationSet>
          <AssociationSet Name="fk_urbanisationcs_cs" Association="Self.fk_urbanisationcs_cs">
            <End Role="cartescolaire" EntitySet="cartescolaire" />
            <End Role="urbanisationcartescolaire" EntitySet="urbanisationcartescolaire" />
          </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="anneescolaire">
          <Key>
            <PropertyRef Name="nom" />
          </Key>
          <Property Name="nom" Type="Decimal" Precision="4" Scale="0" Nullable="false" />
          <Property Name="nbanscalcultap" Type="Int32" />
          <Property Name="nbanscalcultap2" Type="Int32" />
          <Property Name="datecalcultap" Type="DateTime" Precision="0" />
        </EntityType>
        <EntityType Name="bassin">
          <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="idgrandbassin" Type="Int32" />
        </EntityType>
        <EntityType Name="canton">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="code" Type="String" MaxLength="3" FixedLength="false" Unicode="true" />
          <Property Name="nom" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="responsable1" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="responsable2" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="commune" Relationship="Self.fk_commune_canton" FromRole="canton" ToRole="commune" />
        </EntityType>
        <EntityType Name="carte">
          <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="posx" Type="Double" />
          <Property Name="posy" Type="Double" />
          <Property Name="zoom" Type="Double" />
        </EntityType>
        <EntityType Name="cartescolaire">
          <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="adresseoptbd" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="adressenomcouche" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="adressenomchamp" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="adressenomchampprim" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="voieoptbd" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="voienomcouche" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="voienomchamp" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="voienomchampprim" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="etablissementoptbd" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="etablissementnomcouche" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="etablissementnomchamp" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="etablissementnomchampprim" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="ecoleoptbd" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="ecolenomcouche" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="ecolenomchamp1" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="ecolenomchampratio1" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="ecolenomchamp2" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="ecolenomchampratio2" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="datederniercalcul" Type="DateTime" Precision="6" />
          <Property Name="adressenomchampdistance" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="adressenomchampdistanceprim" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="parcellenomchampdistance" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="parcellenomchampdistanceprim" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="parcellenomchamp" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="parcellenomchampprim" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="elevecartescolaire" Relationship="Self.fk_elevecs_cs" FromRole="cartescolaire" ToRole="elevecartescolaire" />
          <NavigationProperty Name="simulationannee" Relationship="Self.fk_simulationannee_cs" FromRole="cartescolaire" ToRole="simulationannee" />
          <NavigationProperty Name="urbanisationcartescolaire" Relationship="Self.fk_urbanisationcs_cs" FromRole="cartescolaire" ToRole="urbanisationcartescolaire" />
        </EntityType>
        <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="canton" Relationship="Self.fk_commune_canton" FromRole="commune" ToRole="canton" />
          <NavigationProperty Name="rues" Relationship="Self.FK_RuesCommunes" FromRole="commune" ToRole="rues" />
        </EntityType>
        <EntityType Name="communeurbanisationannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idcommune" Type="Double" />
          <Property Name="annee" Type="Double" />
          <Property Name="nomprogramme" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="nature" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="adresse" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="debut" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="fin" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="budgetprevu" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="budgetreel" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="motifecart" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="subvention" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="typelogements" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="anneedebut" Type="Decimal" Precision="4" Scale="0" />
          <Property Name="numadresse" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="idrue" Type="Decimal" Precision="12" Scale="0" />
          <Property Name="dateimport" Type="DateTime" Precision="6" />
          <Property Name="datemodif" Type="DateTime" Precision="6" />
          <Property Name="nblogements" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="nbeleves" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="nblogementsrenouv" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="idtypelogement" Type="Decimal" Precision="10" Scale="0" />
          <NavigationProperty Name="urbanisationcartescolaire" Relationship="Self.FK_UrbaCS" FromRole="communeurbanisationannee" ToRole="urbanisationcartescolaire" />
        </EntityType>
        <EntityType Name="couleur">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="code" Type="Int32" />
          <Property Name="r" Type="Int32" />
          <Property Name="v" Type="Int32" />
          <Property Name="b" Type="Int32" />
          <Property Name="nom" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="eleve">
          <Key>
            <PropertyRef Name="code" />
          </Key>
          <Property Name="code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="numadresse" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="idrue" Type="Double" />
          <Property Name="adresse2" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="idcsp" Type="Double" />
          <Property Name="datenaissance" Type="DateTime" Precision="6" />
          <Property Name="nom" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="prenom" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="sexe" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="nationalite" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="ilotinsee" Type="String" MaxLength="9" FixedLength="false" Unicode="true" />
          <Property Name="posx" Type="Double" />
          <Property Name="posy" Type="Double" />
          <Property Name="idfamille" Type="Int32" />
          <NavigationProperty Name="eleveannee" Relationship="Self.FK_EleveAnneeCode" FromRole="eleve" ToRole="eleveannee" />
        </EntityType>
        <EntityType Name="eleveannee">
          <Key>
            <PropertyRef Name="code" />
            <PropertyRef Name="annee" />
          </Key>
          <Property Name="code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="idetablissement" Type="Double" />
          <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="eleve" Relationship="Self.FK_EleveAnneeCode" FromRole="eleveannee" ToRole="eleve" />
        </EntityType>
        <EntityType Name="elevecartescolaire">
          <Key>
            <PropertyRef Name="id_elevecs" />
          </Key>
          <Property Name="code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="idcartescolaire" Type="Int32" />
          <Property Name="idetabsecteur" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="idetabsecteursuiv" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="id_elevecs" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idetabsecteurprec" Type="Int32" />
          <NavigationProperty Name="cartescolaire" Relationship="Self.fk_elevecs_cs" FromRole="elevecartescolaire" ToRole="cartescolaire" />
        </EntityType>
        <EntityType Name="etabcartescolaire">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idetablissement" Type="Int32" Nullable="false" />
          <Property Name="idrue" Type="Double" />
          <Property Name="debut" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="fin" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="pairimpair" Type="Double" />
          <Property Name="proximite" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="accessibilite" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="idcartescolaire" Type="Decimal" Precision="4" Scale="0" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_EtabCS" FromRole="etabcartescolaire" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etabcartescolairecommune">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idetablissement" Type="Int32" Nullable="false" />
          <Property Name="idcommune" Type="Double" />
          <Property Name="idcartescolaire" Type="Decimal" Precision="4" Scale="0" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_EtabCSCommune" FromRole="etabcartescolairecommune" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etabclasseannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idsousgroupe" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="nom" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="effectif" Type="Decimal" Precision="5" Scale="0" />
        </EntityType>
        <EntityType Name="etabeffectifannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="annee" Type="Double" />
          <Property Name="effectif" Type="Double" />
          <Property Name="idniveau" Type="Double" />
          <Property Name="tap" Type="Double" />
          <Property Name="tevit" Type="Double" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <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" />
        </EntityType>
        <EntityType Name="etabequipementannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="annee" Type="Double" />
          <Property Name="nom" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="capacite" Type="Double" />
          <Property Name="superficie" Type="Double" />
          <Property Name="nbsalles" Type="Double" />
          <Property Name="gardien" Type="String" MaxLength="70" FixedLength="false" Unicode="true" />
          <Property Name="contact" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="vestiaire" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_EtabEquipAnnee" FromRole="etabequipementannee" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etabequipementprocheannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="annee" Type="Double" />
          <Property Name="nom" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="capacite" Type="Double" />
          <Property Name="superficie" Type="Double" />
          <Property Name="nbsalles" Type="Double" />
          <Property Name="gardien" Type="String" MaxLength="70" FixedLength="false" Unicode="true" />
          <Property Name="contact" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="vestiaire" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_EtabEquipProcheAnnee" FromRole="etabequipementprocheannee" ToRole="etablissement" />
        </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="Double" />
          <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="etabcartescolaire" Relationship="Self.FK_EtabCS" FromRole="etablissement" ToRole="etabcartescolaire" />
          <NavigationProperty Name="etabcartescolairecommune" Relationship="Self.FK_EtabCSCommune" FromRole="etablissement" ToRole="etabcartescolairecommune" />
          <NavigationProperty Name="etabeffectifannee" Relationship="Self.FK_EtabEffectifAnnee" FromRole="etablissement" ToRole="etabeffectifannee" />
          <NavigationProperty Name="etabequipementannee" Relationship="Self.FK_EtabEquipAnnee" FromRole="etablissement" ToRole="etabequipementannee" />
          <NavigationProperty Name="etabequipementprocheannee" Relationship="Self.FK_EtabEquipProcheAnnee" FromRole="etablissement" ToRole="etabequipementprocheannee" />
          <NavigationProperty Name="etablissementannee" Relationship="Self.FK_EtabAnnee" FromRole="etablissement" ToRole="etablissementannee" />
          <NavigationProperty Name="etaboptionsannee" Relationship="Self.FK_EtabOptionsAnnee" FromRole="etablissement" ToRole="etaboptionsannee" />
          <NavigationProperty Name="etablissementregie" Relationship="Self.fk_etabregie_etab" FromRole="etablissement" ToRole="etablissementregie" />
          <NavigationProperty Name="etabsallesannee" Relationship="Self.FK_etabsallesannee" FromRole="etablissement" ToRole="etabsallesannee" />
          <NavigationProperty Name="etabsegpa" Relationship="Self.FK_etabsegpa" FromRole="etablissement" ToRole="etabsegpa" />
          <NavigationProperty Name="etabsousgroupeannee" Relationship="Self.FK_etabsousgroupeannee" FromRole="etablissement" ToRole="etabsousgroupeannee" />
          <NavigationProperty Name="etabtosannee" Relationship="Self.FK_etabtosannee" FromRole="etablissement" ToRole="etabtosannee" />
          <NavigationProperty Name="etabtravauxannee" Relationship="Self.FK_etabtravauxannee" FromRole="etablissement" ToRole="etabtravauxannee" />
          <NavigationProperty Name="simulationresultats" Relationship="Self.FK_simulationresultats" FromRole="etablissement" ToRole="simulationresultats" />
          <NavigationProperty Name="simulationresurbanisation" Relationship="Self.FK_simulationresurbanisation" FromRole="etablissement" ToRole="simulationresurbanisation" />
        </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="Self.FK_EtabAnnee" FromRole="etablissementannee" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etablissementregie">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="idregie" Type="Int32" />
          <Property Name="ratio" Type="Double" />
          <Property Name="annee" Type="Int32" />
          <NavigationProperty Name="etablissement" Relationship="Self.fk_etabregie_etab" FromRole="etablissementregie" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etaboptionsannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="idoption" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_EtabOptionsAnnee" FromRole="etaboptionsannee" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etabsallesannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="annee" Type="Double" />
          <Property Name="nbsalles" Type="Double" />
          <Property Name="idtypesalle" Type="Double" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="surface" Type="Decimal" Precision="5" Scale="0" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_etabsallesannee" FromRole="etabsallesannee" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etabsegpa">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="idsegpa" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_etabsegpa" FromRole="etabsegpa" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etabsousgroupeannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="nom" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="annee" Type="Int32" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_etabsousgroupeannee" FromRole="etabsousgroupeannee" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etabtosannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="annee" Type="Double" />
          <Property Name="nom" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="mission1" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="quotite" Type="Double" />
          <Property Name="duree1" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="mission2" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="duree2" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="mission3" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="duree3" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_etabtosannee" FromRole="etabtosannee" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="etabtravauxannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="annee" Type="Int32" />
          <Property Name="nature" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="previsibilite" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="motifurgence" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="debut" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="fin" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="budgetprevu" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="budgetreel" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="motifecart" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_etabtravauxannee" FromRole="etabtravauxannee" ToRole="etablissement" />
        </EntityType>
        <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" />
        </EntityType>
        <EntityType Name="grandbassin">
          <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" />
        </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" />
        </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="Decimal" Precision="5" Scale="0" />
          <Property Name="idfiliere" Type="Decimal" Precision="5" Scale="0" />
        </EntityType>
        <EntityType Name="mission">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="nom" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
        </EntityType>
        <EntityType Name="nationalite">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="code" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="libelle" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
        </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" />
        </EntityType>
        <EntityType Name="previsibilite">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="regierestauration">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idrue" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="numadresse" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="code" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="nom" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="capacite" Type="Int32" />
        </EntityType>
        <EntityType Name="rpi">
          <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" />
        </EntityType>
        <EntityType Name="rues">
          <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" />
        </EntityType>
        <EntityType Name="ruescomplement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idrue" Type="Int32" />
          <Property Name="complement" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="segpa">
          <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" />
        </EntityType>
        <EntityType Name="simulationannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="annee" Type="Double" />
          <Property Name="nom" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="monteepedagogique" Type="Double" />
          <Property Name="tap" Type="Double" />
          <Property Name="ratios" Type="Double" />
          <Property Name="evitement" Type="Double" />
          <Property Name="idcartescolaire" Type="Int32" />
          <Property Name="tapsec" Type="Double" />
          <Property Name="datecalcul" Type="DateTime" Precision="6" />
          <Property Name="apportprogressif" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="idcartescolaire2" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="anneecartescolaire2" Type="Decimal" Precision="4" Scale="0" />
          <Property Name="optcartescolaire2" Type="Decimal" Precision="2" Scale="0" />
          <Property Name="optapportglobal" Type="Decimal" Precision="2" Scale="0" />
          <Property Name="optprevisionficheetab" Type="Decimal" Precision="2" Scale="0" />
          <Property Name="opttapdepartemental" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optmonteeadresse" Type="Int32" />
          <NavigationProperty Name="cartescolaire" Relationship="Self.fk_simulationannee_cs" FromRole="simulationannee" ToRole="cartescolaire" />
          <NavigationProperty Name="simulationresurbanisation" Relationship="Self.FK_simulationresurbanisationsimu" FromRole="simulationannee" ToRole="simulationresurbanisation" />
        </EntityType>
        <EntityType Name="simulationresultats">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idsimulation" Type="Int32" />
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="idniveau" Type="Double" />
          <Property Name="effectif" Type="Double" />
          <Property Name="annee" Type="Double" />
          <Property Name="effectifurba" Type="Double" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_simulationresultats" FromRole="simulationresultats" ToRole="etablissement" />
        </EntityType>
        <EntityType Name="simulationresurbanisation">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idsimulation" Type="Int32" Nullable="false" />
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="effectif" Type="Single" />
          <Property Name="annee" Type="Decimal" Precision="4" Scale="0" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_simulationresurbanisation" FromRole="simulationresurbanisation" ToRole="etablissement" />
          <NavigationProperty Name="simulationannee" Relationship="Self.FK_simulationresurbanisationsimu" FromRole="simulationresurbanisation" ToRole="simulationannee" />
        </EntityType>
        <EntityType Name="thematique">
          <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="couleur" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="valeurmin" Type="Decimal" Precision="10" Scale="2" />
          <Property Name="valeurmax" Type="Decimal" Precision="10" Scale="2" />
        </EntityType>
        <EntityType Name="thematiques">
          <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="couche" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="thematiquescommunes">
          <Key>
            <PropertyRef Name="insee" />
          </Key>
          <Property Name="insee" Type="String" MaxLength="5" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="nbelpublic" Type="Single" />
          <Property Name="nbelprive" Type="Single" />
          <Property Name="nbnaissances" Type="Single" />
          <Property Name="nbelprimaire" Type="Single" />
          <Property Name="nblogementsan1" Type="Single" />
          <Property Name="nblogementsan2" Type="Single" />
          <Property Name="nblogementsan3" Type="Single" />
          <Property Name="nblogementsan4" Type="Single" />
          <Property Name="nblogementsan5" Type="Single" />
          <Property Name="rneetabsecteur" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="anneereel" Type="Single" />
          <Property Name="anneesimu" Type="Single" />
          <Property Name="nbelpublicsimu" Type="Single" />
          <Property Name="nbelprivesimu" Type="Single" />
          <Property Name="superficie" Type="Single" />
          <Property Name="densitecollegiens" Type="Single" />
          <Property Name="nbhabitants" Type="Single" />
          <Property Name="densitepop" Type="Single" />
          <Property Name="nongeolocalises" Type="Single" />
          <Property Name="nongeolocalisesprive" Type="Single" />
          <Property Name="rpi" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="effreel2007" Type="Single" />
          <Property Name="effreel2008" Type="Single" />
          <Property Name="effreel2009" Type="Single" />
          <Property Name="effreel2010" Type="Single" />
          <Property Name="effreel2011" Type="Single" />
          <Property Name="effreel2012" Type="Single" />
          <Property Name="effreel2013" Type="Single" />
          <Property Name="excedentreel2007" Type="Double" />
          <Property Name="excedentreel2008" Type="Double" />
          <Property Name="excedentreel2009" Type="Double" />
          <Property Name="excedentreel2010" Type="Double" />
          <Property Name="excedentreel2011" Type="Double" />
          <Property Name="excedentreel2012" Type="Double" />
          <Property Name="excedentreel2013" Type="Double" />
          <Property Name="effreel2014" Type="Double" />
          <Property Name="excedentreel2014" Type="Double" />
          <Property Name="effreel2015" Type="Double" />
          <Property Name="excedentreel2015" Type="Double" />
          <Property Name="effreel2016" Type="Double" />
          <Property Name="excedentreel2016" Type="Double" />
          <Property Name="effreel2017" Type="Double" />
          <Property Name="excedentreel2017" Type="Double" />
        </EntityType>
        <EntityType Name="thematiqueseleves">
          <Key>
            <PropertyRef Name="oid" />
          </Key>
          <Property Name="numnominsee" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="nbelpublic" Type="Int32" />
          <Property Name="nbelprive" Type="Int32" />
          <Property Name="nbnaissances" Type="Int32" />
          <Property Name="nbelprimaire" Type="Int32" />
          <Property Name="nblogementsan1" Type="Int32" />
          <Property Name="nblogementsan2" Type="Int32" />
          <Property Name="nblogementsan3" Type="Int32" />
          <Property Name="nblogementsan4" Type="Int32" />
          <Property Name="nblogementsan5" Type="Int32" />
          <Property Name="nbcpsfavorisea" Type="Int32" />
          <Property Name="nbcpsfavoriseb" Type="Int32" />
          <Property Name="nbcpsdefavorise" Type="Int32" />
          <Property Name="nbcpsmoyenne" Type="Int32" />
          <Property Name="rne" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="nblogementstotal" Type="Int32" />
          <Property Name="rne1" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="rne2" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="rne3" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="rne4" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="rne5" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="rne6" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="effectif1" Type="Int32" />
          <Property Name="effectif2" Type="Int32" />
          <Property Name="effectif3" Type="Int32" />
          <Property Name="effectif4" Type="Int32" />
          <Property Name="effectif5" Type="Int32" />
          <Property Name="effectif6" Type="Int32" />
          <Property Name="ellogan1" Type="Int32" />
          <Property Name="matlogan1" Type="Int32" />
          <Property Name="ellogan2" Type="Int32" />
          <Property Name="matlogan2" Type="Int32" />
          <Property Name="ellogan3" Type="Int32" />
          <Property Name="matlogan3" Type="Int32" />
          <Property Name="ellogan4" Type="Int32" />
          <Property Name="matlogan4" Type="Int32" />
          <Property Name="ellogan5" Type="Int32" />
          <Property Name="matlogan5" Type="Int32" />
          <Property Name="ellogtotal" Type="Int32" />
          <Property Name="matlogtotal" Type="Int32" />
          <Property Name="oid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nbelpublicapprox" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="nbelpriveapprox" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="numadresse" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="idrue" Type="Int32" />
          <Property Name="totalpublic" Type="Int32" />
          <Property Name="totalprive" Type="Int32" />
          <Property Name="totalsecteur" Type="Int32" />
          <Property Name="totalhorssecteur" Type="Int32" />
          <Property Name="matnbelpublic" Type="Int32" />
          <Property Name="matnbelprive" Type="Int32" />
          <Property Name="matnbelpublicapprox" Type="Int32" />
          <Property Name="matnbelpriveapprox" Type="Int32" />
          <Property Name="mattotalpublic" Type="Int32" />
          <Property Name="mattotalprive" Type="Int32" />
          <Property Name="mattotalsecteur" Type="Int32" />
          <Property Name="mattotalhorssecteur" Type="Int32" />
          <Property Name="matrne1" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="matrne2" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="matrne3" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="matrne4" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="matrne5" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="matrne6" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="mateffectif1" Type="Int32" />
          <Property Name="mateffectif2" Type="Int32" />
          <Property Name="mateffectif3" Type="Int32" />
          <Property Name="mateffectif4" Type="Int32" />
          <Property Name="mateffectif5" Type="Int32" />
          <Property Name="mateffectif6" Type="Int32" />
          <Property Name="dist" Type="Double" />
        </EntityType>
        <EntityType Name="thematiquesetab">
          <Key>
            <PropertyRef Name="idetablissement" />
          </Key>
          <Property Name="idetablissement" Type="Int32" Nullable="false" />
          <Property Name="anneereel" Type="Single" />
          <Property Name="anneesimu" Type="Single" />
          <Property Name="effectifreel" Type="Single" />
          <Property Name="effectifdpreel" Type="Single" />
          <Property Name="nblogementsan1" Type="Single" />
          <Property Name="nblogementsan2" Type="Single" />
          <Property Name="nblogementsan3" Type="Single" />
          <Property Name="nblogementsan4" Type="Single" />
          <Property Name="nblogementsan5" Type="Single" />
          <Property Name="effectifsimu" Type="Single" />
          <Property Name="capacite" Type="Single" />
          <Property Name="capacitedp" Type="Single" />
          <Property Name="nbderog" Type="Single" />
          <Property Name="nbcpsfavorisea" Type="Single" />
          <Property Name="nbcpsfavoriseb" Type="Single" />
          <Property Name="nbcpsdefavorise" Type="Single" />
          <Property Name="nbcpsmoyenne" Type="Single" />
          <Property Name="zep" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="handicap" Type="Int32" />
          <Property Name="prive" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="rne" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="txremplireel" Type="Single" />
          <Property Name="txremplisimu" Type="Single" />
          <Property Name="txremplidpreel" Type="Single" />
          <Property Name="effectifsegpa" Type="Single" />
          <Property Name="capacitesegpa" Type="Single" />
          <Property Name="txremplisegpa" Type="Single" />
          <Property Name="nblogementstotal" Type="Single" />
          <Property Name="nomregierestauration" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="rne1" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="ratio1" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="rne2" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="ratio2" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="rne1h1" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="ratio1h1" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="rne2h1" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="ratio2h1" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="effreel2006" Type="Single" />
          <Property Name="excedentreel2006" Type="Single" />
          <Property Name="effreel2007" Type="Single" />
          <Property Name="excedentreel2007" Type="Single" />
          <Property Name="effreel2008" Type="Single" />
          <Property Name="excedentreel2008" Type="Single" />
          <Property Name="effreel2009" Type="Single" />
          <Property Name="excedentreel2009" Type="Single" />
          <Property Name="effreel2010" Type="Single" />
          <Property Name="excedentreel2010" Type="Single" />
          <Property Name="effreel2011" Type="Single" />
          <Property Name="excedentreel2011" Type="Single" />
          <Property Name="effreel2012" Type="Single" />
          <Property Name="excedentreel2012" Type="Single" />
          <Property Name="effreel2013" Type="Single" />
          <Property Name="excedentreel2013" Type="Single" />
          <Property Name="effsimu2013" Type="Double" />
          <Property Name="excedentsimu2013" Type="Double" />
          <Property Name="effsimu2014" Type="Double" />
          <Property Name="excedentsimu2014" Type="Double" />
          <Property Name="effsimu2015" Type="Double" />
          <Property Name="excedentsimu2015" Type="Double" />
          <Property Name="effsimu2016" Type="Double" />
          <Property Name="excedentsimu2016" Type="Double" />
          <Property Name="effsimu2017" Type="Double" />
          <Property Name="excedentsimu2017" Type="Double" />
          <Property Name="effsimu2018" Type="Double" />
          <Property Name="excedentsimu2018" Type="Double" />
          <Property Name="effsimu2019" Type="Double" />
          <Property Name="excedentsimu2019" Type="Double" />
          <Property Name="effsimu2020" Type="Double" />
          <Property Name="excedentsimu2020" Type="Double" />
          <Property Name="effsimu2021" Type="Double" />
          <Property Name="excedentsimu2021" Type="Double" />
          <Property Name="ulis" Type="Int32" />
          <Property Name="secteur6" Type="Int32" />
          <Property Name="horssecteur6" Type="Int32" />
          <Property Name="effreel2014" Type="Double" />
          <Property Name="excedentreel2014" Type="Double" />
          <Property Name="effreel2015" Type="Double" />
          <Property Name="excedentreel2015" Type="Double" />
          <Property Name="effsimu2022" Type="Double" />
          <Property Name="excedentsimu2022" Type="Double" />
          <Property Name="effsimu2023" Type="Double" />
          <Property Name="excedentsimu2023" Type="Double" />
          <Property Name="effreel2016" Type="Double" />
          <Property Name="excedentreel2016" Type="Double" />
          <Property Name="effreel2017" Type="Double" />
          <Property Name="excedentreel2017" Type="Double" />
        </EntityType>
        <EntityType Name="typelogement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="coefcollege" Type="Decimal" Precision="10" Scale="3" />
          <Property Name="coefprimaire" Type="Decimal" Precision="10" Scale="3" />
          <Property Name="libelle" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="typesalle">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="ulis">
          <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="3" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="urbanisationcartescolaire">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idurbanisation" Type="Int32" />
          <Property Name="idcartescolaire" Type="Int32" />
          <Property Name="idetabsecteur" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="idecolesecteur" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="idmaternellesecteur" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="cartescolaire" Relationship="Self.fk_urbanisationcs_cs" FromRole="urbanisationcartescolaire" ToRole="cartescolaire" />
          <NavigationProperty Name="communeurbanisationannee" Relationship="Self.FK_UrbaCS" FromRole="urbanisationcartescolaire" ToRole="communeurbanisationannee" />
        </EntityType>
        <EntityType Name="utilisateur">
          <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="mdp" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="optetablissements" Type="Double" />
          <Property Name="optadministrateur" Type="Double" />
          <Property Name="optcommunes" Type="Double" />
          <Property Name="opteleves" Type="Double" />
          <Property Name="optsimulations" Type="Double" />
          <Property Name="optdonnees" Type="Double" />
          <Property Name="optsig" Type="Double" />
        </EntityType>
        <EntityType Name="classement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="classeniveau">
          <Key>
            <PropertyRef Name="idclasse" />
          </Key>
          <Property Name="idclasse" Type="Decimal" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idniveau" Type="Decimal" Precision="10" Scale="0" />
        </EntityType>
        <EntityType Name="commune_ok">
          <Key>
            <PropertyRef Name="idcommuneok" />
            <PropertyRef Name="nom" />
          </Key>
          <Property Name="idcommuneok" Type="Decimal" Precision="10" Scale="0" Nullable="false" />
          <Property Name="nom" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="communeannee">
          <Key>
            <PropertyRef Name="idcommune" />
            <PropertyRef Name="annee" />
          </Key>
          <Property Name="idcommune" Type="Double" Nullable="false" />
          <Property Name="annee" Type="Double" Nullable="false" />
          <Property Name="prevcreationetab" Type="Double" />
          <Property Name="prevsuppressionetab" Type="Double" />
        </EntityType>
        <EntityType Name="communehabitants">
          <Key>
            <PropertyRef Name="idcommune" />
          </Key>
          <Property Name="idcommune" Type="Decimal" Precision="5" Scale="0" Nullable="false" />
          <Property Name="annee" Type="Decimal" Precision="4" Scale="0" />
          <Property Name="habitants" Type="Decimal" Precision="7" Scale="0" />
          <Property Name="naissances" Type="Decimal" Precision="6" Scale="0" />
        </EntityType>
        <EntityType Name="communeurbanisationparcelle">
          <Key>
            <PropertyRef Name="idurbanisation" />
          </Key>
          <Property Name="idurbanisation" Type="Decimal" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idparcelle" Type="Decimal" Precision="10" Scale="0" />
        </EntityType>
        <EntityType Name="csp">
          <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="10" FixedLength="false" Unicode="true" />
          <Property Name="favorise" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="qf" Type="Decimal" Precision="10" Scale="0" />
        </EntityType>
        <EntityType Name="etab_ok">
          <Key>
            <PropertyRef Name="idetabok" />
            <PropertyRef Name="nom" />
          </Key>
          <Property Name="idetabok" Type="Decimal" Precision="10" Scale="0" Nullable="false" />
          <Property Name="nom" Type="String" MaxLength="150" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="parcelle">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="numadresse" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="idrue" Type="Decimal" Precision="10" Scale="0" />
        </EntityType>
        <EntityType Name="plan">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="chemincomplet" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="zoommin" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="zoommax" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="format" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="ordre" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="etiquette" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="tailleetiquette" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="champetiquette" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="symbol" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="symbolfont" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="symbolsize" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symbolcolor" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symbolangle" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symbolhalo" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symbolbox" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symbolbkgcolor" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symbolshadow" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symbolitalic" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symbolbold" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="linestyle" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="linecolor" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="lineunit" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="linewidth" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="lineinterleaved" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="regionbackcolor" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="regionbordercolor" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="regionborderstyle" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="regionborderwidth" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="regionborderwidthunit" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="regioncolor" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="regionpattern" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="regiontransparent" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="sansrepgraphique" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="visible" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="policeetiquette" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="couleuretiquette" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="typereprgraphique" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nomalias" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="symbolbitmapname" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="symbolbitmapsize" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symbolbitmaptransparent" Type="Decimal" Precision="2" Scale="0" />
          <Property Name="symbolcharacter" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="symboltype" Type="Decimal" Precision="10" Scale="0" />
        </EntityType>
        <EntityType Name="rue_ok">
          <Key>
            <PropertyRef Name="idrueok" />
          </Key>
          <Property Name="idrueok" Type="Double" Nullable="false" />
          <Property Name="nom" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="commune" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="simulationetabcrees">
          <Key>
            <PropertyRef Name="idsimulation" />
          </Key>
          <Property Name="idsimulation" Type="Decimal" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idetablissement" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="annee" Type="Decimal" Precision="4" Scale="0" />
          <Property Name="id" Type="Int32" annotation:StoreGeneratedPattern="Identity" />
        </EntityType>
        <EntityType Name="simulationetabsupprimes">
          <Key>
            <PropertyRef Name="idsimulation" />
          </Key>
          <Property Name="idsimulation" Type="Decimal" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idetablissement" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="annee" Type="Decimal" Precision="4" Scale="0" />
          <Property Name="id" Type="Int32" annotation:StoreGeneratedPattern="Identity" />
        </EntityType>
        <EntityType Name="transport_iti_arret">
          <Key>
            <PropertyRef Name="iditi" />
            <PropertyRef Name="idarret" />
          </Key>
          <Property Name="iditi" Type="Decimal" Precision="10" Scale="0" Nullable="false" />
          <Property Name="idarret" Type="Decimal" Precision="10" Scale="0" Nullable="false" />
          <Property Name="ordre" Type="Decimal" Precision="5" Scale="0" />
        </EntityType>
        <EntityType Name="transportarret">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="annee" Type="Double" />
          <Property Name="code" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="nom" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="idcommune" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="x" Type="Double" />
          <Property Name="y" Type="Double" />
        </EntityType>
        <EntityType Name="transportitineraire">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="annee" Type="Double" />
          <Property Name="code" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="nom" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="fonctionnement" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="typeservice" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="sens" Type="String" MaxLength="1" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="typebourse">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="code" Type="Decimal" Precision="2" Scale="0" />
          <Property Name="libelle" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="typeetablissement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
        </EntityType>
        <Association Name="fk_commune_canton">
          <End Role="canton" Type="Self.canton" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="commune" Type="Self.commune" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="canton">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="commune">
              <PropertyRef Name="idcanton" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="fk_elevecs_cs">
          <End Role="cartescolaire" Type="Self.cartescolaire" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="elevecartescolaire" Type="Self.elevecartescolaire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="cartescolaire">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="elevecartescolaire">
              <PropertyRef Name="idcartescolaire" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="fk_simulationannee_cs">
          <End Role="cartescolaire" Type="Self.cartescolaire" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="simulationannee" Type="Self.simulationannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="cartescolaire">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="simulationannee">
              <PropertyRef Name="idcartescolaire" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="fk_urbanisationcs_cs">
          <End Role="cartescolaire" Type="Self.cartescolaire" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="urbanisationcartescolaire" Type="Self.urbanisationcartescolaire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="cartescolaire">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="urbanisationcartescolaire">
              <PropertyRef Name="idcartescolaire" />
            </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>
        <Association Name="FK_UrbaCS">
          <End Role="communeurbanisationannee" Type="Self.communeurbanisationannee" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="urbanisationcartescolaire" Type="Self.urbanisationcartescolaire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="communeurbanisationannee">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="urbanisationcartescolaire">
              <PropertyRef Name="idurbanisation" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EleveAnneeCode">
          <End Role="eleve" Type="Self.eleve" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="eleveannee" Type="Self.eleveannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="eleve">
              <PropertyRef Name="code" />
            </Principal>
            <Dependent Role="eleveannee">
              <PropertyRef Name="code" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabCS">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabcartescolaire" Type="Self.etabcartescolaire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabcartescolaire">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabCSCommune">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabcartescolairecommune" Type="Self.etabcartescolairecommune" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabcartescolairecommune">
              <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_EtabEquipAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabequipementannee" Type="Self.etabequipementannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabequipementannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabEquipProcheAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabequipementprocheannee" Type="Self.etabequipementprocheannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabequipementprocheannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <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_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_etabregie_etab">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etablissementregie" Type="Self.etablissementregie" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etablissementregie">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabsallesannee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabsallesannee" Type="Self.etabsallesannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabsallesannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabsegpa">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabsegpa" Type="Self.etabsegpa" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabsegpa">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabsousgroupeannee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabsousgroupeannee" Type="Self.etabsousgroupeannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabsousgroupeannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabtosannee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabtosannee" Type="Self.etabtosannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabtosannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_etabtravauxannee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabtravauxannee" Type="Self.etabtravauxannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabtravauxannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_simulationresultats">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="simulationresultats" Type="Self.simulationresultats" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="simulationresultats">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_simulationresurbanisation">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="simulationresurbanisation" Type="Self.simulationresurbanisation" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="simulationresurbanisation">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_simulationresurbanisationsimu">
          <End Role="simulationannee" Type="Self.simulationannee" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="simulationresurbanisation" Type="Self.simulationresurbanisation" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="simulationannee">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="simulationresurbanisation">
              <PropertyRef Name="idsimulation" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="anneescolaire" EntityType="Self.anneescolaire" />
          <EntitySet Name="bassin" EntityType="Self.bassin" />
          <EntitySet Name="canton" EntityType="Self.canton" />
          <EntitySet Name="carte" EntityType="Self.carte" />
          <EntitySet Name="cartescolaire" EntityType="Self.cartescolaire" />
          <EntitySet Name="commune" EntityType="Self.commune" />
          <EntitySet Name="communeurbanisationannee" EntityType="Self.communeurbanisationannee" />
          <EntitySet Name="couleur" EntityType="Self.couleur" />
          <EntitySet Name="eleve" EntityType="Self.eleve" />
          <EntitySet Name="eleveannee" EntityType="Self.eleveannee" />
          <EntitySet Name="elevecartescolaire" EntityType="Self.elevecartescolaire" />
          <EntitySet Name="etabcartescolaire" EntityType="Self.etabcartescolaire" />
          <EntitySet Name="etabcartescolairecommune" EntityType="Self.etabcartescolairecommune" />
          <EntitySet Name="etabclasseannee" EntityType="Self.etabclasseannee" />
          <EntitySet Name="etabeffectifannee" EntityType="Self.etabeffectifannee" />
          <EntitySet Name="etabequipementannee" EntityType="Self.etabequipementannee" />
          <EntitySet Name="etabequipementprocheannee" EntityType="Self.etabequipementprocheannee" />
          <EntitySet Name="etablissement" EntityType="Self.etablissement" />
          <EntitySet Name="etablissementannee" EntityType="Self.etablissementannee" />
          <EntitySet Name="etablissementregie" EntityType="Self.etablissementregie" />
          <EntitySet Name="etaboptionsannee" EntityType="Self.etaboptionsannee" />
          <EntitySet Name="etabsallesannee" EntityType="Self.etabsallesannee" />
          <EntitySet Name="etabsegpa" EntityType="Self.etabsegpa" />
          <EntitySet Name="etabsousgroupeannee" EntityType="Self.etabsousgroupeannee" />
          <EntitySet Name="etabtosannee" EntityType="Self.etabtosannee" />
          <EntitySet Name="etabtravauxannee" EntityType="Self.etabtravauxannee" />
          <EntitySet Name="filiere" EntityType="Self.filiere" />
          <EntitySet Name="grandbassin" EntityType="Self.grandbassin" />
          <EntitySet Name="matiereoption" EntityType="Self.matiereoption" />
          <EntitySet Name="mef" EntityType="Self.mef" />
          <EntitySet Name="mission" EntityType="Self.mission" />
          <EntitySet Name="nationalite" EntityType="Self.nationalite" />
          <EntitySet Name="niveau" EntityType="Self.niveau" />
          <EntitySet Name="previsibilite" EntityType="Self.previsibilite" />
          <EntitySet Name="regierestauration" EntityType="Self.regierestauration" />
          <EntitySet Name="rpi" EntityType="Self.rpi" />
          <EntitySet Name="rues" EntityType="Self.rues" />
          <EntitySet Name="ruescomplement" EntityType="Self.ruescomplement" />
          <EntitySet Name="segpa" EntityType="Self.segpa" />
          <EntitySet Name="simulationannee" EntityType="Self.simulationannee" />
          <EntitySet Name="simulationresultats" EntityType="Self.simulationresultats" />
          <EntitySet Name="simulationresurbanisation" EntityType="Self.simulationresurbanisation" />
          <EntitySet Name="thematique" EntityType="Self.thematique" />
          <EntitySet Name="thematiques" EntityType="Self.thematiques" />
          <EntitySet Name="thematiquescommunes" EntityType="Self.thematiquescommunes" />
          <EntitySet Name="thematiqueseleves" EntityType="Self.thematiqueseleves" />
          <EntitySet Name="thematiquesetab" EntityType="Self.thematiquesetab" />
          <EntitySet Name="typelogement" EntityType="Self.typelogement" />
          <EntitySet Name="typesalle" EntityType="Self.typesalle" />
          <EntitySet Name="ulis" EntityType="Self.ulis" />
          <EntitySet Name="urbanisationcartescolaire" EntityType="Self.urbanisationcartescolaire" />
          <EntitySet Name="utilisateur" EntityType="Self.utilisateur" />
          <EntitySet Name="classement" EntityType="Self.classement" />
          <EntitySet Name="classeniveau" EntityType="Self.classeniveau" />
          <EntitySet Name="commune_ok" EntityType="Self.commune_ok" />
          <EntitySet Name="communeannee" EntityType="Self.communeannee" />
          <EntitySet Name="communehabitants" EntityType="Self.communehabitants" />
          <EntitySet Name="communeurbanisationparcelle" EntityType="Self.communeurbanisationparcelle" />
          <EntitySet Name="csp" EntityType="Self.csp" />
          <EntitySet Name="etab_ok" EntityType="Self.etab_ok" />
          <EntitySet Name="parcelle" EntityType="Self.parcelle" />
          <EntitySet Name="plan" EntityType="Self.plan" />
          <EntitySet Name="rue_ok" EntityType="Self.rue_ok" />
          <EntitySet Name="simulationetabcrees" EntityType="Self.simulationetabcrees" />
          <EntitySet Name="simulationetabsupprimes" EntityType="Self.simulationetabsupprimes" />
          <EntitySet Name="transport_iti_arret" EntityType="Self.transport_iti_arret" />
          <EntitySet Name="transportarret" EntityType="Self.transportarret" />
          <EntitySet Name="transportitineraire" EntityType="Self.transportitineraire" />
          <EntitySet Name="typebourse" EntityType="Self.typebourse" />
          <EntitySet Name="typeetablissement" EntityType="Self.typeetablissement" />
          <AssociationSet Name="fk_commune_canton" Association="Self.fk_commune_canton">
            <End Role="canton" EntitySet="canton" />
            <End Role="commune" EntitySet="commune" />
          </AssociationSet>
          <AssociationSet Name="fk_elevecs_cs" Association="Self.fk_elevecs_cs">
            <End Role="cartescolaire" EntitySet="cartescolaire" />
            <End Role="elevecartescolaire" EntitySet="elevecartescolaire" />
          </AssociationSet>
          <AssociationSet Name="fk_simulationannee_cs" Association="Self.fk_simulationannee_cs">
            <End Role="cartescolaire" EntitySet="cartescolaire" />
            <End Role="simulationannee" EntitySet="simulationannee" />
          </AssociationSet>
          <AssociationSet Name="fk_urbanisationcs_cs" Association="Self.fk_urbanisationcs_cs">
            <End Role="cartescolaire" EntitySet="cartescolaire" />
            <End Role="urbanisationcartescolaire" EntitySet="urbanisationcartescolaire" />
          </AssociationSet>
          <AssociationSet Name="FK_RuesCommunes" Association="Self.FK_RuesCommunes">
            <End Role="commune" EntitySet="commune" />
            <End Role="rues" EntitySet="rues" />
          </AssociationSet>
          <AssociationSet Name="FK_UrbaCS" Association="Self.FK_UrbaCS">
            <End Role="communeurbanisationannee" EntitySet="communeurbanisationannee" />
            <End Role="urbanisationcartescolaire" EntitySet="urbanisationcartescolaire" />
          </AssociationSet>
          <AssociationSet Name="FK_EleveAnneeCode" Association="Self.FK_EleveAnneeCode">
            <End Role="eleve" EntitySet="eleve" />
            <End Role="eleveannee" EntitySet="eleveannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabCS" Association="Self.FK_EtabCS">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabcartescolaire" EntitySet="etabcartescolaire" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabCSCommune" Association="Self.FK_EtabCSCommune">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabcartescolairecommune" EntitySet="etabcartescolairecommune" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabEffectifAnnee" Association="Self.FK_EtabEffectifAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabeffectifannee" EntitySet="etabeffectifannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabEquipAnnee" Association="Self.FK_EtabEquipAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabequipementannee" EntitySet="etabequipementannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabEquipProcheAnnee" Association="Self.FK_EtabEquipProcheAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabequipementprocheannee" EntitySet="etabequipementprocheannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabAnnee" Association="Self.FK_EtabAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etablissementannee" EntitySet="etablissementannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabOptionsAnnee" Association="Self.FK_EtabOptionsAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etaboptionsannee" EntitySet="etaboptionsannee" />
          </AssociationSet>
          <AssociationSet Name="fk_etabregie_etab" Association="Self.fk_etabregie_etab">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etablissementregie" EntitySet="etablissementregie" />
          </AssociationSet>
          <AssociationSet Name="FK_etabsallesannee" Association="Self.FK_etabsallesannee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabsallesannee" EntitySet="etabsallesannee" />
          </AssociationSet>
          <AssociationSet Name="FK_etabsegpa" Association="Self.FK_etabsegpa">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabsegpa" EntitySet="etabsegpa" />
          </AssociationSet>
          <AssociationSet Name="FK_etabsousgroupeannee" Association="Self.FK_etabsousgroupeannee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabsousgroupeannee" EntitySet="etabsousgroupeannee" />
          </AssociationSet>
          <AssociationSet Name="FK_etabtosannee" Association="Self.FK_etabtosannee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabtosannee" EntitySet="etabtosannee" />
          </AssociationSet>
          <AssociationSet Name="FK_etabtravauxannee" Association="Self.FK_etabtravauxannee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabtravauxannee" EntitySet="etabtravauxannee" />
          </AssociationSet>
          <AssociationSet Name="FK_simulationresultats" Association="Self.FK_simulationresultats">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="simulationresultats" EntitySet="simulationresultats" />
          </AssociationSet>
          <AssociationSet Name="FK_simulationresurbanisation" Association="Self.FK_simulationresurbanisation">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="simulationresurbanisation" EntitySet="simulationresurbanisation" />
          </AssociationSet>
          <AssociationSet Name="FK_simulationresurbanisationsimu" Association="Self.FK_simulationresurbanisationsimu">
            <End Role="simulationannee" EntitySet="simulationannee" />
            <End Role="simulationresurbanisation" EntitySet="simulationresurbanisation" />
          </AssociationSet>
        </EntityContainer>
      </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="Entities">
          <EntitySetMapping Name="anneescolaire">
            <EntityTypeMapping TypeName="educfModel.anneescolaire">
              <MappingFragment StoreEntitySet="anneescolaire">
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="nbanscalcultap" ColumnName="nbanscalcultap" />
                <ScalarProperty Name="nbanscalcultap2" ColumnName="nbanscalcultap2" />
                <ScalarProperty Name="datecalcultap" ColumnName="datecalcultap" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="bassin">
            <EntityTypeMapping TypeName="educfModel.bassin">
              <MappingFragment StoreEntitySet="bassin">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="idgrandbassin" ColumnName="idgrandbassin" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="canton">
            <EntityTypeMapping TypeName="educfModel.canton">
              <MappingFragment StoreEntitySet="canton">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="responsable1" ColumnName="responsable1" />
                <ScalarProperty Name="responsable2" ColumnName="responsable2" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="carte">
            <EntityTypeMapping TypeName="educfModel.carte">
              <MappingFragment StoreEntitySet="carte">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="posx" ColumnName="posx" />
                <ScalarProperty Name="posy" ColumnName="posy" />
                <ScalarProperty Name="zoom" ColumnName="zoom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="cartescolaire">
            <EntityTypeMapping TypeName="educfModel.cartescolaire">
              <MappingFragment StoreEntitySet="cartescolaire">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="adresseoptbd" ColumnName="adresseoptbd" />
                <ScalarProperty Name="adressenomcouche" ColumnName="adressenomcouche" />
                <ScalarProperty Name="adressenomchamp" ColumnName="adressenomchamp" />
                <ScalarProperty Name="adressenomchampprim" ColumnName="adressenomchampprim" />
                <ScalarProperty Name="voieoptbd" ColumnName="voieoptbd" />
                <ScalarProperty Name="voienomcouche" ColumnName="voienomcouche" />
                <ScalarProperty Name="voienomchamp" ColumnName="voienomchamp" />
                <ScalarProperty Name="voienomchampprim" ColumnName="voienomchampprim" />
                <ScalarProperty Name="etablissementoptbd" ColumnName="etablissementoptbd" />
                <ScalarProperty Name="etablissementnomcouche" ColumnName="etablissementnomcouche" />
                <ScalarProperty Name="etablissementnomchamp" ColumnName="etablissementnomchamp" />
                <ScalarProperty Name="etablissementnomchampprim" ColumnName="etablissementnomchampprim" />
                <ScalarProperty Name="ecoleoptbd" ColumnName="ecoleoptbd" />
                <ScalarProperty Name="ecolenomcouche" ColumnName="ecolenomcouche" />
                <ScalarProperty Name="ecolenomchamp1" ColumnName="ecolenomchamp1" />
                <ScalarProperty Name="ecolenomchampratio1" ColumnName="ecolenomchampratio1" />
                <ScalarProperty Name="ecolenomchamp2" ColumnName="ecolenomchamp2" />
                <ScalarProperty Name="ecolenomchampratio2" ColumnName="ecolenomchampratio2" />
                <ScalarProperty Name="datederniercalcul" ColumnName="datederniercalcul" />
                <ScalarProperty Name="adressenomchampdistance" ColumnName="adressenomchampdistance" />
                <ScalarProperty Name="adressenomchampdistanceprim" ColumnName="adressenomchampdistanceprim" />
                <ScalarProperty Name="parcellenomchampdistance" ColumnName="parcellenomchampdistance" />
                <ScalarProperty Name="parcellenomchampdistanceprim" ColumnName="parcellenomchampdistanceprim" />
                <ScalarProperty Name="parcellenomchamp" ColumnName="parcellenomchamp" />
                <ScalarProperty Name="parcellenomchampprim" ColumnName="parcellenomchampprim" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="commune">
            <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="communeurbanisationannee">
            <EntityTypeMapping TypeName="educfModel.communeurbanisationannee">
              <MappingFragment StoreEntitySet="communeurbanisationannee">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idcommune" ColumnName="idcommune" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="nomprogramme" ColumnName="nomprogramme" />
                <ScalarProperty Name="nature" ColumnName="nature" />
                <ScalarProperty Name="adresse" ColumnName="adresse" />
                <ScalarProperty Name="debut" ColumnName="debut" />
                <ScalarProperty Name="fin" ColumnName="fin" />
                <ScalarProperty Name="budgetprevu" ColumnName="budgetprevu" />
                <ScalarProperty Name="budgetreel" ColumnName="budgetreel" />
                <ScalarProperty Name="motifecart" ColumnName="motifecart" />
                <ScalarProperty Name="subvention" ColumnName="subvention" />
                <ScalarProperty Name="typelogements" ColumnName="typelogements" />
                <ScalarProperty Name="anneedebut" ColumnName="anneedebut" />
                <ScalarProperty Name="numadresse" ColumnName="numadresse" />
                <ScalarProperty Name="idrue" ColumnName="idrue" />
                <ScalarProperty Name="dateimport" ColumnName="dateimport" />
                <ScalarProperty Name="datemodif" ColumnName="datemodif" />
                <ScalarProperty Name="nblogements" ColumnName="nblogements" />
                <ScalarProperty Name="nbeleves" ColumnName="nbeleves" />
                <ScalarProperty Name="nblogementsrenouv" ColumnName="nblogementsrenouv" />
                <ScalarProperty Name="idtypelogement" ColumnName="idtypelogement" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="couleur">
            <EntityTypeMapping TypeName="educfModel.couleur">
              <MappingFragment StoreEntitySet="couleur">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="r" ColumnName="r" />
                <ScalarProperty Name="v" ColumnName="v" />
                <ScalarProperty Name="b" ColumnName="b" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="eleve">
            <EntityTypeMapping TypeName="educfModel.eleve">
              <MappingFragment StoreEntitySet="eleve">
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="numadresse" ColumnName="numadresse" />
                <ScalarProperty Name="idrue" ColumnName="idrue" />
                <ScalarProperty Name="adresse2" ColumnName="adresse2" />
                <ScalarProperty Name="idcsp" ColumnName="idcsp" />
                <ScalarProperty Name="datenaissance" ColumnName="datenaissance" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="prenom" ColumnName="prenom" />
                <ScalarProperty Name="sexe" ColumnName="sexe" />
                <ScalarProperty Name="nationalite" ColumnName="nationalite" />
                <ScalarProperty Name="ilotinsee" ColumnName="ilotinsee" />
                <ScalarProperty Name="posx" ColumnName="posx" />
                <ScalarProperty Name="posy" ColumnName="posy" />
                <ScalarProperty Name="idfamille" ColumnName="idfamille" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="eleveannee">
            <EntityTypeMapping TypeName="educfModel.eleveannee">
              <MappingFragment StoreEntitySet="eleveannee">
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="idniveau" ColumnName="idniveau" />
                <ScalarProperty Name="inscritrs" ColumnName="inscritrs" />
                <ScalarProperty Name="inscritts" ColumnName="inscritts" />
                <ScalarProperty Name="interne" ColumnName="interne" />
                <ScalarProperty Name="ititransport" ColumnName="ititransport" />
                <ScalarProperty Name="arret8h" ColumnName="arret8h" />
                <ScalarProperty Name="arret12h" ColumnName="arret12h" />
                <ScalarProperty Name="arret14h" ColumnName="arret14h" />
                <ScalarProperty Name="arret17h" ColumnName="arret17h" />
                <ScalarProperty Name="classe" ColumnName="classe" />
                <ScalarProperty Name="idfiliere" ColumnName="idfiliere" />
                <ScalarProperty Name="optboursier" ColumnName="optboursier" />
                <ScalarProperty Name="typebourse" ColumnName="typebourse" />
                <ScalarProperty Name="optderogation" ColumnName="optderogation" />
                <ScalarProperty Name="optcl" ColumnName="optcl" />
                <ScalarProperty Name="idetabprec" ColumnName="idetabprec" />
                <ScalarProperty Name="idniveauprec" ColumnName="idniveauprec" />
                <ScalarProperty Name="idoption1" ColumnName="idoption1" />
                <ScalarProperty Name="idoption2" ColumnName="idoption2" />
                <ScalarProperty Name="idoption3" ColumnName="idoption3" />
                <ScalarProperty Name="idoption4" ColumnName="idoption4" />
                <ScalarProperty Name="nonredoublant" ColumnName="nonredoublant" />
                <ScalarProperty Name="idclasse" ColumnName="idclasse" />
                <ScalarProperty Name="idsousgroupe" ColumnName="idsousgroupe" />
                <ScalarProperty Name="qf" ColumnName="qf" />
                <ScalarProperty Name="idoption5" ColumnName="idoption5" />
                <ScalarProperty Name="idmef" ColumnName="idmef" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="elevecartescolaire">
            <EntityTypeMapping TypeName="educfModel.elevecartescolaire">
              <MappingFragment StoreEntitySet="elevecartescolaire">
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="idcartescolaire" ColumnName="idcartescolaire" />
                <ScalarProperty Name="idetabsecteur" ColumnName="idetabsecteur" />
                <ScalarProperty Name="idetabsecteursuiv" ColumnName="idetabsecteursuiv" />
                <ScalarProperty Name="id_elevecs" ColumnName="id_elevecs" />
                <ScalarProperty Name="idetabsecteurprec" ColumnName="idetabsecteurprec" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabcartescolaire">
            <EntityTypeMapping TypeName="educfModel.etabcartescolaire">
              <MappingFragment StoreEntitySet="etabcartescolaire">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="idrue" ColumnName="idrue" />
                <ScalarProperty Name="debut" ColumnName="debut" />
                <ScalarProperty Name="fin" ColumnName="fin" />
                <ScalarProperty Name="pairimpair" ColumnName="pairimpair" />
                <ScalarProperty Name="proximite" ColumnName="proximite" />
                <ScalarProperty Name="accessibilite" ColumnName="accessibilite" />
                <ScalarProperty Name="idcartescolaire" ColumnName="idcartescolaire" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabcartescolairecommune">
            <EntityTypeMapping TypeName="educfModel.etabcartescolairecommune">
              <MappingFragment StoreEntitySet="etabcartescolairecommune">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="idcommune" ColumnName="idcommune" />
                <ScalarProperty Name="idcartescolaire" ColumnName="idcartescolaire" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabclasseannee">
            <EntityTypeMapping TypeName="educfModel.etabclasseannee">
              <MappingFragment StoreEntitySet="etabclasseannee">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idsousgroupe" ColumnName="idsousgroupe" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="effectif" ColumnName="effectif" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabeffectifannee">
            <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="etabequipementannee">
            <EntityTypeMapping TypeName="educfModel.etabequipementannee">
              <MappingFragment StoreEntitySet="etabequipementannee">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="capacite" ColumnName="capacite" />
                <ScalarProperty Name="superficie" ColumnName="superficie" />
                <ScalarProperty Name="nbsalles" ColumnName="nbsalles" />
                <ScalarProperty Name="gardien" ColumnName="gardien" />
                <ScalarProperty Name="contact" ColumnName="contact" />
                <ScalarProperty Name="vestiaire" ColumnName="vestiaire" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabequipementprocheannee">
            <EntityTypeMapping TypeName="educfModel.etabequipementprocheannee">
              <MappingFragment StoreEntitySet="etabequipementprocheannee">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="capacite" ColumnName="capacite" />
                <ScalarProperty Name="superficie" ColumnName="superficie" />
                <ScalarProperty Name="nbsalles" ColumnName="nbsalles" />
                <ScalarProperty Name="gardien" ColumnName="gardien" />
                <ScalarProperty Name="contact" ColumnName="contact" />
                <ScalarProperty Name="vestiaire" ColumnName="vestiaire" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etablissement">
            <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="etablissementannee">
            <EntityTypeMapping TypeName="educfModel.etablissementannee">
              <MappingFragment StoreEntitySet="etablissementannee">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="nbeleves" ColumnName="nbeleves" />
                <ScalarProperty Name="capaciteinternes" ColumnName="capaciteinternes" />
                <ScalarProperty Name="capacitedemipension" ColumnName="capacitedemipension" />
                <ScalarProperty Name="capaciteeleves" ColumnName="capaciteeleves" />
                <ScalarProperty Name="effectifmaximal" ColumnName="effectifmaximal" />
                <ScalarProperty Name="classesprevues" ColumnName="classesprevues" />
                <ScalarProperty Name="elevessecteur" ColumnName="elevessecteur" />
                <ScalarProperty Name="eleveshorssecteur" ColumnName="eleveshorssecteur" />
                <ScalarProperty Name="niveauremplissage" ColumnName="niveauremplissage" />
                <ScalarProperty Name="demipensionnaires" ColumnName="demipensionnaires" />
                <ScalarProperty Name="responsable" ColumnName="responsable" />
                <ScalarProperty Name="gestionnaire" ColumnName="gestionnaire" />
                <ScalarProperty Name="nbenseignants" ColumnName="nbenseignants" />
                <ScalarProperty Name="nbadministratifs" ColumnName="nbadministratifs" />
                <ScalarProperty Name="nbautrepersonnel" ColumnName="nbautrepersonnel" />
                <ScalarProperty Name="optzep" ColumnName="optzep" />
                <ScalarProperty Name="optrep" ColumnName="optrep" />
                <ScalarProperty Name="capacitearchi" ColumnName="capacitearchi" />
                <ScalarProperty Name="optrar" ColumnName="optrar" />
                <ScalarProperty Name="ien" ColumnName="ien" />
                <ScalarProperty Name="capacitesegpa" ColumnName="capacitesegpa" />
                <ScalarProperty Name="internes" ColumnName="internes" />
                <ScalarProperty Name="nbsegpa" ColumnName="nbsegpa" />
                <ScalarProperty Name="rpi" ColumnName="rpi" />
                <ScalarProperty Name="optrpi" ColumnName="optrpi" />
                <ScalarProperty Name="nbhandi" ColumnName="nbhandi" />
                <ScalarProperty Name="nbtechno" ColumnName="nbtechno" />
                <ScalarProperty Name="nbupi" ColumnName="nbupi" />
                <ScalarProperty Name="nbcham" ColumnName="nbcham" />
                <ScalarProperty Name="nbsport" ColumnName="nbsport" />
                <ScalarProperty Name="capacitedivisions" ColumnName="capacitedivisions" />
                <ScalarProperty Name="nbdivisions" ColumnName="nbdivisions" />
                <ScalarProperty Name="nbgene" ColumnName="nbgene" />
                <ScalarProperty Name="nbulis" ColumnName="nbulis" />
                <ScalarProperty Name="nbdima" ColumnName="nbdima" />
                <ScalarProperty Name="principaladjoint" ColumnName="principaladjoint" />
                <ScalarProperty Name="mailgestionnaire" ColumnName="mailgestionnaire" />
                <ScalarProperty Name="mailresponsable" ColumnName="mailresponsable" />
                <ScalarProperty Name="nbupe2a" ColumnName="nbupe2a" />
                <ScalarProperty Name="dotation" ColumnName="dotation" />
                <ScalarProperty Name="nbcpsfavorisea" ColumnName="nbcpsfavorisea" />
                <ScalarProperty Name="nbcpsfavoriseb" ColumnName="nbcpsfavoriseb" />
                <ScalarProperty Name="nbcpsdefavorise" ColumnName="nbcpsdefavorise" />
                <ScalarProperty Name="nbcpsmoyenne" ColumnName="nbcpsmoyenne" />
                <ScalarProperty Name="optrpiconcentre" ColumnName="optrpiconcentre" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etablissementregie">
            <EntityTypeMapping TypeName="educfModel.etablissementregie">
              <MappingFragment StoreEntitySet="etablissementregie">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="idregie" ColumnName="idregie" />
                <ScalarProperty Name="ratio" ColumnName="ratio" />
                <ScalarProperty Name="annee" ColumnName="annee" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etaboptionsannee">
            <EntityTypeMapping TypeName="educfModel.etaboptionsannee">
              <MappingFragment StoreEntitySet="etaboptionsannee">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="idoption" ColumnName="idoption" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabsallesannee">
            <EntityTypeMapping TypeName="educfModel.etabsallesannee">
              <MappingFragment StoreEntitySet="etabsallesannee">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="nbsalles" ColumnName="nbsalles" />
                <ScalarProperty Name="idtypesalle" ColumnName="idtypesalle" />
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="surface" ColumnName="surface" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabsegpa">
            <EntityTypeMapping TypeName="educfModel.etabsegpa">
              <MappingFragment StoreEntitySet="etabsegpa">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="idsegpa" ColumnName="idsegpa" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabsousgroupeannee">
            <EntityTypeMapping TypeName="educfModel.etabsousgroupeannee">
              <MappingFragment StoreEntitySet="etabsousgroupeannee">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="annee" ColumnName="annee" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabtosannee">
            <EntityTypeMapping TypeName="educfModel.etabtosannee">
              <MappingFragment StoreEntitySet="etabtosannee">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="mission1" ColumnName="mission1" />
                <ScalarProperty Name="quotite" ColumnName="quotite" />
                <ScalarProperty Name="duree1" ColumnName="duree1" />
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="mission2" ColumnName="mission2" />
                <ScalarProperty Name="duree2" ColumnName="duree2" />
                <ScalarProperty Name="mission3" ColumnName="mission3" />
                <ScalarProperty Name="duree3" ColumnName="duree3" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabtravauxannee">
            <EntityTypeMapping TypeName="educfModel.etabtravauxannee">
              <MappingFragment StoreEntitySet="etabtravauxannee">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="nature" ColumnName="nature" />
                <ScalarProperty Name="previsibilite" ColumnName="previsibilite" />
                <ScalarProperty Name="motifurgence" ColumnName="motifurgence" />
                <ScalarProperty Name="debut" ColumnName="debut" />
                <ScalarProperty Name="fin" ColumnName="fin" />
                <ScalarProperty Name="budgetprevu" ColumnName="budgetprevu" />
                <ScalarProperty Name="budgetreel" ColumnName="budgetreel" />
                <ScalarProperty Name="motifecart" ColumnName="motifecart" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="filiere">
            <EntityTypeMapping TypeName="educfModel.filiere">
              <MappingFragment StoreEntitySet="filiere">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="libelle" ColumnName="libelle" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="grandbassin">
            <EntityTypeMapping TypeName="educfModel.grandbassin">
              <MappingFragment StoreEntitySet="grandbassin">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="matiereoption">
            <EntityTypeMapping TypeName="educfModel.matiereoption">
              <MappingFragment StoreEntitySet="matiereoption">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="nomcourt" ColumnName="nomcourt" />
                <ScalarProperty Name="nomlong" ColumnName="nomlong" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="mef">
            <EntityTypeMapping TypeName="educfModel.mef">
              <MappingFragment StoreEntitySet="mef">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="mefst11" ColumnName="mefst11" />
                <ScalarProperty Name="nomcourt" ColumnName="nomcourt" />
                <ScalarProperty Name="nomlong" ColumnName="nomlong" />
                <ScalarProperty Name="idniveau" ColumnName="idniveau" />
                <ScalarProperty Name="idfiliere" ColumnName="idfiliere" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="mission">
            <EntityTypeMapping TypeName="educfModel.mission">
              <MappingFragment StoreEntitySet="mission">
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="nationalite">
            <EntityTypeMapping TypeName="educfModel.nationalite">
              <MappingFragment StoreEntitySet="nationalite">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="libelle" ColumnName="libelle" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="niveau">
            <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="previsibilite">
            <EntityTypeMapping TypeName="educfModel.previsibilite">
              <MappingFragment StoreEntitySet="previsibilite">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="regierestauration">
            <EntityTypeMapping TypeName="educfModel.regierestauration">
              <MappingFragment StoreEntitySet="regierestauration">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idrue" ColumnName="idrue" />
                <ScalarProperty Name="numadresse" ColumnName="numadresse" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="capacite" ColumnName="capacite" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="rpi">
            <EntityTypeMapping TypeName="educfModel.rpi">
              <MappingFragment StoreEntitySet="rpi">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="rues">
            <EntityTypeMapping TypeName="educfModel.rues">
              <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="ruescomplement">
            <EntityTypeMapping TypeName="educfModel.ruescomplement">
              <MappingFragment StoreEntitySet="ruescomplement">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idrue" ColumnName="idrue" />
                <ScalarProperty Name="complement" ColumnName="complement" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="segpa">
            <EntityTypeMapping TypeName="educfModel.segpa">
              <MappingFragment StoreEntitySet="segpa">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="simulationannee">
            <EntityTypeMapping TypeName="educfModel.simulationannee">
              <MappingFragment StoreEntitySet="simulationannee">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="monteepedagogique" ColumnName="monteepedagogique" />
                <ScalarProperty Name="tap" ColumnName="tap" />
                <ScalarProperty Name="ratios" ColumnName="ratios" />
                <ScalarProperty Name="evitement" ColumnName="evitement" />
                <ScalarProperty Name="idcartescolaire" ColumnName="idcartescolaire" />
                <ScalarProperty Name="tapsec" ColumnName="tapsec" />
                <ScalarProperty Name="datecalcul" ColumnName="datecalcul" />
                <ScalarProperty Name="apportprogressif" ColumnName="apportprogressif" />
                <ScalarProperty Name="idcartescolaire2" ColumnName="idcartescolaire2" />
                <ScalarProperty Name="anneecartescolaire2" ColumnName="anneecartescolaire2" />
                <ScalarProperty Name="optcartescolaire2" ColumnName="optcartescolaire2" />
                <ScalarProperty Name="optapportglobal" ColumnName="optapportglobal" />
                <ScalarProperty Name="optprevisionficheetab" ColumnName="optprevisionficheetab" />
                <ScalarProperty Name="opttapdepartemental" ColumnName="opttapdepartemental" />
                <ScalarProperty Name="optmonteeadresse" ColumnName="optmonteeadresse" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="simulationresultats">
            <EntityTypeMapping TypeName="educfModel.simulationresultats">
              <MappingFragment StoreEntitySet="simulationresultats">
                <ScalarProperty Name="idsimulation" ColumnName="idsimulation" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="idniveau" ColumnName="idniveau" />
                <ScalarProperty Name="effectif" ColumnName="effectif" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="effectifurba" ColumnName="effectifurba" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="simulationresurbanisation">
            <EntityTypeMapping TypeName="educfModel.simulationresurbanisation">
              <MappingFragment StoreEntitySet="simulationresurbanisation">
                <ScalarProperty Name="idsimulation" ColumnName="idsimulation" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="effectif" ColumnName="effectif" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="thematique">
            <EntityTypeMapping TypeName="educfModel.thematique">
              <MappingFragment StoreEntitySet="thematique">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="couleur" ColumnName="couleur" />
                <ScalarProperty Name="valeurmin" ColumnName="valeurmin" />
                <ScalarProperty Name="valeurmax" ColumnName="valeurmax" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="thematiques">
            <EntityTypeMapping TypeName="educfModel.thematiques">
              <MappingFragment StoreEntitySet="thematiques">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="couche" ColumnName="couche" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="thematiquescommunes">
            <EntityTypeMapping TypeName="educfModel.thematiquescommunes">
              <MappingFragment StoreEntitySet="thematiquescommunes">
                <ScalarProperty Name="insee" ColumnName="insee" />
                <ScalarProperty Name="nbelpublic" ColumnName="nbelpublic" />
                <ScalarProperty Name="nbelprive" ColumnName="nbelprive" />
                <ScalarProperty Name="nbnaissances" ColumnName="nbnaissances" />
                <ScalarProperty Name="nbelprimaire" ColumnName="nbelprimaire" />
                <ScalarProperty Name="nblogementsan1" ColumnName="nblogementsan1" />
                <ScalarProperty Name="nblogementsan2" ColumnName="nblogementsan2" />
                <ScalarProperty Name="nblogementsan3" ColumnName="nblogementsan3" />
                <ScalarProperty Name="nblogementsan4" ColumnName="nblogementsan4" />
                <ScalarProperty Name="nblogementsan5" ColumnName="nblogementsan5" />
                <ScalarProperty Name="rneetabsecteur" ColumnName="rneetabsecteur" />
                <ScalarProperty Name="anneereel" ColumnName="anneereel" />
                <ScalarProperty Name="anneesimu" ColumnName="anneesimu" />
                <ScalarProperty Name="nbelpublicsimu" ColumnName="nbelpublicsimu" />
                <ScalarProperty Name="nbelprivesimu" ColumnName="nbelprivesimu" />
                <ScalarProperty Name="superficie" ColumnName="superficie" />
                <ScalarProperty Name="densitecollegiens" ColumnName="densitecollegiens" />
                <ScalarProperty Name="nbhabitants" ColumnName="nbhabitants" />
                <ScalarProperty Name="densitepop" ColumnName="densitepop" />
                <ScalarProperty Name="nongeolocalises" ColumnName="nongeolocalises" />
                <ScalarProperty Name="nongeolocalisesprive" ColumnName="nongeolocalisesprive" />
                <ScalarProperty Name="rpi" ColumnName="rpi" />
                <ScalarProperty Name="effreel2007" ColumnName="effreel2007" />
                <ScalarProperty Name="effreel2008" ColumnName="effreel2008" />
                <ScalarProperty Name="effreel2009" ColumnName="effreel2009" />
                <ScalarProperty Name="effreel2010" ColumnName="effreel2010" />
                <ScalarProperty Name="effreel2011" ColumnName="effreel2011" />
                <ScalarProperty Name="effreel2012" ColumnName="effreel2012" />
                <ScalarProperty Name="effreel2013" ColumnName="effreel2013" />
                <ScalarProperty Name="excedentreel2007" ColumnName="excedentreel2007" />
                <ScalarProperty Name="excedentreel2008" ColumnName="excedentreel2008" />
                <ScalarProperty Name="excedentreel2009" ColumnName="excedentreel2009" />
                <ScalarProperty Name="excedentreel2010" ColumnName="excedentreel2010" />
                <ScalarProperty Name="excedentreel2011" ColumnName="excedentreel2011" />
                <ScalarProperty Name="excedentreel2012" ColumnName="excedentreel2012" />
                <ScalarProperty Name="excedentreel2013" ColumnName="excedentreel2013" />
                <ScalarProperty Name="effreel2014" ColumnName="effreel2014" />
                <ScalarProperty Name="excedentreel2014" ColumnName="excedentreel2014" />
                <ScalarProperty Name="effreel2015" ColumnName="effreel2015" />
                <ScalarProperty Name="excedentreel2015" ColumnName="excedentreel2015" />
                <ScalarProperty Name="effreel2016" ColumnName="effreel2016" />
                <ScalarProperty Name="excedentreel2016" ColumnName="excedentreel2016" />
                <ScalarProperty Name="effreel2017" ColumnName="effreel2017" />
                <ScalarProperty Name="excedentreel2017" ColumnName="excedentreel2017" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="thematiqueseleves">
            <EntityTypeMapping TypeName="educfModel.thematiqueseleves">
              <MappingFragment StoreEntitySet="thematiqueseleves">
                <ScalarProperty Name="numnominsee" ColumnName="numnominsee" />
                <ScalarProperty Name="nbelpublic" ColumnName="nbelpublic" />
                <ScalarProperty Name="nbelprive" ColumnName="nbelprive" />
                <ScalarProperty Name="nbnaissances" ColumnName="nbnaissances" />
                <ScalarProperty Name="nbelprimaire" ColumnName="nbelprimaire" />
                <ScalarProperty Name="nblogementsan1" ColumnName="nblogementsan1" />
                <ScalarProperty Name="nblogementsan2" ColumnName="nblogementsan2" />
                <ScalarProperty Name="nblogementsan3" ColumnName="nblogementsan3" />
                <ScalarProperty Name="nblogementsan4" ColumnName="nblogementsan4" />
                <ScalarProperty Name="nblogementsan5" ColumnName="nblogementsan5" />
                <ScalarProperty Name="nbcpsfavorisea" ColumnName="nbcpsfavorisea" />
                <ScalarProperty Name="nbcpsfavoriseb" ColumnName="nbcpsfavoriseb" />
                <ScalarProperty Name="nbcpsdefavorise" ColumnName="nbcpsdefavorise" />
                <ScalarProperty Name="nbcpsmoyenne" ColumnName="nbcpsmoyenne" />
                <ScalarProperty Name="rne" ColumnName="rne" />
                <ScalarProperty Name="nblogementstotal" ColumnName="nblogementstotal" />
                <ScalarProperty Name="rne1" ColumnName="rne1" />
                <ScalarProperty Name="rne2" ColumnName="rne2" />
                <ScalarProperty Name="rne3" ColumnName="rne3" />
                <ScalarProperty Name="rne4" ColumnName="rne4" />
                <ScalarProperty Name="rne5" ColumnName="rne5" />
                <ScalarProperty Name="rne6" ColumnName="rne6" />
                <ScalarProperty Name="effectif1" ColumnName="effectif1" />
                <ScalarProperty Name="effectif2" ColumnName="effectif2" />
                <ScalarProperty Name="effectif3" ColumnName="effectif3" />
                <ScalarProperty Name="effectif4" ColumnName="effectif4" />
                <ScalarProperty Name="effectif5" ColumnName="effectif5" />
                <ScalarProperty Name="effectif6" ColumnName="effectif6" />
                <ScalarProperty Name="ellogan1" ColumnName="ellogan1" />
                <ScalarProperty Name="matlogan1" ColumnName="matlogan1" />
                <ScalarProperty Name="ellogan2" ColumnName="ellogan2" />
                <ScalarProperty Name="matlogan2" ColumnName="matlogan2" />
                <ScalarProperty Name="ellogan3" ColumnName="ellogan3" />
                <ScalarProperty Name="matlogan3" ColumnName="matlogan3" />
                <ScalarProperty Name="ellogan4" ColumnName="ellogan4" />
                <ScalarProperty Name="matlogan4" ColumnName="matlogan4" />
                <ScalarProperty Name="ellogan5" ColumnName="ellogan5" />
                <ScalarProperty Name="matlogan5" ColumnName="matlogan5" />
                <ScalarProperty Name="ellogtotal" ColumnName="ellogtotal" />
                <ScalarProperty Name="matlogtotal" ColumnName="matlogtotal" />
                <ScalarProperty Name="oid" ColumnName="oid" />
                <ScalarProperty Name="nbelpublicapprox" ColumnName="nbelpublicapprox" />
                <ScalarProperty Name="nbelpriveapprox" ColumnName="nbelpriveapprox" />
                <ScalarProperty Name="numadresse" ColumnName="numadresse" />
                <ScalarProperty Name="idrue" ColumnName="idrue" />
                <ScalarProperty Name="totalpublic" ColumnName="totalpublic" />
                <ScalarProperty Name="totalprive" ColumnName="totalprive" />
                <ScalarProperty Name="totalsecteur" ColumnName="totalsecteur" />
                <ScalarProperty Name="totalhorssecteur" ColumnName="totalhorssecteur" />
                <ScalarProperty Name="matnbelpublic" ColumnName="matnbelpublic" />
                <ScalarProperty Name="matnbelprive" ColumnName="matnbelprive" />
                <ScalarProperty Name="matnbelpublicapprox" ColumnName="matnbelpublicapprox" />
                <ScalarProperty Name="matnbelpriveapprox" ColumnName="matnbelpriveapprox" />
                <ScalarProperty Name="mattotalpublic" ColumnName="mattotalpublic" />
                <ScalarProperty Name="mattotalprive" ColumnName="mattotalprive" />
                <ScalarProperty Name="mattotalsecteur" ColumnName="mattotalsecteur" />
                <ScalarProperty Name="mattotalhorssecteur" ColumnName="mattotalhorssecteur" />
                <ScalarProperty Name="matrne1" ColumnName="matrne1" />
                <ScalarProperty Name="matrne2" ColumnName="matrne2" />
                <ScalarProperty Name="matrne3" ColumnName="matrne3" />
                <ScalarProperty Name="matrne4" ColumnName="matrne4" />
                <ScalarProperty Name="matrne5" ColumnName="matrne5" />
                <ScalarProperty Name="matrne6" ColumnName="matrne6" />
                <ScalarProperty Name="mateffectif1" ColumnName="mateffectif1" />
                <ScalarProperty Name="mateffectif2" ColumnName="mateffectif2" />
                <ScalarProperty Name="mateffectif3" ColumnName="mateffectif3" />
                <ScalarProperty Name="mateffectif4" ColumnName="mateffectif4" />
                <ScalarProperty Name="mateffectif5" ColumnName="mateffectif5" />
                <ScalarProperty Name="mateffectif6" ColumnName="mateffectif6" />
                <ScalarProperty Name="dist" ColumnName="dist" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="thematiquesetab">
            <EntityTypeMapping TypeName="educfModel.thematiquesetab">
              <MappingFragment StoreEntitySet="thematiquesetab">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="anneereel" ColumnName="anneereel" />
                <ScalarProperty Name="anneesimu" ColumnName="anneesimu" />
                <ScalarProperty Name="effectifreel" ColumnName="effectifreel" />
                <ScalarProperty Name="effectifdpreel" ColumnName="effectifdpreel" />
                <ScalarProperty Name="nblogementsan1" ColumnName="nblogementsan1" />
                <ScalarProperty Name="nblogementsan2" ColumnName="nblogementsan2" />
                <ScalarProperty Name="nblogementsan3" ColumnName="nblogementsan3" />
                <ScalarProperty Name="nblogementsan4" ColumnName="nblogementsan4" />
                <ScalarProperty Name="nblogementsan5" ColumnName="nblogementsan5" />
                <ScalarProperty Name="effectifsimu" ColumnName="effectifsimu" />
                <ScalarProperty Name="capacite" ColumnName="capacite" />
                <ScalarProperty Name="capacitedp" ColumnName="capacitedp" />
                <ScalarProperty Name="nbderog" ColumnName="nbderog" />
                <ScalarProperty Name="nbcpsfavorisea" ColumnName="nbcpsfavorisea" />
                <ScalarProperty Name="nbcpsfavoriseb" ColumnName="nbcpsfavoriseb" />
                <ScalarProperty Name="nbcpsdefavorise" ColumnName="nbcpsdefavorise" />
                <ScalarProperty Name="nbcpsmoyenne" ColumnName="nbcpsmoyenne" />
                <ScalarProperty Name="zep" ColumnName="zep" />
                <ScalarProperty Name="handicap" ColumnName="handicap" />
                <ScalarProperty Name="prive" ColumnName="prive" />
                <ScalarProperty Name="rne" ColumnName="rne" />
                <ScalarProperty Name="txremplireel" ColumnName="txremplireel" />
                <ScalarProperty Name="txremplisimu" ColumnName="txremplisimu" />
                <ScalarProperty Name="txremplidpreel" ColumnName="txremplidpreel" />
                <ScalarProperty Name="effectifsegpa" ColumnName="effectifsegpa" />
                <ScalarProperty Name="capacitesegpa" ColumnName="capacitesegpa" />
                <ScalarProperty Name="txremplisegpa" ColumnName="txremplisegpa" />
                <ScalarProperty Name="nblogementstotal" ColumnName="nblogementstotal" />
                <ScalarProperty Name="nomregierestauration" ColumnName="nomregierestauration" />
                <ScalarProperty Name="rne1" ColumnName="rne1" />
                <ScalarProperty Name="ratio1" ColumnName="ratio1" />
                <ScalarProperty Name="rne2" ColumnName="rne2" />
                <ScalarProperty Name="ratio2" ColumnName="ratio2" />
                <ScalarProperty Name="rne1h1" ColumnName="rne1h1" />
                <ScalarProperty Name="ratio1h1" ColumnName="ratio1h1" />
                <ScalarProperty Name="rne2h1" ColumnName="rne2h1" />
                <ScalarProperty Name="ratio2h1" ColumnName="ratio2h1" />
                <ScalarProperty Name="effreel2006" ColumnName="effreel2006" />
                <ScalarProperty Name="excedentreel2006" ColumnName="excedentreel2006" />
                <ScalarProperty Name="effreel2007" ColumnName="effreel2007" />
                <ScalarProperty Name="excedentreel2007" ColumnName="excedentreel2007" />
                <ScalarProperty Name="effreel2008" ColumnName="effreel2008" />
                <ScalarProperty Name="excedentreel2008" ColumnName="excedentreel2008" />
                <ScalarProperty Name="effreel2009" ColumnName="effreel2009" />
                <ScalarProperty Name="excedentreel2009" ColumnName="excedentreel2009" />
                <ScalarProperty Name="effreel2010" ColumnName="effreel2010" />
                <ScalarProperty Name="excedentreel2010" ColumnName="excedentreel2010" />
                <ScalarProperty Name="effreel2011" ColumnName="effreel2011" />
                <ScalarProperty Name="excedentreel2011" ColumnName="excedentreel2011" />
                <ScalarProperty Name="effreel2012" ColumnName="effreel2012" />
                <ScalarProperty Name="excedentreel2012" ColumnName="excedentreel2012" />
                <ScalarProperty Name="effreel2013" ColumnName="effreel2013" />
                <ScalarProperty Name="excedentreel2013" ColumnName="excedentreel2013" />
                <ScalarProperty Name="effsimu2013" ColumnName="effsimu2013" />
                <ScalarProperty Name="excedentsimu2013" ColumnName="excedentsimu2013" />
                <ScalarProperty Name="effsimu2014" ColumnName="effsimu2014" />
                <ScalarProperty Name="excedentsimu2014" ColumnName="excedentsimu2014" />
                <ScalarProperty Name="effsimu2015" ColumnName="effsimu2015" />
                <ScalarProperty Name="excedentsimu2015" ColumnName="excedentsimu2015" />
                <ScalarProperty Name="effsimu2016" ColumnName="effsimu2016" />
                <ScalarProperty Name="excedentsimu2016" ColumnName="excedentsimu2016" />
                <ScalarProperty Name="effsimu2017" ColumnName="effsimu2017" />
                <ScalarProperty Name="excedentsimu2017" ColumnName="excedentsimu2017" />
                <ScalarProperty Name="effsimu2018" ColumnName="effsimu2018" />
                <ScalarProperty Name="excedentsimu2018" ColumnName="excedentsimu2018" />
                <ScalarProperty Name="effsimu2019" ColumnName="effsimu2019" />
                <ScalarProperty Name="excedentsimu2019" ColumnName="excedentsimu2019" />
                <ScalarProperty Name="effsimu2020" ColumnName="effsimu2020" />
                <ScalarProperty Name="excedentsimu2020" ColumnName="excedentsimu2020" />
                <ScalarProperty Name="effsimu2021" ColumnName="effsimu2021" />
                <ScalarProperty Name="excedentsimu2021" ColumnName="excedentsimu2021" />
                <ScalarProperty Name="ulis" ColumnName="ulis" />
                <ScalarProperty Name="secteur6" ColumnName="secteur6" />
                <ScalarProperty Name="horssecteur6" ColumnName="horssecteur6" />
                <ScalarProperty Name="effreel2014" ColumnName="effreel2014" />
                <ScalarProperty Name="excedentreel2014" ColumnName="excedentreel2014" />
                <ScalarProperty Name="effreel2015" ColumnName="effreel2015" />
                <ScalarProperty Name="excedentreel2015" ColumnName="excedentreel2015" />
                <ScalarProperty Name="effsimu2022" ColumnName="effsimu2022" />
                <ScalarProperty Name="excedentsimu2022" ColumnName="excedentsimu2022" />
                <ScalarProperty Name="effsimu2023" ColumnName="effsimu2023" />
                <ScalarProperty Name="excedentsimu2023" ColumnName="excedentsimu2023" />
                <ScalarProperty Name="effreel2016" ColumnName="effreel2016" />
                <ScalarProperty Name="excedentreel2016" ColumnName="excedentreel2016" />
                <ScalarProperty Name="effreel2017" ColumnName="effreel2017" />
                <ScalarProperty Name="excedentreel2017" ColumnName="excedentreel2017" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="typelogement">
            <EntityTypeMapping TypeName="educfModel.typelogement">
              <MappingFragment StoreEntitySet="typelogement">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="coefcollege" ColumnName="coefcollege" />
                <ScalarProperty Name="coefprimaire" ColumnName="coefprimaire" />
                <ScalarProperty Name="libelle" ColumnName="libelle" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="typesalle">
            <EntityTypeMapping TypeName="educfModel.typesalle">
              <MappingFragment StoreEntitySet="typesalle">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ulis">
            <EntityTypeMapping TypeName="educfModel.ulis">
              <MappingFragment StoreEntitySet="ulis">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="code" ColumnName="code" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="urbanisationcartescolaire">
            <EntityTypeMapping TypeName="educfModel.urbanisationcartescolaire">
              <MappingFragment StoreEntitySet="urbanisationcartescolaire">
                <ScalarProperty Name="idurbanisation" ColumnName="idurbanisation" />
                <ScalarProperty Name="idcartescolaire" ColumnName="idcartescolaire" />
                <ScalarProperty Name="idetabsecteur" ColumnName="idetabsecteur" />
                <ScalarProperty Name="idecolesecteur" ColumnName="idecolesecteur" />
                <ScalarProperty Name="idmaternellesecteur" ColumnName="idmaternellesecteur" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="utilisateur">
            <EntityTypeMapping TypeName="educfModel.utilisateur">
              <MappingFragment StoreEntitySet="utilisateur">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="mdp" ColumnName="mdp" />
                <ScalarProperty Name="optetablissements" ColumnName="optetablissements" />
                <ScalarProperty Name="optadministrateur" ColumnName="optadministrateur" />
                <ScalarProperty Name="optcommunes" ColumnName="optcommunes" />
                <ScalarProperty Name="opteleves" ColumnName="opteleves" />
                <ScalarProperty Name="optsimulations" ColumnName="optsimulations" />
                <ScalarProperty Name="optdonnees" ColumnName="optdonnees" />
                <ScalarProperty Name="optsig" ColumnName="optsig" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="classement">
            <EntityTypeMapping TypeName="educfModel.classement">
              <MappingFragment StoreEntitySet="classement">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="classeniveau">
            <EntityTypeMapping TypeName="educfModel.classeniveau">
              <MappingFragment StoreEntitySet="classeniveau">
                <ScalarProperty Name="idclasse" ColumnName="idclasse" />
                <ScalarProperty Name="idniveau" ColumnName="idniveau" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="commune_ok">
            <EntityTypeMapping TypeName="educfModel.commune_ok">
              <MappingFragment StoreEntitySet="commune_ok">
                <ScalarProperty Name="idcommuneok" ColumnName="idcommuneok" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="communeannee">
            <EntityTypeMapping TypeName="educfModel.communeannee">
              <MappingFragment StoreEntitySet="communeannee">
                <ScalarProperty Name="idcommune" ColumnName="idcommune" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="prevcreationetab" ColumnName="prevcreationetab" />
                <ScalarProperty Name="prevsuppressionetab" ColumnName="prevsuppressionetab" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="communehabitants">
            <EntityTypeMapping TypeName="educfModel.communehabitants">
              <MappingFragment StoreEntitySet="communehabitants">
                <ScalarProperty Name="idcommune" ColumnName="idcommune" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="habitants" ColumnName="habitants" />
                <ScalarProperty Name="naissances" ColumnName="naissances" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="communeurbanisationparcelle">
            <EntityTypeMapping TypeName="educfModel.communeurbanisationparcelle">
              <MappingFragment StoreEntitySet="communeurbanisationparcelle">
                <ScalarProperty Name="idurbanisation" ColumnName="idurbanisation" />
                <ScalarProperty Name="idparcelle" ColumnName="idparcelle" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="csp">
            <EntityTypeMapping TypeName="educfModel.csp">
              <MappingFragment StoreEntitySet="csp">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="favorise" ColumnName="favorise" />
                <ScalarProperty Name="qf" ColumnName="qf" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etab_ok">
            <EntityTypeMapping TypeName="educfModel.etab_ok">
              <MappingFragment StoreEntitySet="etab_ok">
                <ScalarProperty Name="idetabok" ColumnName="idetabok" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="parcelle">
            <EntityTypeMapping TypeName="educfModel.parcelle">
              <MappingFragment StoreEntitySet="parcelle">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="numadresse" ColumnName="numadresse" />
                <ScalarProperty Name="idrue" ColumnName="idrue" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="plan">
            <EntityTypeMapping TypeName="educfModel.plan">
              <MappingFragment StoreEntitySet="plan">
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="chemincomplet" ColumnName="chemincomplet" />
                <ScalarProperty Name="zoommin" ColumnName="zoommin" />
                <ScalarProperty Name="zoommax" ColumnName="zoommax" />
                <ScalarProperty Name="format" ColumnName="format" />
                <ScalarProperty Name="ordre" ColumnName="ordre" />
                <ScalarProperty Name="etiquette" ColumnName="etiquette" />
                <ScalarProperty Name="tailleetiquette" ColumnName="tailleetiquette" />
                <ScalarProperty Name="champetiquette" ColumnName="champetiquette" />
                <ScalarProperty Name="symbol" ColumnName="symbol" />
                <ScalarProperty Name="symbolfont" ColumnName="symbolfont" />
                <ScalarProperty Name="symbolsize" ColumnName="symbolsize" />
                <ScalarProperty Name="symbolcolor" ColumnName="symbolcolor" />
                <ScalarProperty Name="symbolangle" ColumnName="symbolangle" />
                <ScalarProperty Name="symbolhalo" ColumnName="symbolhalo" />
                <ScalarProperty Name="symbolbox" ColumnName="symbolbox" />
                <ScalarProperty Name="symbolbkgcolor" ColumnName="symbolbkgcolor" />
                <ScalarProperty Name="symbolshadow" ColumnName="symbolshadow" />
                <ScalarProperty Name="symbolitalic" ColumnName="symbolitalic" />
                <ScalarProperty Name="symbolbold" ColumnName="symbolbold" />
                <ScalarProperty Name="linestyle" ColumnName="linestyle" />
                <ScalarProperty Name="linecolor" ColumnName="linecolor" />
                <ScalarProperty Name="lineunit" ColumnName="lineunit" />
                <ScalarProperty Name="linewidth" ColumnName="linewidth" />
                <ScalarProperty Name="lineinterleaved" ColumnName="lineinterleaved" />
                <ScalarProperty Name="regionbackcolor" ColumnName="regionbackcolor" />
                <ScalarProperty Name="regionbordercolor" ColumnName="regionbordercolor" />
                <ScalarProperty Name="regionborderstyle" ColumnName="regionborderstyle" />
                <ScalarProperty Name="regionborderwidth" ColumnName="regionborderwidth" />
                <ScalarProperty Name="regionborderwidthunit" ColumnName="regionborderwidthunit" />
                <ScalarProperty Name="regioncolor" ColumnName="regioncolor" />
                <ScalarProperty Name="regionpattern" ColumnName="regionpattern" />
                <ScalarProperty Name="regiontransparent" ColumnName="regiontransparent" />
                <ScalarProperty Name="sansrepgraphique" ColumnName="sansrepgraphique" />
                <ScalarProperty Name="visible" ColumnName="visible" />
                <ScalarProperty Name="policeetiquette" ColumnName="policeetiquette" />
                <ScalarProperty Name="couleuretiquette" ColumnName="couleuretiquette" />
                <ScalarProperty Name="typereprgraphique" ColumnName="typereprgraphique" />
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nomalias" ColumnName="nomalias" />
                <ScalarProperty Name="symbolbitmapname" ColumnName="symbolbitmapname" />
                <ScalarProperty Name="symbolbitmapsize" ColumnName="symbolbitmapsize" />
                <ScalarProperty Name="symbolbitmaptransparent" ColumnName="symbolbitmaptransparent" />
                <ScalarProperty Name="symbolcharacter" ColumnName="symbolcharacter" />
                <ScalarProperty Name="symboltype" ColumnName="symboltype" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="rue_ok">
            <EntityTypeMapping TypeName="educfModel.rue_ok">
              <MappingFragment StoreEntitySet="rue_ok">
                <ScalarProperty Name="idrueok" ColumnName="idrueok" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="commune" ColumnName="commune" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="simulationetabcrees">
            <EntityTypeMapping TypeName="educfModel.simulationetabcrees">
              <MappingFragment StoreEntitySet="simulationetabcrees">
                <ScalarProperty Name="idsimulation" ColumnName="idsimulation" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="simulationetabsupprimes">
            <EntityTypeMapping TypeName="educfModel.simulationetabsupprimes">
              <MappingFragment StoreEntitySet="simulationetabsupprimes">
                <ScalarProperty Name="idsimulation" ColumnName="idsimulation" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="transport_iti_arret">
            <EntityTypeMapping TypeName="educfModel.transport_iti_arret">
              <MappingFragment StoreEntitySet="transport_iti_arret">
                <ScalarProperty Name="iditi" ColumnName="iditi" />
                <ScalarProperty Name="idarret" ColumnName="idarret" />
                <ScalarProperty Name="ordre" ColumnName="ordre" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="transportarret">
            <EntityTypeMapping TypeName="educfModel.transportarret">
              <MappingFragment StoreEntitySet="transportarret">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="idcommune" ColumnName="idcommune" />
                <ScalarProperty Name="x" ColumnName="x" />
                <ScalarProperty Name="y" ColumnName="y" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="transportitineraire">
            <EntityTypeMapping TypeName="educfModel.transportitineraire">
              <MappingFragment StoreEntitySet="transportitineraire">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="fonctionnement" ColumnName="fonctionnement" />
                <ScalarProperty Name="typeservice" ColumnName="typeservice" />
                <ScalarProperty Name="sens" ColumnName="sens" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="typebourse">
            <EntityTypeMapping TypeName="educfModel.typebourse">
              <MappingFragment StoreEntitySet="typebourse">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="libelle" ColumnName="libelle" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="typeetablissement">
            <EntityTypeMapping TypeName="educfModel.typeetablissement">
              <MappingFragment StoreEntitySet="typeetablissement">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
              </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="false" />
        <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>