Credits table
From MythTV Official Wiki
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 | ||
| 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 |
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.
