| Column name |
Data type |
Description
|
| SALESID
|
INTEGER
|
Primary key, a unique ID value for each row.
Each row represents a sale of one or more tickets for a specific event, as
offered in a specific listing.
|
| LISTID
|
INTEGER
|
Foreign-key reference to the LISTING table.
|
| SELLERID
|
INTEGER
|
Foreign-key reference to the USERS table (the
user who sold the tickets).
|
| BUYERID
|
INTEGER
|
Foreign-key reference to the USERS table (the
user who bought the tickets).
|
| EVENTID
|
INTEGER
|
Foreign-key reference to the EVENT table.
|
| DATEID
|
SMALLINT
|
Foreign-key reference to the DATE table.
|
| QTYSOLD
|
SMALLINT
|
The number of tickets that were sold, from
1 to
8. (A maximum of 8 tickets can be sold in
a single transaction.)
|
| PRICEPAID
|
DECIMAL(8,2)
|
The total price paid for the tickets, such as
75.00 or
488.00. The individual price of a ticket
is PRICEPAID/QTYSOLD.
|
| COMMISSION
|
DECIMAL(8,2)
|
The 15% commission that the business collects
from the sale, such as
11.25 or
73.20. The seller receives 85% of the
PRICEPAID value.
|
| SALETIME
|
TIMESTAMP
|
The full date and time when the sale was
completed, such as
2008-05-24 06:21:47.
|