fichecollege/CD67.FicheCollege.Entity/EducfModel.edmx

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="educfModel.Store" Provider="Npgsql" ProviderManifestToken="9.2.8" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityType Name="commune">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="200" />
          <Property Name="code" Type="varchar" MaxLength="7" />
          <Property Name="insee" Type="varchar" MaxLength="30" />
          <Property Name="superficie" Type="numeric" Precision="10" Scale="0" />
          <Property Name="maire" Type="varchar" MaxLength="100" />
          <Property Name="adresse" Type="varchar" MaxLength="100" />
          <Property Name="tel" Type="varchar" MaxLength="100" />
          <Property Name="fax" Type="varchar" MaxLength="100" />
          <Property Name="email" Type="varchar" MaxLength="250" />
          <Property Name="urbanisationemail" Type="varchar" MaxLength="250" />
          <Property Name="urbanisationinterlocuteur" Type="varchar" MaxLength="100" />
          <Property Name="urbanisationtel" Type="varchar" MaxLength="100" />
          <Property Name="optcommunecollege" Type="numeric" Precision="1" Scale="0" />
          <Property Name="rpi" Type="varchar" MaxLength="50" />
          <Property Name="web" Type="varchar" MaxLength="100" />
          <Property Name="idcanton" Type="int4" />
        </EntityType>
        <EntityType Name="etabeffectifannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="int4" />
          <Property Name="annee" Type="float8" />
          <Property Name="effectif" Type="float8" />
          <Property Name="idniveau" Type="float8" />
          <Property Name="tap" Type="float8" />
          <Property Name="tevit" Type="float8" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nbclasses" Type="numeric" Precision="5" Scale="0" />
          <Property Name="effectifdp" Type="float8" />
          <Property Name="effectifderog" Type="float8" />
          <Property Name="tapsec" Type="float8" />
        </EntityType>
        <EntityType Name="etablissement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="250" />
          <Property Name="numero" Type="varchar" MaxLength="20" />
          <Property Name="idtype" Type="float8" />
          <Property Name="privepublic" Type="float8" />
          <Property Name="numadresse" Type="varchar" MaxLength="20" />
          <Property Name="idrue" Type="float8" />
          <Property Name="adresse2" Type="varchar" MaxLength="250" />
          <Property Name="tel" Type="varchar" MaxLength="20" />
          <Property Name="fax" Type="varchar" MaxLength="20" />
          <Property Name="tel2" Type="varchar" MaxLength="20" />
          <Property Name="numabrege" Type="varchar" MaxLength="10" />
          <Property Name="email" Type="varchar" MaxLength="250" />
          <Property Name="anneeconstruction" Type="float8" />
          <Property Name="idclassement" Type="float8" />
          <Property Name="web" Type="varchar" MaxLength="250" />
          <Property Name="surface" Type="varchar" MaxLength="20" />
          <Property Name="accueilhandicape" Type="numeric" Precision="1" Scale="0" />
          <Property Name="idelementairesecteur" Type="text" />
          <Property Name="horaires1" Type="varchar" MaxLength="100" />
          <Property Name="horaires2" Type="varchar" MaxLength="100" />
          <Property Name="horaires3" Type="varchar" MaxLength="100" />
          <Property Name="horaires4" Type="varchar" MaxLength="100" />
          <Property Name="optdplundi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optdpmardi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optdpmercredi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optdpjeudi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="optdpvendredi" Type="numeric" Precision="1" Scale="0" />
          <Property Name="idregierestauration" Type="numeric" Precision="3" Scale="0" />
          <Property Name="idbassin" Type="numeric" Precision="5" Scale="0" />
          <Property Name="couleur" Type="numeric" Precision="10" Scale="0" />
          <Property Name="idcouleur" Type="int4" />
          <Property Name="optulis" Type="int4" />
          <Property Name="cp" Type="varchar" MaxLength="10" />
          <Property Name="anneerestructuration" Type="varchar" MaxLength="4" />
          <Property Name="libellecarte1" Type="varchar" MaxLength="200" />
          <Property Name="libellecarte2" Type="varchar" MaxLength="200" />
        </EntityType>
        <EntityType Name="etaboptionsannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="int4" />
          <Property Name="idoption" Type="numeric" Precision="5" Scale="0" />
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
        </EntityType>
        <EntityType Name="filiere">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="60" />
          <Property Name="libelle" Type="varchar" MaxLength="100" />
        </EntityType>
        <EntityType Name="matiereoption">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="code" Type="varchar" MaxLength="20" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="nomcourt" Type="varchar" MaxLength="50" />
          <Property Name="nomlong" Type="varchar" MaxLength="200" />
        </EntityType>
        <EntityType Name="mef">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="code" Type="varchar" MaxLength="11" />
          <Property Name="mefst11" Type="varchar" MaxLength="11" />
          <Property Name="nomcourt" Type="varchar" MaxLength="6" />
          <Property Name="nomlong" Type="varchar" MaxLength="40" />
          <Property Name="idniveau" Type="numeric" Precision="5" Scale="0" />
          <Property Name="idfiliere" Type="numeric" Precision="5" Scale="0" />
        </EntityType>
        <EntityType Name="niveau">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="typeetablissement" Type="float8" />
          <Property Name="nom" Type="varchar" MaxLength="20" />
          <Property Name="ordre" Type="float8" />
          <Property Name="idniveaumontee" Type="numeric" Precision="5" Scale="0" />
          <Property Name="capacite" Type="numeric" Precision="3" Scale="0" />
          <Property Name="capacitezep" Type="numeric" Precision="3" Scale="0" />
        </EntityType>
        <EntityType Name="rues">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int4" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nom" Type="varchar" MaxLength="100" />
          <Property Name="idcommune" Type="int4" />
          <Property Name="typerue" Type="varchar" MaxLength="100" />
          <Property Name="rivoli" Type="varchar" MaxLength="10" />
        </EntityType>
        <Association Name="FK_EtabEffectifAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabeffectifannee" Type="Self.etabeffectifannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabeffectifannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabOptionsAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etaboptionsannee" Type="Self.etaboptionsannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etaboptionsannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RuesCommunes">
          <End Role="commune" Type="Self.commune" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="rues" Type="Self.rues" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="commune">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="rues">
              <PropertyRef Name="idcommune" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="educfModelStoreContainer">
          <EntitySet Name="commune" EntityType="Self.commune" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etabeffectifannee" EntityType="Self.etabeffectifannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etablissement" EntityType="Self.etablissement" Schema="educf" store:Type="Tables" />
          <EntitySet Name="etaboptionsannee" EntityType="Self.etaboptionsannee" Schema="educf" store:Type="Tables" />
          <EntitySet Name="filiere" EntityType="Self.filiere" Schema="educf" store:Type="Tables" />
          <EntitySet Name="matiereoption" EntityType="Self.matiereoption" Schema="educf" store:Type="Tables" />
          <EntitySet Name="mef" EntityType="Self.mef" Schema="educf" store:Type="Tables" />
          <EntitySet Name="niveau" EntityType="Self.niveau" Schema="educf" store:Type="Tables" />
          <EntitySet Name="rues" EntityType="Self.rues" Schema="educf" store:Type="Tables" />
          <AssociationSet Name="FK_EtabEffectifAnnee" Association="Self.FK_EtabEffectifAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etabeffectifannee" EntitySet="etabeffectifannee" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabOptionsAnnee" Association="Self.FK_EtabOptionsAnnee">
            <End Role="etablissement" EntitySet="etablissement" />
            <End Role="etaboptionsannee" EntitySet="etaboptionsannee" />
          </AssociationSet>
          <AssociationSet Name="FK_RuesCommunes" Association="Self.FK_RuesCommunes">
            <End Role="commune" EntitySet="commune" />
            <End Role="rues" EntitySet="rues" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="educfModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityType Name="commune">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="code" Type="String" MaxLength="7" FixedLength="false" Unicode="true" />
          <Property Name="insee" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
          <Property Name="superficie" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="maire" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="adresse" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="tel" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="fax" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="email" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="urbanisationemail" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="urbanisationinterlocuteur" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="urbanisationtel" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="optcommunecollege" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="rpi" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="web" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="idcanton" Type="Int32" />
          <NavigationProperty Name="rues" Relationship="Self.FK_RuesCommunes" FromRole="commune" ToRole="rues" />
        </EntityType>
        <EntityType Name="etabeffectifannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="annee" Type="Double" />
          <Property Name="effectif" Type="Double" />
          <Property Name="idniveau" Type="Int32" />
          <Property Name="tap" Type="Double" />
          <Property Name="tevit" Type="Double" />
          <Property Name="nbclasses" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="effectifdp" Type="Double" />
          <Property Name="effectifderog" Type="Double" />
          <Property Name="tapsec" Type="Double" />
          <NavigationProperty Name="etablissement" Relationship="Self.FK_EtabEffectifAnnee" FromRole="etabeffectifannee" ToRole="etablissement" />
          <NavigationProperty Name="niveau" Relationship="educfModel.niveauetabeffectifannee" FromRole="etabeffectifannee" ToRole="niveau" />
        </EntityType>
        <EntityType Name="etablissement">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="numero" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="idtype" Type="Double" />
          <Property Name="privepublic" Type="Double" />
          <Property Name="numadresse" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="idrue" Type="Int32" />
          <Property Name="adresse2" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="tel" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="fax" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="tel2" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="numabrege" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="email" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="anneeconstruction" Type="Double" />
          <Property Name="idclassement" Type="Double" />
          <Property Name="web" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="surface" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="accueilhandicape" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="idelementairesecteur" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="horaires1" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="horaires2" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="horaires3" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="horaires4" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="optdplundi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optdpmardi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optdpmercredi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optdpjeudi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="optdpvendredi" Type="Decimal" Precision="1" Scale="0" />
          <Property Name="idregierestauration" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="idbassin" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="couleur" Type="Decimal" Precision="10" Scale="0" />
          <Property Name="idcouleur" Type="Int32" />
          <Property Name="optulis" Type="Int32" />
          <Property Name="cp" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="anneerestructuration" Type="String" MaxLength="4" FixedLength="false" Unicode="true" />
          <Property Name="libellecarte1" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="libellecarte2" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="etabeffectifannees" Relationship="Self.FK_EtabEffectifAnnee" FromRole="etablissement" ToRole="etabeffectifannee" />
          <NavigationProperty Name="rue" Relationship="educfModel.etablissementrue" FromRole="etablissement" ToRole="rue" />
          <NavigationProperty Name="etaboptionsannees" Relationship="educfModel.FK_EtabOptionsAnnee" FromRole="etablissement" ToRole="etaboptionsannee" />
        </EntityType>
        <EntityType Name="niveau">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="typeetablissement" Type="Double" />
          <Property Name="nom" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="ordre" Type="Double" />
          <Property Name="idniveaumontee" Type="Decimal" Precision="5" Scale="0" />
          <Property Name="capacite" Type="Decimal" Precision="3" Scale="0" />
          <Property Name="capacitezep" Type="Decimal" Precision="3" Scale="0" />
          <NavigationProperty Name="etabeffectifannees" Relationship="educfModel.niveauetabeffectifannee" FromRole="niveau" ToRole="etabeffectifannee" />
        </EntityType>
        <EntityType Name="rue">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="idcommune" Type="Int32" />
          <Property Name="typerue" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="rivoli" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="commune" Relationship="Self.FK_RuesCommunes" FromRole="rues" ToRole="commune" />
          <NavigationProperty Name="etablissements" Relationship="educfModel.etablissementrue" FromRole="rue" ToRole="etablissement" />
        </EntityType>
        <Association Name="FK_RuesCommunes">
          <End Role="commune" Type="Self.commune" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="rues" Type="Self.rue" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="commune">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="rues">
              <PropertyRef Name="idcommune" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EtabEffectifAnnee">
          <End Role="etablissement" Type="Self.etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="etabeffectifannee" Type="Self.etabeffectifannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabeffectifannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="EducfEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="communes" EntityType="Self.commune" />
          <EntitySet Name="etabeffectifannees" EntityType="Self.etabeffectifannee" />
          <EntitySet Name="etablissements" EntityType="Self.etablissement" />
          <EntitySet Name="niveaux" EntityType="Self.niveau" />
          <EntitySet Name="rues" EntityType="Self.rue" />
          <AssociationSet Name="FK_RuesCommunes" Association="Self.FK_RuesCommunes">
            <End Role="commune" EntitySet="communes" />
            <End Role="rues" EntitySet="rues" />
          </AssociationSet>
          <AssociationSet Name="FK_EtabEffectifAnnee" Association="Self.FK_EtabEffectifAnnee">
            <End Role="etablissement" EntitySet="etablissements" />
            <End Role="etabeffectifannee" EntitySet="etabeffectifannees" />
          </AssociationSet>
          <AssociationSet Name="etablissementrue" Association="educfModel.etablissementrue">
            <End Role="etablissement" EntitySet="etablissements" />
            <End Role="rue" EntitySet="rues" />
          </AssociationSet>
          <AssociationSet Name="niveauetabeffectifannee" Association="educfModel.niveauetabeffectifannee">
            <End Role="niveau" EntitySet="niveaux" />
            <End Role="etabeffectifannee" EntitySet="etabeffectifannees" />
          </AssociationSet>
          <EntitySet Name="filieres" EntityType="educfModel.filiere" />
          <EntitySet Name="mefs" EntityType="educfModel.mef" />
          <AssociationSet Name="filieremef" Association="educfModel.filieremef">
            <End Role="filiere" EntitySet="filieres" />
            <End Role="mef" EntitySet="mefs" />
          </AssociationSet>
          <EntitySet Name="etaboptionsannees" EntityType="educfModel.etaboptionsannee" />
          <EntitySet Name="matiereoptions" EntityType="educfModel.matiereoption" />
          <AssociationSet Name="FK_EtabOptionsAnnee" Association="educfModel.FK_EtabOptionsAnnee">
            <End Role="etablissement" EntitySet="etablissements" />
            <End Role="etaboptionsannee" EntitySet="etaboptionsannees" />
          </AssociationSet>
          <AssociationSet Name="matiereoptionetaboptionsannee" Association="educfModel.matiereoptionetaboptionsannee">
            <End Role="etaboptionsannee" EntitySet="etaboptionsannees" />
            <End Role="matiereoption" EntitySet="matiereoptions" />
          </AssociationSet>
        </EntityContainer>
        <Association Name="etablissementrue">
          <End Type="educfModel.etablissement" Role="etablissement" Multiplicity="*" />
          <End Type="educfModel.rue" Role="rue" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="rue">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etablissement">
              <PropertyRef Name="idrue" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="niveauetabeffectifannee">
          <End Type="educfModel.niveau" Role="niveau" Multiplicity="0..1" />
          <End Type="educfModel.etabeffectifannee" Role="etabeffectifannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="niveau">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etabeffectifannee">
              <PropertyRef Name="idniveau" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="filiere">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nom" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
          <Property Name="libelle" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="mefs" Relationship="educfModel.filieremef" FromRole="filiere" ToRole="mef" />
        </EntityType>
        <EntityType Name="mef">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="code" Type="String" MaxLength="11" FixedLength="false" Unicode="true" />
          <Property Name="mefst11" Type="String" MaxLength="11" FixedLength="false" Unicode="true" />
          <Property Name="nomcourt" Type="String" MaxLength="6" FixedLength="false" Unicode="true" />
          <Property Name="nomlong" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
          <Property Name="idniveau" Type="Int32" />
          <Property Name="idfiliere" Type="Int32" />
          <NavigationProperty Name="filiere" Relationship="educfModel.filieremef" FromRole="mef" ToRole="filiere" />
        </EntityType>
        <Association Name="filieremef">
          <End Type="educfModel.filiere" Role="filiere" Multiplicity="0..1" />
          <End Type="educfModel.mef" Role="mef" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="filiere">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="mef">
              <PropertyRef Name="idfiliere" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="etaboptionsannee">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="idetablissement" Type="Int32" />
          <Property Name="idoption" Type="Int32" />
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="etablissement" Relationship="educfModel.FK_EtabOptionsAnnee" FromRole="etaboptionsannee" ToRole="etablissement" />
          <NavigationProperty Name="matiereoption" Relationship="educfModel.matiereoptionetaboptionsannee" FromRole="etaboptionsannee" ToRole="matiereoption" />
        </EntityType>
        <EntityType Name="matiereoption">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="code" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="nom" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="nomcourt" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="nomlong" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="etaboptionsannees" Relationship="educfModel.matiereoptionetaboptionsannee" FromRole="matiereoption" ToRole="etaboptionsannee" />
        </EntityType>
        <Association Name="FK_EtabOptionsAnnee">
          <End Type="educfModel.etablissement" Role="etablissement" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="educfModel.etaboptionsannee" Role="etaboptionsannee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="etablissement">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etaboptionsannee">
              <PropertyRef Name="idetablissement" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="matiereoptionetaboptionsannee">
          <End Type="educfModel.etaboptionsannee" Role="etaboptionsannee" Multiplicity="*" />
          <End Type="educfModel.matiereoption" Role="matiereoption" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="matiereoption">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="etaboptionsannee">
              <PropertyRef Name="idoption" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="educfModelStoreContainer" CdmEntityContainer="EducfEntities">
          <EntitySetMapping Name="communes">
            <EntityTypeMapping TypeName="educfModel.commune">
              <MappingFragment StoreEntitySet="commune">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="insee" ColumnName="insee" />
                <ScalarProperty Name="superficie" ColumnName="superficie" />
                <ScalarProperty Name="maire" ColumnName="maire" />
                <ScalarProperty Name="adresse" ColumnName="adresse" />
                <ScalarProperty Name="tel" ColumnName="tel" />
                <ScalarProperty Name="fax" ColumnName="fax" />
                <ScalarProperty Name="email" ColumnName="email" />
                <ScalarProperty Name="urbanisationemail" ColumnName="urbanisationemail" />
                <ScalarProperty Name="urbanisationinterlocuteur" ColumnName="urbanisationinterlocuteur" />
                <ScalarProperty Name="urbanisationtel" ColumnName="urbanisationtel" />
                <ScalarProperty Name="optcommunecollege" ColumnName="optcommunecollege" />
                <ScalarProperty Name="rpi" ColumnName="rpi" />
                <ScalarProperty Name="web" ColumnName="web" />
                <ScalarProperty Name="idcanton" ColumnName="idcanton" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etabeffectifannees">
            <EntityTypeMapping TypeName="educfModel.etabeffectifannee">
              <MappingFragment StoreEntitySet="etabeffectifannee">
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
                <ScalarProperty Name="annee" ColumnName="annee" />
                <ScalarProperty Name="effectif" ColumnName="effectif" />
                <ScalarProperty Name="idniveau" ColumnName="idniveau" />
                <ScalarProperty Name="tap" ColumnName="tap" />
                <ScalarProperty Name="tevit" ColumnName="tevit" />
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nbclasses" ColumnName="nbclasses" />
                <ScalarProperty Name="effectifdp" ColumnName="effectifdp" />
                <ScalarProperty Name="effectifderog" ColumnName="effectifderog" />
                <ScalarProperty Name="tapsec" ColumnName="tapsec" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etablissements">
            <EntityTypeMapping TypeName="educfModel.etablissement">
              <MappingFragment StoreEntitySet="etablissement">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="numero" ColumnName="numero" />
                <ScalarProperty Name="idtype" ColumnName="idtype" />
                <ScalarProperty Name="privepublic" ColumnName="privepublic" />
                <ScalarProperty Name="numadresse" ColumnName="numadresse" />
                <ScalarProperty Name="idrue" ColumnName="idrue" />
                <ScalarProperty Name="adresse2" ColumnName="adresse2" />
                <ScalarProperty Name="tel" ColumnName="tel" />
                <ScalarProperty Name="fax" ColumnName="fax" />
                <ScalarProperty Name="tel2" ColumnName="tel2" />
                <ScalarProperty Name="numabrege" ColumnName="numabrege" />
                <ScalarProperty Name="email" ColumnName="email" />
                <ScalarProperty Name="anneeconstruction" ColumnName="anneeconstruction" />
                <ScalarProperty Name="idclassement" ColumnName="idclassement" />
                <ScalarProperty Name="web" ColumnName="web" />
                <ScalarProperty Name="surface" ColumnName="surface" />
                <ScalarProperty Name="accueilhandicape" ColumnName="accueilhandicape" />
                <ScalarProperty Name="idelementairesecteur" ColumnName="idelementairesecteur" />
                <ScalarProperty Name="horaires1" ColumnName="horaires1" />
                <ScalarProperty Name="horaires2" ColumnName="horaires2" />
                <ScalarProperty Name="horaires3" ColumnName="horaires3" />
                <ScalarProperty Name="horaires4" ColumnName="horaires4" />
                <ScalarProperty Name="optdplundi" ColumnName="optdplundi" />
                <ScalarProperty Name="optdpmardi" ColumnName="optdpmardi" />
                <ScalarProperty Name="optdpmercredi" ColumnName="optdpmercredi" />
                <ScalarProperty Name="optdpjeudi" ColumnName="optdpjeudi" />
                <ScalarProperty Name="optdpvendredi" ColumnName="optdpvendredi" />
                <ScalarProperty Name="idregierestauration" ColumnName="idregierestauration" />
                <ScalarProperty Name="idbassin" ColumnName="idbassin" />
                <ScalarProperty Name="couleur" ColumnName="couleur" />
                <ScalarProperty Name="idcouleur" ColumnName="idcouleur" />
                <ScalarProperty Name="optulis" ColumnName="optulis" />
                <ScalarProperty Name="cp" ColumnName="cp" />
                <ScalarProperty Name="anneerestructuration" ColumnName="anneerestructuration" />
                <ScalarProperty Name="libellecarte1" ColumnName="libellecarte1" />
                <ScalarProperty Name="libellecarte2" ColumnName="libellecarte2" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="niveaux">
            <EntityTypeMapping TypeName="educfModel.niveau">
              <MappingFragment StoreEntitySet="niveau">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="typeetablissement" ColumnName="typeetablissement" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="ordre" ColumnName="ordre" />
                <ScalarProperty Name="idniveaumontee" ColumnName="idniveaumontee" />
                <ScalarProperty Name="capacite" ColumnName="capacite" />
                <ScalarProperty Name="capacitezep" ColumnName="capacitezep" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="rues">
            <EntityTypeMapping TypeName="educfModel.rue">
              <MappingFragment StoreEntitySet="rues">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="idcommune" ColumnName="idcommune" />
                <ScalarProperty Name="typerue" ColumnName="typerue" />
                <ScalarProperty Name="rivoli" ColumnName="rivoli" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="filieres">
            <EntityTypeMapping TypeName="educfModel.filiere">
              <MappingFragment StoreEntitySet="filiere">
                <ScalarProperty Name="libelle" ColumnName="libelle" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="mefs">
            <EntityTypeMapping TypeName="educfModel.mef">
              <MappingFragment StoreEntitySet="mef">
                <ScalarProperty Name="idfiliere" ColumnName="idfiliere" />
                <ScalarProperty Name="idniveau" ColumnName="idniveau" />
                <ScalarProperty Name="nomlong" ColumnName="nomlong" />
                <ScalarProperty Name="nomcourt" ColumnName="nomcourt" />
                <ScalarProperty Name="mefst11" ColumnName="mefst11" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="etaboptionsannees">
            <EntityTypeMapping TypeName="educfModel.etaboptionsannee">
              <MappingFragment StoreEntitySet="etaboptionsannee">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="idoption" ColumnName="idoption" />
                <ScalarProperty Name="idetablissement" ColumnName="idetablissement" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="matiereoptions">
            <EntityTypeMapping TypeName="educfModel.matiereoption">
              <MappingFragment StoreEntitySet="matiereoption">
                <ScalarProperty Name="nomlong" ColumnName="nomlong" />
                <ScalarProperty Name="nomcourt" ColumnName="nomcourt" />
                <ScalarProperty Name="nom" ColumnName="nom" />
                <ScalarProperty Name="code" ColumnName="code" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="true" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="Aucun" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>