tbl_stage_trigger_action

42 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_stage_trigger_action_id_seq'::regclass)
tbl_stage_trigger_action_users.stagetriggeractionid fkpgnmik3fh7s5r2txljwi86of6 R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single action executed upon a trigger firing.
createdby varchar 50 null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who defined this action.
createddate timestamp 29,6 √ null

Timestamp of when the trigger action record was created.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The last user who modified this trigger action record.
modifieddate timestamp 29,6 √ null

Timestamp of when the trigger action record was last modified.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
type varchar 255 √ null

The type of action to be performed.
Format: Varchar/Text or lookup key
Example: Send_Email, Webhook_Call, Field_Update, System_Alert.
value varchar 255 √ null

The payload or parameter required to execute the action.
Format: Text or JSONB
Example: The body of the email to send, or the URL for the webhook.
failid int8 19 √ null
tbl_stage_trigger.id fkcjorgrjn0ntyg8xgoigijjepg R

FK: public.tbl_stage.id or public.tbl_stage_actions.id (Presumed Foreign Key)
Meaning: The stage/action to execute if the trigger action FAILS.
Logic: Defines the alternative path for workflow if the automated action (e.g., API call) is unsuccessful.
successid int8 19 √ null
tbl_stage_trigger.id fknnossp3hywub4wrty44i1sb9b R

FK: public.tbl_stage.id or public.tbl_stage_actions.id (Presumed Foreign Key)
Meaning: The stage/action to execute if the trigger action is SUCCESSFUL.
Logic: Defines the next step in the workflow when the automated action completes as expected (e.g., move to the next stage).

Indexes

Constraint Name Type Sort Column(s)
tbl_stage_trigger_action_pk__tbl_stag__3213e83fa4585195 Primary key Asc id

Relationships

Close relationships within degrees of separation