Warehouse.StockItemStockGroups

Generated using SQL Data Dictionary demo version.

Table Warehouse.StockItemStockGroups (442 rows)

Which stock items are in which stock groups

	Column	Data Type	Identity	Nullable	Default
PK	StockItemStockGroupID	int			NEXT VALUE FOR [Sequences].[StockItemStockGroupID]
Internal reference for this linking row
UK, FK	StockItemID	int
Stock item assigned to this stock group (FK indexed via unique constraint)
UK, FK	StockGroupID	int
StockGroup assigned to this stock item (FK indexed via unique constraint)
FK	LastEditedBy	int
	LastEditedWhen	datetime2			sysdatetime()

Indexes:

PK_Warehouse_StockItemStockGroups
- (Primary Key)
- (Clustered)
- (0.23% Selectivity)
- StockItemStockGroupID

UQ_StockItemStockGroups_StockGroupID_Lookup
- (Unique)
- (0.23% Selectivity)
- StockGroupID
- StockItemID

UQ_StockItemStockGroups_StockItemID_Lookup
- (Unique)
- (0.23% Selectivity)
- StockItemID
- StockGroupID

References:

Application.People
- PersonID (LastEditedBy)

Warehouse.StockGroups
- StockGroupID

Warehouse.StockItems
- StockItemID

Used by:

Function
Website.CalculateCustomerPrice
- StockGroupID
- StockItemID