show tables;
+----------------------+
| Tables_in_sfa_db     |
+----------------------+
| category             |
| catlink              |
| config_options       |
| config_version       |
| event                |
| event_topic          |
| event_type           |
| feature              |
| feature_dossier      |
| feature_photo        |
| feature_photo_link   |
| feature_sequence     |
| language             |
| location             |
| user                 |
| validation           |
| webcast              |
| webcast_comment      |
| webcast_comment_body |
| webcast_media        |
| webcast_text         |
+----------------------+



mysql> explain category;
+-------------------------------+---------------------------------------+------+-----+-------------------+----------------+
| Field                         | Type                                  | Null | Key | Default           | Extra          |
+-------------------------------+---------------------------------------+------+-----+-------------------+----------------+
| name                          | varchar(200)                          | YES  |     | NULL              |                |
| order_num                     | smallint(6) unsigned                  |      |     | 0                 |                |
| category_id                   | smallint(5) unsigned                  |      | PRI | NULL              | auto_increment |
| template_name                 | varchar(200)                          |      |     | 0                 |                |
| creation_date                 | timestamp                             | YES  |     | CURRENT_TIMESTAMP |                |
| creator_id                    | smallint(5) unsigned                  |      |     | 0                 |                |
| default_feature_template_name | varchar(200)                          |      |     | 0                 |                |
| shortname                     | varchar(20)                           |      | UNI |                   |                |
| summarylength                 | smallint(5) unsigned                  |      |     | 10                |                |
| parentid                      | smallint(6) unsigned                  | YES  |     | NULL              |                |
| newswire                      | enum('n','s','a','f')                 |      |     | n                 |                |
| center                        | enum('t','f')                         |      |     | t                 |                |
| catclass                      | enum('m','t','l','h','i','e','p','o') |      |     | t                 |                |
| description                   | text                                  | YES  |     | NULL              |                |
+-------------------------------+---------------------------------------+------+-----+-------------------+----------------+

mysql> explain catlink;
+-------+----------------------+------+-----+---------+-------+
| Field | Type                 | Null | Key | Default | Extra |
+-------+----------------------+------+-----+---------+-------+
| catid | smallint(6) unsigned |      |     | 0       |       |
| id    | int(11) unsigned     |      |     | 0       |       |
+-------+----------------------+------+-----+---------+-------+

mysql> explain config_version;
+-------+-----------------------+------+-----+---------------------+----------------+
| Field | Type                  | Null | Key | Default             | Extra          |
+-------+-----------------------+------+-----+---------------------+----------------+
| id    | mediumint(8) unsigned |      | PRI | NULL                | auto_increment |
| date  | datetime              |      |     | 0000-00-00 00:00:00 |                |
+-------+-----------------------+------+-----+---------------------+----------------+


mysql> explain event;
+---------------------+---------------------+------+-----+---------+----------------+
| Field               | Type                | Null | Key | Default | Extra          |
+---------------------+---------------------+------+-----+---------+----------------+
| event_id            | int(11)             |      | PRI | NULL    | auto_increment |
| start_date          | datetime            | YES  |     | NULL    |                |
| end_date            | datetime            | YES  |     | NULL    |                |
| duration            | int(11)             | YES  |     | NULL    |                |
| location_id         | int(11)             | YES  |     | NULL    |                |
| location_other      | varchar(50)         | YES  |     | NULL    |                |
| event_topic_id      | int(11)             | YES  |     | NULL    |                |
| event_topic_other   | varchar(50)         | YES  |     | NULL    |                |
| event_type_id       | int(11)             | YES  |     | NULL    |                |
| title               | varchar(50)         | YES  |     | NULL    |                |
| location_details    | text                | YES  |     | NULL    |                |
| contact_name        | varchar(50)         | YES  |     | NULL    |                |
| contact_phone       | varchar(50)         | YES  |     | NULL    |                |
| contact_email       | varchar(50)         | YES  |     | NULL    |                |
| confirmation_number | int(11)             | YES  |     | NULL    |                |
| description         | text                | YES  |     | NULL    |                |
| event_type_other    | varchar(50)         | YES  |     | NULL    |                |
| linked_file         | varchar(160)        | YES  |     | NULL    |                |
| mime_type           | varchar(50)         | YES  |     | NULL    |                |
| event               | varchar(5)          | YES  |     | NULL    |                |
| language_id         | tinyint(3) unsigned | YES  |     | NULL    |                |
| artmime             | enum('h','t')       | YES  |     | NULL    |                |
+---------------------+---------------------+------+-----+---------+----------------+