Databases > WideWorldImporters > Tables > Sales.CustomerCategories

WideWorldImporters

Sales.CustomerCategories

//
Categories for customers (ie restaurants, cafes, supermarkets, etc.)

SYSTEM VERSIONED

Created: Modified:

Columns

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

Indexes

  • PK_Sales_CustomerCategories
    UNIQUE CLUSTERED
    CustomerCategoryID
  • UQ_Sales_CustomerCategories_CustomerCategoryName
    UNIQUE NONCLUSTERED
    CustomerCategoryName

Foreign Keys

  • FK_Sales_CustomerCategories_Application_People
    Application.People
    LastEditedBy ⥱ PersonID

Sample Data

CustomerCategoryID
CustomerCategoryName
LastEditedBy
ValidFrom
ValidTo
1
Agent
1
2
Wholesaler
1
3
Novelty Shop
1
4
Supermarket
1
5
Computer Store
1
6
Gift Store
1
7
Corporate
1
8
General Retailer
9