reference.RepoObjectColumn_reference_T - U

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

RepoObject_guid: 16481475-58F5-EB11-850C-A81E8446D5B0

InheritanceType: 13

Description

Examples

Entity Diagram

Columns

Table 1. Columns of reference.RepoObjectColumn_reference_T - U
PK	Column Name	Data Type	NULL?
1	referenced_RepoObjectColumn_guid	`uniqueidentifier`	`NOT NULL`
2	referencing_RepoObjectColumn_guid	`uniqueidentifier`	`NOT NULL`
	is_referenced_object	`tinyint`	`NULL`
	is_referencing_object_equal_referenced_object	`tinyint`	`NULL`
	referenced_column_name	`nvarchar(128)`	`NULL`
	referenced_entity_name	`nvarchar(128)`	`NULL`
	referenced_external_AntoraComponent	`nvarchar(128)`	`NULL`
	referenced_external_AntoraModule	`nvarchar(128)`	`NULL`
	referenced_is_external Default: DF_RepoObjectColumn_reference_T_referenced_is_external `((0))` sql	`bit`	`NOT NULL`
	referenced_RepoObject_guid	`uniqueidentifier`	`NULL`
	referenced_schema_name	`nvarchar(128)`	`NULL`
	referenced_type	`char(2)`	`NULL`
	referencing_column_name	`nvarchar(128)`	`NULL`
	referencing_entity_name	`nvarchar(128)`	`NULL`
	referencing_external_AntoraComponent	`nvarchar(128)`	`NULL`
	referencing_external_AntoraModule	`nvarchar(128)`	`NULL`
	referencing_is_external Default: DF_RepoObjectColumn_reference_T_referencing_is_external `((0))` sql	`bit`	`NOT NULL`
	referencing_RepoObject_guid	`uniqueidentifier`	`NULL`
	referencing_schema_name	`nvarchar(128)`	`NULL`
	referencing_type	`char(2)`	`NULL`
	referenced_ro_fullname Definition (PERSISTED) `(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],']'))` sql	`nvarchar(261)`	`NOT NULL`
	referenced_ro_fullname2 Definition (PERSISTED) `(concat([referenced_schema_name],'.',[referenced_entity_name]))` sql	`nvarchar(257)`	`NOT NULL`
	referenced_roc_fullname Definition (PERSISTED) `(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],'].[',[referenced_column_name],']'))` sql	`nvarchar(392)`	`NOT NULL`
	referenced_roc_fullname2 Definition (PERSISTED) `(concat([referenced_schema_name],'.',[referenced_entity_name],'.',[referenced_column_name]))` sql	`nvarchar(386)`	`NOT NULL`
	referencing_ro_fullname Definition (PERSISTED) `(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],']'))` sql	`nvarchar(261)`	`NOT NULL`
	referencing_ro_fullname2 Definition (PERSISTED) `(concat([referencing_schema_name],'.',[referencing_entity_name]))` sql	`nvarchar(257)`	`NOT NULL`
	referencing_roc_fullname Definition (PERSISTED) `(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],'].[',[referencing_column_name],']'))` sql	`nvarchar(392)`	`NOT NULL`
	referencing_roc_fullname2 Definition (PERSISTED) `(concat([referencing_schema_name],'.',[referencing_entity_name],'.',[referencing_column_name]))` sql	`nvarchar(386)`	`NOT NULL`

Persistence, History Table

persistence source: reference.RepoObjectColumn_reference - 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: 1
is_persistence_update_changed: 0
has_history: 0
has_history_columns: 0

Foreign Key Diagram

References

Referenced Objects

reference.RepoObjectColumn_reference - 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_RepoObjectColumn_reference_T

IndexSemanticGroup: no_group
- [column-referenced_RepoObjectColumn_guid]; uniqueidentifier
- [column-referencing_RepoObjectColumn_guid]; uniqueidentifier
PK, Unique, Real: 1, 1, 1

Column Details

_

referenced_RepoObjectColumn_guid

referenced_RepoObjectColumn_guid

uniqueidentifier

NOT NULL

Referenced Columns

reference.RepoObjectColumn_reference.referenced_RepoObjectColumn_guid

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.Referenced_guid

referencing_RepoObjectColumn_guid

referencing_RepoObjectColumn_guid

uniqueidentifier

NOT NULL

Referenced Columns

reference.RepoObjectColumn_reference.referencing_RepoObjectColumn_guid

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.Referencing_guid

is_referenced_object

tinyint

NULL

Referenced Columns

reference.RepoObjectColumn_reference.is_referenced_object

is_referencing_object_equal_referenced_object

tinyint

NULL

Referenced Columns

reference.RepoObjectColumn_reference.is_referencing_object_equal_referenced_object

referenced_column_name

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referenced_column_name

Referencing Columns

reference.RepoObjectColumn_reference_T.referenced_roc_fullname
reference.RepoObjectColumn_reference_T.referenced_roc_fullname2
reference.RepoObjectColumn_ReferencedReferencing.ReferencedColumn_name

referenced_entity_name

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referenced_entity_name

Referencing Columns

reference.RepoObjectColumn_reference_T.referenced_ro_fullname
reference.RepoObjectColumn_reference_T.referenced_ro_fullname2
reference.RepoObjectColumn_reference_T.referenced_roc_fullname
reference.RepoObjectColumn_reference_T.referenced_roc_fullname2

referenced_external_AntoraComponent

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referenced_external_AntoraComponent

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.referenced_external_AntoraComponent

referenced_external_AntoraModule

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referenced_external_AntoraModule

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.referenced_external_AntoraModule

referenced_is_external

Default: DF_RepoObjectColumn_reference_T_referenced_is_external

((0))

sql

bit

NOT NULL

Referenced Columns

reference.RepoObjectColumn_reference.referenced_is_external

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.referenced_is_external

referenced_RepoObject_guid

uniqueidentifier

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referenced_RepoObject_guid

Referencing Columns

referenced_schema_name

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referenced_schema_name

Referencing Columns

reference.RepoObjectColumn_reference_T.referenced_roc_fullname2
reference.RepoObjectColumn_reference_T.referenced_roc_fullname
reference.RepoObjectColumn_reference_T.referenced_ro_fullname2
reference.RepoObjectColumn_reference_T.referenced_ro_fullname

referenced_type

char(2)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referenced_type

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.Referenced_type

referencing_column_name

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referencing_column_name

Referencing Columns

reference.RepoObjectColumn_reference_T.referencing_roc_fullname
reference.RepoObjectColumn_reference_T.referencing_roc_fullname2
reference.RepoObjectColumn_ReferencedReferencing.ReferencingColumn_name

referencing_entity_name

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referencing_entity_name

Referencing Columns

reference.RepoObjectColumn_reference_T.referencing_ro_fullname
reference.RepoObjectColumn_reference_T.referencing_ro_fullname2
reference.RepoObjectColumn_reference_T.referencing_roc_fullname
reference.RepoObjectColumn_reference_T.referencing_roc_fullname2

referencing_external_AntoraComponent

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referencing_external_AntoraComponent

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.referencing_external_AntoraComponent

referencing_external_AntoraModule

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referencing_external_AntoraModule

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.referencing_external_AntoraModule

referencing_is_external

Default: DF_RepoObjectColumn_reference_T_referencing_is_external

((0))

sql

bit

NOT NULL

Referenced Columns

reference.RepoObjectColumn_reference.referencing_is_external

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.referencing_is_external

referencing_RepoObject_guid

uniqueidentifier

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referencing_RepoObject_guid

Referencing Columns

referencing_schema_name

nvarchar(128)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referencing_schema_name

Referencing Columns

reference.RepoObjectColumn_reference_T.referencing_ro_fullname
reference.RepoObjectColumn_reference_T.referencing_ro_fullname2
reference.RepoObjectColumn_reference_T.referencing_roc_fullname
reference.RepoObjectColumn_reference_T.referencing_roc_fullname2

referencing_type

char(2)

NULL

Referenced Columns

reference.RepoObjectColumn_reference.referencing_type

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.Referencing_type

referenced_ro_fullname

Definition (PERSISTED)

(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],']'))

sql

nvarchar(261)

NOT NULL

Description

(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],']'))

Referenced Columns

reference.RepoObjectColumn_reference_T.referenced_schema_name
reference.RepoObjectColumn_reference_T.referenced_entity_name

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.Referenced_fullname

referenced_ro_fullname2

Definition (PERSISTED)

(concat([referenced_schema_name],'.',[referenced_entity_name]))

sql

nvarchar(257)

NOT NULL

Description

(concat([referenced_schema_name],'.',[referenced_entity_name]))

Referenced Columns

reference.RepoObjectColumn_reference_T.referenced_schema_name
reference.RepoObjectColumn_reference_T.referenced_entity_name

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.Referenced_fullname2

referenced_roc_fullname

Definition (PERSISTED)

(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],'].[',[referenced_column_name],']'))

sql

nvarchar(392)

NOT NULL

Description

(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],'].[',[referenced_column_name],']'))

Referenced Columns

reference.RepoObjectColumn_reference_T.referenced_schema_name
reference.RepoObjectColumn_reference_T.referenced_column_name
reference.RepoObjectColumn_reference_T.referenced_entity_name

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.ReferencedColumn_fullname

referenced_roc_fullname2

Definition (PERSISTED)

(concat([referenced_schema_name],'.',[referenced_entity_name],'.',[referenced_column_name]))

sql

nvarchar(386)

NOT NULL

Description

(concat([referenced_schema_name],'.',[referenced_entity_name],'.',[referenced_column_name]))

Referenced Columns

reference.RepoObjectColumn_reference_T.referenced_schema_name
reference.RepoObjectColumn_reference_T.referenced_column_name
reference.RepoObjectColumn_reference_T.referenced_entity_name

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.ReferencedColumn_fullname2

referencing_ro_fullname

Definition (PERSISTED)

(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],']'))

sql

nvarchar(261)

NOT NULL

Description

(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],']'))

Referenced Columns

reference.RepoObjectColumn_reference_T.referencing_schema_name
reference.RepoObjectColumn_reference_T.referencing_entity_name

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.Referencing_fullname

referencing_ro_fullname2

Definition (PERSISTED)

(concat([referencing_schema_name],'.',[referencing_entity_name]))

sql

nvarchar(257)

NOT NULL

Description

(concat([referencing_schema_name],'.',[referencing_entity_name]))

Referenced Columns

reference.RepoObjectColumn_reference_T.referencing_schema_name
reference.RepoObjectColumn_reference_T.referencing_entity_name

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.Referencing_fullname2

referencing_roc_fullname

Definition (PERSISTED)

(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],'].[',[referencing_column_name],']'))

sql

nvarchar(392)

NOT NULL

Description

(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],'].[',[referencing_column_name],']'))

Referenced Columns

reference.RepoObjectColumn_reference_T.referencing_entity_name
reference.RepoObjectColumn_reference_T.referencing_schema_name
reference.RepoObjectColumn_reference_T.referencing_column_name

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.ReferencingColumn_fullname

referencing_roc_fullname2

Definition (PERSISTED)

(concat([referencing_schema_name],'.',[referencing_entity_name],'.',[referencing_column_name]))

sql

nvarchar(386)

NOT NULL

Description

(concat([referencing_schema_name],'.',[referencing_entity_name],'.',[referencing_column_name]))

Referenced Columns

reference.RepoObjectColumn_reference_T.referencing_entity_name
reference.RepoObjectColumn_reference_T.referencing_schema_name
reference.RepoObjectColumn_reference_T.referencing_column_name

Referencing Columns

reference.RepoObjectColumn_ReferencedReferencing.ReferencingColumn_fullname2