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 |
