Someone
public text v1 · immutablemysql> DESCRIBE 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 | |
| listingsource | int(11) | | | 0 | |
| first | tinyint(1) | | | 0 | |
| last | tinyint(1) | | | 0 | |
+-------------------------+------------------+------+-----+--------------------- +-------+
29 rows in set (0.01 sec)
mysql>