docs.RepoObject_PlantUml_PumlEntityFkList - V

type: V ( view ), modify_date: 2022-09-08 16:31:26

RepoObject_guid: 1D224606-439A-EB11-84F5-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.repoobject_plantuml_pumlentityfklist

Columns

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

1

uniqueidentifier

NULL

nvarchar(10)

NOT NULL

nvarchar(max)

NULL

nvarchar(257)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.repoobject_plantuml_pumlentityfklist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.repoobject_plantuml_pumlentityfklist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.repoobject_plantuml_pumlentityfklist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.repoobject_plantuml_pumlentityfklist

Column Reference Diagram

entity_1_1_colref-docs.repoobject_plantuml_pumlentityfklist

Indexes

PK_RepoObject_PlantUml_PumlEntityFkList

idx_RepoObject_PlantUml_PumlEntityFkList__2

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NULL

cultures_name

cultures_name

nvarchar(10)

NOT NULL

PumlEntityFkList

PumlEntityFkList

nvarchar(max)

NULL

RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NULL

Description

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


sql_modules_definition

docs.RepoObject_PlantUml_PumlEntityFkList - V script
CREATE View docs.RepoObject_PlantUml_PumlEntityFkList
As
Select
    ro.RepoObject_guid
  , rop.cultures_name
  , RepoObject_fullname2 = Max ( ro.RepoObject_fullname2 )
  , PumlEntityFkList     = String_Agg ( Cast(rop.RepoObject_PumlOnlyIndex As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                                         ro.included_RepoObject_fullname2)
From
    repo.RepoObject_related_FK_union      As ro
    Inner Join
        docs.RepoObject_Plantuml_Entity_T As rop
            On
            rop.RepoObject_guid = ro.included_RepoObject_guid
Group By
    ro.RepoObject_guid
  , rop.cultures_name