reference.additional_Reference_is_external - V

type: V ( view ), modify_date: 2021-09-22 08:02:58

RepoObject_guid: C130C78C-161B-EC11-8520-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.additional_reference_is_external

Columns

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

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

int

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

int

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-reference.additional_reference_is_external

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.additional_reference_is_external

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.additional_reference_is_external

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.additional_reference_is_external

Column Reference Diagram

entity_1_1_colref-reference.additional_reference_is_external

Column Details

_

internal_AntoraComponent

internal_AntoraComponent

nvarchar(max)

NULL

internal_AntoraModule

internal_AntoraModule

nvarchar(max)

NULL

referenced_AntoraComponent

referenced_AntoraComponent

nvarchar(128)

NOT NULL

referenced_AntoraModule

referenced_AntoraModule

nvarchar(128)

NOT NULL

referenced_Column

referenced_Column

nvarchar(128)

NULL

referenced_is_external

referenced_is_external

int

NOT NULL

referenced_Object

referenced_Object

nvarchar(128)

NOT NULL

referenced_Schema

referenced_Schema

nvarchar(128)

NOT NULL

referencing_AntoraComponent

referencing_AntoraComponent

nvarchar(128)

NOT NULL

referencing_AntoraModule

referencing_AntoraModule

nvarchar(128)

NOT NULL

referencing_Column

referencing_Column

nvarchar(128)

NULL

referencing_is_external

referencing_is_external

int

NOT NULL

referencing_Object

referencing_Object

nvarchar(128)

NOT NULL

referencing_Schema

referencing_Schema

nvarchar(128)

NOT NULL

sql_modules_definition

reference.additional_Reference_is_external - V script
Create View reference.additional_Reference_is_external
As
Select
    T1.referenced_AntoraComponent
  , T1.referenced_AntoraModule
  , T1.referenced_Schema
  , T1.referenced_Object
  , T1.referenced_Column
  , referenced_is_external   = Case
                                   When T1.referenced_AntoraComponent = AntoraComponent.Parameter_value_result
                                        And T1.referenced_AntoraModule = AntoraModule.Parameter_value_result
                                       Then
                                       0
                                   Else
                                       1
                               End
  , T1.referencing_AntoraComponent
  , T1.referencing_AntoraModule
  , T1.referencing_Schema
  , T1.referencing_Object
  , T1.referencing_Column
  , referencing_is_external  = Case
                                   When T1.referencing_AntoraComponent = AntoraComponent.Parameter_value_result
                                        And T1.referencing_AntoraModule = AntoraModule.Parameter_value_result
                                       Then
                                       0
                                   Else
                                       1
                               End
  , internal_AntoraComponent = AntoraComponent.Parameter_value_result
  , internal_AntoraModule    = AntoraModule.Parameter_value_result
From
    reference.additional_Reference                                      As T1
    Cross Join config.ftv_get_parameter_value ( 'AntoraComponent', '' ) As AntoraComponent
    Cross Join config.ftv_get_parameter_value ( 'AntoraModule', '' ) As AntoraModule