Deployed App: https://fac-week3-project.herokuapp.com/
Movie Rating App
- Programming Language: JS
- Backend: Node.js, Express
- DBMS: Postgresql
- Frontend: CSS, HTML
- (Testing: Cypress TBC)
Table: users
| Column | Type | Nullable | Notes |
|---|---|---|---|
| id | serial | not null | PRIMARY KEY |
| username | text | FOREIGN KEY | |
| text | not null | unique | |
| password | text | not null |
Table: posts
| Column | Type | Nullable | Notes |
|---|---|---|---|
| id | serial | not null | PRIMARY KEY |
| user_id | integer | FOREIGN KEY REFERENCES users(id) ON DELETE CASCADE | |
| movie_title | text | ||
| comment | text | ||
| rating | text |
Table: sessions
| Column | Type | Nullable | Notes |
|---|---|---|---|
| sid | text | PRIMARY KEY | |
| text | not null |