Channel table

From MythTV Official Wiki
Revision as of 21:29, 4 April 2012 by Boehmi (Talk | contribs)

Jump to: navigation, search

Important.png 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
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
commmethod tinyint(4) -1
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

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

See also