multi-vendor - Laravel Schema Designer

users

id increments
timestamps timestamps
first_name string (191)
last_name string (191)
email string (191)
birthdate date
password string (191)
image string (191)
address string (191)
job_title string (191)
user_type enum
status enum
gender enum

branches

id increments
timestamps timestamps
branch_name string (191)
city_id ^FK integer
lat string (191)
lang string (191)
address string (191)
status enum
phone integer

countries

id increments
timestamps timestamps
country_code string (191)
flag string
is_available boolean

cities

id increments
timestamps timestamps
state_id ^FK integer
is_available boolean

states

id increments
timestamps timestamps
country_id ^FK integer
is_available boolean

Phone

id increments
timestamps timestamps
object_id integer
object_type string (191)
phone integer
country_id string (191)

contact_salle

id increments
timestamps timestamps
first_name string (191)
last_name string (191)
job_title text
company_name string (191)
company_location string (191)
businees_name string (191)
business_eamil string (191)
company_type string (191)
avg_daily_order string (191)
message text

currencies

id increments
timestamps timestamps
name string (191)
flag string (191)
price float
is_available boolean

orders

id increments
timestamps timestamps
curreny_id ^FK integer
warehouse string (191)
customer_name ^FK integer
city_id ^FK integer
delivery_type string (191)
shipment_number string (191)
order_date date
total_amount float
payment_method enum
status_id ^FK integer
address string (191)
order_number string (191)
brand_name string (191)
country_id ^FK integer
order_comment text
lat string (191)
lang string (191)
product_name string (191)
sku string (191)
item string (191)
quentity string (191)
price float
tax float
total float
grand_total float

order_status

id increments
timestamps timestamps
name string (191)
is_available boolean

warehouses

id increments
timestamps timestamps
name string (191)
city_id ^FK integer
phone ^FK integer
address text
lat string (191)
lang string (191)
status enum

shipments

id increments
timestamps timestamps
user_id ^FK integer
city_id ^FK integer
order_date date
grand_total float

settings

id increments
timestamps timestamps
email string (191)
logo string (191)
facebook_url string (191)
twitter_url string (191)
youtub_url string (191)
phone1 string (191)
phone2 string (191)
years_exp string (191)

settings_data

id increments
timestamps timestamps
setting_id ^FK integer
name string (191)
description text
working_hours text
keywords string (191)
lang_id ^FK integer

languages

id increments
timestamps timestamps
title string (191)
code string (191)
flag string (191)

country_data

id increments
timestamps timestamps
country_id ^FK integer
name string (191)
lang_id ^FK integer

state_data

id increments
timestamps timestamps
state_id ^FK integer
lang_id ^FK integer
name string (191)

city_data

id increments
timestamps timestamps
city_id ^FK integer
lang_id ^FK integer
name string (191)

branch_data

id increments
timestamps timestamps
branch_id ^FK integer
lang_id ^FK integer
name string (191)

branch_user

id increments
timestamps timestamps
branch_id ^FK integer
user_id ^FK integer

banners

id increments
timestamps timestamps
image string (191)
link string (191)

banner_data

id increments
timestamps timestamps
title string (191)
description text
banner_id ^FK integer
lang_id ^FK integer

sliders

id increments
timestamps timestamps
link string (191)
image string (191)

slider_data

id increments
timestamps timestamps
title string (191)
description text
slider_id ^FK integer
lang_id ^FK integer

blog_categories

id increments
timestamps timestamps
is_available boolean
image string (191)

blog_categories_data

id increments
timestamps timestamps
title string (191)
description text
blog_category_id ^FK integer
lang_id ^FK integer

blogs

id increments
timestamps timestamps
image string (191)
blog_category_id ^FK integer
is_available boolean

blog_data

id increments
timestamps timestamps
title string (191)
description text
blog_id ^FK integer
lang_id ^FK integer