1
+--------------------------------------------+
3
+--------------------------------------------+
5
Total number of Schemata: {{SCHEMA_COUNT}}
6
=============================================
8
{{SCHEMA_NR}}. Schema: {{SCHEMA_NAME}}
9
----------------------------------------------
10
## Tables ({{TABLE_COUNT}}) ##
11
{{#TABLES}}{{TABLE_NR_FMT}}. Table: {{TABLE_NAME}}
12
{{#COLUMNS_LISTING}}## Columns ##
13
Key Column Name Datatype Not Null Default Comment
14
{{#COLUMNS}} {{COLUMN_KEY}} {{COLUMN_NAME}} {{COLUMN_DATATYPE}} {{COLUMN_NOTNULL}} {{COLUMN_DEFAULTVALUE}} {{COLUMN_COMMENT}}
15
{{/COLUMNS}}{{/COLUMNS_LISTING}}
16
{{#INDICES_LISTING}}## Indices ##
17
Index Name Columns Primary Unique Type Kind Comment
18
{{#INDICES}} {{INDEX_NAME}} {{#INDICES_COLUMNS}}{{INDEX_COLUMN_NAME}} {{INDEX_COLUMN_ORDER}} {{INDEX_COLUMN_COMMENT}}{{/INDICES_COLUMNS}} {{INDEX_PRIMARY}} {{INDEX_UNIQUE}} {{INDEX_TYPE}} {{INDEX_KIND}} {{INDEX_COMMENT}}
19
{{/INDICES}}{{/INDICES_LISTING}}
20
{{#REL_LISTING}}## Relationships ##
21
Relationship Name Relationship Type Parent Table Child Table Cardinality
22
{{#REL}} {{REL_NAME}} {{REL_TYPE}} {{REL_PARENTTABLE}} {{REL_CHILDTABLE}} {{REL_CARD}}
23
{{/REL}}{{/REL_LISTING}}
24
---------------------------------------------
28
=============================================
29
End of MySQL Workbench Report