laundry_city - Laravel Schema Designer

categories

id increments
name string
is_active boolean
timestamps timestamps

sub_categories

id increments
name string
is_active boolean
category_id ^FK bigInteger
timestamps timestamps

types

id increments
name string
sub_category_id ^FK bigInteger
is_active boolean
timestamps timestamps

services

id increments
name string
is_active boolean
timestamps timestamps

service_sub_category

id increments
service_id ^FK bigInteger
sub_category_id ^FK bigInteger
timestamps timestamps

product

id increments
service_id ^FK bigInteger
type_id ^FK bigInteger
price decimal
timestamps timestamps

offers

id increments
name string
start_date timestamp
end_date timestamp
category_id ^FK bigInteger
description text
discount_ratio decimal
timestamps timestamps

offer_type

id increments
offer_id ^FK bigInteger
type_id ^FK bigInteger
service_id ^FK bigInteger
timestamps timestamps

work_hours

id increments
day string
start_time time
end_time time
timestamps timestamps

advertisements

id increments
name string
publish_start_date timestamp
publish_end_date timestamp
is_active boolean
timestamps timestamps

contacts

id increments
client_name string
client_mobile string
client_email string
type string
is_answerd boolean
message text
reply_message text
timestamps timestamps

carts

id increments
user_id ^FK bigInteger
timestamps timestamps

orders

id increments
receive_order_type string
district_id ^FK bigInteger
address_description string
address string
lat decimal
long decimal
nearest_landmark string
product_price decimal
delivery_price decimal
tax decimal
status string
timestamps timestamps
rate string
comment text
user_id bigInteger

districts

id increments
name string
is_active boolean
timestamps timestamps

order_product

id increments
order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
price decimal
timestamps timestamps

cart_product

id increments
cart_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
timestamps timestamps

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