e-commerce website - Laravel Schema Designer

category

id integer
cat_name string (255)
cate_image text
created_at timestamp
updated_at timestamp

product

id integer
product_name string (255)
product_des text
qty integer
MRP decimal
selling_price decimal
image text
created_at timestamp
updated_at timestamp
fk_catid ^FK integer

cart

id binary
fk_product_id ^FK integer
qty integer
cost decimal
created_at timestamp
updated_at timestamp

order

id integer
order_id string (255)
order_amount decimal
order_date datetime
order_status text
fk_userid ^FK integer
order_type text
created_at timestamp
updated_at timestamp

order_items

id integer
item_name string (255)
items_amount decimal
items_qty integer
fk_orderid ^FK integer

user

id integer
first_name string (255)
last_name string (255)
email string (255)
phone integer
password string (255)
profile_pic text

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