3525 lines
192 KiB
XML
3525 lines
192 KiB
XML
<?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="Model.Store" 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="__RefactorLog">
|
|
<Key>
|
|
<PropertyRef Name="OperationKey" />
|
|
</Key>
|
|
<Property Name="OperationKey" Type="uniqueidentifier" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="AccountType">
|
|
<Key>
|
|
<PropertyRef Name="AccountTypeId" />
|
|
</Key>
|
|
<Property Name="AccountTypeId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Name" Type="varchar" MaxLength="256" />
|
|
</EntityType>
|
|
<EntityType Name="Adress">
|
|
<Key>
|
|
<PropertyRef Name="AdressId" />
|
|
</Key>
|
|
<Property Name="AdressId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Postcode" Type="varchar" MaxLength="16" />
|
|
<Property Name="Country" Type="varchar" MaxLength="50" />
|
|
<Property Name="Voivodship" Type="varchar" MaxLength="50" />
|
|
<Property Name="City" Type="varchar" MaxLength="50" />
|
|
<Property Name="Street" Type="varchar" MaxLength="50" />
|
|
<Property Name="Number" Type="varchar" MaxLength="50" />
|
|
</EntityType>
|
|
<EntityType Name="Client">
|
|
<Key>
|
|
<PropertyRef Name="ClientId" />
|
|
</Key>
|
|
<Property Name="ClientId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Name" Type="varchar" MaxLength="256" />
|
|
<Property Name="AdressId" Type="bigint" />
|
|
<Property Name="CompanyId" Type="bigint" />
|
|
<Property Name="IsRemoved" Type="bit" Nullable="false" />
|
|
<Property Name="DeletionDate" Type="datetime" />
|
|
<Property Name="DefaultContactId" Type="bigint" />
|
|
<Property Name="DefaultStartAdressId" Type="bigint" />
|
|
<Property Name="DefaultEndAdressId" Type="bigint" />
|
|
<Property Name="DefaultMachineId" Type="bigint" />
|
|
<Property Name="NIP" Type="varchar" MaxLength="254" />
|
|
<Property Name="PostAdressId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="Company">
|
|
<Key>
|
|
<PropertyRef Name="CompanyId" />
|
|
</Key>
|
|
<Property Name="CompanyId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Name" Type="varchar" MaxLength="256" />
|
|
<Property Name="AdressId" Type="bigint" />
|
|
<Property Name="NIP" Type="varchar" MaxLength="256" />
|
|
<Property Name="WlascicielId" Type="bigint" />
|
|
<Property Name="LastPaydate" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="Contact">
|
|
<Key>
|
|
<PropertyRef Name="ContactId" />
|
|
</Key>
|
|
<Property Name="ContactId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Name" Type="varchar" MaxLength="256" />
|
|
<Property Name="Surname" Type="varchar" MaxLength="256" />
|
|
<Property Name="IsOwner" Type="bit" />
|
|
<Property Name="ClientId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="Cost">
|
|
<Key>
|
|
<PropertyRef Name="CostId" />
|
|
</Key>
|
|
<Property Name="CostId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Describtion" Type="varchar" MaxLength="124" />
|
|
<Property Name="Cost" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="OrderId" Type="bigint" />
|
|
<Property Name="UserId" Type="bigint" />
|
|
<Property Name="MachineId" Type="bigint" />
|
|
<Property Name="PayDate" Type="datetime" />
|
|
<Property Name="DeletionDate" Type="datetime" />
|
|
<Property Name="CostTypeId" Type="bigint" />
|
|
<Property Name="WorktimeId" Type="bigint" />
|
|
<Property Name="CurrencyId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="Email">
|
|
<Key>
|
|
<PropertyRef Name="EmailId" />
|
|
</Key>
|
|
<Property Name="EmailId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Email" Type="varchar" MaxLength="50" />
|
|
<Property Name="ContactId" Type="bigint" />
|
|
<Property Name="WorkerId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="example">
|
|
<Key>
|
|
<PropertyRef Name="one" />
|
|
</Key>
|
|
<Property Name="one" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="two" Type="int" />
|
|
<Property Name="three" Type="varchar" MaxLength="32" />
|
|
<Property Name="fout" Type="varchar" MaxLength="256" />
|
|
<Property Name="five" Type="binary" MaxLength="64" />
|
|
<Property Name="six" Type="varchar" MaxLength="512" />
|
|
<Property Name="seven" Type="datetime" />
|
|
<Property Name="eight" Type="tinyint" Nullable="false" />
|
|
<Property Name="nine" Type="varchar" MaxLength="64" />
|
|
<Property Name="ten" Type="int" />
|
|
<Property Name="eleven" Type="varchar" MaxLength="256" />
|
|
<Property Name="twelve" Type="datetime" />
|
|
<Property Name="thirteen" Type="bit" />
|
|
<Property Name="fourteen" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="Ferry">
|
|
<Key>
|
|
<PropertyRef Name="FerryId" />
|
|
</Key>
|
|
<Property Name="FerryId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="From" Type="varchar" MaxLength="256" />
|
|
<Property Name="To" Type="varchar" MaxLength="256" />
|
|
<Property Name="StartDate" Type="datetime" />
|
|
<Property Name="EndDate" Type="datetime" />
|
|
<Property Name="Cost" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="IsReal" Type="bit" />
|
|
<Property Name="OrderId" Type="bigint" />
|
|
<Property Name="UserId" Type="bigint" />
|
|
<Property Name="MachineId" Type="bigint" />
|
|
<Property Name="PayDate" Type="datetime" />
|
|
<Property Name="DeletionDate" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="IPLoginFailed">
|
|
<Key>
|
|
<PropertyRef Name="IP" />
|
|
</Key>
|
|
<Property Name="IP" Type="varchar" MaxLength="45" Nullable="false" />
|
|
<Property Name="Count" Type="int" />
|
|
<Property Name="Date" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="LoginResult">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="UserId" Type="bigint" />
|
|
<Property Name="Type" Type="bit" />
|
|
<Property Name="Date" Type="datetime" />
|
|
<Property Name="Browser" Type="varchar" MaxLength="126" />
|
|
</EntityType>
|
|
<EntityType Name="Machine">
|
|
<Key>
|
|
<PropertyRef Name="MachineId" />
|
|
</Key>
|
|
<Property Name="MachineId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="RegistrationNumber" Type="varchar" MaxLength="50" />
|
|
<Property Name="Przebieg" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="Brand" Type="varchar" MaxLength="50" />
|
|
<Property Name="Owner" Type="varchar" MaxLength="50" />
|
|
<Property Name="FuelStatus" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="TachografLegalizationDate" Type="datetime" />
|
|
<Property Name="LastPrzegladDate" Type="datetime" />
|
|
<Property Name="ModelName" Type="varchar" MaxLength="50" />
|
|
<Property Name="CompanyId" Type="bigint" />
|
|
<Property Name="IsCiagnik" Type="bit" />
|
|
<Property Name="IsNaczepa" Type="bit" />
|
|
<Property Name="KierowcaId" Type="bigint" />
|
|
<Property Name="PrzypisanyCiagnikId" Type="bigint" />
|
|
<Property Name="IsDeleted" Type="bit" />
|
|
<Property Name="MaximalFuel" Type="bigint" />
|
|
<Property Name="VIN" Type="varchar" MaxLength="50" />
|
|
<Property Name="AxisSerialNumber" Type="varchar" MaxLength="50" />
|
|
<Property Name="RegistrationDate" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="MachineRepair">
|
|
<Key>
|
|
<PropertyRef Name="MachineRepairId" />
|
|
</Key>
|
|
<Property Name="MachineRepairId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="MachineId" Type="bigint" />
|
|
<Property Name="ServiceStartDate" Type="datetime" />
|
|
<Property Name="ServiceEndDate" Type="datetime" />
|
|
<Property Name="ServiceTypeId" Type="bigint" />
|
|
<Property Name="Cost" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="Description" Type="varchar" MaxLength="256" />
|
|
<Property Name="WorkstationId" Type="bigint" />
|
|
<Property Name="CurrencyId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="Notification">
|
|
<Key>
|
|
<PropertyRef Name="NotificationId" />
|
|
</Key>
|
|
<Property Name="NotificationId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Text" Type="nvarchar" MaxLength="255" />
|
|
<Property Name="IsSMS" Type="bit" />
|
|
<Property Name="IsPWA" Type="bit" />
|
|
<Property Name="CreationDate" Type="datetime" />
|
|
<Property Name="SentDate" Type="datetime" />
|
|
<Property Name="IsSend" Type="bit" />
|
|
<Property Name="UserId" Type="bigint" />
|
|
<Property Name="OrderId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="OrderContactConnection">
|
|
<Key>
|
|
<PropertyRef Name="OrderId" />
|
|
<PropertyRef Name="ContactId" />
|
|
</Key>
|
|
<Property Name="OrderId" Type="bigint" Nullable="false" />
|
|
<Property Name="ContactId" Type="bigint" Nullable="false" />
|
|
<Property Name="IsStartContact" Type="bit" Nullable="false" />
|
|
<Property Name="IsEndContact" Type="bit" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="OrderList">
|
|
<Key>
|
|
<PropertyRef Name="OrderListId" />
|
|
</Key>
|
|
<Property Name="OrderListId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="DataUtworzenia" Type="datetime" Nullable="false" />
|
|
<Property Name="CompanyId" Type="bigint" />
|
|
<Property Name="ClientId" Type="bigint" />
|
|
<Property Name="StartAdressId" Type="bigint" />
|
|
<Property Name="StartDate" Type="datetime" />
|
|
<Property Name="EndAdressId" Type="bigint" />
|
|
<Property Name="EndDate" Type="datetime" />
|
|
<Property Name="KwotaZlecenia" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="CiagnikId" Type="bigint" />
|
|
<Property Name="NaczepaId" Type="bigint" />
|
|
<Property Name="IsDeleted" Type="bit" />
|
|
<Property Name="DeletionDate" Type="datetime" />
|
|
<Property Name="OrderNumber" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="AwizoNumber" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="CurrencyId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="OrderUserConnection">
|
|
<Key>
|
|
<PropertyRef Name="OrderId" />
|
|
<PropertyRef Name="UserId" />
|
|
</Key>
|
|
<Property Name="OrderId" Type="bigint" Nullable="false" />
|
|
<Property Name="UserId" Type="bigint" Nullable="false" />
|
|
<Property Name="IsCurrentDriver" Type="bit" />
|
|
</EntityType>
|
|
<EntityType Name="OrderUserHistory">
|
|
<Key>
|
|
<PropertyRef Name="OrderUserHistoryId" />
|
|
</Key>
|
|
<Property Name="OrderUserHistoryId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="OrderId" Type="bigint" Nullable="false" />
|
|
<Property Name="UserFromId" Type="bigint" Nullable="false" />
|
|
<Property Name="UserToId" Type="bigint" Nullable="false" />
|
|
<Property Name="DateOfChange" Type="datetime" />
|
|
<Property Name="DateOfReporting" Type="datetime" />
|
|
<Property Name="AdressId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="PhoneNumber">
|
|
<Key>
|
|
<PropertyRef Name="PhoneId" />
|
|
</Key>
|
|
<Property Name="PhoneId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Number" Type="varchar" MaxLength="50" />
|
|
<Property Name="ContactId" Type="bigint" />
|
|
<Property Name="WorkerId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="SessionHistory">
|
|
<Key>
|
|
<PropertyRef Name="SessionHistoryId" />
|
|
</Key>
|
|
<Property Name="SessionHistoryId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="UserListId" Type="bigint" />
|
|
<Property Name="Amount" Type="int" />
|
|
<Property Name="ZeroingSessionDate" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="Slownik">
|
|
<Key>
|
|
<PropertyRef Name="SlownikId" />
|
|
</Key>
|
|
<Property Name="SlownikId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Name" Type="varchar" MaxLength="256" />
|
|
<Property Name="SlownikTypId" Type="bigint" Nullable="false" />
|
|
<Property Name="CompanyId" Type="bigint" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="SlownikTyp">
|
|
<Key>
|
|
<PropertyRef Name="SlownikTypId" />
|
|
</Key>
|
|
<Property Name="SlownikTypId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Name" Type="varchar" MaxLength="256" />
|
|
</EntityType>
|
|
<EntityType Name="SmsLog">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="PhoneNumber" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="Text" Type="nvarchar" MaxLength="255" />
|
|
<Property Name="CreationDate" Type="datetime" />
|
|
<Property Name="DateRead" Type="datetime" />
|
|
<Property Name="SendAfter" Type="datetime" />
|
|
<Property Name="BlockedSending" Type="bit" />
|
|
<Property Name="SentDate" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="SubskrypcjaPWASet">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Endpoint" Type="nvarchar" MaxLength="255" Nullable="false" />
|
|
<Property Name="p256dh" Type="nvarchar" MaxLength="100" Nullable="false" />
|
|
<Property Name="Auth" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="System" Type="nvarchar" MaxLength="30" />
|
|
<Property Name="IsActive" Type="bit" Nullable="false" />
|
|
<Property Name="IsAndroid" Type="bit" Nullable="false" />
|
|
<Property Name="UserListId" Type="bigint" />
|
|
</EntityType>
|
|
<EntityType Name="sysdiagrams">
|
|
<Key>
|
|
<PropertyRef Name="diagram_id" />
|
|
</Key>
|
|
<Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
|
|
<Property Name="principal_id" Type="int" Nullable="false" />
|
|
<Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="version" Type="int" />
|
|
<Property Name="definition" Type="varbinary(max)" />
|
|
</EntityType>
|
|
<EntityType Name="Ubezpieczenia">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="RokObowiazywania" Type="datetime" />
|
|
<Property Name="Zdrowotne" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="Emerytalne" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="Rentowe" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="Chorobowe" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="FunduszPracy" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="FGSP" Type="decimal" Precision="18" Scale="2" />
|
|
</EntityType>
|
|
<EntityType Name="UserList">
|
|
<Key>
|
|
<PropertyRef Name="UserId" />
|
|
</Key>
|
|
<Property Name="UserId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="CompanyId" Type="bigint" />
|
|
<Property Name="Login" Type="varchar" MaxLength="32" />
|
|
<Property Name="Password" Type="varchar" MaxLength="256" />
|
|
<Property Name="Salt" Type="binary" MaxLength="16" />
|
|
<Property Name="Session" Type="varchar" MaxLength="512" />
|
|
<Property Name="SessionCount" Type="int" />
|
|
<Property Name="SessionTime" Type="datetime" />
|
|
<Property Name="AccountTypeId" Type="bigint" Nullable="false" />
|
|
<Property Name="Email" Type="varchar" MaxLength="256" />
|
|
<Property Name="EmailVerifactionCode" Type="varchar" MaxLength="256" />
|
|
<Property Name="IsVerified" Type="bit" />
|
|
<Property Name="LoginFailed" Type="int" />
|
|
<Property Name="PasswordReset" Type="varchar" MaxLength="256" />
|
|
<Property Name="PasswordResetTime" Type="datetime" />
|
|
<Property Name="Deleted" Type="bit" />
|
|
<Property Name="DeletedDate" Type="datetime" />
|
|
<Property Name="LastWorktimeCostUpdate" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="Worker">
|
|
<Key>
|
|
<PropertyRef Name="WorkerId" />
|
|
</Key>
|
|
<Property Name="WorkerId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="UserListId" Type="bigint" />
|
|
<Property Name="Imie" Type="varchar" MaxLength="256" />
|
|
<Property Name="Nazwisko" Type="varchar" MaxLength="256" />
|
|
<Property Name="PESEL" Type="varchar" MaxLength="256" />
|
|
<Property Name="Birthdate" Type="varchar" MaxLength="256" />
|
|
<Property Name="AdressId" Type="bigint" />
|
|
<Property Name="Pensja" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="ContactId" Type="bigint" />
|
|
<Property Name="DrugieImie" Type="varchar" MaxLength="256" />
|
|
<Property Name="NrKonta" Type="varchar" MaxLength="256" />
|
|
<Property Name="SalaryTypeId" Type="bigint" />
|
|
<Property Name="CurrencyId" Type="bigint" />
|
|
<Property Name="UbezpieczenieWypadkowe" Type="decimal" Precision="18" Scale="2" />
|
|
<Property Name="CzyPracujeNaMiejscu" Type="bit" />
|
|
</EntityType>
|
|
<EntityType Name="WorkTime">
|
|
<Key>
|
|
<PropertyRef Name="WorkTimeId" />
|
|
</Key>
|
|
<Property Name="WorkTimeId" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="UserId" Type="bigint" Nullable="false" />
|
|
<Property Name="Start" Type="datetime" Nullable="false" />
|
|
<Property Name="End" Type="datetime" />
|
|
</EntityType>
|
|
<!--Errors Found During Generation:
|
|
warning 6002: The table/view 's434730_projekt-akm.dbo.CiagnikiList' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
|
<EntityType Name="CiagnikiList">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Nazwa" Type="varchar" MaxLength="50" />
|
|
<Property Name="CompanyId" Type="bigint" />
|
|
</EntityType>
|
|
<!--Errors Found During Generation:
|
|
warning 6002: The table/view 's434730_projekt-akm.dbo.PracownicyList' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
|
<EntityType Name="PracownicyList">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
|
<Property Name="Nazwa" Type="varchar" MaxLength="513" />
|
|
<Property Name="IsDeleted" Type="bit" />
|
|
<Property Name="AccountType" Type="varchar" MaxLength="256" />
|
|
<Property Name="CompanyId" Type="bigint" />
|
|
</EntityType>
|
|
<!--Errors Found During Generation:
|
|
warning 6002: The table/view 's434730_projekt-akm.dbo.ZleceniaList' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
|
<EntityType Name="ZleceniaList">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Nazwa" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="CompanyId" Type="bigint" />
|
|
</EntityType>
|
|
<Association Name="FK_ClientAdress">
|
|
<End Role="Adress" Type="Self.Adress" Multiplicity="0..1" />
|
|
<End Role="Client" Type="Self.Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="AdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientAdresWysylkowy">
|
|
<End Role="Adress" Type="Self.Adress" Multiplicity="0..1" />
|
|
<End Role="Client" Type="Self.Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="PostAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientCompany">
|
|
<End Role="Company" Type="Self.Company" Multiplicity="0..1" />
|
|
<End Role="Client" Type="Self.Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientDefaultContact">
|
|
<End Role="Contact" Type="Self.Contact" Multiplicity="0..1" />
|
|
<End Role="Client" Type="Self.Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="DefaultContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientDefaultEndAdress">
|
|
<End Role="Adress" Type="Self.Adress" Multiplicity="0..1" />
|
|
<End Role="Client" Type="Self.Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="DefaultEndAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientDefaultMachine">
|
|
<End Role="Machine" Type="Self.Machine" Multiplicity="0..1" />
|
|
<End Role="Client" Type="Self.Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="DefaultMachineId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientDefaultStartAdress">
|
|
<End Role="Adress" Type="Self.Adress" Multiplicity="0..1" />
|
|
<End Role="Client" Type="Self.Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="DefaultStartAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CompanyAdress">
|
|
<End Role="Adress" Type="Self.Adress" Multiplicity="0..1" />
|
|
<End Role="Company" Type="Self.Company" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Company">
|
|
<PropertyRef Name="AdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CompanyWlasciciel">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="0..1" />
|
|
<End Role="Company" Type="Self.Company" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Company">
|
|
<PropertyRef Name="WlascicielId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ContactClient">
|
|
<End Role="Client" Type="Self.Client" Multiplicity="0..1" />
|
|
<End Role="Contact" Type="Self.Contact" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Client">
|
|
<PropertyRef Name="ClientId" />
|
|
</Principal>
|
|
<Dependent Role="Contact">
|
|
<PropertyRef Name="ClientId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostCiagnik">
|
|
<End Role="Machine" Type="Self.Machine" Multiplicity="0..1" />
|
|
<End Role="Cost" Type="Self.Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="MachineId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostCurrency">
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="0..1" />
|
|
<End Role="Cost" Type="Self.Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="CurrencyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostOrder">
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="0..1" />
|
|
<End Role="Cost" Type="Self.Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostType">
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="0..1" />
|
|
<End Role="Cost" Type="Self.Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="CostTypeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostUser">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="0..1" />
|
|
<End Role="Cost" Type="Self.Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostWorktime">
|
|
<End Role="WorkTime" Type="Self.WorkTime" Multiplicity="0..1" />
|
|
<End Role="Cost" Type="Self.Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="WorkTime">
|
|
<PropertyRef Name="WorkTimeId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="WorktimeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_EmailContact">
|
|
<End Role="Contact" Type="Self.Contact" Multiplicity="0..1" />
|
|
<End Role="Email" Type="Self.Email" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="Email">
|
|
<PropertyRef Name="ContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_EmailWorker">
|
|
<End Role="Worker" Type="Self.Worker" Multiplicity="0..1" />
|
|
<End Role="Email" Type="Self.Email" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Worker">
|
|
<PropertyRef Name="WorkerId" />
|
|
</Principal>
|
|
<Dependent Role="Email">
|
|
<PropertyRef Name="WorkerId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_FerryCiagnik">
|
|
<End Role="Machine" Type="Self.Machine" Multiplicity="0..1" />
|
|
<End Role="Ferry" Type="Self.Ferry" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="Ferry">
|
|
<PropertyRef Name="MachineId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_FerryOrder">
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="0..1" />
|
|
<End Role="Ferry" Type="Self.Ferry" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="Ferry">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_FerryUser">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="0..1" />
|
|
<End Role="Ferry" Type="Self.Ferry" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Ferry">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_LoginResultUser">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="0..1" />
|
|
<End Role="LoginResult" Type="Self.LoginResult" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="LoginResult">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_MachineCompany">
|
|
<End Role="Company" Type="Self.Company" Multiplicity="0..1" />
|
|
<End Role="Machine" Type="Self.Machine" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="Machine">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_MachineKierowca">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="0..1" />
|
|
<End Role="Machine" Type="Self.Machine" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Machine">
|
|
<PropertyRef Name="KierowcaId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_NaczepaCiagnik">
|
|
<End Role="Machine" Type="Self.Machine" Multiplicity="0..1" />
|
|
<End Role="Machine1" Type="Self.Machine" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="Machine1">
|
|
<PropertyRef Name="PrzypisanyCiagnikId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_NotificationOrder">
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="0..1" />
|
|
<End Role="Notification" Type="Self.Notification" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="Notification">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_NotificationUser">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="0..1" />
|
|
<End Role="Notification" Type="Self.Notification" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Notification">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderContactConnection_Contact">
|
|
<End Role="Contact" Type="Self.Contact" Multiplicity="1" />
|
|
<End Role="OrderContactConnection" Type="Self.OrderContactConnection" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="OrderContactConnection">
|
|
<PropertyRef Name="ContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderContactConnection_Order">
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="1" />
|
|
<End Role="OrderContactConnection" Type="Self.OrderContactConnection" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="OrderContactConnection">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderHistoryAdress">
|
|
<End Role="Adress" Type="Self.Adress" Multiplicity="0..1" />
|
|
<End Role="OrderUserHistory" Type="Self.OrderUserHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserHistory">
|
|
<PropertyRef Name="AdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderHistoryOrder">
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="1" />
|
|
<End Role="OrderUserHistory" Type="Self.OrderUserHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserHistory">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderHistoryUserFrom">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="1" />
|
|
<End Role="OrderUserHistory" Type="Self.OrderUserHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserHistory">
|
|
<PropertyRef Name="UserFromId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderHistoryUserTo">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="1" />
|
|
<End Role="OrderUserHistory" Type="Self.OrderUserHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserHistory">
|
|
<PropertyRef Name="UserToId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListCiagnik">
|
|
<End Role="Machine" Type="Self.Machine" Multiplicity="0..1" />
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="CiagnikId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListClient">
|
|
<End Role="Client" Type="Self.Client" Multiplicity="0..1" />
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Client">
|
|
<PropertyRef Name="ClientId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="ClientId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListCompany">
|
|
<End Role="Company" Type="Self.Company" Multiplicity="0..1" />
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListCurrency">
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="0..1" />
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="CurrencyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListEndAdress">
|
|
<End Role="Adress" Type="Self.Adress" Multiplicity="0..1" />
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="EndAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListNaczepa">
|
|
<End Role="Machine" Type="Self.Machine" Multiplicity="0..1" />
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="NaczepaId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListStartAdress">
|
|
<End Role="Adress" Type="Self.Adress" Multiplicity="0..1" />
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="StartAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderUserConnection_Order">
|
|
<End Role="OrderList" Type="Self.OrderList" Multiplicity="1" />
|
|
<End Role="OrderUserConnection" Type="Self.OrderUserConnection" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserConnection">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderUserConnection_User">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="1" />
|
|
<End Role="OrderUserConnection" Type="Self.OrderUserConnection" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserConnection">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_PhoneContact">
|
|
<End Role="Contact" Type="Self.Contact" Multiplicity="0..1" />
|
|
<End Role="PhoneNumber" Type="Self.PhoneNumber" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="PhoneNumber">
|
|
<PropertyRef Name="ContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_PhoneWorker">
|
|
<End Role="Worker" Type="Self.Worker" Multiplicity="0..1" />
|
|
<End Role="PhoneNumber" Type="Self.PhoneNumber" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Worker">
|
|
<PropertyRef Name="WorkerId" />
|
|
</Principal>
|
|
<Dependent Role="PhoneNumber">
|
|
<PropertyRef Name="WorkerId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_PWAUser">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="0..1" />
|
|
<End Role="SubskrypcjaPWASet" Type="Self.SubskrypcjaPWASet" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="SubskrypcjaPWASet">
|
|
<PropertyRef Name="UserListId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_RepairCurrency">
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="0..1" />
|
|
<End Role="MachineRepair" Type="Self.MachineRepair" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="MachineRepair">
|
|
<PropertyRef Name="CurrencyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_RepairMachine">
|
|
<End Role="Machine" Type="Self.Machine" Multiplicity="0..1" />
|
|
<End Role="MachineRepair" Type="Self.MachineRepair" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="MachineRepair">
|
|
<PropertyRef Name="MachineId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_RepairType">
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="0..1" />
|
|
<End Role="MachineRepair" Type="Self.MachineRepair" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="MachineRepair">
|
|
<PropertyRef Name="ServiceTypeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_RepairWorkstation">
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="0..1" />
|
|
<End Role="MachineRepair" Type="Self.MachineRepair" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="MachineRepair">
|
|
<PropertyRef Name="WorkstationId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_SessionHistoryUser">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="0..1" />
|
|
<End Role="SessionHistory" Type="Self.SessionHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="SessionHistory">
|
|
<PropertyRef Name="UserListId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_SlownikCompany">
|
|
<End Role="Company" Type="Self.Company" Multiplicity="1" />
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="Slownik">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_SlownikSlownikTyp">
|
|
<End Role="SlownikTyp" Type="Self.SlownikTyp" Multiplicity="1" />
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="SlownikTyp">
|
|
<PropertyRef Name="SlownikTypId" />
|
|
</Principal>
|
|
<Dependent Role="Slownik">
|
|
<PropertyRef Name="SlownikTypId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_UserAccountType">
|
|
<End Role="AccountType" Type="Self.AccountType" Multiplicity="1" />
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="AccountType">
|
|
<PropertyRef Name="AccountTypeId" />
|
|
</Principal>
|
|
<Dependent Role="UserList">
|
|
<PropertyRef Name="AccountTypeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_UserCompany">
|
|
<End Role="Company" Type="Self.Company" Multiplicity="0..1" />
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="UserList">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkerAdress">
|
|
<End Role="Adress" Type="Self.Adress" Multiplicity="0..1" />
|
|
<End Role="Worker" Type="Self.Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="AdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkerContact">
|
|
<End Role="Contact" Type="Self.Contact" Multiplicity="0..1" />
|
|
<End Role="Worker" Type="Self.Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="ContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkerCurrency">
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="0..1" />
|
|
<End Role="Worker" Type="Self.Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="CurrencyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkerSalaryType">
|
|
<End Role="Slownik" Type="Self.Slownik" Multiplicity="0..1" />
|
|
<End Role="Worker" Type="Self.Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="SalaryTypeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkerUserList">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="0..1" />
|
|
<End Role="Worker" Type="Self.Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="UserListId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkTimeUser">
|
|
<End Role="UserList" Type="Self.UserList" Multiplicity="1" />
|
|
<End Role="WorkTime" Type="Self.WorkTime" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="WorkTime">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Function Name="fn_diagramobjects" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" ReturnType="int" />
|
|
<Function Name="sp_alterdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="diagramname" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="owner_id" Type="int" Mode="In" />
|
|
<Parameter Name="version" Type="int" Mode="In" />
|
|
<Parameter Name="definition" Type="varbinary(max)" Mode="In" />
|
|
</Function>
|
|
<Function Name="sp_creatediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="diagramname" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="owner_id" Type="int" Mode="In" />
|
|
<Parameter Name="version" Type="int" Mode="In" />
|
|
<Parameter Name="definition" Type="varbinary(max)" Mode="In" />
|
|
</Function>
|
|
<Function Name="sp_dropdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="diagramname" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="owner_id" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="sp_helpdiagramdefinition" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="diagramname" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="owner_id" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="sp_helpdiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="diagramname" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="owner_id" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="sp_renamediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="diagramname" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="owner_id" Type="int" Mode="In" />
|
|
<Parameter Name="new_diagramname" Type="nvarchar" Mode="In" />
|
|
</Function>
|
|
<Function Name="sp_upgraddiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
|
|
<EntityContainer Name="ModelStoreContainer">
|
|
<EntitySet Name="__RefactorLog" EntityType="Self.__RefactorLog" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="AccountType" EntityType="Self.AccountType" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Adress" EntityType="Self.Adress" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Client" EntityType="Self.Client" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Company" EntityType="Self.Company" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Contact" EntityType="Self.Contact" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Cost" EntityType="Self.Cost" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Email" EntityType="Self.Email" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="example" EntityType="Self.example" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Ferry" EntityType="Self.Ferry" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="IPLoginFailed" EntityType="Self.IPLoginFailed" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="LoginResult" EntityType="Self.LoginResult" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Machine" EntityType="Self.Machine" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="MachineRepair" EntityType="Self.MachineRepair" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Notification" EntityType="Self.Notification" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="OrderContactConnection" EntityType="Self.OrderContactConnection" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="OrderList" EntityType="Self.OrderList" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="OrderUserConnection" EntityType="Self.OrderUserConnection" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="OrderUserHistory" EntityType="Self.OrderUserHistory" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="PhoneNumber" EntityType="Self.PhoneNumber" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="SessionHistory" EntityType="Self.SessionHistory" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Slownik" EntityType="Self.Slownik" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="SlownikTyp" EntityType="Self.SlownikTyp" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="SmsLog" EntityType="Self.SmsLog" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="SubskrypcjaPWASet" EntityType="Self.SubskrypcjaPWASet" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Ubezpieczenia" EntityType="Self.Ubezpieczenia" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="UserList" EntityType="Self.UserList" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Worker" EntityType="Self.Worker" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="WorkTime" EntityType="Self.WorkTime" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="CiagnikiList" EntityType="Self.CiagnikiList" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[CiagnikiList].[Id] AS [Id],
|
|
[CiagnikiList].[Nazwa] AS [Nazwa],
|
|
[CiagnikiList].[CompanyId] AS [CompanyId]
|
|
FROM [dbo].[CiagnikiList] AS [CiagnikiList]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="PracownicyList" EntityType="Self.PracownicyList" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[PracownicyList].[Id] AS [Id],
|
|
[PracownicyList].[Nazwa] AS [Nazwa],
|
|
[PracownicyList].[IsDeleted] AS [IsDeleted],
|
|
[PracownicyList].[AccountType] AS [AccountType],
|
|
[PracownicyList].[CompanyId] AS [CompanyId]
|
|
FROM [dbo].[PracownicyList] AS [PracownicyList]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="ZleceniaList" EntityType="Self.ZleceniaList" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[ZleceniaList].[Id] AS [Id],
|
|
[ZleceniaList].[Nazwa] AS [Nazwa],
|
|
[ZleceniaList].[CompanyId] AS [CompanyId]
|
|
FROM [dbo].[ZleceniaList] AS [ZleceniaList]</DefiningQuery>
|
|
</EntitySet>
|
|
<AssociationSet Name="FK_ClientAdress" Association="Self.FK_ClientAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientAdresWysylkowy" Association="Self.FK_ClientAdresWysylkowy">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientCompany" Association="Self.FK_ClientCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientDefaultContact" Association="Self.FK_ClientDefaultContact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientDefaultEndAdress" Association="Self.FK_ClientDefaultEndAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientDefaultMachine" Association="Self.FK_ClientDefaultMachine">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientDefaultStartAdress" Association="Self.FK_ClientDefaultStartAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CompanyAdress" Association="Self.FK_CompanyAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Company" EntitySet="Company" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CompanyWlasciciel" Association="Self.FK_CompanyWlasciciel">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Company" EntitySet="Company" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ContactClient" Association="Self.FK_ContactClient">
|
|
<End Role="Client" EntitySet="Client" />
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostCiagnik" Association="Self.FK_CostCiagnik">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostCurrency" Association="Self.FK_CostCurrency">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostOrder" Association="Self.FK_CostOrder">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostType" Association="Self.FK_CostType">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostUser" Association="Self.FK_CostUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostWorktime" Association="Self.FK_CostWorktime">
|
|
<End Role="WorkTime" EntitySet="WorkTime" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_EmailContact" Association="Self.FK_EmailContact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="Email" EntitySet="Email" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_EmailWorker" Association="Self.FK_EmailWorker">
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
<End Role="Email" EntitySet="Email" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_FerryCiagnik" Association="Self.FK_FerryCiagnik">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="Ferry" EntitySet="Ferry" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_FerryOrder" Association="Self.FK_FerryOrder">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="Ferry" EntitySet="Ferry" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_FerryUser" Association="Self.FK_FerryUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Ferry" EntitySet="Ferry" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_LoginResultUser" Association="Self.FK_LoginResultUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="LoginResult" EntitySet="LoginResult" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_MachineCompany" Association="Self.FK_MachineCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_MachineKierowca" Association="Self.FK_MachineKierowca">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_NaczepaCiagnik" Association="Self.FK_NaczepaCiagnik">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="Machine1" EntitySet="Machine" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_NotificationOrder" Association="Self.FK_NotificationOrder">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="Notification" EntitySet="Notification" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_NotificationUser" Association="Self.FK_NotificationUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Notification" EntitySet="Notification" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderContactConnection_Contact" Association="Self.FK_OrderContactConnection_Contact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="OrderContactConnection" EntitySet="OrderContactConnection" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderContactConnection_Order" Association="Self.FK_OrderContactConnection_Order">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="OrderContactConnection" EntitySet="OrderContactConnection" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderHistoryAdress" Association="Self.FK_OrderHistoryAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="OrderUserHistory" EntitySet="OrderUserHistory" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderHistoryOrder" Association="Self.FK_OrderHistoryOrder">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="OrderUserHistory" EntitySet="OrderUserHistory" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderHistoryUserFrom" Association="Self.FK_OrderHistoryUserFrom">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="OrderUserHistory" EntitySet="OrderUserHistory" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderHistoryUserTo" Association="Self.FK_OrderHistoryUserTo">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="OrderUserHistory" EntitySet="OrderUserHistory" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListCiagnik" Association="Self.FK_OrderListCiagnik">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListClient" Association="Self.FK_OrderListClient">
|
|
<End Role="Client" EntitySet="Client" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListCompany" Association="Self.FK_OrderListCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListCurrency" Association="Self.FK_OrderListCurrency">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListEndAdress" Association="Self.FK_OrderListEndAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListNaczepa" Association="Self.FK_OrderListNaczepa">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListStartAdress" Association="Self.FK_OrderListStartAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderUserConnection_Order" Association="Self.FK_OrderUserConnection_Order">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="OrderUserConnection" EntitySet="OrderUserConnection" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderUserConnection_User" Association="Self.FK_OrderUserConnection_User">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="OrderUserConnection" EntitySet="OrderUserConnection" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_PhoneContact" Association="Self.FK_PhoneContact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="PhoneNumber" EntitySet="PhoneNumber" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_PhoneWorker" Association="Self.FK_PhoneWorker">
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
<End Role="PhoneNumber" EntitySet="PhoneNumber" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_PWAUser" Association="Self.FK_PWAUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="SubskrypcjaPWASet" EntitySet="SubskrypcjaPWASet" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_RepairCurrency" Association="Self.FK_RepairCurrency">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="MachineRepair" EntitySet="MachineRepair" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_RepairMachine" Association="Self.FK_RepairMachine">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="MachineRepair" EntitySet="MachineRepair" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_RepairType" Association="Self.FK_RepairType">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="MachineRepair" EntitySet="MachineRepair" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_RepairWorkstation" Association="Self.FK_RepairWorkstation">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="MachineRepair" EntitySet="MachineRepair" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_SessionHistoryUser" Association="Self.FK_SessionHistoryUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="SessionHistory" EntitySet="SessionHistory" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_SlownikCompany" Association="Self.FK_SlownikCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_SlownikSlownikTyp" Association="Self.FK_SlownikSlownikTyp">
|
|
<End Role="SlownikTyp" EntitySet="SlownikTyp" />
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_UserAccountType" Association="Self.FK_UserAccountType">
|
|
<End Role="AccountType" EntitySet="AccountType" />
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_UserCompany" Association="Self.FK_UserCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkerAdress" Association="Self.FK_WorkerAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkerContact" Association="Self.FK_WorkerContact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkerCurrency" Association="Self.FK_WorkerCurrency">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkerSalaryType" Association="Self.FK_WorkerSalaryType">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkerUserList" Association="Self.FK_WorkerUserList">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkTimeUser" Association="Self.FK_WorkTimeUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="WorkTime" EntitySet="WorkTime" />
|
|
</AssociationSet>
|
|
</EntityContainer>
|
|
</Schema></edmx:StorageModels>
|
|
<!-- CSDL content -->
|
|
<edmx:ConceptualModels>
|
|
<Schema Namespace="Model" 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="C__RefactorLog">
|
|
<Key>
|
|
<PropertyRef Name="OperationKey" />
|
|
</Key>
|
|
<Property Name="OperationKey" Type="Guid" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="Company">
|
|
<Key>
|
|
<PropertyRef Name="CompanyId" />
|
|
</Key>
|
|
<Property Name="CompanyId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Name" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="AdressId" Type="Int64" />
|
|
<Property Name="NIP" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<NavigationProperty Name="Adress" Relationship="Model.FK_CompanyAdress" FromRole="Company" ToRole="Adress" />
|
|
<Property Name="WlascicielId" Type="Int64" />
|
|
<NavigationProperty Name="Clients" Relationship="Model.FK_ClientCompany" FromRole="Company" ToRole="Client" />
|
|
<NavigationProperty Name="Orders" Relationship="Model.FK_OrderListCompany" FromRole="Company" ToRole="OrderList" />
|
|
<NavigationProperty Name="Slowniki" Relationship="Model.FK_SlownikCompany" FromRole="Company" ToRole="Slownik" />
|
|
<NavigationProperty Name="Machines" Relationship="Model.FK_MachineCompany" FromRole="Company" ToRole="Machine" />
|
|
<NavigationProperty Name="OwnerUser" Relationship="Model.FK_CompanyWlasciciel" FromRole="Company" ToRole="UserList" />
|
|
<NavigationProperty Name="Users" Relationship="Model.FK_UserCompany" FromRole="Company" ToRole="UserList" />
|
|
<Property Name="LastPaydate" Type="DateTime" Precision="3" />
|
|
</EntityType>
|
|
<EntityType Name="example">
|
|
<Key>
|
|
<PropertyRef Name="one" />
|
|
</Key>
|
|
<Property Name="one" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="two" Type="Int32" />
|
|
<Property Name="three" Type="String" MaxLength="32" FixedLength="false" Unicode="false" />
|
|
<Property Name="fout" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="five" Type="Binary" MaxLength="64" FixedLength="true" />
|
|
<Property Name="six" Type="String" MaxLength="512" FixedLength="false" Unicode="false" />
|
|
<Property Name="seven" Type="DateTime" Precision="3" />
|
|
<Property Name="eight" Type="Byte" Nullable="false" />
|
|
<Property Name="nine" Type="String" MaxLength="64" FixedLength="false" Unicode="false" />
|
|
<Property Name="ten" Type="Int32" />
|
|
<Property Name="eleven" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="twelve" Type="DateTime" Precision="3" />
|
|
<Property Name="thirteen" Type="Boolean" />
|
|
<Property Name="fourteen" Type="DateTime" Precision="3" />
|
|
</EntityType>
|
|
<EntityType Name="LoginResult">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="UserId" Type="Int64" />
|
|
<Property Name="Type" Type="Boolean" />
|
|
<Property Name="Date" Type="DateTime" Precision="3" />
|
|
<Property Name="Browser" Type="String" MaxLength="126" FixedLength="false" Unicode="false" />
|
|
<NavigationProperty Name="UserList" Relationship="Model.FK_LoginResultUser" FromRole="LoginResult" ToRole="UserList" />
|
|
</EntityType>
|
|
<EntityType Name="sysdiagrams">
|
|
<Key>
|
|
<PropertyRef Name="diagram_id" />
|
|
</Key>
|
|
<Property Name="name" Type="String" MaxLength="128" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="principal_id" Type="Int32" Nullable="false" />
|
|
<Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="version" Type="Int32" />
|
|
<Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
|
|
</EntityType>
|
|
<EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
|
|
<EntitySet Name="C__RefactorLog" EntityType="Self.C__RefactorLog" />
|
|
<EntitySet Name="Company" EntityType="Self.Company" />
|
|
<EntitySet Name="example" EntityType="Self.example" />
|
|
<EntitySet Name="LoginResult" EntityType="Self.LoginResult" />
|
|
<EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" />
|
|
<FunctionImport Name="sp_alterdiagram">
|
|
<Parameter Name="diagramname" Mode="In" Type="String" />
|
|
<Parameter Name="owner_id" Mode="In" Type="Int32" />
|
|
<Parameter Name="version" Mode="In" Type="Int32" />
|
|
<Parameter Name="definition" Mode="In" Type="Binary" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="sp_creatediagram">
|
|
<Parameter Name="diagramname" Mode="In" Type="String" />
|
|
<Parameter Name="owner_id" Mode="In" Type="Int32" />
|
|
<Parameter Name="version" Mode="In" Type="Int32" />
|
|
<Parameter Name="definition" Mode="In" Type="Binary" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="sp_dropdiagram">
|
|
<Parameter Name="diagramname" Mode="In" Type="String" />
|
|
<Parameter Name="owner_id" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="sp_helpdiagramdefinition" ReturnType="Collection(Model.sp_helpdiagramdefinition_Result)">
|
|
<Parameter Name="diagramname" Mode="In" Type="String" />
|
|
<Parameter Name="owner_id" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="sp_helpdiagrams" ReturnType="Collection(Model.sp_helpdiagrams_Result)">
|
|
<Parameter Name="diagramname" Mode="In" Type="String" />
|
|
<Parameter Name="owner_id" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="sp_renamediagram">
|
|
<Parameter Name="diagramname" Mode="In" Type="String" />
|
|
<Parameter Name="owner_id" Mode="In" Type="Int32" />
|
|
<Parameter Name="new_diagramname" Mode="In" Type="String" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="sp_upgraddiagrams" />
|
|
<EntitySet Name="Adress" EntityType="Model.Adress" />
|
|
<EntitySet Name="Client" EntityType="Model.Client" />
|
|
<EntitySet Name="Ferry" EntityType="Model.Ferry" />
|
|
<AssociationSet Name="FK_CompanyAdress" Association="Model.FK_CompanyAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Company" EntitySet="Company" />
|
|
</AssociationSet>
|
|
<EntitySet Name="Slownik" EntityType="Model.Slownik" />
|
|
<EntitySet Name="SlownikTyp" EntityType="Model.SlownikTyp" />
|
|
<EntitySet Name="AccountType" EntityType="Model.AccountType" />
|
|
<AssociationSet Name="FK_SlownikSlownikTyp" Association="Model.FK_SlownikSlownikTyp">
|
|
<End Role="SlownikTyp" EntitySet="SlownikTyp" />
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientCompany" Association="Model.FK_ClientCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<EntitySet Name="IPLoginFailed" EntityType="Model.IPLoginFailed" />
|
|
<EntitySet Name="Email" EntityType="Model.Email" />
|
|
<EntitySet Name="OrderContactConnection" EntityType="Model.OrderContactConnection" />
|
|
<EntitySet Name="PhoneNumber" EntityType="Model.PhoneNumber" />
|
|
<EntitySet Name="OrderList" EntityType="Model.OrderList" />
|
|
<AssociationSet Name="FK_ClientAdress" Association="Model.FK_ClientAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListEndAdress" Association="Model.FK_OrderListEndAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListStartAdress" Association="Model.FK_OrderListStartAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListClient" Association="Model.FK_OrderListClient">
|
|
<End Role="Client" EntitySet="Client" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_FerryOrder" Association="Model.FK_FerryOrder">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="Ferry" EntitySet="Ferry" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderContactConnection_Order" Association="Model.FK_OrderContactConnection_Order">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="OrderContactConnection" EntitySet="OrderContactConnection" />
|
|
</AssociationSet>
|
|
<EntitySet Name="Contact" EntityType="Model.Contact" />
|
|
<EntitySet Name="Worker" EntityType="Model.Worker" />
|
|
<AssociationSet Name="FK_WorkerAdress" Association="Model.FK_WorkerAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ContactClient" Association="Model.FK_ContactClient">
|
|
<End Role="Client" EntitySet="Client" />
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_EmailContact" Association="Model.FK_EmailContact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="Email" EntitySet="Email" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderContactConnection_Contact" Association="Model.FK_OrderContactConnection_Contact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="OrderContactConnection" EntitySet="OrderContactConnection" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_PhoneContact" Association="Model.FK_PhoneContact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="PhoneNumber" EntitySet="PhoneNumber" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkerContact" Association="Model.FK_WorkerContact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_EmailWorker" Association="Model.FK_EmailWorker">
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
<End Role="Email" EntitySet="Email" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_PhoneWorker" Association="Model.FK_PhoneWorker">
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
<End Role="PhoneNumber" EntitySet="PhoneNumber" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListCompany" Association="Model.FK_OrderListCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<EntitySet Name="OrderUserConnection" EntityType="Model.OrderUserConnection" />
|
|
<AssociationSet Name="FK_OrderUserConnection_Order" Association="Model.FK_OrderUserConnection_Order">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="OrderUserConnection" EntitySet="OrderUserConnection" />
|
|
</AssociationSet>
|
|
<EntitySet Name="WorkTime" EntityType="Model.WorkTime" />
|
|
<AssociationSet Name="FK_SlownikCompany" Association="Model.FK_SlownikCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
</AssociationSet>
|
|
<EntitySet Name="MachineRepair" EntityType="Model.MachineRepair" />
|
|
<AssociationSet Name="FK_RepairType" Association="Model.FK_RepairType">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="MachineRepair" EntitySet="MachineRepair" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_RepairWorkstation" Association="Model.FK_RepairWorkstation">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="MachineRepair" EntitySet="MachineRepair" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientDefaultEndAdress" Association="Model.FK_ClientDefaultEndAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientDefaultStartAdress" Association="Model.FK_ClientDefaultStartAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientDefaultContact" Association="Model.FK_ClientDefaultContact">
|
|
<End Role="Contact" EntitySet="Contact" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<EntitySet Name="Cost" EntityType="Model.Cost" />
|
|
<AssociationSet Name="FK_CostOrder" Association="Model.FK_CostOrder">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostType" Association="Model.FK_CostType">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ClientAdresWysylkowy" Association="Model.FK_ClientAdresWysylkowy">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<EntitySet Name="Machine" EntityType="Model.Machine" />
|
|
<AssociationSet Name="FK_ClientDefaultMachine" Association="Model.FK_ClientDefaultMachine">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="Client" EntitySet="Client" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_MachineCompany" Association="Model.FK_MachineCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostCiagnik" Association="Model.FK_CostCiagnik">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_FerryCiagnik" Association="Model.FK_FerryCiagnik">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="Ferry" EntitySet="Ferry" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_NaczepaCiagnik" Association="Model.FK_NaczepaCiagnik">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="Machine1" EntitySet="Machine" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListCiagnik" Association="Model.FK_OrderListCiagnik">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListNaczepa" Association="Model.FK_OrderListNaczepa">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_RepairMachine" Association="Model.FK_RepairMachine">
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
<End Role="MachineRepair" EntitySet="MachineRepair" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkerSalaryType" Association="Model.FK_WorkerSalaryType">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<EntitySet Name="UserList" EntityType="Model.UserList" />
|
|
<AssociationSet Name="FK_UserAccountType" Association="Model.FK_UserAccountType">
|
|
<End Role="AccountType" EntitySet="AccountType" />
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CompanyWlasciciel" Association="Model.FK_CompanyWlasciciel">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Company" EntitySet="Company" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_UserCompany" Association="Model.FK_UserCompany">
|
|
<End Role="Company" EntitySet="Company" />
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostUser" Association="Model.FK_CostUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_FerryUser" Association="Model.FK_FerryUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Ferry" EntitySet="Ferry" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_LoginResultUser" Association="Model.FK_LoginResultUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="LoginResult" EntitySet="LoginResult" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_MachineKierowca" Association="Model.FK_MachineKierowca">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Machine" EntitySet="Machine" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderUserConnection_User" Association="Model.FK_OrderUserConnection_User">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="OrderUserConnection" EntitySet="OrderUserConnection" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkerUserList" Association="Model.FK_WorkerUserList">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkTimeUser" Association="Model.FK_WorkTimeUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="WorkTime" EntitySet="WorkTime" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostWorktime" Association="Model.FK_CostWorktime">
|
|
<End Role="WorkTime" EntitySet="WorkTime" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_CostCurrency" Association="Model.FK_CostCurrency">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="Cost" EntitySet="Cost" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_RepairCurrency" Association="Model.FK_RepairCurrency">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="MachineRepair" EntitySet="MachineRepair" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderListCurrency" Association="Model.FK_OrderListCurrency">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_WorkerCurrency" Association="Model.FK_WorkerCurrency">
|
|
<End Role="Slownik" EntitySet="Slownik" />
|
|
<End Role="Worker" EntitySet="Worker" />
|
|
</AssociationSet>
|
|
<EntitySet Name="SessionHistory" EntityType="Model.SessionHistory" />
|
|
<AssociationSet Name="FK_SessionHistoryUser" Association="Model.FK_SessionHistoryUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="SessionHistory" EntitySet="SessionHistory" />
|
|
</AssociationSet>
|
|
<EntitySet Name="OrderUserHistory" EntityType="Model.OrderUserHistory" />
|
|
<AssociationSet Name="FK_OrderHistoryOrder" Association="Model.FK_OrderHistoryOrder">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="OrderUserHistory" EntitySet="OrderUserHistory" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderHistoryUserFrom" Association="Model.FK_OrderHistoryUserFrom">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="OrderUserHistory" EntitySet="OrderUserHistory" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderHistoryUserTo" Association="Model.FK_OrderHistoryUserTo">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="OrderUserHistory" EntitySet="OrderUserHistory" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_OrderHistoryAdress" Association="Model.FK_OrderHistoryAdress">
|
|
<End Role="Adress" EntitySet="Adress" />
|
|
<End Role="OrderUserHistory" EntitySet="OrderUserHistory" />
|
|
</AssociationSet>
|
|
<EntitySet Name="CiagnikiList" EntityType="Model.CiagnikiList" />
|
|
<EntitySet Name="PracownicyList" EntityType="Model.PracownicyList" />
|
|
<EntitySet Name="ZleceniaList" EntityType="Model.ZleceniaList" />
|
|
<EntitySet Name="SmsLog" EntityType="Model.SmsLog" />
|
|
<EntitySet Name="SubskrypcjaPWASet" EntityType="Model.SubskrypcjaPWASet" />
|
|
<AssociationSet Name="FK_PWAUser" Association="Model.FK_PWAUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="SubskrypcjaPWASet" EntitySet="SubskrypcjaPWASet" />
|
|
</AssociationSet>
|
|
<EntitySet Name="Ubezpieczenia" EntityType="Model.Ubezpieczenia" />
|
|
<EntitySet Name="Notification" EntityType="Model.Notification" />
|
|
<AssociationSet Name="FK_NotificationOrder" Association="Model.FK_NotificationOrder">
|
|
<End Role="OrderList" EntitySet="OrderList" />
|
|
<End Role="Notification" EntitySet="Notification" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_NotificationUser" Association="Model.FK_NotificationUser">
|
|
<End Role="UserList" EntitySet="UserList" />
|
|
<End Role="Notification" EntitySet="Notification" />
|
|
</AssociationSet>
|
|
</EntityContainer>
|
|
<ComplexType Name="sp_helpdiagramdefinition_Result">
|
|
<Property Type="Int32" Name="version" Nullable="true" />
|
|
<Property Type="Binary" Name="definition" Nullable="true" />
|
|
</ComplexType>
|
|
<ComplexType Name="sp_helpdiagrams_Result">
|
|
<Property Type="String" Name="Database" Nullable="true" MaxLength="128" />
|
|
<Property Type="String" Name="Name" Nullable="false" MaxLength="128" />
|
|
<Property Type="Int32" Name="ID" Nullable="false" />
|
|
<Property Type="String" Name="Owner" Nullable="true" MaxLength="128" />
|
|
<Property Type="Int32" Name="OwnerID" Nullable="false" />
|
|
</ComplexType>
|
|
<EntityType Name="Adress">
|
|
<Key>
|
|
<PropertyRef Name="AdressId" />
|
|
</Key>
|
|
<Property Name="AdressId" Type="Int64" Nullable="false" />
|
|
<Property Name="Postcode" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
|
<Property Name="Country" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="Voivodship" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="City" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="Street" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<NavigationProperty Name="Companies" Relationship="Model.FK_CompanyAdress" FromRole="Adress" ToRole="Company" />
|
|
<Property Name="Number" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<NavigationProperty Name="Client" Relationship="Model.FK_ClientAdress" FromRole="Adress" ToRole="Client" />
|
|
<NavigationProperty Name="OrderList" Relationship="Model.FK_OrderListEndAdress" FromRole="Adress" ToRole="OrderList" />
|
|
<NavigationProperty Name="OrderList1" Relationship="Model.FK_OrderListStartAdress" FromRole="Adress" ToRole="OrderList" />
|
|
<NavigationProperty Name="Worker" Relationship="Model.FK_WorkerAdress" FromRole="Adress" ToRole="Worker" />
|
|
<NavigationProperty Name="ClientFromEndDefault" Relationship="Model.FK_ClientDefaultEndAdress" FromRole="Adress" ToRole="Client" />
|
|
<NavigationProperty Name="ClientFromStartDefault" Relationship="Model.FK_ClientDefaultStartAdress" FromRole="Adress" ToRole="Client" />
|
|
<NavigationProperty Name="PostClients" Relationship="Model.FK_ClientAdresWysylkowy" FromRole="Adress" ToRole="Client" />
|
|
<NavigationProperty Name="OrderUserHistory" Relationship="Model.FK_OrderHistoryAdress" FromRole="Adress" ToRole="OrderUserHistory" />
|
|
</EntityType>
|
|
<EntityType Name="Client">
|
|
<Key>
|
|
<PropertyRef Name="ClientId" />
|
|
</Key>
|
|
<Property Name="ClientId" Type="Int64" Nullable="false" />
|
|
<Property Name="Name" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="AdressId" Type="Int64" />
|
|
<Property Name="CompanyId" Type="Int64" />
|
|
<NavigationProperty Name="Company" Relationship="Model.FK_ClientCompany" FromRole="Client" ToRole="Company" />
|
|
<Property Name="IsRemoved" Type="Boolean" Nullable="false" />
|
|
<NavigationProperty Name="Adress" Relationship="Model.FK_ClientAdress" FromRole="Client" ToRole="Adress" />
|
|
<NavigationProperty Name="Orders" Relationship="Model.FK_OrderListClient" FromRole="Client" ToRole="OrderList" />
|
|
<NavigationProperty Name="Contacts" Relationship="Model.FK_ContactClient" FromRole="Client" ToRole="Contact" />
|
|
<Property Name="DeletionDate" Type="DateTime" Precision="3" />
|
|
<Property Name="DefaultContactId" Type="Int64" />
|
|
<Property Name="DefaultStartAdressId" Type="Int64" />
|
|
<Property Name="DefaultEndAdressId" Type="Int64" />
|
|
<Property Name="DefaultMachineId" Type="Int64" />
|
|
<NavigationProperty Name="DefaultEndAdress" Relationship="Model.FK_ClientDefaultEndAdress" FromRole="Client" ToRole="Adress" />
|
|
<NavigationProperty Name="DefaultStartAdress" Relationship="Model.FK_ClientDefaultStartAdress" FromRole="Client" ToRole="Adress" />
|
|
<NavigationProperty Name="DefaultContact" Relationship="Model.FK_ClientDefaultContact" FromRole="Client" ToRole="Contact" />
|
|
<Property Name="NIP" Type="String" MaxLength="254" FixedLength="false" Unicode="false" />
|
|
<Property Name="PostAdressId" Type="Int64" />
|
|
<NavigationProperty Name="PostAdress" Relationship="Model.FK_ClientAdresWysylkowy" FromRole="Client" ToRole="Adress" />
|
|
<NavigationProperty Name="DefaultMachine" Relationship="Model.FK_ClientDefaultMachine" FromRole="Client" ToRole="Machine" />
|
|
</EntityType>
|
|
<EntityType Name="Ferry">
|
|
<Key>
|
|
<PropertyRef Name="FerryId" />
|
|
</Key>
|
|
<Property Name="FerryId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="From" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="To" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="StartDate" Type="DateTime" Precision="3" />
|
|
<Property Name="EndDate" Type="DateTime" Precision="3" />
|
|
<Property Name="Cost" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="IsReal" Type="Boolean" />
|
|
<Property Name="OrderId" Type="Int64" />
|
|
<Property Name="UserId" Type="Int64" />
|
|
<Property Name="MachineId" Type="Int64" />
|
|
<NavigationProperty Name="OrderList" Relationship="Model.FK_FerryOrder" FromRole="Ferry" ToRole="OrderList" />
|
|
<Property Name="PayDate" Type="DateTime" Precision="3" />
|
|
<Property Name="DeletionDate" Type="DateTime" Precision="3" />
|
|
<NavigationProperty Name="Machine" Relationship="Model.FK_FerryCiagnik" FromRole="Ferry" ToRole="Machine" />
|
|
<NavigationProperty Name="UserList" Relationship="Model.FK_FerryUser" FromRole="Ferry" ToRole="UserList" />
|
|
</EntityType>
|
|
<Association Name="FK_CompanyAdress">
|
|
<End Type="Model.Adress" Role="Adress" Multiplicity="0..1" />
|
|
<End Type="Model.Company" Role="Company" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Company">
|
|
<PropertyRef Name="AdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="Slownik">
|
|
<Key>
|
|
<PropertyRef Name="SlownikId" />
|
|
</Key>
|
|
<Property Name="SlownikId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Name" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="SlownikTypId" Type="Int64" Nullable="false" />
|
|
<NavigationProperty Name="SlownikTyp" Relationship="Model.FK_SlownikSlownikTyp" FromRole="Slownik" ToRole="SlownikTyp" />
|
|
<Property Name="CompanyId" Type="Int64" Nullable="false" />
|
|
<NavigationProperty Name="Company" Relationship="Model.FK_SlownikCompany" FromRole="Slownik" ToRole="Company" />
|
|
<NavigationProperty Name="MachineRepairTypesUsage" Relationship="Model.FK_RepairType" FromRole="Slownik" ToRole="MachineRepair" />
|
|
<NavigationProperty Name="MachineRepairWorkstationUsage" Relationship="Model.FK_RepairWorkstation" FromRole="Slownik" ToRole="MachineRepair" />
|
|
<NavigationProperty Name="Costs" Relationship="Model.FK_CostType" FromRole="Slownik" ToRole="Cost" />
|
|
<NavigationProperty Name="SalaryTypeWorkers" Relationship="Model.FK_WorkerSalaryType" FromRole="Slownik" ToRole="Worker" />
|
|
<NavigationProperty Name="CurrenciesCosts" Relationship="Model.FK_CostCurrency" FromRole="Slownik" ToRole="Cost" />
|
|
<NavigationProperty Name="CurrenciesRepairs" Relationship="Model.FK_RepairCurrency" FromRole="Slownik" ToRole="MachineRepair" />
|
|
<NavigationProperty Name="CurrenciesOrders" Relationship="Model.FK_OrderListCurrency" FromRole="Slownik" ToRole="OrderList" />
|
|
<NavigationProperty Name="CurrencyWorkers" Relationship="Model.FK_WorkerCurrency" FromRole="Slownik" ToRole="Worker" />
|
|
</EntityType>
|
|
<EntityType Name="SlownikTyp">
|
|
<Key>
|
|
<PropertyRef Name="SlownikTypId" />
|
|
</Key>
|
|
<Property Name="SlownikTypId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Name" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<NavigationProperty Name="Slowniki" Relationship="Model.FK_SlownikSlownikTyp" FromRole="SlownikTyp" ToRole="Slownik" />
|
|
</EntityType>
|
|
<EntityType Name="AccountType">
|
|
<Key>
|
|
<PropertyRef Name="AccountTypeId" />
|
|
</Key>
|
|
<Property Name="AccountTypeId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Name" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<NavigationProperty Name="UserLists" Relationship="Model.FK_UserAccountType" FromRole="AccountType" ToRole="UserList" />
|
|
</EntityType>
|
|
<Association Name="FK_SlownikSlownikTyp">
|
|
<End Type="Model.SlownikTyp" Role="SlownikTyp" Multiplicity="1" />
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="SlownikTyp">
|
|
<PropertyRef Name="SlownikTypId" />
|
|
</Principal>
|
|
<Dependent Role="Slownik">
|
|
<PropertyRef Name="SlownikTypId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientCompany">
|
|
<End Type="Model.Company" Role="Company" Multiplicity="0..1" />
|
|
<End Type="Model.Client" Role="Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="IPLoginFailed">
|
|
<Key>
|
|
<PropertyRef Name="IP" />
|
|
</Key>
|
|
<Property Name="Count" Type="Int32" />
|
|
<Property Name="Date" Type="DateTime" Precision="3" />
|
|
<Property Name="IP" Type="String" Nullable="false" MaxLength="45" FixedLength="false" Unicode="false" />
|
|
</EntityType>
|
|
<EntityType Name="Email">
|
|
<Key>
|
|
<PropertyRef Name="EmailId" />
|
|
</Key>
|
|
<Property Name="EmailId" Type="Int64" Nullable="false" />
|
|
<Property Name="Adress" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="ContactId" Type="Int64" />
|
|
<Property Name="WorkerId" Type="Int64" />
|
|
<NavigationProperty Name="Contact" Relationship="Model.FK_EmailContact" FromRole="Email" ToRole="Contact" />
|
|
<NavigationProperty Name="Worker" Relationship="Model.FK_EmailWorker" FromRole="Email" ToRole="Worker" />
|
|
</EntityType>
|
|
<EntityType Name="OrderContactConnection">
|
|
<Key>
|
|
<PropertyRef Name="OrderId" />
|
|
<PropertyRef Name="ContactId" />
|
|
</Key>
|
|
<Property Name="OrderId" Type="Int64" Nullable="false" />
|
|
<Property Name="ContactId" Type="Int64" Nullable="false" />
|
|
<Property Name="IsStartContact" Type="Boolean" Nullable="false" />
|
|
<Property Name="IsEndContact" Type="Boolean" Nullable="false" />
|
|
<NavigationProperty Name="OrderList" Relationship="Model.FK_OrderContactConnection_Order" FromRole="OrderContactConnection" ToRole="OrderList" />
|
|
<NavigationProperty Name="Contact" Relationship="Model.FK_OrderContactConnection_Contact" FromRole="OrderContactConnection" ToRole="Contact" />
|
|
</EntityType>
|
|
<EntityType Name="PhoneNumber">
|
|
<Key>
|
|
<PropertyRef Name="PhoneId" />
|
|
</Key>
|
|
<Property Name="PhoneId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Number" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="ContactId" Type="Int64" />
|
|
<Property Name="WorkerId" Type="Int64" />
|
|
<NavigationProperty Name="Contact" Relationship="Model.FK_PhoneContact" FromRole="PhoneNumber" ToRole="Contact" />
|
|
<NavigationProperty Name="Worker" Relationship="Model.FK_PhoneWorker" FromRole="PhoneNumber" ToRole="Worker" />
|
|
</EntityType>
|
|
<EntityType Name="OrderList">
|
|
<Key>
|
|
<PropertyRef Name="OrderListId" />
|
|
</Key>
|
|
<Property Name="OrderListId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="DataUtworzenia" Type="DateTime" Nullable="false" Precision="3" />
|
|
<Property Name="ClientId" Type="Int64" />
|
|
<Property Name="StartAdressId" Type="Int64" />
|
|
<Property Name="StartDate" Type="DateTime" Precision="3" />
|
|
<Property Name="EndAdressId" Type="Int64" />
|
|
<Property Name="EndDate" Type="DateTime" Precision="3" />
|
|
<Property Name="KwotaZlecenia" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="CiagnikId" Type="Int64" />
|
|
<Property Name="NaczepaId" Type="Int64" />
|
|
<NavigationProperty Name="EndAdress" Relationship="Model.FK_OrderListEndAdress" FromRole="OrderList" ToRole="Adress" />
|
|
<NavigationProperty Name="StartAdress" Relationship="Model.FK_OrderListStartAdress" FromRole="OrderList" ToRole="Adress" />
|
|
<NavigationProperty Name="Client" Relationship="Model.FK_OrderListClient" FromRole="OrderList" ToRole="Client" />
|
|
<NavigationProperty Name="Ferries" Relationship="Model.FK_FerryOrder" FromRole="OrderList" ToRole="Ferry" />
|
|
<NavigationProperty Name="OrderContactConnection" Relationship="Model.FK_OrderContactConnection_Order" FromRole="OrderList" ToRole="OrderContactConnection" />
|
|
<Property Name="CompanyId" Type="Int64" />
|
|
<NavigationProperty Name="Company" Relationship="Model.FK_OrderListCompany" FromRole="OrderList" ToRole="Company" />
|
|
<NavigationProperty Name="KierowcyConnections" Relationship="Model.FK_OrderUserConnection_Order" FromRole="OrderList" ToRole="OrderUserConnection" />
|
|
<Property Name="IsDeleted" Type="Boolean" />
|
|
<Property Name="DeletionDate" Type="DateTime" Precision="3" />
|
|
<NavigationProperty Name="Costs" Relationship="Model.FK_CostOrder" FromRole="OrderList" ToRole="Cost" />
|
|
<Property Name="OrderNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="AwizoNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<NavigationProperty Name="Ciagnik" Relationship="Model.FK_OrderListCiagnik" FromRole="OrderList" ToRole="Machine" />
|
|
<NavigationProperty Name="Naczepa" Relationship="Model.FK_OrderListNaczepa" FromRole="OrderList" ToRole="Machine" />
|
|
<Property Name="CurrencyId" Type="Int64" />
|
|
<NavigationProperty Name="Currency" Relationship="Model.FK_OrderListCurrency" FromRole="OrderList" ToRole="Slownik" />
|
|
<NavigationProperty Name="OrderUserHistories" Relationship="Model.FK_OrderHistoryOrder" FromRole="OrderList" ToRole="OrderUserHistory" />
|
|
<NavigationProperty Name="Notifications" Relationship="Model.FK_NotificationOrder" FromRole="OrderList" ToRole="Notification" />
|
|
</EntityType>
|
|
<Association Name="FK_ClientAdress">
|
|
<End Type="Model.Adress" Role="Adress" Multiplicity="0..1" />
|
|
<End Type="Model.Client" Role="Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="AdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListEndAdress">
|
|
<End Type="Model.Adress" Role="Adress" Multiplicity="0..1" />
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="EndAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListStartAdress">
|
|
<End Type="Model.Adress" Role="Adress" Multiplicity="0..1" />
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="StartAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListClient">
|
|
<End Type="Model.Client" Role="Client" Multiplicity="0..1" />
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Client">
|
|
<PropertyRef Name="ClientId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="ClientId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_FerryOrder">
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="0..1" />
|
|
<End Type="Model.Ferry" Role="Ferry" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="Ferry">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderContactConnection_Order">
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="1" />
|
|
<End Type="Model.OrderContactConnection" Role="OrderContactConnection" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="OrderContactConnection">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="Contact">
|
|
<Key>
|
|
<PropertyRef Name="ContactId" />
|
|
</Key>
|
|
<Property Name="ContactId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Name" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="Surname" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="IsOwner" Type="Boolean" />
|
|
<Property Name="ClientId" Type="Int64" />
|
|
<NavigationProperty Name="Client" Relationship="Model.FK_ContactClient" FromRole="Contact" ToRole="Client" />
|
|
<NavigationProperty Name="Emails" Relationship="Model.FK_EmailContact" FromRole="Contact" ToRole="Email" />
|
|
<NavigationProperty Name="OrderContactConnections" Relationship="Model.FK_OrderContactConnection_Contact" FromRole="Contact" ToRole="OrderContactConnection" />
|
|
<NavigationProperty Name="PhoneNumbers" Relationship="Model.FK_PhoneContact" FromRole="Contact" ToRole="PhoneNumber" />
|
|
<NavigationProperty Name="Workers" Relationship="Model.FK_WorkerContact" FromRole="Contact" ToRole="Worker" />
|
|
<NavigationProperty Name="ClientFromDefault" Relationship="Model.FK_ClientDefaultContact" FromRole="Contact" ToRole="Client" />
|
|
</EntityType>
|
|
<EntityType Name="Worker">
|
|
<Key>
|
|
<PropertyRef Name="WorkerId" />
|
|
</Key>
|
|
<Property Name="WorkerId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="UserListId" Type="Int64" />
|
|
<Property Name="Imie" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="Nazwisko" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="PESEL" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="Birthdate" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="AdressId" Type="Int64" />
|
|
<Property Name="Pensja" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="ContactId" Type="Int64" />
|
|
<Property Name="DrugieImie" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="NrKonta" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<NavigationProperty Name="Adress" Relationship="Model.FK_WorkerAdress" FromRole="Worker" ToRole="Adress" />
|
|
<NavigationProperty Name="Contact" Relationship="Model.FK_WorkerContact" FromRole="Worker" ToRole="Contact" />
|
|
<NavigationProperty Name="Emails" Relationship="Model.FK_EmailWorker" FromRole="Worker" ToRole="Email" />
|
|
<NavigationProperty Name="PhoneNumbers" Relationship="Model.FK_PhoneWorker" FromRole="Worker" ToRole="PhoneNumber" />
|
|
<Property Name="SalaryTypeId" Type="Int64" />
|
|
<NavigationProperty Name="SalaryType" Relationship="Model.FK_WorkerSalaryType" FromRole="Worker" ToRole="Slownik" />
|
|
<NavigationProperty Name="UserList" Relationship="Model.FK_WorkerUserList" FromRole="Worker" ToRole="UserList" />
|
|
<Property Name="CurrencyId" Type="Int64" />
|
|
<NavigationProperty Name="Currency" Relationship="Model.FK_WorkerCurrency" FromRole="Worker" ToRole="Slownik" />
|
|
<Property Name="UbezpieczenieWypadkowe" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="CzyPracujeNaMiejscu" Type="Boolean" />
|
|
</EntityType>
|
|
<Association Name="FK_WorkerAdress">
|
|
<End Type="Model.Adress" Role="Adress" Multiplicity="0..1" />
|
|
<End Type="Model.Worker" Role="Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="AdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ContactClient">
|
|
<End Type="Model.Client" Role="Client" Multiplicity="0..1" />
|
|
<End Type="Model.Contact" Role="Contact" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Client">
|
|
<PropertyRef Name="ClientId" />
|
|
</Principal>
|
|
<Dependent Role="Contact">
|
|
<PropertyRef Name="ClientId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_EmailContact">
|
|
<End Type="Model.Contact" Role="Contact" Multiplicity="0..1" />
|
|
<End Type="Model.Email" Role="Email" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="Email">
|
|
<PropertyRef Name="ContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderContactConnection_Contact">
|
|
<End Type="Model.Contact" Role="Contact" Multiplicity="1" />
|
|
<End Type="Model.OrderContactConnection" Role="OrderContactConnection" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="OrderContactConnection">
|
|
<PropertyRef Name="ContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_PhoneContact">
|
|
<End Type="Model.Contact" Role="Contact" Multiplicity="0..1" />
|
|
<End Type="Model.PhoneNumber" Role="PhoneNumber" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="PhoneNumber">
|
|
<PropertyRef Name="ContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkerContact">
|
|
<End Type="Model.Contact" Role="Contact" Multiplicity="0..1" />
|
|
<End Type="Model.Worker" Role="Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="ContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_EmailWorker">
|
|
<End Type="Model.Worker" Role="Worker" Multiplicity="0..1" />
|
|
<End Type="Model.Email" Role="Email" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Worker">
|
|
<PropertyRef Name="WorkerId" />
|
|
</Principal>
|
|
<Dependent Role="Email">
|
|
<PropertyRef Name="WorkerId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_PhoneWorker">
|
|
<End Type="Model.Worker" Role="Worker" Multiplicity="0..1" />
|
|
<End Type="Model.PhoneNumber" Role="PhoneNumber" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Worker">
|
|
<PropertyRef Name="WorkerId" />
|
|
</Principal>
|
|
<Dependent Role="PhoneNumber">
|
|
<PropertyRef Name="WorkerId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListCompany">
|
|
<End Type="Model.Company" Role="Company" Multiplicity="0..1" />
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="OrderUserConnection">
|
|
<Key>
|
|
<PropertyRef Name="OrderId" />
|
|
<PropertyRef Name="UserId" />
|
|
</Key>
|
|
<Property Name="OrderId" Type="Int64" Nullable="false" />
|
|
<Property Name="UserId" Type="Int64" Nullable="false" />
|
|
<Property Name="IsCurrentDriver" Type="Boolean" />
|
|
<NavigationProperty Name="OrderList" Relationship="Model.FK_OrderUserConnection_Order" FromRole="OrderUserConnection" ToRole="OrderList" />
|
|
<NavigationProperty Name="UserList" Relationship="Model.FK_OrderUserConnection_User" FromRole="OrderUserConnection" ToRole="UserList" />
|
|
</EntityType>
|
|
<Association Name="FK_OrderUserConnection_Order">
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="1" />
|
|
<End Type="Model.OrderUserConnection" Role="OrderUserConnection" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserConnection">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="WorkTime">
|
|
<Key>
|
|
<PropertyRef Name="WorkTimeId" />
|
|
</Key>
|
|
<Property Name="WorkTimeId" Type="Int64" Nullable="false" />
|
|
<Property Name="UserId" Type="Int64" Nullable="false" />
|
|
<Property Name="Start" Type="DateTime" Nullable="false" Precision="3" />
|
|
<Property Name="End" Type="DateTime" Precision="3" />
|
|
<NavigationProperty Name="UserList" Relationship="Model.FK_WorkTimeUser" FromRole="WorkTime" ToRole="UserList" />
|
|
<NavigationProperty Name="Costs" Relationship="Model.FK_CostWorktime" FromRole="WorkTime" ToRole="Cost" />
|
|
</EntityType>
|
|
<Association Name="FK_SlownikCompany">
|
|
<End Type="Model.Company" Role="Company" Multiplicity="1" />
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="Slownik">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="MachineRepair">
|
|
<Key>
|
|
<PropertyRef Name="MachineRepairId" />
|
|
</Key>
|
|
<Property Name="MachineRepairId" Type="Int64" Nullable="false" />
|
|
<Property Name="MachineId" Type="Int64" />
|
|
<Property Name="ServiceStartDate" Type="DateTime" Precision="3" />
|
|
<Property Name="ServiceEndDate" Type="DateTime" Precision="3" />
|
|
<Property Name="ServiceTypeId" Type="Int64" />
|
|
<Property Name="Cost" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="Description" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="WorkstationId" Type="Int64" />
|
|
<NavigationProperty Name="ServiceType" Relationship="Model.FK_RepairType" FromRole="MachineRepair" ToRole="Slownik" />
|
|
<NavigationProperty Name="ServiceWorkstation" Relationship="Model.FK_RepairWorkstation" FromRole="MachineRepair" ToRole="Slownik" />
|
|
<NavigationProperty Name="Machine" Relationship="Model.FK_RepairMachine" FromRole="MachineRepair" ToRole="Machine" />
|
|
<Property Name="CurrencyId" Type="Int64" />
|
|
<NavigationProperty Name="Currency" Relationship="Model.FK_RepairCurrency" FromRole="MachineRepair" ToRole="Slownik" />
|
|
</EntityType>
|
|
<Association Name="FK_RepairType">
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="0..1" />
|
|
<End Type="Model.MachineRepair" Role="MachineRepair" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="MachineRepair">
|
|
<PropertyRef Name="ServiceTypeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_RepairWorkstation">
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="0..1" />
|
|
<End Type="Model.MachineRepair" Role="MachineRepair" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="MachineRepair">
|
|
<PropertyRef Name="WorkstationId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientDefaultEndAdress">
|
|
<End Type="Model.Adress" Role="Adress" Multiplicity="0..1" />
|
|
<End Type="Model.Client" Role="Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="DefaultEndAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientDefaultStartAdress">
|
|
<End Type="Model.Adress" Role="Adress" Multiplicity="0..1" />
|
|
<End Type="Model.Client" Role="Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="DefaultStartAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientDefaultContact">
|
|
<End Type="Model.Contact" Role="Contact" Multiplicity="0..1" />
|
|
<End Type="Model.Client" Role="Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Contact">
|
|
<PropertyRef Name="ContactId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="DefaultContactId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="Cost">
|
|
<Key>
|
|
<PropertyRef Name="CostId" />
|
|
</Key>
|
|
<Property Name="CostId" Type="Int64" Nullable="false" />
|
|
<Property Name="Describtion" Type="String" MaxLength="124" FixedLength="false" Unicode="false" />
|
|
<Property Name="ActualCost" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="OrderId" Type="Int64" />
|
|
<Property Name="UserId" Type="Int64" />
|
|
<Property Name="MachineId" Type="Int64" />
|
|
<Property Name="PayDate" Type="DateTime" Precision="3" />
|
|
<Property Name="DeletionDate" Type="DateTime" Precision="3" />
|
|
<Property Name="CostTypeId" Type="Int64" />
|
|
<NavigationProperty Name="OrderList" Relationship="Model.FK_CostOrder" FromRole="Cost" ToRole="OrderList" />
|
|
<NavigationProperty Name="CostType" Relationship="Model.FK_CostType" FromRole="Cost" ToRole="Slownik" />
|
|
<NavigationProperty Name="Machine" Relationship="Model.FK_CostCiagnik" FromRole="Cost" ToRole="Machine" />
|
|
<NavigationProperty Name="UserList" Relationship="Model.FK_CostUser" FromRole="Cost" ToRole="UserList" />
|
|
<Property Name="WorktimeId" Type="Int64" />
|
|
<NavigationProperty Name="Worktime" Relationship="Model.FK_CostWorktime" FromRole="Cost" ToRole="WorkTime" />
|
|
<Property Name="CurrencyId" Type="Int64" />
|
|
<NavigationProperty Name="Currency" Relationship="Model.FK_CostCurrency" FromRole="Cost" ToRole="Slownik" />
|
|
</EntityType>
|
|
<Association Name="FK_CostOrder">
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="0..1" />
|
|
<End Type="Model.Cost" Role="Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostType">
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="0..1" />
|
|
<End Type="Model.Cost" Role="Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="CostTypeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ClientAdresWysylkowy">
|
|
<End Type="Model.Adress" Role="Adress" Multiplicity="0..1" />
|
|
<End Type="Model.Client" Role="Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="PostAdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="Machine">
|
|
<Key>
|
|
<PropertyRef Name="MachineId" />
|
|
</Key>
|
|
<Property Name="MachineId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="RegistrationNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="Przebieg" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="Brand" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="Owner" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="FuelStatus" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="TachografLegalizationDate" Type="DateTime" Precision="3" />
|
|
<Property Name="LastPrzegladDate" Type="DateTime" Precision="3" />
|
|
<Property Name="ModelName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="CompanyId" Type="Int64" />
|
|
<Property Name="IsCiagnik" Type="Boolean" />
|
|
<Property Name="IsNaczepa" Type="Boolean" />
|
|
<Property Name="KierowcaId" Type="Int64" />
|
|
<Property Name="PrzypisanyCiagnikId" Type="Int64" />
|
|
<Property Name="IsDeleted" Type="Boolean" />
|
|
<Property Name="MaximalFuel" Type="Int64" />
|
|
<Property Name="VIN" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="AxisSerialNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="RegistrationDate" Type="DateTime" Precision="3" />
|
|
<NavigationProperty Name="Clients" Relationship="Model.FK_ClientDefaultMachine" FromRole="Machine" ToRole="Client" />
|
|
<NavigationProperty Name="Company" Relationship="Model.FK_MachineCompany" FromRole="Machine" ToRole="Company" />
|
|
<NavigationProperty Name="Costs" Relationship="Model.FK_CostCiagnik" FromRole="Machine" ToRole="Cost" />
|
|
<NavigationProperty Name="Ferrys" Relationship="Model.FK_FerryCiagnik" FromRole="Machine" ToRole="Ferry" />
|
|
<NavigationProperty Name="Naczepy" Relationship="Model.FK_NaczepaCiagnik" FromRole="Machine" ToRole="Machine1" />
|
|
<NavigationProperty Name="Ciagnik" Relationship="Model.FK_NaczepaCiagnik" FromRole="Machine1" ToRole="Machine" />
|
|
<NavigationProperty Name="CiagnikOrderLists" Relationship="Model.FK_OrderListCiagnik" FromRole="Machine" ToRole="OrderList" />
|
|
<NavigationProperty Name="NaczepaOrderLists" Relationship="Model.FK_OrderListNaczepa" FromRole="Machine" ToRole="OrderList" />
|
|
<NavigationProperty Name="MachineRepairs" Relationship="Model.FK_RepairMachine" FromRole="Machine" ToRole="MachineRepair" />
|
|
<NavigationProperty Name="Kierowca" Relationship="Model.FK_MachineKierowca" FromRole="Machine" ToRole="UserList" />
|
|
</EntityType>
|
|
<Association Name="FK_ClientDefaultMachine">
|
|
<End Type="Model.Machine" Role="Machine" Multiplicity="0..1" />
|
|
<End Type="Model.Client" Role="Client" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="Client">
|
|
<PropertyRef Name="DefaultMachineId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_MachineCompany">
|
|
<End Type="Model.Company" Role="Company" Multiplicity="0..1" />
|
|
<End Type="Model.Machine" Role="Machine" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="Machine">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostCiagnik">
|
|
<End Type="Model.Machine" Role="Machine" Multiplicity="0..1" />
|
|
<End Type="Model.Cost" Role="Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="MachineId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_FerryCiagnik">
|
|
<End Type="Model.Machine" Role="Machine" Multiplicity="0..1" />
|
|
<End Type="Model.Ferry" Role="Ferry" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="Ferry">
|
|
<PropertyRef Name="MachineId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_NaczepaCiagnik">
|
|
<End Type="Model.Machine" Role="Machine" Multiplicity="0..1" />
|
|
<End Type="Model.Machine" Role="Machine1" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="Machine1">
|
|
<PropertyRef Name="PrzypisanyCiagnikId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListCiagnik">
|
|
<End Type="Model.Machine" Role="Machine" Multiplicity="0..1" />
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="CiagnikId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListNaczepa">
|
|
<End Type="Model.Machine" Role="Machine" Multiplicity="0..1" />
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="NaczepaId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_RepairMachine">
|
|
<End Type="Model.Machine" Role="Machine" Multiplicity="0..1" />
|
|
<End Type="Model.MachineRepair" Role="MachineRepair" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Machine">
|
|
<PropertyRef Name="MachineId" />
|
|
</Principal>
|
|
<Dependent Role="MachineRepair">
|
|
<PropertyRef Name="MachineId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkerSalaryType">
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="0..1" />
|
|
<End Type="Model.Worker" Role="Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="SalaryTypeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="UserList">
|
|
<Key>
|
|
<PropertyRef Name="UserId" />
|
|
</Key>
|
|
<Property Name="UserId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="CompanyId" Type="Int64" />
|
|
<Property Name="Login" Type="String" MaxLength="32" FixedLength="false" Unicode="false" />
|
|
<Property Name="Password" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="Salt" Type="Binary" MaxLength="16" FixedLength="true" />
|
|
<Property Name="Session" Type="String" MaxLength="512" FixedLength="false" Unicode="false" />
|
|
<Property Name="SessionCount" Type="Int32" />
|
|
<Property Name="SessionTime" Type="DateTime" Precision="3" />
|
|
<Property Name="AccountTypeId" Type="Int64" Nullable="false" />
|
|
<Property Name="Email" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="EmailVerifactionCode" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="IsVerified" Type="Boolean" />
|
|
<Property Name="LoginFailed" Type="Int32" />
|
|
<Property Name="PasswordReset" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
<Property Name="PasswordResetTime" Type="DateTime" Precision="3" />
|
|
<Property Name="Deleted" Type="Boolean" />
|
|
<Property Name="DeletedDate" Type="DateTime" Precision="3" />
|
|
<Property Name="LastWorktimeCostUpdate" Type="DateTime" Precision="3" />
|
|
<NavigationProperty Name="AccountType" Relationship="Model.FK_UserAccountType" FromRole="UserList" ToRole="AccountType" />
|
|
<NavigationProperty Name="Companies" Relationship="Model.FK_CompanyWlasciciel" FromRole="UserList" ToRole="Company" />
|
|
<NavigationProperty Name="Company" Relationship="Model.FK_UserCompany" FromRole="UserList" ToRole="Company" />
|
|
<NavigationProperty Name="Costs" Relationship="Model.FK_CostUser" FromRole="UserList" ToRole="Cost" />
|
|
<NavigationProperty Name="Ferries" Relationship="Model.FK_FerryUser" FromRole="UserList" ToRole="Ferry" />
|
|
<NavigationProperty Name="LoginResults" Relationship="Model.FK_LoginResultUser" FromRole="UserList" ToRole="LoginResult" />
|
|
<NavigationProperty Name="Machines" Relationship="Model.FK_MachineKierowca" FromRole="UserList" ToRole="Machine" />
|
|
<NavigationProperty Name="ZleceniaConnections" Relationship="Model.FK_OrderUserConnection_User" FromRole="UserList" ToRole="OrderUserConnection" />
|
|
<NavigationProperty Name="Workers" Relationship="Model.FK_WorkerUserList" FromRole="UserList" ToRole="Worker" />
|
|
<NavigationProperty Name="WorkTimes" Relationship="Model.FK_WorkTimeUser" FromRole="UserList" ToRole="WorkTime" />
|
|
<NavigationProperty Name="SessionHistory" Relationship="Model.FK_SessionHistoryUser" FromRole="UserList" ToRole="SessionHistory" />
|
|
<NavigationProperty Name="OrderUserHistoriesTo" Relationship="Model.FK_OrderHistoryUserFrom" FromRole="UserList" ToRole="OrderUserHistory" />
|
|
<NavigationProperty Name="OrderUserHistoriesFrom" Relationship="Model.FK_OrderHistoryUserTo" FromRole="UserList" ToRole="OrderUserHistory" />
|
|
<NavigationProperty Name="SubskrypcjaPWASet" Relationship="Model.FK_PWAUser" FromRole="UserList" ToRole="SubskrypcjaPWASet" />
|
|
<NavigationProperty Name="Notifications" Relationship="Model.FK_NotificationUser" FromRole="UserList" ToRole="Notification" />
|
|
</EntityType>
|
|
<Association Name="FK_UserAccountType">
|
|
<End Type="Model.AccountType" Role="AccountType" Multiplicity="1" />
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="AccountType">
|
|
<PropertyRef Name="AccountTypeId" />
|
|
</Principal>
|
|
<Dependent Role="UserList">
|
|
<PropertyRef Name="AccountTypeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CompanyWlasciciel">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="0..1" />
|
|
<End Type="Model.Company" Role="Company" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Company">
|
|
<PropertyRef Name="WlascicielId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_UserCompany">
|
|
<End Type="Model.Company" Role="Company" Multiplicity="0..1" />
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Company">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Principal>
|
|
<Dependent Role="UserList">
|
|
<PropertyRef Name="CompanyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostUser">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="0..1" />
|
|
<End Type="Model.Cost" Role="Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_FerryUser">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="0..1" />
|
|
<End Type="Model.Ferry" Role="Ferry" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Ferry">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_LoginResultUser">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="0..1" />
|
|
<End Type="Model.LoginResult" Role="LoginResult" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="LoginResult">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_MachineKierowca">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="0..1" />
|
|
<End Type="Model.Machine" Role="Machine" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Machine">
|
|
<PropertyRef Name="KierowcaId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderUserConnection_User">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="1" />
|
|
<End Type="Model.OrderUserConnection" Role="OrderUserConnection" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserConnection">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkerUserList">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="0..1" />
|
|
<End Type="Model.Worker" Role="Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="UserListId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkTimeUser">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="1" />
|
|
<End Type="Model.WorkTime" Role="WorkTime" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="WorkTime">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostWorktime">
|
|
<End Type="Model.WorkTime" Role="WorkTime" Multiplicity="0..1" />
|
|
<End Type="Model.Cost" Role="Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="WorkTime">
|
|
<PropertyRef Name="WorkTimeId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="WorktimeId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_CostCurrency">
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="0..1" />
|
|
<End Type="Model.Cost" Role="Cost" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="Cost">
|
|
<PropertyRef Name="CurrencyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_RepairCurrency">
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="0..1" />
|
|
<End Type="Model.MachineRepair" Role="MachineRepair" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="MachineRepair">
|
|
<PropertyRef Name="CurrencyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderListCurrency">
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="0..1" />
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="OrderList">
|
|
<PropertyRef Name="CurrencyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_WorkerCurrency">
|
|
<End Type="Model.Slownik" Role="Slownik" Multiplicity="0..1" />
|
|
<End Type="Model.Worker" Role="Worker" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Slownik">
|
|
<PropertyRef Name="SlownikId" />
|
|
</Principal>
|
|
<Dependent Role="Worker">
|
|
<PropertyRef Name="CurrencyId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="SessionHistory">
|
|
<Key>
|
|
<PropertyRef Name="SessionHistoryId" />
|
|
</Key>
|
|
<Property Name="SessionHistoryId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="UserListId" Type="Int64" />
|
|
<Property Name="Amount" Type="Int32" />
|
|
<Property Name="ZeroingSessionDate" Type="DateTime" Precision="3" />
|
|
<NavigationProperty Name="UserList" Relationship="Model.FK_SessionHistoryUser" FromRole="SessionHistory" ToRole="UserList" />
|
|
</EntityType>
|
|
<Association Name="FK_SessionHistoryUser">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="0..1" />
|
|
<End Type="Model.SessionHistory" Role="SessionHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="SessionHistory">
|
|
<PropertyRef Name="UserListId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="OrderUserHistory">
|
|
<Key>
|
|
<PropertyRef Name="OrderUserHistoryId" />
|
|
</Key>
|
|
<Property Name="OrderUserHistoryId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="OrderId" Type="Int64" Nullable="false" />
|
|
<Property Name="UserFromId" Type="Int64" Nullable="false" />
|
|
<Property Name="UserToId" Type="Int64" Nullable="false" />
|
|
<Property Name="DateOfChange" Type="DateTime" Precision="3" />
|
|
<Property Name="DateOfReporting" Type="DateTime" Precision="3" />
|
|
<NavigationProperty Name="OrderList" Relationship="Model.FK_OrderHistoryOrder" FromRole="OrderUserHistory" ToRole="OrderList" />
|
|
<NavigationProperty Name="UserFrom" Relationship="Model.FK_OrderHistoryUserFrom" FromRole="OrderUserHistory" ToRole="UserList" />
|
|
<NavigationProperty Name="UserTo" Relationship="Model.FK_OrderHistoryUserTo" FromRole="OrderUserHistory" ToRole="UserList" />
|
|
<Property Name="AdressId" Type="Int64" />
|
|
<NavigationProperty Name="Adress" Relationship="Model.FK_OrderHistoryAdress" FromRole="OrderUserHistory" ToRole="Adress" />
|
|
</EntityType>
|
|
<Association Name="FK_OrderHistoryOrder">
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="1" />
|
|
<End Type="Model.OrderUserHistory" Role="OrderUserHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserHistory">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderHistoryUserFrom">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="1" />
|
|
<End Type="Model.OrderUserHistory" Role="OrderUserHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserHistory">
|
|
<PropertyRef Name="UserFromId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderHistoryUserTo">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="1" />
|
|
<End Type="Model.OrderUserHistory" Role="OrderUserHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserHistory">
|
|
<PropertyRef Name="UserToId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_OrderHistoryAdress">
|
|
<End Type="Model.Adress" Role="Adress" Multiplicity="0..1" />
|
|
<End Type="Model.OrderUserHistory" Role="OrderUserHistory" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Adress">
|
|
<PropertyRef Name="AdressId" />
|
|
</Principal>
|
|
<Dependent Role="OrderUserHistory">
|
|
<PropertyRef Name="AdressId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="CiagnikiList">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Nazwa" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="CompanyId" Type="Int64" />
|
|
</EntityType>
|
|
<EntityType Name="PracownicyList">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int64" Nullable="false" />
|
|
<Property Name="Nazwa" Type="String" MaxLength="513" FixedLength="false" Unicode="false" />
|
|
<Property Name="CompanyId" Type="Int64" />
|
|
<Property Name="IsDeleted" Type="Boolean" />
|
|
<Property Name="AccountType" Type="String" MaxLength="256" FixedLength="false" Unicode="false" />
|
|
</EntityType>
|
|
<EntityType Name="ZleceniaList">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Nazwa" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="CompanyId" Type="Int64" />
|
|
</EntityType>
|
|
<EntityType Name="SmsLog">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="PhoneNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Text" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
|
<Property Name="CreationDate" Type="DateTime" Precision="3" />
|
|
<Property Name="DateRead" Type="DateTime" Precision="3" />
|
|
<Property Name="SendAfter" Type="DateTime" Precision="3" />
|
|
<Property Name="BlockedSending" Type="Boolean" />
|
|
<Property Name="SentDate" Type="DateTime" Precision="3" />
|
|
</EntityType>
|
|
<EntityType Name="SubskrypcjaPWASet">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Endpoint" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
|
|
<Property Name="p256dh" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="Auth" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="System" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
|
|
<Property Name="IsActive" Type="Boolean" Nullable="false" />
|
|
<Property Name="IsAndroid" Type="Boolean" Nullable="false" />
|
|
<Property Name="UserListId" Type="Int64" />
|
|
<NavigationProperty Name="UserList" Relationship="Model.FK_PWAUser" FromRole="SubskrypcjaPWASet" ToRole="UserList" />
|
|
</EntityType>
|
|
<Association Name="FK_PWAUser">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="0..1" />
|
|
<End Type="Model.SubskrypcjaPWASet" Role="SubskrypcjaPWASet" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="SubskrypcjaPWASet">
|
|
<PropertyRef Name="UserListId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="Ubezpieczenia">
|
|
<Key>
|
|
<PropertyRef Name="Id" />
|
|
</Key>
|
|
<Property Name="Id" Type="Int64" Nullable="false" />
|
|
<Property Name="RokObowiazywania" Type="DateTime" Precision="3" />
|
|
<Property Name="Zdrowotne" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="Emerytalne" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="Rentowe" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="Chorobowe" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="FunduszPracy" Type="Decimal" Precision="18" Scale="2" />
|
|
<Property Name="FGSP" Type="Decimal" Precision="18" Scale="2" />
|
|
</EntityType>
|
|
<EntityType Name="Notification">
|
|
<Key>
|
|
<PropertyRef Name="NotificationId" />
|
|
</Key>
|
|
<Property Name="NotificationId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Text" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
|
<Property Name="IsSMS" Type="Boolean" />
|
|
<Property Name="IsPWA" Type="Boolean" />
|
|
<Property Name="CreationDate" Type="DateTime" Precision="3" />
|
|
<Property Name="SentDate" Type="DateTime" Precision="3" />
|
|
<Property Name="IsSend" Type="Boolean" />
|
|
<Property Name="UserId" Type="Int64" />
|
|
<Property Name="OrderId" Type="Int64" />
|
|
<NavigationProperty Name="OrderList" Relationship="Model.FK_NotificationOrder" FromRole="Notification" ToRole="OrderList" />
|
|
<NavigationProperty Name="UserList" Relationship="Model.FK_NotificationUser" FromRole="Notification" ToRole="UserList" />
|
|
</EntityType>
|
|
<Association Name="FK_NotificationOrder">
|
|
<End Type="Model.OrderList" Role="OrderList" Multiplicity="0..1" />
|
|
<End Type="Model.Notification" Role="Notification" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="OrderList">
|
|
<PropertyRef Name="OrderListId" />
|
|
</Principal>
|
|
<Dependent Role="Notification">
|
|
<PropertyRef Name="OrderId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_NotificationUser">
|
|
<End Type="Model.UserList" Role="UserList" Multiplicity="0..1" />
|
|
<End Type="Model.Notification" Role="Notification" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="UserList">
|
|
<PropertyRef Name="UserId" />
|
|
</Principal>
|
|
<Dependent Role="Notification">
|
|
<PropertyRef Name="UserId" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
</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="ModelStoreContainer" CdmEntityContainer="Entities">
|
|
<EntitySetMapping Name="C__RefactorLog">
|
|
<EntityTypeMapping TypeName="Model.C__RefactorLog">
|
|
<MappingFragment StoreEntitySet="__RefactorLog">
|
|
<ScalarProperty Name="OperationKey" ColumnName="OperationKey" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Company">
|
|
<EntityTypeMapping TypeName="Model.Company">
|
|
<MappingFragment StoreEntitySet="Company">
|
|
<ScalarProperty Name="LastPaydate" ColumnName="LastPaydate" />
|
|
<ScalarProperty Name="WlascicielId" ColumnName="WlascicielId" />
|
|
<ScalarProperty Name="NIP" ColumnName="NIP" />
|
|
<ScalarProperty Name="AdressId" ColumnName="AdressId" />
|
|
<ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="example">
|
|
<EntityTypeMapping TypeName="Model.example">
|
|
<MappingFragment StoreEntitySet="example">
|
|
<ScalarProperty Name="one" ColumnName="one" />
|
|
<ScalarProperty Name="two" ColumnName="two" />
|
|
<ScalarProperty Name="three" ColumnName="three" />
|
|
<ScalarProperty Name="fout" ColumnName="fout" />
|
|
<ScalarProperty Name="five" ColumnName="five" />
|
|
<ScalarProperty Name="six" ColumnName="six" />
|
|
<ScalarProperty Name="seven" ColumnName="seven" />
|
|
<ScalarProperty Name="eight" ColumnName="eight" />
|
|
<ScalarProperty Name="nine" ColumnName="nine" />
|
|
<ScalarProperty Name="ten" ColumnName="ten" />
|
|
<ScalarProperty Name="eleven" ColumnName="eleven" />
|
|
<ScalarProperty Name="twelve" ColumnName="twelve" />
|
|
<ScalarProperty Name="thirteen" ColumnName="thirteen" />
|
|
<ScalarProperty Name="fourteen" ColumnName="fourteen" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="LoginResult">
|
|
<EntityTypeMapping TypeName="Model.LoginResult">
|
|
<MappingFragment StoreEntitySet="LoginResult">
|
|
<ScalarProperty Name="Browser" ColumnName="Browser" />
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|
<ScalarProperty Name="Type" ColumnName="Type" />
|
|
<ScalarProperty Name="Date" ColumnName="Date" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="sysdiagrams">
|
|
<EntityTypeMapping TypeName="Model.sysdiagrams">
|
|
<MappingFragment StoreEntitySet="sysdiagrams">
|
|
<ScalarProperty Name="name" ColumnName="name" />
|
|
<ScalarProperty Name="principal_id" ColumnName="principal_id" />
|
|
<ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
|
|
<ScalarProperty Name="version" ColumnName="version" />
|
|
<ScalarProperty Name="definition" ColumnName="definition" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<FunctionImportMapping FunctionImportName="sp_alterdiagram" FunctionName="Model.Store.sp_alterdiagram" />
|
|
<FunctionImportMapping FunctionImportName="sp_creatediagram" FunctionName="Model.Store.sp_creatediagram" />
|
|
<FunctionImportMapping FunctionImportName="sp_dropdiagram" FunctionName="Model.Store.sp_dropdiagram" />
|
|
<FunctionImportMapping FunctionImportName="sp_helpdiagramdefinition" FunctionName="Model.Store.sp_helpdiagramdefinition">
|
|
<ResultMapping>
|
|
<ComplexTypeMapping TypeName="Model.sp_helpdiagramdefinition_Result">
|
|
<ScalarProperty Name="version" ColumnName="version" />
|
|
<ScalarProperty Name="definition" ColumnName="definition" />
|
|
</ComplexTypeMapping>
|
|
</ResultMapping>
|
|
</FunctionImportMapping>
|
|
<FunctionImportMapping FunctionImportName="sp_helpdiagrams" FunctionName="Model.Store.sp_helpdiagrams">
|
|
<ResultMapping>
|
|
<ComplexTypeMapping TypeName="Model.sp_helpdiagrams_Result">
|
|
<ScalarProperty Name="Database" ColumnName="Database" />
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
<ScalarProperty Name="Owner" ColumnName="Owner" />
|
|
<ScalarProperty Name="OwnerID" ColumnName="OwnerID" />
|
|
</ComplexTypeMapping>
|
|
</ResultMapping>
|
|
</FunctionImportMapping>
|
|
<FunctionImportMapping FunctionImportName="sp_renamediagram" FunctionName="Model.Store.sp_renamediagram" />
|
|
<FunctionImportMapping FunctionImportName="sp_upgraddiagrams" FunctionName="Model.Store.sp_upgraddiagrams" />
|
|
<EntitySetMapping Name="Adress">
|
|
<EntityTypeMapping TypeName="Model.Adress">
|
|
<MappingFragment StoreEntitySet="Adress">
|
|
<ScalarProperty Name="Number" ColumnName="Number" />
|
|
<ScalarProperty Name="Street" ColumnName="Street" />
|
|
<ScalarProperty Name="City" ColumnName="City" />
|
|
<ScalarProperty Name="Voivodship" ColumnName="Voivodship" />
|
|
<ScalarProperty Name="Country" ColumnName="Country" />
|
|
<ScalarProperty Name="Postcode" ColumnName="Postcode" />
|
|
<ScalarProperty Name="AdressId" ColumnName="AdressId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Client">
|
|
<EntityTypeMapping TypeName="Model.Client">
|
|
<MappingFragment StoreEntitySet="Client">
|
|
<ScalarProperty Name="PostAdressId" ColumnName="PostAdressId" />
|
|
<ScalarProperty Name="NIP" ColumnName="NIP" />
|
|
<ScalarProperty Name="DefaultMachineId" ColumnName="DefaultMachineId" />
|
|
<ScalarProperty Name="DefaultEndAdressId" ColumnName="DefaultEndAdressId" />
|
|
<ScalarProperty Name="DefaultStartAdressId" ColumnName="DefaultStartAdressId" />
|
|
<ScalarProperty Name="DefaultContactId" ColumnName="DefaultContactId" />
|
|
<ScalarProperty Name="DeletionDate" ColumnName="DeletionDate" />
|
|
<ScalarProperty Name="IsRemoved" ColumnName="IsRemoved" />
|
|
<ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
|
|
<ScalarProperty Name="AdressId" ColumnName="AdressId" />
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
<ScalarProperty Name="ClientId" ColumnName="ClientId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Ferry">
|
|
<EntityTypeMapping TypeName="Model.Ferry">
|
|
<MappingFragment StoreEntitySet="Ferry">
|
|
<ScalarProperty Name="DeletionDate" ColumnName="DeletionDate" />
|
|
<ScalarProperty Name="PayDate" ColumnName="PayDate" />
|
|
<ScalarProperty Name="MachineId" ColumnName="MachineId" />
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|
<ScalarProperty Name="OrderId" ColumnName="OrderId" />
|
|
<ScalarProperty Name="IsReal" ColumnName="IsReal" />
|
|
<ScalarProperty Name="Cost" ColumnName="Cost" />
|
|
<ScalarProperty Name="EndDate" ColumnName="EndDate" />
|
|
<ScalarProperty Name="StartDate" ColumnName="StartDate" />
|
|
<ScalarProperty Name="To" ColumnName="To" />
|
|
<ScalarProperty Name="From" ColumnName="From" />
|
|
<ScalarProperty Name="FerryId" ColumnName="FerryId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Slownik">
|
|
<EntityTypeMapping TypeName="Model.Slownik">
|
|
<MappingFragment StoreEntitySet="Slownik">
|
|
<ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
|
|
<ScalarProperty Name="SlownikTypId" ColumnName="SlownikTypId" />
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
<ScalarProperty Name="SlownikId" ColumnName="SlownikId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="SlownikTyp">
|
|
<EntityTypeMapping TypeName="Model.SlownikTyp">
|
|
<MappingFragment StoreEntitySet="SlownikTyp">
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
<ScalarProperty Name="SlownikTypId" ColumnName="SlownikTypId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="AccountType">
|
|
<EntityTypeMapping TypeName="Model.AccountType">
|
|
<MappingFragment StoreEntitySet="AccountType">
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
<ScalarProperty Name="AccountTypeId" ColumnName="AccountTypeId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="IPLoginFailed">
|
|
<EntityTypeMapping TypeName="Model.IPLoginFailed">
|
|
<MappingFragment StoreEntitySet="IPLoginFailed">
|
|
<ScalarProperty Name="IP" ColumnName="IP" />
|
|
<ScalarProperty Name="Date" ColumnName="Date" />
|
|
<ScalarProperty Name="Count" ColumnName="Count" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Email">
|
|
<EntityTypeMapping TypeName="Model.Email">
|
|
<MappingFragment StoreEntitySet="Email">
|
|
<ScalarProperty Name="WorkerId" ColumnName="WorkerId" />
|
|
<ScalarProperty Name="ContactId" ColumnName="ContactId" />
|
|
<ScalarProperty Name="Adress" ColumnName="Email" />
|
|
<ScalarProperty Name="EmailId" ColumnName="EmailId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="OrderContactConnection">
|
|
<EntityTypeMapping TypeName="Model.OrderContactConnection">
|
|
<MappingFragment StoreEntitySet="OrderContactConnection">
|
|
<ScalarProperty Name="IsEndContact" ColumnName="IsEndContact" />
|
|
<ScalarProperty Name="IsStartContact" ColumnName="IsStartContact" />
|
|
<ScalarProperty Name="ContactId" ColumnName="ContactId" />
|
|
<ScalarProperty Name="OrderId" ColumnName="OrderId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="PhoneNumber">
|
|
<EntityTypeMapping TypeName="Model.PhoneNumber">
|
|
<MappingFragment StoreEntitySet="PhoneNumber">
|
|
<ScalarProperty Name="WorkerId" ColumnName="WorkerId" />
|
|
<ScalarProperty Name="ContactId" ColumnName="ContactId" />
|
|
<ScalarProperty Name="Number" ColumnName="Number" />
|
|
<ScalarProperty Name="PhoneId" ColumnName="PhoneId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="OrderList">
|
|
<EntityTypeMapping TypeName="Model.OrderList">
|
|
<MappingFragment StoreEntitySet="OrderList">
|
|
<ScalarProperty Name="CurrencyId" ColumnName="CurrencyId" />
|
|
<ScalarProperty Name="AwizoNumber" ColumnName="AwizoNumber" />
|
|
<ScalarProperty Name="OrderNumber" ColumnName="OrderNumber" />
|
|
<ScalarProperty Name="DeletionDate" ColumnName="DeletionDate" />
|
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
|
<ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
|
|
<ScalarProperty Name="NaczepaId" ColumnName="NaczepaId" />
|
|
<ScalarProperty Name="CiagnikId" ColumnName="CiagnikId" />
|
|
<ScalarProperty Name="KwotaZlecenia" ColumnName="KwotaZlecenia" />
|
|
<ScalarProperty Name="EndDate" ColumnName="EndDate" />
|
|
<ScalarProperty Name="EndAdressId" ColumnName="EndAdressId" />
|
|
<ScalarProperty Name="StartDate" ColumnName="StartDate" />
|
|
<ScalarProperty Name="StartAdressId" ColumnName="StartAdressId" />
|
|
<ScalarProperty Name="ClientId" ColumnName="ClientId" />
|
|
<ScalarProperty Name="DataUtworzenia" ColumnName="DataUtworzenia" />
|
|
<ScalarProperty Name="OrderListId" ColumnName="OrderListId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Contact">
|
|
<EntityTypeMapping TypeName="Model.Contact">
|
|
<MappingFragment StoreEntitySet="Contact">
|
|
<ScalarProperty Name="ClientId" ColumnName="ClientId" />
|
|
<ScalarProperty Name="IsOwner" ColumnName="IsOwner" />
|
|
<ScalarProperty Name="Surname" ColumnName="Surname" />
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
<ScalarProperty Name="ContactId" ColumnName="ContactId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Worker">
|
|
<EntityTypeMapping TypeName="Model.Worker">
|
|
<MappingFragment StoreEntitySet="Worker">
|
|
<ScalarProperty Name="CzyPracujeNaMiejscu" ColumnName="CzyPracujeNaMiejscu" />
|
|
<ScalarProperty Name="UbezpieczenieWypadkowe" ColumnName="UbezpieczenieWypadkowe" />
|
|
<ScalarProperty Name="CurrencyId" ColumnName="CurrencyId" />
|
|
<ScalarProperty Name="SalaryTypeId" ColumnName="SalaryTypeId" />
|
|
<ScalarProperty Name="NrKonta" ColumnName="NrKonta" />
|
|
<ScalarProperty Name="DrugieImie" ColumnName="DrugieImie" />
|
|
<ScalarProperty Name="ContactId" ColumnName="ContactId" />
|
|
<ScalarProperty Name="Pensja" ColumnName="Pensja" />
|
|
<ScalarProperty Name="AdressId" ColumnName="AdressId" />
|
|
<ScalarProperty Name="Birthdate" ColumnName="Birthdate" />
|
|
<ScalarProperty Name="PESEL" ColumnName="PESEL" />
|
|
<ScalarProperty Name="Nazwisko" ColumnName="Nazwisko" />
|
|
<ScalarProperty Name="Imie" ColumnName="Imie" />
|
|
<ScalarProperty Name="UserListId" ColumnName="UserListId" />
|
|
<ScalarProperty Name="WorkerId" ColumnName="WorkerId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="OrderUserConnection">
|
|
<EntityTypeMapping TypeName="Model.OrderUserConnection">
|
|
<MappingFragment StoreEntitySet="OrderUserConnection">
|
|
<ScalarProperty Name="IsCurrentDriver" ColumnName="IsCurrentDriver" />
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|
<ScalarProperty Name="OrderId" ColumnName="OrderId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="WorkTime">
|
|
<EntityTypeMapping TypeName="Model.WorkTime">
|
|
<MappingFragment StoreEntitySet="WorkTime">
|
|
<ScalarProperty Name="End" ColumnName="End" />
|
|
<ScalarProperty Name="Start" ColumnName="Start" />
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|
<ScalarProperty Name="WorkTimeId" ColumnName="WorkTimeId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="MachineRepair">
|
|
<EntityTypeMapping TypeName="Model.MachineRepair">
|
|
<MappingFragment StoreEntitySet="MachineRepair">
|
|
<ScalarProperty Name="CurrencyId" ColumnName="CurrencyId" />
|
|
<ScalarProperty Name="WorkstationId" ColumnName="WorkstationId" />
|
|
<ScalarProperty Name="Description" ColumnName="Description" />
|
|
<ScalarProperty Name="Cost" ColumnName="Cost" />
|
|
<ScalarProperty Name="ServiceTypeId" ColumnName="ServiceTypeId" />
|
|
<ScalarProperty Name="ServiceEndDate" ColumnName="ServiceEndDate" />
|
|
<ScalarProperty Name="ServiceStartDate" ColumnName="ServiceStartDate" />
|
|
<ScalarProperty Name="MachineId" ColumnName="MachineId" />
|
|
<ScalarProperty Name="MachineRepairId" ColumnName="MachineRepairId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Cost">
|
|
<EntityTypeMapping TypeName="Model.Cost">
|
|
<MappingFragment StoreEntitySet="Cost">
|
|
<ScalarProperty Name="CurrencyId" ColumnName="CurrencyId" />
|
|
<ScalarProperty Name="WorktimeId" ColumnName="WorktimeId" />
|
|
<ScalarProperty Name="CostTypeId" ColumnName="CostTypeId" />
|
|
<ScalarProperty Name="DeletionDate" ColumnName="DeletionDate" />
|
|
<ScalarProperty Name="PayDate" ColumnName="PayDate" />
|
|
<ScalarProperty Name="MachineId" ColumnName="MachineId" />
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|
<ScalarProperty Name="OrderId" ColumnName="OrderId" />
|
|
<ScalarProperty Name="ActualCost" ColumnName="Cost" />
|
|
<ScalarProperty Name="Describtion" ColumnName="Describtion" />
|
|
<ScalarProperty Name="CostId" ColumnName="CostId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Machine">
|
|
<EntityTypeMapping TypeName="Model.Machine">
|
|
<MappingFragment StoreEntitySet="Machine">
|
|
<ScalarProperty Name="RegistrationDate" ColumnName="RegistrationDate" />
|
|
<ScalarProperty Name="AxisSerialNumber" ColumnName="AxisSerialNumber" />
|
|
<ScalarProperty Name="VIN" ColumnName="VIN" />
|
|
<ScalarProperty Name="MaximalFuel" ColumnName="MaximalFuel" />
|
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
|
<ScalarProperty Name="PrzypisanyCiagnikId" ColumnName="PrzypisanyCiagnikId" />
|
|
<ScalarProperty Name="KierowcaId" ColumnName="KierowcaId" />
|
|
<ScalarProperty Name="IsNaczepa" ColumnName="IsNaczepa" />
|
|
<ScalarProperty Name="IsCiagnik" ColumnName="IsCiagnik" />
|
|
<ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
|
|
<ScalarProperty Name="ModelName" ColumnName="ModelName" />
|
|
<ScalarProperty Name="LastPrzegladDate" ColumnName="LastPrzegladDate" />
|
|
<ScalarProperty Name="TachografLegalizationDate" ColumnName="TachografLegalizationDate" />
|
|
<ScalarProperty Name="FuelStatus" ColumnName="FuelStatus" />
|
|
<ScalarProperty Name="Owner" ColumnName="Owner" />
|
|
<ScalarProperty Name="Brand" ColumnName="Brand" />
|
|
<ScalarProperty Name="Przebieg" ColumnName="Przebieg" />
|
|
<ScalarProperty Name="RegistrationNumber" ColumnName="RegistrationNumber" />
|
|
<ScalarProperty Name="MachineId" ColumnName="MachineId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="UserList">
|
|
<EntityTypeMapping TypeName="Model.UserList">
|
|
<MappingFragment StoreEntitySet="UserList">
|
|
<ScalarProperty Name="LastWorktimeCostUpdate" ColumnName="LastWorktimeCostUpdate" />
|
|
<ScalarProperty Name="DeletedDate" ColumnName="DeletedDate" />
|
|
<ScalarProperty Name="Deleted" ColumnName="Deleted" />
|
|
<ScalarProperty Name="PasswordResetTime" ColumnName="PasswordResetTime" />
|
|
<ScalarProperty Name="PasswordReset" ColumnName="PasswordReset" />
|
|
<ScalarProperty Name="LoginFailed" ColumnName="LoginFailed" />
|
|
<ScalarProperty Name="IsVerified" ColumnName="IsVerified" />
|
|
<ScalarProperty Name="EmailVerifactionCode" ColumnName="EmailVerifactionCode" />
|
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
|
<ScalarProperty Name="AccountTypeId" ColumnName="AccountTypeId" />
|
|
<ScalarProperty Name="SessionTime" ColumnName="SessionTime" />
|
|
<ScalarProperty Name="SessionCount" ColumnName="SessionCount" />
|
|
<ScalarProperty Name="Session" ColumnName="Session" />
|
|
<ScalarProperty Name="Salt" ColumnName="Salt" />
|
|
<ScalarProperty Name="Password" ColumnName="Password" />
|
|
<ScalarProperty Name="Login" ColumnName="Login" />
|
|
<ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="SessionHistory">
|
|
<EntityTypeMapping TypeName="Model.SessionHistory">
|
|
<MappingFragment StoreEntitySet="SessionHistory">
|
|
<ScalarProperty Name="ZeroingSessionDate" ColumnName="ZeroingSessionDate" />
|
|
<ScalarProperty Name="Amount" ColumnName="Amount" />
|
|
<ScalarProperty Name="UserListId" ColumnName="UserListId" />
|
|
<ScalarProperty Name="SessionHistoryId" ColumnName="SessionHistoryId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="OrderUserHistory">
|
|
<EntityTypeMapping TypeName="Model.OrderUserHistory">
|
|
<MappingFragment StoreEntitySet="OrderUserHistory">
|
|
<ScalarProperty Name="AdressId" ColumnName="AdressId" />
|
|
<ScalarProperty Name="DateOfReporting" ColumnName="DateOfReporting" />
|
|
<ScalarProperty Name="DateOfChange" ColumnName="DateOfChange" />
|
|
<ScalarProperty Name="UserToId" ColumnName="UserToId" />
|
|
<ScalarProperty Name="UserFromId" ColumnName="UserFromId" />
|
|
<ScalarProperty Name="OrderId" ColumnName="OrderId" />
|
|
<ScalarProperty Name="OrderUserHistoryId" ColumnName="OrderUserHistoryId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="CiagnikiList">
|
|
<EntityTypeMapping TypeName="Model.CiagnikiList">
|
|
<MappingFragment StoreEntitySet="CiagnikiList">
|
|
<ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
|
|
<ScalarProperty Name="Nazwa" ColumnName="Nazwa" />
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="PracownicyList">
|
|
<EntityTypeMapping TypeName="Model.PracownicyList">
|
|
<MappingFragment StoreEntitySet="PracownicyList">
|
|
<ScalarProperty Name="AccountType" ColumnName="AccountType" />
|
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
|
<ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
|
|
<ScalarProperty Name="Nazwa" ColumnName="Nazwa" />
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="ZleceniaList">
|
|
<EntityTypeMapping TypeName="Model.ZleceniaList">
|
|
<MappingFragment StoreEntitySet="ZleceniaList">
|
|
<ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
|
|
<ScalarProperty Name="Nazwa" ColumnName="Nazwa" />
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="SmsLog">
|
|
<EntityTypeMapping TypeName="Model.SmsLog">
|
|
<MappingFragment StoreEntitySet="SmsLog">
|
|
<ScalarProperty Name="SentDate" ColumnName="SentDate" />
|
|
<ScalarProperty Name="BlockedSending" ColumnName="BlockedSending" />
|
|
<ScalarProperty Name="SendAfter" ColumnName="SendAfter" />
|
|
<ScalarProperty Name="DateRead" ColumnName="DateRead" />
|
|
<ScalarProperty Name="CreationDate" ColumnName="CreationDate" />
|
|
<ScalarProperty Name="Text" ColumnName="Text" />
|
|
<ScalarProperty Name="PhoneNumber" ColumnName="PhoneNumber" />
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="SubskrypcjaPWASet">
|
|
<EntityTypeMapping TypeName="Model.SubskrypcjaPWASet">
|
|
<MappingFragment StoreEntitySet="SubskrypcjaPWASet">
|
|
<ScalarProperty Name="UserListId" ColumnName="UserListId" />
|
|
<ScalarProperty Name="IsAndroid" ColumnName="IsAndroid" />
|
|
<ScalarProperty Name="IsActive" ColumnName="IsActive" />
|
|
<ScalarProperty Name="System" ColumnName="System" />
|
|
<ScalarProperty Name="Auth" ColumnName="Auth" />
|
|
<ScalarProperty Name="p256dh" ColumnName="p256dh" />
|
|
<ScalarProperty Name="Endpoint" ColumnName="Endpoint" />
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Ubezpieczenia">
|
|
<EntityTypeMapping TypeName="Model.Ubezpieczenia">
|
|
<MappingFragment StoreEntitySet="Ubezpieczenia">
|
|
<ScalarProperty Name="FGSP" ColumnName="FGSP" />
|
|
<ScalarProperty Name="FunduszPracy" ColumnName="FunduszPracy" />
|
|
<ScalarProperty Name="Chorobowe" ColumnName="Chorobowe" />
|
|
<ScalarProperty Name="Rentowe" ColumnName="Rentowe" />
|
|
<ScalarProperty Name="Emerytalne" ColumnName="Emerytalne" />
|
|
<ScalarProperty Name="Zdrowotne" ColumnName="Zdrowotne" />
|
|
<ScalarProperty Name="RokObowiazywania" ColumnName="RokObowiazywania" />
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Notification">
|
|
<EntityTypeMapping TypeName="Model.Notification">
|
|
<MappingFragment StoreEntitySet="Notification">
|
|
<ScalarProperty Name="OrderId" ColumnName="OrderId" />
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|
<ScalarProperty Name="IsSend" ColumnName="IsSend" />
|
|
<ScalarProperty Name="SentDate" ColumnName="SentDate" />
|
|
<ScalarProperty Name="CreationDate" ColumnName="CreationDate" />
|
|
<ScalarProperty Name="IsPWA" ColumnName="IsPWA" />
|
|
<ScalarProperty Name="IsSMS" ColumnName="IsSMS" />
|
|
<ScalarProperty Name="Text" ColumnName="Text" />
|
|
<ScalarProperty Name="NotificationId" ColumnName="NotificationId" />
|
|
</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="None" />
|
|
</DesignerInfoPropertySet>
|
|
</Options>
|
|
<!-- Diagram content (shape and connector positions) -->
|
|
<Diagrams></Diagrams>
|
|
</Designer>
|
|
</edmx:Edmx> |