September 2007
Intermediate to advanced
600 pages
20h 21m
English
The MerchandiseOrders table stores online merchandise order information. MerchandiseOrders contains the columns in Table B.10.
| Column | Datatype | Description |
|---|---|---|
| OrderID | Numeric (Identity) | Unique order ID |
| ContactID | Numeric | Buyer contact ID |
| OrderDate | Date Time | Order date |
| ShipAddress | Text (100 chars) | Ship to address |
| ShipCity | Text (50 chars) | Ship to city |
| ShipState | Text (5 chars) | Ship to state |
| ShipZip | Text (10 chars) | Ship to ZIP |
| ShipCountry | Text (50 chars) | Ship to country |
| ShipDate | Date Time | Ship date |
OrderID
ContactID related to primary key in Contacts table
Read now
Unlock full access