Commit | Line | Data |
2b2601b5 |
1 | Schema: [% schema.name %] |
2 | Database: [% schema.database %] |
3 | |
4 | [%- FOREACH table = schema.get_tables %] |
462ede1e |
5 | Table: [% table %] |
2b2601b5 |
6 | ========================================================================== |
7 | |
8 | Fields |
9 | [%- FOREACH field = table.get_fields %] |
462ede1e |
10 | [% field %] |
2b2601b5 |
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 %] |
462ede1e |
22 | table: [% field.table %] |
2b2601b5 |
23 | [% END %] |
24 | |
25 | Indices |
26 | [%- FOREACH index = table.get_indices %] |
27 | [% index.name %] |
462ede1e |
28 | table: [% index.table %] |
2b2601b5 |
29 | fields: [% index.fields.join(', ') %] |
30 | type: [% index.type %] |
31 | options: [% index.options %] |
32 | is_valid: [% index.is_valid %] |
33 | [% END %] |
34 | |
35 | Constraints |
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 %] |
49 | [% END -%] |
50 | [% END %] |