NBE_DB - Laravel Schema Designer

users

id increments
name string (150)
mobile string (15)
email string (100)
password string (100)
status tinyInteger
organization_id ^FK integer
timestamp timestamps
softdelete softDeletes

role_groups

id increments
name string (200)
organization_id ^FK integer
timestamp timestamps
softdelete softDeletes

user_has_roles

id integer
role_id ^FK integer
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string (100)
role_group_id ^FK integer
organization_id ^FK integer
timestamp timestamps
softdelete softDeletes

role_has_permissions

id increments
role_id ^FK integer
permission_id ^FK integer
timestamp timestamps
softdelete softDeletes

module_has_permissions

id integer
module_id ^FK integer
permission_id ^FK integer
timestamps timestamps
softDeletes softDeletes

modules

id increments
name string (200)
url string (150)
description text
parent_id ^FK integer
organization_id integer
timestamps timestamps
softDeletes softDeletes

auditor

id increments
table_id integer
table_name string (150)
action_type tinyInteger
user_id integer
timestamp timestamps
data json

permissions

id increments
name string (150)
organization_id ^FK integer
timestamp timestamps
softdelete softDeletes

organizations

id increments
name string (200)
sub_domain string (32)
timestamps timestamps
softDeletes softDeletes

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