PDMSchemaPageFormat

Formatting template to format schema pages in the RDBMS-specific, customer-facing manuals. This template is called by the Schema query in Template:PDMPageQuery. It parallels the formatting in the {{Template:PDMSchema]] template, which formats the Library book pages.

TO DO: The initial repeated {{#if}} statements for possibly multiple diagrams, which are replicated from the previous DPL query formatting, can now be replaced by a more elegant Cargo query since the relevant parameters are now defined as lists.

The template includes sub-queries to populate lists of tables, indexes and references in the schema.

Content is:

{{#switch:{{#explode:{{{page}}}|:|3}}|Schema-Core={{#switch:{{#explode:{{{page}}}|:|2}}|PDMMS|PDMOra|PDMPostgre|PDMDB2={{{{{pageName}}}}}|Library|#default=}}|#default=}}
{{#if:{{{schemaDesc|}}}|{{{schemaDesc}}}|}}
{{#if:{{#explode:{{{diagram}}}|,|1}}|=={{{schemaName}}} Schema Diagrams==|=={{{schemaName}}} Schema Diagram==}}
{{#if:{{{diagramComment|}}}|{{{diagramComment}}}|}}

{{#if:{{#explode:{{{diagram}}}|,|1}}|{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|0}}|caption={{#explode:{{{caption}}}|,|0}}}}
{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|1}}|caption={{#explode:{{{caption}}}|,|1}}}}

{{#if:{{#explode:{{{diagram}}}|,|2}}|{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|2}}|caption={{#explode:{{{caption}}}|,|2}}}}|}}

{{#if:{{#explode:{{{diagram}}}|,|3}}|{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|3}}|caption={{#explode:{{{caption}}}|,|3}}}}|}}

{{#if:{{#explode:{{{diagram}}}|,|4}}|{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|4}}|caption={{#explode:{{{caption}}}|,|4}}}}|}}

{{#if:{{#explode:{{{diagram}}}|,|5}}|{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|5}}|caption={{#explode:{{{caption}}}|,|5}}}}|}}

{{#if:{{#explode:{{{diagram}}}|,|6}}|{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|6}}|caption={{#explode:{{{caption}}}|,|6}}}}|}}

{{#if:{{#explode:{{{diagram}}}|,|7}}|{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|7}}|caption={{#explode:{{{caption}}}|,|7}}}}|}}

{{#if:{{#explode:{{{diagram}}}|,|8}}|{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|8}}|caption={{#explode:{{{caption}}}|,|8}}}}|}}

{{#if:{{#explode:{{{diagram}}}|,|9}}|{{Template:PDMDiagramLink|diagram={{#explode:{{{diagram}}}|,|9}}|caption={{#explode:{{{caption}}}|,|9}}}}|}}|{{Template:PDMDiagramLink|diagram={{{diagram}}}|caption={{{caption}}}}}}}

==List of Tables==
{{PDMListQuery|object=Table|withDesc=yes|page={{{page}}}|addFilter= AND dbSchema LIKE "{{#explode:{{#explode:{{FULLPAGENAME}}|:|3}}|-|1}}"}}
{{AnchorDiv|IndexList}}
==List of Indexes==
{{PDMIndexQuery|page={{{page}}}}}
{{AnchorDiv|RefList}}
==List of References==
{{PDMRefQuery|page={{{page}}}}}

---

{{{schemaName}}} Schema Diagram

[[File:PDMSchemaPageFormat-{{{diagram}}}-Ora.png|thumb|center|link=|{{{caption}}} View Large]]

List of Tables

No results

Index List

No indexes are defined.