| Invoice | ||
|---|---|---|
| Invoice_Number | Customer_Number | Payment |
| INTEGER | INTEGER | DECIMAL(10,2) |
| 11731 | 3175 | 0 |
| 11732 | 3176 | 249.5 |
| 11733 | 3175 | 0 |
| Customer | |||||
|---|---|---|---|---|---|
| Customer_Number | Name | Address | City | State | Zip |
| INTEGER | CHAR(40) | CHAR(40) | CHAR(30) | CHAR(2) | CHAR(10) |
| 3175 | Sam's Small Appliances | 100 Main St. | Anytown | CA | 98765 |
| 3176 | Electronics Unlimited | 1175 Liberty Ave. | Pleasantville | MI | 45066 |