Difference between revisions of "Callsignnetworkmap table"
From MythTV Official Wiki
(FK) |
|||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{Wrongtitle|callsignnetworkmap table}} | |
| − | + | The '''callsignnetworkmap table''' contains the call-signs of the TV channels in the database. This table is used by [[mythfilldatabase]] for grabbing [[channel icons]]. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | == Table Description == | ||
| + | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | ||
| + | |- style="background: lightsteelblue" | ||
| + | ! Field name !! Type !! Null !! Key !! Default !! Extras | ||
| + | |- | ||
| + | || id || int(11) || || PRI || NULL || auto_increment | ||
| + | |- | ||
| + | || callsign || varchar(20) || || UNI || || REFERENCES [[channel table|channel]](callsign) | ||
| + | |- | ||
| + | || network || varchar(20) || || || || REFERENCES [[networkiconmap table|networkiconmap]](network) | ||
| + | |- | ||
| + | |} | ||
| + | |||
| + | ==Fields== | ||
| + | *'''id''' is a unique identifier for the entries in the table. | ||
| + | *'''callsign''' is used to map to the [[channel table]]. | ||
| + | ** Example values: ''SCI-FI'', ''HIST'', ''TOON'', ''USA'', ''WKRC'' | ||
| + | *'''network''' is used to map to the [[networkiconmap table]]. | ||
| + | ** Example values: ''dni_SCIFI'', ''dni_HIST'', ''dni_TOON'', ''dni_USA'', ''dni_WKRC'' | ||
[[Category:DB Table]] | [[Category:DB Table]] | ||
Latest revision as of 15:24, 22 February 2014
Note: The correct title of this article is callsignnetworkmap table. It appears incorrectly here due to technical restrictions.
The callsignnetworkmap table contains the call-signs of the TV channels in the database. This table is used by mythfilldatabase for grabbing channel icons.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| id | int(11) | PRI | NULL | auto_increment | |
| callsign | varchar(20) | UNI | REFERENCES channel(callsign) | ||
| network | varchar(20) | REFERENCES networkiconmap(network) |
Fields
- id is a unique identifier for the entries in the table.
- callsign is used to map to the channel table.
- Example values: SCI-FI, HIST, TOON, USA, WKRC
- network is used to map to the networkiconmap table.
- Example values: dni_SCIFI, dni_HIST, dni_TOON, dni_USA, dni_WKRC
