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
)