GasStation/Server/obj/Debug/edmxResourcesToEmbed/GasStationModel.ssdl

<?xml version="1.0" encoding="utf-8"?>
<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="Car">
    <Key>
      <PropertyRef Name="CarID" />
    </Key>
    <Property Name="CarID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="CarNumber" Type="nvarchar" MaxLength="9" Nullable="false" />
    <Property Name="VolumeTank" Type="int" />
    <Property Name="IDClient" Type="int" />
  </EntityType>
  <EntityType Name="Card">
    <Key>
      <PropertyRef Name="CardID" />
    </Key>
    <Property Name="CardID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="NumberCard" Type="nvarchar" MaxLength="20" Nullable="false" />
    <Property Name="CardExpDate" Type="nvarchar" MaxLength="10" Nullable="false" />
    <Property Name="Balance" Type="money" Nullable="false" />
    <Property Name="IDCardType" Type="int" Nullable="false" />
    <Property Name="IDCardIssuer" Type="int" />
    <Property Name="IDHolder" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="CardIssuer">
    <Key>
      <PropertyRef Name="CardIssuerID" />
    </Key>
    <Property Name="CardIssuerID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="NameCardIssuer" Type="nvarchar" MaxLength="50" Nullable="false" />
  </EntityType>
  <EntityType Name="CardType">
    <Key>
      <PropertyRef Name="CardTypeID" />
    </Key>
    <Property Name="CardTypeID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="NameType" Type="nvarchar" MaxLength="50" Nullable="false" />
  </EntityType>
  <EntityType Name="Client">
    <Key>
      <PropertyRef Name="ClientID" />
    </Key>
    <Property Name="ClientID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
    <Property Name="Name" Type="nvarchar" MaxLength="50" Nullable="false" />
  </EntityType>
  <EntityType Name="DataOfCamera">
    <Key>
      <PropertyRef Name="DataOfCameraID" />
    </Key>
    <Property Name="DataOfCameraID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Date" Type="datetime" Nullable="false" />
    <Property Name="Status" Type="bit" Nullable="false" />
    <Property Name="CarNumber" Type="nvarchar" MaxLength="9" />
    <Property Name="NameImage" Type="nvarchar(max)" Nullable="false" />
  </EntityType>
  <EntityType Name="FuelType">
    <Key>
      <PropertyRef Name="FuelTypeID" />
    </Key>
    <Property Name="FuelTypeID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="NameFuelType" Type="nvarchar" MaxLength="2" Nullable="false" />
  </EntityType>
  <EntityType Name="FuelTypeOnGasStation">
    <Key>
      <PropertyRef Name="IDGasStation" />
      <PropertyRef Name="IDFuelType" />
    </Key>
    <Property Name="IDGasStation" Type="int" Nullable="false" />
    <Property Name="IDFuelType" Type="int" Nullable="false" />
    <Property Name="Price" Type="float" Nullable="false" />
    <Property Name="AmountOfFuel" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="GasStation">
    <Key>
      <PropertyRef Name="GasStationID" />
    </Key>
    <Property Name="GasStationID" Type="int" Nullable="false" />
    <Property Name="Address" Type="nvarchar(max)" Nullable="false" />
  </EntityType>
  <EntityType Name="Payment">
    <Key>
      <PropertyRef Name="PaymentID" />
    </Key>
    <Property Name="PaymentID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="IDRefueling" Type="int" Nullable="false" />
    <Property Name="PriceRefueling" Type="money" Nullable="false" />
    <Property Name="Status" Type="bit" Nullable="false" />
    <Property Name="TransactionCode" Type="nvarchar" MaxLength="17" Nullable="false" />
    <Property Name="IDCard" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="Refueling">
    <Key>
      <PropertyRef Name="RefuelingID" />
    </Key>
    <Property Name="RefuelingID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="IDCar" Type="int" />
    <Property Name="VolumeFuel" Type="int" Nullable="false" />
    <Property Name="IDDataOfCamera" Type="int" />
    <Property Name="KeySession" Type="nvarchar" MaxLength="12" Nullable="false" />
    <Property Name="IDRefulingGun" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="RefuelingColumn">
    <Key>
      <PropertyRef Name="RefuelingColumnID" />
    </Key>
    <Property Name="RefuelingColumnID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="IDGasStation" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="RefuelingGun">
    <Key>
      <PropertyRef Name="RefuelingGunID" />
    </Key>
    <Property Name="RefuelingGunID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="IDRefuelingColumn" Type="int" Nullable="false" />
    <Property Name="IDFuelType" Type="int" Nullable="false" />
  </EntityType>
  <Association Name="FK_Car_Client">
    <End Role="Client" Type="Self.Client" Multiplicity="0..1" />
    <End Role="Car" Type="Self.Car" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Client">
        <PropertyRef Name="ClientID" />
      </Principal>
      <Dependent Role="Car">
        <PropertyRef Name="IDClient" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Card_CardIssuer">
    <End Role="CardIssuer" Type="Self.CardIssuer" Multiplicity="0..1" />
    <End Role="Card" Type="Self.Card" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="CardIssuer">
        <PropertyRef Name="CardIssuerID" />
      </Principal>
      <Dependent Role="Card">
        <PropertyRef Name="IDCardIssuer" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Card_CardType">
    <End Role="CardType" Type="Self.CardType" Multiplicity="1" />
    <End Role="Card" Type="Self.Card" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="CardType">
        <PropertyRef Name="CardTypeID" />
      </Principal>
      <Dependent Role="Card">
        <PropertyRef Name="IDCardType" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Card_Client">
    <End Role="Client" Type="Self.Client" Multiplicity="1" />
    <End Role="Card" Type="Self.Card" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Client">
        <PropertyRef Name="ClientID" />
      </Principal>
      <Dependent Role="Card">
        <PropertyRef Name="IDHolder" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_FuelInGasStation_GasStation">
    <End Role="GasStation" Type="Self.GasStation" Multiplicity="1" />
    <End Role="FuelTypeOnGasStation" Type="Self.FuelTypeOnGasStation" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="GasStation">
        <PropertyRef Name="GasStationID" />
      </Principal>
      <Dependent Role="FuelTypeOnGasStation">
        <PropertyRef Name="IDGasStation" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_FuelInGasStation_TypeOfFuel">
    <End Role="FuelType" Type="Self.FuelType" Multiplicity="1" />
    <End Role="FuelTypeOnGasStation" Type="Self.FuelTypeOnGasStation" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="FuelType">
        <PropertyRef Name="FuelTypeID" />
      </Principal>
      <Dependent Role="FuelTypeOnGasStation">
        <PropertyRef Name="IDFuelType" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Payment_Card">
    <End Role="Card" Type="Self.Card" Multiplicity="1" />
    <End Role="Payment" Type="Self.Payment" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Card">
        <PropertyRef Name="CardID" />
      </Principal>
      <Dependent Role="Payment">
        <PropertyRef Name="IDCard" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Payment_Refueling">
    <End Role="Refueling" Type="Self.Refueling" Multiplicity="1" />
    <End Role="Payment" Type="Self.Payment" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Refueling">
        <PropertyRef Name="RefuelingID" />
      </Principal>
      <Dependent Role="Payment">
        <PropertyRef Name="IDRefueling" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Refueling_Car">
    <End Role="Car" Type="Self.Car" Multiplicity="0..1" />
    <End Role="Refueling" Type="Self.Refueling" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Car">
        <PropertyRef Name="CarID" />
      </Principal>
      <Dependent Role="Refueling">
        <PropertyRef Name="IDCar" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Refueling_DataOfCamera">
    <End Role="DataOfCamera" Type="Self.DataOfCamera" Multiplicity="0..1" />
    <End Role="Refueling" Type="Self.Refueling" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="DataOfCamera">
        <PropertyRef Name="DataOfCameraID" />
      </Principal>
      <Dependent Role="Refueling">
        <PropertyRef Name="IDDataOfCamera" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Refueling_RefuelingGun">
    <End Role="RefuelingGun" Type="Self.RefuelingGun" Multiplicity="1" />
    <End Role="Refueling" Type="Self.Refueling" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="RefuelingGun">
        <PropertyRef Name="RefuelingGunID" />
      </Principal>
      <Dependent Role="Refueling">
        <PropertyRef Name="IDRefulingGun" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_RefuelingColumn_GasStation">
    <End Role="GasStation" Type="Self.GasStation" Multiplicity="1" />
    <End Role="RefuelingColumn" Type="Self.RefuelingColumn" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="GasStation">
        <PropertyRef Name="GasStationID" />
      </Principal>
      <Dependent Role="RefuelingColumn">
        <PropertyRef Name="IDGasStation" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_RefuelingGun_FuelType">
    <End Role="FuelType" Type="Self.FuelType" Multiplicity="1" />
    <End Role="RefuelingGun" Type="Self.RefuelingGun" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="FuelType">
        <PropertyRef Name="FuelTypeID" />
      </Principal>
      <Dependent Role="RefuelingGun">
        <PropertyRef Name="IDFuelType" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_RefuelingGun_RefuelingColumn">
    <End Role="RefuelingColumn" Type="Self.RefuelingColumn" Multiplicity="1" />
    <End Role="RefuelingGun" Type="Self.RefuelingGun" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="RefuelingColumn">
        <PropertyRef Name="RefuelingColumnID" />
      </Principal>
      <Dependent Role="RefuelingGun">
        <PropertyRef Name="IDRefuelingColumn" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <EntityContainer Name="Хранилище gr672_pgvModelContainer">
    <EntitySet Name="Car" EntityType="Self.Car" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Card" EntityType="Self.Card" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="CardIssuer" EntityType="Self.CardIssuer" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="CardType" EntityType="Self.CardType" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Client" EntityType="Self.Client" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="DataOfCamera" EntityType="Self.DataOfCamera" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="FuelType" EntityType="Self.FuelType" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="FuelTypeOnGasStation" EntityType="Self.FuelTypeOnGasStation" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="GasStation" EntityType="Self.GasStation" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Payment" EntityType="Self.Payment" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Refueling" EntityType="Self.Refueling" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="RefuelingColumn" EntityType="Self.RefuelingColumn" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="RefuelingGun" EntityType="Self.RefuelingGun" Schema="dbo" store:Type="Tables" />
    <AssociationSet Name="FK_Car_Client" Association="Self.FK_Car_Client">
      <End Role="Client" EntitySet="Client" />
      <End Role="Car" EntitySet="Car" />
    </AssociationSet>
    <AssociationSet Name="FK_Card_CardIssuer" Association="Self.FK_Card_CardIssuer">
      <End Role="CardIssuer" EntitySet="CardIssuer" />
      <End Role="Card" EntitySet="Card" />
    </AssociationSet>
    <AssociationSet Name="FK_Card_CardType" Association="Self.FK_Card_CardType">
      <End Role="CardType" EntitySet="CardType" />
      <End Role="Card" EntitySet="Card" />
    </AssociationSet>
    <AssociationSet Name="FK_Card_Client" Association="Self.FK_Card_Client">
      <End Role="Client" EntitySet="Client" />
      <End Role="Card" EntitySet="Card" />
    </AssociationSet>
    <AssociationSet Name="FK_FuelInGasStation_GasStation" Association="Self.FK_FuelInGasStation_GasStation">
      <End Role="GasStation" EntitySet="GasStation" />
      <End Role="FuelTypeOnGasStation" EntitySet="FuelTypeOnGasStation" />
    </AssociationSet>
    <AssociationSet Name="FK_FuelInGasStation_TypeOfFuel" Association="Self.FK_FuelInGasStation_TypeOfFuel">
      <End Role="FuelType" EntitySet="FuelType" />
      <End Role="FuelTypeOnGasStation" EntitySet="FuelTypeOnGasStation" />
    </AssociationSet>
    <AssociationSet Name="FK_Payment_Card" Association="Self.FK_Payment_Card">
      <End Role="Card" EntitySet="Card" />
      <End Role="Payment" EntitySet="Payment" />
    </AssociationSet>
    <AssociationSet Name="FK_Payment_Refueling" Association="Self.FK_Payment_Refueling">
      <End Role="Refueling" EntitySet="Refueling" />
      <End Role="Payment" EntitySet="Payment" />
    </AssociationSet>
    <AssociationSet Name="FK_Refueling_Car" Association="Self.FK_Refueling_Car">
      <End Role="Car" EntitySet="Car" />
      <End Role="Refueling" EntitySet="Refueling" />
    </AssociationSet>
    <AssociationSet Name="FK_Refueling_DataOfCamera" Association="Self.FK_Refueling_DataOfCamera">
      <End Role="DataOfCamera" EntitySet="DataOfCamera" />
      <End Role="Refueling" EntitySet="Refueling" />
    </AssociationSet>
    <AssociationSet Name="FK_Refueling_RefuelingGun" Association="Self.FK_Refueling_RefuelingGun">
      <End Role="RefuelingGun" EntitySet="RefuelingGun" />
      <End Role="Refueling" EntitySet="Refueling" />
    </AssociationSet>
    <AssociationSet Name="FK_RefuelingColumn_GasStation" Association="Self.FK_RefuelingColumn_GasStation">
      <End Role="GasStation" EntitySet="GasStation" />
      <End Role="RefuelingColumn" EntitySet="RefuelingColumn" />
    </AssociationSet>
    <AssociationSet Name="FK_RefuelingGun_FuelType" Association="Self.FK_RefuelingGun_FuelType">
      <End Role="FuelType" EntitySet="FuelType" />
      <End Role="RefuelingGun" EntitySet="RefuelingGun" />
    </AssociationSet>
    <AssociationSet Name="FK_RefuelingGun_RefuelingColumn" Association="Self.FK_RefuelingGun_RefuelingColumn">
      <End Role="RefuelingColumn" EntitySet="RefuelingColumn" />
      <End Role="RefuelingGun" EntitySet="RefuelingGun" />
    </AssociationSet>
  </EntityContainer>
</Schema>