sismaya_helpdesk_db - Laravel Schema Designer

companies

id increments
name string
abbreviation string
type enum
timestamps timestamps
softDeletes softDeletes

departments

id increments
name string
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string
timestamps timestamps
softDeletes softDeletes

categories

id increments
company_id ^FK bigInteger
name string
timestamps timestamps
softDeletes softDeletes

companies_cito_uselog

id increments
company_id ^FK bigInteger
timestamps timestamps

users

id increments
email string
phone string
password longText
timestamps timestamps
softDeletes softDeletes

user_infos

id increments
user_id ^FK bigInteger
company_id ^FK bigInteger
department_id ^FK bigInteger
role_id ^FK bigInteger
name string
timestamps timestamps
profile_picture string

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