docs.RepoObject_Plantuml - V

type: V ( view ), modify_date: 2021-12-16 11:41:19

RepoObject_guid: F20B29C2-E595-EB11-84F4-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.repoobject_plantuml

Columns

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

1

uniqueidentifier

NOT NULL

2

nvarchar(10)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(257)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.repoobject_plantuml

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.repoobject_plantuml

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.repoobject_plantuml

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.repoobject_plantuml

Column Reference Diagram

entity_1_1_colref-docs.repoobject_plantuml

Indexes

PK_RepoObject_Plantuml

idx_RepoObject_Plantuml__1

idx_RepoObject_Plantuml__3

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

ColRefList

ColRefList

nvarchar(max)

NULL

ObjectRefList

ObjectRefList

nvarchar(max)

NULL

ObjectRefList_0_30

ObjectRefList_0_30

nvarchar(max)

NULL

ObjectRefList_30_0

ObjectRefList_30_0

nvarchar(max)

NULL

PlantumlEntity_0_30_ObjectRef

PlantumlEntity_0_30_ObjectRef

nvarchar(max)

NOT NULL

PlantumlEntity_1_1_ColRef

PlantumlEntity_1_1_ColRef

nvarchar(max)

NOT NULL

PlantumlEntity_1_1_FkRef

PlantumlEntity_1_1_FkRef

nvarchar(max)

NOT NULL

PlantumlEntity_1_1_ObjectRef

PlantumlEntity_1_1_ObjectRef

nvarchar(max)

NOT NULL

PlantumlEntity_30_0_ObjectRef

PlantumlEntity_30_0_ObjectRef

nvarchar(max)

NOT NULL

PumlEntityList

PumlEntityList

nvarchar(max)

NULL

PumlEntityList_0_30

PumlEntityList_0_30

nvarchar(max)

NULL

PumlEntityList_30_0

PumlEntityList_30_0

nvarchar(max)

NULL

RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([RepoObject_schema_name],'.',[RepoObject_name]))


sql_modules_definition

docs.RepoObject_Plantuml - V script
CREATE View docs.RepoObject_Plantuml
As
Select
    ro.RepoObject_guid
  --in case of ro.is_external = 1 the cultures_name is ''
  , cultures_name       = Coalesce ( rof.cultures_name, '' )
  , ro.RepoObject_fullname2
  , elist_1_1.PumlEntityList
  , PumlEntityList_0_30 = elist_0_30.PumlEntityList
  , PumlEntityList_30_0 = elist_30_0.PumlEntityList
  , clist.ColRefList
  , olist_1_1.ObjectRefList
  , ObjectRefList_0_30  = olist_0_30.ObjectRefList
  , ObjectRefList_30_0  = olist_30_0.ObjectRefList
  , PlantumlEntity_1_1_ColRef
  --
                        = Concat (
                                     '@startuml' + Char ( 13 ) + Char ( 10 )
                                   , docs.fs_PumlHeaderLeftToRight ()
                                   , elist_1_1.PumlEntityList
                                   , Char ( 13 ) + Char ( 10 )
                                   , olist_1_1.ObjectRefList
                                   , Char ( 13 ) + Char ( 10 )
                                   , clist.ColRefList
                                   , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + puml_footer.Parameter_value_result + Char ( 13 )
                                     + Char ( 10 )
                                   , Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
                                 )
  , PlantumlEntity_1_1_ObjectRef
  --
                        = Concat (
                                     '@startuml' + Char ( 13 ) + Char ( 10 )
                                   , docs.fs_PumlHeaderLeftToRight ()
                                   , elist_1_1.PumlEntityOnlyPkList
                                   , Char ( 13 ) + Char ( 10 )
                                   , olist_1_1.ObjectRefList
                                   , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + puml_footer.Parameter_value_result + Char ( 13 )
                                     + Char ( 10 )
                                   , Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
                                 )
  , PlantumlEntity_0_30_ObjectRef
  --
                        = Concat (
                                     '@startuml' + Char ( 13 ) + Char ( 10 )
                                   , docs.fs_PumlHeaderTopToBottom ()
                                   , elist_0_30.PumlEntityOnlyPkList
                                   , Char ( 13 ) + Char ( 10 )
                                   , olist_0_30.ObjectRefList
                                   , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + puml_footer.Parameter_value_result + Char ( 13 )
                                     + Char ( 10 )
                                   , Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
                                 )
  , PlantumlEntity_30_0_ObjectRef
  --
                        = Concat (
                                     '@startuml' + Char ( 13 ) + Char ( 10 )
                                   , docs.fs_PumlHeaderTopToBottom ()
                                   , elist_30_0.PumlEntityOnlyPkList
                                   , Char ( 13 ) + Char ( 10 )
                                   , olist_30_0.ObjectRefList
                                   , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + puml_footer.Parameter_value_result + Char ( 13 )
                                     + Char ( 10 )
                                   , Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
                                 )
  , PlantumlEntity_1_1_FkRef
  --
                        = Concat (
                                     '@startuml' + Char ( 13 ) + Char ( 10 )
                                   , docs.fs_PumlHeaderLeftToRight ()
                                   , EntityFkList.PumlEntityFkList
                                   , Char ( 13 ) + Char ( 10 )
                                   , FkRefList.FkRefList
                                   , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + puml_footer.Parameter_value_result + Char ( 13 )
                                     + Char ( 10 )
                                   , Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
                                 )
From
    repo.RepoObject_gross                                                                                            As ro
    Left Join
        docs.RepoObject_OutputFilter_T                                                                               As rof
            On
            rof.RepoObject_guid = ro.RepoObject_guid

    Left Join
        docs.RepoObject_Plantuml_ColRefList_1_1                                                                      As clist
            On
            clist.RepoObject_guid = ro.RepoObject_guid
            --in case of ro.is_external = 1 the cultures_name is ''
            And clist.cultures_name = Coalesce ( rof.cultures_name, '' )

    Left Join
        docs.RepoObject_Plantuml_ObjectRefList_1_1                                                                   As olist_1_1
            On
            olist_1_1.RepoObject_guid = ro.RepoObject_guid
    --object references are the same for all cultures
    --because the filenames are the same for all cultures
    ----in case of ro.is_external = 1 the cultures_name is ''
    --And olist_1_1.cultures_name = Coalesce ( rof.cultures_name, '' )

    Left Join
        docs.RepoObject_Plantuml_ObjectRefList_0_30                                                                  As olist_0_30
            On
            olist_0_30.RepoObject_guid = ro.RepoObject_guid
    --object references are the same for all cultures
    --because the filenames are the same for all cultures
    ----in case of ro.is_external = 1 the cultures_name is ''
    --And olist_0_30.cultures_name = Coalesce ( rof.cultures_name, '' )

    Left Join
        docs.RepoObject_Plantuml_ObjectRefList_30_0                                                                  As olist_30_0
            On
            olist_30_0.RepoObject_guid = ro.RepoObject_guid
    --object references are the same for all cultures
    --because the filenames are the same for all cultures
    ----in case of ro.is_external = 1 the cultures_name is ''
    --And olist_30_0.cultures_name = Coalesce ( rof.cultures_name, '' )
    Cross Apply docs.ftv_RepoObject_Reference_PlantUml_EntityRefList ( ro.RepoObject_guid, 1, 1, rof.cultures_name ) As elist_1_1
    Cross Apply docs.ftv_RepoObject_Reference_PlantUml_EntityRefList ( ro.RepoObject_guid, 30, 0, rof.cultures_name ) As elist_30_0
    Cross Apply docs.ftv_RepoObject_Reference_PlantUml_EntityRefList ( ro.RepoObject_guid, 0, 30, rof.cultures_name ) As elist_0_30
    --Cross Apply docs.ftv_RepoObject_Reference_PlantUml_EntityRefList ( ro.RepoObject_guid, 1, 1 , rof.cultures_name) As elist_cyclic
    Left Join
        docs.RepoObject_PlantUml_PumlEntityFkList                              As EntityFkList
            On
            EntityFkList.RepoObject_guid = ro.RepoObject_guid
            And EntityFkList.cultures_name = rof.cultures_name

    Left Join
        docs.RepoObject_PlantUml_FkRefList                                     As FkRefList
            On
            FkRefList.RepoObject_guid = ro.RepoObject_guid
    Cross Join config.ftv_get_parameter_value ( 'puml_footer', 'interactive' ) As puml_footer
Where
    Not rof.RepoObject_guid Is Null
    Or ro.is_external = 1