property.RepoObjectProperty_cross - V

type: V ( view ), modify_date: 2021-10-02 13:23:34

RepoObject_guid: EC5BF6C2-0593-EB11-84F2-A81E8446D5B0

Description

  • cross join between RepoObject and all used properties in any RepoObject

  • required for Antora export: per RepoObject we export partials for all Properties:
    When we use includes with tags we can’t check if the tags exists or not. That’s why we need to create all tags, with contents without content

Examples

Entity Diagram

entity-property.repoobjectproperty_cross

Columns

Table 1. Columns of property.RepoObjectProperty_cross - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

2

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-property.repoobjectproperty_cross

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-property.repoobjectproperty_cross

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.repoobjectproperty_cross

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.repoobjectproperty_cross

Column Reference Diagram

entity_1_1_colref-property.repoobjectproperty_cross

Indexes

PK_RepoObjectProperty_cross

idx_RepoObjectProperty_cross__2

idx_RepoObjectProperty_cross__3

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

property_name

2

property_name

nvarchar(128)

NULL

sql_modules_definition

property.RepoObjectProperty_cross - V script
/*
<<property_start>>Description
* cross join between RepoObject and *all* used properties in any RepoObject
* required for Antora export: per RepoObject we export partials for all Properties: +
When we use includes with tags we can't check if the tags exists or not. That's why we need to create all tags, with contents without content
<<property_end>>
*/
CREATE View property.RepoObjectProperty_cross
As
Select
    ro.RepoObject_guid
  , p.property_name
From
    repo.RepoObject                             As ro
    Cross Join property.PropertyName_RepoObject As p