Warehouse.StockGroups - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Warehouse
Name	StockGroups
Module	Warehouse

Groups for categorizing stock items (e.g., novelties, toys, edible novelties, etc.)

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		StockGroupID	int		Default: NEXT VALUE FOR [Sequences].[StockGroupID]		Numeric ID used for reference to a stock group within the database
Numeric ID used for reference to a stock group within the database Default: NEXT VALUE FOR [Sequences].[StockGroupID]
	2		StockGroupName	nvarchar(50)				Full name of groups used to categorize stock items
Full name of groups used to categorize stock items
	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
Warehouse.StockGroups		Application.People	Warehouse.StockGroups.LastEditedBy = Application.People.PersonID	FK_Warehouse_StockGroups_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockGroups.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_StockGroups_Application_People Foreign key constraint referencing People.PersonID
Sales.SpecialDeals		Warehouse.StockGroups	Sales.SpecialDeals.StockGroupID = Warehouse.StockGroups.StockGroupID	FK_Sales_SpecialDeals_StockGroupID_Warehouse_StockGroups Foreign key constraint referencing StockGroups.StockGroupID
Sales.SpecialDeals.StockGroupID = Warehouse.StockGroups.StockGroupID Name: FK_Sales_SpecialDeals_StockGroupID_Warehouse_StockGroups Foreign key constraint referencing StockGroups.StockGroupID
Warehouse.StockItemStockGroups		Warehouse.StockGroups	Warehouse.StockItemStockGroups.StockGroupID = Warehouse.StockGroups.StockGroupID	FK_Warehouse_StockItemStockGroups_StockGroupID_Warehouse_StockGroups Foreign key constraint referencing StockGroups.StockGroupID
Warehouse.StockItemStockGroups.StockGroupID = Warehouse.StockGroups.StockGroupID Name: FK_Warehouse_StockItemStockGroups_StockGroupID_Warehouse_StockGroups Foreign key constraint referencing StockGroups.StockGroupID

Unique keys

	Key name	Columns	Description
	PK_Warehouse_StockGroups	StockGroupID	Primary key (clustered) constraint.
Primary key (clustered) constraint.
	UQ_Warehouse_StockGroups_StockGroupName	StockGroupName	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Warehouse.StockGroups
Application.People

Used by

Name
Warehouse.StockGroups
Sales.SpecialDeals
Warehouse.StockItemStockGroups

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