Difference between revisions of "Credits table"
From MythTV Official Wiki
m (table style) |
|||
| 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=" | + | == Table Description == |
| − | |- | + | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" |
| − | ! Field | + | |- style="background: lightsteelblue" |
| − | |- | + | ! Field name !! Type !! Null !! Key !! Default !! Extras |
| − | | person | + | |- |
| − | |- | + | | person || mediumint(8) unsigned || || PRI || 0 || |
| − | | chanid | + | |- |
| − | |- | + | | chanid || int(10) unsigned || || PRI || 0 || |
| − | | starttime || datetime || || PRI || 0000-00-00 00:00:00 || | + | |- |
| − | |- | + | | starttime || datetime || || PRI || 0000-00-00 00:00:00 || |
| − | | role | + | |- |
| + | | 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 04:42, 12 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.
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 |
