docs.Unit_2 - V

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

RepoObject_guid: E4F27B65-9D0F-EC11-8518-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.unit_2

Columns

Table 1. Columns of docs.Unit_2 - V
PK Column Name Data Type NULL? ID

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(257)

NULL

varchar(2)

NULL

nvarchar(128)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(638)

NOT NULL

uniqueidentifier

NOT NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

varchar(7)

NOT NULL

nvarchar(500)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NOT NULL

nvarchar(500)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.unit_2

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.unit_2

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.unit_2

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.unit_2

Column Reference Diagram

entity_1_1_colref-docs.unit_2

Column Details

_

AntoraComponent

AntoraComponent

nvarchar(max)

NULL

Referencing Columns

AntoraModule

AntoraModule

nvarchar(max)

NULL

Referencing Columns

AntoraPage

AntoraPage

nvarchar(4000)

NULL

Referencing Columns

AntoraSectionId

AntoraSectionId

nvarchar(4000)

NULL

Referencing Columns

AntoraSiteUrl

AntoraSiteUrl

nvarchar(max)

NULL

Referencing Columns

AntoraVersion

AntoraVersion

nvarchar(max)

NULL

Referencing Columns

Object_fullname2

Object_fullname2

nvarchar(257)

NULL

Referencing Columns

Object_Type

Object_Type

varchar(2)

NULL

Referenced Columns
Referencing Columns

Unit_ColummName

Unit_ColummName

nvarchar(128)

NULL

Referencing Columns

Unit_Description

Unit_Description

nvarchar(max)

NULL

Referencing Columns

Unit_DisplayFolder

Unit_DisplayFolder

nvarchar(500)

NULL

Referencing Columns

Unit_Expression

Unit_Expression

nvarchar(max)

NULL

Referencing Columns

Unit_FormatString

Unit_FormatString

nvarchar(500)

NULL

Referencing Columns

Unit_fullname2

Unit_fullname2

nvarchar(638)

NOT NULL

Referencing Columns

Unit_guid

Unit_guid

uniqueidentifier

NOT NULL

Referenced Columns
Referencing Columns

Unit_isHidden

Unit_isHidden

bit

NULL

Referenced Columns
Referencing Columns

Unit_IsKey

Unit_IsKey

bit

NULL

Referenced Columns
Referencing Columns

Unit_IsSsas

Unit_IsSsas

bit

NULL

Referenced Columns
Referencing Columns

Unit_IsUnique

Unit_IsUnique

bit

NULL

Referenced Columns
Referencing Columns

Unit_Metatype

Unit_Metatype

varchar(7)

NOT NULL

Referenced Columns
Referencing Columns

Unit_Name

Unit_Name

nvarchar(500)

NOT NULL

Referenced Columns
Referencing Columns

Unit_ObjectName

Unit_ObjectName

nvarchar(128)

NULL

Referencing Columns

Unit_Schema

Unit_Schema

nvarchar(128)

NOT NULL

Referenced Columns
Referencing Columns

Unit_SummarizeBy

Unit_SummarizeBy

nvarchar(500)

NULL

Referencing Columns

Unit_TypeName

Unit_TypeName

nvarchar(128)

NULL

Referenced Columns
Referencing Columns

sql_modules_definition

docs.Unit_2 - V script
CREATE View docs.Unit_2
As
Select
    T1.Unit_guid
  , T1.Unit_Metatype
  , T1.Unit_Schema
  , T1.Unit_ObjectName
  , T1.Unit_ColummName
  , T1.Unit_Name
  , T1.Unit_fullname2
  , T1.Unit_TypeName
  , T1.Unit_isHidden
  , T1.Unit_IsSsas
  , T1.Unit_Description
  , T1.Unit_DisplayFolder
  , T1.Unit_Expression
  , T1.Unit_FormatString
  , T1.Unit_IsKey
  , T1.Unit_IsUnique
  , T1.Unit_SummarizeBy
  , T1.Object_fullname2
  , T1.Object_Type
  , AntoraSiteUrl   = AntoraSiteUrl.Parameter_value_result
  , AntoraComponent = AntoraComponent.Parameter_value_result
  , AntoraVersion   = AntoraVersion.Parameter_value_result
  , AntoraModule    = AntoraModule.Parameter_value_result
  , AntoraPage      = Case
                          When T1.Unit_Metatype = 'schema'
                              Then
                              'nav-schema-' + docs.fs_cleanStringForAnchorId ( T1.Unit_Schema )
                          Else
                              --( 'object', 'column', 'measure' )
                              docs.fs_cleanStringForAnchorId ( T1.Object_fullname2 )
                      End
  , AntoraSectionId = Case
                          When T1.Unit_Metatype In
                          ( 'column', 'measure' )
                              Then
                              T1.Unit_Metatype + '-' + docs.fs_cleanStringForAnchorId ( T1.Unit_Name )
                      End
From
    docs.Unit_1_union                                                 As T1
    Cross Join config.ftv_get_parameter_value ( 'AntoraSiteUrl', '' ) As AntoraSiteUrl
    Cross Join config.ftv_get_parameter_value ( 'AntoraVersion', '' ) As AntoraVersion
    Cross Join config.ftv_get_parameter_value ( 'AntoraComponent', '' ) As AntoraComponent
    Cross Join config.ftv_get_parameter_value ( 'AntoraModule', '' ) As AntoraModule