School/SchoolProject/Model.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="Хранилище gr672_pgvModel" 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="Briefing">
          <Key>
            <PropertyRef Name="BriefingID" />
          </Key>
          <Property Name="BriefingID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Date" Type="date" Nullable="false" />
          <Property Name="IDInstructor" Type="int" Nullable="false" />
          <Property Name="Reason" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Note" Type="nvarchar(max)" Nullable="false" />
          <Property Name="IDEmployee" Type="int" Nullable="false" />
          <Property Name="IDType" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Employee">
          <Key>
            <PropertyRef Name="EmployeeID" />
          </Key>
          <Property Name="EmployeeID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="50" />
          <Property Name="IsWorking" Type="bit" Nullable="false" />
          <Property Name="IDPosition" Type="int" Nullable="false" />
          <Property Name="BirthDate" Type="date" Nullable="false" />
          <Property Name="IDSubdivision" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeInBriefing">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="IDEmployee" Type="int" Nullable="false" />
          <Property Name="IDBriefing" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Position">
          <Key>
            <PropertyRef Name="PositionID" />
          </Key>
          <Property Name="PositionID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="PositionName" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="Subdivision">
          <Key>
            <PropertyRef Name="SubdivisionID" />
          </Key>
          <Property Name="SubdivisionID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="SubdivisionName" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <Association Name="FK_Briefing_Employee">
          <End Role="Employee" Type="Self.Employee" Multiplicity="1" />
          <End Role="Briefing" Type="Self.Briefing" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employee">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="Briefing">
              <PropertyRef Name="IDInstructor" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Employee_Position">
          <End Role="Position" Type="Self.Position" Multiplicity="1" />
          <End Role="Employee" Type="Self.Employee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Position">
              <PropertyRef Name="PositionID" />
            </Principal>
            <Dependent Role="Employee">
              <PropertyRef Name="IDPosition" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Employee_Subdivision">
          <End Role="Subdivision" Type="Self.Subdivision" Multiplicity="1" />
          <End Role="Employee" Type="Self.Employee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Subdivision">
              <PropertyRef Name="SubdivisionID" />
            </Principal>
            <Dependent Role="Employee">
              <PropertyRef Name="IDSubdivision" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeInBriefing_Briefing">
          <End Role="Briefing" Type="Self.Briefing" Multiplicity="1" />
          <End Role="EmployeeInBriefing" Type="Self.EmployeeInBriefing" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Briefing">
              <PropertyRef Name="BriefingID" />
            </Principal>
            <Dependent Role="EmployeeInBriefing">
              <PropertyRef Name="IDBriefing" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeInBriefing_Employee">
          <End Role="Employee" Type="Self.Employee" Multiplicity="1" />
          <End Role="EmployeeInBriefing" Type="Self.EmployeeInBriefing" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employee">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeInBriefing">
              <PropertyRef Name="IDEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище gr672_pgvModelContainer">
          <EntitySet Name="Briefing" EntityType="Self.Briefing" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Employee" EntityType="Self.Employee" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeInBriefing" EntityType="Self.EmployeeInBriefing" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Position" EntityType="Self.Position" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Subdivision" EntityType="Self.Subdivision" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_Briefing_Employee" Association="Self.FK_Briefing_Employee">
            <End Role="Employee" EntitySet="Employee" />
            <End Role="Briefing" EntitySet="Briefing" />
          </AssociationSet>
          <AssociationSet Name="FK_Employee_Position" Association="Self.FK_Employee_Position">
            <End Role="Position" EntitySet="Position" />
            <End Role="Employee" EntitySet="Employee" />
          </AssociationSet>
          <AssociationSet Name="FK_Employee_Subdivision" Association="Self.FK_Employee_Subdivision">
            <End Role="Subdivision" EntitySet="Subdivision" />
            <End Role="Employee" EntitySet="Employee" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeInBriefing_Briefing" Association="Self.FK_EmployeeInBriefing_Briefing">
            <End Role="Briefing" EntitySet="Briefing" />
            <End Role="EmployeeInBriefing" EntitySet="EmployeeInBriefing" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeInBriefing_Employee" Association="Self.FK_EmployeeInBriefing_Employee">
            <End Role="Employee" EntitySet="Employee" />
            <End Role="EmployeeInBriefing" EntitySet="EmployeeInBriefing" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="gr672_pgvModel" 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="Briefing">
          <Key>
            <PropertyRef Name="BriefingID" />
          </Key>
          <Property Name="BriefingID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="IDInstructor" Type="Int32" Nullable="false" />
          <Property Name="Reason" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Note" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="IDEmployee" Type="Int32" Nullable="false" />
          <Property Name="IDType" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Employee" Relationship="Self.FK_Briefing_Employee" FromRole="Briefing" ToRole="Employee" />
          <NavigationProperty Name="EmployeeInBriefing" Relationship="Self.FK_EmployeeInBriefing_Briefing" FromRole="Briefing" ToRole="EmployeeInBriefing" />
        </EntityType>
        <EntityType Name="Employee">
          <Key>
            <PropertyRef Name="EmployeeID" />
          </Key>
          <Property Name="EmployeeID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="IsWorking" Type="Boolean" Nullable="false" />
          <Property Name="IDPosition" Type="Int32" Nullable="false" />
          <Property Name="BirthDate" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="IDSubdivision" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Briefing" Relationship="Self.FK_Briefing_Employee" FromRole="Employee" ToRole="Briefing" />
          <NavigationProperty Name="Position" Relationship="Self.FK_Employee_Position" FromRole="Employee" ToRole="Position" />
          <NavigationProperty Name="Subdivision" Relationship="Self.FK_Employee_Subdivision" FromRole="Employee" ToRole="Subdivision" />
          <NavigationProperty Name="EmployeeInBriefing" Relationship="Self.FK_EmployeeInBriefing_Employee" FromRole="Employee" ToRole="EmployeeInBriefing" />
        </EntityType>
        <EntityType Name="EmployeeInBriefing">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="IDEmployee" Type="Int32" Nullable="false" />
          <Property Name="IDBriefing" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Briefing" Relationship="Self.FK_EmployeeInBriefing_Briefing" FromRole="EmployeeInBriefing" ToRole="Briefing" />
          <NavigationProperty Name="Employee" Relationship="Self.FK_EmployeeInBriefing_Employee" FromRole="EmployeeInBriefing" ToRole="Employee" />
        </EntityType>
        <EntityType Name="Position">
          <Key>
            <PropertyRef Name="PositionID" />
          </Key>
          <Property Name="PositionID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="PositionName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="Employee" Relationship="Self.FK_Employee_Position" FromRole="Position" ToRole="Employee" />
        </EntityType>
        <EntityType Name="Subdivision">
          <Key>
            <PropertyRef Name="SubdivisionID" />
          </Key>
          <Property Name="SubdivisionID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="SubdivisionName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="Employee" Relationship="Self.FK_Employee_Subdivision" FromRole="Subdivision" ToRole="Employee" />
        </EntityType>
        <Association Name="FK_Briefing_Employee">
          <End Role="Employee" Type="Self.Employee" Multiplicity="1" />
          <End Role="Briefing" Type="Self.Briefing" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employee">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="Briefing">
              <PropertyRef Name="IDInstructor" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeInBriefing_Briefing">
          <End Role="Briefing" Type="Self.Briefing" Multiplicity="1" />
          <End Role="EmployeeInBriefing" Type="Self.EmployeeInBriefing" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Briefing">
              <PropertyRef Name="BriefingID" />
            </Principal>
            <Dependent Role="EmployeeInBriefing">
              <PropertyRef Name="IDBriefing" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Employee_Position">
          <End Role="Position" Type="Self.Position" Multiplicity="1" />
          <End Role="Employee" Type="Self.Employee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Position">
              <PropertyRef Name="PositionID" />
            </Principal>
            <Dependent Role="Employee">
              <PropertyRef Name="IDPosition" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Employee_Subdivision">
          <End Role="Subdivision" Type="Self.Subdivision" Multiplicity="1" />
          <End Role="Employee" Type="Self.Employee" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Subdivision">
              <PropertyRef Name="SubdivisionID" />
            </Principal>
            <Dependent Role="Employee">
              <PropertyRef Name="IDSubdivision" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeInBriefing_Employee">
          <End Role="Employee" Type="Self.Employee" Multiplicity="1" />
          <End Role="EmployeeInBriefing" Type="Self.EmployeeInBriefing" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employee">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeInBriefing">
              <PropertyRef Name="IDEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="gr672_pgvEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Briefing" EntityType="Self.Briefing" />
          <EntitySet Name="Employee" EntityType="Self.Employee" />
          <EntitySet Name="EmployeeInBriefing" EntityType="Self.EmployeeInBriefing" />
          <EntitySet Name="Position" EntityType="Self.Position" />
          <EntitySet Name="Subdivision" EntityType="Self.Subdivision" />
          <AssociationSet Name="FK_Briefing_Employee" Association="Self.FK_Briefing_Employee">
            <End Role="Employee" EntitySet="Employee" />
            <End Role="Briefing" EntitySet="Briefing" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeInBriefing_Briefing" Association="Self.FK_EmployeeInBriefing_Briefing">
            <End Role="Briefing" EntitySet="Briefing" />
            <End Role="EmployeeInBriefing" EntitySet="EmployeeInBriefing" />
          </AssociationSet>
          <AssociationSet Name="FK_Employee_Position" Association="Self.FK_Employee_Position">
            <End Role="Position" EntitySet="Position" />
            <End Role="Employee" EntitySet="Employee" />
          </AssociationSet>
          <AssociationSet Name="FK_Employee_Subdivision" Association="Self.FK_Employee_Subdivision">
            <End Role="Subdivision" EntitySet="Subdivision" />
            <End Role="Employee" EntitySet="Employee" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeInBriefing_Employee" Association="Self.FK_EmployeeInBriefing_Employee">
            <End Role="Employee" EntitySet="Employee" />
            <End Role="EmployeeInBriefing" EntitySet="EmployeeInBriefing" />
          </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="Хранилище gr672_pgvModelContainer" CdmEntityContainer="gr672_pgvEntities">
          <EntitySetMapping Name="Briefing">
            <EntityTypeMapping TypeName="gr672_pgvModel.Briefing">
              <MappingFragment StoreEntitySet="Briefing">
                <ScalarProperty Name="BriefingID" ColumnName="BriefingID" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="IDInstructor" ColumnName="IDInstructor" />
                <ScalarProperty Name="Reason" ColumnName="Reason" />
                <ScalarProperty Name="Note" ColumnName="Note" />
                <ScalarProperty Name="IDEmployee" ColumnName="IDEmployee" />
                <ScalarProperty Name="IDType" ColumnName="IDType" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Employee">
            <EntityTypeMapping TypeName="gr672_pgvModel.Employee">
              <MappingFragment StoreEntitySet="Employee">
                <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="IsWorking" ColumnName="IsWorking" />
                <ScalarProperty Name="IDPosition" ColumnName="IDPosition" />
                <ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
                <ScalarProperty Name="IDSubdivision" ColumnName="IDSubdivision" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeInBriefing">
            <EntityTypeMapping TypeName="gr672_pgvModel.EmployeeInBriefing">
              <MappingFragment StoreEntitySet="EmployeeInBriefing">
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="IDEmployee" ColumnName="IDEmployee" />
                <ScalarProperty Name="IDBriefing" ColumnName="IDBriefing" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Position">
            <EntityTypeMapping TypeName="gr672_pgvModel.Position">
              <MappingFragment StoreEntitySet="Position">
                <ScalarProperty Name="PositionID" ColumnName="PositionID" />
                <ScalarProperty Name="PositionName" ColumnName="PositionName" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Subdivision">
            <EntityTypeMapping TypeName="gr672_pgvModel.Subdivision">
              <MappingFragment StoreEntitySet="Subdivision">
                <ScalarProperty Name="SubdivisionID" ColumnName="SubdivisionID" />
                <ScalarProperty Name="SubdivisionName" ColumnName="SubdivisionName" />
              </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="Нет" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>