Difference between revisions of "Credits table"

From MythTV Official Wiki
Jump to: navigation, search
m (FK)
m (Table Description)
 
Line 11: Line 11:
 
| chanid      || int(10) unsigned      ||      || PRI || 0                  || rowspan="2" | REFERENCES [[program table|program]](chanid,starttime)
 
| chanid      || int(10) unsigned      ||      || PRI || 0                  || rowspan="2" | REFERENCES [[program table|program]](chanid,starttime)
 
|-
 
|-
| starttime  || datetime              ||      || PRI || 0000-00-00 00:00:00 ||
+
| 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 ||    ||
 
| role || set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') ||    || PRI ||    ||

Latest revision as of 16:25, 22 February 2014

Important.png 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