Prev | Current Page 174 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"


The Relational System
[ 188 ]
Defining the Display Field
On the workspace, we see in the author table that the name column has a special
background color; this indicates that this column serves as the display field. We can
simply click the Choose field to display top icon and drag the short message
Choose field to display onto another column, for example the phone column. This
changes the display field to this column. If we had dragged the message to an
existing display field column, we would have removed this column as a display field
for the table.
Exporting for PDF Schema
In Chapter 15 (System Documentation), we'll see how to produce a PDF schema of a
subset of our database. If we have used the techniques explained in this latter chapter
to create a PDF schema, we can import the coordinates 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.
Benefits of the Defined Relations
In this section, we will look at the benefits that we can currently test; other benefits
will be described in Chapter 13 (The Multi-Table Query Generator) and Chapter 15
(System Documentation). Some other benefits of the linked-tables infrastructure will
appear in Chapter 14 (Bookmarks) and Chapter 16 (MIME-Based Transformations).


Pages:
162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186