Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

LISTING Table

Column Name Data Type Description
LISTID INTEGER Primary key, a unique ID value for each row. Each row represents a listing of a batch of tickets for a specific event.
SELLERID INTEGER Foreign-key reference to the USERS table, identifying the user who is selling the tickets.
EVENTID INTEGER Foreign-key reference to the EVENT table.
DATEID SMALLINT Foreign-key reference to the DATE table.
NUMTICKETS SMALLINT The number of tickets available for sale, such as 2 or 20.
PRICEPERTICKET DECIMAL(8,2) The fixed price of an individual ticket, such as 27.00 or 206.00.
TOTALPRICE DECIMAL(8,2) The total price for this listing (NUMTICKETS*PRICEPERTICKET).
LISTTIME TIMESTAMP The full date and time when the listing was posted, such as 2008-03-18 07:19:35.