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 .
|