newdashboard - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
username string (255)
password string (600)
user_group_id ^FK integer
rememberToken rememberToken
email string
phone string

user_group

id increments
timestamps timestamps
softDeletes softDeletes
name_en string (255)
name_ckb string (255)
name_ar string (255)
user_id integer

system_part

id increments
timestamps timestamps
softDeletes softDeletes
key string (255)

system_route

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
system_part_id ^FK integer
type string (255)

group_system_part

id increments
timestamps timestamps
softDeletes softDeletes
user_group_id ^FK integer
system_part_id ^FK integer
read integer
add integer
update integer
delete integer
day integer

log

id increments
timestamps timestamps
softDeletes softDeletes
event string (255)
user_id ^FK integer
log_type string (255)
log_id integer

log_data

id increments
timestamps timestamps
softDeletes softDeletes
log_id ^FK integer
type string (50)
data string (5120)

office

id increments
timestamps timestamps
softDeletes softDeletes
name_ckb string
name_ar string
name_en string
banner string

user_office

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
office_id ^FK integer

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