Database Reference
In-Depth Information
The MIME column is empty until we add MIME-related information to some
columns (explained in Chapter 16).
Relational schema in PDF
In Chapter 11, we defined relations between the book and the author tables. These
relations were used for various foreign key functions (for example, getting a list of
possible values in Insert mode). We will now examine a feature that enables us to
generate a custom-made relational schema for our tables in the popular PDF format.
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,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `country` (`code`, `description`) VALUES
('ca', 'Canada'),
('uk', 'United Kingdom');
We will now link this table to the author table. First, in the Relation view for the
country table, we specify the field that we want to display.
 
Search WWH ::




Custom Search