Difference between revisions of "Credits table"

From MythTV Official Wiki
Jump to: navigation, search
(Added to Category:DB Table)
Line 1: Line 1:
This table records the roles and people associated with a show.
+
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]].
  
||<tablewidth="100%" rowbgcolor="#D6DFE7">Field||Type||NULL||Default||
 
||person||mediumint(8)||No||0 ||
 
||chanid||int(10)||No||0 ||
 
||starttime||timestamp(14)||Yes||NULL||
 
||role||set('actor', 'director', 'producer', 'executive_producer', 'writer', 'guest_star', 'host', 'adapter', 'presenter', 'commentator', 'guest')||No||||
 
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 18:20, 3 March 2006

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.