This can be done from
the Structure sub-page for a database by selecting the tables we want and choosing
Print view from the drop-down menu:
The Table Print View
There is also a Print view link on the Structure sub-page for each table. Clicking this,
produces information about columns, indexes, space usage, and row statistics:
Chapter 15
[ 231 ]
The Data Dictionary
A more complete report about tables and columns for a database is available from
the Structure sub-page of the Database view. We just have to click Data dictionary to
get this report, which is partially shown here:
The MIME column is empty until we add MIME-related information to some
columns. (This is explained in Chapter 16.)
Relational Schema in PDF
In Chapter 11, we defined relations between the book and author tables. These
relations were used for various foreign key functions (for example, getting a list of
possible values in Insert mode). Now, we will examine a feature that enables us to
generate a custom-made relational schema for our tables in a popular format: PDF.
This feature requires that the linked-tables infrastructure be properly
installed and configured, as explained in Chapter 11.
Adding a Third Table to Our Model
To get a more complete schema, we will now add another table, country, to our
database. Here is its export file:
CREATE TABLE IF NOT EXISTS `country` (
`code` char(2) NOT NULL,
`description` varchar(50) NOT NULL,
System Documentation
[ 232 ]
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `country` (`code`, `description`) VALUES
('ca', 'Canada'),
('uk', 'United Kingdom');
We will link this table to the author table.
Pages:
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214