reference.RepoObject_reference_additional - V

type: V ( view ), modify_date: 2022-01-05 18:06:34

RepoObject_guid: 7BDAAA1B-681B-EC11-8520-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobject_reference_additional

Columns

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

varchar(30)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(261)

NULL

int

NULL

bit

NULL

uniqueidentifier

NULL

nvarchar(128)

NOT NULL

char(2)

NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(261)

NULL

int

NULL

bit

NULL

uniqueidentifier

NULL

nvarchar(128)

NOT NULL

char(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobject_reference_additional

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobject_reference_additional

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobject_reference_additional

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobject_reference_additional

Column Reference Diagram

entity_1_1_colref-reference.repoobject_reference_additional

Indexes

idx_RepoObject_reference_additional__1

idx_RepoObject_reference_additional__2

Column Details

_

InformationSource

InformationSource

varchar(30)

NOT NULL

referenced_entity_name

referenced_entity_name

nvarchar(128)

NOT NULL

referenced_external_AntoraComponent

referenced_external_AntoraComponent

nvarchar(128)

NULL

referenced_external_AntoraModule

referenced_external_AntoraModule

nvarchar(128)

NULL

referenced_fullname

referenced_fullname

nvarchar(261)

NULL

Description

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


referenced_id

referenced_id

int

NULL

referenced_is_external

referenced_is_external

bit

NULL

referenced_RepoObject_guid

referenced_RepoObject_guid

uniqueidentifier

NULL

referenced_schema_name

referenced_schema_name

nvarchar(128)

NOT NULL

referenced_type

referenced_type

char(2)

NULL

referencing_entity_name

referencing_entity_name

nvarchar(128)

NOT NULL

referencing_external_AntoraComponent

referencing_external_AntoraComponent

nvarchar(128)

NULL

referencing_external_AntoraModule

referencing_external_AntoraModule

nvarchar(128)

NULL

referencing_fullname

referencing_fullname

nvarchar(261)

NULL

Description

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


referencing_id

referencing_id

int

NULL

referencing_is_external

referencing_is_external

bit

NULL

referencing_RepoObject_guid

referencing_RepoObject_guid

uniqueidentifier

NULL

referencing_schema_name

referencing_schema_name

nvarchar(128)

NOT NULL

referencing_type

referencing_type

char(2)

NULL

sql_modules_definition

reference.RepoObject_reference_additional - V script
CREATE View reference.RepoObject_reference_additional
As
Select
--distinct, because the source also contains columns
    Distinct
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , referenced_entity_name  = T1.referenced_Object
  , T1.referenced_fullname
  , T1.referenced_id
  --, referenced_node_id
  , referenced_schema_name  = T1.referenced_Schema
  , T1.referenced_type
  , T1.referenced_external_AntoraComponent
  , T1.referenced_external_AntoraModule
  , referenced_is_external
  , referencing_entity_name = T1.referencing_Object
  , T1.referencing_fullname
  , T1.referencing_id
  --, referencing_node_id
  , referencing_schema_name = T1.referencing_Schema
  , T1.referencing_type
  , T1.referencing_external_AntoraComponent
  , T1.referencing_external_AntoraModule
  , referencing_is_external
  , InformationSource       = 'reference.additional_Reference'
From
    reference.additional_Reference_guid As T1
Where
    (
        T1.referenced_is_external     = 0
        Or T1.referencing_is_external = 0
    )
    And Not T1.referenced_RepoObject_guid Is Null
    And Not T1.referencing_RepoObject_guid Is Null