reference.additional_Reference_from_ssas_tgt

Description

Examples

Entity Diagram

Columns

Table 1. Columns of reference.additional_Reference_from_ssas_tgt - V
PK	Column Name	Data Type	NULL?
1	referenced_AntoraComponent	`nvarchar(128)`	`NOT NULL`
2	referenced_AntoraModule	`nvarchar(128)`	`NOT NULL`
3	referenced_Schema	`nvarchar(128)`	`NOT NULL`
4	referenced_Object	`nvarchar(128)`	`NOT NULL`
5	referenced_Column	`nvarchar(128)`	`NULL`
6	referencing_AntoraComponent	`nvarchar(128)`	`NOT NULL`
7	referencing_AntoraModule	`nvarchar(128)`	`NOT NULL`
8	referencing_Schema	`nvarchar(128)`	`NOT NULL`
9	referencing_Object	`nvarchar(128)`	`NOT NULL`
10	referencing_Column	`nvarchar(128)`	`NULL`
	Id	`int`	`NOT NULL`
	tik	`nvarchar(1311)`	`NOT NULL`
	tik_hash	`binary(16)`	`NULL`

Persistence, History Table

persistence source: reference.additional_Reference_from_ssas_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

References

Referenced Objects

reference.additional_Reference_from_ssas_src - V

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_additional_Reference_from_ssas_tgt

IndexSemanticGroup: no_group
- [column-referenced_AntoraComponent]; nvarchar(128)
- [column-referenced_AntoraModule]; nvarchar(128)
- [column-referenced_Schema]; nvarchar(128)
- [column-referenced_Object]; nvarchar(128)
- [column-referenced_Column]; nvarchar(128)
- [column-referencing_AntoraComponent]; nvarchar(128)
- [column-referencing_AntoraModule]; nvarchar(128)
- [column-referencing_Schema]; nvarchar(128)
- [column-referencing_Object]; nvarchar(128)
- [column-referencing_Column]; nvarchar(128)
PK, Unique, Real: 1, 1, 0

idx_additional_Reference_from_ssas_tgt__2

IndexSemanticGroup: no_group
- [column-referencing_Column]; nvarchar(128)
PK, Unique, Real: 0, 0, 0

idx_additional_Reference_from_ssas_tgt__3

IndexSemanticGroup: no_group
- [column-referencing_Schema]; nvarchar(128)
- [column-referencing_Object]; nvarchar(128)
PK, Unique, Real: 0, 0, 0

idx_additional_Reference_from_ssas_tgt__4

IndexSemanticGroup: no_group
- [column-referencing_Schema]; nvarchar(128)
PK, Unique, Real: 0, 0, 0

Column Details

_

referenced_AntoraComponent

1

referenced_AntoraComponent

nvarchar(128)

NOT NULL

Referenced Columns

referenced_AntoraModule

2

referenced_AntoraModule

nvarchar(128)

NOT NULL

Referenced Columns

referenced_Schema

3

referenced_Schema

nvarchar(128)

NOT NULL

Referenced Columns

referenced_Object

4

referenced_Object

nvarchar(128)

NOT NULL

Referenced Columns

referenced_Column

5

referenced_Column

nvarchar(128)

NULL

Referenced Columns

referencing_AntoraComponent

6

referencing_AntoraComponent

nvarchar(128)

NOT NULL

Referenced Columns

referencing_AntoraModule

7

referencing_AntoraModule

nvarchar(128)

NOT NULL

Referenced Columns

referencing_Schema

8

referencing_Schema

nvarchar(128)

NOT NULL

Referenced Columns

referencing_Object

9

referencing_Object

nvarchar(128)

NOT NULL

Referenced Columns

referencing_Column

10

referencing_Column

nvarchar(128)

NULL

Referenced Columns

Id

int

NOT NULL

Referenced Columns

reference.additional_Reference.Id

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],'|}|'))

Referenced Columns

reference.additional_Reference.tik

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],'|}|')))))

Referenced Columns

reference.additional_Reference.tik_hash

sql_modules_definition

reference.additional_Reference_from_ssas_tgt - V script

Create View reference.additional_Reference_from_ssas_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

sql