Difference between revisions of "Recordedcredits table"
From MythTV Official Wiki
(FK) |
|||
| Line 6: | Line 6: | ||
! Field name !! Type !! Null !! Key !! Default !! Extras | ! Field name !! Type !! Null !! Key !! Default !! Extras | ||
|- | |- | ||
| − | | person || mediumint(8) unsigned || || PRI || 0 || | + | | person || mediumint(8) unsigned || || PRI || 0 || REFERENCES [[people table|people]](person) |
|- | |- | ||
| − | | chanid || int(10) unsigned || || PRI || 0 || | + | | chanid || int(10) unsigned || || PRI || 0 || rowspan="2" | REFERENCES [[recorded table|recorded]](chanid,starttime) |
|- | |- | ||
| − | | starttime || datetime || || PRI || 0000-00-00 00:00:00 | + | | 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 || || | | role || set(actor,director,producer,executive_producer,writer,guest_star,host,adapter,presenter,commentator,guest) || || PRI || || | ||
Revision as of 14:15, 22 February 2014
Note: The correct title of this article is recordedcredits table. It appears incorrectly here due to technical restrictions.
The recordedcredits table describes the role (actor, director, etc.) that individuals in the people table play in specific programs stored in the recorded table.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| person | mediumint(8) unsigned | PRI | 0 | REFERENCES people(person) | |
| chanid | int(10) unsigned | PRI | 0 | REFERENCES recorded(chanid,starttime) | |
| 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 |
Fields
- person relates to the personid field of the people table.
- chanid along with starttime relate to unique entries in the recorded table.
- role describes the role this person played in the program.
Example Entries
person: 2027
chanid: 2542
starttime: 2007-03-22 08:30:00
role: actor
person: 8201
chanid: 2531
starttime: 2007-03-25 02:35:00
role: executive_producer
person: 11670
chanid: 2531
starttime: 2007-03-24 23:35:00
role: writer
