property.RepoObjectColumnProperty_external_tgt - V

type: V ( view ), modify_date: 2022-01-05 18:06:33

RepoObject_guid: C93DCF42-D31B-EC11-8521-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.repoobjectcolumnproperty_external_tgt

Columns

Table 1. Columns of property.RepoObjectColumnProperty_external_tgt - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

2

nvarchar(128)

NOT NULL

tinyint

NULL

nvarchar(max)

NOT NULL

int

NOT NULL

Persistence, History Table

  • persistence source: property.RepoObjectColumnProperty_external_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: 1

  • is_persistence_insert: 1

  • is_persistence_truncate: 0

  • is_persistence_update_changed: 1

  • has_history: 0

  • has_history_columns: 0

Foreign Key Diagram

entity_1_1_fk-property.repoobjectcolumnproperty_external_tgt

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.repoobjectcolumnproperty_external_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.repoobjectcolumnproperty_external_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.repoobjectcolumnproperty_external_tgt

Column Reference Diagram

entity_1_1_colref-property.repoobjectcolumnproperty_external_tgt

Indexes

PK_RepoObjectColumnProperty_external_tgt

idx_RepoObjectColumnProperty_external_tgt__2

Column Details

_

RepoObjectColumn_guid

1

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

property_name

2

property_name

nvarchar(128)

NOT NULL

inheritance

inheritance

tinyint

NULL

property_value

property_value

nvarchar(max)

NOT NULL

RepoObjectColumnProperty_id

RepoObjectColumnProperty_id

int

NOT NULL

sql_modules_definition

property.RepoObjectColumnProperty_external_tgt - V script
CREATE View property.RepoObjectColumnProperty_external_tgt
As
Select
    --pk: RepoObjectColumn_guid, property_name
    rop.RepoObjectColumn_guid
  , rop.property_name
  , rop.property_value
  , rop.RepoObjectColumnProperty_id
  , rop.inheritance
From
    property.RepoObjectColumnProperty As rop
Where
    Exists
(
    Select
        1
    From
        repo.RepoObjectColumn As roc
        Left Join
            repo.RepoObject   As ro
                On
                ro.RepoObject_guid = roc.RepoObject_guid
    Where
        roc.RepoObjectColumn_guid = rop.RepoObjectColumn_guid
        And ro.is_external        = 1
)
    And Exists
(
    Select
        1
    From
        property.PropertyName_RepoObject_T As pn
    Where
        pn.property_name       = rop.property_name
        --only property_name which are used in inheritance
        And pn.has_inheritance = 1
)