property.RepoObjectColumnProperty_ForUpdate - V

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

RepoObject_guid: 3012CE32-0E9D-EB11-84F6-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.repoobjectcolumnproperty_forupdate

Columns

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

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(128)

NULL

tinyint

NULL

nvarchar(4000)

NULL

tinyint

NULL

nvarchar(128)

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

char(2)

NOT NULL

nvarchar(520)

NOT NULL

nvarchar(386)

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-property.repoobjectcolumnproperty_forupdate

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.repoobjectcolumnproperty_forupdate

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.repoobjectcolumnproperty_forupdate

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.repoobjectcolumnproperty_forupdate

Column Reference Diagram

entity_1_1_colref-property.repoobjectcolumnproperty_forupdate

Indexes

idx_RepoObjectColumnProperty_ForUpdate__1

idx_RepoObjectColumnProperty_ForUpdate__2

idx_RepoObjectColumnProperty_ForUpdate__3

idx_RepoObjectColumnProperty_ForUpdate__4

idx_RepoObjectColumnProperty_ForUpdate__5

Column Details

_

AntoraComponent

AntoraComponent

nvarchar(max)

NULL

AntoraModule

AntoraModule

nvarchar(max)

NULL

dwh_database

dwh_database

nvarchar(128)

NULL

inheritance

inheritance

tinyint

NULL

InheritanceDefinition

InheritanceDefinition

nvarchar(4000)

NULL

InheritanceType

InheritanceType

tinyint

NULL

property_name

property_name

nvarchar(128)

NOT NULL

property_value

property_value

nvarchar(max)

NOT NULL

repo_database

repo_database

nvarchar(128)

NULL

Repo_user_type_fullname

Repo_user_type_fullname

nvarchar(128)

NULL

RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([RepoObject_schema_name],'.',[RepoObject_name]))


RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RepoObject_name

RepoObject_name

nvarchar(128)

NOT NULL

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NOT NULL

RepoObject_type

RepoObject_type

char(2)

NOT NULL

RepoObjectColumn_fullname

RepoObjectColumn_fullname

nvarchar(520)

NOT NULL

RepoObjectColumn_fullname2

RepoObjectColumn_fullname2

nvarchar(386)

NOT NULL

RepoObjectColumn_guid

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

RepoObjectColumn_name

RepoObjectColumn_name

nvarchar(128)

NOT NULL

RepoObjectColumnProperty_id

RepoObjectColumnProperty_id

int

NOT NULL

sql_modules_definition

property.RepoObjectColumnProperty_ForUpdate - V script
CREATE View property.RepoObjectColumnProperty_ForUpdate
As
Select
    rocp.RepoObjectColumnProperty_id
  , rocp.RepoObjectColumn_guid
  , rocp.property_name
  , rocp.property_value
  , rocp.inheritance
  --, rocp.[property_basetype]
  , rocg.InheritanceType
  , rocg.InheritanceDefinition
  , rocg.RepoObjectColumn_fullname
  , rocg.RepoObjectColumn_fullname2
  , rocg.RepoObjectColumn_name
  , rocg.RepoObject_fullname
  , rocg.RepoObject_fullname2
  , rocg.RepoObject_guid
  , rocg.RepoObject_schema_name
  , rocg.RepoObject_name
  , rocg.RepoObject_type
  , rocg.Repo_user_type_fullname
  , repo_database   = Db_Name ()
  , dwh_database    = config.fs_dwh_database_name ()
  , AntoraComponent = config.fs_get_parameter_value ( 'AntoraComponent', '' )
  , AntoraModule    = config.fs_get_parameter_value ( 'AntoraModule', '' )
From
    property.RepoObjectColumnProperty As rocp
    Inner Join
        repo.RepoObjectColumn_gross   As rocg
            On
            rocg.RepoObjectColumn_guid = rocp.RepoObjectColumn_guid