Orders

830 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OrderID INTEGER 2000000000,10 null
Invoices.OrderID Implied ConstraintR
Order Details.OrderID R
Order Details Extended.OrderID Implied ConstraintR
Order Subtotals.OrderID Implied ConstraintR
Orders Qry.OrderID Implied ConstraintR
Sales Totals by Amount.OrderID Implied ConstraintR
Summary of Sales by Quarter.OrderID Implied ConstraintR
Summary of Sales by Year.OrderID Implied ConstraintR
CustomerID TEXT 2000000000,10 null
Customers.CustomerID R
EmployeeID INTEGER 2000000000,10 null
Employees.EmployeeID R
OrderDate DATETIME 2000000000,10 null
RequiredDate DATETIME 2000000000,10 null
ShippedDate DATETIME 2000000000,10 null
ShipVia INTEGER 2000000000,10 null
Shippers.ShipperID R
Freight NUMERIC 2000000000,10 0
ShipName TEXT 2000000000,10 null
ShipAddress TEXT 2000000000,10 null
ShipCity TEXT 2000000000,10 null
ShipRegion TEXT 2000000000,10 null
ShipPostalCode TEXT 2000000000,10 null
ShipCountry TEXT 2000000000,10 null

Indexes

Constraint Name Type Sort Column(s)
Orders_s_pk Primary key Asc OrderID

Relationships