pma and mysql
There are my pma settings for bwHead. It helps a lot to understand the bw schema with mysql
<?php
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_comments', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_attachments', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_comments', 'parent_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_comments', 'root_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_structures', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_structures', 'root_structure_id', 'bwHead', 'liberty_structures', 'structure_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'users_groups_map', 'user_id', 'bwHead', 'users_users', 'user_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'users_groups_map', 'group_id', 'bwHead', 'users_groups', 'group_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'wiki_pages', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'pigeonholes', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'pigeonholes', 'structure_id', 'bwHead', 'liberty_structures', 'structure_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'pigeonhole_members', 'parent_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'stars_history', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'stars_history', 'user_id', 'bwHead', 'users_users', 'user_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'stars', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_table_info` ( `db_name` , `table_name` , `display_field` ) VALUES ('bwHead', 'liberty_content', 'title');
INSERT INTO `pma_table_info` ( `db_name` , `table_name` , `display_field` ) VALUES ('bwHead', 'users_users', 'login');
INSERT INTO `pma_table_info` ( `db_name` , `table_name` , `display_field` ) VALUES ('bwHead', 'users_groups', 'group_name');
?>