Databases > WideWorldImporters > Tables > Purchasing.SupplierCategories

WideWorldImporters

Purchasing.SupplierCategories

//
Categories for suppliers (ie novelties, toys, clothing, packaging, etc.)

SYSTEM VERSIONED

Created: Modified:

Columns

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

Indexes

  • PK_Purchasing_SupplierCategories
    UNIQUE CLUSTERED
    SupplierCategoryID
  • UQ_Purchasing_SupplierCategories_SupplierCategoryName
    UNIQUE NONCLUSTERED
    SupplierCategoryName

Foreign Keys

  • FK_Purchasing_SupplierCategories_Application_People
    Application.People
    LastEditedBy ⥱ PersonID

Sample Data

SupplierCategoryID
SupplierCategoryName
LastEditedBy
ValidFrom
ValidTo
1
Other Wholesaler
1
2
Novelty Goods Supplier
1
3
Toy Supplier
1
4
Clothing Supplier
1
5
Packaging Supplier
1
6
Courier Services Supplier
16
7
Financial Services Supplier
1
8
Marketing Services Supplier
1
9
Insurance Services Supplier
1