Database Tables
Orders Table
| OrderID | ClientID | RowA | RowB | RowC | RowD | RowE | RowF | RowG | RowH | RowI | Shipping |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 1 | 0 | 0 |
| 2 | 2 | 5 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 |
Tickets Table
| row_id | row_price | row_cat | row_sold |
|---|---|---|---|
| a | 50 | 1 | 5 |
| b | 50 | 1 | 0 |
| c | 50 | 1 | 2 |
| d | 40 | 2 | 2 |
| e | 40 | 2 | 0 |
| f | 40 | 2 | 0 |
| g | 30 | 3 | 6 |
| h | 30 | 3 | 1 |
| i | 30 | 3 | 0 |
Clients Table
| client_id | fname | lname | street | zip | city | state | |
|---|---|---|---|---|---|---|---|
| 1 | John | Smith | testemail@gmail.com | 1600 Amphitheatre Parkway | 94043 | Mountain View | CA |
| 2 | John | Smith | testemail@gmail.com | 1600 Amphitheatre Parkway | 94043 | Mountain View | CA |