ICS Permissions 2 - Laravel Schema Designer

menus

id increments
menu_no string (50)
level_no tinyInteger
level_status boolean
name_ar string (191)
name_en string (191)
desc_ar text
desc_en text
actions string (50)
route_name string (191)
parent_id ^FK integer
menu_section_id ^FK integer
softDeletes softDeletes
timestamps timestamps

sectors

id increments
name_ar string (191)
name_en string (191)
desc_ar text
desc_en text
timestamps timestamps
softDeletes softDeletes

activitytypes

id increments
Actvty_No integer
Name_Ar string (191)
Name_En string (191)
sector_id ^FK integer
softDeletes softDeletes
timestamps timestamps

maincompany

id increments
app_client_id ^FK integer
timestamps timestamps
softDeletes softDeletes

app_clients

id increments
name string (191)
email string (100)
address string (191)
phone string (20)
phone2 string (20)
website string (191)
status boolean
user_id ^FK integer
softDeletes softDeletes
timestamps timestamps

users

id increments
username string (100)
email string (100)
password string (100)
first_name string (100)
last_name string (100)
email_verified_at timestamp
mobile string (50)
status boolean
current_company integer
current_branch integer
user_type enum
lang string (20)
rememberToken rememberToken
softDeletes softDeletes
timestamps timestamps
last_login datetime

roles

id increments
company_id ^FK integer
name_ar string (100)
name_en string (100)
timestamps timestamps

role_permissions

id increments
role_id ^FK integer
company_menu_id ^FK integer
is_able_to string (50)
timestamps timestamps

company_menu

id increments
company_id ^FK integer
menu_id ^FK integer
timestamps timestamps

user_permissions

id increments
user_id ^FK integer
role_permission_id ^FK integer
is_able_to string (50)
timestamps timestamps

activity_menu

id increments
activity_id ^FK integer
menu_id ^FK integer
timestamps timestamps

role_user

id increments
user_id ^FK integer
role_id ^FK integer
timestamps timestamps

menu_sections

id increments
type string (100)
name_ar string (100)
name_en string (100)
timestamps timestamps

menu_sectionables

id increments
menu_section_id ^FK integer
menu_sectionable_id integer
menu_sectionable_type string
timestamps timestamps

modules

id increments
activity_id ^FK integer
name_ar string (100)
name_en string (100)
desc_ar text
desc_en string
monthly_sub decimal (10,2)
annual_sub decimal (10,2)
currency_id integer
discount decimal (8,2)
timestamps timestamps

menu_module

id increments
module_id ^FK integer
menu_id ^FK integer
timestamps timestamps

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