CourseProject/Logistics application/Datebase.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="Хранилище gr682_ggi3Model" 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="Addressee">
          <Key>
            <PropertyRef Name="ID_Addressee" />
          </Key>
          <Property Name="ID_Addressee" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="PhotoNumber" Type="char" MaxLength="10" Nullable="false" />
          <Property Name="City" Type="nvarchar" MaxLength="15" Nullable="false" />
        </EntityType>
        <EntityType Name="Car">
          <Key>
            <PropertyRef Name="ID_Car" />
          </Key>
          <Property Name="ID_Car" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="MachineBrand" Type="nvarchar" MaxLength="15" />
          <Property Name="MachineType" Type="nvarchar" MaxLength="15" />
        </EntityType>
        <EntityType Name="Driver">
          <Key>
            <PropertyRef Name="ID_Driver" />
          </Key>
          <Property Name="ID_Driver" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="ID_Car" Type="int" />
          <Property Name="BrigadeNumber" Type="int" />
        </EntityType>
        <EntityType Name="Operator">
          <Key>
            <PropertyRef Name="ID_Operator" />
          </Key>
          <Property Name="ID_Operator" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Login" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Password" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="15" Nullable="false" />
        </EntityType>
        <EntityType Name="Order">
          <Key>
            <PropertyRef Name="ID_Order" />
          </Key>
          <Property Name="ID_Order" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="OrderNumber" Type="int" Nullable="false" />
          <Property Name="ID_Driver" Type="int" Nullable="false" />
          <Property Name="ID_Sender" Type="int" Nullable="false" />
          <Property Name="SenderCuty" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="DepartureDate" Type="date" Nullable="false" />
          <Property Name="ID_Addressee" Type="int" Nullable="false" />
          <Property Name="AddresseeCity" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="DateOfAddressee" Type="date" Nullable="false" />
        </EntityType>
        <EntityType Name="Route">
          <Key>
            <PropertyRef Name="ID_Route" />
          </Key>
          <Property Name="ID_Route" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="OrderNumber" Type="int" Nullable="false" />
          <Property Name="SenderCity" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="AddresseeCity" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="ShordRoute" Type="nvarchar" MaxLength="100" Nullable="false" />
        </EntityType>
        <EntityType Name="Sender">
          <Key>
            <PropertyRef Name="ID_Sender" />
          </Key>
          <Property Name="ID_Sender" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="PhoneNumber" Type="char" MaxLength="10" Nullable="false" />
          <Property Name="City" Type="nvarchar" MaxLength="15" Nullable="false" />
        </EntityType>
        <EntityContainer Name="Хранилище gr682_ggi3ModelContainer">
          <EntitySet Name="Addressee" EntityType="Self.Addressee" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Car" EntityType="Self.Car" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Driver" EntityType="Self.Driver" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Operator" EntityType="Self.Operator" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Order" EntityType="Self.Order" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Route" EntityType="Self.Route" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Sender" EntityType="Self.Sender" Schema="dbo" store:Type="Tables" />
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="gr682_ggi3Model" 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="Addressee">
          <Key>
            <PropertyRef Name="ID_Addressee" />
          </Key>
          <Property Name="ID_Addressee" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Surname" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="PhotoNumber" Type="String" MaxLength="10" FixedLength="true" Unicode="false" Nullable="false" />
          <Property Name="City" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="Car">
          <Key>
            <PropertyRef Name="ID_Car" />
          </Key>
          <Property Name="ID_Car" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="MachineBrand" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="MachineType" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="Driver">
          <Key>
            <PropertyRef Name="ID_Driver" />
          </Key>
          <Property Name="ID_Driver" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Surname" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="ID_Car" Type="Int32" />
          <Property Name="BrigadeNumber" Type="Int32" />
        </EntityType>
        <EntityType Name="Operator">
          <Key>
            <PropertyRef Name="ID_Operator" />
          </Key>
          <Property Name="ID_Operator" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <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" />
          <Property Name="Surname" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="Order">
          <Key>
            <PropertyRef Name="ID_Order" />
          </Key>
          <Property Name="ID_Order" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="OrderNumber" Type="Int32" Nullable="false" />
          <Property Name="ID_Driver" Type="Int32" Nullable="false" />
          <Property Name="ID_Sender" Type="Int32" Nullable="false" />
          <Property Name="SenderCuty" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="DepartureDate" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="ID_Addressee" Type="Int32" Nullable="false" />
          <Property Name="AddresseeCity" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="DateOfAddressee" Type="DateTime" Nullable="false" Precision="0" />
        </EntityType>
        <EntityType Name="Route">
          <Key>
            <PropertyRef Name="ID_Route" />
          </Key>
          <Property Name="ID_Route" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="OrderNumber" Type="Int32" Nullable="false" />
          <Property Name="SenderCity" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="AddresseeCity" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="ShordRoute" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="Sender">
          <Key>
            <PropertyRef Name="ID_Sender" />
          </Key>
          <Property Name="ID_Sender" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Surname" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="PhoneNumber" Type="String" MaxLength="10" FixedLength="true" Unicode="false" Nullable="false" />
          <Property Name="City" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityContainer Name="gr682_ggi3Entities1" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Addressee" EntityType="Self.Addressee" />
          <EntitySet Name="Car" EntityType="Self.Car" />
          <EntitySet Name="Driver" EntityType="Self.Driver" />
          <EntitySet Name="Operator" EntityType="Self.Operator" />
          <EntitySet Name="Order" EntityType="Self.Order" />
          <EntitySet Name="Route" EntityType="Self.Route" />
          <EntitySet Name="Sender" EntityType="Self.Sender" />
        </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="Хранилище gr682_ggi3ModelContainer" CdmEntityContainer="gr682_ggi3Entities1">
          <EntitySetMapping Name="Addressee">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Addressee">
              <MappingFragment StoreEntitySet="Addressee">
                <ScalarProperty Name="ID_Addressee" ColumnName="ID_Addressee" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="PhotoNumber" ColumnName="PhotoNumber" />
                <ScalarProperty Name="City" ColumnName="City" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Car">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Car">
              <MappingFragment StoreEntitySet="Car">
                <ScalarProperty Name="ID_Car" ColumnName="ID_Car" />
                <ScalarProperty Name="MachineBrand" ColumnName="MachineBrand" />
                <ScalarProperty Name="MachineType" ColumnName="MachineType" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Driver">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Driver">
              <MappingFragment StoreEntitySet="Driver">
                <ScalarProperty Name="ID_Driver" ColumnName="ID_Driver" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="ID_Car" ColumnName="ID_Car" />
                <ScalarProperty Name="BrigadeNumber" ColumnName="BrigadeNumber" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Operator">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Operator">
              <MappingFragment StoreEntitySet="Operator">
                <ScalarProperty Name="ID_Operator" ColumnName="ID_Operator" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Order">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Order">
              <MappingFragment StoreEntitySet="Order">
                <ScalarProperty Name="ID_Order" ColumnName="ID_Order" />
                <ScalarProperty Name="OrderNumber" ColumnName="OrderNumber" />
                <ScalarProperty Name="ID_Driver" ColumnName="ID_Driver" />
                <ScalarProperty Name="ID_Sender" ColumnName="ID_Sender" />
                <ScalarProperty Name="SenderCuty" ColumnName="SenderCuty" />
                <ScalarProperty Name="DepartureDate" ColumnName="DepartureDate" />
                <ScalarProperty Name="ID_Addressee" ColumnName="ID_Addressee" />
                <ScalarProperty Name="AddresseeCity" ColumnName="AddresseeCity" />
                <ScalarProperty Name="DateOfAddressee" ColumnName="DateOfAddressee" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Route">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Route">
              <MappingFragment StoreEntitySet="Route">
                <ScalarProperty Name="ID_Route" ColumnName="ID_Route" />
                <ScalarProperty Name="OrderNumber" ColumnName="OrderNumber" />
                <ScalarProperty Name="SenderCity" ColumnName="SenderCity" />
                <ScalarProperty Name="AddresseeCity" ColumnName="AddresseeCity" />
                <ScalarProperty Name="ShordRoute" ColumnName="ShordRoute" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Sender">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Sender">
              <MappingFragment StoreEntitySet="Sender">
                <ScalarProperty Name="ID_Sender" ColumnName="ID_Sender" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="PhoneNumber" ColumnName="PhoneNumber" />
                <ScalarProperty Name="City" ColumnName="City" />
              </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>