gist: search for tables [here]
gist: explain query and tables: [here]
gist: dump database from CMD (import export): [here]
EXPLAIN will give you more information about a query.
DESCRIBE will give you more information about tables or columns.
You can also use EXPLAIN on a table name, in which case it will behave exactly like DESCRIBE.
To see how the table where structured use SHOW CREATE table <table_name>;
SHOW CREATE table <table_name>;
DESC <table_name>;
SHOW DATABASES;
SHOW TABLES;
SHOW CREATE table ps_product;
Shows how table was originally constructed.
DESC ps_product
DESCRIBE ps_product
Both query will show the same output.
Searching for related tables
If your database uses some naming convection as it should you can search for tables that relates to each other directly. PrestaShop use tables names so that they represent the relations between key tables. Knowing that you can search for all tables containing some name (just make sure to use the correct database before):.
SELECT TABLE_NAME, ENGINE, TABLE_COLLATION, CREATE_OPTIONS, TEMPORARY
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%product%' GROUP BY TABLE_NAME;