Rezkly - Laravel Schema Designer

users

id increments
avatar string (50)
name string (50)
country_code string (5)
phone string (15)
email string
password string
lat decimal (10, 8)
lng decimal (10, 8)
map_desc string (255)
is_active boolean
is_blocked boolean
softDeletes softDeletes
timestamps timestamps

base_categories

id increments
name string
is_active boolean
timestamps timestamps

categories

id increments
base_category_id bigInteger
image string
name string
parent_id bigInteger
timestamps timestamps

orders

id increments
order_num string (50)
user_id bigInteger
provider_id bigInteger
category_id bigInteger
sub_category_id bigInteger
description string
lat decimal (10, 8)
lng decimal (10, 8)
map_desc string
date date
time time
pay_type tinyInteger
pay_status tinyInteger
pay_data json
uuid uuid
cancel_reason_id bigInteger
softDeletes softDeletes
timestamps timestamps

order_offers

id increments
order_id bigInteger
provider_id bigInteger
status enum
softDeletes softDeletes
timestamps timestamps

attachments

id increments
attachable morphs
file_path string
file_type string
status enum
deleted boolean
softDeletes softDeletes
timestamps timestamps

order_refuses

id increments
order_id bigInteger
provider_id bigInteger
cancel_reason_id bigInteger
timestamps timestamps

cancel_reasons

id increments
text string
softDeletes softDeletes
timestamps timestamps

addresses

id increments
user_id bigInteger
lat decimal (10, 8)
lng decimal (10, 8)
map_desc string
softDeletes softDeletes
timestamps timestamps

work_times

id increments
provider_id bigInteger
day string
from time
to time
softDeletes softDeletes
timestamps timestamps

packages

id increments
name string
description string
price decimal (10, 8)
duration timestamp
timestamps timestamps
softDeletes softDeletes

provider_packages

id increments
provider_id bigInteger
package_id bigInteger
started_at timestamp
ended_at timestamp
price decimal (10, 8)
pay_type tinyInteger
pay_status tinyInteger
pay_data json
timestamps timestamps
softDeletes softDeletes

providers

id increments
avatar string
name string
base_category_id bigInteger
country_code string (5)
phone string (15)
city_id bigInteger
lat decimal (10, 8)
lng decimal (10, 8)
map_desc string
is_active boolean
is_blocked boolean
is_available boolean
is_approved enum
softDeletes softDeletes
timestamps timestamps

provider_categories

id increments
provider_id bigInteger
category_id bigInteger
softDeletes softDeletes
timestamps timestamps

products

id increments
provider_id bigInteger
type enum
sub_category_id bigInteger
name text
description text
price decimal (10, 8)
discount_type enum
discount_value decimal (10, 8)
started_discount_at timestamp
ended_discount_at timestamp
softDeletes softDeletes
timestamps timestamps

product_features

id increments
product_id bigInteger
softDeletes softDeletes
timestamps timestamps
feature_id bigInteger

features

id increments
name string
timestamps timestamps
softDeletes softDeletes

carts

id increments
timestamps timestamps
user_id ^FK integer
coupon_id ^FK integer

cart_items

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

coupons

id increments
timestamps timestamps

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