db Schema

Database Schema

users

Column name	Data type	Details
id	integer	not null, primary key
username	string	not null, indexed
email	string	not null, indexed, unique
password_digest	string	not null
session_token	string	not null, indexed, unique
organizer_description	text	not null
created_at	datetime	not null
updated_at	datetime	not null

---

events

Column name	Data type	Details
id	integer	not null, primary key
event_name	string	not null, indexed
organizer_id	integer	not null, indexed, unique to event_name
date	datetime	not null
time	datetime	not null
location	string	not null
description	text	not null
price	float	not null
event_type	special	not null, included in set
created_at	datetime	not null
updated_at	datetime	not null

---

categories

Column name	Data type	Details
id	integer	not null, primary key
category	string	not null, indexed, unique
created_at	datetime	not null
updated_at	datetime	not null

---

taggings

Column name	Data type	Details
category_id	integer	not null, indexed, unique to event_id
event_id	integer	not null, indexed
created_at	datetime	not null
updated_at	datetime	not null

---

registrations

Column name	Data type	Details
event_id	integer	not null, indexed
attendee_id	integer	not null, indexed
created_at	datetime	not null
updated_at	datetime	not null

---

bookmarks

Column name	Data type	Details
event_id	integer	not null, indexed
attendee_id	integer	not null, indexed
created_at	datetime	not null
updated_at	datetime	not null

---