Difference between revisions of "Channel table"

From MythTV Official Wiki
Jump to: navigation, search
(Added to Category:DB Table)
Line 1: Line 1:
Each row in this table describes one tunable channel, where a channel is a frequency (and possibly a subchannel id for satellite and digital cable) -- if you get CNN from two [[Video Source]]s, it will appear twice in this table (though, as long as the callsigns are the same, ScheduledRecordings will be moved from one tuner to another, priorities permitting).
+
Each row in this table describes one tunable channel, where a channel is a unique combination of hardware settings such as frequency, modulation and subchannel id (serviceid) for satellite and digital cable -- if you get CNN from two [[Video Source]]s, it will appear twice in this table (though, as long as the callsigns are the same, ScheduledRecordings will be moved from one tuner to another, priorities permitting). The sourceid is used to find a tuner which can tune the channel. The mplexid field is used to point to information in the dtv_multiplex table which will be used to tune the tuner, and the serviceid is used to select a particular digital stream from the tuned feed.
 +
 
 +
Amended on April 5, 2006 to reflect the present schema (adding new fields)
 +
 
 +
<pre>
 +
mysql> describe channel;
 +
+---------------+-----------------------+------+-----+---------+-------+
 +
| Field        | Type                  | Null | Key | Default | Extra |
 +
+---------------+-----------------------+------+-----+---------+-------+
 +
| chanid        | int(10) unsigned      |      | PRI | 0      |      |
 +
| channum      | varchar(10)          |      | MUL |        |      |
 +
| freqid        | varchar(10)          | YES  |    | NULL    |      |
 +
| sourceid      | int(10) unsigned      | YES  |    | NULL    |      |
 +
| callsign      | varchar(20)          |      |    |        |      |
 +
| name          | varchar(64)          |      |    |        |      |
 +
| icon          | varchar(255)          |      |    | none    |      |
 +
| finetune      | int(11)              | YES  |    | NULL    |      |
 +
| videofilters  | varchar(255)          |      |    |        |      |
 +
| xmltvid      | varchar(64)          |      |    |        |      |
 +
| recpriority  | int(10)              |      |    | 0      |      |
 +
| contrast      | int(11)              | YES  |    | 32768  |      |
 +
| brightness    | int(11)              | YES  |    | 32768  |      |
 +
| colour        | int(11)              | YES  |    | 32768  |      |
 +
| hue          | int(11)              | YES  |    | 32768  |      |
 +
| tvformat      | varchar(10)          |      |    | Default |      |
 +
| commfree      | tinyint(4)            |      |    | 0      |      |
 +
| visible      | tinyint(1)            |      |    | 1      |      |
 +
| outputfilters | varchar(255)          |      |    |        |      |
 +
| 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.00 sec)
 +
 
 +
</pre>
 +
 
 +
R. G. Newbury [[User:65.94.232.153|65.94.232.153]] 15:56, 5 April 2006 (UTC)
  
{| border="1" cellpadding="2" style="background:#D6DFE7"
 
! Field !! Type !! NULL !! Default
 
|-
 
| chanid || int(10) || No || 0
 
|-
 
| channum || varchar(5) || No ||
 
|-
 
| freqid || varchar(5) || No ||
 
|-
 
| sourceid || int(10) || Yes || NULL
 
|-
 
| callsign || varchar(20) || No ||
 
|-
 
|name||varchar(64)||No||
 
|-
 
|icon||varchar(255)||No||none
 
|-
 
|finetune||int(11)||Yes||NULL
 
|-
 
|videofilters||varchar(255)||No||
 
|-
 
|xmltvid||varchar(64)||No||
 
|-
 
|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||
 
|}
 
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 15:56, 5 April 2006

Each row in this table describes one tunable channel, where a channel is a unique combination of hardware settings such as frequency, modulation and subchannel id (serviceid) for satellite and digital cable -- if you get CNN from two Video Sources, it will appear twice in this table (though, as long as the callsigns are the same, ScheduledRecordings will be moved from one tuner to another, priorities permitting). The sourceid is used to find a tuner which can tune the channel. The mplexid field is used to point to information in the dtv_multiplex table which will be used to tune the tuner, and the serviceid is used to select a particular digital stream from the tuned feed.

Amended on April 5, 2006 to reflect the present schema (adding new fields)

mysql> describe channel;
+---------------+-----------------------+------+-----+---------+-------+
| Field         | Type                  | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------+-------+
| chanid        | int(10) unsigned      |      | PRI | 0       |       |
| channum       | varchar(10)           |      | MUL |         |       |
| freqid        | varchar(10)           | YES  |     | NULL    |       |
| sourceid      | int(10) unsigned      | YES  |     | NULL    |       |
| callsign      | varchar(20)           |      |     |         |       |
| name          | varchar(64)           |      |     |         |       |
| icon          | varchar(255)          |      |     | none    |       |
| finetune      | int(11)               | YES  |     | NULL    |       |
| videofilters  | varchar(255)          |      |     |         |       |
| xmltvid       | varchar(64)           |      |     |         |       |
| recpriority   | int(10)               |      |     | 0       |       |
| contrast      | int(11)               | YES  |     | 32768   |       |
| brightness    | int(11)               | YES  |     | 32768   |       |
| colour        | int(11)               | YES  |     | 32768   |       |
| hue           | int(11)               | YES  |     | 32768   |       |
| tvformat      | varchar(10)           |      |     | Default |       |
| commfree      | tinyint(4)            |      |     | 0       |       |
| visible       | tinyint(1)            |      |     | 1       |       |
| outputfilters | varchar(255)          |      |     |         |       |
| 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.00 sec)

R. G. Newbury 65.94.232.153 15:56, 5 April 2006 (UTC)