Schema
Home Up Feedback Contents Search

Database Tables Schema

Here is the information you need to create your own database tables that imports the data from the DVD downloadable database. It is basically for SQL but the field types and sizes will help you create something similar in what ever database you are using. I also have code for SQL, Access and Excel to help with manipulating the data, if you need help with these systems let me know. If you have a question or run into a problem please just write.

DVDTitles

CREATE TABLE [dbo].[DVDTitles] (
[DVD_Title] [varchar] (128) NULL ,
[Studio] [varchar] (30) NULL ,
[Released] [smalldatetime] NULL ,
[Status] [varchar] (15) NULL ,
[Sound] [varchar] (20) NULL ,
[Versions] [varchar] (20) NULL ,
[Price] [money] NULL ,
[Rating] [varchar] (5) NULL ,
[Year] [varchar] (5) NULL ,
[Genre] [varchar] (20) NULL ,
[Aspect] [varchar] (6) NULL ,
[UPC] [varchar] (15) NULL ,
[DVD_ReleaseDate] [smalldatetime] NULL ,
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Timestamp] [smalldatetime] NULL
)

newDVDs

CREATE TABLE [dbo].[newDVDs] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[DVD_Title] [varchar] (128)  NULL ,
[Studio] [varchar] (30)  NULL ,
[Released] [smalldatetime] NULL ,
[Status] [varchar] (15)  NULL ,
[Sound] [varchar] (20)  NULL ,
[Versions] [varchar] (20)  NULL ,
[Price] [money] NULL ,
[Rating] [varchar] (5)  NULL ,
[Year] [varchar] (5)  NULL ,
[Genre] [varchar] (20)  NULL ,
[Aspect] [varchar] (6)  NULL ,
[Updated] [smallint] NULL ,
[UPC] [varchar] (15)  NULL ,
[DVD_ReleaseDate] [smalldatetime] NULL ,
[Timestamp] [smalldatetime] NULL
)
 

Thanks to everyone visiting this site.

Send email to doug@hometheaterinfo.com with questions or comments about this web site.
Copyright 1999-2017 Home Theater Info