Difference between revisions of "Callsignnetworkmap table"
From MythTV Official Wiki
(FK) |
|||
| Line 9: | Line 9: | ||
|| id || int(11) || || PRI || NULL || auto_increment | || id || int(11) || || PRI || NULL || auto_increment | ||
|- | |- | ||
| − | || callsign || varchar(20) || || UNI || || | + | || callsign || varchar(20) || || UNI || || REFERENCES [[channel table|channel]](callsign) |
|- | |- | ||
| − | || network || varchar(20) || || || || | + | || network || varchar(20) || || || || REFERENCES [[networkiconmap table|networkiconmap]](network) |
|- | |- | ||
|} | |} | ||
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
