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

<?xml version="1.0" encoding="utf-8"?>
<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">
  <EntityContainer Name="gr672_pgvEntities" annotation:LazyLoadingEnabled="true">
    <EntitySet Name="Car" EntityType="gr672_pgvModel.Car" />
    <EntitySet Name="Card" EntityType="gr672_pgvModel.Card" />
    <EntitySet Name="CardIssuer" EntityType="gr672_pgvModel.CardIssuer" />
    <EntitySet Name="CardType" EntityType="gr672_pgvModel.CardType" />
    <EntitySet Name="Client" EntityType="gr672_pgvModel.Client" />
    <EntitySet Name="DataOfCamera" EntityType="gr672_pgvModel.DataOfCamera" />
    <EntitySet Name="FuelType" EntityType="gr672_pgvModel.FuelType" />
    <EntitySet Name="FuelTypeOnGasStation" EntityType="gr672_pgvModel.FuelTypeOnGasStation" />
    <EntitySet Name="GasStation" EntityType="gr672_pgvModel.GasStation" />
    <EntitySet Name="Payment" EntityType="gr672_pgvModel.Payment" />
    <EntitySet Name="Refueling" EntityType="gr672_pgvModel.Refueling" />
    <EntitySet Name="RefuelingColumn" EntityType="gr672_pgvModel.RefuelingColumn" />
    <EntitySet Name="RefuelingGun" EntityType="gr672_pgvModel.RefuelingGun" />
    <AssociationSet Name="FK_Car_Client" Association="gr672_pgvModel.FK_Car_Client">
      <End Role="Client" EntitySet="Client" />
      <End Role="Car" EntitySet="Car" />
    </AssociationSet>
    <AssociationSet Name="FK_Refueling_Car" Association="gr672_pgvModel.FK_Refueling_Car">
      <End Role="Car" EntitySet="Car" />
      <End Role="Refueling" EntitySet="Refueling" />
    </AssociationSet>
    <AssociationSet Name="FK_Card_CardIssuer" Association="gr672_pgvModel.FK_Card_CardIssuer">
      <End Role="CardIssuer" EntitySet="CardIssuer" />
      <End Role="Card" EntitySet="Card" />
    </AssociationSet>
    <AssociationSet Name="FK_Card_CardType" Association="gr672_pgvModel.FK_Card_CardType">
      <End Role="CardType" EntitySet="CardType" />
      <End Role="Card" EntitySet="Card" />
    </AssociationSet>
    <AssociationSet Name="FK_Card_Client" Association="gr672_pgvModel.FK_Card_Client">
      <End Role="Client" EntitySet="Client" />
      <End Role="Card" EntitySet="Card" />
    </AssociationSet>
    <AssociationSet Name="FK_Payment_Card" Association="gr672_pgvModel.FK_Payment_Card">
      <End Role="Card" EntitySet="Card" />
      <End Role="Payment" EntitySet="Payment" />
    </AssociationSet>
    <AssociationSet Name="FK_Refueling_DataOfCamera" Association="gr672_pgvModel.FK_Refueling_DataOfCamera">
      <End Role="DataOfCamera" EntitySet="DataOfCamera" />
      <End Role="Refueling" EntitySet="Refueling" />
    </AssociationSet>
    <AssociationSet Name="FK_FuelInGasStation_TypeOfFuel" Association="gr672_pgvModel.FK_FuelInGasStation_TypeOfFuel">
      <End Role="FuelType" EntitySet="FuelType" />
      <End Role="FuelTypeOnGasStation" EntitySet="FuelTypeOnGasStation" />
    </AssociationSet>
    <AssociationSet Name="FK_RefuelingGun_FuelType" Association="gr672_pgvModel.FK_RefuelingGun_FuelType">
      <End Role="FuelType" EntitySet="FuelType" />
      <End Role="RefuelingGun" EntitySet="RefuelingGun" />
    </AssociationSet>
    <AssociationSet Name="FK_FuelInGasStation_GasStation" Association="gr672_pgvModel.FK_FuelInGasStation_GasStation">
      <End Role="GasStation" EntitySet="GasStation" />
      <End Role="FuelTypeOnGasStation" EntitySet="FuelTypeOnGasStation" />
    </AssociationSet>
    <AssociationSet Name="FK_RefuelingColumn_GasStation" Association="gr672_pgvModel.FK_RefuelingColumn_GasStation">
      <End Role="GasStation" EntitySet="GasStation" />
      <End Role="RefuelingColumn" EntitySet="RefuelingColumn" />
    </AssociationSet>
    <AssociationSet Name="FK_Payment_Refueling" Association="gr672_pgvModel.FK_Payment_Refueling">
      <End Role="Refueling" EntitySet="Refueling" />
      <End Role="Payment" EntitySet="Payment" />
    </AssociationSet>
    <AssociationSet Name="FK_Refueling_RefuelingGun" Association="gr672_pgvModel.FK_Refueling_RefuelingGun">
      <End Role="RefuelingGun" EntitySet="RefuelingGun" />
      <End Role="Refueling" EntitySet="Refueling" />
    </AssociationSet>
    <AssociationSet Name="FK_RefuelingGun_RefuelingColumn" Association="gr672_pgvModel.FK_RefuelingGun_RefuelingColumn">
      <End Role="RefuelingColumn" EntitySet="RefuelingColumn" />
      <End Role="RefuelingGun" EntitySet="RefuelingGun" />
    </AssociationSet>
  </EntityContainer>
  <EntityType Name="Car">
    <Key>
      <PropertyRef Name="CarID" />
    </Key>
    <Property Name="CarID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="CarNumber" Type="String" Nullable="false" MaxLength="9" FixedLength="false" Unicode="true" />
    <Property Name="VolumeTank" Type="Int32" />
    <Property Name="IDClient" Type="Int32" />
    <NavigationProperty Name="Client" Relationship="gr672_pgvModel.FK_Car_Client" FromRole="Car" ToRole="Client" />
    <NavigationProperty Name="Refueling" Relationship="gr672_pgvModel.FK_Refueling_Car" FromRole="Car" ToRole="Refueling" />
  </EntityType>
  <EntityType Name="Card">
    <Key>
      <PropertyRef Name="CardID" />
    </Key>
    <Property Name="CardID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="NumberCard" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
    <Property Name="CardExpDate" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
    <Property Name="Balance" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
    <Property Name="IDCardType" Type="Int32" Nullable="false" />
    <Property Name="IDCardIssuer" Type="Int32" />
    <Property Name="IDHolder" Type="Int32" Nullable="false" />
    <NavigationProperty Name="CardIssuer" Relationship="gr672_pgvModel.FK_Card_CardIssuer" FromRole="Card" ToRole="CardIssuer" />
    <NavigationProperty Name="CardType" Relationship="gr672_pgvModel.FK_Card_CardType" FromRole="Card" ToRole="CardType" />
    <NavigationProperty Name="Client" Relationship="gr672_pgvModel.FK_Card_Client" FromRole="Card" ToRole="Client" />
    <NavigationProperty Name="Payment" Relationship="gr672_pgvModel.FK_Payment_Card" FromRole="Card" ToRole="Payment" />
  </EntityType>
  <EntityType Name="CardIssuer">
    <Key>
      <PropertyRef Name="CardIssuerID" />
    </Key>
    <Property Name="CardIssuerID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="NameCardIssuer" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Card" Relationship="gr672_pgvModel.FK_Card_CardIssuer" FromRole="CardIssuer" ToRole="Card" />
  </EntityType>
  <EntityType Name="CardType">
    <Key>
      <PropertyRef Name="CardTypeID" />
    </Key>
    <Property Name="CardTypeID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="NameType" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Card" Relationship="gr672_pgvModel.FK_Card_CardType" FromRole="CardType" ToRole="Card" />
  </EntityType>
  <EntityType Name="Client">
    <Key>
      <PropertyRef Name="ClientID" />
    </Key>
    <Property Name="ClientID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="LastName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Name" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Car" Relationship="gr672_pgvModel.FK_Car_Client" FromRole="Client" ToRole="Car" />
    <NavigationProperty Name="Card" Relationship="gr672_pgvModel.FK_Card_Client" FromRole="Client" ToRole="Card" />
  </EntityType>
  <EntityType Name="DataOfCamera">
    <Key>
      <PropertyRef Name="DataOfCameraID" />
    </Key>
    <Property Name="DataOfCameraID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Date" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="Status" Type="Boolean" Nullable="false" />
    <Property Name="CarNumber" Type="String" MaxLength="9" FixedLength="false" Unicode="true" />
    <Property Name="NameImage" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Refueling" Relationship="gr672_pgvModel.FK_Refueling_DataOfCamera" FromRole="DataOfCamera" ToRole="Refueling" />
  </EntityType>
  <EntityType Name="FuelType">
    <Key>
      <PropertyRef Name="FuelTypeID" />
    </Key>
    <Property Name="FuelTypeID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="NameFuelType" Type="String" Nullable="false" MaxLength="2" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="FuelTypeOnGasStation" Relationship="gr672_pgvModel.FK_FuelInGasStation_TypeOfFuel" FromRole="FuelType" ToRole="FuelTypeOnGasStation" />
    <NavigationProperty Name="RefuelingGun" Relationship="gr672_pgvModel.FK_RefuelingGun_FuelType" FromRole="FuelType" ToRole="RefuelingGun" />
  </EntityType>
  <EntityType Name="FuelTypeOnGasStation">
    <Key>
      <PropertyRef Name="IDGasStation" />
      <PropertyRef Name="IDFuelType" />
    </Key>
    <Property Name="IDGasStation" Type="Int32" Nullable="false" />
    <Property Name="IDFuelType" Type="Int32" Nullable="false" />
    <Property Name="Price" Type="Double" Nullable="false" />
    <Property Name="AmountOfFuel" Type="Int32" Nullable="false" />
    <NavigationProperty Name="FuelType" Relationship="gr672_pgvModel.FK_FuelInGasStation_TypeOfFuel" FromRole="FuelTypeOnGasStation" ToRole="FuelType" />
    <NavigationProperty Name="GasStation" Relationship="gr672_pgvModel.FK_FuelInGasStation_GasStation" FromRole="FuelTypeOnGasStation" ToRole="GasStation" />
  </EntityType>
  <EntityType Name="GasStation">
    <Key>
      <PropertyRef Name="GasStationID" />
    </Key>
    <Property Name="GasStationID" Type="Int32" Nullable="false" />
    <Property Name="Address" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="FuelTypeOnGasStation" Relationship="gr672_pgvModel.FK_FuelInGasStation_GasStation" FromRole="GasStation" ToRole="FuelTypeOnGasStation" />
    <NavigationProperty Name="RefuelingColumn" Relationship="gr672_pgvModel.FK_RefuelingColumn_GasStation" FromRole="GasStation" ToRole="RefuelingColumn" />
  </EntityType>
  <EntityType Name="Payment">
    <Key>
      <PropertyRef Name="PaymentID" />
    </Key>
    <Property Name="PaymentID" Type="Int32" Nullable="false" />
    <Property Name="IDRefueling" Type="Int32" Nullable="false" />
    <Property Name="PriceRefueling" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
    <Property Name="Status" Type="Boolean" Nullable="false" />
    <Property Name="TransactionCode" Type="String" Nullable="false" MaxLength="17" FixedLength="false" Unicode="true" />
    <Property Name="IDCard" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Card" Relationship="gr672_pgvModel.FK_Payment_Card" FromRole="Payment" ToRole="Card" />
    <NavigationProperty Name="Refueling" Relationship="gr672_pgvModel.FK_Payment_Refueling" FromRole="Payment" ToRole="Refueling" />
  </EntityType>
  <EntityType Name="Refueling">
    <Key>
      <PropertyRef Name="RefuelingID" />
    </Key>
    <Property Name="RefuelingID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="IDCar" Type="Int32" />
    <Property Name="VolumeFuel" Type="Int32" Nullable="false" />
    <Property Name="IDDataOfCamera" Type="Int32" />
    <Property Name="KeySession" Type="String" Nullable="false" MaxLength="12" FixedLength="false" Unicode="true" />
    <Property Name="IDRefulingGun" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Car" Relationship="gr672_pgvModel.FK_Refueling_Car" FromRole="Refueling" ToRole="Car" />
    <NavigationProperty Name="DataOfCamera" Relationship="gr672_pgvModel.FK_Refueling_DataOfCamera" FromRole="Refueling" ToRole="DataOfCamera" />
    <NavigationProperty Name="Payment" Relationship="gr672_pgvModel.FK_Payment_Refueling" FromRole="Refueling" ToRole="Payment" />
    <NavigationProperty Name="RefuelingGun" Relationship="gr672_pgvModel.FK_Refueling_RefuelingGun" FromRole="Refueling" ToRole="RefuelingGun" />
  </EntityType>
  <EntityType Name="RefuelingColumn">
    <Key>
      <PropertyRef Name="RefuelingColumnID" />
    </Key>
    <Property Name="RefuelingColumnID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="IDGasStation" Type="Int32" Nullable="false" />
    <NavigationProperty Name="GasStation" Relationship="gr672_pgvModel.FK_RefuelingColumn_GasStation" FromRole="RefuelingColumn" ToRole="GasStation" />
    <NavigationProperty Name="RefuelingGun" Relationship="gr672_pgvModel.FK_RefuelingGun_RefuelingColumn" FromRole="RefuelingColumn" ToRole="RefuelingGun" />
  </EntityType>
  <EntityType Name="RefuelingGun">
    <Key>
      <PropertyRef Name="RefuelingGunID" />
    </Key>
    <Property Name="RefuelingGunID" Type="Int32" Nullable="false" />
    <Property Name="IDRefuelingColumn" Type="Int32" Nullable="false" />
    <Property Name="IDFuelType" Type="Int32" Nullable="false" />
    <NavigationProperty Name="FuelType" Relationship="gr672_pgvModel.FK_RefuelingGun_FuelType" FromRole="RefuelingGun" ToRole="FuelType" />
    <NavigationProperty Name="Refueling" Relationship="gr672_pgvModel.FK_Refueling_RefuelingGun" FromRole="RefuelingGun" ToRole="Refueling" />
    <NavigationProperty Name="RefuelingColumn" Relationship="gr672_pgvModel.FK_RefuelingGun_RefuelingColumn" FromRole="RefuelingGun" ToRole="RefuelingColumn" />
  </EntityType>
  <Association Name="FK_Car_Client">
    <End Type="gr672_pgvModel.Client" Role="Client" Multiplicity="0..1" />
    <End Type="gr672_pgvModel.Car" Role="Car" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Client">
        <PropertyRef Name="ClientID" />
      </Principal>
      <Dependent Role="Car">
        <PropertyRef Name="IDClient" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Refueling_Car">
    <End Type="gr672_pgvModel.Car" Role="Car" Multiplicity="0..1" />
    <End Type="gr672_pgvModel.Refueling" Role="Refueling" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Car">
        <PropertyRef Name="CarID" />
      </Principal>
      <Dependent Role="Refueling">
        <PropertyRef Name="IDCar" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Card_CardIssuer">
    <End Type="gr672_pgvModel.CardIssuer" Role="CardIssuer" Multiplicity="0..1" />
    <End Type="gr672_pgvModel.Card" Role="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 Type="gr672_pgvModel.CardType" Role="CardType" Multiplicity="1" />
    <End Type="gr672_pgvModel.Card" Role="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 Type="gr672_pgvModel.Client" Role="Client" Multiplicity="1" />
    <End Type="gr672_pgvModel.Card" Role="Card" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Client">
        <PropertyRef Name="ClientID" />
      </Principal>
      <Dependent Role="Card">
        <PropertyRef Name="IDHolder" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Payment_Card">
    <End Type="gr672_pgvModel.Card" Role="Card" Multiplicity="1" />
    <End Type="gr672_pgvModel.Payment" Role="Payment" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Card">
        <PropertyRef Name="CardID" />
      </Principal>
      <Dependent Role="Payment">
        <PropertyRef Name="IDCard" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Refueling_DataOfCamera">
    <End Type="gr672_pgvModel.DataOfCamera" Role="DataOfCamera" Multiplicity="0..1" />
    <End Type="gr672_pgvModel.Refueling" Role="Refueling" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="DataOfCamera">
        <PropertyRef Name="DataOfCameraID" />
      </Principal>
      <Dependent Role="Refueling">
        <PropertyRef Name="IDDataOfCamera" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_FuelInGasStation_TypeOfFuel">
    <End Type="gr672_pgvModel.FuelType" Role="FuelType" Multiplicity="1" />
    <End Type="gr672_pgvModel.FuelTypeOnGasStation" Role="FuelTypeOnGasStation" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="FuelType">
        <PropertyRef Name="FuelTypeID" />
      </Principal>
      <Dependent Role="FuelTypeOnGasStation">
        <PropertyRef Name="IDFuelType" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_RefuelingGun_FuelType">
    <End Type="gr672_pgvModel.FuelType" Role="FuelType" Multiplicity="1" />
    <End Type="gr672_pgvModel.RefuelingGun" Role="RefuelingGun" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="FuelType">
        <PropertyRef Name="FuelTypeID" />
      </Principal>
      <Dependent Role="RefuelingGun">
        <PropertyRef Name="IDFuelType" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_FuelInGasStation_GasStation">
    <End Type="gr672_pgvModel.GasStation" Role="GasStation" Multiplicity="1" />
    <End Type="gr672_pgvModel.FuelTypeOnGasStation" Role="FuelTypeOnGasStation" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="GasStation">
        <PropertyRef Name="GasStationID" />
      </Principal>
      <Dependent Role="FuelTypeOnGasStation">
        <PropertyRef Name="IDGasStation" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_RefuelingColumn_GasStation">
    <End Type="gr672_pgvModel.GasStation" Role="GasStation" Multiplicity="1" />
    <End Type="gr672_pgvModel.RefuelingColumn" Role="RefuelingColumn" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="GasStation">
        <PropertyRef Name="GasStationID" />
      </Principal>
      <Dependent Role="RefuelingColumn">
        <PropertyRef Name="IDGasStation" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Payment_Refueling">
    <End Type="gr672_pgvModel.Refueling" Role="Refueling" Multiplicity="1" />
    <End Type="gr672_pgvModel.Payment" Role="Payment" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Refueling">
        <PropertyRef Name="RefuelingID" />
      </Principal>
      <Dependent Role="Payment">
        <PropertyRef Name="IDRefueling" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Refueling_RefuelingGun">
    <End Type="gr672_pgvModel.RefuelingGun" Role="RefuelingGun" Multiplicity="1" />
    <End Type="gr672_pgvModel.Refueling" Role="Refueling" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="RefuelingGun">
        <PropertyRef Name="RefuelingGunID" />
      </Principal>
      <Dependent Role="Refueling">
        <PropertyRef Name="IDRefulingGun" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_RefuelingGun_RefuelingColumn">
    <End Type="gr672_pgvModel.RefuelingColumn" Role="RefuelingColumn" Multiplicity="1" />
    <End Type="gr672_pgvModel.RefuelingGun" Role="RefuelingGun" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="RefuelingColumn">
        <PropertyRef Name="RefuelingColumnID" />
      </Principal>
      <Dependent Role="RefuelingGun">
        <PropertyRef Name="IDRefuelingColumn" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
</Schema>