Channelscan channel table

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)