Courses/CS 122/Summer 2009/MovieDesc
From CSWiki
< Courses | CS 122 | Summer 2009
Contents |
[edit] Members
- MemberID: The member ID assigned to this user by the movie archive website.
- Username: The username the user has selected.
- Password: The password the user has selected.
- Email: The e-mail address of the user.
- Gender: The gender of the user.
- Birthdate: The birth date of the user.
- ZipPostalCode: The zip or postal code of the city the user resides in.
- Country: The country the user comes.
- JoinDate: The date the user joined the movie archive website.
- ProMember: TRUE if member is a paid subscriber; FALSE otherwise.
[edit] Companies
- CompanyID: The numeric identifier assigned to this production company by the movie archive website.
- Name: The name of this production company.
- Address: The postal address of this production company.
- City: The city that this production company resides in.
- StateProvince: The state that this production company resides in.
- ZipPostalCode: The zip or postal code of the city this production company resides in.
- Country: The country this production company resides in.
- Phone: The phone number of this production company.
[edit] Genres
- Genre: A movie genre, such as Action, Adventure, Romance, etc.
[edit] Movies
- MovieID: A unique numeric identifier assigned to this movie by the movie archive website.
- Title: The title of this movie.
- ReleaseDate: The official date that this movie was released to the public (in theaters).
- MPAA: The MPAA rating of this movie, for example, G, PG-13, and R.
- Runtime: The running time in minutes of this movie.
- Country: The country the production company produced this movie for.
- Language: The original language this movie was recorded in.
- CompanyID: The ID of the production company that produced this movie.
[edit] People
- PersonID: The unique identifier assigned to this person by the movie archive website.
- FirstName: The first name of this person (professionally used first name).
- MiddleName: The middle name of this person (professionally used middle name).
- LastName: The last name of this person (professionally used last name).
- BirthFirstName: The first name of this person (legal first name, at birth). If NULL, same as professional first name.
- BirthMiddleName: The middle name of this person (legal middle name, at birth). If NULL, same as professional middle name.
- BirthLastName: The last name of this person (legal middle name, at birth). If NULL, same as professional last name.
- BirthDate: The birthday of this person.
- BirthCity: The city this person was born in.
- BirthStateProvince: The state or province this person was born in.
- BirthCountry: The country this person was born in.
- Height: The height of this person in meters.
[edit] Ratings
- MemberID: The member ID of the user that gave this rating.
- MovieID: The movie ID of the movie this user rated.
- Rating: The rating this user gave. Will always be a value between 0 and 10.
[edit] Spouses
- HusbandID: The person ID of the husband.
- WifeID: The person ID of the wife.
- StartDate: The date this couple got married.
- EndDate: The date this couple got divorced.
- Status: Current status of the relationship between this couple. Can be married, divorced or separated.
- Children: The number of children this couple has had together.
[edit] Taglines
- MovieID: The movie ID for this movie.
- Tagline: The tagline for this movie. Taglines are catch phrases typically used in billboard advertising.
[edit] Keywords
- MovieID: The movie ID for this movie.
- Keyword: The keyword associated with this movie. Keywords are typically single or compound words used to describe events that happen in a movie.
[edit] XRefActorsMovies
- MovieID: The movie ID of the movie.
- ActorID: The person ID of the actor that starred in this movie.
- CharacterName: The name of the character the actor played in the movie.
[edit] XRefDirectorsMovies
- MovieID: The movie ID of this movie.
- DirectorID: The person ID of the director that directed this movie. Note that any movie may have more than one director.
[edit] XRefProducersMovies
- MovieID: The movie ID of the movie.
- ProducerID: The person ID of the producer that produced this movie.
- ProducerTitle: The job title of the producer that produced this movie. Can be Producer, Executive Producer, Associate Producer, or Co-Producer.
[edit] XRefGenresMovies
- MovieID: The movie ID of this movie.
- Genre: The genre that this movie is associated with. Note that a movie may be associated with multiple genres.
