Database Reference
In-Depth Information
We then add a
country_code
column (same type and size as that of the
code
column
of the
country
table) to the
author
table, and in the
Relation view
, we link it to the
newly- created
country
table. We must remember to click
Save
for the relation to
be recorded. For this example, it is not necessary to enter any country data for an
author, as we are interested only in the relational schema.
Editing PDF pages
Each relational schema is called a
page
. We can create or edit a page by clicking
Edit
PDF pages
in the
Operations
subpage of the Database view.
Page planning
In phpMyAdmin version 3.1.x, a relational schema cannot span multiple databases.
But even working with just one database, the number of tables might be large.
Representing the various table relations in a clear way could be a challenge. This is
why we may use many pages, each showing some tables and their relations.
We must also take into account the dimensions of the final output. Printing
on letter-size paper gives us less space to show all our tables and still have a
legible schema.
Creating a new page
As there are no existing pages, we need to create one. Again, as our most important
table is
book
, we will also name this page,
book
.
Search WWH ::
Custom Search