- started working on PPM Widgets
- created DraggableTablesContainer, TableInfoPanel, TableInfoList
- working on getting table information for TableInfoPanel
- A Diagram of the MySQL information schema
- find primary key of table
SELECT c.*, ke.REFERENCED_TABLE_NAME FROM information_schema.COLUMNS c LEFT JOIN information_schema.KEY_COLUMN_USAGE ke USING (TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME) WHERE c.table_schema='test' ORDER BY ke.referenced_table_name;
got Tables, Primary Keys and Foreign Keys to display…
