RSM sytem - Laravel Schema Designer

branch

id increments
code string (255)
name string (255)
timestamps timestamps

user

id increments
name string (255)
email string (255)
password string (255)
branch_id ^FK integer
timestamps timestamps

admin

id increments
name string (255)
email string (255)
password string (255)
role string (20)
timestamps timestamps

user_request

id increments
user_id ^FK integer
item_id ^FK integer
quantity integer
timestamps timestamps

brand

id increments
name string (255)
timestamps timestamps

category

id increments
brand_id integer
name string (255)
timestamps timestamps

sub_category

id increments
category_id integer
name string (255)
timestamps timestamps

item

id increments
sub_category integer
code integer
name string (255)
timestamps timestamps

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