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