property.RepoObjectColumnProperty_InheritanceType_InheritanceDefinition - V

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

RepoObject_guid: 65B33A4A-426D-EB11-84E2-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.repoobjectcolumnproperty_inheritancetype_inheritancedefinition

Columns

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

1

uniqueidentifier

NOT NULL

2

nvarchar(128)

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

int

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

int

NULL

nvarchar(max)

NULL

nvarchar(128)

NOT NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

tinyint

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

int

NULL

Foreign Key Diagram

entity_1_1_fk-property.repoobjectcolumnproperty_inheritancetype_inheritancedefinition

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.repoobjectcolumnproperty_inheritancetype_inheritancedefinition

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.repoobjectcolumnproperty_inheritancetype_inheritancedefinition

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.repoobjectcolumnproperty_inheritancetype_inheritancedefinition

Column Reference Diagram

entity_1_1_colref-property.repoobjectcolumnproperty_inheritancetype_inheritancedefinition

Indexes

PK_RepoObjectColumnProperty_InheritanceType_InheritanceDefinition

idx_RepoObjectColumnProperty_InheritanceType_InheritanceDefinition__2

idx_RepoObjectColumnProperty_InheritanceType_InheritanceDefinition__3

idx_RepoObjectColumnProperty_InheritanceType_InheritanceDefinition__4

Column Details

_

RepoObjectColumn_guid

1

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

Inheritance_StringAggSeparatorSql

Inheritance_StringAggSeparatorSql

nvarchar(max)

NULL

InheritanceDefinition

InheritanceDefinition

nvarchar(max)

NULL

par_Inheritance_StringAggSeparatorSql

par_Inheritance_StringAggSeparatorSql

nvarchar(max)

NULL

Description

(coalesce([Parameter_value],[Parameter_default_value]))


par_InheritanceDefinition

par_InheritanceDefinition

nvarchar(max)

NULL

Description

(coalesce([Parameter_value],[Parameter_default_value]))


par_InheritanceType

par_InheritanceType

int

NULL

Description

(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [int]))


RepoObjectColumn_name

RepoObjectColumn_name

nvarchar(128)

NOT NULL

roc_Inheritance_StringAggSeparatorSql

roc_Inheritance_StringAggSeparatorSql

nvarchar(4000)

NULL

roc_InheritanceDefinition

roc_InheritanceDefinition

nvarchar(4000)

NULL

roc_InheritanceType

roc_InheritanceType

tinyint

NULL

sub_Inheritance_StringAggSeparatorSql

sub_Inheritance_StringAggSeparatorSql

nvarchar(max)

NULL

Description

(coalesce([Parameter_value],[Parameter_default_value]))


sub_InheritanceDefinition

sub_InheritanceDefinition

nvarchar(max)

NULL

Description

(coalesce([Parameter_value],[Parameter_default_value]))


sub_InheritanceType

sub_InheritanceType

int

NULL

Description

(TRY_CAST(left(coalesce([Parameter_value],[Parameter_default_value]),(4000)) AS [int]))


sql_modules_definition

property.RepoObjectColumnProperty_InheritanceType_InheritanceDefinition - V script
CREATE View property.RepoObjectColumnProperty_InheritanceType_InheritanceDefinition
As
Select
    --
    roc.RepoObjectColumn_guid
  , pn.property_name
  , rocp.property_value
  , Inheritance_StringAggSeparatorSql     = Coalesce (
                                                         roc.Inheritance_StringAggSeparatorSql
                                                       , par_sub_sep.Parameter_value_result
                                                       , par_sep.Parameter_value_result
                                                     )
  , InheritanceDefinition                 = Coalesce (
                                                         roc.InheritanceDefinition
                                                       , par_sub_def.Parameter_value_result
                                                       , par_def.Parameter_value_result
                                                     )
  , InheritanceType                       = Coalesce (
                                                         roc.InheritanceType
                                                       , par_sub.Parameter_value_result_int
                                                       , par.Parameter_value_result_int
                                                     )
  , roc.RepoObjectColumn_name
  , roc_InheritanceType                   = roc.InheritanceType
  , sub_InheritanceType                   = par_sub.Parameter_value_result_int
  , par_InheritanceType                   = par.Parameter_value_result_int
  , roc_InheritanceDefinition             = roc.InheritanceDefinition
  , sub_InheritanceDefinition             = par_sub_def.Parameter_value_result
  , par_InheritanceDefinition             = par_def.Parameter_value_result
  , roc_Inheritance_StringAggSeparatorSql = roc.Inheritance_StringAggSeparatorSql
  , sub_Inheritance_StringAggSeparatorSql = par_sub_sep.Parameter_value_result
  , par_Inheritance_StringAggSeparatorSql = par_sep.Parameter_value_result
From
    repo.RepoObjectColumn                               As roc
    Cross Join property.PropertyName_RepoObjectColumn_T As pn
    Left Join
        property.RepoObjectColumnProperty As rocp
            On
            rocp.RepoObjectColumn_guid    = roc.RepoObjectColumn_guid
            And rocp.property_name        = pn.property_name

    Left Join
        config.Parameter                  As par_sub
            On
            par_sub.Parameter_name        = 'InheritanceType_column'
            And par_sub.sub_Parameter     = pn.property_name

    Left Join
        config.Parameter                  As par
            On
            par.Parameter_name            = 'InheritanceType_column'
            And par.sub_Parameter         = ''

    Left Join
        config.Parameter                  As par_sub_def
            On
            par_sub_def.Parameter_name    = 'InheritanceDefinition_column'
            And par_sub_def.sub_Parameter = pn.property_name

    Left Join
        config.Parameter                  As par_def
            On
            par_def.Parameter_name        = 'InheritanceDefinition_column'
            And par_def.sub_Parameter     = ''

    Left Join
        config.Parameter                  As par_sub_sep
            On
            par_sub_sep.Parameter_name    = 'Inheritance_StringAggSeparatorSql_column'
            And par_sub_sep.sub_Parameter = pn.property_name

    Left Join
        config.Parameter                  As par_sep
            On
            par_sep.Parameter_name        = 'Inheritance_StringAggSeparatorSql_column'
            And par_sep.sub_Parameter     = ''
Where
    pn.has_inheritance = 1