Notes

create table vehicles IF NOT EXISTS
Id int NOT NULL AUTO_INCREMENT,
vehicles_details_id int NOT NULL,
locations_id int NOT NULL,
selling_price int NOT NULL

create table vehicle_details IF NOT EXISTS
id int NOT NULL AUTO_INCREMENT,
brands_id int NOT NULL,
model,
specs,
type,
colour_id int NOT NULL,
price

create table properties IF NOT EXISTS
- Id int NOT NULL AUTO_INCREMENT,
name,
details,
type,
location_id int NOT NULL,
original_price,
selling_price

create table shares IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
vehicle_id int NULL,
property_id int NULL,
share,
share_price,
status,
user_details_id,
date,
calendar_bookings_id int NOT NULL

create table payment_records IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
stripe_id ,
stripe_token,
user_details_id,
vehicle_id,
property_id,
share_id,
calendar_bookings_id,
date,
refunded,
exchanged

create table refunds IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
payment_record_id,
stripe_id,
stripe_token,
share_id,
calendar_bookings_id,
date

create table exchanges IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
user1_payment_record_id,
user2_payment_record_id,
date

create table calender_holidays IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
from,
to,
location_id int NOT NULL

create table calendar_bookings IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
user_details_id int NOT NULL,
from TIMESTAMP NOT NULL,
to TIMESTAMP NOT NULL

create table user_details IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
name,
age,
gender,
phone,
location_id,
email_address,
image_path

create table user_documents IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
user_details_id,
path,
type,
status

create table private_details IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
user_details_id,
password

create table password_resets IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT, user_details_id, token , time
create table images IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
vehicle_details_id int NULL ,
property_id int NULL,
image_path

create table locations IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
address ,
post_code,
city_id int NOT NULL,
country_id int NOT NULL

create table brands IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
brand

create table cities IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
name

create table countries IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
name

create table colours IF NOT EXISTS
- id int NOT NULL AUTO_INCREMENT,
colour


Notes:
before booking disable holidays that are in calendar_holidays
shares require the date to be booked first, as if not confirmed after 30 days can be removed from calendar

payment_records may require changes with stripe, for security bank account details may be better not to store
exchanges - uses payment records but can be improved
vehicle_details & properties - can be improved in the future to store type/category separately

if refunded use share_id and calender_bookings_id to update the calendar and mark 1 in refunded in payment_records
if exchange mark both records exchanged and change both user_id

may be good to:
- auto calculate selling price and dates
- have configuration page for admins to insert data from ui
- in future to add user settings to store their configuration , /languages/currency etc
- to have currency for payments

Social media
Sign in Facebook, Google