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

order_services

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
status enum
pay_type tinyInteger
pay_status tinyInteger
pay_data json
uuid uuid
cancel_reason_id bigInteger
cancel_by string
softDeletes softDeletes
timestamps timestamps

order_offer_service

id increments
order_id bigInteger
provider_id bigInteger
user_id bigInteger
status enum
cancel_reason_id bigInteger
cancel_by string
softDeletes softDeletes
timestamps timestamps

attachments

id increments
attachable morphs
file_path string
file_type string
status enum
deleted boolean
softDeletes softDeletes
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
sub_category_id bigInteger
type enum
name text
description text
price decimal (10, 8)
quantity integer
discount_type enum
discount_value decimal (10, 8)
started_discount_at timestamp
ended_discount_at timestamp
softDeletes softDeletes
timestamps timestamps

product_features

id increments
base_group boolean
product_id bigInteger
feature_id bigInteger
feature_value_id bigInteger
price decimal
quantity integer
discount_type enum
discount_value decimal (10, 8)
started_discount_at timestamp
ended_discount_at timestamp
softDeletes softDeletes
timestamps timestamps

features

id increments
name string
timestamps timestamps
softDeletes softDeletes

cart_items

id increments
user_id ^FK integer
provider_id ^FK integer
product_features_id ^FK integer
quantity integer
timestamps timestamps

coupons

id increments
coupon_num string
type enum
discount decimal (10, 8)
max_discount decimal (10, 8)
expire_date datetime
max_use integer
use_times integer
status enum
timestamps timestamps

cart_orders

id increments
order_num string
user_id ^FK integer
address_id ^FK integer
sub_total decimal (10,2)
delivery_price decimal (10,2)
coupon_id ^FK integer
discount decimal (10,2)
vat decimal (10,2)
total decimal (10,2)
notes text
status string
pay_type string
pay_status string
cancel_reason_id bigInteger
cancel_by string
timestamps timestamps

feature_values

id increments
feature_id string
value string
softDeletes softDeletes
timestamps timestamps

order_items

id increments
cart_order_id ^FK integer
product_features_id ^FK integer
quantity integer
price string
timestamps timestamps

order_returs

id increments
returnable_id morphs
returnable_type morphs
timestamps timestamps

friday_providers

id increments
timestamps timestamps
name string
phone string
email string
map_desc string
status string

ratings

id increments
user_id bigInteger
rate decimal (10, 8)
comment string
timestamps timestamps

friday_provider_products

id increments
timestamps timestamps
status string