salehCars - Laravel Schema Designer

branches

id increments
branch_name_ar string
branch_name_en string
branch_google_url string
timestamps timestamps
latitude decimal (10,8)
longitude decimal (10,8)
status integer

videos

id increments
video_url string
timestamps timestamps
status integer
title string
softDeletes text

mail_list

id increments
email string
timestamps timestamps

car_brands

id increments
brand_name_ar string
brand_name_en string
brand_image string
timestamps timestamps

car_models

id increments
car_brand_id ^FK integer
model_name_ar string
model_name_en string
timestamps timestamps

car_model_types

id increments
car_model_id ^FK integer
tybe_name_ar string
tybe_name_en string
timestamps timestamps

car_colors

id increments
color_name_ar string
color_name_en string
color_code string
color_image string
timestamps timestamps

setting

id increments
timestamps timestamps
site_name_ar string
site_name_en string
site_desc_ar text
site_desc_en text
social_fb string
social_tw string
social_insta string
social_youtube string
site_mail string
site_mobile string
site_keyword_ar text
site_keyword_en text

notifications

id increments
title_en string
title_ar string
content_en string
content_ar string
timestamps timestamps
type enum
notifiable_id integer
notifiable_type string

products

id increments
product_name string
car_model_id integer
model_type_id integer
year integer
main_image string
notes text
product_status integer
timestamps timestamps

customers

id increments
timestamps timestamps
name string
mobile string
from string

contact

id increments
name string
email string
message string
subject string
timestamps timestamps

inner_cars

id increments
product_id ^FK integer
engine_capacity string
inner_color_id ^FK integer
outer_color_id ^FK integer
gear_type enum
supplier enum
main_image string
car_status integer
price integer
have_discount integer
price_after integer
engine_size integer
car_operation string
ex_bluetooth integer
ex_aux integer
ex_cd integer
ex_navigator integer
ex_back_cam integer
ex_sensor_front integer
ex_sensor_back integer
ex_intellegance_entry integer
ex_sun_roof integer
ex_seat_type integer
notes text
new_or_used enum
timestamps timestamps

orders

id increments
inner_car_id ^FK integer
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01