1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 |
- <?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="FuelType" EntityType="gr672_pgvModel.FuelType" />
- <EntitySet Name="FuelTypeOnGasStation" EntityType="gr672_pgvModel.FuelTypeOnGasStation" />
- <EntitySet Name="GasStation" EntityType="gr672_pgvModel.GasStation" />
- <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_FuelInGasStation_GasStation" Association="gr672_pgvModel.FK_FuelInGasStation_GasStation">
- <End Role="GasStation" EntitySet="GasStation" />
- <End Role="FuelTypeOnGasStation" EntitySet="FuelTypeOnGasStation" />
- </AssociationSet>
- </EntityContainer>
- <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" />
- </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" />
- </EntityType>
- <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_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>
- </Schema>
|