property.RepoObjectProperty_external_tgt - V

type: V ( view ), modify_date: 2021-09-22 21:12:49

RepoObject_guid: 47948D1F-D01B-EC11-8521-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.repoobjectproperty_external_tgt

Columns

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

1

uniqueidentifier

NOT NULL

2

nvarchar(128)

NOT NULL

tinyint

NULL

nvarchar(max)

NULL

int

NOT NULL

Persistence, History Table

  • persistence source: property.RepoObjectProperty_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.repoobjectproperty_external_tgt

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.repoobjectproperty_external_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.repoobjectproperty_external_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.repoobjectproperty_external_tgt

Column Reference Diagram

entity_1_1_colref-property.repoobjectproperty_external_tgt

Indexes

PK_RepoObjectProperty_external_tgt

idx_RepoObjectProperty_external_tgt__2

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

property_name

2

property_name

nvarchar(128)

NOT NULL

inheritance

inheritance

tinyint

NULL

property_value

property_value

nvarchar(max)

NULL

RepoObjectProperty_id

RepoObjectProperty_id

int

NOT NULL

sql_modules_definition

property.RepoObjectProperty_external_tgt - V script
CREATE View property.RepoObjectProperty_external_tgt
As
Select
    --pk: RepoObject_guid, property_name
    rop.RepoObject_guid
  , rop.property_name
  , rop.property_value
  , rop.RepoObjectProperty_id
  , rop.inheritance
From
    property.RepoObjectProperty As rop
Where
    Exists
(
    Select
        1
    From
        repo.RepoObject As ro
    Where
        ro.RepoObject_guid = rop.RepoObject_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
)