workflow.Workflow_ProcedureDependency_wo_redundant

Description

Examples

Entity Diagram

Columns

Table 1. Columns of workflow.Workflow_ProcedureDependency_wo_redundant - V
Column Name	Data Type	NULL?
referenced_Procedure_RepoObject_guid	`uniqueidentifier`	`NOT NULL`
referencing_Procedure_RepoObject_guid	`uniqueidentifier`	`NOT NULL`
Workflow_id	`int`	`NOT NULL`

Foreign Key Diagram

References

Referenced Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

idx_Workflow_ProcedureDependency_wo_redundant__1

IndexSemanticGroup: no_group
- [column-Workflow_id]; int
PK, Unique, Real: 0, 0, 0

idx_Workflow_ProcedureDependency_wo_redundant__2

IndexSemanticGroup: no_group
- [column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
- [column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0

idx_Workflow_ProcedureDependency_wo_redundant__3

IndexSemanticGroup: no_group
- [column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0

idx_Workflow_ProcedureDependency_wo_redundant__4

IndexSemanticGroup: no_group
- [column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0

Column Details

_

referenced_Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

workflow.Workflow_ProcedureDependency_all.referenced_Procedure_RepoObject_guid

referencing_Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

workflow.Workflow_ProcedureDependency_all.referencing_Procedure_RepoObject_guid

Workflow_id

int

NOT NULL

Referenced Columns

workflow.Workflow_ProcedureDependency_all.Workflow_id

sql_modules_definition

workflow.Workflow_ProcedureDependency_wo_redundant - V script

CREATE View workflow.Workflow_ProcedureDependency_wo_redundant
As
Select
    T1.Workflow_id
  , T1.referenced_Procedure_RepoObject_guid
  , T1.referencing_Procedure_RepoObject_guid
From
    workflow.Workflow_ProcedureDependency_all As T1
Except
(Select
     T1.Workflow_id
   , T1.referenced_Procedure_RepoObject_guid
   , T1.referencing_Procedure_RepoObject_guid
 From
     workflow.Workflow_ProcedureDependency_T_redundant As T1)