Difference between revisions of "Credits table"
From MythTV Official Wiki
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 |