updated the DB diagram to contain the new set of table relationships.
also need to checkin the green dao generated code.