PRBHUJI - Laravel Schema Designer

roles

id increments
guard_name string (255)
name string
timestamps timestamps
softDeletes softDeletes

permissions

id increments
guard_name string
name string
description text
timestamps timestamps

admins

id increments
name string
email string
email_verified_at timestamp
password string
two_factor_secret text
two_factor_recovery_codes text
remember_token string
timestamps timestamps
softDeletes softDeletes

admin_meta_details

id increments
admin_id bigInteger
meta_name string
meta_value text
timestamps timestamps
softDeletes softDeletes

users

id increments
name string
email string
password string
two_factor_secret text
email_verified_at timestamp
two_factor_recovery_codes text
remember_token string
timestamps timestamps
softDeletes softDeletes

user_meta_details

id increments
timestamps timestamps
user_id bigInteger
meta_name string
meta_value text
meta_value_previous text
softDeletes softDeletes

user_address_details

id increments
type enum
user_id bigInteger
is_current boolean
house_no string
address_line_1 string
address_line_2 string
city string
country string
district string
zip string
latitude string
longitude string
timestamps timestamps
softDeletes softDeletes

products

id increments
author_id string
author_type string
product_type string
warehouses_id bigInteger
sku string
name string
slug string
descriptions text
short_descriptions text
imgae string
status boolean
timestamps timestamps

product_variants

id increments
product_id bigInteger
sku string
descriptions text
short_decriptions text
mrp decimal
sales_price decimal
quantity string
is_default tinyInteger
timestamps timestamps
softDeletes softDeletes

product_attributes

id increments
name string
slug string
status boolean
timestamps timestamps
softDeletes softDeletes

product_attribute_reletionship

product_id bigInteger
attribute_id string
timestamps timestamps

product_attribute_values

id increments
product_attribute_id bigInteger
name string
short_descriptions text
status boolean
timestamps timestamps
softDeletes softDeletes

product_attribute_variants_reletionship

id increments
product_id bigInteger
product_attribute_id bigInteger
product_attribute_value_id bigInteger
product_variants_id string
timestamps timestamps

cities

id increments
author_id bigInteger
author_type string
name string
status boolean
code string
timestamps timestamps
softDeletes softDeletes

warehouses

id increments
author_id bigInteger
author_type string
city_id bigInteger
name string
code string
status boolean
timestamps timestamps
softDeletes softDeletes

warehouses_adderss

id increments
warehouses_id bigInteger
house_no string
address_line_1 string
address_line_2 string
city string
district string
country string
zip string
latitude string
longitude string
softDeletes softDeletes
timestamps timestamps

packages

id increments
author_id bigInteger
author_type string
name string
code string
status boolean
timestamps timestamps
softDeletes softDeletes

package_product_relationship

timestamps timestamps
product_id bigInteger
package_id bigInteger

orders

id increments
user_id bigInteger
type string
total decimal
tax decimal
discount decimal
payment_id string
timestamps timestamps
softDeletes softDeletes

order_ref

id increments
timestamps timestamps
softDeletes softDeletes
order_id bigInteger
user_id bigInteger
type string
total decimal
tax decimal
discount decimal
payment_id bigInteger

leads

id increments
name string
phone string
locations string
timestamps timestamps
softDeletes softDeletes

delivery

id increments
timestamps timestamps
softDeletes softDeletes
order_id bigInteger
warehouse_id bigInteger
user_id bigInteger
status boolean
deliver_boy_id bigInteger
zip string

order_product_reletion

id increments
timestamps timestamps
softDeletes softDeletes
product_id bigInteger
order_id bigInteger
price decimal
quantity string

collection_wallet

id increments
collector_id bigInteger
date date
opening_balance decimal
closing_balance decimal
status string
timestamps timestamps
softDeletes softDeletes

cash_collections

id increments
timestamps timestamps
softDeletes softDeletes
user_id bigInteger
order_id bigInteger
latitude string
longitude string
wallet_id bigInteger
payment decimal
amount decimal
change decimal

cash_collections_log

id increments
timestamps timestamps
softDeletes softDeletes
collector_id bigInteger
logs text

delivery_logs

id increments
timestamps timestamps
softDeletes softDeletes
delivery_boy_id bigInteger
logs text

complains

id increments
timestamps timestamps
softDeletes softDeletes
type string
user_id bigInteger
status string
order_id bigInteger

complain_meta

id increments
timestamps timestamps
softDeletes softDeletes
complain_id bigInteger
meta_name text
meta_value string