Arthur Fuller wrote:
>>Ooops! You just threw a new wrench into the works! "A video may have
>>multiple titles." In this case you must distinguish the original from its
>>presumably foreign-translations (or whatever). In other words, you might
>>store the master as "La Cage aux Folles" and the English subtitled version
>>as something else, which implies another 1:M table, residing above Titles in
>>
>>
>
>
Just to top it off, you should probably consider a 'Language' table
which has a reference in the VideoTitles SQL table.
VideoTitle:
VideoID -> Videos.ID
TitleID -> Titles.ID
LanguageID -> Languages.ID
ReleaseDate (date)
Sub-Titled (bool)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
