al-osimi v1 - Laravel Schema Designer

users

id bigIncrements
timestamps timestamps
softDeletes softDeletes
first_name string
middle_name string
last_name string
email string
mobile string
password string
status tinyInteger

departments

id bigIncrements
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
status tinyInteger

department_user

id bigIncrements
timestamps timestamps
department_id ^FK bigInteger
user_id ^FK bigInteger

action_lists

id bigIncrements
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
type tinyInteger
data text
status tinyInteger

process_steps

id bigIncrements
timestamps timestamps
softDeletes softDeletes
process_id ^FK bigInteger
process_version json
name_ar string
name_en string
order integer
target nullableMorphs

processes

id bigIncrements
timestamps timestamps
softDeletes softDeletes
serial string
name_ar string
name_en string
version_date datetime
status tinyInteger
notes text

durations

id bigIncrements
timestamps timestamps
softDeletes softDeletes
related morphs
type tinyInteger
value integer

process_step_actions

id bigIncrements
timestamps timestamps
softDeletes softDeletes
process_step_id ^FK bigInteger
process_step_version json
target morphs
component morphs
component_version json
order integer
result json
process_step_action_id ^FK bigInteger

dynamic_forms

id bigIncrements
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
description_ar text
description_en text
will_be_signed tinyInteger
signers_data string
signature_invitation_data json
status tinyInteger

dynamic_form_fields

id bigIncrements
timestamps timestamps
softDeletes softDeletes
dynamic_form_id ^FK bigInteger
name_ar string
name_en string
type tinyInteger
data json
component nullableMorphs

dynamic_lists

id bigIncrements
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
description_ar text
description_en string
type tinyInteger
data json
status tinyInteger

file_template

id bigIncrements
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
content_ar text
content_en text
type tinyInteger
file_template_id ^FK bigInteger

attachments

id bigIncrements
timestamps timestamps
softDeletes softDeletes
related nullableMorphs
path string
extension string
name_ar string
name_en string
privacy tinyInteger
key tinyInteger
user_id ^FK bigInteger

readable_logs

id bigIncrements
timestamps timestamps
softDeletes softDeletes
related morphs
name_ar string
name_en string
content_ar text
content_en text
causer nullableMorphs

process_execution

id bigIncrements
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
process_id ^FK bigInteger
process_version json
process_steps_version json
start_date datetime
end_date datetime
deadline_date datetime

process_execution_steps

id bigIncrements
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
process_execution_id ^FK bigInteger
process_step_version_id bigInteger
process_step_version_actions json
data json
start_date datetime
end_date datetime
deadline_date datetime
actions_count integer
done_actions_count integer
status tinyInteger

process_execution_step_actions

id bigIncrements
timestamps timestamps
softDeletes softDeletes
process_step_version_action_id bigInteger
data json
status tinyInteger

electronic_signatures

id bigIncrements
timestamps timestamps
softDeletes softDeletes
related morphs
online_document_id string
user_id ^FK bigInteger
user_email string
user_version json
invitation_role string
invitation_order integer
status tinyInteger

categories

id bigIncrements
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
status tinyInteger

category_department

id increments
timestamps timestamps
category_id ^FK bigInteger
department_id ^FK bigInteger

tasks

id increments
timestamps timestamps
softDeletes softDeletes
category_id ^FK bigInteger
user_id ^FK bigInteger
content_ar text
content_en text
status tinyInteger

notification_templates

id increments
timestamps timestamps
softDeletes softDeletes
title_ar string
title_en string
content_ar text
content_en text

settings

id increments
timestamps timestamps
softDeletes softDeletes
group string
key string
value text

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