Databases > WideWorldImporters > Tables > Warehouse.StockGroups

WideWorldImporters

Warehouse.StockGroups

//
Groups for categorizing stock items (ie: novelties, toys, edible novelties, etc.)

SYSTEM VERSIONED

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    StockGroupID
    [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[StockGroupID])
  • //
    ${escapify(column.description)}
    StockGroupName
    [nvarchar](50) NOT NULL
  • LastEditedBy
    [int] NOT NULL
  • ValidFrom
    [datetime2](8) NOT NULL
  • ValidTo
    [datetime2](8) NOT NULL

Indexes

  • PK_Warehouse_StockGroups
    UNIQUE CLUSTERED
    StockGroupID
  • UQ_Warehouse_StockGroups_StockGroupName
    UNIQUE NONCLUSTERED
    StockGroupName

Foreign Keys

  • FK_Warehouse_StockGroups_Application_People
    Application.People
    LastEditedBy ⥱ PersonID

Sample Data

StockGroupID
StockGroupName
LastEditedBy
ValidFrom
ValidTo
1
Novelty Items
1
2
Clothing
1
3
Mugs
1
4
T-Shirts
1
5
Airline Novelties
1
6
Computing Novelties
1
7
USB Novelties
1
8
Furry Footwear
9
9
Toys
1
10
Packaging Materials
1