Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
{% for table_column in columns %}
{{ table_column.get_key_icon()|safe }}{{ table_column.name }} |
{{ table_column.type_name }} |
{{ table_column.detailed_size }} |
{{ table_column.get_nullable() }} |
{{ table_column.get_auto_updated() }} |
{{ table_column.get_default_value() }} |
{% for constraint in table_column.get_children() %}
{{ constraint.child_table.name }}.{{ table_column.name }} |
{{ constraint.name }}{{ constraint.get_delete_rule_alias() }} |
{% endfor %}
|
{% for constraint in table_column.get_parents() %}
{{ constraint.parent_table.name }}.{{ table_column.name }} |
{{ constraint.name }}{{ constraint.get_delete_rule_alias() }} |
{% endfor %}
|
{{ table_column.comments|safe }} |
{% endfor %}
{% if not indexes.isEmpty %}
Constraint Name |
Type |
Index Type |
Column(s) |
{% for index in indexes %}
{{ index.get_key_icon()|safe }}{{ index.name }} |
{{ index.get_type() }} |
{{ index.get_index_type()|safe }} |
{{ index.columns_as_string() }} |
{% endfor %}
{% endif %}
{% if diagram_tables or diagram_relationships %}
{% endif %}
{% if not diagram_tables and diagram_relationships %}
Diagram producer might be missing
No diagrams were produced please see application output for any errors
{% endif %}
{% if sql_code %}
{% endif %}