Warehouse.StockItemStockGroups - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Warehouse
Name	StockItemStockGroups
Module	Warehouse

Which stock items are in which stock groups (many to many)

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		StockItemStockGroupID	int		Default: NEXT VALUE FOR [Sequences].[StockItemStockGroupID]		Internal reference for this linking row
Internal reference for this linking row Default: NEXT VALUE FOR [Sequences].[StockItemStockGroupID]
	2		StockItemID	int			Warehouse.StockItems	Stock item assigned to this stock group (FK indexed via unique constraint)
Stock item assigned to this stock group (FK indexed via unique constraint) References: Warehouse.StockItems
	3		StockGroupID	int			Warehouse.StockGroups	StockGroup assigned to this stock item (FK indexed via unique constraint)
StockGroup assigned to this stock item (FK indexed via unique constraint) References: Warehouse.StockGroups
	4		LastEditedBy	int			Application.People
References: Application.People
	5		LastEditedWhen	datetime2(7)		Default: sysdatetime()		When this row was last edited
When this row was last edited Default: sysdatetime()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Warehouse.StockItemStockGroups		Application.People	Warehouse.StockItemStockGroups.LastEditedBy = Application.People.PersonID	FK_Warehouse_StockItemStockGroups_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItemStockGroups.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_StockItemStockGroups_Application_People Foreign key constraint referencing People.PersonID
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
Warehouse.StockItemStockGroups		Warehouse.StockItems	Warehouse.StockItemStockGroups.StockItemID = Warehouse.StockItems.StockItemID	FK_Warehouse_StockItemStockGroups_StockItemID_Warehouse_StockItems Foreign key constraint referencing StockItems.StockItemID
Warehouse.StockItemStockGroups.StockItemID = Warehouse.StockItems.StockItemID Name: FK_Warehouse_StockItemStockGroups_StockItemID_Warehouse_StockItems Foreign key constraint referencing StockItems.StockItemID

Unique keys

	Key name	Columns	Description
	PK_Warehouse_StockItemStockGroups	StockItemStockGroupID	Primary key (clustered) constraint.
Primary key (clustered) constraint.
	UQ_StockItemStockGroups_StockGroupID_Lookup	StockGroupID, StockItemID	Unique nonclustered index.
Unique nonclustered index.
	UQ_StockItemStockGroups_StockItemID_Lookup	StockItemID, StockGroupID	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Warehouse.StockItemStockGroups
Application.People
Warehouse.StockGroups
Warehouse.StockItems

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