|−|This table records the roles and people associated with a show. |+|
table the and associated with .
| || |
|−|||<tablewidth="100%" rowbgcolor="#D6DFE7">Field||Type||NULL||Default|| | |
|−|||person||mediumint(8)||No||0 || | |
|−|||chanid||int(10)||No||0 || | |
|−|||starttime||timestamp(14)||Yes||NULL|| | |
|−|||role||set('actor', 'director', 'producer', 'executive_producer', 'writer', 'guest_star', 'host', 'adapter', 'presenter', 'commentator', 'guest')||No|||| | |
Revision as of 18:20, 3 March 2006
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.