CarShare

A project for sharing cars 🚘 🌱

Contents

• User Story
• Website Design
• Database Design
• Server Design

Website: https://cars-sharing.herokuapp.com/

Login Credentials (for code review):

• Username: [email protected]
• Password: XtWurJnVfhw

User Story

As a member of WebAhead who has a car I would like to share...

• I can add my car to the database :white_check_mark:

As a member of WebAhead who is interested in using a car...

• I can browse for available cars ✔️
• I can reserve a car for certain dates ✔️
• I can unreserve a car ❌

Suggested additional requirements / stretch goals:

• I can login to the site ✔️
• I can rate the car after I've used it ❌
• Cars can simultaneously be reserved by multiple users but for different dates ✔️

Website Design

Sign in:

Search for Car:

Add Car page and User Details page WIP

Database Design

Schema:

Table 1: Users
	- id
	- first name
	- last name
	- phone number
	- email
	- password
	- image
	-------------------------
Table 2: Cars
	- id
	- type
	- model
	- engine
	- color
	- sets number
	- raite
	- image
	-------------------------
Table 3: Reservations (Pivot table)
	- id
	- user_id
	- car_id
	- from_date
	- to_date
	-------------------------

MANY to MANY relationship between users and cars, where reservations links to two primary IDs

Server Design

Routing:

Static:
   	-------
 - Login page
 - User Info page
 - Reservation page
 - Adding Car page 

Dynamic
   	-------
GET:
- Get All Cars
- Get Available Cars
- Get Password check
- Get user details & reservations

POST:
- Post reservations
- Post new Cars

Conclusion

• BIG project, SMALL team 😥
• We also put each team member on their weakest area! 🐸
• So sadly we only had limited time for testing & security 🔓
• Having your own data base is a fast and useful way to store, amend & access data 🗄️
• Designing your database correctly at the start is important! 🔀