mysql> describe missionaries;
+----------------+---------------+------+-----+---------------------+----------------+
| Field          | Type          | Null | Key | Default             | Extra          |
+----------------+---------------+------+-----+---------------------+----------------+
| missionary_id  | int(11)       |      | PRI | NULL                | auto_increment |
| username       | varchar(20)   |      |     |                     |                |
| password       | varchar(30)   |      |     |                     |                |
| last_name      | varchar(50)   |      |     |                     |                |
| first_name     | varchar(50)   |      |     |                     |                |
| middle_name    | varchar(50)   |      |     |                     |                |
| email          | varchar(50)   |      |     |                     |                |
| website        | varchar(150)  |      |     |                     |                |
| address        | varchar(100)  |      |     |                     |                |
| city           | varchar(100)  |      |     |                     |                |
| state          | varchar(50)   |      |     |                     |                |
| country        | varchar(50)   |      |     |                     |                |
| zip            | varchar(15)   |      |     |                     |                |
| home_ward      | varchar(50)   |      |     |                     |                |
| home_stake     | varchar(50)   |      |     |                     |                |
| phone          | varchar(50)   |      |     |                     |                |
| active         | enum('Y','N') |      |     | Y                   |                |
| admin          | enum('Y','N') |      |     | N                   |                |
| submitter_info | varchar(100)  |      |     |                     |                |
| last_updated   | datetime      |      |     | 0000-00-00 00:00:00 |                |
| date_started   | datetime      |      |     | 0000-00-00 00:00:00 |                |
+----------------+---------------+------+-----+---------------------+----------------+
21 rows in set (0.00 sec)


mysql> describe missions;
+----------------+---------------+------+-----+---------------------+----------------+
| Field          | Type          | Null | Key | Default             | Extra          |
+----------------+---------------+------+-----+---------------------+----------------+
| mission_id     | int(11)       |      | PRI | NULL                | auto_increment |
| mission        | varchar(55)   |      |     |                     |                |
| area           | varchar(50)   |      |     |                     |                |
| country        | varchar(50)   |      |     |                     |                |
| location       | varchar(50)   |      |     |                     |                |
| city           | varchar(50)   |      |     |                     |                |
| address        | varchar(150)  |      |     |                     |                |
| email          | varchar(50)   |      |     |                     |                |
| phone          | varchar(50)   |      |     |                     |                |
| fax            | varchar(50)   |      |     |                     |                |
| active         | enum('Y','N') |      |     | Y                   |                |
| last_updated   | datetime      |      |     | 0000-00-00 00:00:00 |                |
| date_submitted | datetime      |      |     | 0000-00-00 00:00:00 |                |
+----------------+---------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)


mysql> describe mission_links;
+--------------------+--------------+------+-----+---------------------+----------------+
| Field              | Type         | Null | Key | Default             | Extra          |
+--------------------+--------------+------+-----+---------------------+----------------+
| mission_link_id    | int(11)      |      | PRI | NULL                | auto_increment |
| missionary_id      | int(11)      |      |     | 0                   |                |
| mission_id         | int(11)      |      |     | 0                   |                |
| start_date         | datetime     |      |     | 0000-00-00 00:00:00 |                |
| end_date           | datetime     |      |     | 0000-00-00 00:00:00 |                |
| mission_presidents | varchar(100) |      |     |                     |                |
| comment            | text         |      |     |                     |                |
| last_updated       | datetime     |      |     | 0000-00-00 00:00:00 |                |
| date_submitted     | datetime     |      |     | 0000-00-00 00:00:00 |                |
+--------------------+--------------+------+-----+---------------------+----------------+
9 rows in set (0.00 sec)