-
Notifications
You must be signed in to change notification settings - Fork 0
db Schema
John Lockhart edited this page Aug 1, 2018
·
9 revisions
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 |
profile_pic |
url | |
organizer_description |
text | |
created_at |
datetime | not null |
updated_at |
datetime | not null |
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 |
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 |
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 |
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 |
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 |
Column name | Data type | Details |
---|---|---|
organizer_id |
integer | not null, primary key |
follower_id |
integer | not null, indexed |
created_at |
datetime | not null |
updated_at |
datetime | not null |