1 Schema: [% schema.name %]
2 Database: [% schema.database %]
4 [%- FOREACH table = schema.get_tables %]
5 Table: [% table.name %]
6 ==========================================================================
9 [%- FOREACH field = table.get_fields %]
11 data_type: [% field.data_type %]
12 size: [% field.size %]
13 is_nullable: [% field.is_nullable %]
14 default_value: [% field.default_value %]
15 is_primary_key: [% field.is_primary_key %]
16 is_unique: [% field.is_unique %]
17 is_auto_increment: [% field.is_auto_increment %]
18 is_foreign_key: [% field.is_foreign_key %]
19 foreign_key_reference: [% field.foreign_key_reference %]
20 is_valid: [% field.is_valid %]
21 order: [% field.order %]
22 extra: [% field.extra %]
23 table: [% field.table.name %]
27 [%- FOREACH index = table.get_indices %]
29 table: [% index.table.name %]
30 fields: [% index.fields.join(', ') %]
31 type: [% index.type %]
32 options: [% index.options %]
33 is_valid: [% index.is_valid %]
37 [%- FOREACH constraint = table.get_constraints %]
38 [% constraint.name OR "?" %]
39 type: [% constraint.type %]
40 fields: [% constraint.fields.join(', ') %]
41 expression: [% constraint.expression %]
42 match_type: [% constraint.match_type %]
43 reference_fields: [% constraint.reference_fields.join(', ') %]
44 reference_table: [% constraint.reference_table.join(', ') %]
45 deferrable: [% constraint.deferrable %]
46 on_delete: [% constraint.on_delete %]
47 on_update: [% constraint.on_update %]
48 options: [% constraint.options %]
49 is_valid: [% constraint.is_valid %]