kirthidiamond_db - Laravel Schema Designer

admin_users

id increments
name string (256)
email string (256)
password string (256)
mobile integer
role tinyInteger
status tinyInteger
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string (256)
slug string (256)
description string (256)
timestamps timestamps
softDeletes softDeletes

permissions

id increments
title string (256)
description string (256)
slug string (256)
timestamps timestamps
softDeletes softDeletes

role_has_permissions

id increments
role_id ^FK integer
permission_id ^FK integer
timestamps timestamps
softDeletes softDeletes

user_otp

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
otp smallInteger

users

id increments
session_token string (256)
name string (256)
email string (256)
mobile integer
country string (256)
address text
city string (256)
pincode smallInteger
status tinyInteger
timestamps timestamps
softDeletes softDeletes

faq

question text
answer text
id increments
timestamps timestamps
softDeletes softDeletes

categories

id increments
name string (256)
slug string (256)
image text
order integer
parent_id integer
parent_name string (256)
size_chart text
status tinyInteger
timestamps timestamps
softDeletes softDeletes

blog

id increments
title text
sub_title text
content text
image text
status tinyInteger
timestamps timestamps
softDeletes softDeletes

category_attributes

id increments
category_id ^FK integer
name string (256)
value string (256)
timestamps timestamps
softDeletes softDeletes

category_attributes_size

id increments
attribute_id ^FK integer
size text
status tinyInteger
timestamps timestamps
softDeletes softDeletes

products

id increments
name string (256)
features text
details text
image text
price bigInteger
tax double
total_price bigInteger
status tinyInteger
timestamps timestamps
softDeletes softDeletes

products_attributes

id increments
product_id ^FK integer
attribute_id ^FK integer
status tinyInteger
timestamps timestamps
softDeletes softDeletes

products_attributes_size

id increments
product_id ^FK integer
attribute_id ^FK integer
size_id ^FK integer
status tinyInteger
timestamps timestamps
softDeletes softDeletes

product_category

id increments
product_id ^FK integer
category_id ^FK integer
status tinyInteger
timestamps timestamps
softDeletes softDeletes

product_images

id increments
product_id ^FK integer
image text
timestamps timestamps
softDeletes softDeletes

related_products

id increments
product_id ^FK integer
related_id ^FK integer
timestamps timestamps
softDeletes softDeletes

cart

id increments
user_id ^FK integer
product_id ^FK integer
quantity integer
timestamps timestamps
softDeletes softDeletes

delivery_address

id increments
user_id ^FK integer
name string (256)
country string (256)
address text
city string (256)
pincode smallInteger
mobile integer
email string (256)
timestamps timestamps
softDeletes softDeletes

order

id increments
order_no bigInteger
user_id ^FK integer
payment_method string (256)
razorpay_orderid string (256)
delivery_date date
delivery_fee integer
tax double
amount bigInteger
grand_total bigInteger
order_status_id ^FK integer
timestamps timestamps
softDeletes softDeletes

order_products

id increments
order_id ^FK integer
product_id ^FK integer
quantity smallInteger
timestamps timestamps
softDeletes softDeletes

status

id increments
timestamps timestamps
softDeletes softDeletes
name string (256)

order_status

id increments
order_id bigInteger
status_id ^FK integer
timestamps timestamps
softDeletes softDeletes

settings

id increments
title string (256)
slug string (256)
description text
left_image text
right_image text
video_link text
timestamps timestamps
softDeletes softDeletes

banner

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)
image text
type tinyInteger
url text
order integer
status tinyInteger

product_request

id increments
enquiry_type string (256)
name string (256)
contact integer
email string (256)
message text
mode_of_contact string (256)
timestamps timestamps
softDeletes softDeletes