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

service_requests

id increments
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
softDeletes softDeletes
timestamps timestamps

service_request_offers

id increments
service_request_id bigInteger
provider_id bigInteger
user_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

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
email string
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_groups

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

featrues

id increments
name string
type enum
timestamps timestamps
softDeletes softDeletes

cart_items

id increments
cart_id integer
product_id ^FK integer
product_group_id bigInteger
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

orders

id increments
num string
address_id ^FK integer
lat string
lng string
map_desc string
sub_total decimal (10,2)
coupon_id ^FK integer
coupon_type string
coupons_value decimal (10,2)
coupon_amount string
delivery_price decimal (10,2)
vat_value decimal (10,2)
vat_amount string
total decimal (10,2)
status string
pay_type string
pay_status string
cancel_reason_id bigInteger
cancelable morphs
cancel_reason string
notes text
timestamps timestamps

featute_values

id increments
feature_id string
value string
hexa_color string
softDeletes softDeletes
timestamps timestamps

order_items

id increments
order_id ^FK integer
product_group_id ^FK integer
quantity integer
price string
product_features json
timestamps timestamps

order_returs

id increments
returnable_id morphs
returnable_type morphs
timestamps timestamps

ratings

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

friday_provider_products

id increments
provider_id bigInteger
status string
name string
price string
pay_type string
pay_status string
timestamps timestamps

carts

id increments
user_id string
provider_id string
timestamps timestamps
softDeletes softDeletes

product_features

id increments
product_group_id bigInteger
feature_value_id string
timestamps timestamps