| 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) |
||
| 1The composite primary key is defined on CustomerID, CustomerTypeID. | |||||