Difference between revisions of "Programrating table"
From MythTV Official Wiki
(TYPE,FK) |
|||
| (8 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | The | + | {{Wrongtitle|programrating table}} |
| + | 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 ([http://www.bbfc.co.uk/ BBFC]) and the ratings that may be used are U, PG, 12, 12A, 15, 18 and R18. | ||
| + | |||
| + | == 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 | ||
| + | |- | ||
| + | || chanid || int(10) unsigned || || MUL || 0 || REFERENCES [[program table|program]](chanid,starttime) | ||
| + | |- | ||
| + | || starttime || datetime || || MUL || 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 [[program 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. | ||
| + | |||
| + | [[Category:DB Table]] | ||
Latest revision as of 22:09, 22 February 2014
Note: The correct title of this article is programrating table. It appears incorrectly here due to technical restrictions.
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.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| chanid | int(10) unsigned | MUL | 0 | REFERENCES program(chanid,starttime) | |
| starttime | datetime | MUL | 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 program 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.
