Databases > WideWorldImporters > Tables > Warehouse.StockItemStockGroups

WideWorldImporters

Warehouse.StockItemStockGroups

//
Which stock items are in which stock groups

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    StockItemStockGroupID
    [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[StockItemStockGroupID])
  • //
    ${escapify(column.description)}
    StockItemID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    StockGroupID
    [int] NOT NULL
  • LastEditedBy
    [int] NOT NULL
  • LastEditedWhen
    [datetime2](8) NOT NULL DEFAULT (sysdatetime())

Indexes

  • PK_Warehouse_StockItemStockGroups
    UNIQUE CLUSTERED
    StockItemStockGroupID
  • UQ_StockItemStockGroups_StockItemID_Lookup
    UNIQUE NONCLUSTERED
    StockItemID , StockGroupID
  • UQ_StockItemStockGroups_StockGroupID_Lookup
    UNIQUE NONCLUSTERED
    StockGroupID , StockItemID

Foreign Keys

  • FK_Warehouse_StockItemStockGroups_Application_People
    Application.People
    LastEditedBy ⥱ PersonID
  • FK_Warehouse_StockItemStockGroups_StockGroupID_Warehouse_StockGroups
    Warehouse.StockGroups
    StockGroupID ⥱ StockGroupID
  • FK_Warehouse_StockItemStockGroups_StockItemID_Warehouse_StockItems
    Warehouse.StockItems
    StockItemID ⥱ StockItemID

Sample Data

StockItemStockGroupID
StockItemID
StockGroupID
LastEditedBy
LastEditedWhen
1
1
6
1
2
1
1
1
3
1
7
1
4
2
6
1
5
2
1
1
6
2
7
1
7
3
6
1
8
3
1
1
9
4
6
1
10
4
1
1
11
4
7
1
12
5
6
1
13
5
1
1
14
5
7
1
15
6
6
1
16
6
1
1
17
6
7
1
18
7
6
1
19
7
1
1
20
7
7
1
21
8
6
1
22
8
1
1
23
8
7
1
24
9
6
1
25
9
1
1