Table cartticket

web interface: stores the tickets in the cart

Column NameTypePropertiesDocu
cartidstring:32Primary-Key Foreign-Key=cart(cartid) the cart the ticket is in
eventidint32Primary-Key Foreign-Key=event(eventid) the event the ticket is for
pricecategoryidint32Primary-Key Foreign-Key=pricecategory(pricecategoryid) the price category of the ticket
origpricecategoryidint32NULL-able Foreign-Key=pricecategory(pricecategoryid) the price category of the ticket
amountint32amount of tickets of this type in the cart
seatingstring:255NULL-able