Template Parameters and Syntax for PDM Pages

This page provides "templates" for populating the Library book pages.

Table Pages

[+] Show blank template for GIM and RAA

<onlyinclude>
{{PDMTable
|tableName = 
|shortDesc = 
|tableDesc = 
|subjectAreas = 
|introduced = 
|modified = 
|discontinued = 
|group = 
|partitioned = 
}}

{{PDMColumn
|colName = 
|dataType_Ora = 
|dataType_MSSQL = 
|dataType_Postgre = 
|primaryKey = 
|mandatory = 
|foreignKey = 
|default =
|colDesc = 
|introduced = 
|modified = 
|discontinued = 
}}

{{PDMIndex}}
{{PDMIndexItem
|indexName = 
|indexDesc = 
|indexPresentInPartitioned = 
|indexKey = [or |indexKey1, |indexKey2, etc.]
|keyPresentInNonpartitioned = [or |keyPresentInNonpartitioned1, |keyPresentInNonpartitioned2, etc.]
|sort = [or |sort1, |sort2, etc.]
|unique = 
|cluster =
}}

{{PDMRef
|parentTable =  [or |parentView]
|foreignKey = 
}}
</onlyinclude>

Subject Area pages

|diagram = Insert the file name of the graphics file(s) to use. If there is more than one diagram, use a comma-separated list. The template rules are:

• If the value of the |diagram parameter includes the file type, the parameter value is used in full as the graphics file name. The template recognizes the following file types: jpg, jpeg, gif, png.
• Otherwise, the template will construct a file name that follows the <product>-<category>-<descriptivename>-<rdbms>.png pattern, using the value of the |diagram parameter as the <category>-<descriptivenname> part of the file name and appending the <product> prefix and <rdbms>.png suffix based on the URL of the PDM page.

For example:

• |diagram=GIM-SA-Facts.png — The template will use GIM-SA-Facts.png in all the PDMs.
• |diagram=SA-SummaryResourceState — The template will use GIM-SA-SummaryResourceState-MSSQL.png, GIM-SA-SummaryResourceState-Ora.png, and GIM-SA-SummaryResourceState-Postgre.png in the respective PDMs.

==