Databases > WideWorldImporters > Tables > Application.DeliveryMethods

WideWorldImporters

Application.DeliveryMethods

//
Ways that stock items can be delivered (ie: truck/van, post, pickup, courier, etc.

SYSTEM VERSIONED

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    DeliveryMethodID
    [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[DeliveryMethodID])
  • //
    ${escapify(column.description)}
    DeliveryMethodName
    [nvarchar](50) NOT NULL
  • LastEditedBy
    [int] NOT NULL
  • ValidFrom
    [datetime2](8) NOT NULL
  • ValidTo
    [datetime2](8) NOT NULL

Indexes

  • PK_Application_DeliveryMethods
    UNIQUE CLUSTERED
    DeliveryMethodID
  • UQ_Application_DeliveryMethods_DeliveryMethodName
    UNIQUE NONCLUSTERED
    DeliveryMethodName

Foreign Keys

  • FK_Application_DeliveryMethods_Application_People
    Application.People
    LastEditedBy ⥱ PersonID

Sample Data

DeliveryMethodID
DeliveryMethodName
LastEditedBy
ValidFrom
ValidTo
1
Post
1
2
Courier
1
3
Delivery Van
1
4
Customer Collect
1
5
Chilled Van
16
6
Customer Courier to Collect
1
7
Road Freight
1
8
Air Freight
1
9
Refrigerated Road Freight
1
10
Refrigerated Air Freight
1