workflow.ProcedureDependency_gross - V

type: V ( view ), modify_date: 2021-08-17 20:24:45

RepoObject_guid: 48514649-189D-EB11-84F6-A81E8446D5B0

Description

Examples

Entity Diagram

entity-workflow.proceduredependency_gross

Columns

Table 1. Columns of workflow.ProcedureDependency_gross - V
PK Column Name Data Type NULL? ID

nvarchar(4000)

NULL

id

int

NOT NULL

bit

NOT NULL

bit

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

nvarchar(128)

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-workflow.proceduredependency_gross

References

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.proceduredependency_gross

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.proceduredependency_gross

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.proceduredependency_gross

Column Reference Diagram

entity_1_1_colref-workflow.proceduredependency_gross

Indexes

idx_ProcedureDependency_gross__1

idx_ProcedureDependency_gross__2

idx_ProcedureDependency_gross__3

  • IndexSemanticGroup: no_group

  • PK, Unique, Real: 0, 0, 0

idx_ProcedureDependency_gross__4

idx_ProcedureDependency_gross__5

idx_ProcedureDependency_gross__6

Column Details

_

Description

Description

nvarchar(4000)

NULL

id

id

int

NOT NULL

Referenced Columns

is_active

is_active

bit

NOT NULL

is_PersistenceDependency

is_PersistenceDependency

bit

NOT NULL

referenced_Procedure_RepoObject_guid

referenced_Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

referenced_RepoObject_fullname

referenced_RepoObject_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


referenced_RepoObject_fullname2

referenced_RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([RepoObject_schema_name],'.',[RepoObject_name]))


referenced_RepoObject_schema_name

referenced_RepoObject_schema_name

nvarchar(128)

NOT NULL

referencing_Procedure_RepoObject_guid

referencing_Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

referencing_RepoObject_fullname

referencing_RepoObject_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


referencing_RepoObject_fullname2

referencing_RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([RepoObject_schema_name],'.',[RepoObject_name]))


referencing_RepoObject_schema_name

referencing_RepoObject_schema_name

nvarchar(128)

NOT NULL

sql_modules_definition

workflow.ProcedureDependency_gross - V script
CREATE View workflow.ProcedureDependency_gross
As
Select
    pd.id
  , pd.referenced_Procedure_RepoObject_guid
  , pd.referencing_Procedure_RepoObject_guid
  , pd.is_active
  , pd.is_PersistenceDependency
  , pd.Description
  , referenced_RepoObject_fullname     = ro_1.RepoObject_fullname
  , referenced_RepoObject_fullname2    = ro_1.RepoObject_fullname2
  , referenced_RepoObject_schema_name  = ro_1.RepoObject_schema_name
  , referencing_RepoObject_fullname    = ro_2.RepoObject_fullname
  , referencing_RepoObject_fullname2   = ro_2.RepoObject_fullname2
  , referencing_RepoObject_schema_name = ro_2.RepoObject_schema_name
From
    workflow.ProcedureDependency As pd
    Inner Join
        repo.RepoObject          As ro_1
            On
            pd.referenced_Procedure_RepoObject_guid  = ro_1.RepoObject_guid

    Inner Join
        repo.RepoObject          As ro_2
            On
            pd.referencing_Procedure_RepoObject_guid = ro_2.RepoObject_guid