[UPHPU] Database Speed Question
Brandon Stout
bms at mscis.org
Thu Apr 12 13:15:51 MDT 2007
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
Justin,
You will have different release dates for both the movie and the dvds
for different countries.
Brandon Stout
http://mscis.org
More information about the UPHPU
mailing list