Northwind › Tables
Suppliers table
Companies Northwind buys from. Each product has exactly one supplier. 29 rows.
Columns
| # | Name | Type | Not null | Default | Key | References |
|---|---|---|---|---|---|---|
| 0 | SupplierID |
INTEGER |
no | — | 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 | — | ||
| 11 | HomePage |
TEXT |
no | — |
Indexes
| Name | Columns | Unique | Created by |
|---|---|---|---|
Suppliers_PostalCode |
PostalCode |
no | CREATE INDEX |
Suppliers_CompanyName |
CompanyName |
no | CREATE INDEX |
Referenced by
Products.SupplierID → Suppliers.SupplierID
Definition
CREATE TABLE Suppliers (
SupplierID INTEGER PRIMARY KEY,
CompanyName TEXT NOT NULL,
ContactName TEXT,
ContactTitle TEXT,
Address TEXT,
City TEXT,
Region TEXT,
PostalCode TEXT,
Country TEXT,
Phone TEXT,
Fax TEXT,
HomePage TEXT
)