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 |