al-zohoor_db - Laravel Schema Designer

users

id increments
name string (191)
email string (191)
password string (255)
phone string (15)
role string (50)
timestamps timestamps

categories

id increments
timestamps timestamps
name string

sub_categories

id increments
timestamps timestamps
softDeletes softDeletes
category_id ^FK integer

products

id increments
sub_category_id ^FK integer
category_id ^FK integer
name string
description string
image string
price float
stock integer
softDeletes softDeletes
timestamps timestamps

comments

id increments
user_id ^FK integer
comment text
timestamps timestamps
product_id ^FK integer

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