Car sharing app - Laravel Schema Designer

users

id increments
full_name string (100)
email string (150)
country_code string (5)
phone string (20)
password string (255)
is_smoking boolean
active boolean
latitude decimal (9,6)
longitude decimal (9,6)
birthday datetime
nationality_id ^FK integer
image string (255)
fcm_token string
language_id ^FK integer
timestamps timestamps
softDeletes softDeletes

rides

id increments
user_id ^FK integer
pickup string (255)
dropoff string (255)
date_schedule datetime
passengers_limit smallInteger
instant_booking boolean
price_per_seat double
is_publish boolean
vehicle_id ^FK integer
timestamps timestamps
middle_seat_empty boolean
notes string (255)
total_price double

ride_stopovers

id increments
timestamps timestamps
ride_id ^FK integer
latitude double (9.6)
longitude double (9,6)
name string (255)

ride_requests

id increments
timestamps timestamps
ride_id ^FK integer
user_id ^FK integer
price double
status_id ^FK integer
payment_method_id ^FK integer

user_reports

id increments
timestamps timestamps
reporter_id ^FK integer
reported_id ^FK integer
description string
ride_id ^FK integer

ride_reviews

id increments
timestamps timestamps
ride_id ^FK integer
user_id ^FK integer
rating smallInteger
review string (255)

vehicles

id increments
plate_number mediumInteger
vehicle_name string (255)
image string (255)
color string (10)
vehicle_model_id ^FK integer
user_id ^FK integer
vehicle_type_id ^FK integer
timestamps timestamps

vehicle_models

id increments
timestamps timestamps
name string (50)

vehicle_types

id increments
timestamps timestamps
name string (50)

saved_places

id increments
timestamps timestamps
latitude decimal (9,6)
longitude double (9,6)
address string (255)
user_id ^FK integer
type_id ^FK integer

otps

id increments
timestamps timestamps
otp smallInteger
user_id ^FK integer
expired_at datetime

contacts

id increments
timestamps timestamps
full_name string
email string (150)
message string (255)

user_verifications

id increments
email boolean
phone boolean
national_id_card boolean
driving_licence boolean
national_id_card_front_image string (255)
national_id_card_back_image string (255)
driving_licence_back_image string (255)
driving_licence_front_image string (255)
user_id ^FK integer
timestamps timestamps

wallets

id increments
timestamps timestamps
user_id ^FK integer
requested_balance double
wallet_balance double
checkout_balance double
maximum_balance double

wallet_transactions

id increments
timestamps timestamps
wallet_id ^FK integer
ride_id ^FK integer
amount double
status_id ^FK integer
type_id ^FK integer

vehicle_verification

id increments
timestamps timestamps
licence_front_image string (255)
licence_back_image string
licence boolean
vehicle_id ^FK integer

countries

id increments
name string (50)
nationality string (50)
code string (4)
country_code string (5)
timestamps timestamps

admins

id increments
full_name string (100)
email string (100)
country_code string (5)
phone string (20)
password string (255)
active boolean
country_id ^FK integer
language_id ^FK integer
timestamps timestamps

safes

id increments
timestamps timestamps
admin_id ^FK integer
money_in double (10,2)
money_out double (12,2)
balance double (12,2)
maximum_balance double

safe_transactions

id increments
timestamps timestamps
safe_id ^FK integer
amount double
type enum
receipt string
bank_account_id ^FK integer

bank_accounts

id increments
timestamps timestamps
account_number string (20)
account_holder_name string (100)
active boolean
bank_name string (100)
admin_id ^FK integer

languages

id increments
timestamps timestamps
active boolean
name string (50)

statuses

id increments
timestamps timestamps
table_name string (255)
name string (255)
active boolean

payment_methods

id increments
timestamps timestamps
name string (50)
active boolean

types

id increments
timestamps timestamps
table_name string (255)
name string
active boolean

ride_request_payment_transactions

id increments
timestamps timestamps
ride_request_id ^FK integer
status_id string
amount string
payment_gateway_id ^FK integer

payment_gateways

id increments
timestamps timestamps
name string
active boolean
total_transactions double (12,2)

status_locales

id increments
timestamps timestamps
name string
status_id ^FK integer
language_id ^FK integer

type_locales

id increments
timestamps timestamps
type_id ^FK integer
language_id ^FK integer
name string