ecom - Laravel Schema Designer

categories

id increments
name json
position integer
Image string
meta_title json
meta_description json
slug json
meta_keywords json
vendor_id ^FK integer
timestamps timestamps

parent_categories

id increments
category_id ^FK integer
parent_id ^FK integer
timestamps timestamps

products

id increments
sku string
Name json
slug json
is_new boolean
is_featured boolean
status enum
description json
short_description json
meta_title json
meta_keywords string
meta_description json
price decimal (2)
width string
height string
depth string
weight string
type enum
stock string
vendor_id ^FK integer
discount_type enum
discount_percentage string
discount_fixed string
timestamps timestamps
vat string

users

id increments
timestamps timestamps

addresses

id increments
user_id ^FK integer
lat string
lng string
address string
is_default boolean
timestamps timestamps

orders

id increments
user_id ^FK integer
vendor_id ^FK integer
is_guest boolean
customer_email string
customer_first_name string
customer_last_name string
customer_phone string
address_id ^FK integer
vendor_address_id ^FK integer
payment_method enum
payment_id string
order_type enum
status enum
total_item_count string
total_price string
sub_total string
discount_percent string
discount_amount string
tax_amount string
tax_percent string
shipping_amount string
delivery_id ^FK integer

order_items

id increments
order_id ^FK integer
product_id ^FK integer
quantity string
timestamps timestamps
product_combination_id ^FK integer

product_offers

id increments
special_price decimal
timestamps timestamps
special_price_from datetime
special_price_to datetime
product_id ^FK integer

variations

id increments
name string
vendor_id ^FK integer
unique_code string
type enum
timestamps timestamps

variation_options

id increments
name string
variation_id ^FK integer
image string
position string
timestamps timestamps

product_variations_options

id increments
variation_name string
variation_id integer
product_id ^FK integer
timestamps timestamps

product_variations_options_values

id increments
variation_name string
variation_id ^FK integer
product_variation_id ^FK integer
timestamps timestamps

product_stocks

id increments
total_stock string
unit_price string
total_price string
product_combination_id ^FK integer
timestamps timestamps

product_combinations

id increments
combination_string string
sku string
Price string
unique_string_id string
product_id ^FK integer
available_stock string
timestamps timestamps

currencies

id increments
timestamps timestamps

sections

id increments
name string
image string
parent_id ^FK integer
timestamps timestamps

coupons

id increments
timestamps timestamps

shipments

id increments
timestamps timestamps

invoices

id increments
timestamps timestamps

counties

id increments
timestamps timestamps

cities

id increments
timestamps timestamps

states

id increments
timestamps timestamps

additional_information

id increments
user_id ^FK integer
timestamps timestamps
section_id ^FK integer
vendor_id ^FK integer
vendor_lat string
vendor_lng string
vendor_address string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01