This is the newly reverse-engineered database diagram. (07/21/2010)
here is the database uml i have currently (NOTE: This is old. Consider removing -- Matthew Presser)