reference.additional_Reference - U

type: U ( user table ), modify_date: 2022-09-05 18:17:51

RepoObject_guid: 9AB0B5F7-B004-EC11-8514-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.additional_reference

Columns

Table 1. Columns of reference.additional_Reference - U
PK Column Name Data Type NULL? ID

1

Definition (PERSISTED)
(isnull(CONVERT([nvarchar](32),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],'|~|'))),(2)),''))

nvarchar(32)

NOT NULL

Id

int

NOT NULL

(1,1)

Default: DF_additional_Reference_referenced_AntoraComponent
(N'mycomponent')

nvarchar(128)

NOT NULL

Default: DF_additional_Reference_referenced_AntoraModule
(N'sqldb')

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

Default: DF_additional_Reference_referencing_AntoraComponent
(N'mycomponent')

nvarchar(128)

NOT NULL

Default: DF_additional_Reference_referencing_AntoraModule
(N'sqldb')

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

tik

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

nvarchar(1311)

NOT NULL

Definition (PERSISTED)
(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],'|~|')))))

binary(16)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.additional_reference

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.additional_reference

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.additional_reference

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.additional_reference

Column Reference Diagram

entity_1_1_colref-reference.additional_reference

Indexes

PK_additional_Reference

uq_additional_Reference

Column Details

_

tik_hash_c

1

tik_hash_c

Definition (PERSISTED)
(isnull(CONVERT([nvarchar](32),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],'|~|'))),(2)),''))

nvarchar(32)

NOT NULL

Description

(isnull(CONVERT([nvarchar](32),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],'||'))),(2)),''))


tik

tik

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

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

Definition (PERSISTED)
(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],'|~|')))))

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