[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]

This view returns process dependencies inferred from configured resource dependencies.

A process dependency is a requirement that two processes be run in a specific order; i.e. A must run before B, and not B before A. The view refers to the process that must run first as the predecessor and the later process as the successor.

Sprockit stores dependency information in the form of resource dependencies because they are easier to configure, but process handlers need process dependency information to determine when a process is ready for execution. This view performs a self-join on sprockit.Resource, joining output resources to their subsequent use as input resources, inferring an execution dependency between the associated processes.

Column name1) Column type Description Notes
RL1 PredecessorId INT Identifies the predecessor process
PredecessorFqName NVARCHAR(392) The predecessor process's three-part name From sprockit.uvw_Process
PredecessorStatus VARCHAR(20) The predecessor process's status From sprockit.uvw_Process
Predecessor ProcessType VARCHAR(2) The predecessor process's type From sprockit.uvw_Process
RL2 SuccessorId INT Identifies the successor process
SuccessorFqName NVARCHAR(392) The successor process's three-part name From sprockit.uvw_Process
SuccessorStatus VARCHAR(20) The successor process's status From sprockit.uvw_Process
SuccessorProcessType VARCHAR(2) The successor process's type From sprockit.uvw_Process

Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.

Click here to view the data model diagram.

(in this table)
Referenced table Referenced attributes
(in referenced table)
RL1 PredecessorId sprockit.Process ProcessId
RL2 SuccessorId sprockit.Process ProcessId
Relationship Attributes
(in referencing table)
Referenced attributes
(in this table)

Page generated from database metadata by DbScout.

Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.