Generated using SQL Data Dictionary demo version.
Categories for customers (ie restaurants, cafes, supermarkets, etc.)
| Column | Data Type | Identity | Nullable | Default | |
|---|---|---|---|---|---|
| PK | CustomerCategoryID | int | NEXT VALUE FOR [Sequences].[CustomerCategoryID] | ||
| Numeric ID used for reference to a customer category within the database | |||||
| UK | CustomerCategoryName | nvarchar(50) | |||
| Full name of the category that customers can be assigned to | |||||
| FK | LastEditedBy | int | |||
| ValidFrom | datetime2 | ||||
| ValidTo | datetime2 | ||||