Difference between revisions of "Callsignnetworkmap table"

From MythTV Official Wiki
Jump to: navigation, search
m
(FK)
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
 
{{Wrongtitle|callsignnetworkmap table}}
 
{{Wrongtitle|callsignnetworkmap table}}
<table cellpadding="4">
+
The '''callsignnetworkmap table''' contains the call-signs of the TV channels in the database.  This table is used by [[mythfilldatabase]] for grabbing [[channel icons]].
<tr bgcolor=#9999ff> <td><b>Field name</b></td> <td><b>Type</b></td> <td><b>Allow nulls?</b></td> <td><b>Key</b></td> <td><b>Default value</b></td> <td><b>Extras</b></td> </tr>
 
<tr bgcolor=#cccccc>
 
<td>id</td>
 
<td>int(11)</td>
 
<td>No</td>
 
<td>Primary</td>
 
<td>&nbsp;</td>
 
<td>auto_increment&nbsp;</td>
 
</tr>
 
<tr bgcolor=#cccccc>
 
<td>callsign</td>
 
<td>varchar(20)</td>
 
<td>No</td>
 
<td>None</td>
 
<td>&nbsp;</td>
 
<td>&nbsp;</td>
 
</tr>
 
<tr bgcolor=#cccccc>
 
<td>network</td>
 
<td>varchar(20)</td>
 
<td>No</td>
 
<td>None</td>
 
<td>&nbsp;</td>
 
<td>&nbsp;</td>
 
</tr>
 
</table>
 
  
{{stub}}
+
== 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

Important.png 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