Videocollection table
Jump to navigation
Jump to search
Note: The correct title of this article is videocollection table. It appears incorrectly here due to technical restrictions.
The videocollection table contains ...
Table Description
| Field name | Type | Null | Key | Default | Extras | Description |
|---|---|---|---|---|---|---|
| intid | int(10) unsigned | PRI | NULL | auto_increment | ||
| title | varchar(256) | MUL | NULL | |||
| contenttype | set('MOVIE','TELEVISION','ADULT','MUSICVIDEO','HOMEVIDEO') | |||||
| plot | text | NULL | NULL | |||
| network | varchar(128) | NULL | NULL | |||
| collectionref | varchar(128) | NULL | ||||
| certification | varchar(128) | NULL | NULL | |||
| genre | varchar(128) | NULL | ||||
| releasedate | date | NULL | NULL | |||
| language | varchar(10) | NULL | NULL | |||
| status | varchar(64) | NULL | NULL | |||
| rating | float | NULL | 0 | |||
| ratingcount | int(10) | NULL | 0 | |||
| runtime | smallint(5) unsigned | NULL | 0 | |||
| banner | text | NULL | NULL | |||
| fanart | text | NULL | NULL | |||
| coverart | text | NULL | NULL |