fragrance - Laravel Schema Designer

users

name string
id increments
email string
email_verified_at timestamp
password string
phone string
image string
status tinyInteger
remember_token string
created_at timestamp
softDeletes softDeletes
updated_at timestamp

customers

id increments
name string
email string
country_code string
mobile string
dob date
timestamps timestamps
softDeletes softDeletes

otp

id increments
customer_id ^FK bigInteger
otp string
timestamps timestamps

customer_addresses

id increments
customer_id ^FK bigInteger
type tinyInteger
address_line_1 string
address_line_2 string
city string
state string
country string
zip_code string
timestamps timestamps
softDeletes softDeletes

categories

id increments
name string
name_ar string
slug string
image string
video string
status tinyInteger
timestamps timestamps
softDeletes softDeletes

products

id increments
name string
name_ar string
sku string
slug string
price string
image string
video string
description longText
description_ar longText
ingredients longText
ingredients_ar longText
stock string
status tinyInteger
timestamps timestamps
softDeletes softDeletes
brand_id ^FK bigInteger

product_categories

id increments
product_id bigInteger
category_id bigInteger
timestamps timestamps

attributes

id increments
name string
name_ar string
category_id bigInteger
status tinyInteger
timestamps timestamps
softDeletes softDeletes

product_attributes

id increments
product_id bigInteger
attribute_id bigInteger
timestamps timestamps
softDeletes softDeletes

product_images

id increments
product_id bigInteger
image string
timestamps timestamps
softDeletes softDeletes

wishlists

id increments
customer_id bigInteger
product_id bigInteger
timestamps timestamps
softDeletes softDeletes

carts

id increments
customer_id integer
coupon_id bigInteger
total_amount decimal
timestamps timestamps
softDeletes softDeletes

orders

id increments
amount decimal
customer_id bigInteger
shipping_address_id bigInteger
billing_address_id bigInteger
payment_method_id ^FK bigInteger
payment_status tinyInteger
status tinyInteger
delivery_date date
timestamps timestamps
softDeletes softDeletes

order_details

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

cart_details

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

product_ratings

id increments
product_id bigInteger
customer_id string
image string
rating string
review string
timestamps timestamps
softDeletes softDeletes

stores

id increments
name string
name_ar string
address longText
phone string
email string
country string
status string
latitude string
longitude string
timestamps timestamps
softDeletes softDeletes

store_hours

id increments
store_id bigInteger
day string
opening_time time
closing_time time
timestamps timestamps
softDeletes softDeletes

home_banners

id increments
title string
title_ar string
description string
description_ar string
banner_url string
status tinyInteger
timestamps timestamps
softDeletes softDeletes

abouts

id increments
title string
title_ar string
sub_title string
sub_title_ar string
description longText
description_ar longText
image_1 string
image_2 string
timestamps timestamps
softDeletes softDeletes

enquiries

id increments
name string
email string
mobile string
subject string
message string
timestamps timestamps
softDeletes softDeletes

contact_us

id increments
title string
title_ar string
sub_title string
sub_title_ar string
description string
description_ar string
timestamps timestamps
softDeletes softDeletes

privacy_policies

id increments
description longText
description_ar string
timestamps timestamps
softDeletes softDeletes

terms

id increments
description_ar longText
description longText
timestamps timestamps

return_policies

id increments
description longText
description_ar longText
timestamps timestamps

disclaimers

id increments
description longText
description_ar longText
timestamps timestamps

coupons

id increments
name string
coupon_code string
coupon_type enum
target_products string
minimum_cart_value decimal
discount_type tinyInteger
discount_value decimal
maximum_discount_value decimal
validity integer
status tinyInteger
is_single_use tinyInteger
maximum_usage_count integer
timestamps timestamps
softDeletes softDeletes

customer_coupons

id increments
customer_id bigInteger
coupon_id bigInteger
from_date date
end_date date
is_used tinyInteger
timestamps timestamps
softDeletes softDeletes

loyalty_points

id increments
point_value decimal (5,2)
min_redemption_point integer
timestamps timestamps
softDeletes softDeletes

customer_loyalties

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK bigInteger
loyalty_points integer
loyalty_points_redeemed integer

general_settings

id increments
logo string
facebook_logo string
instagram_logo string
twitter_logo string
linked_logo string
facebook string
instagram string
twitter string
linked_in string
contact_number_1 string
contact_number_2 string
email string
copyright_text string
control_panel_title string
seo_url string
meta_title string
meta_tag string
meta_description string
timestamps timestamps

wallets

id increments
customer_id bigInteger
total_wallet_amount decimal
status tinyInteger
timestamps timestamps
softDeletes softDeletes

wallet_details

id increments
wallet_id ^FK bigInteger
amount decimal
transaction_type enum
description string
timestamps timestamps
softDeletes softDeletes

news_letters

id increments
email string
timestamps timestamps
softDeletes softDeletes

offers

id increments
title string
title_ar string
description string
description_ar string
from_date datetime
to_date datetime
type enum
value integer
maximum_value integer
status tinyInteger
timestamps timestamps
softDeletes softDeletes

offer_products

id increments
offer_id bigInteger
product_id bigInteger
timestamps timestamps
softDeletes softDeletes

gift_cards

id increments
gift_card_code string (50)
title string
title_ar string
image string
is_active tinyInteger
validity integer
softDeletes softDeletes
timestamps timestamps

gift_card_orders

id increments
type tinyInteger
gift_card_Id bigInteger
customer_id ^FK bigInteger
total_amount decimal
payment_status enum
recipient_name string
recipient_email string
sender_name string
phone string
valid_from date
valid_to date
message string
delivery_date date
timestamps timestamps
softDeletes softDeletes

product_videos

id increments
product_id ^FK bigInteger
video string
timestamps timestamps
softDeletes softDeletes

product_features

id increments
product_id ^FK bigInteger
feature string
timestamps timestamps
softDeletes softDeletes

product_highlights

id increments
product_id ^FK bigInteger
highlight string
timestamps timestamps
softDeletes softDeletes

brands

id increments
brand_name string
founded_year date
description string
description_ar string
timestamps timestamps
softDeletes softDeletes

product_collection

id increments
product_id ^FK bigInteger
collection_name string (100)
collection_title string (100)
timestamps timestamps
softDeletes timestamp

payment_methods

id increments
method_name string (100)
description string
active boolean
timestamps timestamps
softDeletes softDeletes

product_stores

id increments
timestamps timestamps
softDeletes softDeletes