schema - Russel-Tsang/Eventnite GitHub Wiki

users

column name	data type	details
id	integer	not null, primary key
email	string	not null, indexed, unique
fname	string	not null
lname	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

addresses

column name	data type	details
id	integer	not null, primary key
street	integer	not null,
city	string	not null
state	string	not null
zip code	integer	not null
user_id	integer	not null, indexed

events

column Name	data type	details
id	integer	not null, primary key
title	string	not null
description	text	not null
location	string	not null
category	string	not null
creator_id	integer	not null, indexed, foreign key

event likes

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, indexed
event_id	integer	not null, indexed

event follows

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, indexed
event_id	integer	not null, indexed

event registrations

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, indexed
event_id	integer	not null, indexed

tags

column name	data type	details
id	integer	not null, primary key
tag_name	string	not null

taggings

column name	data type	details
id	integer	not null, primary key
tag_id	integer	not null
event_id	integer	not null