sismaya_helpdesk_db - Laravel Schema Designer

companies

id increments
name string
abbreviation string
type enum
cito_quota integer
cito_used integer
cito_reset_at datetime
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
ticket_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
profile_picture string
timestamps timestamps

requests

id increments
user_id ^FK bigInteger
company_id ^FK bigInteger
department_id ^FK bigInteger
category_id ^FK bigInteger
creator_id ^FK bigInteger
assignee_company_id ^FK bigInteger
assignee_id ^FK bigInteger
product_id ^FK bigInteger
progress_status_id ^FK integer
is_cito boolean
rating float
number string
priority enum
description text
step string
timestamps timestamps
softDeletes softDeletes

attachments

id increments
updatable_type string
updatable_id bigInteger
file_name string
file_path string
timestamps timestamps
softDeletes softDeletes

request_assigneelogs

id increments
request_id ^FK bigInteger
assignee_id ^FK bigInteger
creator_id ^FK bigInteger
timestamps timestamps

app_parameters

id increments
name string
value string
description text
timestamps timestamps
softDeletes softDeletes

request_progressionlogs

id increments
request_id ^FK bigInteger
assignee_id ^FK bigInteger
creator_id ^FK bigInteger
progress_status_id ^FK integer
step string
timestamps timestamps

statuses

id increments
company_id ^FK bigInteger
name string
step enum
timestamps timestamps
softDeletes softDeletes
sort integer

products

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

company_product_uses

id increments
company_id ^FK bigInteger
product_id ^FK bigInteger
timestamps timestamps

tasks

id increments
request_id ^FK integer
creator_id ^FK integer
name string
description string
step enum
due_date datetime
timestamps timestamps
softDeletes softDeletes

task_assigneelogs

id increments
task_id ^FK integer
assignee_id ^FK integer
creator_id ^FK integer
timestamps timestamps

request_activitylogs

id increments
request_id ^FK integer
task_id ^FK integer
creator_id ^FK integer
description string
timestamps timestamps

task_worklogs

id increments
timestamps timestamps
task_id ^FK integer
start_task_id ^FK integer
started_at datetime

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