Difference between revisions of "Channel table"
m (→Channel examples by type) |
Dantheperson (talk | contribs) (explain use of freqid column for DVB-T) |
||
(One intermediate revision by the same user not shown) | |||
Line 161: | Line 161: | ||
| channum || colspan="4"|1 (channel on the remote) | | channum || colspan="4"|1 (channel on the remote) | ||
|- | |- | ||
− | | freqid || E6 || | + | | freqid || E6 || [http://igorfuna.com/dvb-t/digital/tv-channel-frequencies DVB Frequency Channel] || 74 || NULL |
|- | |- | ||
| sourceid || colspan="4"|1 (from [[Videosource_table]]) | | sourceid || colspan="4"|1 (from [[Videosource_table]]) |
Latest revision as of 10:53, 14 June 2015
Note: The correct title of this article is channel table. It appears incorrectly here due to technical restrictions.
Each row in the channel 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, scheduled recordings 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.
Table Description
Field name | Type | Null | Key | Default | Extras | Schema-Version |
---|---|---|---|---|---|---|
chanid | int(10) unsigned | PRI | 0 | |||
channum | varchar(10) | MUL | ||||
freqid | varchar(10) | YES | NULL | |||
sourceid | int(10) unsigned | YES | NULL | REFERENCES videosource(sourceid) | ||
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 | ||||
visible | tinyint(1) | 1 | ||||
outputfilters | varchar(255) | |||||
useonairguide | tinyint(1) | YES | 0 | |||
mplexid | smallint(6) | YES | NULL | REFERENCES dtv_multiplex(mplexid) | ||
serviceid | mediumint(8) unsigned | YES | NULL | |||
|
int(11) | YES | NULL | -??? | ||
atsc_major_chan | int(10) unsigned | 0 | + | |||
atsc_minor_chan | int(10) unsigned | 0 | + | |||
last_record | datetime | +1303 | ||||
default_authority | varchar(32) | +??? | ||||
commmethod | int(11) | -1 | ||||
iptvid | smallint(6) unsigned | YES | NULL | REFERENCES iptv_channel(iptvid) | +1301 |
Example Entries
This is a channel record for an ATSC digital cable stream, which is nominally on channel 74, but is listed by the cable supplier as channel 406. The mplexid is 110 and the dtv_multiplex table defines the modulation method to be used to decode the stream(in this case QAM_256). The actual stream is denoted by the serviceid of 52. Although the channum of 406 is the cable co's. reference (and also used by Schedules Direct), xmltvid is the unique reference key, as this channel may be given a different number elsewhere on the same cable co. system. The tvformat must be ATSC for digital cable or OTA. Note that for cable channels the channel number is a whole number, while OTA uses the 18.2 style.
chanid: 2743 channum: 406 freqid: 74 sourceid: 2 callsign: RSP name: Sportsnet Pacific icon: finetune: NULL videofilters: xmltvid: 18801 recpriority: 0 contrast: 32768 brightness: 32768 colour: 32768 hue: 32768 tvformat: atsc commmethod: -1 visible: 1 outputfilters: useonairguide: 0 mplexid: 110 serviceid: 52 atscsrcid: NULL tmoffset: 0 atsc_major_chan: 0 atsc_minor_chan: 0
The following is an entry for a DVB-T source:
chanid: 1504 channum: 504 freqid: sourceid: 1 callsign: ABC TV name: ABC TV icon: none finetune: 0 videofilters: xmltvid: ABC-SA recpriority: 0 contrast: 32768 brightness: 32768 colour: 32768 hue: 32768 tvformat: Default commmethod: -1 visible: 0 outputfilters: useonairguide: 0 mplexid: 12 serviceid: 595 atscsrcid: NULL tmoffset: 0 atsc_major_chan: 0 atsc_minor_chan: 0
This is an entry for an analogue source for the same channel. Here the freqid column describes the frequency (in kHz).
chanid: 3001 channum: 2 freqid: 64250 sourceid: 1 callsign: ABC-S name: ABC-SA icon: finetune: 0 videofilters: xmltvid: ABC-SA recpriority: 0 contrast: 32768 brightness: 32768 colour: 32768 hue: 32768 tvformat: Default commmethod: -1 visible: 0 outputfilters: useonairguide: 0 mplexid: NULL serviceid: 0 atscsrcid: NULL tmoffset: 0 atsc_major_chan: 0 atsc_minor_chan: 0
Channel examples by type
Type | Analog | DVB-C/S/T | ATSC | IPTV |
---|---|---|---|---|
chanid | 1 (row number) | |||
channum | 1 (channel on the remote) | |||
freqid | E6 | DVB Frequency Channel | 74 | NULL |
sourceid | 1 (from Videosource_table) | |||
callsign | EXAMPLE | |||
name | The Example Channel | |||
icon | example.jpg (relative to ChannelIcons-Storagegroup_table) | |||
finetune | 0 | NULL | NULL | NULL |
videofilters | ? | |||
xmltvid | tv.example.org | |||
recpriority | 0 (no priority boost) | |||
contrast, brightness, colour, hue | 32768 (±0) | - | - | - |
tvformat | Default | ? | atsc | ? |
visible | 1 (show in guide) | |||
outputfilters | ? | |||
useonairguide | 0 (use only EPG data) | |||
mplexid | NULL | 1 (from Dtv_multiplex_table) | 110 | NULL |
serviceid | NULL | 12003 (the Program ID on the multiplex) | 52 | NULL |
tmoffset | 0 (no time adjustment needed) | |||
atsc_major_chan | NULL | NULL | ? | NULL |
atsc_minor_chan | NULL | NULL | ? | NULL |
last_record | 2014-03-08 12:31:15 | |||
default_authority | ? | |||
commmethod | -1 (use default) | |||
iptvid | NULL | NULL | NULL | 1 (from Iptv_channel_table) |