﻿<?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="PersonalLaundryModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns="http://schemas.microsoft.com/ado/2009/11/edm" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation">
  <EntityType Name="DriverAction">
    <Key>
      <PropertyRef Name="DriverActionId" />
    </Key>
    <Property Name="DriverActionId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Action" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
    <NavigationProperty Name="DriverLogs" Relationship="PersonalLaundryModel.FK_DriverLog_DriverActions" FromRole="DriverAction" ToRole="DriverLog" />
  </EntityType>
  <EntityType Name="DriverLog">
    <Key>
      <PropertyRef Name="DriverLogId" />
    </Key>
    <Property Name="DriverLogId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="LocationId" Type="Int32" Nullable="false" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="DriverActionId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Customer" Relationship="PersonalLaundryModel.FK_DriverLog_Customers" FromRole="DriverLog" ToRole="Customer" />
    <NavigationProperty Name="DriverAction" Relationship="PersonalLaundryModel.FK_DriverLog_DriverActions" FromRole="DriverLog" ToRole="DriverAction" />
    <NavigationProperty Name="Location" Relationship="PersonalLaundryModel.FK_DriverLog_Locations" FromRole="DriverLog" ToRole="Location" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_DriverLog_OperatorLogins" FromRole="DriverLog" ToRole="OperatorLogin" />
  </EntityType>
  <EntityType Name="Setting">
    <Key>
      <PropertyRef Name="SettingId" />
    </Key>
    <Property Name="SettingId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="SettingName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
    <Property Name="SettingValue" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
  </EntityType>
  <EntityContainer Name="DataModel" annotation:LazyLoadingEnabled="true">
    <EntitySet Name="DriverActions" EntityType="Self.DriverAction" />
    <EntitySet Name="DriverLogs" EntityType="Self.DriverLog" />
    <EntitySet Name="Settings" EntityType="Self.Setting" />
    <EntitySet Name="Dispatches" EntityType="PersonalLaundryModel.Dispatch" />
    <EntitySet Name="Invoices" EntityType="PersonalLaundryModel.Invoice" />
    <EntitySet Name="InvoiceStatus" EntityType="PersonalLaundryModel.InvoiceStatu" />
    <EntitySet Name="Locations" EntityType="PersonalLaundryModel.Location" />
    <EntitySet Name="OperatorLogins" EntityType="PersonalLaundryModel.OperatorLogin" />
    <EntitySet Name="OperatorRoles" EntityType="PersonalLaundryModel.OperatorRole" />
    <EntitySet Name="Packages" EntityType="PersonalLaundryModel.Package" />
    <AssociationSet Name="FK_Dispatches_Invoices" Association="PersonalLaundryModel.FK_Dispatches_Invoices">
      <End Role="Invoice" EntitySet="Invoices" />
      <End Role="Dispatch" EntitySet="Dispatches" />
    </AssociationSet>
    <AssociationSet Name="FK_Dispatches_OperatorLogins" Association="PersonalLaundryModel.FK_Dispatches_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="Dispatch" EntitySet="Dispatches" />
    </AssociationSet>
    <AssociationSet Name="FK_Invoices_InvoiceStatus" Association="PersonalLaundryModel.FK_Invoices_InvoiceStatus">
      <End Role="InvoiceStatu" EntitySet="InvoiceStatus" />
      <End Role="Invoice" EntitySet="Invoices" />
    </AssociationSet>
    <AssociationSet Name="FK_Invoices_OperatorLogins" Association="PersonalLaundryModel.FK_Invoices_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="Invoice" EntitySet="Invoices" />
    </AssociationSet>
    <AssociationSet Name="FK_OperatorLogins_OperatorRoles" Association="PersonalLaundryModel.FK_OperatorLogins_OperatorRoles">
      <End Role="OperatorRole" EntitySet="OperatorRoles" />
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
    </AssociationSet>
    <AssociationSet Name="FK_Packages_OperatorLogins" Association="PersonalLaundryModel.FK_Packages_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="Package" EntitySet="Packages" />
    </AssociationSet>
    <EntitySet Name="Actions" EntityType="PersonalLaundryModel.Action" />
    <EntitySet Name="BagReferences" EntityType="PersonalLaundryModel.BagReference" />
    <EntitySet Name="BillingProfiles" EntityType="PersonalLaundryModel.BillingProfile" />
    <EntitySet Name="CustomerInventories" EntityType="PersonalLaundryModel.CustomerInventory" />
    <EntitySet Name="CustomerInventoryAudits" EntityType="PersonalLaundryModel.CustomerInventoryAudit" />
    <EntitySet Name="CustomerLoginLogs" EntityType="PersonalLaundryModel.CustomerLoginLog" />
    <EntitySet Name="CustomerLogins" EntityType="PersonalLaundryModel.CustomerLogin" />
    <EntitySet Name="Customers" EntityType="PersonalLaundryModel.Customer" />
    <EntitySet Name="CustomerWorkloadBags" EntityType="PersonalLaundryModel.CustomerWorkloadBag" />
    <EntitySet Name="DispatchPackages" EntityType="PersonalLaundryModel.DispatchPackage" />
    <EntitySet Name="DispatchStatus" EntityType="PersonalLaundryModel.DispatchStatu" />
    <EntitySet Name="InventoryItems" EntityType="PersonalLaundryModel.InventoryItem" />
    <EntitySet Name="InventoryItemTypeCategories" EntityType="PersonalLaundryModel.InventoryItemTypeCategory" />
    <EntitySet Name="InventoryItemTypes" EntityType="PersonalLaundryModel.InventoryItemType" />
    <EntitySet Name="InventoryItemTypeSizes" EntityType="PersonalLaundryModel.InventoryItemTypeSize" />
    <EntitySet Name="InvoiceBags" EntityType="PersonalLaundryModel.InvoiceBag" />
    <EntitySet Name="InvoiceItems" EntityType="PersonalLaundryModel.InvoiceItem" />
    <EntitySet Name="WorkloadItems" EntityType="PersonalLaundryModel.WorkloadItem" />
    <EntitySet Name="WorkloadItemsAudits" EntityType="PersonalLaundryModel.WorkloadItemsAudit" />
    <EntitySet Name="Workloads" EntityType="PersonalLaundryModel.Workload" />
    <EntitySet Name="WorkloadsAudits" EntityType="PersonalLaundryModel.WorkloadsAudit" />
    <EntitySet Name="WorkloadStatuses" EntityType="PersonalLaundryModel.WorkloadStatus" />
    <EntitySet Name="WorkloadTypes" EntityType="PersonalLaundryModel.WorkloadType" />
    <EntitySet Name="vwClosedCustomerWorkloads" EntityType="PersonalLaundryModel.vwClosedCustomerWorkload" />
    <EntitySet Name="vwCustomerBagsWaitingCountings" EntityType="PersonalLaundryModel.vwCustomerBagsWaitingCounting" />
    <EntitySet Name="vwCustomerInventories" EntityType="PersonalLaundryModel.vwCustomerInventory" />
    <EntitySet Name="vwCustomerInventoryForWorkloads" EntityType="PersonalLaundryModel.vwCustomerInventoryForWorkload" />
    <EntitySet Name="vwCustomerInventoryWorkloads" EntityType="PersonalLaundryModel.vwCustomerInventoryWorkload" />
    <EntitySet Name="vwDeliveryNoteCategoriesByBagSeals" EntityType="PersonalLaundryModel.vwDeliveryNoteCategoriesByBagSeal" />
    <EntitySet Name="vwDispatchBagPackageContents" EntityType="PersonalLaundryModel.vwDispatchBagPackageContent" />
    <EntitySet Name="vwExcelDataDumps" EntityType="PersonalLaundryModel.vwExcelDataDump" />
    <EntitySet Name="vwInventoryItems" EntityType="PersonalLaundryModel.vwInventoryItem" />
    <EntitySet Name="vwInventoryItemTypes" EntityType="PersonalLaundryModel.vwInventoryItemType" />
    <EntitySet Name="vwInvoiceBagSealCategories" EntityType="PersonalLaundryModel.vwInvoiceBagSealCategory" />
    <EntitySet Name="vwInvoiceCountsRecons" EntityType="PersonalLaundryModel.vwInvoiceCountsRecon" />
    <EntitySet Name="vwOpenCustomerWorkloads" EntityType="PersonalLaundryModel.vwOpenCustomerWorkload" />
    <EntitySet Name="vwPackageContents" EntityType="PersonalLaundryModel.vwPackageContent" />
    <EntitySet Name="vwPackagesReadyForDispatches" EntityType="PersonalLaundryModel.vwPackagesReadyForDispatch" />
    <EntitySet Name="vwWorkloadCategoryTypeCounts" EntityType="PersonalLaundryModel.vwWorkloadCategoryTypeCount" />
    <EntitySet Name="vwWorkloadStatusReports" EntityType="PersonalLaundryModel.vwWorkloadStatusReport" />
    <EntitySet Name="vwWorkloadStatusReportWithCounts" EntityType="PersonalLaundryModel.vwWorkloadStatusReportWithCount" />
    <AssociationSet Name="FK_CustomerLoginLog_Actions" Association="PersonalLaundryModel.FK_CustomerLoginLog_Actions">
      <End Role="Action" EntitySet="Actions" />
      <End Role="CustomerLoginLog" EntitySet="CustomerLoginLogs" />
    </AssociationSet>
    <AssociationSet Name="FK_BagReferences_OperatorLogins" Association="PersonalLaundryModel.FK_BagReferences_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="BagReference" EntitySet="BagReferences" />
    </AssociationSet>
    <AssociationSet Name="FK_InvoiceBags_BagReferences" Association="PersonalLaundryModel.FK_InvoiceBags_BagReferences">
      <End Role="BagReference" EntitySet="BagReferences" />
      <End Role="InvoiceBag" EntitySet="InvoiceBags" />
    </AssociationSet>
    <AssociationSet Name="FK_Customers_BillingProfiles" Association="PersonalLaundryModel.FK_Customers_BillingProfiles">
      <End Role="BillingProfile" EntitySet="BillingProfiles" />
      <End Role="Customer" EntitySet="Customers" />
    </AssociationSet>
    <AssociationSet Name="FK_CustomerInventory_Customer" Association="PersonalLaundryModel.FK_CustomerInventory_Customer">
      <End Role="Customer" EntitySet="Customers" />
      <End Role="CustomerInventory" EntitySet="CustomerInventories" />
    </AssociationSet>
    <AssociationSet Name="FK_CustomerInventory_InventoryItemTypes" Association="PersonalLaundryModel.FK_CustomerInventory_InventoryItemTypes">
      <End Role="InventoryItemType" EntitySet="InventoryItemTypes" />
      <End Role="CustomerInventory" EntitySet="CustomerInventories" />
    </AssociationSet>
    <AssociationSet Name="FK_CustomerInventory_OperatorLogins" Association="PersonalLaundryModel.FK_CustomerInventory_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="CustomerInventory" EntitySet="CustomerInventories" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadItems_CustomerInventory" Association="PersonalLaundryModel.FK_WorkloadItems_CustomerInventory">
      <End Role="CustomerInventory" EntitySet="CustomerInventories" />
      <End Role="WorkloadItem" EntitySet="WorkloadItems" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadItemsAudit_CustomerInventory" Association="PersonalLaundryModel.FK_WorkloadItemsAudit_CustomerInventory">
      <End Role="CustomerInventory" EntitySet="CustomerInventories" />
      <End Role="WorkloadItemsAudit" EntitySet="WorkloadItemsAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_CustomerInventoryAudit_Customers" Association="PersonalLaundryModel.FK_CustomerInventoryAudit_Customers">
      <End Role="Customer" EntitySet="Customers" />
      <End Role="CustomerInventoryAudit" EntitySet="CustomerInventoryAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_CustomerInventoryAudit_InventoryItems" Association="PersonalLaundryModel.FK_CustomerInventoryAudit_InventoryItems">
      <End Role="InventoryItemType" EntitySet="InventoryItemTypes" />
      <End Role="CustomerInventoryAudit" EntitySet="CustomerInventoryAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_CustomerInventoryAudit_OperatorLogins" Association="PersonalLaundryModel.FK_CustomerInventoryAudit_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="CustomerInventoryAudit" EntitySet="CustomerInventoryAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_CustomerLogins_Customers" Association="PersonalLaundryModel.FK_CustomerLogins_Customers">
      <End Role="Customer" EntitySet="Customers" />
      <End Role="CustomerLogin" EntitySet="CustomerLogins" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadBags_CustomerLogins" Association="PersonalLaundryModel.FK_WorkloadBags_CustomerLogins">
      <End Role="CustomerLogin" EntitySet="CustomerLogins" />
      <End Role="CustomerWorkloadBag" EntitySet="CustomerWorkloadBags" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadItems_CustomerLogins" Association="PersonalLaundryModel.FK_WorkloadItems_CustomerLogins">
      <End Role="CustomerLogin" EntitySet="CustomerLogins" />
      <End Role="WorkloadItem" EntitySet="WorkloadItems" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadItemsAudit_CustomerLogins" Association="PersonalLaundryModel.FK_WorkloadItemsAudit_CustomerLogins">
      <End Role="CustomerLogin" EntitySet="CustomerLogins" />
      <End Role="WorkloadItemsAudit" EntitySet="WorkloadItemsAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_Workloads_CustomerLogins" Association="PersonalLaundryModel.FK_Workloads_CustomerLogins">
      <End Role="CustomerLogin" EntitySet="CustomerLogins" />
      <End Role="Workload" EntitySet="Workloads" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadsAudit_CustomerLogins" Association="PersonalLaundryModel.FK_WorkloadsAudit_CustomerLogins">
      <End Role="CustomerLogin" EntitySet="CustomerLogins" />
      <End Role="WorkloadsAudit" EntitySet="WorkloadsAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_Customers_OperatorLogins" Association="PersonalLaundryModel.FK_Customers_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="Customer" EntitySet="Customers" />
    </AssociationSet>
    <AssociationSet Name="FK_InventoryItems_Customers" Association="PersonalLaundryModel.FK_InventoryItems_Customers">
      <End Role="Customer" EntitySet="Customers" />
      <End Role="InventoryItem" EntitySet="InventoryItems" />
    </AssociationSet>
    <AssociationSet Name="FK_Invoices_Customers" Association="PersonalLaundryModel.FK_Invoices_Customers">
      <End Role="Customer" EntitySet="Customers" />
      <End Role="Invoice" EntitySet="Invoices" />
    </AssociationSet>
    <AssociationSet Name="FK_Workloads_Customers" Association="PersonalLaundryModel.FK_Workloads_Customers">
      <End Role="Customer" EntitySet="Customers" />
      <End Role="Workload" EntitySet="Workloads" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadsAudit_Customers" Association="PersonalLaundryModel.FK_WorkloadsAudit_Customers">
      <End Role="Customer" EntitySet="Customers" />
      <End Role="WorkloadsAudit" EntitySet="WorkloadsAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadBags_Workloads" Association="PersonalLaundryModel.FK_WorkloadBags_Workloads">
      <End Role="Workload" EntitySet="Workloads" />
      <End Role="CustomerWorkloadBag" EntitySet="CustomerWorkloadBags" />
    </AssociationSet>
    <AssociationSet Name="FK_Dispatches_DispatchStatus" Association="PersonalLaundryModel.FK_Dispatches_DispatchStatus">
      <End Role="DispatchStatu" EntitySet="DispatchStatus" />
      <End Role="Dispatch" EntitySet="Dispatches" />
    </AssociationSet>
    <AssociationSet Name="FK_DispatchItems_Dispatches" Association="PersonalLaundryModel.FK_DispatchItems_Dispatches">
      <End Role="Dispatch" EntitySet="Dispatches" />
      <End Role="DispatchPackage" EntitySet="DispatchPackages" />
    </AssociationSet>
    <AssociationSet Name="FK_DispatchItems_Packages" Association="PersonalLaundryModel.FK_DispatchItems_Packages">
      <End Role="Package" EntitySet="Packages" />
      <End Role="DispatchPackage" EntitySet="DispatchPackages" />
    </AssociationSet>
    <AssociationSet Name="FK_InventoryItems_InventoryItemTypes" Association="PersonalLaundryModel.FK_InventoryItems_InventoryItemTypes">
      <End Role="InventoryItemType" EntitySet="InventoryItemTypes" />
      <End Role="InventoryItem" EntitySet="InventoryItems" />
    </AssociationSet>
    <AssociationSet Name="FK_InventoryItemTypes_InventoryItemTypeCategories" Association="PersonalLaundryModel.FK_InventoryItemTypes_InventoryItemTypeCategories">
      <End Role="InventoryItemTypeCategory" EntitySet="InventoryItemTypeCategories" />
      <End Role="InventoryItemType" EntitySet="InventoryItemTypes" />
    </AssociationSet>
    <AssociationSet Name="FK_InventoryItemTypes_InventoryItemTypeSize" Association="PersonalLaundryModel.FK_InventoryItemTypes_InventoryItemTypeSize">
      <End Role="InventoryItemTypeSize" EntitySet="InventoryItemTypeSizes" />
      <End Role="InventoryItemType" EntitySet="InventoryItemTypes" />
    </AssociationSet>
    <AssociationSet Name="FK_InvoiceItems_InventoryItemTypes" Association="PersonalLaundryModel.FK_InvoiceItems_InventoryItemTypes">
      <End Role="InventoryItemType" EntitySet="InventoryItemTypes" />
      <End Role="InvoiceItem" EntitySet="InvoiceItems" />
    </AssociationSet>
    <AssociationSet Name="FK_InvoiceBags_Invoices" Association="PersonalLaundryModel.FK_InvoiceBags_Invoices">
      <End Role="Invoice" EntitySet="Invoices" />
      <End Role="InvoiceBag" EntitySet="InvoiceBags" />
    </AssociationSet>
    <AssociationSet Name="FK_InvoiceBags_OperatorLogins" Association="PersonalLaundryModel.FK_InvoiceBags_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="InvoiceBag" EntitySet="InvoiceBags" />
    </AssociationSet>
    <AssociationSet Name="FK_InvoiceItems_Invoices" Association="PersonalLaundryModel.FK_InvoiceItems_Invoices">
      <End Role="Invoice" EntitySet="Invoices" />
      <End Role="InvoiceItem" EntitySet="InvoiceItems" />
    </AssociationSet>
    <AssociationSet Name="FK_InvoiceItems_OperatorLogins" Association="PersonalLaundryModel.FK_InvoiceItems_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="InvoiceItem" EntitySet="InvoiceItems" />
    </AssociationSet>
    <AssociationSet Name="FK_Packages_InvoiceItems" Association="PersonalLaundryModel.FK_Packages_InvoiceItems">
      <End Role="InvoiceItem" EntitySet="InvoiceItems" />
      <End Role="Package" EntitySet="Packages" />
    </AssociationSet>
    <AssociationSet Name="FK_Invoices_Workloads" Association="PersonalLaundryModel.FK_Invoices_Workloads">
      <End Role="Workload" EntitySet="Workloads" />
      <End Role="Invoice" EntitySet="Invoices" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadItems_OperatorLogins" Association="PersonalLaundryModel.FK_WorkloadItems_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="WorkloadItem" EntitySet="WorkloadItems" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadItemsAudit_OperatorLogins" Association="PersonalLaundryModel.FK_WorkloadItemsAudit_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="WorkloadItemsAudit" EntitySet="WorkloadItemsAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_Workloads_OperatorLogins" Association="PersonalLaundryModel.FK_Workloads_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="Workload" EntitySet="Workloads" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadsAudit_OperatorLogins" Association="PersonalLaundryModel.FK_WorkloadsAudit_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="WorkloadsAudit" EntitySet="WorkloadsAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadItems_Workloads" Association="PersonalLaundryModel.FK_WorkloadItems_Workloads">
      <End Role="Workload" EntitySet="Workloads" />
      <End Role="WorkloadItem" EntitySet="WorkloadItems" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadItemsAudit_Workloads" Association="PersonalLaundryModel.FK_WorkloadItemsAudit_Workloads">
      <End Role="Workload" EntitySet="Workloads" />
      <End Role="WorkloadItemsAudit" EntitySet="WorkloadItemsAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_Workloads_WorkloadStatus" Association="PersonalLaundryModel.FK_Workloads_WorkloadStatus">
      <End Role="WorkloadStatu" EntitySet="WorkloadStatuses" />
      <End Role="Workload" EntitySet="Workloads" />
    </AssociationSet>
    <AssociationSet Name="FK_Workloads_WorkloadTypes" Association="PersonalLaundryModel.FK_Workloads_WorkloadTypes">
      <End Role="WorkloadType" EntitySet="WorkloadTypes" />
      <End Role="Workload" EntitySet="Workloads" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadsAudit_WorkloadStatus" Association="PersonalLaundryModel.FK_WorkloadsAudit_WorkloadStatus">
      <End Role="WorkloadStatu" EntitySet="WorkloadStatuses" />
      <End Role="WorkloadsAudit" EntitySet="WorkloadsAudits" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkloadsAudit_WorkloadTypes" Association="PersonalLaundryModel.FK_WorkloadsAudit_WorkloadTypes">
      <End Role="WorkloadType" EntitySet="WorkloadTypes" />
      <End Role="WorkloadsAudit" EntitySet="WorkloadsAudits" />
    </AssociationSet>
    <FunctionImport Name="AcceptCustomerBag" ReturnType="Collection(PersonalLaundryModel.AcceptCustomerBag_Result)">
      <Parameter Name="CustomerId" Mode="In" Type="Int32" />
      <Parameter Name="UniqueReference" Mode="In" Type="String" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="CreateDispatch" ReturnType="Collection(PersonalLaundryModel.CreateDispatch_Result)">
      <Parameter Name="Packages" Mode="In" Type="String" />
      <Parameter Name="BagSeal" Mode="In" Type="String" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="CreatePackage" ReturnType="Collection(PersonalLaundryModel.CreatePackage_Result)">
      <Parameter Name="InvoiceItemId" Mode="In" Type="Int32" />
      <Parameter Name="ItemCount" Mode="In" Type="Int32" />
      <Parameter Name="ItemCountStain" Mode="In" Type="Int32" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="CreateWorkload" ReturnType="Collection(PersonalLaundryModel.CreateWorkload_Result)">
      <Parameter Name="CustomerLoginId" Mode="In" Type="Int32" />
      <Parameter Name="WorkloadTypeId" Mode="In" Type="Int32" />
      <Parameter Name="WorkloadItems" Mode="In" Type="String" />
      <Parameter Name="Reference" Mode="In" Type="String" />
      <Parameter Name="TotalBags" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="FinishCounting" ReturnType="Collection(PersonalLaundryModel.FinishCounting_Result)">
      <Parameter Name="WorkloadId" Mode="In" Type="Int32" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GenerateInvoiceFromWorkloadCounts" ReturnType="Collection(PersonalLaundryModel.GenerateInvoiceFromWorkloadCounts_Result)">
      <Parameter Name="WorkloadId" Mode="In" Type="Int32" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetCustomerInventory" ReturnType="Collection(PersonalLaundryModel.GetCustomerInventory_Result)">
      <Parameter Name="CustomerId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetCustomerInventoryByCustomerIdWorkloadId" ReturnType="Collection(PersonalLaundryModel.GetCustomerInventoryByCustomerIdWorkloadId_Result)">
      <Parameter Name="CustomerId" Mode="In" Type="Int32" />
      <Parameter Name="WorkloadId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetCustomerInventoryForWorkload" ReturnType="Collection(PersonalLaundryModel.GetCustomerInventoryForWorkload_Result)">
      <Parameter Name="CustomerId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetCustomerLoginFromGuid" ReturnType="Collection(PersonalLaundryModel.GetCustomerLoginFromGuid_Result)">
      <Parameter Name="Guid" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="GetInvoiceForPrinter" ReturnType="Collection(PersonalLaundryModel.GetInvoiceForPrinter_Result)">
      <Parameter Name="InvoiceId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetWorkloadInventory" ReturnType="Collection(PersonalLaundryModel.GetWorkloadInventory_Result)">
      <Parameter Name="WorkloadId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetWorkloadInventoryForInvoice" ReturnType="Collection(PersonalLaundryModel.WorkloadInventory_Result)">
      <Parameter Name="InvoiceId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="LoginCustomer" ReturnType="Collection(PersonalLaundryModel.LoginCustomer_Result)">
      <Parameter Name="EmailAddress" Mode="In" Type="String" />
      <Parameter Name="Password" Mode="In" Type="String" />
      <Parameter Name="IPAddress" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="LoginOperator" ReturnType="Collection(PersonalLaundryModel.LoginOperator_Result)">
      <Parameter Name="Username" Mode="In" Type="String" />
      <Parameter Name="Password" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="PLSendMail">
      <Parameter Name="server" Mode="In" Type="String" />
      <Parameter Name="from" Mode="In" Type="String" />
      <Parameter Name="recipients" Mode="In" Type="String" />
      <Parameter Name="subject" Mode="In" Type="String" />
      <Parameter Name="body" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="SaveFingerprint" ReturnType="Collection(PersonalLaundryModel.SaveFingerprint_Result)">
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
      <Parameter Name="Fingerprint" Mode="In" Type="Binary" />
    </FunctionImport>
    <FunctionImport Name="Split" IsComposable="true" ReturnType="Collection(String)">
      <Parameter Name="S" Mode="In" Type="String" />
      <Parameter Name="Delimiter" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="UpdateCustomerInventory" ReturnType="Collection(PersonalLaundryModel.UpdateCustomerInventory_Result)">
      <Parameter Name="CustomerId" Mode="In" Type="Int32" />
      <Parameter Name="InventoryItemTypeId" Mode="In" Type="Int32" />
      <Parameter Name="CostGeneralWash" Mode="In" Type="Int32" />
      <Parameter Name="CostRepeatWash" Mode="In" Type="Int32" />
      <Parameter Name="CostStainWash" Mode="In" Type="Int32" />
      <Parameter Name="CostRewashWash" Mode="In" Type="Int32" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="UpdateCustomerLogin" ReturnType="Collection(PersonalLaundryModel.UpdateCustomerLogin_Result)">
      <Parameter Name="CustomerId" Mode="In" Type="Int32" />
      <Parameter Name="EmailAddress" Mode="In" Type="String" />
      <Parameter Name="Password" Mode="In" Type="String" />
      <Parameter Name="IsActive" Mode="In" Type="Boolean" />
      <Parameter Name="IsLockedOut" Mode="In" Type="Boolean" />
    </FunctionImport>
    <FunctionImport Name="UpdateCustomerWorkloadBag" ReturnType="Collection(PersonalLaundryModel.UpdateCustomerWorkloadBag_Result)">
      <Parameter Name="CustomerLoginId" Mode="In" Type="Int32" />
      <Parameter Name="WorkloadId" Mode="In" Type="Int32" />
      <Parameter Name="UniqueReference" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="UpdateInventoryItemType">
      <Parameter Name="Category" Mode="In" Type="String" />
      <Parameter Name="ItemType" Mode="In" Type="String" />
      <Parameter Name="Size" Mode="In" Type="String" />
      <Parameter Name="InventoryItemTypeId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="UpdateInvoiceItemCount" ReturnType="Collection(PersonalLaundryModel.UpdateInvoiceItemCount_Result)">
      <Parameter Name="InvoiceId" Mode="In" Type="Int32" />
      <Parameter Name="InventoryItemTypeId" Mode="In" Type="Int32" />
      <Parameter Name="Count" Mode="In" Type="Int32" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="UpdateOperatorLogin" ReturnType="Collection(PersonalLaundryModel.UpdateOperatorLogin_Result)">
      <Parameter Name="Username" Mode="In" Type="String" />
      <Parameter Name="Password" Mode="In" Type="String" />
      <Parameter Name="OperatorRoleId" Mode="In" Type="Int32" />
      <Parameter Name="OperatorShift" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="UpdateWorkloadItem" ReturnType="Collection(PersonalLaundryModel.UpdateWorkloadItem_Result)">
      <Parameter Name="WorkloadId" Mode="In" Type="Int32" />
      <Parameter Name="CustomerInventoryId" Mode="In" Type="Int32" />
      <Parameter Name="ItemCount" Mode="In" Type="Int32" />
      <Parameter Name="CustomerLoginId" Mode="In" Type="Int32" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <AssociationSet Name="FK_DriverLog_Customers" Association="PersonalLaundryModel.FK_DriverLog_Customers">
      <End Role="Customer" EntitySet="Customers" />
      <End Role="DriverLog" EntitySet="DriverLogs" />
    </AssociationSet>
    <AssociationSet Name="FK_DriverLog_DriverActions" Association="PersonalLaundryModel.FK_DriverLog_DriverActions">
      <End Role="DriverAction" EntitySet="DriverActions" />
      <End Role="DriverLog" EntitySet="DriverLogs" />
    </AssociationSet>
    <AssociationSet Name="FK_DriverLog_Locations" Association="PersonalLaundryModel.FK_DriverLog_Locations">
      <End Role="Location" EntitySet="Locations" />
      <End Role="DriverLog" EntitySet="DriverLogs" />
    </AssociationSet>
    <AssociationSet Name="FK_DriverLog_OperatorLogins" Association="PersonalLaundryModel.FK_DriverLog_OperatorLogins">
      <End Role="OperatorLogin" EntitySet="OperatorLogins" />
      <End Role="DriverLog" EntitySet="DriverLogs" />
    </AssociationSet>
    <EntitySet Name="vwInvoicesReadyToPrints" EntityType="PersonalLaundryModel.vwInvoicesReadyToPrint" />
    <FunctionImport Name="GetWorkloadInventoryForDispatch" ReturnType="Collection(PersonalLaundryModel.WorkloadInventory_Result)">
      <Parameter Name="DispatchId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetCustomerInvoiceById" ReturnType="Collection(PersonalLaundryModel.GetCustomerInvoiceById_Result)">
      <Parameter Name="CustomerId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="UpdateInvoiceItemBadCount" ReturnType="Collection(PersonalLaundryModel.UpdateInvoiceItemBadCount_Result)">
      <Parameter Name="InvoiceId" Mode="In" Type="Int32" />
      <Parameter Name="InventoryItemTypeId" Mode="In" Type="Int32" />
      <Parameter Name="Count" Mode="In" Type="Int32" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <EntitySet Name="vwInvoiceItemCounts" EntityType="PersonalLaundryModel.vwInvoiceItemCount" />
    <EntitySet Name="sysdiagrams" EntityType="PersonalLaundryModel.sysdiagram" />
    <EntitySet Name="vwDispatchesOutForDeliveries" EntityType="PersonalLaundryModel.vwDispatchesOutForDelivery" />
    <FunctionImport Name="GetWorkloadInventoryForInvoice_backup_20140820" ReturnType="Collection(PersonalLaundryModel.GetWorkloadInventoryForInvoice_backup_20140820_Result)">
      <Parameter Name="InvoiceId" Mode="In" Type="Int32" />
    </FunctionImport>
    <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">
      <Parameter Name="diagramname" Mode="In" Type="String" />
      <Parameter Name="owner_id" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="sp_helpdiagrams">
      <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="vwCustomerBagsReadyToDispatches" EntityType="PersonalLaundryModel.vwCustomerBagsReadyToDispatch" />
    <EntitySet Name="vwInvoiceCountsCondemneds" EntityType="PersonalLaundryModel.vwInvoiceCountsCondemned" />
    <EntitySet Name="vwInvoicesReadyToPrint2" EntityType="PersonalLaundryModel.vwInvoicesReadyToPrint2" />
    <EntitySet Name="vwDeliveryNoteCategoriesByBagSeal2" EntityType="PersonalLaundryModel.vwDeliveryNoteCategoriesByBagSeal2" />
    <FunctionImport Name="SendMail">
      <Parameter Name="p_strSubject" Mode="In" Type="String" />
      <Parameter Name="p_strRecipients" Mode="In" Type="String" />
      <Parameter Name="p_from_address" Mode="In" Type="String" />
      <Parameter Name="p_strBody" Mode="In" Type="String" />
      <Parameter Name="p_cc" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="GetCustomerPricingPercentages" ReturnType="Collection(PersonalLaundryModel.GetCustomerPricingPercentages_Result)" />
    <FunctionImport Name="UpdateCustomerInventoryByPercentages">
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetWorkloadInventoryForDispatches" ReturnType="Collection(PersonalLaundryModel.GetWorkloadInventoryForDispatches_Result)">
      <Parameter Name="DeliveryId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="UpdateDispatchDeliveryId">
      <Parameter Name="DispatchIds" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="UpdateDeliveryId" ReturnType="Collection(PersonalLaundryModel.UpdateDeliveryId_Result)">
      <Parameter Name="DispatchIds" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="UpdateDispatchDelivery" ReturnType="Collection(PersonalLaundryModel.UpdateDispatchDelivery_Result)">
      <Parameter Name="DispatchIds" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="UpdateDispatchDelivery1" ReturnType="Collection(PersonalLaundryModel.UpdateDispatchDelivery_Result)">
      <Parameter Name="DispatchIds" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="UpdateDispatchDelivery2" ReturnType="Collection(PersonalLaundryModel.UpdateDispatchDelivery_Result)">
      <Parameter Name="DispatchIds" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="GetWorkloadInventoryForDispatches2016" ReturnType="Collection(PersonalLaundryModel.GetWorkloadInventoryForDispatches2016_Result)">
      <Parameter Name="DispatchId" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="UpdateCondemnedPrintedForDispatches">
      <Parameter Name="DispatchId" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="GetDeliveryNoteCategoriesByBagSeal" ReturnType="Collection(PersonalLaundryModel.GetDeliveryNoteCategoriesByBagSeal_Result)">
      <Parameter Name="BagIds" Mode="In" Type="String" />
    </FunctionImport>
    <EntitySet Name="vwDispatchesReadyToPrints" EntityType="PersonalLaundryModel.vwDispatchesReadyToPrint" />
    <FunctionImport Name="GetWorkloadInventoryForDelivery" ReturnType="Collection(PersonalLaundryModel.GetWorkloadInventoryForDelivery_Result)">
      <Parameter Name="DeliveryId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetDispatchesReadyToPrint" ReturnType="Collection(PersonalLaundryModel.GetDispatchesReadyToPrint_Result)">
      <Parameter Name="Customerid" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetDispatchesReadyToExport" ReturnType="Collection(PersonalLaundryModel.GetDispatchesReadyToExport_Result)">
      <Parameter Name="startDate" Mode="In" Type="String" />
      <Parameter Name="endDate" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="GetCustomerEmail" ReturnType="Collection(String)">
      <Parameter Name="workloadId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="CheckCustomerInventoryCost" ReturnType="Collection(Int32)">
      <Parameter Name="itemType" Type="String" Mode="In" />
      <Parameter Name="workloadid" Type="Int32" Mode="In" />
    </FunctionImport>
    <FunctionImport Name="CheckCustomerInventoryItemCost" ReturnType="Collection(Int32)">
      <Parameter Name="itemType" Mode="In" Type="String" />
      <Parameter Name="itemTypeCategory" Mode="In" Type="String" />
      <Parameter Name="workloadid" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="CheckCustomerInventoryItemSizeCost" ReturnType="Collection(Int32)">
      <Parameter Name="itemTypeId" Mode="In" Type="Int32" />
      <Parameter Name="workloadid" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="GetCustomerCCEmail" ReturnType="Collection(String)">
      <Parameter Name="workloadId" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="UpdateCondemnedPrintedForDelivery">
      <Parameter Name="DeliveryId" Mode="In" Type="Int32" />
      <Parameter Name="DispatchId" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="GetDuplicatePrelists" ReturnType="Collection(PersonalLaundryModel.GetDuplicatePrelists_Result)">
      <Parameter Name="startDate" Mode="In" Type="String" />
      <Parameter Name="endDate" Mode="In" Type="String" />
    </FunctionImport>
    <EntitySet Name="DispatchOperators" EntityType="PersonalLaundryModel.DispatchOperator" />
    <FunctionImport Name="CreateDeliveryOperator">
      <Parameter Name="DeliveryId" Mode="In" Type="Int32" />
      <Parameter Name="OperatorLoginId" Mode="In" Type="Int32" />
      <Parameter Name="DeviceName" Mode="In" Type="String" />
      <Parameter Name="PosPrinter" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="rptOutstandingOrders" ReturnType="Collection(String)">
      <Parameter Name="p_CustomerID" Mode="In" Type="Int32" />
    </FunctionImport>
    <FunctionImport Name="rptOutstandingOrders_Items" ReturnType="Collection(PersonalLaundryModel.rptOutstandingOrders_Items_Result)">
      <Parameter Name="p_CustomerID" Mode="In" Type="Int32" />
      <Parameter Name="p_StartDate" Mode="In" Type="String" />
      <Parameter Name="p_EndDate" Mode="In" Type="String" />
    </FunctionImport>
    <EntitySet Name="VATs" EntityType="PersonalLaundryModel.VAT" />
    <FunctionImport Name="rptBagReconDeliveries" ReturnType="Collection(PersonalLaundryModel.rptBagReconDeliveries_Result)">
      <Parameter Name="p_CustomerID" Mode="In" Type="Int32" />
      <Parameter Name="p_StartDate" Mode="In" Type="String" />
      <Parameter Name="p_EndDate" Mode="In" Type="String" />
    </FunctionImport>
    <FunctionImport Name="rptBagReconPickups" ReturnType="Collection(PersonalLaundryModel.rptBagReconPickups_Result)">
      <Parameter Name="p_CustomerID" Mode="In" Type="Int32" />
      <Parameter Name="p_StartDate" Mode="In" Type="String" />
      <Parameter Name="p_EndDate" Mode="In" Type="String" />
    </FunctionImport>
  </EntityContainer>
  <EntityType Name="Dispatch">
    <Key>
      <PropertyRef Name="DispatchId" />
    </Key>
    <Property Name="DispatchId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="BagSeal" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="DispatchStatusId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Invoice" Relationship="PersonalLaundryModel.FK_Dispatches_Invoices" FromRole="Dispatch" ToRole="Invoice" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_Dispatches_OperatorLogins" FromRole="Dispatch" ToRole="OperatorLogin" />
    <NavigationProperty Name="DispatchStatu" Relationship="PersonalLaundryModel.FK_Dispatches_DispatchStatus" FromRole="Dispatch" ToRole="DispatchStatu" />
    <NavigationProperty Name="DispatchPackages" Relationship="PersonalLaundryModel.FK_DispatchItems_Dispatches" FromRole="Dispatch" ToRole="DispatchPackage" />
    <Property Name="DeliveryId" Type="Int32" />
    <Property Name="DateDelivered" Type="DateTime" Precision="3" />
  </EntityType>
  <EntityType Name="Invoice">
    <Key>
      <PropertyRef Name="InvoiceId" />
    </Key>
    <Property Name="InvoiceId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="InvoiceStatusId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Dispatches" Relationship="PersonalLaundryModel.FK_Dispatches_Invoices" FromRole="Invoice" ToRole="Dispatch" />
    <NavigationProperty Name="InvoiceStatu" Relationship="PersonalLaundryModel.FK_Invoices_InvoiceStatus" FromRole="Invoice" ToRole="InvoiceStatu" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_Invoices_OperatorLogins" FromRole="Invoice" ToRole="OperatorLogin" />
    <NavigationProperty Name="Customer" Relationship="PersonalLaundryModel.FK_Invoices_Customers" FromRole="Invoice" ToRole="Customer" />
    <NavigationProperty Name="InvoiceBags" Relationship="PersonalLaundryModel.FK_InvoiceBags_Invoices" FromRole="Invoice" ToRole="InvoiceBag" />
    <NavigationProperty Name="InvoiceItems" Relationship="PersonalLaundryModel.FK_InvoiceItems_Invoices" FromRole="Invoice" ToRole="InvoiceItem" />
    <NavigationProperty Name="Workload" Relationship="PersonalLaundryModel.FK_Invoices_Workloads" FromRole="Invoice" ToRole="Workload" />
    <Property Name="Printed" Type="Boolean" />
  </EntityType>
  <EntityType Name="InvoiceStatu">
    <Key>
      <PropertyRef Name="InvoiceStatusId" />
    </Key>
    <Property Name="InvoiceStatusId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Status" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Invoices" Relationship="PersonalLaundryModel.FK_Invoices_InvoiceStatus" FromRole="InvoiceStatu" ToRole="Invoice" />
  </EntityType>
  <EntityType Name="Location">
    <Key>
      <PropertyRef Name="LocationId" />
    </Key>
    <Property Name="LocationId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Address" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
    <Property Name="Lat" Type="Double" Nullable="false" />
    <Property Name="Lng" Type="Double" Nullable="false" />
    <NavigationProperty Name="DriverLogs" Relationship="PersonalLaundryModel.FK_DriverLog_Locations" FromRole="Location" ToRole="DriverLog" />
  </EntityType>
  <EntityType Name="OperatorLogin">
    <Key>
      <PropertyRef Name="OperatorLoginId" />
    </Key>
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Username" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Password" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="OperatorRoleId" Type="Int32" Nullable="false" />
    <Property Name="Fingerprint" Type="Binary" MaxLength="Max" FixedLength="false" />
    <NavigationProperty Name="Dispatches" Relationship="PersonalLaundryModel.FK_Dispatches_OperatorLogins" FromRole="OperatorLogin" ToRole="Dispatch" />
    <NavigationProperty Name="Invoices" Relationship="PersonalLaundryModel.FK_Invoices_OperatorLogins" FromRole="OperatorLogin" ToRole="Invoice" />
    <NavigationProperty Name="OperatorRole" Relationship="PersonalLaundryModel.FK_OperatorLogins_OperatorRoles" FromRole="OperatorLogin" ToRole="OperatorRole" />
    <NavigationProperty Name="Packages" Relationship="PersonalLaundryModel.FK_Packages_OperatorLogins" FromRole="OperatorLogin" ToRole="Package" />
    <NavigationProperty Name="BagReferences" Relationship="PersonalLaundryModel.FK_BagReferences_OperatorLogins" FromRole="OperatorLogin" ToRole="BagReference" />
    <NavigationProperty Name="CustomerInventories" Relationship="PersonalLaundryModel.FK_CustomerInventory_OperatorLogins" FromRole="OperatorLogin" ToRole="CustomerInventory" />
    <NavigationProperty Name="CustomerInventoryAudits" Relationship="PersonalLaundryModel.FK_CustomerInventoryAudit_OperatorLogins" FromRole="OperatorLogin" ToRole="CustomerInventoryAudit" />
    <NavigationProperty Name="Customers" Relationship="PersonalLaundryModel.FK_Customers_OperatorLogins" FromRole="OperatorLogin" ToRole="Customer" />
    <NavigationProperty Name="InvoiceBags" Relationship="PersonalLaundryModel.FK_InvoiceBags_OperatorLogins" FromRole="OperatorLogin" ToRole="InvoiceBag" />
    <NavigationProperty Name="InvoiceItems" Relationship="PersonalLaundryModel.FK_InvoiceItems_OperatorLogins" FromRole="OperatorLogin" ToRole="InvoiceItem" />
    <NavigationProperty Name="WorkloadItems" Relationship="PersonalLaundryModel.FK_WorkloadItems_OperatorLogins" FromRole="OperatorLogin" ToRole="WorkloadItem" />
    <NavigationProperty Name="WorkloadItemsAudits" Relationship="PersonalLaundryModel.FK_WorkloadItemsAudit_OperatorLogins" FromRole="OperatorLogin" ToRole="WorkloadItemsAudit" />
    <NavigationProperty Name="Workloads" Relationship="PersonalLaundryModel.FK_Workloads_OperatorLogins" FromRole="OperatorLogin" ToRole="Workload" />
    <NavigationProperty Name="WorkloadsAudits" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_OperatorLogins" FromRole="OperatorLogin" ToRole="WorkloadsAudit" />
    <NavigationProperty Name="DriverLogs" Relationship="PersonalLaundryModel.FK_DriverLog_OperatorLogins" FromRole="OperatorLogin" ToRole="DriverLog" />
    <Property Name="OperatorShift" Type="String" Nullable="false" MaxLength="2" FixedLength="false" Unicode="true" />
  </EntityType>
  <EntityType Name="OperatorRole">
    <Key>
      <PropertyRef Name="OperatorRoleId" />
    </Key>
    <Property Name="OperatorRoleId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="RoleName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="CanLogin" Type="Boolean" Nullable="false" />
    <NavigationProperty Name="OperatorLogins" Relationship="PersonalLaundryModel.FK_OperatorLogins_OperatorRoles" FromRole="OperatorRole" ToRole="OperatorLogin" />
  </EntityType>
  <EntityType Name="Package">
    <Key>
      <PropertyRef Name="PackageId" />
    </Key>
    <Property Name="PackageId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="InvoiceItemId" Type="Int32" Nullable="false" />
    <Property Name="ItemCount" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_Packages_OperatorLogins" FromRole="Package" ToRole="OperatorLogin" />
    <NavigationProperty Name="DispatchPackages" Relationship="PersonalLaundryModel.FK_DispatchItems_Packages" FromRole="Package" ToRole="DispatchPackage" />
    <NavigationProperty Name="InvoiceItem" Relationship="PersonalLaundryModel.FK_Packages_InvoiceItems" FromRole="Package" ToRole="InvoiceItem" />
    <Property Name="ItemCountStain" Type="Int32" />
  </EntityType>
  <Association Name="FK_Dispatches_Invoices">
    <End Type="PersonalLaundryModel.Invoice" Role="Invoice" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Dispatch" Role="Dispatch" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Invoice">
        <PropertyRef Name="InvoiceId" />
      </Principal>
      <Dependent Role="Dispatch">
        <PropertyRef Name="InvoiceId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Dispatches_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Dispatch" Role="Dispatch" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="Dispatch">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Invoices_InvoiceStatus">
    <End Type="PersonalLaundryModel.InvoiceStatu" Role="InvoiceStatu" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Invoice" Role="Invoice" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="InvoiceStatu">
        <PropertyRef Name="InvoiceStatusId" />
      </Principal>
      <Dependent Role="Invoice">
        <PropertyRef Name="InvoiceStatusId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Invoices_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Invoice" Role="Invoice" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="Invoice">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_OperatorLogins_OperatorRoles">
    <End Type="PersonalLaundryModel.OperatorRole" Role="OperatorRole" Multiplicity="1" />
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorRole">
        <PropertyRef Name="OperatorRoleId" />
      </Principal>
      <Dependent Role="OperatorLogin">
        <PropertyRef Name="OperatorRoleId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Packages_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Package" Role="Package" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="Package">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <EntityType Name="Action">
    <Key>
      <PropertyRef Name="ActionId" />
    </Key>
    <Property Name="ActionId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="ActionDetails" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="CustomerLoginLogs" Relationship="PersonalLaundryModel.FK_CustomerLoginLog_Actions" FromRole="Action" ToRole="CustomerLoginLog" />
  </EntityType>
  <EntityType Name="BagReference">
    <Key>
      <PropertyRef Name="BagReferenceId" />
    </Key>
    <Property Name="BagReferenceId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="UniqueReference" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_BagReferences_OperatorLogins" FromRole="BagReference" ToRole="OperatorLogin" />
    <NavigationProperty Name="InvoiceBags" Relationship="PersonalLaundryModel.FK_InvoiceBags_BagReferences" FromRole="BagReference" ToRole="InvoiceBag" />
  </EntityType>
  <EntityType Name="BillingProfile">
    <Key>
      <PropertyRef Name="BillingProfileId" />
    </Key>
    <Property Name="BillingProfileId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="ProfileName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="IncludeRewashInInvoice" Type="Boolean" Nullable="false" />
    <NavigationProperty Name="Customers" Relationship="PersonalLaundryModel.FK_Customers_BillingProfiles" FromRole="BillingProfile" ToRole="Customer" />
  </EntityType>
  <EntityType Name="CustomerInventory">
    <Key>
      <PropertyRef Name="CustomerInventoryId" />
    </Key>
    <Property Name="CustomerInventoryId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="InventoryItemTypeId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="CostGeneralWash" Type="Int32" />
    <Property Name="CostRepeatWash" Type="Int32" />
    <Property Name="CostStainWash" Type="Int32" />
    <NavigationProperty Name="Customer" Relationship="PersonalLaundryModel.FK_CustomerInventory_Customer" FromRole="CustomerInventory" ToRole="Customer" />
    <NavigationProperty Name="InventoryItemType" Relationship="PersonalLaundryModel.FK_CustomerInventory_InventoryItemTypes" FromRole="CustomerInventory" ToRole="InventoryItemType" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_CustomerInventory_OperatorLogins" FromRole="CustomerInventory" ToRole="OperatorLogin" />
    <NavigationProperty Name="WorkloadItems" Relationship="PersonalLaundryModel.FK_WorkloadItems_CustomerInventory" FromRole="CustomerInventory" ToRole="WorkloadItem" />
    <NavigationProperty Name="WorkloadItemsAudits" Relationship="PersonalLaundryModel.FK_WorkloadItemsAudit_CustomerInventory" FromRole="CustomerInventory" ToRole="WorkloadItemsAudit" />
    <Property Name="CostRewashWash" Type="Int32" />
  </EntityType>
  <EntityType Name="CustomerInventoryAudit">
    <Key>
      <PropertyRef Name="CustomerInventoryAuditId" />
    </Key>
    <Property Name="CustomerInventoryAuditId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="InventoryItemTypeId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="CostGeneralWash" Type="Int32" />
    <Property Name="CostRepeatWash" Type="Int32" />
    <Property Name="CostStainWash" Type="Int32" />
    <NavigationProperty Name="Customer" Relationship="PersonalLaundryModel.FK_CustomerInventoryAudit_Customers" FromRole="CustomerInventoryAudit" ToRole="Customer" />
    <NavigationProperty Name="InventoryItemType" Relationship="PersonalLaundryModel.FK_CustomerInventoryAudit_InventoryItems" FromRole="CustomerInventoryAudit" ToRole="InventoryItemType" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_CustomerInventoryAudit_OperatorLogins" FromRole="CustomerInventoryAudit" ToRole="OperatorLogin" />
  </EntityType>
  <EntityType Name="CustomerLoginLog">
    <Key>
      <PropertyRef Name="CustomerLoginLogId" />
    </Key>
    <Property Name="CustomerLoginLogId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="CustomerLoginId" Type="Int32" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="IPAddress" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
    <Property Name="ActionId" Type="Int32" Nullable="false" />
    <Property Name="ActionDetails" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Action" Relationship="PersonalLaundryModel.FK_CustomerLoginLog_Actions" FromRole="CustomerLoginLog" ToRole="Action" />
  </EntityType>
  <EntityType Name="CustomerLogin">
    <Key>
      <PropertyRef Name="CustomerLoginId" />
    </Key>
    <Property Name="CustomerLoginId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="GUID" Type="Guid" Nullable="false" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="EmailAddress" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="Password" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="IsActive" Type="Boolean" Nullable="false" />
    <Property Name="IsLockedOut" Type="Boolean" Nullable="false" />
    <NavigationProperty Name="Customer" Relationship="PersonalLaundryModel.FK_CustomerLogins_Customers" FromRole="CustomerLogin" ToRole="Customer" />
    <NavigationProperty Name="CustomerWorkloadBags" Relationship="PersonalLaundryModel.FK_WorkloadBags_CustomerLogins" FromRole="CustomerLogin" ToRole="CustomerWorkloadBag" />
    <NavigationProperty Name="WorkloadItems" Relationship="PersonalLaundryModel.FK_WorkloadItems_CustomerLogins" FromRole="CustomerLogin" ToRole="WorkloadItem" />
    <NavigationProperty Name="WorkloadItemsAudits" Relationship="PersonalLaundryModel.FK_WorkloadItemsAudit_CustomerLogins" FromRole="CustomerLogin" ToRole="WorkloadItemsAudit" />
    <NavigationProperty Name="Workloads" Relationship="PersonalLaundryModel.FK_Workloads_CustomerLogins" FromRole="CustomerLogin" ToRole="Workload" />
    <NavigationProperty Name="WorkloadsAudits" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_CustomerLogins" FromRole="CustomerLogin" ToRole="WorkloadsAudit" />
  </EntityType>
  <EntityType Name="Customer">
    <Key>
      <PropertyRef Name="CustomerId" />
    </Key>
    <Property Name="CustomerId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Name" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="BillingProfileId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="EmailAddress" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="ContactName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="AddressLine1" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="AddressLine2" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="AddressCity" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="AddressPostCode" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="VATNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="BillingProfile" Relationship="PersonalLaundryModel.FK_Customers_BillingProfiles" FromRole="Customer" ToRole="BillingProfile" />
    <NavigationProperty Name="CustomerInventories" Relationship="PersonalLaundryModel.FK_CustomerInventory_Customer" FromRole="Customer" ToRole="CustomerInventory" />
    <NavigationProperty Name="CustomerInventoryAudits" Relationship="PersonalLaundryModel.FK_CustomerInventoryAudit_Customers" FromRole="Customer" ToRole="CustomerInventoryAudit" />
    <NavigationProperty Name="CustomerLogins" Relationship="PersonalLaundryModel.FK_CustomerLogins_Customers" FromRole="Customer" ToRole="CustomerLogin" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_Customers_OperatorLogins" FromRole="Customer" ToRole="OperatorLogin" />
    <NavigationProperty Name="InventoryItems" Relationship="PersonalLaundryModel.FK_InventoryItems_Customers" FromRole="Customer" ToRole="InventoryItem" />
    <NavigationProperty Name="Invoices" Relationship="PersonalLaundryModel.FK_Invoices_Customers" FromRole="Customer" ToRole="Invoice" />
    <NavigationProperty Name="Workloads" Relationship="PersonalLaundryModel.FK_Workloads_Customers" FromRole="Customer" ToRole="Workload" />
    <NavigationProperty Name="WorkloadsAudits" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_Customers" FromRole="Customer" ToRole="WorkloadsAudit" />
    <NavigationProperty Name="DriverLogs" Relationship="PersonalLaundryModel.FK_DriverLog_Customers" FromRole="Customer" ToRole="DriverLog" />
    <Property Name="PastelCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="StainExpressPercentage" Type="Double" Nullable="false" />
    <Property Name="PriceIncreasePercentage" Type="Double" Nullable="false" />
    <Property Name="EmailAddress2" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="EmailAddress3" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="DoublePrintBagLabel" Type="Boolean" Nullable="false" />
  </EntityType>
  <EntityType Name="CustomerWorkloadBag">
    <Key>
      <PropertyRef Name="WorkloadBagId" />
    </Key>
    <Property Name="WorkloadBagId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="UniqueReference" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="CustomerLoginId" Type="Int32" Nullable="false" />
    <Property Name="TimeReceived" Type="DateTime" Precision="3" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="CustomerLogin" Relationship="PersonalLaundryModel.FK_WorkloadBags_CustomerLogins" FromRole="CustomerWorkloadBag" ToRole="CustomerLogin" />
    <NavigationProperty Name="Workload" Relationship="PersonalLaundryModel.FK_WorkloadBags_Workloads" FromRole="CustomerWorkloadBag" ToRole="Workload" />
  </EntityType>
  <EntityType Name="DispatchPackage">
    <Key>
      <PropertyRef Name="DispatchItemId" />
    </Key>
    <Property Name="DispatchItemId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="DispatchId" Type="Int32" Nullable="false" />
    <Property Name="PackageId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Dispatch" Relationship="PersonalLaundryModel.FK_DispatchItems_Dispatches" FromRole="DispatchPackage" ToRole="Dispatch" />
    <NavigationProperty Name="Package" Relationship="PersonalLaundryModel.FK_DispatchItems_Packages" FromRole="DispatchPackage" ToRole="Package" />
  </EntityType>
  <EntityType Name="DispatchStatu">
    <Key>
      <PropertyRef Name="DispatchStatusId" />
    </Key>
    <Property Name="DispatchStatusId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Status" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Dispatches" Relationship="PersonalLaundryModel.FK_Dispatches_DispatchStatus" FromRole="DispatchStatu" ToRole="Dispatch" />
  </EntityType>
  <EntityType Name="InventoryItem">
    <Key>
      <PropertyRef Name="InventoryItemId" />
    </Key>
    <Property Name="InventoryItemId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="InventoryItemTypeId" Type="Int32" Nullable="false" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="UniqueId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Customer" Relationship="PersonalLaundryModel.FK_InventoryItems_Customers" FromRole="InventoryItem" ToRole="Customer" />
    <NavigationProperty Name="InventoryItemType" Relationship="PersonalLaundryModel.FK_InventoryItems_InventoryItemTypes" FromRole="InventoryItem" ToRole="InventoryItemType" />
  </EntityType>
  <EntityType Name="InventoryItemTypeCategory">
    <Key>
      <PropertyRef Name="InventoryItemTypeCategoryId" />
    </Key>
    <Property Name="InventoryItemTypeCategoryId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="OrderPriority" Type="Int32" Nullable="false" />
    <NavigationProperty Name="InventoryItemTypes" Relationship="PersonalLaundryModel.FK_InventoryItemTypes_InventoryItemTypeCategories" FromRole="InventoryItemTypeCategory" ToRole="InventoryItemType" />
  </EntityType>
  <EntityType Name="InventoryItemType">
    <Key>
      <PropertyRef Name="InventoryItemTypeId" />
    </Key>
    <Property Name="InventoryItemTypeId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="InventoryItemTypeCategoryId" Type="Int32" Nullable="false" />
    <Property Name="InventoryItemTypeSizeId" Type="Int32" Nullable="false" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="CustomerInventories" Relationship="PersonalLaundryModel.FK_CustomerInventory_InventoryItemTypes" FromRole="InventoryItemType" ToRole="CustomerInventory" />
    <NavigationProperty Name="CustomerInventoryAudits" Relationship="PersonalLaundryModel.FK_CustomerInventoryAudit_InventoryItems" FromRole="InventoryItemType" ToRole="CustomerInventoryAudit" />
    <NavigationProperty Name="InventoryItems" Relationship="PersonalLaundryModel.FK_InventoryItems_InventoryItemTypes" FromRole="InventoryItemType" ToRole="InventoryItem" />
    <NavigationProperty Name="InventoryItemTypeCategory" Relationship="PersonalLaundryModel.FK_InventoryItemTypes_InventoryItemTypeCategories" FromRole="InventoryItemType" ToRole="InventoryItemTypeCategory" />
    <NavigationProperty Name="InventoryItemTypeSize" Relationship="PersonalLaundryModel.FK_InventoryItemTypes_InventoryItemTypeSize" FromRole="InventoryItemType" ToRole="InventoryItemTypeSize" />
    <NavigationProperty Name="InvoiceItems" Relationship="PersonalLaundryModel.FK_InvoiceItems_InventoryItemTypes" FromRole="InventoryItemType" ToRole="InvoiceItem" />
  </EntityType>
  <EntityType Name="InventoryItemTypeSize">
    <Key>
      <PropertyRef Name="InventoryItemTypeSizeId" />
    </Key>
    <Property Name="InventoryItemTypeSizeId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Size" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="OrderPriority" Type="Int32" Nullable="false" />
    <NavigationProperty Name="InventoryItemTypes" Relationship="PersonalLaundryModel.FK_InventoryItemTypes_InventoryItemTypeSize" FromRole="InventoryItemTypeSize" ToRole="InventoryItemType" />
  </EntityType>
  <EntityType Name="InvoiceBag">
    <Key>
      <PropertyRef Name="InvoiceBagId" />
    </Key>
    <Property Name="InvoiceBagId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="BagReferenceId" Type="Int32" Nullable="false" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="BagReference" Relationship="PersonalLaundryModel.FK_InvoiceBags_BagReferences" FromRole="InvoiceBag" ToRole="BagReference" />
    <NavigationProperty Name="Invoice" Relationship="PersonalLaundryModel.FK_InvoiceBags_Invoices" FromRole="InvoiceBag" ToRole="Invoice" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_InvoiceBags_OperatorLogins" FromRole="InvoiceBag" ToRole="OperatorLogin" />
  </EntityType>
  <EntityType Name="InvoiceItem">
    <Key>
      <PropertyRef Name="InvoiceItemId" />
    </Key>
    <Property Name="InvoiceItemId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="InventoryItemTypeId" Type="Int32" Nullable="false" />
    <Property Name="ItemCount" Type="Int32" Nullable="false" />
    <Property Name="Cost" Type="Int32" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="InventoryItemType" Relationship="PersonalLaundryModel.FK_InvoiceItems_InventoryItemTypes" FromRole="InvoiceItem" ToRole="InventoryItemType" />
    <NavigationProperty Name="Invoice" Relationship="PersonalLaundryModel.FK_InvoiceItems_Invoices" FromRole="InvoiceItem" ToRole="Invoice" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_InvoiceItems_OperatorLogins" FromRole="InvoiceItem" ToRole="OperatorLogin" />
    <NavigationProperty Name="Packages" Relationship="PersonalLaundryModel.FK_Packages_InvoiceItems" FromRole="InvoiceItem" ToRole="Package" />
    <Property Name="BadCount" Type="Int32" />
    <Property Name="CondemnedPrinted" Type="Int32" />
  </EntityType>
  <EntityType Name="WorkloadItem">
    <Key>
      <PropertyRef Name="WorkloadItemId" />
    </Key>
    <Property Name="WorkloadItemId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="CustomerInventoryId" Type="Int32" Nullable="false" />
    <Property Name="ItemCount" Type="Int32" Nullable="false" />
    <Property Name="CustomerLoginId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
    <NavigationProperty Name="CustomerInventory" Relationship="PersonalLaundryModel.FK_WorkloadItems_CustomerInventory" FromRole="WorkloadItem" ToRole="CustomerInventory" />
    <NavigationProperty Name="CustomerLogin" Relationship="PersonalLaundryModel.FK_WorkloadItems_CustomerLogins" FromRole="WorkloadItem" ToRole="CustomerLogin" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_WorkloadItems_OperatorLogins" FromRole="WorkloadItem" ToRole="OperatorLogin" />
    <NavigationProperty Name="Workload" Relationship="PersonalLaundryModel.FK_WorkloadItems_Workloads" FromRole="WorkloadItem" ToRole="Workload" />
  </EntityType>
  <EntityType Name="WorkloadItemsAudit">
    <Key>
      <PropertyRef Name="WorkloadItemAuditId" />
    </Key>
    <Property Name="WorkloadItemAuditId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="CustomerInventoryId" Type="Int32" Nullable="false" />
    <Property Name="ItemCount" Type="Int32" Nullable="false" />
    <Property Name="CustomerLoginId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
    <NavigationProperty Name="CustomerInventory" Relationship="PersonalLaundryModel.FK_WorkloadItemsAudit_CustomerInventory" FromRole="WorkloadItemsAudit" ToRole="CustomerInventory" />
    <NavigationProperty Name="CustomerLogin" Relationship="PersonalLaundryModel.FK_WorkloadItemsAudit_CustomerLogins" FromRole="WorkloadItemsAudit" ToRole="CustomerLogin" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_WorkloadItemsAudit_OperatorLogins" FromRole="WorkloadItemsAudit" ToRole="OperatorLogin" />
    <NavigationProperty Name="Workload" Relationship="PersonalLaundryModel.FK_WorkloadItemsAudit_Workloads" FromRole="WorkloadItemsAudit" ToRole="Workload" />
  </EntityType>
  <EntityType Name="Workload">
    <Key>
      <PropertyRef Name="WorkloadId" />
    </Key>
    <Property Name="WorkloadId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="CustomerLoginId" Type="Int32" Nullable="false" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="WorkloadStatusId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadTypeId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="CustomerLogin" Relationship="PersonalLaundryModel.FK_Workloads_CustomerLogins" FromRole="Workload" ToRole="CustomerLogin" />
    <NavigationProperty Name="Customer" Relationship="PersonalLaundryModel.FK_Workloads_Customers" FromRole="Workload" ToRole="Customer" />
    <NavigationProperty Name="CustomerWorkloadBags" Relationship="PersonalLaundryModel.FK_WorkloadBags_Workloads" FromRole="Workload" ToRole="CustomerWorkloadBag" />
    <NavigationProperty Name="Invoices" Relationship="PersonalLaundryModel.FK_Invoices_Workloads" FromRole="Workload" ToRole="Invoice" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_Workloads_OperatorLogins" FromRole="Workload" ToRole="OperatorLogin" />
    <NavigationProperty Name="WorkloadItems" Relationship="PersonalLaundryModel.FK_WorkloadItems_Workloads" FromRole="Workload" ToRole="WorkloadItem" />
    <NavigationProperty Name="WorkloadItemsAudits" Relationship="PersonalLaundryModel.FK_WorkloadItemsAudit_Workloads" FromRole="Workload" ToRole="WorkloadItemsAudit" />
    <NavigationProperty Name="WorkloadStatu" Relationship="PersonalLaundryModel.FK_Workloads_WorkloadStatus" FromRole="Workload" ToRole="WorkloadStatu" />
    <NavigationProperty Name="WorkloadType" Relationship="PersonalLaundryModel.FK_Workloads_WorkloadTypes" FromRole="Workload" ToRole="WorkloadType" />
    <Property Name="Reference" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="OperatorAuthoriseId" Type="Int32" Nullable="false" />
    <Property Name="TotalBags" Type="Int32" />
  </EntityType>
  <EntityType Name="WorkloadsAudit">
    <Key>
      <PropertyRef Name="WorkloadAuditId" />
    </Key>
    <Property Name="WorkloadAuditId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="CustomerLoginId" Type="Int32" Nullable="false" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="WorkloadStatusId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadTypeId" Type="Int32" Nullable="false" />
    <NavigationProperty Name="CustomerLogin" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_CustomerLogins" FromRole="WorkloadsAudit" ToRole="CustomerLogin" />
    <NavigationProperty Name="Customer" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_Customers" FromRole="WorkloadsAudit" ToRole="Customer" />
    <NavigationProperty Name="OperatorLogin" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_OperatorLogins" FromRole="WorkloadsAudit" ToRole="OperatorLogin" />
    <NavigationProperty Name="WorkloadStatu" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_WorkloadStatus" FromRole="WorkloadsAudit" ToRole="WorkloadStatu" />
    <NavigationProperty Name="WorkloadType" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_WorkloadTypes" FromRole="WorkloadsAudit" ToRole="WorkloadType" />
  </EntityType>
  <EntityType Name="WorkloadStatus">
    <Key>
      <PropertyRef Name="WorkloadStatusId" />
    </Key>
    <Property Name="WorkloadStatusId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Status" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Workloads" Relationship="PersonalLaundryModel.FK_Workloads_WorkloadStatus" FromRole="WorkloadStatu" ToRole="Workload" />
    <NavigationProperty Name="WorkloadsAudits" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_WorkloadStatus" FromRole="WorkloadStatu" ToRole="WorkloadsAudit" />
  </EntityType>
  <EntityType Name="WorkloadType">
    <Key>
      <PropertyRef Name="WorkloadTypeId" />
    </Key>
    <Property Name="WorkloadTypeId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Type" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="CanStartCycle" Type="Boolean" Nullable="false" />
    <NavigationProperty Name="Workloads" Relationship="PersonalLaundryModel.FK_Workloads_WorkloadTypes" FromRole="WorkloadType" ToRole="Workload" />
    <NavigationProperty Name="WorkloadsAudits" Relationship="PersonalLaundryModel.FK_WorkloadsAudit_WorkloadTypes" FromRole="WorkloadType" ToRole="WorkloadsAudit" />
  </EntityType>
  <EntityType Name="vwClosedCustomerWorkload">
    <Key>
      <PropertyRef Name="WorkloadItemId" />
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="CustomerInventoryId" />
      <PropertyRef Name="ItemCount" />
      <PropertyRef Name="CustomerLoginId" />
      <PropertyRef Name="OperatorLoginId" />
      <PropertyRef Name="TimeStamp" />
    </Key>
    <Property Name="WorkloadItemId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="CustomerInventoryId" Type="Int32" Nullable="false" />
    <Property Name="ItemCount" Type="Int32" Nullable="false" />
    <Property Name="CustomerLoginId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
  </EntityType>
  <EntityType Name="vwCustomerBagsWaitingCounting">
    <Key>
      <PropertyRef Name="CustomerId" />
      <PropertyRef Name="Name" />
    </Key>
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="Name" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="BagCount" Type="Int32" />
  </EntityType>
  <EntityType Name="vwCustomerInventory">
    <Key>
      <PropertyRef Name="CustomerId" />
      <PropertyRef Name="CustomerInventoryId" />
      <PropertyRef Name="Category" />
      <PropertyRef Name="ItemType" />
      <PropertyRef Name="Size" />
      <PropertyRef Name="TCOrderPriority" />
      <PropertyRef Name="TSOrderPriority" />
    </Key>
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="CustomerInventoryId" Type="Int32" Nullable="false" />
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="Size" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="TCOrderPriority" Type="Int32" Nullable="false" />
    <Property Name="TSOrderPriority" Type="Int32" Nullable="false" />
  </EntityType>
  <EntityType Name="vwCustomerInventoryForWorkload">
    <Key>
      <PropertyRef Name="CustomerId" />
      <PropertyRef Name="CustomerInventoryId" />
      <PropertyRef Name="Category" />
      <PropertyRef Name="ItemType" />
      <PropertyRef Name="Size" />
      <PropertyRef Name="TCOrderPriority" />
      <PropertyRef Name="TSOrderPriority" />
    </Key>
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="CustomerInventoryId" Type="Int32" Nullable="false" />
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="Size" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="TCOrderPriority" Type="Int32" Nullable="false" />
    <Property Name="TSOrderPriority" Type="Int32" Nullable="false" />
  </EntityType>
  <EntityType Name="vwCustomerInventoryWorkload">
    <Key>
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="InventoryItemTypeId" />
      <PropertyRef Name="ItemCount" />
    </Key>
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="InventoryItemTypeId" Type="Int32" Nullable="false" />
    <Property Name="CostGeneralWash" Type="Int32" />
    <Property Name="CostRepeatWash" Type="Int32" />
    <Property Name="CostStainWash" Type="Int32" />
    <Property Name="ItemCount" Type="Int32" Nullable="false" />
  </EntityType>
  <EntityType Name="vwDeliveryNoteCategoriesByBagSeal">
    <Key>
      <PropertyRef Name="InvoiceId" />
      <PropertyRef Name="BagSeal" />
      <PropertyRef Name="DispatchId" />
    </Key>
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="BagSeal" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
    <Property Name="Categories" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
    <Property Name="DispatchId" Type="Int32" Nullable="false" />
  </EntityType>
  <EntityType Name="vwDispatchBagPackageContent">
    <Key>
      <PropertyRef Name="DispatchId" />
      <PropertyRef Name="PackageId" />
      <PropertyRef Name="ItemType" />
      <PropertyRef Name="Category" />
      <PropertyRef Name="Category_OrderPriority" />
      <PropertyRef Name="Size" />
      <PropertyRef Name="Size_OrderPriority" />
    </Key>
    <Property Name="DispatchId" Type="Int32" Nullable="false" />
    <Property Name="PackageId" Type="Int32" Nullable="false" />
    <Property Name="BagNumber" Type="Int64" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Category_OrderPriority" Type="Int32" Nullable="false" />
    <Property Name="Size" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Size_OrderPriority" Type="Int32" Nullable="false" />
    <Property Name="ItemCount" Type="Int32" />
    <Property Name="ItemCountStain" Type="Int32" />
  </EntityType>
  <EntityType Name="vwExcelDataDump">
    <Key>
      <PropertyRef Name="Name" />
      <PropertyRef Name="Type" />
      <PropertyRef Name="ItemType" />
      <PropertyRef Name="ItemCount" />
    </Key>
    <Property Name="Date" Type="DateTime" Precision="0" />
    <Property Name="Name" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="Type" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="Size" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="ItemCount" Type="Int32" Nullable="false" />
  </EntityType>
  <EntityType Name="vwInventoryItem">
    <Key>
      <PropertyRef Name="InventoryItemTypeId" />
      <PropertyRef Name="ItemType" />
      <PropertyRef Name="Category" />
      <PropertyRef Name="Size" />
      <PropertyRef Name="Categories_OrderPriority" />
      <PropertyRef Name="Size_OrderPriority" />
    </Key>
    <Property Name="InventoryItemTypeId" Type="Int32" Nullable="false" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Size" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Categories_OrderPriority" Type="Int32" Nullable="false" />
    <Property Name="Size_OrderPriority" Type="Int32" Nullable="false" />
  </EntityType>
  <EntityType Name="vwInventoryItemType">
    <Key>
      <PropertyRef Name="Category" />
      <PropertyRef Name="ItemType" />
    </Key>
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
  </EntityType>
  <EntityType Name="vwInvoiceBagSealCategory">
    <Key>
      <PropertyRef Name="InvoiceId" />
      <PropertyRef Name="BagSeal" />
      <PropertyRef Name="Category" />
      <PropertyRef Name="DispatchId" />
    </Key>
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="BagSeal" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="DispatchId" Type="Int32" Nullable="false" />
    <Property Name="DeliveryId" Type="Int32" />
  </EntityType>
  <EntityType Name="vwInvoiceCountsRecon">
    <Key>
      <PropertyRef Name="InvoiceId" />
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="InventoryItemTypeId" />
      <PropertyRef Name="ItemType" />
      <PropertyRef Name="Category" />
      <PropertyRef Name="Size" />
      <PropertyRef Name="InvoiceItemCount" />
      <PropertyRef Name="Categories_OrderPriority" />
      <PropertyRef Name="Size_OrderPriority" />
    </Key>
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="InventoryItemTypeId" Type="Int32" Nullable="false" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Size" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="InvoiceItemCount" Type="Int32" Nullable="false" />
    <Property Name="CustomerItemCount" Type="Int32" />
    <Property Name="Cost" Type="Int32" />
    <Property Name="CostGeneralWash" Type="Int32" />
    <Property Name="CostRepeatWash" Type="Int32" />
    <Property Name="CostStainWash" Type="Int32" />
    <Property Name="Categories_OrderPriority" Type="Int32" Nullable="false" />
    <Property Name="Size_OrderPriority" Type="Int32" Nullable="false" />
  </EntityType>
  <EntityType Name="vwOpenCustomerWorkload">
    <Key>
      <PropertyRef Name="WorkloadItemId" />
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="CustomerInventoryId" />
      <PropertyRef Name="ItemCount" />
      <PropertyRef Name="CustomerLoginId" />
      <PropertyRef Name="OperatorLoginId" />
      <PropertyRef Name="TimeStamp" />
    </Key>
    <Property Name="WorkloadItemId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="CustomerInventoryId" Type="Int32" Nullable="false" />
    <Property Name="ItemCount" Type="Int32" Nullable="false" />
    <Property Name="CustomerLoginId" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="TimeStamp" Type="DateTime" Nullable="false" Precision="3" />
  </EntityType>
  <EntityType Name="vwPackageContent">
    <Key>
      <PropertyRef Name="PackageId" />
      <PropertyRef Name="InvoiceId" />
      <PropertyRef Name="WorkloadId" />
    </Key>
    <Property Name="PackageId" Type="Int32" Nullable="false" />
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="Description" Type="String" MaxLength="303" FixedLength="false" Unicode="true" />
  </EntityType>
  <EntityType Name="vwPackagesReadyForDispatch">
    <Key>
      <PropertyRef Name="PackageId" />
      <PropertyRef Name="InvoiceItemId" />
      <PropertyRef Name="ItemCount" />
      <PropertyRef Name="OperatorLoginId" />
      <PropertyRef Name="DateCreated" />
    </Key>
    <Property Name="PackageId" Type="Int32" Nullable="false" />
    <Property Name="InvoiceItemId" Type="Int32" Nullable="false" />
    <Property Name="ItemCount" Type="Int32" Nullable="false" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
  </EntityType>
  <EntityType Name="vwWorkloadCategoryTypeCount">
    <Key>
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="Category" />
      <PropertyRef Name="ItemType" />
    </Key>
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="ItemCount" Type="Int32" />
  </EntityType>
  <EntityType Name="vwWorkloadStatusReport">
    <Key>
      <PropertyRef Name="WorkloadStatusId" />
      <PropertyRef Name="Status" />
    </Key>
    <Property Name="WorkloadStatusId" Type="Int32" Nullable="false" />
    <Property Name="Status" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Customers" Type="Int32" />
    <Property Name="TotalItems" Type="Int32" />
  </EntityType>
  <EntityType Name="vwWorkloadStatusReportWithCount">
    <Key>
      <PropertyRef Name="WorkloadStatusId" />
      <PropertyRef Name="Status" />
    </Key>
    <Property Name="WorkloadStatusId" Type="Int32" Nullable="false" />
    <Property Name="Status" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Customers" Type="Int32" />
    <Property Name="Bags" Type="Int32" />
    <Property Name="Items" Type="Int32" />
  </EntityType>
  <Association Name="FK_CustomerLoginLog_Actions">
    <End Type="PersonalLaundryModel.Action" Role="Action" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerLoginLog" Role="CustomerLoginLog" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Action">
        <PropertyRef Name="ActionId" />
      </Principal>
      <Dependent Role="CustomerLoginLog">
        <PropertyRef Name="ActionId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_BagReferences_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.BagReference" Role="BagReference" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="BagReference">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InvoiceBags_BagReferences">
    <End Type="PersonalLaundryModel.BagReference" Role="BagReference" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InvoiceBag" Role="InvoiceBag" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="BagReference">
        <PropertyRef Name="BagReferenceId" />
      </Principal>
      <Dependent Role="InvoiceBag">
        <PropertyRef Name="BagReferenceId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Customers_BillingProfiles">
    <End Type="PersonalLaundryModel.BillingProfile" Role="BillingProfile" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="BillingProfile">
        <PropertyRef Name="BillingProfileId" />
      </Principal>
      <Dependent Role="Customer">
        <PropertyRef Name="BillingProfileId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_CustomerInventory_Customer">
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerInventory" Role="CustomerInventory" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Customer">
        <PropertyRef Name="CustomerId" />
      </Principal>
      <Dependent Role="CustomerInventory">
        <PropertyRef Name="CustomerId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_CustomerInventory_InventoryItemTypes">
    <End Type="PersonalLaundryModel.InventoryItemType" Role="InventoryItemType" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerInventory" Role="CustomerInventory" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="InventoryItemType">
        <PropertyRef Name="InventoryItemTypeId" />
      </Principal>
      <Dependent Role="CustomerInventory">
        <PropertyRef Name="InventoryItemTypeId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_CustomerInventory_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerInventory" Role="CustomerInventory" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="CustomerInventory">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadItems_CustomerInventory">
    <End Type="PersonalLaundryModel.CustomerInventory" Role="CustomerInventory" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadItem" Role="WorkloadItem" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="CustomerInventory">
        <PropertyRef Name="CustomerInventoryId" />
      </Principal>
      <Dependent Role="WorkloadItem">
        <PropertyRef Name="CustomerInventoryId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadItemsAudit_CustomerInventory">
    <End Type="PersonalLaundryModel.CustomerInventory" Role="CustomerInventory" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadItemsAudit" Role="WorkloadItemsAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="CustomerInventory">
        <PropertyRef Name="CustomerInventoryId" />
      </Principal>
      <Dependent Role="WorkloadItemsAudit">
        <PropertyRef Name="CustomerInventoryId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_CustomerInventoryAudit_Customers">
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerInventoryAudit" Role="CustomerInventoryAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Customer">
        <PropertyRef Name="CustomerId" />
      </Principal>
      <Dependent Role="CustomerInventoryAudit">
        <PropertyRef Name="CustomerId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_CustomerInventoryAudit_InventoryItems">
    <End Type="PersonalLaundryModel.InventoryItemType" Role="InventoryItemType" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerInventoryAudit" Role="CustomerInventoryAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="InventoryItemType">
        <PropertyRef Name="InventoryItemTypeId" />
      </Principal>
      <Dependent Role="CustomerInventoryAudit">
        <PropertyRef Name="InventoryItemTypeId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_CustomerInventoryAudit_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerInventoryAudit" Role="CustomerInventoryAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="CustomerInventoryAudit">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_CustomerLogins_Customers">
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerLogin" Role="CustomerLogin" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Customer">
        <PropertyRef Name="CustomerId" />
      </Principal>
      <Dependent Role="CustomerLogin">
        <PropertyRef Name="CustomerId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadBags_CustomerLogins">
    <End Type="PersonalLaundryModel.CustomerLogin" Role="CustomerLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerWorkloadBag" Role="CustomerWorkloadBag" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="CustomerLogin">
        <PropertyRef Name="CustomerLoginId" />
      </Principal>
      <Dependent Role="CustomerWorkloadBag">
        <PropertyRef Name="CustomerLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadItems_CustomerLogins">
    <End Type="PersonalLaundryModel.CustomerLogin" Role="CustomerLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadItem" Role="WorkloadItem" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="CustomerLogin">
        <PropertyRef Name="CustomerLoginId" />
      </Principal>
      <Dependent Role="WorkloadItem">
        <PropertyRef Name="CustomerLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadItemsAudit_CustomerLogins">
    <End Type="PersonalLaundryModel.CustomerLogin" Role="CustomerLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadItemsAudit" Role="WorkloadItemsAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="CustomerLogin">
        <PropertyRef Name="CustomerLoginId" />
      </Principal>
      <Dependent Role="WorkloadItemsAudit">
        <PropertyRef Name="CustomerLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Workloads_CustomerLogins">
    <End Type="PersonalLaundryModel.CustomerLogin" Role="CustomerLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Workload" Role="Workload" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="CustomerLogin">
        <PropertyRef Name="CustomerLoginId" />
      </Principal>
      <Dependent Role="Workload">
        <PropertyRef Name="CustomerLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadsAudit_CustomerLogins">
    <End Type="PersonalLaundryModel.CustomerLogin" Role="CustomerLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadsAudit" Role="WorkloadsAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="CustomerLogin">
        <PropertyRef Name="CustomerLoginId" />
      </Principal>
      <Dependent Role="WorkloadsAudit">
        <PropertyRef Name="CustomerLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Customers_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="Customer">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InventoryItems_Customers">
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InventoryItem" Role="InventoryItem" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Customer">
        <PropertyRef Name="CustomerId" />
      </Principal>
      <Dependent Role="InventoryItem">
        <PropertyRef Name="CustomerId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Invoices_Customers">
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Invoice" Role="Invoice" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Customer">
        <PropertyRef Name="CustomerId" />
      </Principal>
      <Dependent Role="Invoice">
        <PropertyRef Name="CustomerId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Workloads_Customers">
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Workload" Role="Workload" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Customer">
        <PropertyRef Name="CustomerId" />
      </Principal>
      <Dependent Role="Workload">
        <PropertyRef Name="CustomerId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadsAudit_Customers">
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadsAudit" Role="WorkloadsAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Customer">
        <PropertyRef Name="CustomerId" />
      </Principal>
      <Dependent Role="WorkloadsAudit">
        <PropertyRef Name="CustomerId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadBags_Workloads">
    <End Type="PersonalLaundryModel.Workload" Role="Workload" Multiplicity="1" />
    <End Type="PersonalLaundryModel.CustomerWorkloadBag" Role="CustomerWorkloadBag" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Workload">
        <PropertyRef Name="WorkloadId" />
      </Principal>
      <Dependent Role="CustomerWorkloadBag">
        <PropertyRef Name="WorkloadId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Dispatches_DispatchStatus">
    <End Type="PersonalLaundryModel.DispatchStatu" Role="DispatchStatu" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Dispatch" Role="Dispatch" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="DispatchStatu">
        <PropertyRef Name="DispatchStatusId" />
      </Principal>
      <Dependent Role="Dispatch">
        <PropertyRef Name="DispatchStatusId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_DispatchItems_Dispatches">
    <End Type="PersonalLaundryModel.Dispatch" Role="Dispatch" Multiplicity="1" />
    <End Type="PersonalLaundryModel.DispatchPackage" Role="DispatchPackage" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Dispatch">
        <PropertyRef Name="DispatchId" />
      </Principal>
      <Dependent Role="DispatchPackage">
        <PropertyRef Name="DispatchId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_DispatchItems_Packages">
    <End Type="PersonalLaundryModel.Package" Role="Package" Multiplicity="1" />
    <End Type="PersonalLaundryModel.DispatchPackage" Role="DispatchPackage" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Package">
        <PropertyRef Name="PackageId" />
      </Principal>
      <Dependent Role="DispatchPackage">
        <PropertyRef Name="PackageId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InventoryItems_InventoryItemTypes">
    <End Type="PersonalLaundryModel.InventoryItemType" Role="InventoryItemType" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InventoryItem" Role="InventoryItem" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="InventoryItemType">
        <PropertyRef Name="InventoryItemTypeId" />
      </Principal>
      <Dependent Role="InventoryItem">
        <PropertyRef Name="InventoryItemTypeId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InventoryItemTypes_InventoryItemTypeCategories">
    <End Type="PersonalLaundryModel.InventoryItemTypeCategory" Role="InventoryItemTypeCategory" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InventoryItemType" Role="InventoryItemType" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="InventoryItemTypeCategory">
        <PropertyRef Name="InventoryItemTypeCategoryId" />
      </Principal>
      <Dependent Role="InventoryItemType">
        <PropertyRef Name="InventoryItemTypeCategoryId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InventoryItemTypes_InventoryItemTypeSize">
    <End Type="PersonalLaundryModel.InventoryItemTypeSize" Role="InventoryItemTypeSize" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InventoryItemType" Role="InventoryItemType" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="InventoryItemTypeSize">
        <PropertyRef Name="InventoryItemTypeSizeId" />
      </Principal>
      <Dependent Role="InventoryItemType">
        <PropertyRef Name="InventoryItemTypeSizeId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InvoiceItems_InventoryItemTypes">
    <End Type="PersonalLaundryModel.InventoryItemType" Role="InventoryItemType" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InvoiceItem" Role="InvoiceItem" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="InventoryItemType">
        <PropertyRef Name="InventoryItemTypeId" />
      </Principal>
      <Dependent Role="InvoiceItem">
        <PropertyRef Name="InventoryItemTypeId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InvoiceBags_Invoices">
    <End Type="PersonalLaundryModel.Invoice" Role="Invoice" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InvoiceBag" Role="InvoiceBag" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Invoice">
        <PropertyRef Name="InvoiceId" />
      </Principal>
      <Dependent Role="InvoiceBag">
        <PropertyRef Name="InvoiceId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InvoiceBags_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InvoiceBag" Role="InvoiceBag" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="InvoiceBag">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InvoiceItems_Invoices">
    <End Type="PersonalLaundryModel.Invoice" Role="Invoice" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InvoiceItem" Role="InvoiceItem" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Invoice">
        <PropertyRef Name="InvoiceId" />
      </Principal>
      <Dependent Role="InvoiceItem">
        <PropertyRef Name="InvoiceId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_InvoiceItems_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.InvoiceItem" Role="InvoiceItem" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="InvoiceItem">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Packages_InvoiceItems">
    <End Type="PersonalLaundryModel.InvoiceItem" Role="InvoiceItem" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Package" Role="Package" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="InvoiceItem">
        <PropertyRef Name="InvoiceItemId" />
      </Principal>
      <Dependent Role="Package">
        <PropertyRef Name="InvoiceItemId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Invoices_Workloads">
    <End Type="PersonalLaundryModel.Workload" Role="Workload" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Invoice" Role="Invoice" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Workload">
        <PropertyRef Name="WorkloadId" />
      </Principal>
      <Dependent Role="Invoice">
        <PropertyRef Name="WorkloadId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadItems_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadItem" Role="WorkloadItem" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="WorkloadItem">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadItemsAudit_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadItemsAudit" Role="WorkloadItemsAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="WorkloadItemsAudit">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Workloads_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Workload" Role="Workload" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="Workload">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadsAudit_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadsAudit" Role="WorkloadsAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="WorkloadsAudit">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadItems_Workloads">
    <End Type="PersonalLaundryModel.Workload" Role="Workload" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadItem" Role="WorkloadItem" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Workload">
        <PropertyRef Name="WorkloadId" />
      </Principal>
      <Dependent Role="WorkloadItem">
        <PropertyRef Name="WorkloadId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadItemsAudit_Workloads">
    <End Type="PersonalLaundryModel.Workload" Role="Workload" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadItemsAudit" Role="WorkloadItemsAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Workload">
        <PropertyRef Name="WorkloadId" />
      </Principal>
      <Dependent Role="WorkloadItemsAudit">
        <PropertyRef Name="WorkloadId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Workloads_WorkloadStatus">
    <End Type="PersonalLaundryModel.WorkloadStatus" Role="WorkloadStatu" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Workload" Role="Workload" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="WorkloadStatu">
        <PropertyRef Name="WorkloadStatusId" />
      </Principal>
      <Dependent Role="Workload">
        <PropertyRef Name="WorkloadStatusId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Workloads_WorkloadTypes">
    <End Type="PersonalLaundryModel.WorkloadType" Role="WorkloadType" Multiplicity="1" />
    <End Type="PersonalLaundryModel.Workload" Role="Workload" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="WorkloadType">
        <PropertyRef Name="WorkloadTypeId" />
      </Principal>
      <Dependent Role="Workload">
        <PropertyRef Name="WorkloadTypeId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadsAudit_WorkloadStatus">
    <End Type="PersonalLaundryModel.WorkloadStatus" Role="WorkloadStatu" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadsAudit" Role="WorkloadsAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="WorkloadStatu">
        <PropertyRef Name="WorkloadStatusId" />
      </Principal>
      <Dependent Role="WorkloadsAudit">
        <PropertyRef Name="WorkloadStatusId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkloadsAudit_WorkloadTypes">
    <End Type="PersonalLaundryModel.WorkloadType" Role="WorkloadType" Multiplicity="1" />
    <End Type="PersonalLaundryModel.WorkloadsAudit" Role="WorkloadsAudit" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="WorkloadType">
        <PropertyRef Name="WorkloadTypeId" />
      </Principal>
      <Dependent Role="WorkloadsAudit">
        <PropertyRef Name="WorkloadTypeId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <ComplexType Name="AcceptCustomerBag_Result">
    <Property Type="Int32" Name="WorkloadBagId" Nullable="false" />
    <Property Type="Int32" Name="WorkloadId" Nullable="false" />
    <Property Type="String" Name="UniqueReference" Nullable="false" MaxLength="50" />
    <Property Type="DateTime" Name="TimeStamp" Nullable="false" Precision="23" />
    <Property Type="Int32" Name="CustomerLoginId" Nullable="false" />
    <Property Type="DateTime" Name="TimeReceived" Nullable="false" Precision="23" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
  </ComplexType>
  <ComplexType Name="CreateDispatch_Result">
    <Property Type="Int32" Name="DispatchId" Nullable="false" />
    <Property Type="Int32" Name="InvoiceId" Nullable="false" />
    <Property Type="String" Name="BagSeal" Nullable="false" MaxLength="200" />
    <Property Type="DateTime" Name="DateCreated" Nullable="false" Precision="23" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="Int32" Name="DispatchStatusId" Nullable="false" />
  </ComplexType>
  <ComplexType Name="CreatePackage_Result">
    <Property Type="Int32" Name="PackageId" Nullable="false" />
    <Property Type="Int32" Name="InvoiceItemId" Nullable="false" />
    <Property Type="Int32" Name="ItemCount" Nullable="false" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="DateTime" Name="DateCreated" Nullable="false" Precision="23" />
  </ComplexType>
  <ComplexType Name="CreateWorkload_Result">
    <Property Type="Int32" Name="WorkloadId" Nullable="false" />
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="Int32" Name="CustomerLoginId" Nullable="false" />
    <Property Type="DateTime" Name="DateCreated" Nullable="false" Precision="23" />
    <Property Type="Int32" Name="WorkloadStatusId" Nullable="false" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="Int32" Name="WorkloadTypeId" Nullable="false" />
  </ComplexType>
  <ComplexType Name="FinishCounting_Result">
    <Property Type="Int32" Name="InvoiceId" Nullable="false" />
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="Int32" Name="WorkloadId" Nullable="false" />
    <Property Type="DateTime" Name="DateCreated" Nullable="false" Precision="23" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="Int32" Name="InvoiceStatusId" Nullable="false" />
  </ComplexType>
  <ComplexType Name="GenerateInvoiceFromWorkloadCounts_Result">
    <Property Type="Int32" Name="InvoiceId" Nullable="false" />
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="Int32" Name="WorkloadId" Nullable="false" />
    <Property Type="DateTime" Name="DateCreated" Nullable="false" Precision="23" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="Int32" Name="InvoiceStatusId" Nullable="false" />
  </ComplexType>
  <ComplexType Name="GetCustomerInventory_Result">
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="Int32" Name="CostGeneralWash" Nullable="true" />
    <Property Type="Int32" Name="CostRepeatWash" Nullable="true" />
    <Property Type="Int32" Name="CostStainWash" Nullable="true" />
    <Property Type="Int32" Name="CostRewashWash" Nullable="true" />
  </ComplexType>
  <ComplexType Name="GetCustomerInventoryByCustomerIdWorkloadId_Result">
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="Int32" Name="CustomerInventoryId" Nullable="false" />
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Count" Nullable="true" MaxLength="30" />
    <Property Type="Int32" Name="TCOrderPriority" Nullable="false" />
    <Property Type="Int32" Name="TSOrderPriority" Nullable="false" />
  </ComplexType>
  <ComplexType Name="GetCustomerInventoryForWorkload_Result">
    <Property Type="Int32" Name="CustomerInventoryId" Nullable="false" />
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="Int32" Name="CostGeneralWash" Nullable="true" />
    <Property Type="Int32" Name="CostRepeatWash" Nullable="true" />
    <Property Type="Int32" Name="CostStainWash" Nullable="true" />
  </ComplexType>
  <ComplexType Name="GetCustomerLoginFromGuid_Result">
    <Property Type="Int32" Name="CustomerLoginId" Nullable="false" />
    <Property Type="Guid" Name="GUID" Nullable="false" />
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="String" Name="EmailAddress" Nullable="false" MaxLength="100" />
    <Property Type="String" Name="Password" Nullable="false" MaxLength="50" />
    <Property Type="Boolean" Name="IsActive" Nullable="false" />
    <Property Type="Boolean" Name="IsLockedOut" Nullable="false" />
  </ComplexType>
  <ComplexType Name="GetInvoiceForPrinter_Result">
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="Int32" Name="ItemCount" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
  </ComplexType>
  <ComplexType Name="GetWorkloadInventory_Result">
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="Int32" Name="CustomerCount" Nullable="true" />
    <Property Type="Int32" Name="Count" Nullable="true" />
    <Property Type="Int32" Name="Category_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Size_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="CustomerInventoryId" Nullable="false" />
  </ComplexType>
  <ComplexType Name="WorkloadInventory_Result">
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="Int32" Name="ItemCount" Nullable="false" />
    <Property Type="Int32" Name="Category_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Size_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
    <Property Type="Int32" Name="CustomerId" Nullable="true" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="Int32" Name="BadCount" Nullable="false" />
  </ComplexType>
  <ComplexType Name="LoginCustomer_Result">
    <Property Type="Int32" Name="CustomerLoginId" Nullable="false" />
    <Property Type="Guid" Name="GUID" Nullable="false" />
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="String" Name="EmailAddress" Nullable="false" MaxLength="100" />
    <Property Type="String" Name="Password" Nullable="false" MaxLength="50" />
    <Property Type="Boolean" Name="IsActive" Nullable="false" />
    <Property Type="Boolean" Name="IsLockedOut" Nullable="false" />
  </ComplexType>
  <ComplexType Name="LoginOperator_Result">
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="String" Name="Username" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Password" Nullable="false" MaxLength="50" />
    <Property Type="Int32" Name="OperatorRoleId" Nullable="false" />
    <Property Type="Binary" Name="Fingerprint" Nullable="true" />
  </ComplexType>
  <ComplexType Name="SaveFingerprint_Result">
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="String" Name="Username" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Password" Nullable="false" MaxLength="50" />
    <Property Type="Int32" Name="OperatorRoleId" Nullable="false" />
    <Property Type="Binary" Name="Fingerprint" Nullable="true" />
  </ComplexType>
  <ComplexType Name="UpdateCustomerInventory_Result">
    <Property Type="Int32" Name="CustomerInventoryId" Nullable="false" />
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="DateTime" Name="TimeStamp" Nullable="false" Precision="23" />
    <Property Type="Int32" Name="CostGeneralWash" Nullable="true" />
    <Property Type="Int32" Name="CostRepeatWash" Nullable="true" />
    <Property Type="Int32" Name="CostStainWash" Nullable="true" />
  </ComplexType>
  <ComplexType Name="UpdateCustomerLogin_Result">
    <Property Type="Int32" Name="CustomerLoginId" Nullable="false" />
    <Property Type="Guid" Name="GUID" Nullable="false" />
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="String" Name="EmailAddress" Nullable="false" MaxLength="100" />
    <Property Type="String" Name="Password" Nullable="false" MaxLength="50" />
    <Property Type="Boolean" Name="IsActive" Nullable="false" />
    <Property Type="Boolean" Name="IsLockedOut" Nullable="false" />
  </ComplexType>
  <ComplexType Name="UpdateCustomerWorkloadBag_Result">
    <Property Type="Int32" Name="WorkloadBagId" Nullable="false" />
    <Property Type="Int32" Name="WorkloadId" Nullable="false" />
    <Property Type="String" Name="UniqueReference" Nullable="false" MaxLength="50" />
    <Property Type="DateTime" Name="TimeStamp" Nullable="false" Precision="23" />
    <Property Type="Int32" Name="CustomerLoginId" Nullable="false" />
    <Property Type="DateTime" Name="TimeReceived" Nullable="true" Precision="23" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
  </ComplexType>
  <ComplexType Name="UpdateInvoiceItemCount_Result">
    <Property Type="Int32" Name="InvoiceItemId" Nullable="false" />
    <Property Type="Int32" Name="InvoiceId" Nullable="false" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="Int32" Name="ItemCount" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
  </ComplexType>
  <ComplexType Name="UpdateOperatorLogin_Result">
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="String" Name="Username" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Password" Nullable="false" MaxLength="50" />
    <Property Type="Int32" Name="OperatorRoleId" Nullable="false" />
    <Property Type="Binary" Name="Fingerprint" Nullable="true" />
  </ComplexType>
  <ComplexType Name="UpdateWorkloadItem_Result">
    <Property Type="Int32" Name="WorkloadItemId" Nullable="false" />
    <Property Type="Int32" Name="WorkloadId" Nullable="false" />
    <Property Type="Int32" Name="CustomerInventoryId" Nullable="false" />
    <Property Type="Int32" Name="ItemCount" Nullable="false" />
    <Property Type="Int32" Name="CustomerLoginId" Nullable="false" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="DateTime" Name="TimeStamp" Nullable="false" Precision="23" />
  </ComplexType>
  <Association Name="FK_DriverLog_Customers">
    <End Type="PersonalLaundryModel.Customer" Role="Customer" Multiplicity="1" />
    <End Type="PersonalLaundryModel.DriverLog" Role="DriverLog" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Customer">
        <PropertyRef Name="CustomerId" />
      </Principal>
      <Dependent Role="DriverLog">
        <PropertyRef Name="CustomerId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_DriverLog_DriverActions">
    <End Type="PersonalLaundryModel.DriverAction" Role="DriverAction" Multiplicity="1" />
    <End Type="PersonalLaundryModel.DriverLog" Role="DriverLog" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="DriverAction">
        <PropertyRef Name="DriverActionId" />
      </Principal>
      <Dependent Role="DriverLog">
        <PropertyRef Name="DriverActionId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_DriverLog_Locations">
    <End Type="PersonalLaundryModel.Location" Role="Location" Multiplicity="1" />
    <End Type="PersonalLaundryModel.DriverLog" Role="DriverLog" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Location">
        <PropertyRef Name="LocationId" />
      </Principal>
      <Dependent Role="DriverLog">
        <PropertyRef Name="LocationId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_DriverLog_OperatorLogins">
    <End Type="PersonalLaundryModel.OperatorLogin" Role="OperatorLogin" Multiplicity="1" />
    <End Type="PersonalLaundryModel.DriverLog" Role="DriverLog" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="OperatorLogin">
        <PropertyRef Name="OperatorLoginId" />
      </Principal>
      <Dependent Role="DriverLog">
        <PropertyRef Name="OperatorLoginId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <EntityType Name="vwInvoicesReadyToPrint">
    <Key>
      <PropertyRef Name="CustomerId" />
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="DateCreated" />
      <PropertyRef Name="OperatorLoginId" />
      <PropertyRef Name="InvoiceStatusId" />
      <PropertyRef Name="InvoiceId" />
    </Key>
    <Property Name="Id" Type="Int32" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="InvoiceStatusId" Type="Int32" Nullable="false" />
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="InvoiceType" Type="String" MaxLength="8" FixedLength="false" Unicode="false" />
  </EntityType>
  <ComplexType Name="GetWorkloadInventoryForDispatch_Result">
    <Property Type="Int32" Name="CustomerId" Nullable="true" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="Int32" Name="ItemCount" Nullable="false" />
    <Property Type="Int32" Name="Category_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Size_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
  </ComplexType>
  <ComplexType Name="GetCustomerInvoiceById_Result">
    <Property Type="Int32" Name="Id" Nullable="true" />
    <Property Type="Int32" Name="WorkloadId" Nullable="false" />
    <Property Type="DateTime" Name="DateCreated" Nullable="false" Precision="23" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="Int32" Name="InvoiceStatusId" Nullable="false" />
  </ComplexType>
  <ComplexType Name="UpdateInvoiceItemBadCount_Result">
    <Property Type="Int32" Name="InvoiceItemId" Nullable="false" />
    <Property Type="Int32" Name="InvoiceId" Nullable="false" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="Int32" Name="ItemCount" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="Int32" Name="BadCount" Nullable="true" />
  </ComplexType>
  <EntityType Name="vwInvoiceItemCount">
    <Key>
      <PropertyRef Name="InvoiceId" />
      <PropertyRef Name="Name" />
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="DateCreated" />
    </Key>
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="ItemCount" Type="Int32" />
    <Property Name="Name" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
  </EntityType>
  <EntityType Name="sysdiagram">
    <Key>
      <PropertyRef Name="diagram_id" />
    </Key>
    <Property Type="String" Name="name" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" />
    <Property Type="Int32" Name="principal_id" Nullable="false" />
    <Property Type="Int32" Name="diagram_id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Type="Int32" Name="version" />
    <Property Type="Binary" Name="definition" MaxLength="Max" FixedLength="false" />
  </EntityType>
  <EntityType Name="vwDispatchesOutForDelivery">
    <Key>
      <PropertyRef Name="InvoiceId" />
    </Key>
    <Property Type="Int32" Name="InvoiceId" Nullable="false" />
  </EntityType>
  <ComplexType Name="GetWorkloadInventoryForInvoice_backup_20140820_Result">
    <Property Type="Int32" Name="CustomerId" Nullable="true" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="Int32" Name="ItemCount" Nullable="false" />
    <Property Type="Int32" Name="BadCount" Nullable="true" />
    <Property Type="Int32" Name="Category_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Size_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
  </ComplexType>
  <EntityType Name="vwCustomerBagsReadyToDispatch">
    <Key>
      <PropertyRef Name="DispatchId" />
      <PropertyRef Name="BagSeal" />
      <PropertyRef Name="CustomerId" />
      <PropertyRef Name="Name" />
      <PropertyRef Name="WorkloadId" />
    </Key>
    <Property Name="DispatchId" Type="Int32" Nullable="false" />
    <Property Name="BagSeal" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
    <Property Name="DispatchPackagesCount" Type="Int32" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="Name" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
  </EntityType>
  <EntityType Name="vwInvoiceCountsCondemned">
    <Key>
      <PropertyRef Name="InvoiceId" />
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="InventoryItemTypeId" />
      <PropertyRef Name="ItemType" />
      <PropertyRef Name="Category" />
      <PropertyRef Name="Size" />
      <PropertyRef Name="Categories_OrderPriority" />
      <PropertyRef Name="Size_OrderPriority" />
    </Key>
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="InventoryItemTypeId" Type="Int32" Nullable="false" />
    <Property Name="ItemType" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
    <Property Name="Category" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Size" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="InvoiceBadCount" Type="Int32" />
    <Property Name="CustomerItemCount" Type="Int32" />
    <Property Name="Cost" Type="Int32" />
    <Property Name="CostGeneralWash" Type="Int32" />
    <Property Name="CostRepeatWash" Type="Int32" />
    <Property Name="CostStainWash" Type="Int32" />
    <Property Name="Categories_OrderPriority" Type="Int32" Nullable="false" />
    <Property Name="Size_OrderPriority" Type="Int32" Nullable="false" />
  </EntityType>
  <EntityType Name="vwInvoicesReadyToPrint2">
    <Key>
      <PropertyRef Name="Id" />
      <PropertyRef Name="CustomerId" />
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="DateCreated" />
      <PropertyRef Name="OperatorLoginId" />
      <PropertyRef Name="InvoiceStatusId" />
      <PropertyRef Name="InvoiceType" />
      <PropertyRef Name="InvoiceId" />
      <PropertyRef Name="Printed" />
    </Key>
    <Property Name="Id" Type="Int32" Nullable="false" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="OperatorLoginId" Type="Int32" Nullable="false" />
    <Property Name="InvoiceStatusId" Type="Int32" Nullable="false" />
    <Property Name="InvoiceType" Type="String" Nullable="false" MaxLength="8" FixedLength="false" Unicode="false" />
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="Invoice" Type="String" MaxLength="73" FixedLength="false" Unicode="false" />
    <Property Name="Printed" Type="Boolean" Nullable="false" />
  </EntityType>
  <EntityType Name="vwDeliveryNoteCategoriesByBagSeal2">
    <Key>
      <PropertyRef Name="DispatchId" />
      <PropertyRef Name="InvoiceId" />
      <PropertyRef Name="BagSeal" />
      <PropertyRef Name="WorkloadId" />
    </Key>
    <Property Name="DispatchId" Type="Int32" Nullable="false" />
    <Property Name="InvoiceId" Type="Int32" Nullable="false" />
    <Property Name="BagSeal" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
    <Property Name="Categories" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
    <Property Name="WorkloadId" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
    <Property Name="DeliveryId" Type="Int32" />
  </EntityType>
  <ComplexType Name="GetCustomerPricingPercentages_Result">
    <Property Type="String" Name="Name" Nullable="false" MaxLength="100" />
    <Property Type="Double" Name="StainExpressPercentage" Nullable="false" />
    <Property Type="Double" Name="PriceIncreasePercentage" Nullable="false" />
  </ComplexType>
  <ComplexType Name="GetWorkloadInventoryForDispatches_Result">
    <Property Type="Int32" Name="CustomerId" Nullable="true" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="Int32" Name="ItemCount" Nullable="true" />
    <Property Type="Int32" Name="BadCount" Nullable="true" />
    <Property Type="Int32" Name="Category_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Size_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
    <Property Type="Int32" Name="CondemnedPrinted" Nullable="true" />
    <Property Type="Int32" Name="ItemCountStain" Nullable="true" />
  </ComplexType>
  <ComplexType Name="UpdateDeliveryId_Result">
    <Property Type="Int32" Name="CustomerId" Nullable="true" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="Int32" Name="ItemCount" Nullable="true" />
    <Property Type="Int32" Name="BadCount" Nullable="true" />
    <Property Type="Int32" Name="Category_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Size_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
  </ComplexType>
  <ComplexType Name="UpdateDispatchDelivery_Result">
    <Property Type="Int32" Name="Column1" Nullable="false" />
  </ComplexType>
  <ComplexType Name="GetWorkloadInventoryForDispatches2016_Result">
    <Property Type="Int32" Name="CustomerId" Nullable="true" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="Int32" Name="ItemCount" Nullable="true" />
    <Property Type="Int32" Name="BadCount" Nullable="true" />
    <Property Type="Int32" Name="Category_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Size_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
    <Property Type="Int32" Name="CondemnedPrinted" Nullable="true" />
  </ComplexType>
  <ComplexType Name="GetDeliveryNoteCategoriesByBagSeal_Result">
    <Property Type="Int32" Name="DispatchId" Nullable="false" />
    <Property Type="Int32" Name="InvoiceId" Nullable="false" />
    <Property Type="String" Name="BagSeal" Nullable="false" MaxLength="200" />
    <Property Type="String" Name="Categories" Nullable="true" />
    <Property Type="String" Name="WorkloadId" Nullable="true" MaxLength="50" />
  </ComplexType>
  <EntityType Name="vwDispatchesReadyToPrint">
    <Key>
      <PropertyRef Name="CustomerId" />
      <PropertyRef Name="WorkloadId" />
      <PropertyRef Name="DateCreated" />
    </Key>
    <Property Name="DeliveryId" Type="Int32" />
    <Property Name="CustomerId" Type="Int32" Nullable="false" />
    <Property Name="WorkloadId" Type="Int32" Nullable="false" />
    <Property Name="DateCreated" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="Dispatch" Type="String" MaxLength="73" FixedLength="false" Unicode="false" />
    <Property Name="DateDelivered" Type="DateTime" Precision="3" />
  </EntityType>
  <ComplexType Name="GetWorkloadInventoryForDelivery_Result">
    <Property Type="Int32" Name="CustomerId" Nullable="true" />
    <Property Type="Int32" Name="InventoryItemTypeId" Nullable="false" />
    <Property Type="String" Name="Category" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="String" Name="ItemType" Nullable="false" MaxLength="100" />
    <Property Type="Int32" Name="ItemCount" Nullable="true" />
    <Property Type="Int32" Name="BadCount" Nullable="true" />
    <Property Type="Int32" Name="Category_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Size_OrderPriority" Nullable="false" />
    <Property Type="Int32" Name="Cost" Nullable="true" />
    <Property Type="Int32" Name="CondemnedPrinted" Nullable="true" />
  </ComplexType>
  <ComplexType Name="GetDispatchesReadyToPrint_Result">
    <Property Type="Int32" Name="DeliveryId" Nullable="true" />
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="Int32" Name="WorkloadId" Nullable="false" />
    <Property Type="DateTime" Name="DateCreated" Nullable="false" Precision="23" />
    <Property Type="String" Name="Dispatch" Nullable="true" MaxLength="73" />
  </ComplexType>
  <ComplexType Name="GetDispatchesReadyToExport_Result">
    <Property Type="Int32" Name="DeliveryId" Nullable="true" />
    <Property Type="Int32" Name="CustomerId" Nullable="false" />
    <Property Type="DateTime" Name="DateDelivered" Nullable="true" Precision="23" />
    <Property Type="String" Name="Dispatch" Nullable="true" MaxLength="73" />
    <Property Type="String" Name="Reference" Nullable="true" MaxLength="50" />
  </ComplexType>
  <ComplexType Name="GetDuplicatePrelists_Result">
    <Property Type="String" Name="Reference" Nullable="true" MaxLength="50" />
    <Property Type="String" Name="Name" Nullable="false" MaxLength="100" />
    <Property Type="Int32" Name="DuplicateCount" Nullable="true" />
  </ComplexType>
  <EntityType Name="DispatchOperator">
    <Key>
      <PropertyRef Name="DeliveryId" />
      <PropertyRef Name="OperatorLoginId" />
      <PropertyRef Name="DeviceName" />
      <PropertyRef Name="LastEdit" />
    </Key>
    <Property Type="Int32" Name="DeliveryId" Nullable="false" />
    <Property Type="Int32" Name="OperatorLoginId" Nullable="false" />
    <Property Type="String" Name="DeviceName" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
    <Property Type="String" Name="PosPrinter" MaxLength="100" FixedLength="false" Unicode="false" />
    <Property Type="DateTime" Name="LastEdit" Nullable="false" Precision="3" />
  </EntityType>
  <ComplexType Name="rptOutstandingOrders_Items_Result">
    <Property Type="String" Name="CustomerId" Nullable="false" />
    <Property Type="String" Name="Pre_List_Number" Nullable="true" MaxLength="50" />
    <Property Type="String" Name="Item_Description" Nullable="false" MaxLength="100" />
    <Property Type="String" Name="Size" Nullable="false" MaxLength="50" />
    <Property Type="Int32" Name="Customer_Count" Nullable="false" />
    <Property Type="Int32" Name="Laundry_Count" Nullable="true" />
    <Property Type="Int32" Name="Clean_Delivery" Nullable="false" />
    <Property Type="Int32" Name="Stain_Delivery" Nullable="false" />
    <Property Type="Int32" Name="Returned_Undone" Nullable="false" />
    <Property Type="Int32" Name="Outstanding_Items" Nullable="false" />
  </ComplexType>
  <EntityType Name="VAT">
    <Key>
      <PropertyRef Name="VAT1" />
    </Key>
    <Property Name="VAT1" Type="Double" Nullable="false" />
  </EntityType>
  <ComplexType Name="rptBagReconDeliveries_Result">
    <Property Type="DateTime" Name="DateDelivered" Nullable="true" Precision="23" />
    <Property Type="String" Name="Reference" Nullable="true" MaxLength="50" />
    <Property Type="Int32" Name="DeliveryId" Nullable="true" />
    <Property Type="Int32" Name="TotalBags" Nullable="false" />
  </ComplexType>
  <ComplexType Name="rptBagReconPickups_Result">
    <Property Type="DateTime" Name="DateCreated" Nullable="false" Precision="23" />
    <Property Type="String" Name="reference" Nullable="true" MaxLength="50" />
    <Property Type="Int32" Name="TotalBags" Nullable="false" />
  </ComplexType>
</Schema>