Schema - nerochen25/full_stack_project GitHub Wiki
users
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
username |
string | not null, indexed, unique |
email_address |
string | not null, indexed, unique |
password_digest |
string | not null |
session_token |
string | not null, indexed, unique |
profile_description |
text |
projects
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
title |
string | not null |
description |
text | not null |
creator_id |
integer | not null, indexed, foreign key |
category_id |
integer | not null, indexed, foreign key |
funding_goal |
float | not null |
reward_offered |
boolean | ???? |
due_date |
date | not null |
bookmarks
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
watch_id |
integer | not null, foreign key |
project_id |
integer | not null, foreign key |
categories
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
name |
string | not null |
pledges
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
amount |
float | not null |
supporter_id |
integer | not null |
project_id |
integer | not null |
reward_id |
integer |
rewards
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
project_id |
integer | not null, foreign key |
pledge_amount |
float | not null |
title |
string | not null |
description |
text | not null |
item_name |
string | not null |
digital_item |
boolean | |
estimated_delivery |
date | |
delivery_location_limit |
string | |
limited_availability |
boolean | not null |
backer_limit |
integer |
comments
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
commenter_id |
integer | not null, foreign key |
project_id |
integer | not null, foreign key |