Recordedcredits table

From MythTV

Jump to: navigation, search
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.

[edit]

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
[edit]

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.
[edit]

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
Retrieved from "http://www.mythtv.org/wiki/index.php/Recordedcredits_table"
Personal tools