|
Table Name: customers |
||||||
|
cust-id |
cust-name |
business-line |
credit-ok |
addr-1 |
addr-2 |
addr-3 |
|
37666 |
Initech Inc |
Tech |
Good |
|
Table Name: orders_placed |
|||||||
|
order-nbr |
Status |
po-nbr |
date-ordered |
ship-date |
invoice-date |
due |
branch |
|
2008-000201 |
C |
S-2008-547 |
2008-02-27 |
|
Table Name: orders_placed |
||
|
cust-id |
order-nbr |
sales-channel |
|
37666 |
2008-000201 |
Phone |
|
Table Name: order_details |
|||
|
order-nbr |
line-item |
quantity |
product-code |
|
2008-000201 |
4 |
5 |
D12345 |
|
Table Name: products |
||
|
product-code |
product-desc |
price |
|
D12345 |
Stapling Unit |
10.50 |