Difference between revisions of "Credits table"

From MythTV Official Wiki
Jump to: navigation, search
m (table style)
Line 1: Line 1:
The '''credits''' table lists the ''personid'' and role (actor, director, producer, executive_producer, writer, guest_star, host, adapter, presenter, commentator, guest) of individuals associated with shows in the [[program table]]. ''personids'' can be resolved to names using the [[people table]].
+
{{Wrongtitle|credits table}}
 +
The '''credits table''' describes the role (actor, director, etc.) that individuals in the [[people table]] play in specific programs stored in the [[program table]].
  
 
== Table Description ==
 
== Table Description ==
Line 15: Line 16:
 
|-
 
|-
 
|}
 
|}
 +
 +
== Fields ==
 +
*'''person''' relates to the ''personid'' field of the [[people table]].
 +
*'''chanid''' along with '''starttime''' relate to unique entries in the [[program table]].
 +
*'''role''' describes the role this person played in the program.
  
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 00:02, 13 March 2007

Important.png Note: The correct title of this article is credits table. It appears incorrectly here due to technical restrictions.

The credits table describes the role (actor, director, etc.) that individuals in the people table play in specific programs stored in the program table.

Table Description

Field name Type Null Key Default Extras
person mediumint(8) unsigned PRI 0
chanid int(10) unsigned PRI 0
starttime datetime PRI 0000-00-00 00:00:00
role set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') PRI

Fields

  • person relates to the personid field of the people table.
  • chanid along with starttime relate to unique entries in the program table.
  • role describes the role this person played in the program.