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

registered_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)

table

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

table

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