Generated using SQL Data Dictionary demo version.
Stock items can (optionally) have colors
Column | Data Type | Identity | Nullable | Default | |
---|---|---|---|---|---|
PK | ColorID | int | NEXT VALUE FOR [Sequences].[ColorID] | ||
Numeric ID used for reference to a color within the database | |||||
UK | ColorName | nvarchar(20) | |||
Full name of a color that can be used to describe stock items | |||||
FK | LastEditedBy | int | |||
ValidFrom | datetime2 | ||||
ValidTo | datetime2 |