Orders (Created 8/6/2000 1:34:06 AM)
Description: This table contains all of the orders.
Key | ID | Name | Data Type | Size(Precision,Scale) | Nulls | Default
|  | OrderID | int | 0 |  |
| The primary key for each order.
|  | CustomerID | nchar | 5 |  |
| The customer for this order.
|  | EmployeeID | int | 0 |  |
| The salesman for this order.
|  | OrderDate | datetime | 0 |  |
| The date the order was placed.
|  | RequiredDate | datetime | 0 |  |
| The date that the order is required.
|  | ShippedDate | datetime | 0 |  |
| The date that the order was shipped.
|  | ShipVia | int | 0 |  |
| The shipping method for this order.
|  | Freight | money | 0 |  | (0)
| The cost to ship this order.
|  | ShipName | nvarchar | 40 |  |
| The person's name to ship this order to.
|  | ShipAddress | nvarchar | 60 |  |
| The street address to ship the order to.
|  | ShipCity | nvarchar | 15 |  |
| The city to ship the order to.
|  | ShipRegion | nvarchar | 15 |  |
| The region to ship the order to.
|  | ShipPostalCode | nvarchar | 10 |  |
| The postal code to ship the order to.
|  | ShipCountry | nvarchar | 15 |  |
| The country to ship the order to.