Difference between revisions of "Channel table"

From MythTV Official Wiki
Jump to: navigation, search
m (Channel examples by type)
(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 || NULL || 74 || NULL
+
| 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

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 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
atscsrcid 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)

See also