docs.Unit_3 - V

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

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

Description

Examples

Entity Diagram

entity-docs.unit_3

Columns

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

AntoraComponent

nvarchar(max)

NULL

AntoraModule

nvarchar(max)

NULL

AntoraPage

nvarchar(4000)

NULL

AntoraSectionId

nvarchar(4000)

NULL

AntoraSiteUrl

nvarchar(max)

NULL

AntoraVersion

nvarchar(max)

NULL

Object_fullname2

nvarchar(257)

NULL

Object_Type

varchar(2)

NULL

Unit_ColummName

nvarchar(128)

NULL

Unit_Description

nvarchar(max)

NULL

Unit_DisplayFolder

nvarchar(500)

NULL

Unit_Expression

nvarchar(max)

NULL

Unit_FormatString

nvarchar(500)

NULL

Unit_fullname2

nvarchar(638)

NOT NULL

Unit_guid

uniqueidentifier

NOT NULL

Unit_isHidden

bit

NULL

Unit_IsKey

bit

NULL

Unit_IsSsas

bit

NULL

Unit_IsUnique

bit

NULL

Unit_Metatype

varchar(7)

NOT NULL

Unit_Name

nvarchar(500)

NOT NULL

Unit_ObjectName

nvarchar(128)

NULL

Unit_Schema

nvarchar(128)

NOT NULL

Unit_SummarizeBy

nvarchar(500)

NULL

Unit_TypeName

nvarchar(128)

NULL

Unit_Url

nvarchar(max)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.unit_3

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.unit_3

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.unit_3

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.unit_3

Column Reference Diagram

entity_1_1_colref-docs.unit_3

Column Details

_

AntoraComponent

AntoraComponent

nvarchar(max)

NULL
Referenced Columns
Referencing Columns

AntoraModule

AntoraModule

nvarchar(max)

NULL
Referenced Columns
Referencing Columns

AntoraPage

AntoraPage

nvarchar(4000)

NULL
Referenced Columns
Referencing Columns

AntoraSectionId

AntoraSectionId

nvarchar(4000)

NULL
Referenced Columns
Referencing Columns

AntoraSiteUrl

AntoraSiteUrl

nvarchar(max)

NULL
Referenced Columns
Referencing Columns

AntoraVersion

AntoraVersion

nvarchar(max)

NULL
Referenced Columns
Referencing Columns

Object_fullname2

Object_fullname2

nvarchar(257)

NULL
Referenced Columns
Referencing Columns

Object_Type

Object_Type

varchar(2)

NULL
Referenced Columns
Referencing Columns

Unit_ColummName

Unit_ColummName

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

Unit_Description

Unit_Description

nvarchar(max)

NULL
Referenced Columns
Referencing Columns

Unit_DisplayFolder

Unit_DisplayFolder

nvarchar(500)

NULL
Referenced Columns
Referencing Columns

Unit_Expression

Unit_Expression

nvarchar(max)

NULL
Referenced Columns
Referencing Columns

Unit_FormatString

Unit_FormatString

nvarchar(500)

NULL
Referenced Columns
Referencing Columns

Unit_fullname2

Unit_fullname2

nvarchar(638)

NOT NULL
Referenced Columns
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
Referenced Columns
Referencing Columns

Unit_Schema

Unit_Schema

nvarchar(128)

NOT NULL
Referenced Columns
Referencing Columns

Unit_SummarizeBy

Unit_SummarizeBy

nvarchar(500)

NULL
Referenced Columns
Referencing Columns

Unit_TypeName

Unit_TypeName

nvarchar(128)

NULL
Referenced Columns
Referencing Columns

Unit_Url

Unit_Url

nvarchar(max)

NOT NULL
Referencing Columns

sql_modules_definition

docs.Unit_3 - V script 
CREATE View docs.Unit_3
As
Select
    Unit_guid
  , Unit_Metatype
  , Unit_Schema
  , Unit_ObjectName
  , Unit_ColummName
  , Unit_Name
  , Unit_fullname2
  , Unit_TypeName
  , Unit_isHidden
  , Unit_IsSsas
  , Unit_Description
  , Unit_DisplayFolder
  , Unit_Expression
  , Unit_FormatString
  , Unit_IsKey
  , Unit_IsUnique
  , Unit_SummarizeBy
  , Object_fullname2
  , Object_Type
  , AntoraSiteUrl
  , AntoraComponent
  , AntoraVersion
  , AntoraModule
  , AntoraPage
  , AntoraSectionId
  --file:///D:/Repos/GitHub/DataHandwerk/datahandwerk.github.io/local/dhw/0.1.0/sqldb/repo.RepoObject.html#column-InheritanceType
  , Unit_Url = Concat (
                          AntoraSiteUrl
                        , '/' + AntoraComponent
                        , '/' + AntoraVersion
                        , '/' + AntoraModule
                        , '/' + AntoraPage + '.html'
                        , '#' + AntoraSectionId
                      )
From
    docs.Unit_2