1 Schema: [% schema.name %]
2 Database: [% schema.database %]
4 [%- FOREACH table = schema.get_tables %]
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 table: [% field.table %]
26 [%- FOREACH index = table.get_indices %]
28 table: [% index.table %]
29 fields: [% index.fields.join(', ') %]
30 type: [% index.type %]
31 options: [% index.options %]
32 is_valid: [% index.is_valid %]
36 [%- FOREACH constraint = table.get_constraints %]
37 [% constraint.name OR "?" %]
38 type: [% constraint.type %]
39 fields: [% constraint.fields.join(', ') %]
40 expression: [% constraint.expression %]
41 match_type: [% constraint.match_type %]
42 reference_fields: [% constraint.reference_fields.join(', ') %]
43 reference_table: [% constraint.reference_table.join(', ') %]
44 deferrable: [% constraint.deferrable %]
45 on_delete: [% constraint.on_delete %]
46 on_update: [% constraint.on_update %]
47 options: [% constraint.options %]
48 is_valid: [% constraint.is_valid %]