reference.RepoObject_reference_T_bidirectional - V

type: V ( view ), modify_date: 2022-01-05 17:04:09

RepoObject_guid: 7CE72F09-C5FD-EB11-850F-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobject_reference_t_bidirectional

Columns

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

nvarchar(128)

NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

bit

NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NULL

uniqueidentifier

NULL

char(2)

NULL

nvarchar(128)

NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

bit

NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NULL

uniqueidentifier

NULL

varchar(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobject_reference_t_bidirectional

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobject_reference_t_bidirectional

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobject_reference_t_bidirectional

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobject_reference_t_bidirectional

Column Reference Diagram

entity_1_1_colref-reference.repoobject_reference_t_bidirectional

Indexes

idx_RepoObject_reference_T_bidirectional__1

Column Details

_

referenced_entity_name

referenced_entity_name

nvarchar(128)

NULL

referenced_fullname

referenced_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],']'))


referenced_fullname2

referenced_fullname2

nvarchar(257)

NOT NULL

Description

(concat([referenced_schema_name],'.',[referenced_entity_name]))


referenced_is_persistence

referenced_is_persistence

bit

NULL

referenced_RepoObject_guid

referenced_RepoObject_guid

uniqueidentifier

NOT NULL

referenced_schema_name

referenced_schema_name

nvarchar(128)

NULL

referenced_source_RepoObject_guid

referenced_source_RepoObject_guid

uniqueidentifier

NULL

referenced_type

referenced_type

char(2)

NULL

referencing_entity_name

referencing_entity_name

nvarchar(128)

NULL

referencing_fullname

referencing_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],']'))


referencing_fullname2

referencing_fullname2

nvarchar(257)

NOT NULL

Description

(concat([referencing_schema_name],'.',[referencing_entity_name]))


referencing_is_persistence

referencing_is_persistence

bit

NULL

referencing_RepoObject_guid

referencing_RepoObject_guid

uniqueidentifier

NOT NULL

referencing_schema_name

referencing_schema_name

nvarchar(128)

NULL

referencing_source_RepoObject_guid

referencing_source_RepoObject_guid

uniqueidentifier

NULL

referencing_type

referencing_type

varchar(2)

NULL

sql_modules_definition

reference.RepoObject_reference_T_bidirectional - V script
CREATE View reference.RepoObject_reference_T_bidirectional
As
Select
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , T1.referenced_entity_name
  , T1.referenced_schema_name
  , T1.referenced_type
  , T1.referencing_entity_name
  , T1.referencing_schema_name
  , T1.referencing_type
  , T1.referenced_fullname
  , T1.referenced_fullname2
  , T1.referencing_fullname
  , T1.referencing_fullname2
  , referenced_is_persistence          = rop1.is_persistence
  , referenced_source_RepoObject_guid  = rop1.source_RepoObject_guid
  , referencing_is_persistence         = rop2.is_persistence
  , referencing_source_RepoObject_guid = rop2.source_RepoObject_guid
From
    reference.RepoObject_reference_T     As T1
    Inner Join
        reference.RepoObject_reference_T As T2
            On
            T1.referenced_RepoObject_guid      = T2.referencing_RepoObject_guid
            And T1.referencing_RepoObject_guid = T2.referenced_RepoObject_guid

    Left Join
        repo.RepoObject_persistence      As rop1
            On
            rop1.target_RepoObject_guid        = T1.referenced_RepoObject_guid

    Left Join
        repo.RepoObject_persistence      As rop2
            On
            rop2.target_RepoObject_guid        = T1.referencing_RepoObject_guid