fichecollege/CD67.FicheCollege.Entity/EntityModel.edmx

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="CD67.FicheCollege.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityType Name="Actions-CLAS">
          <Key>
            <PropertyRef Name="College_Id" />
          </Key>
          <Property Name="College_Id" Type="nvarchar" MaxLength="8" Nullable="false" />
          <Property Name="Action" Type="bit" />
          <Property Name="Commentaire" Type="ntext" />
        </EntityType>
        <EntityType Name="Annees">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="12" Nullable="false" />
        </EntityType>
        <EntityType Name="Colleges">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="nvarchar" MaxLength="8" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Adresse" Type="nvarchar" MaxLength="255" />
          <Property Name="Code_Postal" Type="nvarchar" MaxLength="5" />
          <Property Name="TypeCollege_Id" Type="int" Nullable="false" />
          <Property Name="Commune_Insee" Type="nvarchar" MaxLength="5" />
          <Property Name="Commune" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Canton" Type="nvarchar" MaxLength="255" />
          <Property Name="Territoire_Id" Type="nvarchar" MaxLength="10" />
          <Property Name="TAD" Type="nvarchar" MaxLength="255" />
          <Property Name="CDC" Type="nvarchar" MaxLength="255" />
          <Property Name="Tel" Type="nvarchar" MaxLength="255" />
          <Property Name="Fax" Type="nvarchar" MaxLength="255" />
          <Property Name="Email" Type="nvarchar" MaxLength="255" />
          <Property Name="Annee_Id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Identites">
          <Key>
            <PropertyRef Name="College_Id" />
          </Key>
          <Property Name="College_Id" Type="nvarchar" MaxLength="8" Nullable="false" />
          <Property Name="Principal_SID" Type="nvarchar" MaxLength="64" />
          <Property Name="Principal_Login" Type="nvarchar" MaxLength="255" />
          <Property Name="Principal_Nom" Type="nvarchar" MaxLength="255" />
          <Property Name="Principal_Prenom" Type="nvarchar" MaxLength="255" />
          <Property Name="Principal_Email" Type="nvarchar" MaxLength="255" />
          <Property Name="Principal_Tel" Type="nvarchar" MaxLength="255" />
          <Property Name="Principal_Structure" Type="nvarchar" MaxLength="255" />
          <Property Name="Adjoint_SID" Type="nvarchar" MaxLength="64" />
          <Property Name="Adjoint_Login" Type="nvarchar" MaxLength="255" />
          <Property Name="Adjoint_Nom" Type="nvarchar" MaxLength="255" />
          <Property Name="Adjoint_Prenom" Type="nvarchar" MaxLength="255" />
          <Property Name="Adjoint_Email" Type="nvarchar" MaxLength="255" />
          <Property Name="Adjoint_Tel" Type="nvarchar" MaxLength="255" />
          <Property Name="Adjoint_Structure" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire_SID" Type="nvarchar" MaxLength="64" />
          <Property Name="Gestionnaire_Login" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire_Nom" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire_Prenom" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire_Email" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire_Tel" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire_Structure" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire2_SID" Type="nvarchar" MaxLength="64" />
          <Property Name="Gestionnaire2_Login" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire2_Nom" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire2_Prenom" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire2_Email" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire2_Tel" Type="nvarchar" MaxLength="255" />
          <Property Name="Gestionnaire2_Structure" Type="nvarchar" MaxLength="255" />
        </EntityType>
        <EntityType Name="Territoires">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Referent_SID" Type="nvarchar" MaxLength="64" />
          <Property Name="Referent_Nom" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Prenom" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Structure" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Login" Type="nvarchar" MaxLength="255" />
          <Property Name="Referent_Email" Type="nvarchar" MaxLength="255" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="TypesCollege">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Ordre" Type="int" Nullable="false" />
        </EntityType>
        <Association Name="FK_Actions-CLAS_College">
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="1" />
          <End Role="Actions-CLAS" Type="Self.Actions-CLAS" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Colleges">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Actions-CLAS">
              <PropertyRef Name="College_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Annees_Colleges">
          <End Role="Annees" Type="Self.Annees" Multiplicity="1" />
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Annees">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Colleges">
              <PropertyRef Name="Annee_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Colleges_Territoires">
          <End Role="Territoires" Type="Self.Territoires" Multiplicity="0..1" />
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Territoires">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Colleges">
              <PropertyRef Name="Territoire_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Colleges_TypesCollege">
          <End Role="TypesCollege" Type="Self.TypesCollege" Multiplicity="1" />
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="TypesCollege">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Colleges">
              <PropertyRef Name="TypeCollege_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_FicheIdentite_College">
          <End Role="Colleges" Type="Self.Colleges" Multiplicity="1" />
          <End Role="Identites" Type="Self.Identites" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Colleges">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Identites">
              <PropertyRef Name="College_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="CD67FicheCollegeStoreContainer">
          <EntitySet Name="Actions-CLAS" EntityType="Self.Actions-CLAS" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Annees" EntityType="Self.Annees" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Colleges" EntityType="Self.Colleges" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Identites" EntityType="Self.Identites" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Territoires" EntityType="Self.Territoires" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="TypesCollege" EntityType="Self.TypesCollege" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_Actions-CLAS_College" Association="Self.FK_Actions-CLAS_College">
            <End Role="Colleges" EntitySet="Colleges" />
            <End Role="Actions-CLAS" EntitySet="Actions-CLAS" />
          </AssociationSet>
          <AssociationSet Name="FK_Annees_Colleges" Association="Self.FK_Annees_Colleges">
            <End Role="Annees" EntitySet="Annees" />
            <End Role="Colleges" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="FK_Colleges_Territoires" Association="Self.FK_Colleges_Territoires">
            <End Role="Territoires" EntitySet="Territoires" />
            <End Role="Colleges" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="FK_Colleges_TypesCollege" Association="Self.FK_Colleges_TypesCollege">
            <End Role="TypesCollege" EntitySet="TypesCollege" />
            <End Role="Colleges" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="FK_FicheIdentite_College" Association="Self.FK_FicheIdentite_College">
            <End Role="Colleges" EntitySet="Colleges" />
            <End Role="Identites" EntitySet="Identites" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="CD67.FicheCollege" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="TypesCollege" EntityType="CD67.FicheCollege.TypeCollege" />
          <EntitySet Name="Territoires" EntityType="CD67.FicheCollege.Territoire" />
          <EntitySet Name="Colleges" EntityType="CD67.FicheCollege.College" />
          <AssociationSet Name="FK_Colleges_Territoires" Association="CD67.FicheCollege.FK_Colleges_Territoires">
            <End Role="Territoire" EntitySet="Territoires" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          <AssociationSet Name="FK_Colleges_TypesCollege" Association="CD67.FicheCollege.FK_Colleges_TypesCollege">
            <End Role="TypeCollege" EntitySet="TypesCollege" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          <EntitySet Name="Identites" EntityType="CD67.FicheCollege.Identite" />
          <AssociationSet Name="FK_FicheIdentite_College" Association="CD67.FicheCollege.FK_FicheIdentite_College">
            <End Role="College" EntitySet="Colleges" />
            <End Role="Identite" EntitySet="Identites" />
          </AssociationSet>
          <EntitySet Name="Annees" EntityType="CD67.FicheCollege.Annee" />
          <AssociationSet Name="AnneeCollege" Association="CD67.FicheCollege.AnneeCollege">
            <End Role="Annee" EntitySet="Annees" />
            <End Role="College" EntitySet="Colleges" />
          </AssociationSet>
          <EntitySet Name="ActionCLAS" EntityType="CD67.FicheCollege.ActionCLAS" />
          <AssociationSet Name="FK_Actions_CLAS_College" Association="CD67.FicheCollege.FK_Actions_CLAS_College">
            <End Role="College" EntitySet="Colleges" />
            <End Role="Actions_CLAS" EntitySet="ActionCLAS" />
          </AssociationSet>
          </EntityContainer>
        <EntityType Name="TypeCollege">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.FK_Colleges_TypesCollege" FromRole="TypeCollege" ToRole="College" />
        </EntityType>
        <EntityType Name="Territoire">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Referent_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Ordre" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.FK_Colleges_Territoires" FromRole="Territoire" ToRole="College" />
        </EntityType>
        <EntityType Name="College">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="String" Nullable="false" MaxLength="8" FixedLength="false" Unicode="true" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adresse" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Code_Postal" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
          <Property Name="TypeCollege_Id" Type="Int32" Nullable="false" />
          <Property Name="Commune_Insee" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
          <Property Name="Commune" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Canton" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Territoire_Id" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="TAD" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="CDC" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Fax" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Territoire" Relationship="CD67.FicheCollege.FK_Colleges_Territoires" FromRole="College" ToRole="Territoire" />
          <NavigationProperty Name="TypeCollege" Relationship="CD67.FicheCollege.FK_Colleges_TypesCollege" FromRole="College" ToRole="TypeCollege" />
          <NavigationProperty Name="Identite" Relationship="CD67.FicheCollege.FK_FicheIdentite_College" FromRole="College" ToRole="Identite" />
          <NavigationProperty Name="Annee" Relationship="CD67.FicheCollege.AnneeCollege" FromRole="College" ToRole="Annee" />
          <Property Name="Annee_Id" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Actions_CLAS" Relationship="CD67.FicheCollege.FK_Actions_CLAS_College" FromRole="College" ToRole="Actions_CLAS" />
        </EntityType>
        <Association Name="FK_Colleges_Territoires">
          <End Type="CD67.FicheCollege.Territoire" Role="Territoire" Multiplicity="0..1" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Territoire">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="College">
              <PropertyRef Name="Territoire_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Colleges_TypesCollege">
          <End Type="CD67.FicheCollege.TypeCollege" Role="TypeCollege" Multiplicity="1" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="TypeCollege">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="College">
              <PropertyRef Name="TypeCollege_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="Identite">
          <Key>
            <PropertyRef Name="College_Id" />
          </Key>
          <Property Name="College_Id" Type="String" Nullable="false" MaxLength="8" FixedLength="false" Unicode="true" />
          <Property Name="Principal_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Principal_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Adjoint_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="Gestionnaire2_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="College" Relationship="CD67.FicheCollege.FK_FicheIdentite_College" FromRole="Identite" ToRole="College" />
        </EntityType>
        <Association Name="FK_FicheIdentite_College">
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="1" />
          <End Type="CD67.FicheCollege.Identite" Role="Identite" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="College">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Identite">
              <PropertyRef Name="College_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="Annee">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.AnneeCollege" FromRole="Annee" ToRole="College" />
          <Property Name="Libelle" Type="String" Nullable="false" MaxLength="12" FixedLength="false" Unicode="true" />
        </EntityType>
        <Association Name="AnneeCollege">
          <End Type="CD67.FicheCollege.Annee" Role="Annee" Multiplicity="1" />
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Annee">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="College">
              <PropertyRef Name="Annee_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="ActionCLAS">
          <Key>
            <PropertyRef Name="College_Id" />
          </Key>
          <Property Name="College_Id" Type="String" Nullable="false" MaxLength="8" FixedLength="false" Unicode="true" />
          <Property Name="Action" Type="Boolean" />
          <Property Name="Commentaire" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="College" Relationship="CD67.FicheCollege.FK_Actions_CLAS_College" FromRole="Actions_CLAS" ToRole="College" />
        </EntityType>
        <Association Name="FK_Actions_CLAS_College">
          <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="1" />
          <End Type="CD67.FicheCollege.ActionCLAS" Role="Actions_CLAS" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="College">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Actions_CLAS">
              <PropertyRef Name="College_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
    <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  <EntityContainerMapping StorageEntityContainer="CD67FicheCollegeStoreContainer" CdmEntityContainer="Entities">
    <EntitySetMapping Name="TypesCollege">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.TypeCollege)">
        <MappingFragment StoreEntitySet="TypesCollege">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Libelle" ColumnName="Libelle" />
          <ScalarProperty Name="Ordre" ColumnName="Ordre" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Territoires">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Territoire)">
        <MappingFragment StoreEntitySet="Territoires">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Libelle" ColumnName="Libelle" />
          <ScalarProperty Name="Referent_SID" ColumnName="Referent_SID" />
          <ScalarProperty Name="Referent_Nom" ColumnName="Referent_Nom" />
          <ScalarProperty Name="Referent_Prenom" ColumnName="Referent_Prenom" />
          <ScalarProperty Name="Referent_Structure" ColumnName="Referent_Structure" />
          <ScalarProperty Name="Referent_Login" ColumnName="Referent_Login" />
          <ScalarProperty Name="Referent_Email" ColumnName="Referent_Email" />
          <ScalarProperty Name="Ordre" ColumnName="Ordre" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Colleges">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.College)">
        <MappingFragment StoreEntitySet="Colleges">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Libelle" ColumnName="Libelle" />
          <ScalarProperty Name="Adresse" ColumnName="Adresse" />
          <ScalarProperty Name="Code_Postal" ColumnName="Code_Postal" />
          <ScalarProperty Name="TypeCollege_Id" ColumnName="TypeCollege_Id" />
          <ScalarProperty Name="Commune_Insee" ColumnName="Commune_Insee" />
          <ScalarProperty Name="Commune" ColumnName="Commune" />
          <ScalarProperty Name="Canton" ColumnName="Canton" />
          <ScalarProperty Name="Territoire_Id" ColumnName="Territoire_Id" />
          <ScalarProperty Name="TAD" ColumnName="TAD" />
          <ScalarProperty Name="CDC" ColumnName="CDC" />
          <ScalarProperty Name="Tel" ColumnName="Tel" />
          <ScalarProperty Name="Fax" ColumnName="Fax" />
          <ScalarProperty Name="Email" ColumnName="Email" />
          <ScalarProperty Name="Annee_Id" ColumnName="Annee_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Identites">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Identite)">
        <MappingFragment StoreEntitySet="Identites">
          <ScalarProperty Name="College_Id" ColumnName="College_Id" />
          <ScalarProperty Name="Principal_SID" ColumnName="Principal_SID" />
          <ScalarProperty Name="Principal_Login" ColumnName="Principal_Login" />
          <ScalarProperty Name="Principal_Nom" ColumnName="Principal_Nom" />
          <ScalarProperty Name="Principal_Prenom" ColumnName="Principal_Prenom" />
          <ScalarProperty Name="Principal_Email" ColumnName="Principal_Email" />
          <ScalarProperty Name="Principal_Tel" ColumnName="Principal_Tel" />
          <ScalarProperty Name="Principal_Structure" ColumnName="Principal_Structure" />
          <ScalarProperty Name="Adjoint_SID" ColumnName="Adjoint_SID" />
          <ScalarProperty Name="Adjoint_Login" ColumnName="Adjoint_Login" />
          <ScalarProperty Name="Adjoint_Nom" ColumnName="Adjoint_Nom" />
          <ScalarProperty Name="Adjoint_Prenom" ColumnName="Adjoint_Prenom" />
          <ScalarProperty Name="Adjoint_Email" ColumnName="Adjoint_Email" />
          <ScalarProperty Name="Adjoint_Tel" ColumnName="Adjoint_Tel" />
          <ScalarProperty Name="Adjoint_Structure" ColumnName="Adjoint_Structure" />
          <ScalarProperty Name="Gestionnaire_SID" ColumnName="Gestionnaire_SID" />
          <ScalarProperty Name="Gestionnaire_Login" ColumnName="Gestionnaire_Login" />
          <ScalarProperty Name="Gestionnaire_Nom" ColumnName="Gestionnaire_Nom" />
          <ScalarProperty Name="Gestionnaire_Prenom" ColumnName="Gestionnaire_Prenom" />
          <ScalarProperty Name="Gestionnaire_Email" ColumnName="Gestionnaire_Email" />
          <ScalarProperty Name="Gestionnaire_Tel" ColumnName="Gestionnaire_Tel" />
          <ScalarProperty Name="Gestionnaire_Structure" ColumnName="Gestionnaire_Structure" />
          <ScalarProperty Name="Gestionnaire2_SID" ColumnName="Gestionnaire2_SID" />
          <ScalarProperty Name="Gestionnaire2_Login" ColumnName="Gestionnaire2_Login" />
          <ScalarProperty Name="Gestionnaire2_Nom" ColumnName="Gestionnaire2_Nom" />
          <ScalarProperty Name="Gestionnaire2_Prenom" ColumnName="Gestionnaire2_Prenom" />
          <ScalarProperty Name="Gestionnaire2_Email" ColumnName="Gestionnaire2_Email" />
          <ScalarProperty Name="Gestionnaire2_Tel" ColumnName="Gestionnaire2_Tel" />
          <ScalarProperty Name="Gestionnaire2_Structure" ColumnName="Gestionnaire2_Structure" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Annees">
      <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Annee)">
        <MappingFragment StoreEntitySet="Annees">
          <ScalarProperty Name="Libelle" ColumnName="Libelle" />
                <ScalarProperty Name="Id" ColumnName="Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
          <EntitySetMapping Name="ActionCLAS">
            <EntityTypeMapping TypeName="CD67.FicheCollege.ActionCLAS">
              <MappingFragment StoreEntitySet="Actions-CLAS">
                <ScalarProperty Name="Commentaire" ColumnName="Commentaire" />
                <ScalarProperty Name="Action" ColumnName="Action" />
                <ScalarProperty Name="College_Id" ColumnName="College_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>