Database Schema

Database Schema

users

Column Name	Data Types	Details
id	integer	not null, primary key
username	string	not null, unique, indexed
email	string	not null, unique, indexed
hashed_password	string	not null
avatar_url	string

events

Column Name	Data Types	Details
id	integer	not null, primary key
name	string	not null
event_description	text	not null
host_id	integer	not null, foreign key (models.User)
event_date	date time object	not null
event_planet	string	not null
event_picture_url	string	not null
category_id	integer	not null, foreign key (models.Category)

bookmarked_events

Column Name	Data Types	Details
id	integer	not null, primary key
event_id	integer	not null, foreign key (models.Event)
user_id	integer	not null, foreign key (models.User)
is_registered	boolean	not null, default=False

categories

Column Name	Data Types	Details
id	integer	not null, primary key
type	string	not null