Difference between revisions of "Credits table"

From MythTV Official Wiki
Jump to: navigation, search
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]].
 
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]].
 +
 +
{| cellpadding="4"
 +
|- bgcolor="#9999ff"
 +
! Field    !! Type                  !! Null !! Key !! Default            !! Extra
 +
|- bgcolor="#cccccc"
 +
| person    || mediumint(8) unsigned ||      || PRI || 0                  ||
 +
|- bgcolor="#cccccc"
 +
| chanid    || int(10) unsigned      ||      || PRI || 0                  ||
 +
|- bgcolor="#cccccc"
 +
| starttime || datetime              ||      || PRI || 0000-00-00 00:00:00 ||
 +
|- bgcolor="#cccccc"
 +
| role      || set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') ||    || PRI ||    ||
 +
|-
 +
|}
  
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 05:06, 4 March 2007

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.

Field Type Null Key Default Extra
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