|
In response to
"Or, even a piece of one. 2-3 tables max is probably all I'll be needing for this."
by
con_carne
|
basically what I do is
Posted by
Max
May 20 '11, 15:07
|
a table for movies and a table for each of: actor, director, cinematographer, screenwriter, composer, and studio. Also a table for keyword.
The movies table links to each of the other tables, plus has fields for opening and total box office, my personal grade, and Nominations checkmark fields for the major categories
The keyword field table has broad categories like Comedy, Romance, Action, Adventure, SciFi, Thriller, etc, where I can pick multiple choices, as well as Era/Ancient, Era/Medieval, Era/1600-1800s, car chase, Revenge, Vampire, Hitman, Sequel, Courtroom, Spy, High School, Spoof... And I've set up a form for that table which shows the titles of the movies and their grades I've given in a list so I can see which movies fit in that category and which I liked most.
The actors table has fields for name, age, gender, power (1-5, based on their ability to open a movie), nominee, and preference, so that I can list my favorite actors and see their movies. Same thing with the keyword form, which shows their filmographies and my grades.
|
Responses:
|