/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.uvw_ProcessDependency ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ]

This view returns [[sprockit.Process|process]] dependencies inferred from configured [[sprockit.Resource|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 [[..:differences#easier_to_configure|easier to configure]], but [[sprockit.Handler|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.

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-start */
===== Columns =====
^ ^Column name((Columns with names in **bold** are non-nullable; columns with __underlined__ names are participants in the table's primary key.))  ^Column type  ^Description   ^Notes   ^
|[[sprockit.Process|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]]  |
|[[sprockit.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]]  |

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-start */
===== Relationships =====
Relationships with integrity enforced by a foreign key constraint have identifiers
prefixed with //FK//; others are prefixed //RL//.

[[sprockit:v1.3:Sprockit tables:Sprockit tables|Click here to view the data model diagram.]]
==== References to other tables ====

^  ^Attributes \\ (in this table)  ^Referenced table  ^Referenced attributes \\  (in referenced table)   ^
|RL1  |PredecessorId  |[[sprockit.Process]]  |ProcessId  |
|RL2  |SuccessorId  |[[sprockit.Process]]  |ProcessId  |

==== References to this table from others ====

^Relationship  ^Attributes \\ (in referencing table)  ^Referenced attributes \\ (in this table)   ^
|(None).   |||


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-start */
----
Page generated from database metadata by [[https://richardswinbank.net/DbScout|DbScout]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-end */