-
Notifications
You must be signed in to change notification settings - Fork 0
Database Schema
Paul edited this page Jan 30, 2018
·
12 revisions
| Column name | Data Type | Description | |
|---|---|---|---|
| Sample Data |
| Project | Data Type | Description | |
|---|---|---|---|
| id | integer | not null | |
| title | string | not null, unique | |
| blurb | text | not null | |
| description | text | not null | |
| author_id | integer | not null | foreign key, indexed |
| due_date | date | not null | |
| funding_goal | integer | not null | |
| current_funding | integer | default: 0 | |
| image_url | string | not null |
| category_names | Data Type | Description | | | name | string | not null | |
| categories | Data Type | Description | |
|---|---|---|---|
| project_id | integer | not null | indexed |
| category_id | integer | not null | indexed |
| Users | Data Type | Description | Notes |
|---|---|---|---|
| id | integer | not null | Primary key |
| username | string | not null, unique | indexed |
| password_digest | string | not null | |
| string | not null, unique | indexed | |
| session_token | string | not null, unique | indexed |