docs.RepoObject_Plantuml - V
type: V ( view ), modify_date: 2021-12-16 11:41:19
RepoObject_guid: F20B29C2-E595-EB11-84F4-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_RepoObject_Plantuml
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 1, 1, 0
idx_RepoObject_Plantuml__1
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_Plantuml__3
-
IndexSemanticGroup: no_group
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
PlantumlEntity_0_30_ObjectRef
PlantumlEntity_0_30_ObjectRef |
|
|
PlantumlEntity_1_1_ObjectRef
PlantumlEntity_1_1_ObjectRef |
|
|
PlantumlEntity_30_0_ObjectRef
PlantumlEntity_30_0_ObjectRef |
|
|
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