workflow - Laravel Schema Designer

users

id increments
name string
email string
password string
role enum
softDeletes softDeletes
timestamps timestamps

workflows

id increments
name string
description string
user_id ^FK bigInteger
status enum
visibility enum
start_date date
end_date date
priority enum
version integer
approved_by ^FK bigInteger
softDeletes softDeletes
timestamps timestamps

steps

id increments
name string
description string
workflow_id ^FK bigInteger
condition_id ^FK bigInteger
assigned_to ^FK bigInteger
order integer
type enum
status enum
due_date date
completion_date date
attachments string
notes string
softDeletes softDeletes
timestamps timestamps

conditions

id increments
workflow_id ^FK bigInteger
condition_name string
operator enum
condition_settings text
softDeletes softDeletes
timestamps timestamps

notifications

id increments
step_id ^FK bigInteger
user_id ^FK bigInteger
workflow_id ^FK bigInteger
message string
type enum
is_read boolean
delivery_time date
softDeletes softDeletes
timestamps timestamps

integrations

id increments
name string
type enum
Is_enabled boolean
softDeletes softDeletes
timestamps timestamps

integration_step

id increments
step_id ^FK bigInteger
integration_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

user_workflow

id increments
workflow_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

triggers

id increments
workflow_id ^FK bigInteger
trigger_type string
trigger_details string
is_active boolean
softDeletes softDeletes
timestamps timestamps

forms

id increments
name string
field_id ^FK bigInteger
is_published boolean
softDeletes softDeletes
timestamps timestamps

form_submissions

id increments
form_id ^FK bigInteger
workflow_id ^FK bigInteger
status enum
softDeletes softDeletes
timestamps timestamps

fields

id increments
step_id ^FK bigInteger
name string
type enum
is_required boolean
validation_rules string
default_value string
options string
softDeletes softDeletes
timestamps timestamps

comments

id increments
timestamps timestamps

connections

id increments
from_step_id ^FK bigInteger
to_step_id ^FK bigInteger
condition_id ^FK bigInteger
Is_conditional boolean
Is_disabled boolean
softDeletes softDeletes
timestamps timestamps

processes

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string

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