Schema - makaveddy/gigbrite GitHub Wiki

users

Column Data Type Details
id integer not null, unique
first_name string not null
last_name string not null
email string not null, indexed, unique
password_digest string not null, unique
session_token string not null, unique
time_stamps datetime not null

events

Column Data Type Details
id integer not null, unique
creator_id integer not null, indexed, foreign key
title string not null
description string not null
location string not null
start_time datetime not null
end_time datetime not null
time_stamps datetime not null

event_registrations

Column Data Type Details
id integer not null, unique
user_id integer not null, indexed
event_id integer not null, indexed
time_stamps datetime not null

bookmarks

Column Data Type Details
id integer not null, unique
user_id integer not null, indexed
event_id integer not null, indexed
time_stamps datetime not null
⚠️ **GitHub.com Fallback** ⚠️