reference.additional_Reference_wo_columns_from_properties_tgt - V

type: V ( view ), modify_date: 2021-09-27 18:16:06

RepoObject_guid: 88E48C87-AE1F-EC11-8523-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.additional_reference_wo_columns_from_properties_tgt

Columns

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

1

nvarchar(128)

NOT NULL

2

nvarchar(128)

NOT NULL

3

nvarchar(128)

NOT NULL

4

nvarchar(128)

NOT NULL

5

nvarchar(128)

NOT NULL

6

nvarchar(128)

NOT NULL

7

nvarchar(128)

NOT NULL

8

nvarchar(128)

NOT NULL

Id

int

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

tik

nvarchar(1311)

NOT NULL

binary(16)

NULL

Persistence, History Table

  • persistence source: reference.additional_Reference_wo_columns_from_properties_src - V

  • is_persistence: 1

  • is_persistence_check_duplicate_per_pk: 0

  • is_persistence_check_for_empty_source: 0

  • is_persistence_delete_changed: 0

  • is_persistence_delete_missing: 0

  • is_persistence_insert: 1

  • is_persistence_truncate: 0

  • is_persistence_update_changed: 0

  • has_history: 0

  • has_history_columns: 0

Foreign Key Diagram

entity_1_1_fk-reference.additional_reference_wo_columns_from_properties_tgt

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.additional_reference_wo_columns_from_properties_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.additional_reference_wo_columns_from_properties_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.additional_reference_wo_columns_from_properties_tgt

Column Reference Diagram

entity_1_1_colref-reference.additional_reference_wo_columns_from_properties_tgt

Indexes

PK_additional_Reference_wo_columns_from_properties_tgt

Column Details

_

referenced_AntoraComponent

1

referenced_AntoraComponent

nvarchar(128)

NOT NULL

referenced_AntoraModule

2

referenced_AntoraModule

nvarchar(128)

NOT NULL

referencing_AntoraComponent

5

referencing_AntoraComponent

nvarchar(128)

NOT NULL

referencing_AntoraModule

6

referencing_AntoraModule

nvarchar(128)

NOT NULL

Id

Id

int

NOT NULL

referenced_Column

referenced_Column

nvarchar(128)

NULL

referencing_Column

referencing_Column

nvarchar(128)

NULL

tik

tik

nvarchar(1311)

NOT NULL

Description

(concat(N'',[referenced_AntoraComponent],'||',[referenced_AntoraModule],'||',[referenced_Schema],'||',[referenced_Object],'||',[referenced_Column],'||',[referencing_AntoraComponent],'||',[referencing_AntoraModule],'||',[referencing_Schema],'||',[referencing_Object],'||',[referencing_Column],'||'))


tik_hash

tik_hash

binary(16)

NULL

Description

(CONVERT([binary](16),hashbytes('MD5',lower(concat(N'',[referenced_AntoraComponent],'||',[referenced_AntoraModule],'||',[referenced_Schema],'||',[referenced_Object],'||',[referenced_Column],'||',[referencing_AntoraComponent],'||',[referencing_AntoraModule],'||',[referencing_Schema],'||',[referencing_Object],'||',[referencing_Column],'||')))))


sql_modules_definition

reference.additional_Reference_wo_columns_from_properties_tgt - V script
create View [reference].[additional_Reference_wo_columns_from_properties_tgt]
As
Select
    referenced_AntoraComponent
  , referenced_AntoraModule
  , referenced_Schema
  , referenced_Object
  , referenced_Column
  , referencing_AntoraComponent
  , referencing_AntoraModule
  , referencing_Schema
  , referencing_Object
  , referencing_Column
  , Id
  , tik
  , tik_hash
From
    reference.additional_Reference