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 | ||||