Database Reference
In-Depth Information
Exporting for PDF schema
In Chapter 15, we'll see how to produce a PDF schema for a subset of our database.
We can import the co-ordinates of tables from such a schema into the Designer's
workspace, and conversely export them to the PDF schema. The
Import/export
coordinates
top icon is available for that purpose.
Beneits of the defined relations
In this section, we will look at the benefits of the defined relations that we can
currently test. Other benefits will be described in chapters 13 and 15. Additional
benefits of the linked-tables infrastructure will appear in chapters 14 and 16.
These benefits are available for both internal and foreign key relations.
Foreign key information
Let's browse the
book
table by entering the
Search
subpage and choosing to display
the first four columns. We see that the related key (
author_id
) is now a link. Moving
the mouse pointer over any
author_id
value reveals the author's name (as defined by
the display field of the
author
table).
Clicking on the
author_id
brings us to the relevant table—
author
—for this
specific author:
Search WWH ::
Custom Search