CourseProject/Logistics application/obj/Debug/edmxResourcesToEmbed/Datebase.ssdl

<?xml version="1.0" encoding="utf-8"?>
<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>