Sales.BuyingGroups - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Sales
Name	BuyingGroups
Module	Sales

Customer organizations can be part of groups that exert greater buying power.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BuyingGroupID	int		Default: NEXT VALUE FOR [Sequences].[BuyingGroupID]		Numeric ID used for reference to a buying group within the database
Numeric ID used for reference to a buying group within the database Default: NEXT VALUE FOR [Sequences].[BuyingGroupID]
	2		BuyingGroupName	nvarchar(50)				Full name of a buying group that customers can be members of
Full name of a buying group that customers can be members of
	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
Sales.BuyingGroups		Application.People	Sales.BuyingGroups.LastEditedBy = Application.People.PersonID	FK_Sales_BuyingGroups_Application_People Foreign key constraint referencing People.PersonID
Sales.BuyingGroups.LastEditedBy = Application.People.PersonID Name: FK_Sales_BuyingGroups_Application_People Foreign key constraint referencing People.PersonID
Sales.Customers		Sales.BuyingGroups	Sales.Customers.BuyingGroupID = Sales.BuyingGroups.BuyingGroupID	FK_Sales_Customers_BuyingGroupID_Sales_BuyingGroups Foreign key constraint referencing BuyingGroups.BuyingGroupID
Sales.Customers.BuyingGroupID = Sales.BuyingGroups.BuyingGroupID Name: FK_Sales_Customers_BuyingGroupID_Sales_BuyingGroups Foreign key constraint referencing BuyingGroups.BuyingGroupID
Sales.SpecialDeals		Sales.BuyingGroups	Sales.SpecialDeals.BuyingGroupID = Sales.BuyingGroups.BuyingGroupID	FK_Sales_SpecialDeals_BuyingGroupID_Sales_BuyingGroups Foreign key constraint referencing BuyingGroups.BuyingGroupID
Sales.SpecialDeals.BuyingGroupID = Sales.BuyingGroups.BuyingGroupID Name: FK_Sales_SpecialDeals_BuyingGroupID_Sales_BuyingGroups Foreign key constraint referencing BuyingGroups.BuyingGroupID

Unique keys

	Key name	Columns	Description
	PK_Sales_BuyingGroups	BuyingGroupID	Primary key (clustered) constraint.
Primary key (clustered) constraint.
	UQ_Sales_BuyingGroups_BuyingGroupName	BuyingGroupName	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Sales.BuyingGroups
Application.People

Used by

Name
Sales.BuyingGroups
Sales.Customers
Sales.SpecialDeals

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