configT.InheritanceType - V

type: V ( view ), modify_date: 2021-10-02 13:23:33

RepoObject_guid: 5CB33A4A-426D-EB11-84E2-A81E8446D5B0

Description

Examples

Entity Diagram

entity-configt.inheritancetype

Columns

Table 1. Columns of configT.InheritanceType - V
PK Column Name Data Type NULL? ID

1

int

NOT NULL

varchar(83)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-configt.inheritancetype

References

Object Reference Diagram - 1 1

entity_1_1_objectref-configt.inheritancetype

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-configt.inheritancetype

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-configt.inheritancetype

Column Reference Diagram

entity_1_1_colref-configt.inheritancetype

Indexes

PK_InheritanceType

Column Details

_

InheritanceType

1

InheritanceType

int

NOT NULL

InheritanceTypeDescription

InheritanceTypeDescription

varchar(83)

NOT NULL

sql_modules_definition

configT.InheritanceType - V script
/*
<<property_start>>Description
<<property_end>>
*/
CREATE View configT.InheritanceType
As
Select
    InheritanceType            = 0
  , InheritanceTypeDescription = 'No inheritance from predecessor'
Union All
Select
    InheritanceType            = 11
  , InheritanceTypeDescription = 'Inheritance from first (or all) predecessor, if current value is NULL'
Union All
Select
    InheritanceType            = 12
  , InheritanceTypeDescription = 'Inheritance from first (or all) predecessor, if current value is NULL or empty ('''')'
Union All
Select
    InheritanceType            = 13
  , InheritanceTypeDescription = 'Inheritance from first (or all) predecessor, forced, only when source is not empty'
Union All
Select
    InheritanceType            = 14
  , InheritanceTypeDescription = 'Inheritance from first (or all) predecessor, forced without exception (dangerous!)';

--UNION ALL
--SELECT
--       [InheritanceType] = 21
--     , [InheritanceTypeDescription] = 'Inheritance from all predecessors - STRING_AGG(xyz, CHAR(13)+CHAR(10)), if current value is NULL'
--UNION ALL
--SELECT
--       [InheritanceType] = 22
--     , [InheritanceTypeDescription] = 'Inheritance from all predecessors - STRING_AGG(xyz, CHAR(13)+CHAR(10)), if current value is NULL or empty ('''')'
--UNION ALL
--SELECT
--       [InheritanceType] = 23
--     , [InheritanceTypeDescription] = 'Inheritance from all predecessors - STRING_AGG(xyz, CHAR(13)+CHAR(10)), forced, only when source is not empty'
--UNION ALL
--SELECT
--       [InheritanceType] = 24
--     , [InheritanceTypeDescription] = 'Inheritance from all predecessors - STRING_AGG(xyz, CHAR(13)+CHAR(10)), forced without exception (dangerous!)'

----still unclear if and how this could or should be implemented
----additional parameters for CONCAT String required
--UNION ALL
--SELECT
--       [InheritanceType] = 31
--     , [InheritanceTypeDescription] = 'use CONCAT (for example: ''[RepoObject_name],CHAR(13),CHAR(10),EineNochZuDefinierendeFunktion(''MS_Description'')''), Inheritance from first predecessor, if current value is NULL'
--UNION ALL
--SELECT
--       [InheritanceType] = 32
--     , [InheritanceTypeDescription] = 'use CONCAT (for example: ''[RepoObject_name],CHAR(13),CHAR(10),EineNochZuDefinierendeFunktion(''MS_Description'')''), Inheritance from first predecessor, if current value is NULL or empty ('''')'
--UNION ALL
--SELECT
--       [InheritanceType] = 33
--     , [InheritanceTypeDescription] = 'use CONCAT (for example: ''[RepoObject_name],CHAR(13),CHAR(10),EineNochZuDefinierendeFunktion(''MS_Description'')''), Inheritance from first predecessor, force'