reference.RepoObject_reference_T - U

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

RepoObject_guid: 0D481475-58F5-EB11-850C-A81E8446D5B0

InheritanceType: 13

Description

Examples

Entity Diagram

entity-reference.repoobject_reference_t

Columns

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

1

referenced_RepoObject_guid

uniqueidentifier

NOT NULL

2

referencing_RepoObject_guid

uniqueidentifier

NOT NULL

is_ReversePersistenceViaView

Default: DF_RepoObject_reference_T_is_ReversePersistenceViaView
((0))

bit

NOT NULL

referenced_entity_name

nvarchar(128)

NULL

referenced_external_AntoraComponent

nvarchar(128)

NULL

referenced_external_AntoraModule

nvarchar(128)

NULL

referenced_is_external

Default: DF_RepoObject_reference_T_referenced_is_external
((0))

bit

NOT NULL

referenced_is_PersistenceSource

Default: DF_RepoObject_reference_T_is_referenced_persistence
((0))

bit

NOT NULL

referenced_is_PersistenceTarget

Default: DF_RepoObject_reference_T_referenced_is_PersistenceSource1_1
((0))

bit

NOT NULL

referenced_schema_name

nvarchar(128)

NULL

referenced_type

char(2)

NULL

referencing_entity_name

nvarchar(128)

NULL

referencing_external_AntoraComponent

nvarchar(128)

NULL

referencing_external_AntoraModule

nvarchar(128)

NULL

referencing_is_external

Default: DF_RepoObject_reference_T_referencing_is_external
((0))

bit

NOT NULL

referencing_is_PersistenceTarget

Default: DF_RepoObject_reference_T_referenced_is_PersistenceSource1
((0))

bit

NOT NULL

referencing_is_PersistenceUspSourceRef

Default: DF_RepoObject_reference_T_referencing_is_PersistenceTarget1
((0))

bit

NOT NULL

referencing_is_PersistenceUspTargetRef

Default: DF_RepoObject_reference_T_referencing_is_PersistenceUspSourceRef1
((0))

bit

NULL

referencing_schema_name

nvarchar(128)

NULL

referencing_type

varchar(2)

NULL

referenced_AntoraComponent

Definition
(coalesce([referenced_external_AntoraComponent],[config].[fs_get_parameter_value]('AntoraComponent','')))

nvarchar(max)

NULL

referenced_AntoraModule

Definition
(coalesce([referenced_external_AntoraModule],[config].[fs_get_parameter_value]('AntoraModule','')))

nvarchar(max)

NULL

referenced_fullname

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

nvarchar(261)

NOT NULL

referenced_fullname2

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

nvarchar(257)

NOT NULL

referenced_puml_entity

Definition
(case when [referenced_is_external]=(1) then (([referenced_external_AntoraComponent]+'.')+[referenced_external_AntoraModule])+'.' else '' end+[docs].[fs_cleanStringForPuml](concat([referenced_schema_name],'.',[referenced_entity_name])))

nvarchar(4000)

NULL

referencing_AntoraComponent

Definition
(coalesce([referencing_external_AntoraComponent],[config].[fs_get_parameter_value]('AntoraComponent','')))

nvarchar(max)

NULL

referencing_AntoraModule

Definition
(coalesce([referencing_external_AntoraModule],[config].[fs_get_parameter_value]('AntoraModule','')))

nvarchar(max)

NULL

referencing_fullname

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

nvarchar(261)

NOT NULL

referencing_fullname2

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

nvarchar(257)

NOT NULL

referencing_puml_entity

Definition
(case when [referencing_is_external]=(1) then (([referencing_external_AntoraComponent]+'.')+[referencing_external_AntoraModule])+'.' else '' end+[docs].[fs_cleanStringForPuml](concat([referencing_schema_name],'.',[referencing_entity_name])))

nvarchar(4000)

NULL

Persistence, History Table

  • persistence source: reference.RepoObject_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.repoobject_reference_t

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobject_reference_t

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobject_reference_t

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobject_reference_t

Column Reference Diagram

entity_1_1_colref-reference.repoobject_reference_t

Indexes

PK_RepoObject_reference_T

Column Details

_

referenced_RepoObject_guid

1

referenced_RepoObject_guid

uniqueidentifier

NOT NULL
Referenced Columns
Referencing Columns

referencing_RepoObject_guid

2

referencing_RepoObject_guid

uniqueidentifier

NOT NULL
Referenced Columns
Referencing Columns

is_ReversePersistenceViaView

is_ReversePersistenceViaView

Default: DF_RepoObject_reference_T_is_ReversePersistenceViaView
((0))

bit

NOT NULL

referenced_entity_name

referenced_entity_name

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

referenced_external_AntoraComponent

referenced_external_AntoraComponent

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

referenced_external_AntoraModule

referenced_external_AntoraModule

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

referenced_is_external

referenced_is_external

Default: DF_RepoObject_reference_T_referenced_is_external
((0))

bit

NOT NULL
Referenced Columns
Referencing Columns

referenced_is_PersistenceSource

referenced_is_PersistenceSource

Default: DF_RepoObject_reference_T_is_referenced_persistence
((0))

bit

NOT NULL

referenced_is_PersistenceTarget

referenced_is_PersistenceTarget

Default: DF_RepoObject_reference_T_referenced_is_PersistenceSource1_1
((0))

bit

NOT NULL

referenced_schema_name

referenced_schema_name

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

referenced_type

referenced_type

char(2)

NULL
Referenced Columns
Referencing Columns

referencing_entity_name

referencing_entity_name

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

referencing_external_AntoraComponent

referencing_external_AntoraComponent

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

referencing_external_AntoraModule

referencing_external_AntoraModule

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

referencing_is_external

referencing_is_external

Default: DF_RepoObject_reference_T_referencing_is_external
((0))

bit

NOT NULL
Referenced Columns
Referencing Columns

referencing_is_PersistenceTarget

referencing_is_PersistenceTarget

Default: DF_RepoObject_reference_T_referenced_is_PersistenceSource1
((0))

bit

NOT NULL

referencing_is_PersistenceUspSourceRef

referencing_is_PersistenceUspSourceRef

Default: DF_RepoObject_reference_T_referencing_is_PersistenceTarget1
((0))

bit

NOT NULL

referencing_is_PersistenceUspTargetRef

referencing_is_PersistenceUspTargetRef

Default: DF_RepoObject_reference_T_referencing_is_PersistenceUspSourceRef1
((0))

bit

NULL

referencing_schema_name

referencing_schema_name

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

referencing_type

referencing_type

varchar(2)

NULL
Referenced Columns
Referencing Columns

referenced_AntoraComponent

referenced_AntoraComponent

Definition
(coalesce([referenced_external_AntoraComponent],[config].[fs_get_parameter_value]('AntoraComponent','')))

nvarchar(max)

NULL
Description

(coalesce([referenced_external_AntoraComponent],[config].[fs_get_parameter_value]('AntoraComponent','')))


Referenced Columns

referenced_AntoraModule

referenced_AntoraModule

Definition
(coalesce([referenced_external_AntoraModule],[config].[fs_get_parameter_value]('AntoraModule','')))

nvarchar(max)

NULL
Description

(coalesce([referenced_external_AntoraModule],[config].[fs_get_parameter_value]('AntoraModule','')))


Referenced Columns

referenced_fullname

referenced_fullname

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

nvarchar(261)

NOT NULL
Description

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


Referenced Columns
Referencing Columns

referenced_fullname2

referenced_fullname2

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

nvarchar(257)

NOT NULL
Description

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


Referenced Columns
Referencing Columns

referenced_puml_entity

referenced_puml_entity

Definition
(case when [referenced_is_external]=(1) then (([referenced_external_AntoraComponent]+'.')+[referenced_external_AntoraModule])+'.' else '' end+[docs].[fs_cleanStringForPuml](concat([referenced_schema_name],'.',[referenced_entity_name])))

nvarchar(4000)

NULL
Description

(case when [referenced_is_external]=(1) then '.')[referenced_external_AntoraModule])'.' else '' end[docs].[fs_cleanStringForPuml](concat([referenced_schema_name],'.',[referenced_entity_name])


Referenced Columns

referencing_AntoraComponent

referencing_AntoraComponent

Definition
(coalesce([referencing_external_AntoraComponent],[config].[fs_get_parameter_value]('AntoraComponent','')))

nvarchar(max)

NULL
Description

(coalesce([referencing_external_AntoraComponent],[config].[fs_get_parameter_value]('AntoraComponent','')))


Referenced Columns

referencing_AntoraModule

referencing_AntoraModule

Definition
(coalesce([referencing_external_AntoraModule],[config].[fs_get_parameter_value]('AntoraModule','')))

nvarchar(max)

NULL
Description

(coalesce([referencing_external_AntoraModule],[config].[fs_get_parameter_value]('AntoraModule','')))


Referenced Columns

referencing_fullname

referencing_fullname

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

nvarchar(261)

NOT NULL
Description

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


Referenced Columns
Referencing Columns

referencing_fullname2

referencing_fullname2

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

nvarchar(257)

NOT NULL
Description

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


Referenced Columns
Referencing Columns

referencing_puml_entity

referencing_puml_entity

Definition
(case when [referencing_is_external]=(1) then (([referencing_external_AntoraComponent]+'.')+[referencing_external_AntoraModule])+'.' else '' end+[docs].[fs_cleanStringForPuml](concat([referencing_schema_name],'.',[referencing_entity_name])))

nvarchar(4000)

NULL
Description

(case when [referencing_is_external]=(1) then '.')[referencing_external_AntoraModule])'.' else '' end[docs].[fs_cleanStringForPuml](concat([referencing_schema_name],'.',[referencing_entity_name])


Referenced Columns