Credits table

From MythTV Official Wiki
Revision as of 05:06, 4 March 2007 by Malban (talk | contribs)

Jump to: navigation, search

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