| Column_name | Data type | Nullable | Default | Check | Key/index |
| CustomerID | nchar(5) | no | | | Composite PK nonclust1,
FK Customers(CustomerID) |
| CustomerTypeID | nchar(10) | no | | | Composite PK nonclust1,
FK CustomerDemographics(CustomerTypeID) |
1 The composite primary key is defined on CustomerID, CustomerTypeID.
