mysql> describe dtv_multiplex;
+-------------------+-------------+------+-----+-------------------+----------------+
| Field             | Type        | Null | Key | Default           | Extra          |
+-------------------+-------------+------+-----+-------------------+----------------+
| mplexid           | smallint(6) | NO   | PRI | NULL              | auto_increment |
| sourceid          | smallint(6) | YES  |     | NULL              |                |
| transportid       | int(11)     | YES  |     | NULL              |                |
| networkid         | int(11)     | YES  |     | NULL              |                |
| frequency         | int(11)     | YES  |     | NULL              |                |
| inversion         | char(1)     | YES  |     | a                 |                |
| symbolrate        | int(11)     | YES  |     | NULL              |                |
| fec               | varchar(10) | YES  |     | auto              |                |
| polarity          | char(1)     | YES  |     | NULL              |                |
| modulation        | varchar(10) | YES  |     | auto              |                |
| bandwidth         | char(1)     | YES  |     | a                 |                |
| lp_code_rate      | varchar(10) | YES  |     | auto              |                |
| transmission_mode | char(1)     | YES  |     | a                 |                |
| guard_interval    | varchar(10) | YES  |     | auto              |                |
| visible           | smallint(1) | NO   |     | 0                 |                |
| constellation     | varchar(10) | YES  |     | auto              |                |
| hierarchy         | varchar(10) | YES  |     | auto              |                |
| hp_code_rate      | varchar(10) | YES  |     | auto              |                |
| sistandard        | varchar(10) | YES  |     | dvb               |                |
| serviceversion    | smallint(6) | YES  |     | 33                |                |
| updatetimestamp   | timestamp   | YES  |     | CURRENT_TIMESTAMP |                |
+-------------------+-------------+------+-----+-------------------+----------------+
mysql> describe channel;
+---------------+-----------------------+------+-----+---------+-------+
| Field         | Type                  | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------+-------+
| chanid        | int(10) unsigned      | NO   | PRI | 0       |       |
| channum       | varchar(10)           | NO   | MUL | NULL    |       |
| freqid        | varchar(10)           | YES  |     | NULL    |       |
| sourceid      | int(10) unsigned      | YES  |     | NULL    |       |
| callsign      | varchar(20)           | NO   |     | NULL    |       |
| name          | varchar(64)           | NO   |     | NULL    |       |
| icon          | varchar(255)          | NO   |     | none    |       |
| finetune      | int(11)               | YES  |     | NULL    |       |
| videofilters  | varchar(255)          | NO   |     | NULL    |       |
| xmltvid       | varchar(64)           | NO   |     | NULL    |       |
| recpriority   | int(10)               | NO   |     | 0       |       |
| contrast      | int(11)               | YES  |     | 32768   |       |
| brightness    | int(11)               | YES  |     | 32768   |       |
| colour        | int(11)               | YES  |     | 32768   |       |
| hue           | int(11)               | YES  |     | 32768   |       |
| tvformat      | varchar(10)           | NO   |     | Default |       |
| commfree      | tinyint(4)            | NO   |     | 0       |       |
| visible       | tinyint(1)            | NO   |     | 1       |       |
| outputfilters | varchar(255)          | NO   |     | NULL    |       |
| useonairguide | tinyint(1)            | YES  |     | 0       |       |
| mplexid       | smallint(6)           | YES  |     | NULL    |       |
| serviceid     | mediumint(8) unsigned | YES  |     | NULL    |       |
| atscsrcid     | int(11)               | YES  |     | NULL    |       |
+---------------+-----------------------+------+-----+---------+-------+
23 rows in set (0.01 sec)