ActionInStoredProc


Description

Action stored procedure associations linking workflow actions to database stored procedures for automated processing. This table enables actions to trigger specific database procedures as part of workflow automation and business process execution.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PKID int identity 4 √ null

Primary key - Unique identifier for each action-procedure association
FKSPID int 4 √ null
StoredProc.pkSPID FK__ActionInS__FKSPI__533092BC R

Stored procedure reference - Links to the StoredProc table for the procedure to execute
FKActionID int 4 √ null

Action reference - Links to the workflow action that triggers the stored procedure

Indexes

Constraint Name Type Sort Column(s)
PK__ActionInStoredPr__523C6E83 Primary key Asc PKID

Relationships

Close relationships within degrees of separation