Definition for AuditTrail

Column Type Description
AuditID int Table index
Action varchar(50) A string containing the type of action the user has taken.
UserName nvarchar(50) Unicode string containing the name of the user.
IP varchar(16) The IP address of the end user
DateTime datetime The date and time of the action taken
Succeed char(1) Did the action succeed? True, or False
Info nvarchar(2000) Additional information regarding the action taken

Definition for Countries

Column Type Description
CountryID int Table index
Country varchar(50) Name of country
DomainName varchar(5) The Internet domain name of the country
TimesUsed int The number of times this country was used.

Definition for Directors
Column Type Description
DirectorID int Table index
PeopleID int Points to People table index
MovieID int Points to Movies table index
TimesUsed int The number of tmes this director was used.

Definition for Genres
Column Type Description
GenreID int Table index
Genre varchar(100) The genre
TimesUsed int Number of times this genre was used.

Definition for Languages

Column Type Description
LanguageID int Table index
LanguageName varchar(50) The name of the language
TimesUsed int The number of times this language was used

Definition for MovieActor

Column Type Description
MovieActorID int Table index
ActorID int Points to People table index
MovieID int Points to Movie table index

Definition for MovieLanguage
Column Type Description
MovieLanguageID int Table index
MovieID int Points to Movies table index
LanguageID int Points to Language table index

Definition for Movies
Column Type Description
MovieID int Table index
Title varchar(50) The name of the movie
GenreID int Points to Genre table index
DirectorID int Points to Director table index
CountryID int Points to Country table index
Picture image Contains a picture of this movie
PictureType varchar(80) The MIME type of the Picture

Definition for People
Column Type Description
PeopleID int Table index
Name varchar(50) The name of the actor/actress/director
FamilyName varchar(50) The surname / family name of the actor / actress / director.
TimesUsed int The number of times this actor was used.
RoleID int Bit 0 - Actor / Actress
Bit 2 - Director

Definition for Reviews
Column Type Description
ReviewID int Table index
ReviewerID int Points to Users table index
MovieID int Points to Movies table index
ReviewText nvarchar(2000) Unicode, contains the text for one review
Rating varchar(15) The rating for this movie
ReviewDate datetime The date/time this movie review was done

Definition for Users
Column Type Description
UserID int Table index
UserName nvarchar(50) Unicode, the name the user used to log in
Name nvarchar(80) Unicode, the display name of the user.
Surname nvarchar(80) Unicode, the display family name of the user.
Password nvarchar(50) The MD5 hash of the user's password.
Email varchar(50) The user's email address
CreatedOn datetime The date/time this user was created.
ModifiedOn datetime The date/time this user was last modified.
LoggedOn datetime The date/time this user last logged on.
LoggedOff datetime The date/time this user last logged off
LoggedOnCount int The number of times this user has logged on.