Difference between revisions of "Videometadatacountry 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  || No  || 0      || Indexed
+
| idvideo    || int(10) unsigned ||     || PRI || NULL    || REFERENCES [[videometadata table]](intid)
 
|-
 
|-
| idcountry  || int(10) unsigned || NO  || No  || 0      || Indexed
+
| idcountry  || int(10) unsigned ||     || PRI || NULL    || REFERENCES [[videocountry table]](intid)
 
|-
 
|-
 
|}
 
|}

Latest revision as of 22:48, 22 February 2014

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

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

Fields