Life-Overflow is a clone off of Stack Overflow. The theme of our website is about life and users can ask questions of life related topics.
- Users can sign up, log in, and log out.
- Users can't use certain features without logging in.
- Logged in users are directed to their profile page which displays all question and answers that are connected to user.
- Logged out users are directed to a the home page with the most recently asked questions.
- user can ask questions
- user can view asked questions
- user edit owned questions
- user can delete owned questions
- user can answer questions
- user can view answers for specified question
- user can edit owned answers
- user can delete owned answers
- guests and users can use search bar to search for question using provided parameters
- possibly limit displayed questions
- filter by different methods
- user can upvote
- user can downvote
- user can edit vote
- user can remove casted vote
| column name | data type | details |
|---|---|---|
| id | integer | not null, PK |
| username | string(25) | not null, unique |
| string(255) | not null, unique | |
| hashedPassword | binary string | not null |
| createdAt | datetime | not null |
| updatedAt | datetime | not null |
| column name | data type | details |
|---|---|---|
| id | integer | not null, PK |
| name | string(50) | not null, unique |
| createdAt | datetime | not null |
| updatedAt | datetime | not null |
| column name | data type | details |
|---|---|---|
| id | integer | not null, PK |
| title | string(255) | not null |
| body | text | not null |
| userId | integer | not null, FK(User) |
| categoryId | integer | not null, FK(Category) |
| createdAt | datetime | not null |
| updatedAt | datetime | not null |
| column name | data type | details |
|---|---|---|
| id | integer | not null, PK |
| body | text | not null |
| userId | integer | not null, FK(User) |
| questionId | integer | not null, FK(Question) |
| createdAt | datetime | not null |
| updatedAt | datetime | not null |
| column name | data type | details |
|---|---|---|
| id | integer | not null, PK |
| value | boolean | not null |
| userId | integer | not null, FK(User) |
| answerId | integer | not null, FK(Answer) |
| createdAt | datetime | not null |
| updatedAt | datetime | not null |
This page displays a log in form
GET /loginPOST /login
This page displays a signup form.
GET /signupPOST /signup
This is our splash page, which displays cards for each category with a hyperlink to each category, which lists every question within the category, as well as a card that leads to all the questions. Every page will have a navigation bar with login/signup or logout buttons.
GET /
These pages lists all of the questions that belongs to their respective category or all question on the /questions page. Each question has an edit and delete button if it belongs to the currently logged in user. Any user can select a question and be redirect to the questions page.
GET /questionsGET /categories/:id
This page displays a form with which a logged in user can craft a new question, as well as a navigation bar with logout button.
GET /questions/newPOST /questions/new
This page displays individual questions with associated answers and votes, as well as a navigation bar with login/signup or logout buttons. If the logged in user owns the question, this page also displays an update and delete button. Logged in users can post answers on this page, and can vote on the answer. The logged in owners of those answers can update or delete them. Logged in users can change or remove their vote.
GET /questions/:idGET api/questions/:id/answersPOST api/questions/:id/answersPUT api/answers/:idDELETE api/answers/:idPUT api/answers/:id/votes
- Anyone can view answers on their respective question page and see it's body and vote counters.
GET /api/questions/:id/answersGET /api/answers/:id
- A logged in user may create an answer and seeing it populate directly on the questions page without causing a refresh/redirect.
POST /api/questions/:id/answers
- A logged in user may edit an answer and see it change directly on the questions page without causing a refresh/redirect.
PUT /api/answers/:id
- A logged in user may delete an answer and see it be removed directly on the questions page without causing a refresh/redirect.
DELETE /api/answers/:id
- A logged in user may cast a vote, change their vote, or remove their vote on an answer and see the vote counter change directly on the questions page without causing a refresh/redirect.
PUT /api/answers/:id/votes