Understanding the Program Table Structure

The tables are based on the person and phone number tables used in the first chapter. Here’s the structure of the person table and the SQL to create it:

+------------+-------------+------+-----+---------+----------------+ | Field      | Type        | Null | Key | Default | Extra          | +------------+-------------+------+-----+---------+----------------+ | id         | int(11)     |      | PRI | NULL    | auto_increment | | first_name | varchar(30) |      |     |         |                | | last_name  | varchar(30) | YES  |     | NULL    |                | | greeting   | varchar(30) | YES  |     | NULL    |                | +------------+-------------+------+-----+---------+----------------+ CREATE TABLE person (   id int(11) NOT NULL auto_increment,   first_name varchar(30) NOT NULL default ‘’,   last_name varchar(30) default NULL,   greeting varchar(30) default NULL,   PRIMARY KEY  (id) ) TYPE=MyISAM;

The phone table uses the person.id and the phone_type as the primary key:

+--------------+-------------+------+-----+---------+-------+ | Field        | Type        | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | id           | int(11)     |      | PRI | 0       |       | | phone_type   | varchar(10) |      | PRI |         |       | | phone_number | varchar(30) |      |     |         |       | | note         | varchar(30) | YES  |     | NULL    |       | +--------------+-------------+------+-----+---------+-------+ CREATE TABLE phone (   id int(11) NOT NULL default ‘0’,   phone_type varchar(10) NOT NULL default ‘’,   phone_number varchar(30) NOT NULL default ‘’,   note varchar(30) default NULL,   PRIMARY KEY  (id, phone_type) ) TYPE=MyISAM;