I have chosen PhpMyAdmin as GUI for my DB admin tool.
However I encountered a few problems with it.
1. I created the pdf output of the database but there's a highlighted field in almost every table and its not the primary keys, I realised that it's becos I clicked Relation View/Choose Field to display, and the field will be hightlighted in a diff. color from the PK, which i dun want.
How can I remove the highlighted field in pdf?
( On a side-note, the documentation doesnt state that the config variable for 'table_info' need to be filled up for pdf to be edited. But apparently, in my case, i need to create the table_info for me to edit and process pdf.)
2. Can the PDF output display the type of R/S between tables? Like one-to-many or one-to-one. If so, how do i modify it?
3. Under Relation View, what does the 'Links to' mean as far as master key and foreign key. If A links to B, does that mean B is a master key and A a foreign key? Can A be part of a series of primary keys in its own table?
Did you enable the extra pdf functions of PHPMyAdmin yourself?
If so, you would have created a database and some tables. In these tables are all the definitions of your constraints etc. that PHPMyAdmin uses to create the pdf's. Simply find the relevent rows and delete them.
hmmp.... if i self-assign the relationships of tables by linking them together which means i will determine the foreign keys manually and link them manually, can referential integerity be enforced if i use the function 'Check Referential Integrity' ?