The SHOW report lists the DML_statement DDL definitions in order of dependencies, first listing the definitions of independent objects and then listing dependent objects.
The rank ordering of the DDL definitions in the report is as follows:
1 Base tables
2 Referenced (parent) tables of base tables
3 Error tables
7 Join and hash indexes