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

entity-reference.repoobjectcolumn_reference_t

Columns

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

1

uniqueidentifier

NOT NULL

2

uniqueidentifier

NOT NULL

tinyint

NULL

tinyint

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

Default: DF_RepoObjectColumn_reference_T_referenced_is_external
((0))

bit

NOT NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

char(2)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

Default: DF_RepoObjectColumn_reference_T_referencing_is_external
((0))

bit

NOT NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

char(2)

NULL

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

nvarchar(261)

NOT NULL

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

nvarchar(257)

NOT NULL

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

nvarchar(392)

NOT NULL

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

nvarchar(386)

NOT NULL

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

nvarchar(261)

NOT NULL

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

nvarchar(257)

NOT NULL

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

nvarchar(392)

NOT NULL

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

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

entity_1_1_fk-reference.repoobjectcolumn_reference_t

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobjectcolumn_reference_t

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobjectcolumn_reference_t

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobjectcolumn_reference_t

Column Reference Diagram

entity_1_1_colref-reference.repoobjectcolumn_reference_t

Indexes

PK_RepoObjectColumn_reference_T

Column Details

_

referenced_RepoObjectColumn_guid

1

referenced_RepoObjectColumn_guid

uniqueidentifier

NOT NULL

referencing_RepoObjectColumn_guid

2

referencing_RepoObjectColumn_guid

uniqueidentifier

NOT NULL

is_referenced_object

is_referenced_object

tinyint

NULL

is_referencing_object_equal_referenced_object

is_referencing_object_equal_referenced_object

tinyint

NULL

referenced_external_AntoraComponent

referenced_external_AntoraComponent

nvarchar(128)

NULL

referenced_external_AntoraModule

referenced_external_AntoraModule

nvarchar(128)

NULL

referenced_is_external

referenced_is_external

Default: DF_RepoObjectColumn_reference_T_referenced_is_external
((0))

bit

NOT NULL

referenced_type

referenced_type

char(2)

NULL

referencing_external_AntoraComponent

referencing_external_AntoraComponent

nvarchar(128)

NULL

referencing_external_AntoraModule

referencing_external_AntoraModule

nvarchar(128)

NULL

referencing_is_external

referencing_is_external

Default: DF_RepoObjectColumn_reference_T_referencing_is_external
((0))

bit

NOT NULL

referencing_type

referencing_type

char(2)

NULL

referenced_ro_fullname

referenced_ro_fullname

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

nvarchar(261)

NOT NULL

Description

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


referenced_ro_fullname2

referenced_ro_fullname2

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

nvarchar(257)

NOT NULL

Description

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


referenced_roc_fullname

referenced_roc_fullname

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

nvarchar(392)

NOT NULL

Description

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


referenced_roc_fullname2

referenced_roc_fullname2

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

nvarchar(386)

NOT NULL

Description

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


referencing_ro_fullname

referencing_ro_fullname

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

nvarchar(261)

NOT NULL

Description

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


referencing_ro_fullname2

referencing_ro_fullname2

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

nvarchar(257)

NOT NULL

Description

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


referencing_roc_fullname

referencing_roc_fullname

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

nvarchar(392)

NOT NULL

Description

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


referencing_roc_fullname2

referencing_roc_fullname2

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

nvarchar(386)

NOT NULL

Description

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