tbl_stage_trigger

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single workflow trigger rule.

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who defined and created this automation trigger.

Timestamp of when the trigger rule was created.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The last user who modified this trigger rule.

Timestamp of when the trigger rule was last modified.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ

The conditional expression that must be met to execute the trigger.
Format: Text (e.g., JSON or logical string)
Example: {"column": "salary", "operator": ">", "value": 50000}

The type of action the trigger performs when activated.
Format: Varchar/Text or lookup key
Example: Send_Email, Move_to_Next_Stage, Update_Field, Execute_Script.

The value or parameter associated with the trigger action.
Format: Text or Varchar
Example: The email template ID to send, or the ID of the next stage to move to.

FK: public.tbl_stage.id (Presumed Foreign Key)
Meaning: The workflow stage where this trigger is configured to check for criteria.
Dependency: The trigger evaluates when the record enters or leaves this specific stage.