Difference between revisions of "Channelscan channel table"
From MythTV Official Wiki
(channelscan_channel) |
m (→Table Description) |
||
| Line 10: | Line 10: | ||
! Field name !! Type !! Null !! Key !! Default !! Extras !! Description | ! Field name !! Type !! Null !! Key !! Default !! Extras !! Description | ||
|- | |- | ||
| − | || transportid || int(6) unsigned || || || NULL || | + | || transportid || int(6) unsigned || || || NULL || REFERENCES [[channelscan_dtv_multiplex table|channelscan_dtv_multiplex]](transportid) || for DVB (and ATSC?): the corresponding data for the multiplex |
|- | |- | ||
|| scanid || int(3) unsigned || || || NULL || REFERENCES [[channelscan table|channelscan]](scanid) || the scan, on which this channel was found | || scanid || int(3) unsigned || || || NULL || REFERENCES [[channelscan table|channelscan]](scanid) || the scan, on which this channel was found | ||
| Line 32: | Line 32: | ||
|| atsc_minor_channel || int(4) unsigned || || || 0 || | || atsc_minor_channel || int(4) unsigned || || || 0 || | ||
|- | |- | ||
| − | || use_on_air_guide || tinyint(1) || || || 0 || channel provides [[EIT]]? | + | || use_on_air_guide || tinyint(1) || || || 0 || || channel provides [[EIT]]? |
|- | |- | ||
|| hidden || tinyint(1) || || || 0 || | || hidden || tinyint(1) || || || 0 || | ||
Latest revision as of 19:50, 22 February 2014
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) |
