dBazar - Laravel Schema Designer

sponsored

id increments
timestamps timestamps
softDeletes softDeletes
entity_id ^FK integer
status tinyInteger
start_date datetime
end_date datetime

facebook_menu

id increments
timestamps timestamps
softDeletes softDeletes

products

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
description string (255)
status tinyInteger
p_cat_id ^FK integer
uuid uuid (90)

product_categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
status tinyInteger

product_options

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
status tinyInteger

product_options_sub

id increments
timestamps timestamps
softDeletes softDeletes
p_cat_id ^FK integer
start_time time
end_time time

vouchers

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
type_id ^FK integer
discount double
start_date datetime
end_date datetime
entity_id ^FK integer
status tinyInteger

orders

id increments
timestamps timestamps
softDeletes softDeletes
payment_id ^FK integer
entity_id ^FK integer
payment_mode_id ^FK integer
consumer_id ^FK integer

ads

id increments
timestamps timestamps
softDeletes softDeletes
image string (255)
start_date_time timestamp
end_date_time timestamp
entity_id ^FK integer

consumers_addresses

id increments
timestamps timestamps
softDeletes softDeletes
address string (255)
street_no string (255)
status string (255)
zip_code string (255)
consumer_user_id ^FK integer
country_id ^FK integer
state_id ^FK integer
city_id ^FK integer
uuid uuid (90)

riders

id increments
timestamps timestamps
softDeletes softDeletes

notifications

id increments
timestamps timestamps
softDeletes softDeletes

notification_templates

id increments
timestamps timestamps
softDeletes softDeletes

email_logs

id increments
timestamps timestamps
softDeletes softDeletes

emnail_templates

id increments
timestamps timestamps
softDeletes softDeletes

activity_log

id increments
timestamps timestamps
softDeletes softDeletes

rewards

id increments
timestamps timestamps
softDeletes softDeletes

affliliates

id increments
timestamps timestamps
softDeletes softDeletes
affiliate_post_type_id ^FK integer
affilitate_package_id ^FK integer
user_id ^FK integer

customer_favourites

id increments
timestamps timestamps
softDeletes softDeletes

taxes

id increments
timestamps timestamps
softDeletes softDeletes
tax_type ^FK integer
tax_percentage integer
country_id ^FK integer

currencies

id increments
timestamps timestamps
softDeletes softDeletes
currency_code string (255)
currency_symbol string (255)

users

id increments
timestamps timestamps
softDeletes softDeletes
uuid string (90)
username string (255)
email string (255)
password string (255)
first_name string (255)
last_name string (255)
user_type enum
email_verified tinyInteger
password_changed tinyInteger
email_verified_token string (255)
password_changed_token string (255)

country

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

state

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
country_id ^FK integer
uuid uuid (90)

city

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
state_id ^FK integer
country_id ^FK integer
uuid uuid (90)

status

id increments
timestamps timestamps
softDeletes softDeletes
name string (90)
type string (155)
uuid uuid (90)

cuisine_assigned

id increments
timestamps timestamps
softDeletes softDeletes
cuisine_id ^FK integer
entity_id ^FK integer
status tinyInteger

services

id increments
name string (255)
type string (155)

tax_type

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

ratings

id increments
range1 double
range2 double
ratings string (255)

consumer_users

id increments
timestamps timestamps
softDeletes softDeletes
uuid string (90)
username string (255)
email string (255)
first_name string (255)
last_name string (255)
user_type enum
email_verified tinyInteger
password_changed tinyInteger
email_verified_token string (255)
password_changed_token string (255)
password string (255)

voucher_type

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
status integer

payment_mode

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
type string (255)
status tinyInteger

order_details

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK integer
product_id ^FK integer
description string (255)
quantity double
uuid uuid (90)

affiliate_post_type

id increments
timestamps timestamps
name string (255)
description string (255)

affilitate_package

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
price double
time_limit datetime
amount double
benifits string (255)
status tinyInteger

EntitiesSettings

id increments
timestamps timestamps
softDeletes softDeletes
entity_id ^FK integer
uuid uuid
order_type integer
commission double
minimum_purchase double
logo string (255)
header string (255)
About string (500)
status integer
status_message string (255)
packaging_type integer
packaging_charge double
tax double
delivery_time time
menu_type integer

area_manager

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
country integer
state integer
city integer

sub_area_manager

id increments
timestamps timestamps
softDeletes softDeletes
area_manager_id integer
name string (255)