Northwind › Tables
Customers table
Companies that buy from Northwind. A five-letter text key (ALFKI) instead of a number. 91 rows.
Columns
| # | Name | Type | Not null | Default | Key | References |
|---|---|---|---|---|---|---|
| 0 | CustomerID |
TEXT |
yes | — | PK | |
| 1 | CompanyName |
TEXT |
yes | — | ||
| 2 | ContactName |
TEXT |
no | — | ||
| 3 | ContactTitle |
TEXT |
no | — | ||
| 4 | Address |
TEXT |
no | — | ||
| 5 | City |
TEXT |
no | — | ||
| 6 | Region |
TEXT |
no | — | ||
| 7 | PostalCode |
TEXT |
no | — | ||
| 8 | Country |
TEXT |
no | — | ||
| 9 | Phone |
TEXT |
no | — | ||
| 10 | Fax |
TEXT |
no | — |
Indexes
| Name | Columns | Unique | Created by |
|---|---|---|---|
Customers_Region |
Region |
no | CREATE INDEX |
Customers_PostalCode |
PostalCode |
no | CREATE INDEX |
Customers_CompanyName |
CompanyName |
no | CREATE INDEX |
Customers_City |
City |
no | CREATE INDEX |
sqlite_autoindex_Customers_1 |
CustomerID |
yes | PRIMARY KEY |
Referenced by
Orders.CustomerID → Customers.CustomerID
CustomerCustomerDemo.CustomerID → Customers.CustomerID
Definition
CREATE TABLE Customers (
CustomerID TEXT NOT NULL PRIMARY KEY,
CompanyName TEXT NOT NULL,
ContactName TEXT,
ContactTitle TEXT,
Address TEXT,
City TEXT,
Region TEXT,
PostalCode TEXT,
Country TEXT,
Phone TEXT,
Fax TEXT
)