tbl_stage_trigger_action_users

62 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
stagetriggeractionid int8 19 null
tbl_stage_trigger_action.id fkpgnmik3fh7s5r2txljwi86of6 R

FK: public.tbl_stage_trigger_action.id
Meaning: The automated trigger action (e.g., Send Email, Update Field) to which this user/role mapping applies.
Dependency: Defines what action the user is being related to.
accesscontrollid int8 19 null
tbl_stage_access_controll.id fkditxthptyj633l7xt3jqtld4w R

FK: public.tbl_stage_access_controll.id or public.tbl_stage_access.id (Presumed Foreign Key)
Meaning: The user or group identified by an access control record.
Logic: Defines who is the target recipient of the trigger action (e.g., who gets the email, or whose field is being updated).

Indexes

Constraint Name Type Sort Column(s)
tbl_stage_trigger_action_users_pk__tbl_stag__5626c42ce800e430 Primary key Asc/Asc stagetriggeractionid + accesscontrollid

Relationships

Close relationships within degrees of separation