Doing More with phpMyAdmin (Part 2) - Looking Up the Dictionary (
Page 6 of 7 )
One of the most
interesting features to be introduced in the latest version of phpMyAdmin is the
ability to create a database dictionary in PDF format. For the uninformed, this
is a comprehensive document that offers an overview of all the objects in a
database - tables, columns, primary keys - together with a neat little
relationship diagram that outlines the foreign key references between the
tables.
In order to accomplish this Herculean task, phpMyAdmin leverages
off the information provided when creating the foreign key relationships
(discussed earlier). Table and column comments entered by the table designers
are also included in the dictionary, thus making it a good reference document
for all developers working with the database.
The best way to understand
what a database dictionary is, is with an example. Select a database - I'll use
the
accounts database created earlier - and use the
Edit PDF
Pages link at the bottom of the page to obtain
this
screen.
Specify a name for the PDF document, (say, “Accounting
Database") and select the
Automatic layout option. After clicking
Go, the same page will reload and display some supplementary information,
as
shown here.
You can now select the tables to be included in the
dictionary, together with some ancillary settings related to the formatting of
the relationship diagram. You can either change the locations of the tables in
the final diagram using X and Y coordinates, or use the
Toggle
Scratchboard button to open up a WYSIWYG editor that allows you to place
each table exactly where you want it (note that this feature needs Internet
Explorer 6.0 or equivalent).
Example.
You can also adjust various formatting options for the PDF file,
using
the options available.
- Show grid - turn the grid on or off in the relationships diagram
- Show color - turn colors on or off in the relationships diagram
- Show dimension of tables - turn the display of the table dimensions
on or off in the relationships diagram
- Display all Tables with same width? - specifies whether the width of
the table image be the same for all tables?
- Data Dictionary - specifies whether table descriptions should be
included
- Data Dictionary Format - specifies whether the dictionary should be
formatted as landscape or portrait
- Paper size - specifies the paper size to be used for creating the
document
All done? Click
Go, and you should get a PDF file
which
contains this.