docs.AntoraNavListPage_by_type - V

type: V ( view ), modify_date: 2021-10-03 20:32:54

RepoObject_guid: 861293B9-DE96-EB11-84F4-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.antoranavlistpage_by_type

Columns

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

nvarchar(4000)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.antoranavlistpage_by_type

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.antoranavlistpage_by_type

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.antoranavlistpage_by_type

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.antoranavlistpage_by_type

Column Reference Diagram

entity_1_1_colref-docs.antoranavlistpage_by_type

Indexes

idx_AntoraNavListPage_by_type__1

  • IndexSemanticGroup: no_group

    • type; nvarchar(128)

  • PK, Unique, Real: 0, 0, 0

Column Details

_

nav_list

nav_list

nvarchar(4000)

NOT NULL

type

type

nvarchar(128)

NULL

Referenced Columns

type_desc

type_desc

nvarchar(128)

NULL

Referenced Columns

sql_modules_definition

docs.AntoraNavListPage_by_type - V script
CREATE View [docs].[AntoraNavListPage_by_type]
As
Select
    t.type
  , t.type_desc
  , nav_list =
  --
  Concat (
             '= '
           , t.type_desc
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           , '\include::partial$navlist/navlist-type-' + docs.fs_cleanStringForFilename ( t.type ) + '.adoc[]'
           , Char ( 13 ) + Char ( 10 )
         )
From
    configT.type As t
Where
    ( t.is_DocsOutput = 1 )
    And Exists
(
    Select
        1
    From
        docs.RepoObject_OutputFilter_T As f
    Where
        f.SysObject_type = t.type
)