dbrnak-diagram - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
country_key string
phone string
lat string
lng string
map_desc text
commerical_image string
password string
type enum
avatar string (255)
logo string (255)
bio text
wallet double (0,0)
lang string (10)
email string (100)
gender integer
birthdate date
nationality string (150)
organization_name string (150)

images

id increments
timestamps timestamps
image string (100)
toable morphs

intros

id increments
timestamps timestamps
image string (100)
title string (150)
description text

contactus

id increments
timestamps timestamps
name string (150)
phone string (150)
content text
byable morphs
country_code string (10)

categories

id increments
timestamps timestamps
name string (150)
image string (150)
parent_id integer

addresses

id increments
timestamps timestamps
title string (100)
lat string (50)
lng string (50)
map_desc text
is_active boolean
user_id ^FK integer

notifications

id increments
timestamps timestamps
type string (100)
data text
read_at timestamp
notifiable string

countries

id increments
timestamps timestamps
name string (150)
image string (150)
country_code string (10)

cities

id increments
timestamps timestamps
name string (150)

providers

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
country_code string
phone string
lat string
lng string
map_desc string
commerical_image string
password string
image string (255)
email string (255)
file string (150)
logo string (100)
wallet double (0,0)
city_id ^FK integer
is_approved boolean

car_types

id increments
timestamps timestamps
name string (150)

branches

id increments
timestamps timestamps
provider_id ^FK integer
image string (150)
name string (150)
phone string (150)
country_code string (10)
email string (150)
lat string (50)
lng string (50)
map_desc text

timings

id increments
timestamps timestamps
day string (50)
from time
to time
is_closed boolean
branch_id ^FK integer

managers

id increments
timestamps timestamps
image string (150)
name string (150)
phone string (150)
country_code string (10)
email string (150)
password string (100)
branch_id ^FK integer

employees

id increments
timestamps timestamps
image string (150)
name string (150)
phone string (150)
country_code string (10)
email string (150)
password string (100)
branch_id integer
addable morphs

cars

id increments
timestamps timestamps
image string (150)
car_type_id ^FK integer
category_id ^FK integer
vehicle_num string (100)
color string (100)
car_model_id ^FK integer
quantity integer
description text
daily_price double
monthly_price double
yearly_price double
manufacter_year string (50)
off_date date
addable morphs
name string (150)

off_dates

id increments
timestamps timestamps
from date
to date
car_id ^FK integer

Order

id increments
timestamps timestamps
order_num string (50)
receive_date date
return_date date
lat string (50)
lng string (50)
map_desc text
car_id ^FK integer
type integer
duration integer
daily_cost double
status integer
admin_commission_ratio double
admin_commission double
vat_amount double
coupon string (50)
rent_amount double
total_price double
pay_type integer
pay_status integer
branch_id ^FK integer
user_id ^FK integer
coupon_value double

coupons

id increments
timestamps timestamps
coupon string (100)
num_to_use integer
expire_date date

car_models

id increments
timestamps timestamps
model string (150)

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