Blank Templates — Syntax for PDM Pages

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

Table Pages

<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>

</toggledisplay>

<toggledisplay showtext="[+] Show blank template for ICON" hidetext="[-] Hide blank template for ICON">

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

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

{{PDMIndex}}
{{PDMIndexItem
|indexName = 
|indexDesc = 
|indexKey = 
|sort = 
|unique = 
|cluster = 
}}

{{PDMRef
|parentTable = 
|refCode = 
|foreignKey = 
}}
</onlyinclude>