Back to Openemr

{{table.name}}

Documentation/EHI_Export/schemaspy/layout/tables/table.html

latest1.8 KB
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
{{#columns}}{{{keyIcon}}}{{column.name}}{{column.typeName}}{{column.detailedSize}}{{nullable}}{{autoUpdated}}{{defaultValue}}

{{#children}} | {{table.name}}.{{column.name}} | {{constraint.name}} | {{constraint.deleteRuleAlias}} | {{/children}} |

{{#parents}} | {{table.name}}.{{column.name}} | {{constraint.name}} | {{constraint.deleteRuleAlias}} | {{/parents}} | {{{comments}}} | {{/columns}}

{{^indexes.isEmpty}}

Indexes

Constraint NameTypeSortColumn(s)
{{#indexes}}{{{keyIcon}}}{{index.name}}{{index.type}}{{{index.sortAsString}}}
{{/indexes}}

{{/indexes.isEmpty}} {{^checkConstraints.isEmpty}}

Check Constraints

Constraint NameConstraint
{{#checkConstraints}}{{name}}
{{/checkConstraints}}

{{/checkConstraints.isEmpty}} {{^diagrams.isEmpty}}

Relationships

Close relationships within degrees of separation

{{#diagrams}} {{{map}}} {{#isEmbed}} {{/isEmbed}} {{^isEmbed}} {{/isEmbed}} {{/diagrams}}

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

{{sqlCode}}


Possibly Referenced Tables/Views

{{#references}} - {{name}} {{/references}}

{{/sqlCode}}