Difference between revisions of "Programrating table"

From MythTV Official Wiki
Jump to: navigation, search
m (table style)
Line 3: Line 3:
 
== 0.20-fixes Version ==
 
== 0.20-fixes Version ==
  
{| border=1 style="background:#D6DFE7"
+
{| cellpadding="4"
 +
|- bgcolor="#9999ff"
 
!Field        !! Type            !! Null !! Key !! Default            !! Extra
 
!Field        !! Type            !! Null !! Key !! Default            !! Extra
|-
+
|- bgcolor="#cccccc"
 
|| chanid      || int(10) unsigned ||      || PRI || 0                  ||
 
|| chanid      || int(10) unsigned ||      || PRI || 0                  ||
|-
+
|- bgcolor="#cccccc"
 
|| starttime  || datetime        ||      || PRI || 0000-00-00 00:00:00 ||
 
|| starttime  || datetime        ||      || PRI || 0000-00-00 00:00:00 ||
|-
+
|- bgcolor="#cccccc"
 
|| system      || char(8)          ||      || PRI ||                    ||
 
|| system      || char(8)          ||      || PRI ||                    ||
 +
|- bgcolor="#cccccc"
 +
|| rating      || char(8)          ||      || PRI ||                    ||
 
|-
 
|-
|| rating      || char(8)          ||      || PRI ||                    ||
 
 
|}
 
|}
  
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 20:07, 3 March 2007

The programrating table contains rating classifications and the classifying body for rated shows (usually movies) listed in the program table. Eg. in the UK, the rating body is the British Board of Film Classification (BBFC) and the ratings that may be used are U, PG, 12, 12A, 15, 18 and R18.

0.20-fixes Version

Field Type Null Key Default Extra
chanid int(10) unsigned PRI 0
starttime datetime PRI 0000-00-00 00:00:00
system char(8) PRI
rating char(8) PRI