database schema - ntuzer/EvenTide GitHub Wiki

Users Table

Column Name	Data Type	Details
id	integer	not null, primary key
first_name	string	not null
last_name	string	not null
email	string	not null, indexed, unique
image_url	string	not null
password_digest	string	not null
session_token	string	not null, indexed, unique
created_at	datetime	not null
updated_at	datetime	not null

Events Table

Column Name	Data Type	Details
id	integer	not null, primary key
organizer_id	integer	not null, foreign key, indexed (event owner)
title	string	not null, indexed
location	string	not null, indexed
description	string	not null
event_image_url	string	not null
category_id	integer	not null, foreign key
min_price	integer	not null
max_price	integer
start_date	datetime	not null
end_date	datetime	not null
created_at	datetime	not null
updated_at	datetime	not null

• category_id references the category table

Tickets Table

Column Name	Data Type	Details
id	integer	not null, primary key
event_id	integer	not null, foreign key
type	string	not null
quantity	integer	not null
price	integer	not null

• event_id references the events table

RSVP Table

Column Name	Data Type	Details
id	integer	not null, primary key
ticket_id	integer	not null, foreign key
user_id	integer	not null , foreign key
quantity	integer	not null

• ticket_id references the tickets table
• user_id references the user table

Bookmarks Table

Column Name	Data Type	Details
id	integer	not null, primary key
user_id	integer	not null, foreign key
event_id	integer	not null, foreign key

• event_id references the events table
• user_id references the user table

Categories Table

Column Name	Data Type	Details
id	integer	not null, primary key
category_name	string	not null, indexed