dmdocs.unit - V

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

RepoObject_guid: 74E1C56A-C111-EC11-8519-A81E8446D5B0

Description

Examples

Entity Diagram

entity-dmdocs.unit

Columns

Table 1. Columns of dmdocs.unit - 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

nvarchar(max)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-dmdocs.unit

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-dmdocs.unit

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-dmdocs.unit

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-dmdocs.unit

Column Reference Diagram

entity_1_1_colref-dmdocs.unit

Column Details

_

AntoraComponent

AntoraComponent

nvarchar(max)

NULL

Referenced Columns

AntoraModule

AntoraModule

nvarchar(max)

NULL

Referenced Columns

AntoraPage

AntoraPage

nvarchar(4000)

NULL

Referenced Columns

AntoraSectionId

AntoraSectionId

nvarchar(4000)

NULL

Referenced Columns

AntoraSiteUrl

AntoraSiteUrl

nvarchar(max)

NULL

Referenced Columns

AntoraVersion

AntoraVersion

nvarchar(max)

NULL

Referenced Columns

Object_fullname2

Object_fullname2

nvarchar(257)

NULL

Referenced Columns

Object_Type

Object_Type

varchar(2)

NULL

Referenced Columns

Unit_ColummName

Unit_ColummName

nvarchar(128)

NULL

Referenced Columns

Unit_Description

Unit_Description

nvarchar(max)

NULL

Referenced Columns

Unit_DisplayFolder

Unit_DisplayFolder

nvarchar(500)

NULL

Referenced Columns

Unit_Expression

Unit_Expression

nvarchar(max)

NULL

Referenced Columns

Unit_FormatString

Unit_FormatString

nvarchar(500)

NULL

Referenced Columns

Unit_fullname2

Unit_fullname2

nvarchar(638)

NOT NULL

Referenced Columns

Unit_guid

Unit_guid

uniqueidentifier

NOT NULL

Referenced Columns

Unit_isHidden

Unit_isHidden

bit

NULL

Referenced Columns

Unit_IsKey

Unit_IsKey

bit

NULL

Referenced Columns

Unit_IsSsas

Unit_IsSsas

bit

NULL

Referenced Columns

Unit_IsUnique

Unit_IsUnique

bit

NULL

Referenced Columns

Unit_Metatype

Unit_Metatype

varchar(7)

NOT NULL

Referenced Columns

Unit_Name

Unit_Name

nvarchar(500)

NOT NULL

Referenced Columns

Unit_ObjectName

Unit_ObjectName

nvarchar(128)

NULL

Referenced Columns

Unit_Schema

Unit_Schema

nvarchar(128)

NOT NULL

Referenced Columns

Unit_SummarizeBy

Unit_SummarizeBy

nvarchar(500)

NULL

Referenced Columns

Unit_TypeName

Unit_TypeName

nvarchar(128)

NULL

Referenced Columns

Unit_Url

Unit_Url

nvarchar(max)

NOT NULL

Referenced Columns

sql_modules_definition

dmdocs.unit - V script
CREATE View dmdocs.unit
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
  , Unit_Url
From
    docs.Unit_3