[UPHPU] Database Speed Question

[Walt Haas]

Why do you use a separate Movie_Relationship_ID?  Wouldn't it work to
use Movie_ID in the Trailers table?

-- Walt

On Thu, 2007-04-12 at 11:57 -0600, Webot Graphics wrote:
> Here is the database that I have now. Anyone have any suggestions?
> 
> Movie Database
> 
> Movies Table
> 	Movie_ID
> 	Plot_Description
> 	
> Movie_Relationships Table
> 	Movie_Relationship_ID
> 	Movie_ID
> 	Movie_Title
> 	Movie_Description
> 	Country_ID
> 	Language_ID
> 	Movie_Release_Year
> 	DVD_Release_Year
> 	Movie_Release_Month
> 	DVD_Release_Month
> 	Movie_Release_Day
> 	DVD_Release_Year
> 	Movie_Runtime
> 	Front_Cover_Image_File
> 	Back_Cover_Image_File
> 	
> Trailers Table
> 	Trailer_ID
> 	Trailer_File
> 	Movie_Relationship_ID
> 	
> Extra_Features Table
> 	Extra_Feature_ID
> 	Extra_Feature_Name
> 	
> Extra_Feature_Movie_Relationships Table
> 	Extra_Feature_ID
> 	Movie_ID
> 	
> Subtitle_Movie_Relationships Table
> 	Language_ID
> 	Movie_ID
> 	
> Languages Table
> 	Language_ID
> 	Language_Name
> 
> Genres Table
> 	Genre_ID
> 	Genre_Name
> 	
> Genre_Movie_Relationships Table
> 	Genre_ID
> 	Movie_ID
> 
> Actors Table
> 	Actor_ID
> 	Actor_First_Name
> 	Actor_Last_Name
> 	
> Actor_Movie_Relationships Table
> 	Actor_ID
> 	Movie_ID
> 
> Producers Table
> 	Producer_ID
> 	Producer_First_Name
> 	Producer_Last_Name
> 	
> Producer_Movie_Relationships Table
> 	Producer_ID
> 	Movie_ID
> 
> Directors Table
> 	Director_ID
> 	Director_First_Name
> 	Director_Last_Name
> 	
> Director_Movie_Relationships Table
> 	Director_ID
> 	Movie_ID
> 
> Production_Companies Table
> 	Production_Company_ID
> 	Production_Company_Name
> 	
> Production_Company_Movie_Relationships Table
> 	Production_Company_ID
> 	Movie_ID
> 
> Ratings Table
> 	Rating_ID
> 	Rating_Code
> 	Rating_Description
> 	Rating_Country_ID
> 	
> Countries Table
> 	Country_ID
> 	Country_Name
> 	
> Rating_Movie_Relationships Table
> 	Rating_ID
> 	Movie_ID
> 
> Barcodes Table
> 	Barcode
> 	Barcode_Movie_ID
> 	Full_Screen (BOOL/False is wide screen)
> 
> 
> 
> Justin Giboney
> www.forodeherbales.com
> 
> 
> 
> _______________________________________________
> 
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net