Northwind › Tables
CustomerDemographics table
Customer types. Empty in Microsoft's data, kept to show the design. 0 rows.
Columns
| # | Name | Type | Not null | Default | Key | References |
|---|---|---|---|---|---|---|
| 0 | CustomerTypeID |
TEXT |
yes | — | PK | |
| 1 | CustomerDesc |
TEXT |
no | — |
Indexes
| Name | Columns | Unique | Created by |
|---|---|---|---|
sqlite_autoindex_CustomerDemographics_1 |
CustomerTypeID |
yes | PRIMARY KEY |
Referenced by
CustomerCustomerDemo.CustomerTypeID → CustomerDemographics.CustomerTypeID
Definition
CREATE TABLE CustomerDemographics (
CustomerTypeID TEXT NOT NULL PRIMARY KEY,
CustomerDesc TEXT
)