{{table.name}}

{{#displayNumRows}}

{{table.numRows}} rows

{{/displayNumRows}}
{{#comments}}

Description

{{{comments}}}
{{/comments}}

Columns

{{#columns}} {{{keyIcon}}}{{column.name}} {{/columns}}
Column Type Size Nulls Auto Default Children Parents Comments
{{column.typeName}} {{column.detailedSize}} {{nullable}} {{autoUpdated}} {{defaultValue}} {{#children}} {{/children}}
{{table.name}}.{{column.name}} {{constraint.name}} {{constraint.deleteRuleAlias}}
{{#parents}} {{/parents}}
{{table.name}}.{{column.name}} {{constraint.name}} {{constraint.deleteRuleAlias}}
{{{comments}}}
{{^indexes.isEmpty}}

Indexes

{{#indexes}} {{{keyIcon}}}{{index.name}} {{/indexes}}
Constraint Name Type Sort Column(s)
{{index.type}} {{{index.sortAsString}}} {{index.columnsAsString}}
{{/indexes.isEmpty}} {{^checkConstraints.isEmpty}}

Check Constraints

{{#checkConstraints}} {{/checkConstraints}}
Constraint Name Constraint
{{name}} {{definition}}
{{/checkConstraints.isEmpty}} {{^diagrams.isEmpty}}

Relationships

{{/diagrams.isEmpty}} {{#diagrams.isEmpty}}{{^table.isView}}

Diagram producer might be missing

No diagrams were produced please see application output for any errors

{{/table.isView}}{{/diagrams.isEmpty}} {{#sqlCode}}

View Definition


Possibly Referenced Tables/Views

    {{#references}}
  • {{name}}
  • {{/references}}
{{/sqlCode}}