Finance Stock Tracker
Database
* postgresqlERDs
Stock
| Column | Type | Default | Nullable |
|---|---|---|---|
| id | SERIAL (primary key) | None | NO |
| ticker | string | None | NO |
| name | string | None | NO |
| last_price | decimal | None | NO |
UserStocks
| Column | Type | Default | Nullable |
|---|---|---|---|
| id | SERIAL (primary key) | None | NO |
| user_id | integer (foreign key) | None | NO |
| stock_id | integer (foreign key) | None | NO |
Authentication
* devise