Channelscan channel table

From MythTV Official Wiki
Revision as of 19:50, 22 February 2014 by Pmhahn (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Important.png Note: The correct title of this article is channelscan_channel table. It appears incorrectly here due to technical restrictions.

The channelscan_channel table contains the channels of previous channel scans. The data is kept to simplify re-scanning for channels, if the capture card is removed and re-added, or new cards for the same source are added.

This table provides the data to fill the channel table.

Table Description

Field name Type Null Key Default Extras Description
transportid int(6) unsigned NULL REFERENCES channelscan_dtv_multiplex(transportid) for DVB (and ATSC?): the corresponding data for the multiplex
scanid int(3) unsigned NULL REFERENCES channelscan(scanid) the scan, on which this channel was found
mplex_id smallint(6) NULL REFERENCES channelscan_dtv_multiplex(mplexid) the ID of the multiplex, this channel is part of
source_id int(3) unsigned NULL REFERENCES videosource(sourceid) the program listing provider used for this channel
channel_id int(3) unsigned 0
callsign varchar(20)
service_name varchar(64)
chan_num varchar(10) recommended channel number
service_id mediumint(8) unsigned 0
atsc_major_channel int(4) unsigned 0
atsc_minor_channel int(4) unsigned 0
use_on_air_guide tinyint(1) 0 channel provides EIT?
hidden tinyint(1) 0
hidden_in_guide tinyint(1) 0
freqid varchar(10) frequency for analog channels
icon varchar(255) URL for channel icon
tvformat varchar(10) Default
xmltvid varchar(64)
pat_tsid int(5) unsigned 0 Transport-Stream-ID for the PAT
vct_tsid int(5) unsigned 0 Transport-Stream-ID for the VCT?
vct_chan_tsid int(5) unsigned 0 Transport-Stream-ID for the VCT?
sdt_tsid int(5) unsigned 0 Transport-Stream-ID for the SDT
orig_netid int(5) unsigned 0 original network ID before overwrite?
netid int(5) unsigned 0 possibly overwritten network ID?
si_standard varchar(10) NULL dvb, ...
in_channels_conf tinyint(1) unsigned 0
in_pat tinyint(1) unsigned 0 channel is listed in PAT
in_pmt tinyint(1) unsigned 0 channel is listed in PMT
in_vct tinyint(1) unsigned 0 channel is listed in VCT
in_nit tinyint(1) unsigned 0 channel is listed in NIT
in_sdt tinyint(1) unsigned 0 channel is listed in SDT
is_encrypted tinyint(1) unsigned 0 channel is scrambled
is_data_service tinyint(1) unsigned 0 channel is used for data, e.g. firmware updates
is_audio_service tinyint(1) unsigned 0 channel is audio-only?
is_opencable tinyint(1) unsigned 0
could_be_opencable tinyint(1) unsigned 0
decryption_status smallint(2) unsigned 0
default_authority varchar(32)

Fields

Example Entries