Customers
| customerName | contactLastName | contactFirstName | phone | addressLine1 | addressLine2 | city | state | postalCode | country | Sales Employee | creditLimit |
|---|
Employees
| lastName | firstName | extension | email | reportsTo | jobTitle |
|---|
Offices
| city | phone | addressLine1 | addressLine2 | state | country | postalCode | territory |
|---|
Orderdetails
| orderNumber | quantityOrdered | priceEach | orderLineNumber |
|---|
Orders
| orderNumber | orderDate | requiredDate | shippedDate | status | comments |
|---|
Payments
| checkNumber | paymentDate | amount |
|---|
Productlines
| productLine | textDescription | htmlDescription | image |
|---|
Products
| productName | productLine | productScale | productVendor | productDescription | quantityInStock | buyPrice | MSRP |
|---|