Difference between revisions of "Videometadatagenre table"

From MythTV Official Wiki
Jump to: navigation, search
m
(FK)
 
Line 9: Line 9:
 
! Field name !! Type              !! Null !! Key !! Default !! Extras
 
! Field name !! Type              !! Null !! Key !! Default !! Extras
 
|-
 
|-
| idvideo    || int(10)  unsigned || NO  ||     || 0      || Indexed
+
| idvideo    || int(10)  unsigned ||     || PRI || NULL    || REFERENCES [[videometadata table]](intid)
 
|-
 
|-
| idgenre    || int(10)  unsigned || NO  ||     || 0      || Indexed
+
| idgenre    || int(10)  unsigned ||     || PRI || NULL    || REFERENCES [[videogenre table]](intid)
 
|-
 
|-
 
|}
 
|}

Latest revision as of 22:50, 22 February 2014

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

The videometadatagenre table relates entries in the videometadata table to entries in the videogenre table.

Table is current as of schema version 1037.

Table Description

Field name Type Null Key Default Extras
idvideo int(10) unsigned PRI NULL REFERENCES videometadata table(intid)
idgenre int(10) unsigned PRI NULL REFERENCES videogenre table(intid)

Fields