Column name |
Data type |
Description
|
USERID
|
INTEGER
|
Primary key, a unique ID value for each row.
Each row represents a registered user (a buyer or seller or both) who has
listed or bought tickets for at least one event.
|
USERNAME
|
CHAR(8)
|
An 8-character alphanumeric username, such as
PGL08LJI .
|
FIRSTNAME
|
VARCHAR(30)
|
The user's first name, such as
Victor .
|
LASTNAME
|
VARCHAR(30)
|
The user's last name, such as
Hernandez .
|
CITY
|
VARCHAR(30)
|
The user's home city, such as
Naperville .
|
STATE
|
CHAR(2)
|
The user's home state, such as
GA .
|
EMAIL
|
VARCHAR(100)
|
The user's email address; this column
contains random Latin values, such as
turpis@accumsanlaoreet.org .
|
PHONE
|
CHAR(14)
|
The user's 14-character phone number, such as
(818) 765-4255 .
|
LIKESPORTS, ...
|
BOOLEAN
|
A series of 10 different columns that
identify the user's likes and dislikes with
true and
false values.
|