Databases Reference
In-Depth Information
After the creation, the left panel shows us the special
pma_
tables along with our
normal tables:
The last step is to adjust all the parameters in
config.inc.php
that relate to
relational features. Except for the database name in the
pmadb
parameter, we use the
default values mentioned in the comments inside the file:
$cfg['Servers'][$i]['pmadb'] = 'marc_book';
Defining Relations with the Relation View
After the installation of the linked-tables infrastructure, there are now more options
available in the Database view and the Table view. We will now examine a new link
in the Table view:
Relation view
. This view is used to:
•
•
Define the relations of the current table to other tables
Choose the display field
Because our goal here is to create a relation between the
book
table (which contains
the author ID) and the
author
table (which describes each author by an ID), we start
on the Table view for the
book
table and click the
Relation view
link.
Search WWH ::
Custom Search