Motery - Laravel Schema Designer

sections

id bigIncrements
name_ar string
name_en string
timestamps timestamps

categories

id bigIncrements
name_ar string
name_en string
section_id ^FK bigInteger
timestamps timestamps

agencies

id bigIncrements
name_ar string
name_en string
description_ar text
description_en text
record_number string
logo string
active boolean
availablity boolean
country_id ^FK bigInteger
brand_id ^FK bigInteger
year_founded string
day_off_id ^FK bigInteger
timestamps timestamps

contacts

id bigIncrements
contactable_type string
contactable_id bigInteger
phone string
website string
whatsapp string
insta string
timestamps timestamps

brands

id bigIncrements
name_ar string
name_en string
description_ar text
description_en text
timestamps timestamps

reviewables

id bigIncrements
reviewable_type string
reviewable_id bigInteger
user_id ^FK bigInteger
rate float (1,2)
comment text
timestamps timestamps

users

id bigIncrements
first_name string
last_name string
email string
email_verified_at string
password string
remember_token string
timestamps timestamps

favouriables

id bigIncrements
favouriable_type string
favouriable_id bigInteger
user_id ^FK bigInteger
timestamps timestamps

countries

id bigIncrements
name_ar string
name_en string
timestamps timestamps

cities

id bigIncrements
name_ar string
name_en string
country_id ^FK bigInteger
timestamps timestamps

branches

id bigIncrements
branchable_id bigInteger
branchable_type string
name_ar string
name_en string
timestamps timestamps
category_id ^FK bigInteger

work_time

id bigIncrements
workable_type string
workable_id bigInteger
from time
to time
days string
timestamps timestamps

cars

id bigIncrements
name_ar string
name_en string
timestamps timestamps

carables

id bigIncrements
carable_type string
carable_id bigInteger
car_id ^FK bigInteger
availablity boolean
check_price double (8,2)
car_price double (8,2)
price double (8,2)
deposit double (8,2)
timestamps timestamps

areas

id bigIncrements
name_ar string
name_en string
city_id ^FK bigInteger
timestamps timestamps

cars_show_rooms

id bigIncrements
name_ar string
name_en string
description_ar text
description_en text
record_number string
logo string
active boolean
availablity boolean
day_off_id ^FK bigInteger
country_id ^FK bigInteger
timestamps timestamps

rental_offices

id bigIncrements
name_ar string
name_en string
description_ar text
description_en text
record_number string
logo string
active boolean
availablity boolean
day_off_id ^FK bigInteger
country_id ^FK bigInteger
timestamps timestamps

rental_cars

id bigIncrements
brand_id ^FK bigInteger
type string
model string
color string
daily_rental double (8,2)
weekly_rental double (8,2)
monthly_rental double (8,2)
yearly_rent double (8,2)
active boolean
availablity boolean
rental_office_id ^FK bigInteger
timestamps timestamps

rental_cars_reservation

id bigIncrements
user_id ^FK bigInteger
rental_car_id ^FK bigInteger
name_ar string
name_en string
phone string
address text
rental_type string
start_at date
rental_active boolean
rental_availabilty boolean
payment_method string
total_payment double (8,2)
timestamps timestamps

policies

id bigIncrements
policiable_type string
policiable_id bigInteger
name_ar string
name_en string
description_ar text
description_en text
timestamps timestamps

categorizables

id bigIncrements
categorizable_type string
categorizable_id bigInteger
category_id ^FK bigInteger
timestamps timestamps

day_offs

id bigIncrements
timestamps timestamps

selling_special_numbers

id bigIncrements
name_ar string
name_en string
description_ar text
description_en text
record_number string
logo string
active boolean
availablity boolean
country_id ^FK bigInteger
timestamps timestamps

special_numbers

id bigIncrements
number string
special_number_category_id ^FK bigInteger
selling_special_number_id ^FK bigInteger
availabilty boolean
active boolean
size string
transition_type string
include_insurance boolean
price double (8,2)
user_id ^FK bigInteger
timestamps timestamps

special_number_reservations

id bigIncrements
user_id ^FK bigInteger
special_number_id ^FK bigInteger
name_ar string
name_en string
address_ar text
address_en text
phone string
status boolean
timestamps timestamps

files

id bigIncrements
filable_type string
filable_id bigInteger
attachment string
type string
timestamps timestamps

garages

id bigInteger
name_ar string
name_en string
description_ar text
description_en text
record_number string
logo string
active boolean
availablity boolean
country_id ^FK bigInteger
timestamps timestamps

services

id bigIncrements
servable_type string
servable_id bigInteger
name_ar string
name_en string
description_ar text
description_en string
price double (8,2)
timestamps timestamps

products

id increments
timestamps timestamps
productable_type string
productable_id bigInteger
type enum
name_ar string
name_en string
price double (8,2)

winches

id bigInteger
name_ar string
name_en string
description_ar text
description_en text
logo string
record_number string
active boolean
availablity boolean
status enum
place_type enum
type enum
country_id ^FK bigInteger
timestamps timestamps

winch_reservations

id increments
user_id ^FK bigInteger
name_ar string
name_en string
address_ar text
address_en string
phone string
from string
to string
status enum
winch_id ^FK bigInteger
timestamps timestamps

special_numbers_categories

id bigIncrements
name_ar string
name_en string
timestamps timestamps

special_numbers_verifications

id bigIncrements
user_id ^FK bigInteger
special_number_id ^FK bigInteger
status string
timestamps timestamps

admins

id bigIncrements
name string
email string
password string
active boolean
timestamps timestamps