2 <a name="$table.name"/>
\r
6 <table border="1" cellspacing="0">
\r
8 <th class="normalFont" bgcolor="#CCCCCC">PK</th>
\r
9 <th class="normalFont" bgcolor="#CCCCCC">INC</th>
\r
10 <th class="normalFont" bgcolor="#CCCCCC">UQ</th>
\r
11 <th class="normalFont" bgcolor="#CCCCCC">Name</th>
\r
12 <th class="normalFont" bgcolor="#CCCCCC">Type</th>
\r
13 <th class="normalFont" bgcolor="#CCCCCC">Size</th>
\r
14 <th class="normalFont" bgcolor="#CCCCCC">NotNull</th>
\r
15 <th class="normalFont" bgcolor="#CCCCCC">Default</th>
\r
16 <th class="normalFont" bgcolor="#CCCCCC">ForeignTable</th>
\r
17 <th class="normalFont" bgcolor="#CCCCCC">ReferrerTable</th>
\r
18 <th class="normalFont" bgcolor="#CCCCCC">PropertyName</th>
\r
19 <th class="normalFont" bgcolor="#CCCCCC">${table.database.targetLanguageInitCap}Type</th>
\r
20 <th class="normalFont" bgcolor="#CCCCCC">Classification</th>
\r
21 <th class="normalFont" bgcolor="#CCCCCC">Comment</th>
\r
23 #foreach ($col in $table.columns)
\r
25 <td class="normalFont"><center> #if ($col.isPrimaryKey())o#else #end </center></td>
\r
26 <td class="normalFont"><center> #if ($col.isAutoIncrement())o#else #end </center></td>
\r
27 <td class="normalFont"><center> #if ($col.isUnique())o#else #end </center></td>
\r
28 <td class="normalFont" id="${table.name}${col.name}">${col.name}</td>
\r
29 <td class="normalFont">${col.dbType}</td>
\r
30 <td class="normalFont"><center>#if ($col.hasColumnSize()) ${col.columnSize} #else #end </center></td>
\r
31 <td class="normalFont"><center> #if ($col.isNotNull())o#else #end </center></td>
\r
32 <td class="normalFont">#if ($col.hasDefaultValue() && !$col.isAutoIncrement()) ${col.defaultValue}#else #end</td>
\r
33 <td class="normalFont"><a href="#${col.foreignTableName}">${col.foreignTableName}</a> </td>
\r
34 <td class="normalFont">${col.referrerTableCommaStringWithHtmlHref} </td>
\r
35 <td class="normalFont">${col.javaBeansRulePropertyName}</td>
\r
36 <td class="normalFont">${col.javaNative}</td>
\r
37 <td class="normalFont">#if ($col.hasClassification()==true)<a href="${table.database.sharp}${col.classificationName}">${col.classificationName}</a>#else #end</td>
\r
38 <td class="normalFont">#if ($col.hasComment()) ${col.comment}#else #end</td>
\r
43 #foreach ($foreignKey in $table.foreignKeys)
\r
44 if(document.getElementById) {
\r
45 #foreach ($columnName in $foreignKey.localColumns)
\r
46 var col = document.getElementById("${table.name}${columnName}");
\r
48 col.style.backgroundColor = "${docHtmlFkColor}";
\r
49 col.title="Foreignkey from ${foreignKey.foreignTableName}.${foreignKey.foreignColumnNames}";
\r