Databases > WideWorldImporters > Tables > Warehouse.Colors

WideWorldImporters

Warehouse.Colors

//
Stock items can (optionally) have colors

SYSTEM VERSIONED

Created: Modified:

Columns

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

Indexes

  • PK_Warehouse_Colors
    UNIQUE CLUSTERED
    ColorID
  • UQ_Warehouse_Colors_ColorName
    UNIQUE NONCLUSTERED
    ColorName

Foreign Keys

  • FK_Warehouse_Colors_Application_People
    Application.People
    LastEditedBy ⥱ PersonID

Sample Data

ColorID
ColorName
LastEditedBy
ValidFrom
ValidTo
1
Azure
1
2
Beige
1
3
Black
1
4
Blue
1
5
Charcoal
1
6
Chartreuse
1
7
Cyan
1
8
Dark Brown
1
9
Dark Green
1
10
Fuchsia
1
11
Gold
1
12
Steel Gray
9
13
Hot Pink
1
14
Indigo
1
15
Ivory
1
16
Khaki
1
17
Lavender
1
18
Light Brown
1
19
Light Green
1
20
Maroon
1
21
Mauve
1
22
Navy Blue
1
23
Olive
1
24
Orange
1
25
Plum
1