Difference between revisions of "People table"

From MythTV Official Wiki
Jump to: navigation, search
(Added to Category:DB Table)
m (table style)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The '''people table''' contains an enumerated list of every individual ever mentioned in the credits from shows listed in the [[program table]]. It is used to look up person ids from the [[credits table]].
+
{{Wrongtitle|people table}}
 +
The '''people table''' contains an enumerated list of every individual ever mentioned in the credits from shows listed in the [[program table]]. It is used to look up ''personids'' from the [[credits table]].
 +
== Table Description ==
 +
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 +
|- style="background: lightsteelblue"
 +
!  Field name !! Type                  !! Null !! Key !! Default            !! Extras
 +
|-
 +
|| person      || mediumint(8) unsigned ||      || PRI || NULL    || auto_increment
 +
|-
 +
|| name        || char(128)            ||      || UNI ||        ||
 +
|-
 +
|}
 +
 
 +
== Fields ==
 +
*'''person''' is a unique identifier for entries in this table.
 +
*'''name''' is the person's name.
 +
 
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Latest revision as of 22:05, 14 March 2007

Important.png Note: The correct title of this article is people table. It appears incorrectly here due to technical restrictions.

The people table contains an enumerated list of every individual ever mentioned in the credits from shows listed in the program table. It is used to look up personids from the credits table.

Table Description

Field name Type Null Key Default Extras
person mediumint(8) unsigned PRI NULL auto_increment
name char(128) UNI

Fields

  • person is a unique identifier for entries in this table.
  • name is the person's name.