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