Difference between revisions of "Credits table"
From MythTV Official Wiki
Goldfishbot (talk | contribs) (Added to Category:DB Table) |
m (→Table Description) |
||
(6 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{Wrongtitle|credits table}} | |
+ | The '''credits table''' describes the role (actor, director, etc.) that individuals in the [[people table]] play in specific programs stored in the [[program table]]. | ||
− | | | + | == Table Description == |
− | + | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | |
− | ||chanid||int(10)|| | + | |- style="background: lightsteelblue" |
− | ||starttime|| | + | ! Field name !! Type !! Null !! Key !! Default !! Extras |
− | ||role||set('actor', 'director', 'producer', 'executive_producer', 'writer', 'guest_star', 'host', 'adapter', 'presenter', 'commentator', 'guest')|| | + | |- |
+ | | person || mediumint(8) unsigned || || PRI || 0 || REFERENCES [[people table|people]](personid) | ||
+ | |- | ||
+ | | chanid || int(10) unsigned || || PRI || 0 || rowspan="2" | REFERENCES [[program table|program]](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 [[program table]]. | ||
+ | *'''role''' describes the role this person played in the program. | ||
+ | |||
+ | == Example Entries == | ||
+ | <pre> | ||
+ | person: 2027 | ||
+ | chanid: 2542 | ||
+ | starttime: 2007-03-22 08:30:00 | ||
+ | role: actor | ||
+ | </pre> | ||
+ | <pre> | ||
+ | person: 8201 | ||
+ | chanid: 2531 | ||
+ | starttime: 2007-03-25 02:35:00 | ||
+ | role: executive_producer | ||
+ | </pre> | ||
+ | <pre> | ||
+ | person: 11670 | ||
+ | chanid: 2531 | ||
+ | starttime: 2007-03-24 23:35:00 | ||
+ | role: writer | ||
+ | </pre> | ||
[[Category:DB Table]] | [[Category:DB Table]] |
Latest revision as of 16:25, 22 February 2014
Note: The correct title of this article is credits table. It appears incorrectly here due to technical restrictions.
The credits table describes the role (actor, director, etc.) that individuals in the people table play in specific programs stored in the program table.
Table Description
Field name | Type | Null | Key | Default | Extras |
---|---|---|---|---|---|
person | mediumint(8) unsigned | PRI | 0 | REFERENCES people(personid) | |
chanid | int(10) unsigned | PRI | 0 | REFERENCES program(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 program 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