Channelscan channel table
From MythTV Official Wiki
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) |