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()



Used by: