Recordedrating table

From MythTV Official Wiki
Jump to: navigation, search

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

The recordedrating table contains rating classifications and the classifying body for rated shows (usually movies) listed in the recorded 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.

Table Description

Field name Type Null Key Default Extras
chanid int(10) unsigned PRI 0 REFERENCES recorded(chanid,starttime)
starttime datetime PRI 0000-00-00 00:00:00
system varchar(8) NULL NULL
rating varchar(16) NULL NULL

Fields

  • chanid along with starttime relate to unique entries in the recorded table.
  • system is the rating system.
    • MPAA, VCHIP, BBFC, etc.
  • rating is the rating of the program.
    • G, NR, PG, PG-13, R, TV-14, TV-G, TV-MA, TV-PG, TV-Y, TV-Y7, U, 12, 12A, 15, 18, etc.