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