mysql> DESCRIBE mythconverg.program;
+-------------------------+------------------+------+-----+---------------------+-------+
| Field                   | Type             | Null | Key | Default             | Extra |
+-------------------------+------------------+------+-----+---------------------+-------+
| chanid                  | int(10) unsigned |      | PRI | 0                   |       |
| starttime               | datetime         |      | PRI | 0000-00-00 00:00:00 |       |
| endtime                 | datetime         |      | MUL | 0000-00-00 00:00:00 |       |
| title                   | varchar(128)     |      | MUL |                     |       |
| subtitle                | varchar(128)     |      |     |                     |       |
| description             | text             |      |     |                     |       |
| category                | varchar(64)      |      |     |                     |       |
| category_type           | varchar(64)      |      |     |                     |       |
| airdate                 | year(4)          |      |     | 0000                |       |
| stars                   | float            |      |     | 0                   |       |
| previouslyshown         | tinyint(4)       |      |     | 0                   |       |
| title_pronounce         | varchar(128)     |      | MUL |                     |       |
| stereo                  | tinyint(1)       |      |     | 0                   |       |
| subtitled               | tinyint(1)       |      |     | 0                   |       |
| hdtv                    | tinyint(1)       |      |     | 0                   |       |
| closecaptioned          | tinyint(1)       |      |     | 0                   |       |
| partnumber              | int(11)          |      |     | 0                   |       |
| parttotal               | int(11)          |      |     | 0                   |       |
| seriesid                | varchar(12)      |      | MUL |                     |       |
| originalairdate         | date             | YES  |     | NULL                |       |
| showtype                | varchar(30)      |      |     |                     |       |
| colorcode               | varchar(20)      |      |     |                     |       |
| syndicatedepisodenumber | varchar(20)      |      |     |                     |       |
| programid               | varchar(20)      |      | MUL |                     |       |
| manualid                | int(10) unsigned |      | PRI | 0                   |       |
| generic                 | tinyint(1)       | YES  |     | 0                   |       |
+-------------------------+------------------+------+-----+---------------------+-------+
26 rows in set (0.00 sec)