Home
fragrance
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for fragrance
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01