Database Tables

Orders Table

OrderID ClientID RowA RowB RowC RowD RowE RowF RowG RowH RowI Shipping
110022000100
225000006000
332000000000
440035200000

Tickets Table

row_id row_price row_cat row_sold
a5017
b5010
c5015
d4027
e4022
f4020
g3036
h3031
i3030

Clients Table

client_id fname lname email street zip city state
1JohnSmithtestemail@gmail.com1600 Amphitheatre Parkway94043Mountain ViewCA
2JohnSmithtestemail@gmail.com1600 Amphitheatre Parkway94043Mountain ViewCA
3JohnSmithtestemail@gmail.com1600 Amphitheatre Parkway94043Mountain ViewCA
4TimSmithtestemail@gmail.com1600 Amphitheatre Parkway94043Mountain ViewCA