Application.DeliveryMethods - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Application
Name	DeliveryMethods
Module	Application

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

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		DeliveryMethodID	int		Default: NEXT VALUE FOR [Sequences].[DeliveryMethodID]		Numeric ID used for reference to a delivery method within the database
Numeric ID used for reference to a delivery method within the database Default: NEXT VALUE FOR [Sequences].[DeliveryMethodID]
	2		DeliveryMethodName	nvarchar(50)				Full name of methods that can be used for delivery of customer orders
Full name of methods that can be used for delivery of customer orders
	3		LastEditedBy	int			Application.People
References: Application.People
	4		ValidFrom	datetime2(7)				Valid from this date and time
Valid from this date and time
	5		ValidTo	datetime2(7)				Valid until this date and time
Valid until this date and time

Relations

Foreign table		Primary table	Join	Title / Name / Description
Application.DeliveryMethods		Application.People	Application.DeliveryMethods.LastEditedBy = Application.People.PersonID	FK_Application_DeliveryMethods_Application_People Foreign key constraint referencing People.PersonID
Application.DeliveryMethods.LastEditedBy = Application.People.PersonID Name: FK_Application_DeliveryMethods_Application_People Foreign key constraint referencing People.PersonID
Sales.Customers		Application.DeliveryMethods	Sales.Customers.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID	FK_Sales_Customers_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Sales.Customers.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID Name: FK_Sales_Customers_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Sales.Invoices		Application.DeliveryMethods	Sales.Invoices.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID	FK_Sales_Invoices_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Sales.Invoices.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID Name: FK_Sales_Invoices_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Purchasing.PurchaseOrders		Application.DeliveryMethods	Purchasing.PurchaseOrders.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID	FK_Purchasing_PurchaseOrders_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Purchasing.PurchaseOrders.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID Name: FK_Purchasing_PurchaseOrders_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Purchasing.Suppliers		Application.DeliveryMethods	Purchasing.Suppliers.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID	FK_Purchasing_Suppliers_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Purchasing.Suppliers.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID Name: FK_Purchasing_Suppliers_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID

Unique keys

	Key name	Columns	Description
	PK_Application_DeliveryMethods	DeliveryMethodID	Primary key (clustered) constraint.
Primary key (clustered) constraint.
	UQ_Application_DeliveryMethods_DeliveryMethodName	DeliveryMethodName	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Application.DeliveryMethods
Application.People

Used by

Name
Application.DeliveryMethods
Purchasing.PurchaseOrders
Purchasing.Suppliers
Sales.Customers
Sales.Invoices

Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51