Difference between revisions of "Videometadatacast table"

From MythTV Official Wiki
Jump to: navigation, search
(Created page with '{{Wrongtitle|videometadatacast table}} The '''videometadatacast table''' relates entries in the videometadata table to entries in the videocast table. Table is current a…')
 
(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)
 
|-
 
|-
| idcast    || int(10)  unsigned || NO  ||     || 0      || Indexed
+
| idcast    || int(10)  unsigned ||     || PRI || NULL    || REFERENCES [[videocast table]](intid)
 
|-
 
|-
 
|}
 
|}

Latest revision as of 22:46, 22 February 2014

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

The videometadatacast table relates entries in the videometadata table to entries in the videocast 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)
idcast int(10) unsigned PRI NULL REFERENCES videocast table(intid)

Fields