v_all_actions

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

actionTrigger

VARCHAR

16

actionTriggerId

BIGINT

19

√

null

name

VARCHAR

101

√

null

subType

VARCHAR

255

√

null

condition

TEXT

65535

√

null

action

VARCHAR

50

params

VARCHAR

500

√

null

id

BIGINT

19

0

notes

LONGTEXT

2147483647

√

null

notificationId

BIGINT

19

√

null

notification.id

Implied Constraint

R

Relationships

Close relationships within degrees of separation

View Definition

select 'Milestone' AS `actionTrigger`,`task`.`task_id` AS `actionTriggerId`,`task`.`task` AS `name`,`act`.`type` AS `subType`,`act`.`condition` AS `condition`,`act`.`action` AS `action`,`act`.`params` AS `params`,`act`.`id` AS `id`,`act`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`milestone_action` `act` join `tb2`.`milestone_tasks` `task` on((`task`.`task_id` = `act`.`milestone_task_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` like '%milestone') and (`na`.`action_id` = `act`.`id`)))) union select (case when (`fact`.`table_column` = 'mailingAddress') then 'AddressChange' else 'StoreField' end) AS `Name_exp_9`,`fld`.`id` AS `id`,`fld`.`name` AS `name`,NULL AS `NULL`,`fact`.`condition` AS `condition`,`fact`.`action` AS `action`,`fact`.`params` AS `params`,`fact`.`id` AS `id`,`fact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`project_field_action` `fact` left join `tb2`.`project_field` `fld` on(((`fld`.`table_name` = `fact`.`table_name`) and (`fld`.`table_column` = `fact`.`table_column`)))) left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'storeField') and (`na`.`action_id` = `fact`.`id`)))) union select 'StoreForm' AS `StoreForm`,`frm`.`id` AS `id`,`frm`.`name` AS `name`,NULL AS `NULL`,`fmact`.`condition` AS `condition`,`fmact`.`action` AS `action`,`fmact`.`params` AS `params`,`fmact`.`id` AS `id`,`fmact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`project_form_action` `fmact` join `tb2`.`project_form` `frm` on((`frm`.`id` = `fmact`.`form_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'storeForm') and (`na`.`action_id` = `fmact`.`id`)))) union select 'Asset' AS `Asset`,NULL AS `NULL`,(case when (`aact`.`table_column` is null) then NULL else concat(`aact`.`table_name`,'.',`aact`.`table_column`) end) AS `Name_exp_27`,`aact`.`trigger` AS `trigger`,`aact`.`condition` AS `condition`,`aact`.`action` AS `action`,`aact`.`params` AS `params`,`aact`.`id` AS `id`,`aact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from (`tb2`.`asset_action` `aact` left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'asset') and (`na`.`action_id` = `aact`.`id`)))) union select 'Legal' AS `Legal`,`ltrig`.`id` AS `id`,`ltrig`.`name` AS `name`,NULL AS `NULL`,`lact`.`condition` AS `condition`,`lact`.`action` AS `action`,`lact`.`params` AS `params`,`lact`.`id` AS `id`,`lact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`legal_action` `lact` join `tb2`.`legal_trigger` `ltrig` on((`ltrig`.`id` = `lact`.`trigger_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'legal') and (`na`.`action_id` = `lact`.`id`)))) union select 'Photo' AS `Photo`,`ptrig`.`id` AS `id`,`ptrig`.`name` AS `name`,NULL AS `NULL`,`pact`.`condition` AS `condition`,`pact`.`action` AS `action`,`pact`.`params` AS `params`,`pact`.`id` AS `id`,`pact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`photo_action` `pact` join `tb2`.`photo_action_trigger` `ptrig` on((`ptrig`.`id` = `pact`.`trigger_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'photo') and (`na`.`action_id` = `pact`.`id`)))) union select 'File' AS `File`,NULL AS `NULL`,`fileact`.`directory` AS `directory`,`fileact`.`subtype` AS `subtype`,`fileact`.`condition` AS `condition`,`fileact`.`action` AS `action`,`fileact`.`params` AS `params`,`fileact`.`id` AS `id`,`fileact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from (`tb2`.`file_action` `fileact` left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'File') and (`na`.`action_id` = `fileact`.`id`)))) union select 'SiteFile' AS `SiteFile`,NULL AS `NULL`,`fileact`.`directory` AS `directory`,`fileact`.`subtype` AS `subtype`,`fileact`.`condition` AS `condition`,`fileact`.`action` AS `action`,`fileact`.`params` AS `params`,`fileact`.`id` AS `id`,`fileact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from (`tb2`.`site_file_action` `fileact` left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'SiteFile') and (`na`.`action_id` = `fileact`.`id`)))) union select 'Workflow' AS `Workflow`,NULL AS `NULL`,concat('Workflow ',replace(`worka`.`trigger`,'_',' ')) AS `name`,`worka`.`trigger` AS `trigger`,`worka`.`condition` AS `condition`,`worka`.`action` AS `action`,`worka`.`params` AS `params`,`worka`.`id` AS `id`,`worka`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from (`tb2`.`workflow_action` `worka` left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'Workflow') and (`na`.`action_id` = `worka`.`id`)))) union select 'Scheduled' AS `Scheduled`,NULL AS `NULL`,`n`.`name` AS `name`,(case when (`schact`.`month_of_quarter` <> '') then 'Quarterly' when (`schact`.`month_of_year` <> '') then 'Yearly' when (`schact`.`week_of_month` <> '') then 'Monthly' when (`schact`.`day_of_month` <> '') then 'Monthly' when (`schact`.`day_of_week` <> '') then 'Weekly' else 'Daily' end) AS `subType`,`schact`.`condition` AS `condition`,`schact`.`action` AS `action`,`schact`.`params` AS `params`,`schact`.`id` AS `id`,`schact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`scheduled_action` `schact` join `tb2`.`notification_action` `na` on(((`na`.`type` in ('Daily','Weekly','MonthlyByDate','MonthlyByWeek','Quarterly','Yearly')) and (`na`.`action_id` = `schact`.`id`)))) join `tb2`.`notification` `n` on(((`n`.`id` = `na`.`notification_id`) and (ifnull(`n`.`active`,0) = 1)))) union select 'SitePack' AS `SitePack`,`sptrig`.`id` AS `id`,NULL AS `NULL`,`sptrig`.`name` AS `name`,`spact`.`condition` AS `condition`,`spact`.`action` AS `action`,`spact`.`params` AS `params`,`spact`.`id` AS `id`,`spact`.`Notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`site_pack_action` `spact` join `tb2`.`site_pack_action_trigger` `sptrig` on((`sptrig`.`id` = `spact`.`trigger_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'sitepack') and (`na`.`action_id` = `spact`.`id`)))) union select 'Punchlist' AS `Punchlist`,`ptrig`.`id` AS `id`,NULL AS `NULL`,`ptrig`.`name` AS `name`,`pact`.`condition` AS `condition`,`pact`.`action` AS `action`,`pact`.`params` AS `params`,`pact`.`id` AS `id`,`pact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`punch_list_action` `pact` join `tb2`.`punch_list_action_trigger` `ptrig` on((`ptrig`.`id` = `pact`.`trigger_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'punchlist') and (`na`.`action_id` = `pact`.`id`)))) union select 'ActivityLog' AS `ActivityLog`,NULL AS `NULL`,`alact`.`trigger` AS `trigger`,NULL AS `NULL`,`alact`.`condition` AS `condition`,`alact`.`action` AS `action`,`alact`.`params` AS `params`,`alact`.`id` AS `id`,`alact`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from (`tb2`.`activity_log_action` `alact` left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'activityLog') and (`na`.`action_id` = `alact`.`id`)))) union select 'VendorTask' AS `VendorTask`,`trig`.`id` AS `id`,NULL AS `NULL`,`trig`.`name` AS `name`,`act`.`condition` AS `condition`,`act`.`action` AS `action`,`act`.`params` AS `params`,`act`.`id` AS `id`,`act`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`vendor_task_action` `act` join `tb2`.`vendor_task_action_trigger` `trig` on((`trig`.`id` = `act`.`trigger_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'vendorTask') and (`na`.`action_id` = `act`.`id`)))) union select 'TempClosure' AS `TempClosure`,`trig`.`id` AS `id`,NULL AS `NULL`,`trig`.`name` AS `name`,`act`.`condition` AS `condition`,`act`.`action` AS `action`,`act`.`params` AS `params`,`act`.`id` AS `id`,`act`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`temp_closure_action` `act` join `tb2`.`temp_closure_action_trigger` `trig` on((`trig`.`id` = `act`.`trigger_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'tempClosure') and (`na`.`action_id` = `act`.`id`)))) union select 'ProgramMilestone' AS `actionTrigger`,`type`.`id` AS `actionTriggerId`,`type`.`title` AS `name`,`act`.`type` AS `subType`,`act`.`condition` AS `condition`,`act`.`action` AS `action`,`act`.`params` AS `params`,`act`.`id` AS `id`,`act`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`program_milestone_action` `act` join `tb2`.`program_milestone_type` `type` on((`type`.`id` = `act`.`milestone_type_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` like '%program_milestone%') and (`na`.`action_id` = `act`.`id`)))) union select 'Program' AS `Program`,`trig`.`id` AS `id`,NULL AS `NULL`,`trig`.`name` AS `name`,`act`.`condition` AS `condition`,`act`.`action` AS `action`,`act`.`params` AS `params`,`act`.`id` AS `id`,`act`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from ((`tb2`.`program_action` `act` join `tb2`.`program_action_trigger` `trig` on((`trig`.`id` = `act`.`trigger_id`))) left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'tempClosure') and (`na`.`action_id` = `act`.`id`)))) union select 'ProgramWorkflow' AS `actionTrigger`,NULL AS `NULL`,concat('Program Workflow ',replace(`pworka`.`trigger`,'_',' ')) AS `name`,`pworka`.`trigger` AS `trigger`,`pworka`.`condition` AS `condition`,`pworka`.`action` AS `action`,`pworka`.`params` AS `params`,`pworka`.`id` AS `id`,`pworka`.`notes` AS `notes`,`na`.`notification_id` AS `notificationId` from (`tb2`.`program_workflow_action` `pworka` left join `tb2`.`notification_action` `na` on(((`na`.`type` = 'ProgramWorkflow') and (`na`.`action_id` = `pworka`.`id`))))

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views