ecomHM - Laravel Schema Designer

categories

id increments
ar_name string (255)
en_name string (255)
image string (255)
status tinyInteger
timestamps timestamps
softDeletes softDeletes
profit_ratio string (255)

subcategories

id increments
category_id integer
ar_name string (255)
en_name string (255)
image string (255)
status tinyInteger
timestamps timestamps
softDeletes softDeletes

products

id increments
category_id integer
subcategory_id integer
seller_id integer
ar_name string (255)
en_name string (255)
ar_details longText
en_details longText
image string (255)
active tinyInteger
status tinyInteger
reason_refused string (255)
timestamps timestamps
softDeletes softDeletes

products_attributes

id increments
product_id integer
sku integer
size string (255)
purchase_price string
price string
color string
stock string
timestamps timestamps
softDeletes softDeletes

products_images

id increments
product_id integer
image string
timestamps timestamps
softDeletes softDeletes

favourites

id increments
user_id integer
product_id integer
timestamps timestamps

carts

id increments
user_id integer
productsAttribute_id integer
quantity string
timestamps timestamps

orders

id increments
timestamps timestamps
user_id string
seller_id string
user_email string
name string
address string
city string
country string
mobile string
order_status string
payment_method string
shipping_charges string
order_comments string
grand_total string
reason_refused string

order_details

id increments
timestamps timestamps
order_id string
user_id string
seller_id string
category_id string
subcategory_id string
product_id string
product_code string
product_name string
product_color string
product_size string
product_price string
seller_cost string
customer_cost string
seller_profit string
product_qty string

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