QWE/Firewatch 2.0/dbDE.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="Хранилище gr601_kayualModel" 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="Fire">
          <Key>
            <PropertyRef Name="Fire_ID" />
          </Key>
          <Property Name="Fire_ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Area" Type="int" Nullable="false" />
          <Property Name="StartDate" Type="date" Nullable="false" />
          <Property Name="EndDate" Type="date" />
          <Property Name="FirePower" Type="int" Nullable="false" />
          <Property Name="FKForestID" Type="int" />
          <Property Name="FKFirehouseID" Type="int" />
        </EntityType>
        <EntityType Name="Firehouse">
          <Key>
            <PropertyRef Name="Firehouse_ID" />
          </Key>
          <Property Name="Firehouse_ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="FirehouseTitle" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="Fireman">
          <Key>
            <PropertyRef Name="Fireman_ID" />
          </Key>
          <Property Name="Fireman_ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="FirstName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="50" />
          <Property Name="FKTeamID" Type="int" />
        </EntityType>
        <EntityType Name="Forest">
          <Key>
            <PropertyRef Name="Forest_ID" />
          </Key>
          <Property Name="Forest_ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="ForestTitle" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Area" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="StaffIS">
          <Key>
            <PropertyRef Name="StaffIS_ID" />
          </Key>
          <Property Name="StaffIS_ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="FirstName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="50" />
          <Property Name="Login" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Password" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="Team">
          <Key>
            <PropertyRef Name="Team_ID" />
          </Key>
          <Property Name="Team_ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="TeamTitle" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="FKFirehouseID" Type="int" />
        </EntityType>
        <Association Name="FK_Firehouse_ID">
          <End Role="Firehouse" Type="Self.Firehouse" Multiplicity="0..1" />
          <End Role="Team" Type="Self.Team" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Firehouse">
              <PropertyRef Name="Firehouse_ID" />
            </Principal>
            <Dependent Role="Team">
              <PropertyRef Name="FKFirehouseID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Firehousee_ID">
          <End Role="Firehouse" Type="Self.Firehouse" Multiplicity="0..1" />
          <End Role="Fire" Type="Self.Fire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Firehouse">
              <PropertyRef Name="Firehouse_ID" />
            </Principal>
            <Dependent Role="Fire">
              <PropertyRef Name="FKFirehouseID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Forest_ID">
          <End Role="Forest" Type="Self.Forest" Multiplicity="0..1" />
          <End Role="Fire" Type="Self.Fire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Forest">
              <PropertyRef Name="Forest_ID" />
            </Principal>
            <Dependent Role="Fire">
              <PropertyRef Name="FKForestID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Team_ID">
          <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
          <End Role="Fireman" Type="Self.Fireman" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Team">
              <PropertyRef Name="Team_ID" />
            </Principal>
            <Dependent Role="Fireman">
              <PropertyRef Name="FKTeamID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище gr601_kayualModelContainer">
          <EntitySet Name="Fire" EntityType="Self.Fire" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Firehouse" EntityType="Self.Firehouse" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Fireman" EntityType="Self.Fireman" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Forest" EntityType="Self.Forest" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="StaffIS" EntityType="Self.StaffIS" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Team" EntityType="Self.Team" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_Firehouse_ID" Association="Self.FK_Firehouse_ID">
            <End Role="Firehouse" EntitySet="Firehouse" />
            <End Role="Team" EntitySet="Team" />
          </AssociationSet>
          <AssociationSet Name="FK_Firehousee_ID" Association="Self.FK_Firehousee_ID">
            <End Role="Firehouse" EntitySet="Firehouse" />
            <End Role="Fire" EntitySet="Fire" />
          </AssociationSet>
          <AssociationSet Name="FK_Forest_ID" Association="Self.FK_Forest_ID">
            <End Role="Forest" EntitySet="Forest" />
            <End Role="Fire" EntitySet="Fire" />
          </AssociationSet>
          <AssociationSet Name="FK_Team_ID" Association="Self.FK_Team_ID">
            <End Role="Team" EntitySet="Team" />
            <End Role="Fireman" EntitySet="Fireman" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="gr601_kayualModel" 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="Fire">
          <Key>
            <PropertyRef Name="Fire_ID" />
          </Key>
          <Property Name="Fire_ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Area" Type="Int32" Nullable="false" />
          <Property Name="StartDate" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="EndDate" Type="DateTime" Precision="0" />
          <Property Name="FirePower" Type="Int32" Nullable="false" />
          <Property Name="FKForestID" Type="Int32" />
          <Property Name="FKFirehouseID" Type="Int32" />
          <NavigationProperty Name="Firehouse" Relationship="Self.FK_Firehousee_ID" FromRole="Fire" ToRole="Firehouse" />
          <NavigationProperty Name="Forest" Relationship="Self.FK_Forest_ID" FromRole="Fire" ToRole="Forest" />
        </EntityType>
        <EntityType Name="Firehouse">
          <Key>
            <PropertyRef Name="Firehouse_ID" />
          </Key>
          <Property Name="Firehouse_ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="FirehouseTitle" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="Fire" Relationship="Self.FK_Firehousee_ID" FromRole="Firehouse" ToRole="Fire" />
          <NavigationProperty Name="Team" Relationship="Self.FK_Firehouse_ID" FromRole="Firehouse" ToRole="Team" />
        </EntityType>
        <EntityType Name="Fireman">
          <Key>
            <PropertyRef Name="Fireman_ID" />
          </Key>
          <Property Name="Fireman_ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="FirstName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="FKTeamID" Type="Int32" />
          <NavigationProperty Name="Team" Relationship="Self.FK_Team_ID" FromRole="Fireman" ToRole="Team" />
        </EntityType>
        <EntityType Name="Forest">
          <Key>
            <PropertyRef Name="Forest_ID" />
          </Key>
          <Property Name="Forest_ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="ForestTitle" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Area" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Fire" Relationship="Self.FK_Forest_ID" FromRole="Forest" ToRole="Fire" />
        </EntityType>
        <EntityType Name="StaffIS">
          <Key>
            <PropertyRef Name="StaffIS_ID" />
          </Key>
          <Property Name="StaffIS_ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="FirstName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Login" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="Team">
          <Key>
            <PropertyRef Name="Team_ID" />
          </Key>
          <Property Name="Team_ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="TeamTitle" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="FKFirehouseID" Type="Int32" />
          <NavigationProperty Name="Firehouse" Relationship="Self.FK_Firehouse_ID" FromRole="Team" ToRole="Firehouse" />
          <NavigationProperty Name="Fireman" Relationship="Self.FK_Team_ID" FromRole="Team" ToRole="Fireman" />
        </EntityType>
        <Association Name="FK_Firehousee_ID">
          <End Role="Firehouse" Type="Self.Firehouse" Multiplicity="0..1" />
          <End Role="Fire" Type="Self.Fire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Firehouse">
              <PropertyRef Name="Firehouse_ID" />
            </Principal>
            <Dependent Role="Fire">
              <PropertyRef Name="FKFirehouseID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Forest_ID">
          <End Role="Forest" Type="Self.Forest" Multiplicity="0..1" />
          <End Role="Fire" Type="Self.Fire" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Forest">
              <PropertyRef Name="Forest_ID" />
            </Principal>
            <Dependent Role="Fire">
              <PropertyRef Name="FKForestID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Firehouse_ID">
          <End Role="Firehouse" Type="Self.Firehouse" Multiplicity="0..1" />
          <End Role="Team" Type="Self.Team" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Firehouse">
              <PropertyRef Name="Firehouse_ID" />
            </Principal>
            <Dependent Role="Team">
              <PropertyRef Name="FKFirehouseID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Team_ID">
          <End Role="Team" Type="Self.Team" Multiplicity="0..1" />
          <End Role="Fireman" Type="Self.Fireman" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Team">
              <PropertyRef Name="Team_ID" />
            </Principal>
            <Dependent Role="Fireman">
              <PropertyRef Name="FKTeamID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="dbData" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Fires" EntityType="Self.Fire" />
          <EntitySet Name="Firehouses" EntityType="Self.Firehouse" />
          <EntitySet Name="Firemans" EntityType="Self.Fireman" />
          <EntitySet Name="Forests" EntityType="Self.Forest" />
          <EntitySet Name="StaffISs" EntityType="Self.StaffIS" />
          <EntitySet Name="Teams" EntityType="Self.Team" />
          <AssociationSet Name="FK_Firehousee_ID" Association="Self.FK_Firehousee_ID">
            <End Role="Firehouse" EntitySet="Firehouses" />
            <End Role="Fire" EntitySet="Fires" />
          </AssociationSet>
          <AssociationSet Name="FK_Forest_ID" Association="Self.FK_Forest_ID">
            <End Role="Forest" EntitySet="Forests" />
            <End Role="Fire" EntitySet="Fires" />
          </AssociationSet>
          <AssociationSet Name="FK_Firehouse_ID" Association="Self.FK_Firehouse_ID">
            <End Role="Firehouse" EntitySet="Firehouses" />
            <End Role="Team" EntitySet="Teams" />
          </AssociationSet>
          <AssociationSet Name="FK_Team_ID" Association="Self.FK_Team_ID">
            <End Role="Team" EntitySet="Teams" />
            <End Role="Fireman" EntitySet="Firemans" />
          </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="Хранилище gr601_kayualModelContainer" CdmEntityContainer="dbData">
          <EntitySetMapping Name="Fires">
            <EntityTypeMapping TypeName="gr601_kayualModel.Fire">
              <MappingFragment StoreEntitySet="Fire">
                <ScalarProperty Name="Fire_ID" ColumnName="Fire_ID" />
                <ScalarProperty Name="Area" ColumnName="Area" />
                <ScalarProperty Name="StartDate" ColumnName="StartDate" />
                <ScalarProperty Name="EndDate" ColumnName="EndDate" />
                <ScalarProperty Name="FirePower" ColumnName="FirePower" />
                <ScalarProperty Name="FKForestID" ColumnName="FKForestID" />
                <ScalarProperty Name="FKFirehouseID" ColumnName="FKFirehouseID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Firehouses">
            <EntityTypeMapping TypeName="gr601_kayualModel.Firehouse">
              <MappingFragment StoreEntitySet="Firehouse">
                <ScalarProperty Name="Firehouse_ID" ColumnName="Firehouse_ID" />
                <ScalarProperty Name="FirehouseTitle" ColumnName="FirehouseTitle" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Firemans">
            <EntityTypeMapping TypeName="gr601_kayualModel.Fireman">
              <MappingFragment StoreEntitySet="Fireman">
                <ScalarProperty Name="Fireman_ID" ColumnName="Fireman_ID" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="FKTeamID" ColumnName="FKTeamID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Forests">
            <EntityTypeMapping TypeName="gr601_kayualModel.Forest">
              <MappingFragment StoreEntitySet="Forest">
                <ScalarProperty Name="Forest_ID" ColumnName="Forest_ID" />
                <ScalarProperty Name="ForestTitle" ColumnName="ForestTitle" />
                <ScalarProperty Name="Area" ColumnName="Area" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="StaffISs">
            <EntityTypeMapping TypeName="gr601_kayualModel.StaffIS">
              <MappingFragment StoreEntitySet="StaffIS">
                <ScalarProperty Name="StaffIS_ID" ColumnName="StaffIS_ID" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="Password" ColumnName="Password" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Teams">
            <EntityTypeMapping TypeName="gr601_kayualModel.Team">
              <MappingFragment StoreEntitySet="Team">
                <ScalarProperty Name="Team_ID" ColumnName="Team_ID" />
                <ScalarProperty Name="TeamTitle" ColumnName="TeamTitle" />
                <ScalarProperty Name="FKFirehouseID" ColumnName="FKFirehouseID" />
              </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>