Credits table

From MythTV Official Wiki
Revision as of 04:42, 12 March 2007 by Malban (talk | contribs) (table style)

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.

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