docs.ObjectRefCyclic - V

type: V ( view ), modify_date: 2021-11-17 11:41:55

RepoObject_guid: 87E72F09-C5FD-EB11-850F-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.objectrefcyclic

Columns

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

nvarchar(10)

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(max)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.objectrefcyclic

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.objectrefcyclic

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.objectrefcyclic

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.objectrefcyclic

Column Reference Diagram

entity_1_1_colref-docs.objectrefcyclic

Column Details

_

cultures_name

cultures_name

nvarchar(10)

NOT NULL

Referenced Columns

ObjectRefCyclic_Puml

ObjectRefCyclic_Puml

nvarchar(max)

NOT NULL

page_content

page_content

nvarchar(max)

NOT NULL

sql_modules_definition

docs.ObjectRefCyclic - V script
CREATE View docs.ObjectRefCyclic
As
Select
    c.cultures_name
  , page_content         =
  --
  Concat (
             '= Cyclic Object References'
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           , '== Object List'
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           , elist.XrefEntityList
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           , '== Object Reference Diagram - Cyclic'
           , Char ( 13 ) + Char ( 10 )
           , '
[plantuml, ObjectRefCyclic, svg, subs=macros]
....
'
           --, '\include::partial$puml/objectrefcyclic.puml[]'
           , Concat (
                        '@startuml' + Char ( 13 ) + Char ( 10 )
                      , docs.fs_PumlHeaderTopToBottom ()
                      , elist.PumlEntityOnlyPkList
                      , Char ( 13 ) + Char ( 10 )
                      , olist.PumlObjectRefList
                      , Char ( 13 ) + Char ( 10 ) + puml_footer.Parameter_value_result + Char ( 13 ) + Char ( 10 )
                      , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
                    )
           , '
....
'
         )
  --can be removed, if export is not required:
  , ObjectRefCyclic_Puml =
  --
  Concat (
             '@startuml' + Char ( 13 ) + Char ( 10 )
           , docs.fs_PumlHeaderTopToBottom ()
           , elist.PumlEntityOnlyPkList
           , Char ( 13 ) + Char ( 10 )
           , olist.PumlObjectRefList
           , Char ( 13 ) + Char ( 10 ) + puml_footer.Parameter_value_result + Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
         )
From
    docs.Culture                                  As c
    Left Join
        docs.ObjectRefCyclic_EntityList           As elist
            On
            elist.cultures_name = c.cultures_name
    Cross Join docs.ObjectRefCyclic_ObjectRefList As olist
    Cross Join config.ftv_get_parameter_value ( 'puml_footer', 'interactive' ) As puml_footer