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