docs.Schema_EntityList - V

type: V ( view ), modify_date: 2022-09-08 16:36:21

RepoObject_guid: 0960D8EE-E90A-EC11-8516-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.schema_entitylist

Columns

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

1

nvarchar(128)

NOT NULL

2

nvarchar(10)

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.schema_entitylist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.schema_entitylist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.schema_entitylist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.schema_entitylist

Column Reference Diagram

entity_1_1_colref-docs.schema_entitylist

Indexes

PK_Schema_EntityList

idx_Schema_EntityList__2

idx_Schema_EntityList__3

Column Details

_

RepoObject_schema_name

1

RepoObject_schema_name

nvarchar(128)

NOT NULL

cultures_name

2

cultures_name

nvarchar(10)

NOT NULL

EntityList_Puml

EntityList_Puml

nvarchar(max)

NULL

EntityList_PumlOnlyIndex

EntityList_PumlOnlyIndex

nvarchar(max)

NULL

EntityList_PumlOnlyPK

EntityList_PumlOnlyPK

nvarchar(max)

NULL

EntityList_PumlOnlyPkOrIndex

EntityList_PumlOnlyPkOrIndex

nvarchar(max)

NULL

EntityList_PumlOnlyPkOrIndexOrMeasure

EntityList_PumlOnlyPkOrIndexOrMeasure

nvarchar(max)

NULL

EntityList_PumlOnlyPkOrNotHidden

EntityList_PumlOnlyPkOrNotHidden

nvarchar(max)

NULL

sql_modules_definition

docs.Schema_EntityList - V script
CREATE View docs.Schema_EntityList
As
Select
    roe.RepoObject_schema_name
  , roe.cultures_name
  , EntityList_Puml                       = String_Agg ( Cast(roe.RepoObject_Puml As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                                                 roe.RepoObject_fullname2)
  , EntityList_PumlOnlyIndex              = String_Agg (
                                                           Cast(roe.RepoObject_PumlOnlyIndex As NVarchar(Max))
                                                         , Char ( 13 ) + Char ( 10 )
                                                       ) Within Group(Order By
                                                                          roe.RepoObject_fullname2)
  , EntityList_PumlOnlyPK                 = String_Agg ( Cast(roe.RepoObject_PumlOnlyPK As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                                                       roe.RepoObject_fullname2)
  , EntityList_PumlOnlyPkOrIndex          = String_Agg (
                                                           Cast(roe.RepoObject_PumlOnlyPkOrIndex As NVarchar(Max))
                                                         , Char ( 13 ) + Char ( 10 )
                                                       ) Within Group(Order By
                                                                          roe.RepoObject_fullname2)
  , EntityList_PumlOnlyPkOrIndexOrMeasure = String_Agg (
                                                           Cast(roe.RepoObject_PumlOnlyPkOrIndexOrMeasure As NVarchar(Max))
                                                         , Char ( 13 ) + Char ( 10 )
                                                       ) Within Group(Order By
                                                                          roe.RepoObject_fullname2)
  , EntityList_PumlOnlyPkOrNotHidden      = String_Agg (
                                                           Cast(roe.RepoObject_PumlOnlyPkOrNotHidden As NVarchar(Max))
                                                         , Char ( 13 ) + Char ( 10 )
                                                       ) Within Group(Order By
                                                                          roe.RepoObject_fullname2)
From
    docs.RepoObject_Plantuml_Entity_T As roe
Group By
    roe.RepoObject_schema_name
  , roe.cultures_name