reference.RepoObject_reference_union - V

type: V ( view ), modify_date: 2022-01-22 00:37:12

RepoObject_guid: 6390291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobject_reference_union

Columns

Table 1. Columns of reference.RepoObject_reference_union - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NULL

2

uniqueidentifier

NULL

varchar(37)

NOT NULL

one

int

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(517)

NULL

int

NULL

int

NULL

nvarchar(128)

NULL

char(2)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(517)

NULL

int

NULL

int

NULL

nvarchar(128)

NULL

varchar(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobject_reference_union

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobject_reference_union

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobject_reference_union

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobject_reference_union

Column Reference Diagram

entity_1_1_colref-reference.repoobject_reference_union

Indexes

PK_RepoObject_reference_union

Column Details

_

referenced_RepoObject_guid

1

referenced_RepoObject_guid

uniqueidentifier

NULL

referencing_RepoObject_guid

2

referencing_RepoObject_guid

uniqueidentifier

NULL

InformationSource

InformationSource

varchar(37)

NOT NULL

one

one

int

NOT NULL

referenced_entity_name

referenced_entity_name

nvarchar(128)

NULL

referenced_external_AntoraComponent

referenced_external_AntoraComponent

nvarchar(128)

NULL

referenced_external_AntoraModule

referenced_external_AntoraModule

nvarchar(128)

NULL

referenced_fullname

referenced_fullname

nvarchar(517)

NULL

referenced_id

referenced_id

int

NULL

referenced_is_external

referenced_is_external

int

NULL

referenced_schema_name

referenced_schema_name

nvarchar(128)

NULL

referenced_type

referenced_type

char(2)

NULL

referencing_entity_name

referencing_entity_name

nvarchar(128)

NULL

referencing_external_AntoraComponent

referencing_external_AntoraComponent

nvarchar(128)

NULL

referencing_external_AntoraModule

referencing_external_AntoraModule

nvarchar(128)

NULL

referencing_fullname

referencing_fullname

nvarchar(517)

NULL

referencing_id

referencing_id

int

NULL

referencing_is_external

referencing_is_external

int

NULL

referencing_schema_name

referencing_schema_name

nvarchar(128)

NULL

referencing_type

referencing_type

varchar(2)

NULL

sql_modules_definition

reference.RepoObject_reference_union - V script
CREATE View reference.RepoObject_reference_union
As
Select
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , T1.referenced_entity_name
  , T1.referenced_fullname
  , T1.referenced_id
  , T1.referenced_schema_name
  , T1.referenced_type
  , referenced_external_AntoraComponent  = Null
  , referenced_external_AntoraModule     = Null
  , referenced_is_external               = 0
  , T1.referencing_entity_name
  , T1.referencing_fullname
  , T1.referencing_id
  , T1.referencing_schema_name
  , T1.referencing_type
  , referencing_external_AntoraComponent = Null
  , referencing_external_AntoraModule    = Null
  , referencing_is_external              = 0
  , T1.InformationSource
  , one                                  = 1
From
    reference.RepoObject_reference_SqlExpressionDependencies As T1
Union All
Select
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , T1.referenced_entity_name
  , T1.referenced_fullname
  , T1.referenced_id
  , T1.referenced_schema_name
  , T1.referenced_type
  , referenced_external_AntoraComponent  = Null
  , referenced_external_AntoraModule     = Null
  , referenced_is_external               = 0
  , T1.referencing_entity_name
  , T1.referencing_fullname
  , T1.referencing_id
  , T1.referencing_schema_name
  , T1.referencing_type
  , referencing_external_AntoraComponent = Null
  , referencing_external_AntoraModule    = Null
  , referencing_is_external              = 0
  , T1.InformationSource
  , one                                  = 1
From
    reference.RepoObject_reference_persistence As T1
Union All
Select
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , T1.referenced_entity_name
  , T1.referenced_fullname
  , T1.referenced_id
  , T1.referenced_schema_name
  , T1.referenced_type
  , referenced_external_AntoraComponent  = Null
  , referenced_external_AntoraModule     = Null
  , referenced_is_external               = 0
  , T1.referencing_entity_name
  , T1.referencing_fullname
  , T1.referencing_id
  , T1.referencing_schema_name
  , T1.referencing_type
  , referencing_external_AntoraComponent = Null
  , referencing_external_AntoraModule    = Null
  , referencing_is_external              = 0
  , T1.InformationSource
  , one                                  = 1
From
    reference.RepoObject_reference_virtual As T1
Union All
Select
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , T1.referenced_entity_name
  , T1.referenced_fullname
  , T1.referenced_id
  , T1.referenced_schema_name
  , T1.referenced_type
  , referenced_external_AntoraComponent  = Null
  , referenced_external_AntoraModule     = Null
  , referenced_is_external               = 0
  , T1.referencing_entity_name
  , T1.referencing_fullname
  , T1.referencing_id
  , T1.referencing_schema_name
  , T1.referencing_type
  , referencing_external_AntoraComponent = Null
  , referencing_external_AntoraModule    = Null
  , referencing_is_external              = 0
  , T1.InformationSource
  , one                                  = 1
From
    reference.RepoObject_reference_persistence_target_as_source As T1
Where
    --the naming of the objects matches: `aaa.bbb_ccc_tgt <- aaa.bbb`
    T1.has_match_left_and_suffix_tgt = 1
Union All
Select
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , T1.referenced_entity_name
  , T1.referenced_fullname
  , T1.referenced_id
  , T1.referenced_schema_name
  , T1.referenced_type
  , referenced_external_AntoraComponent  = Null
  , referenced_external_AntoraModule     = Null
  , referenced_is_external               = 0
  , T1.referencing_entity_name
  , T1.referencing_fullname
  , T1.referencing_id
  , T1.referencing_schema_name
  , T1.referencing_type
  , referencing_external_AntoraComponent = Null
  , referencing_external_AntoraModule    = Null
  , referencing_is_external              = 0
  , T1.InformationSource
  , one                                  = 1
From
    reference.RepoObject_reference_persistence_target_as_source_explicit As T1
Union All
Select
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , T1.referenced_entity_name
  , T1.referenced_fullname
  , T1.referenced_id
  , T1.referenced_schema_name
  , T1.referenced_type
  , T1.referenced_external_AntoraComponent
  , T1.referenced_external_AntoraModule
  , T1.referenced_is_external
  , T1.referencing_entity_name
  , T1.referencing_fullname
  , T1.referencing_id
  , T1.referencing_schema_name
  , T1.referencing_type
  , T1.referencing_external_AntoraComponent
  , T1.referencing_external_AntoraModule
  , T1.referencing_is_external
  , T1.InformationSource
  , one = 1
From
    reference.RepoObject_reference_additional As T1