Columns

{% for row in structure %} {% endfor %}
Name Type Not null Primary key Default
{{row["name"]}} {{row["type"]}} {% if row["notnull"] == 1 %}✓{% endif %} {% if row["pk"] == 1 %}✓{% endif %} {{row["dflt_value"]}}
{% if foreign_keys %}

Foreign Keys

{% for key in foreign_keys %} {% endfor %}
Column Reference
{{key["from"]}} {{key['table']}}.{{key["to"]}}
{% endif %}