Database Schema - rzh150030/Eventbrite-clone-project GitHub Wiki

users

column name	data type	details
id	integer	not null, primary key
username	string	not null, unique
email	string	not null, unique
hashedPassword	binary	not null
created_at	datetime	not null
updated_at	datetime	not null

registrations

column name	data type	details
id	integer	not null, primary key
career_fair_id	integer	not null, foreign key
user_id	integer	not null, foreign key
created_at	datetime	not null
updated_at	datetime	not null

• career_fair_id references career_fairs table
• user_id references users table

Career_fairs

column name	data type	details
id	integer	not null, primary key
host_id	integer	not null, foreign key
venue_id	integer	not null, foreign key
name	string	not null
date	date	not null
capacity	integer	not null
created_at	datetime	not null
updated_at	datetime	not null

• host_id references users table
• venue_id references venues table

Job_titles

column name	data type	details
id	integer	not null, primary key
title	string	not null
created_at	datetime	not null
updated_at	datetime	not null

Venues

column name	data type	details
id	integer	not null, primary key
name	string	not null,
address	string	not null
city	string	not null
country	string	not null
zipCode	string	not null
created_at	datetime	not null
updated_at	datetime	not null

Event_titles

column name	data type	details
id	integer	not null, primary key
job_title_id	integer	not null, foreign key
fair_id	integer	not null, foreign key
created_at	datetime	not null
updated_at	datetime	not null

• job_title_id references job_titles table
• fair_id references career_fairs table