reference.additional_Reference_from_properties_tgt - V

type: V ( view ), modify_date: 2021-09-27 17:12:28

RepoObject_guid: B01F0071-A51F-EC11-8523-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.additional_reference_from_properties_tgt

Columns

Table 1. Columns of reference.additional_Reference_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)

NULL

6

nvarchar(128)

NOT NULL

7

nvarchar(128)

NOT NULL

8

nvarchar(128)

NOT NULL

9

nvarchar(128)

NOT NULL

10

nvarchar(128)

NULL

Id

int

NOT NULL

tik

nvarchar(1311)

NOT NULL

binary(16)

NULL

Persistence, History Table

  • persistence source: reference.additional_Reference_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_from_properties_tgt

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.additional_reference_from_properties_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.additional_reference_from_properties_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.additional_reference_from_properties_tgt

Column Reference Diagram

entity_1_1_colref-reference.additional_reference_from_properties_tgt

Indexes

PK_additional_Reference_from_properties_tgt

Column Details

_

referenced_AntoraComponent

1

referenced_AntoraComponent

nvarchar(128)

NOT NULL

referenced_AntoraModule

2

referenced_AntoraModule

nvarchar(128)

NOT NULL

referenced_Schema

3

referenced_Schema

nvarchar(128)

NOT NULL

referenced_Object

4

referenced_Object

nvarchar(128)

NOT NULL

referenced_Column

5

referenced_Column

nvarchar(128)

NULL

referencing_AntoraComponent

6

referencing_AntoraComponent

nvarchar(128)

NOT NULL

referencing_AntoraModule

7

referencing_AntoraModule

nvarchar(128)

NOT NULL

referencing_Schema

8

referencing_Schema

nvarchar(128)

NOT NULL

referencing_Object

9

referencing_Object

nvarchar(128)

NOT NULL

referencing_Column

10

referencing_Column

nvarchar(128)

NULL

Id

Id

int

NOT 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_from_properties_tgt - V script
Create View reference.additional_Reference_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