atomberg - Laravel Schema Designer

users

id increments
user_type string (255)
display_name string (255)
username string (255)
email string (255)
password string (255)
status string (255)
timestamps timestamps
softDeletes softDeletes

customer

id increments
email string (255)
mobile_no string (15)
password string (255)
status string (255)
email_verifiy_status string (255)
mobile_verify_status string (255)
timestamps timestamps
softDeletes softDeletes

customer_profile

id increments
customer_id ^FK integer
first_name string (255)
middle_name string (255)
last_name string (255)
address_line1 text
address_line2 text
city string (255)
state string (255)
zipcode string (10)
timestamps timestamps
softDeletes softDeletes

product_categories

id increments
category_name string (255)
thumbnail string (255)
timestamps timestamps
softDeletes softDeletes

product_subcategories

id increments
category_id ^FK integer
subcategory_name string (255)
thumbnail string (255)
timestamps timestamps
softDeletes softDeletes

product

id increments
subcategories_id ^FK integer
category_id ^FK integer
product_name string (255)
price decimal
selling_price decimal
unit_of_measurement string (255)
product_details text
quantity integer
timestamps timestamps
softDeletes softDeletes

product_images

id increments
product_id ^FK integer
product_image string (255)
timestamps timestamps
softDeletes softDeletes

review_feedback

id increments
customer_id ^FK integer
product_id ^FK integer
review text
rating decimal
timestamps timestamps
softDeletes softDeletes

order

id increments
invoice_no string (15)
customer_id ^FK integer
payment_status string (25)
final_amount decimal
total_discount decimal
transaction_date datetime
order_status string (25)
alternative_address text
timestamps timestamps
softDeletes softDeletes

order_transaction

id increments
order_id ^FK integer
product_id ^FK integer
quantity integer
rate decimal
discount decimal
total_amount decimal
timestamps timestamps
softDeletes softDeletes

offer

id increments
title string (255)
discount decimal
timestamps timestamps
softDeletes softDeletes

coupon

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
code string (15)
discount decimal

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