Northwind › Tables
Orders table
One row per order: who bought, which employee sold it, which shipper carried it. 830 rows.
Columns
| # | Name | Type | Not null | Default | Key | References |
|---|---|---|---|---|---|---|
| 0 | OrderID |
INTEGER |
no | — | PK | |
| 1 | CustomerID |
TEXT |
no | — | Customers.CustomerID | |
| 2 | EmployeeID |
INTEGER |
no | — | Employees.EmployeeID | |
| 3 | OrderDate |
TEXT |
no | — | ||
| 4 | RequiredDate |
TEXT |
no | — | ||
| 5 | ShippedDate |
TEXT |
no | — | ||
| 6 | ShipVia |
INTEGER |
no | — | Shippers.ShipperID | |
| 7 | Freight |
REAL |
no | 0 |
||
| 8 | ShipName |
TEXT |
no | — | ||
| 9 | ShipAddress |
TEXT |
no | — | ||
| 10 | ShipCity |
TEXT |
no | — | ||
| 11 | ShipRegion |
TEXT |
no | — | ||
| 12 | ShipPostalCode |
TEXT |
no | — | ||
| 13 | ShipCountry |
TEXT |
no | — |
Indexes
| Name | Columns | Unique | Created by |
|---|---|---|---|
Orders_ShipPostalCode |
ShipPostalCode |
no | CREATE INDEX |
Orders_ShipVia |
ShipVia |
no | CREATE INDEX |
Orders_ShippedDate |
ShippedDate |
no | CREATE INDEX |
Orders_OrderDate |
OrderDate |
no | CREATE INDEX |
Orders_EmployeeID |
EmployeeID |
no | CREATE INDEX |
Orders_CustomerID |
CustomerID |
no | CREATE INDEX |
Referenced by
Order Details.OrderID → Orders.OrderID
Definition
CREATE TABLE Orders (
OrderID INTEGER PRIMARY KEY,
CustomerID TEXT REFERENCES Customers (CustomerID),
EmployeeID INTEGER REFERENCES Employees (EmployeeID),
OrderDate TEXT,
RequiredDate TEXT,
ShippedDate TEXT,
ShipVia INTEGER REFERENCES Shippers (ShipperID),
Freight REAL DEFAULT 0,
ShipName TEXT,
ShipAddress TEXT,
ShipCity TEXT,
ShipRegion TEXT,
ShipPostalCode TEXT,
ShipCountry TEXT
)