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