public.users

Documentation	Tickit
Name	users
Module	Tickit diagram

Each row represents a registered user (a buyer or seller or both) who has listed or bought tickets for at least one event.

Columns

		Name	Data type	Description
	1	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.
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.
	2	username	character(8)	An 8-character alphanumeric username, such as PGL08LJI.
An 8-character alphanumeric username, such as PGL08LJI.
	3	firstname	character varying(30)	The user's first name, such as Victor.
The user's first name, such as Victor.
	4	lastname	character varying(30)	The user's last name, such as Hernandez.
The user's last name, such as Hernandez.
	5	city	character varying(30)	The user's home city, such as Naperville.
The user's home city, such as Naperville.
	6	state	character(2)	The user's home state, such as GA.
The user's home state, such as GA.
	7	email	character varying(100)	The user's email address; this column contains random Latin values, such as turpis@accumsanlaoreet.org.
The user's email address; this column contains random Latin values, such as turpis@accumsanlaoreet.org.
	8	phone	character(14)	The user's 14-character phone number, such as (818) 765-4255.
The user's 14-character phone number, such as (818) 765-4255.
	9	likesports	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.
	10	liketheatre	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.
	11	likeconcerts	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.
	12	likejazz	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.
	13	likeclassical	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.
	14	likeopera	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.
	15	likerock	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.
	16	likevegas	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.
	17	likebroadway	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.
	18	likemusicals	boolean	A series of 10 different columns that identify the user's likes and dislikes with true and false values.
A series of 10 different columns that identify the user's likes and dislikes with true and false values.

Relations

Foreign table	Primary table	Join	Title / Name / Description
public.listing	public.users	public.listing.sellerid = public.users.userid	fk_users_listing
public.listing.sellerid = public.users.userid Name: fk_users_listing
public.sales	public.users	public.sales.sellerid = public.users.userid	fk_users_sales
public.sales.sellerid = public.users.userid Name: fk_users_sales
public.sales	public.users	public.sales.buyerid = public.users.userid	fk_users_sales
public.sales.buyerid = public.users.userid Name: fk_users_sales

Unique keys

	Key name	Columns	Description
	pk_users	userid

Used by

Name
public.users
public.listing
public.sales
public.sales

Exported: 2018-10-12 23:27, Last imported: 2018-10-01 10:44