myterroir - Laravel Schema Designer

tabCategory

id increments
avatar string
name string
status string
parent_id integer
parent_category string
slug string
show_on_home_page boolean
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabSeller

id increments
avatar string
name string
preferred_language string
industry_type string
registration_number string
contact_person string
email_id string
contact_no string
phone_no string
address string
post_code string
city string
state string
country string
status string
requires_change_password string
slug string
commission decimal (10,2)
description text
rating decimal (2,1)
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabUser

id increments
full_name string
avatar string
login_id string
password string
email string
role string
status string
email_confirmed tinyInteger
email_confirmation_code string
first_login tinyInteger
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabPostCode

id increments
post_code string
latitude string
longitude string
city string
state string
country string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabFaq

id increments
category_id ^FK integer
status string
title string
description text
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabPressRelease

id increments
avatar string
title string
description text
published_date date
status string
page_url string
slug string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabUnit

id increments
name string
status string
description text
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabOrder

id increments
seller_id ^FK integer
order_no string
order_date timestamp
order_status string
buyer_contact_no string
buyer_id integer
buyer_name string
delivery_address text
sub_total decimal (10,2)
tax_total decimal (10,2)
delivery_charges decimal (10,2)
coupon string
discount_type string
discount_value decimal (10,2)
discount_amount decimal (10,2)
grand_total decimal (10,2)
rounded_total decimal (10,2)
mode_of_payment string
description text
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabOrderTaxDetails

id increments
order_id ^FK integer
name string
tax_type string
rate decimal (10,2)
amount decimal (10,2)
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabOrderDetails

id increments
order_id ^FK integer
product_id integer
web_product_id integer
variant_id integer
customization_id integer
rate decimal (10,2)
qty integer
amount decimal (10,2)
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabOrderStatus

id increments
order_id ^FK integer
status string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabRecipe

id increments
avatar string
status string
title string
description text
preparation_time time
no_of_servings integer
slug string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp
seller_id ^FK integer

tabRecipeProduct

id increments
recipe_id ^FK integer
product_id integer
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabBuyer

id increments
avatar string
title string
name string
dob date
gender string
email_id string
contact_no string
preferred_language string
lifetime_value decimal (10,2)
total_orders integer
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabBuyerAddress

id increments
buyer_id ^FK integer
name string
type string
address text
landmark string
city string
state string
country string
post_code string
contact_no string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabProduct

id increments
avatar string
name string
status string
type string
seller_id ^FK integer
region_id ^FK integer
category_id ^FK integer
starting_price decimal (10,2)
sku string
unit_id ^FK integer
qty decimal (10,2)
max_order_qty decimal (10,2)
inactive_till datetime
variant_product string
customization string
combo_product string
meta_title string
meta_keywords text
meta_description text
slug string
seller_commission decimal (10,2)
description text
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabFaqCategory

id increments
name string
status string
owner string
last_updated_by string
timestamps timestamps

tabProductComboDetails

id increments
product_id ^FK integer
combo_product_id ^FK integer
qty integer
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabProductCustomizationDetails

id increments
product_id ^FK integer
add_on string
label string
parent_add_on string
min_select integer
max_select integer
extra_price decimal (8,2)
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabProductVariantDetails

id increments
product_id ^FK integer
name string
label string
unit_id ^FK integer
conversion_factor decimal (10,2)
price decimal (10,2)
status string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabCoupon

id increments
name string
status string
seller_id ^FK integer
total_coupons integer
total_redeemed integer
valid_from datetime
valid_till datetime
coupon_type string
discount_method string
discount_amount decimal (10,2)
minimum_purchase decimal (10,2)
discount_on string
description text
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabDeliveryArea

id increments
seller string
seller_id ^FK integer
status string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabDeliveryAreaDetails

id increments
delivery_area_id ^FK integer
post_code string
minimum_order decimal (10,2)
delivery_charges decimal (10,2)
delivery_time time
express_delivery_charges decimal (10,2)
express_delivery_time time
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabSellerWorkingDays

id increments
seller_id ^FK integer
day string
start_time time
end_time time
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabSellerHolidays

id increments
seller_id ^FK integer
date date
description text
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabSellerPickLocations

id increments
seller_id ^FK integer
address text
post_code string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabRegion

id increments
avatar text
name string
title string
description text
status string
show_on_carousel boolean
show_on_navbar boolean
slug string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabBuyerFavorites

id increments
buyer_id ^FK integer
product_id ^FK integer
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabProductRelated

id increments
product_id ^FK integer
related_product_id ^FK integer
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabProductComments

id increments
product_id ^FK integer
commentor string
comment text
status string
email_id string
user_id string
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabProductImages

id increments
product_id ^FK integer
avatar string
sort_order integer
owner string
last_updated_by string
created_at timestamp
updated_at timestamp

tabCurrency

id increments
code string
status string (10)
name string
symbol string
country string
description text
owner string
last_updated_by string
timestamps timestamps