Databases Reference
In-Depth Information
Defining the display column
On the workspace, the
name
column in
author
table has a special background color.
This indicates that this column serves as the display column. We can simply click
on the
Choose column to display
icon, and drag the short message
Choose column
to display
onto another column—for example, the
phone
column. This changes the
display column to this column. If we were to drag the message to an existing display
column, we would have removed the definition of this column as the display column
for the table.
Exporting for PDF schema
In Chapter 15, we will see how to produce a PDF schema for a subset of our
database. 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
icon is available for that purpose.
Benefiting from 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
Chapter 12
and
Chapter 15
.
Additional benefits of the phpMyAdmin configuration storage will appear in
Chapter 14
,
Chapter 16
, and
Chapter 18
.
These benefits are available for both internal and foreign key relations.
Foreign key information
Let us browse the
book
table. We see that the values of the related key (
author_id
)
are now links. Moving the cursor over any
author_id
value reveals the author's name
(as defined by the display column of the
author
table).
Search WWH ::
Custom Search