[libdb-develop] Database First Draft Complete

[Morbus I. <mo...@di...>]

Hey all. The first iteration of the database has been finalized and
modeled with data from a rather unremarkable movie I own (THE POOL).
The latest schema and sample data is heading up to CVS now.

Here's your TODO list, if you're interested:

 * sanity check my SQL. ask questions. poke, prod.

 * sanity check my data modeling. ask questions. poke. prod.

 * help me define the following roles. "roles", in the database,
   are "occupations" or "jobs" that a person or corporate body can
   have. naturally, for a movie, there are an awful lot of roles
   (read: an awful lot of different types of crew members). I've
   defined (either myself, or from IMDb) about 75% of the roles
   found in THE POOL, but I need some help on the following,
   either from discovery on Google, or what have you:

     2D Artist, Insurance, Lighting, Music Coordinator,
     Orchestra Contractor, Payroll Accountant,
     Post-Production Accountant, Score Engineer,
     Score Mixer, Score Recording, Score Performance,
     Set Directory, Sound Post-Production,
     Sound Re-Recording Mixer, Special Effects Coordinator,
     Special Effects Technician, Stereo Sound Consultant,
     Titles (company), Video Playback Engineer, Visual
     Effects Producer

Over the next day or so, I'll be fiddling with the wiki to get that
in a more presentable form, as well as creating a press release sort
of thing for the dozen or so blogs I know waiting to announce it.
Then, I'll be coding. Yup. Either way, the Database Schema on the
wiki is updated to the latest/final:

  http://disobey.com/noos/LibDB/?DatabaseSchema

-- 
Morbus Iff ( i still fail to see what this has to do with morocco )
Technical: http://www.oreillynet.com/pub/au/779
Culture: http://www.disobey.com/ and http://www.gamegrene.com/
icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus