IMDb Database Structure

IMDb Database Structure

Field Name	Type	Example	Valid Values	Notes
1. IMDb Constant Title Code	7 Digit Number	0068646		Unique code for each title in IMDb database
2. Title	Text	The Godfather
3. Year	4 digit Number	1972		First Public Screening
4. Plot Outline	Text	A Mafia boss' son, previously uninvolved in the business, takes over when his father is critically wounded in a mob hit.
5. Plot Summary	Text	Don Vito Corleone is the head of a New York Mafia "family". Problems arise when a gangster supported by another Mafia family, Sollozzo, announces his intentions to start selling drugs all over New York. Don Vito hates the idea of drugs, and he is quite happy with the gambling/protection etc. that make him money, so an attempt is made on his life. Sollozzo then kidnaps one of Don Vitos advisors, and tries to make him force Don Vitos son to agree to sell drugs, but the plan goes wrong when Sollozzo finds out that Don Vito is still alive.
6. Principal Cast	Text	Marlon Brando Al Pacino Diane Keaton Richard S. Castellano Robert Duvall		Up to five
7. Genre	Text Set	Crime, Drama	Action, Adventure, Animation, Comedy, Crime, Documentary, Drama, Family, Fantasy, Film-Noir, Horror, Musical, Mystery, Romance, Sci-Fi, Short, Thriller, War, Western	Subset of 12 values.
8. MPAA Rating	Text	USA:R	G, PG, PG-13, R, NC-17, X	Potentially Multiple
9. U.S. Runtime	Minutes	175
10. Trivia	Text	The phone number Michael calls to find out news about his father is Long Beach 4-5620. Warren Beatty, Jack Nicholson, and Dustin Hoffman were all offered the part of Michael Corleone, but all refused. Robert Redford and 'ONeal, Ryan were also considered. Robert De Niro read for the parts of both Sonny and Michael Corleone. Director Francis Coppola decided that he wasn't right for the role of Sonny, and already had Pacino in mind for Michael.		3 entries
11. Goofs	Text	Continuity: A glass of wine in the wedding scene. Anachronisms: In several scenes wine bottles are shown with the DOC Italian wine classification designation shown on the bottle. DOC designations did not come in effect until the 1960s. Continuity: The waiter fills Tom Hagen's glass twice within seconds during his dinner with Woltz.		3 entries
12. Writer(s)	Text	Coppola, Francis Ford Puzo, Mario		Potentially Multiple
13. Plot Keywords	Text Set	garrote revenge father-son-relationship marital-abuse italian-american crime-epic police-brutality organized-crime police-corruption heroin based-on-novel drugs severed-horse's-head racial-slur radio-city-music-hall
14. IMDb Average User Rating	Number	9.0		Avg. User rating on a scale of 1-10
15. Link to official site	URL	N/A		Potentially Multiple
16. Additional Cast	Text	James Caan Talia Shire Sterling Hayden John Marley Richard Conte Al Lettieri Abe Vigoda Gianni Russo John Cazale Rudy Bond		10 Max
17. External Reviews Links	URL	ww.sfgate.com/cgi-bin/article.cgi?f=/examiner/archive/1997/03/21/WEEKEND7240.dtl http://www.suntimes.com/ebert/ebert_reviews/1999/10/god1028.html com/cgi-bin/chronicle/article.cgi?file=/chronicle/archive/1997/03/21/DD65519.DTL http://film.com/film-review/1972/8735/15/default-review.html		10 links Max
18. Links to Trailers	Text	http://us.imdb.com/Trailers?0068646		Potentially Multiple
19. Producer(s)	Text	Frederickson, Gray Ruddy, Albert S.		Potentially Multiple
20. Distributor(s)	Text Set	Paramount Pictures [us]
		Academy Awards®
21. Year	4 Digit Number	1973		Year Award was given, not film release.
22. Category	Text	Best Picture
23. Name-id	Text	Ruddy, Albert S.	Recipient
24. Result	Won	Won	Won, Nominated