I’m still questioning how I should best use the Zend Framework’s database model classes.
The data structure of the current application I’m building is not very complicated: there are 8 tables of between 2 and 11 fields each, and some of the tables are simple parent tables that define user types or status types.
To simplify, three of the tables that do the heaviest lifting do so in a hierarchy like a tree: a user table has a one-to-many relationship with a submissions table, which, in turn, has a one-to-many relationship with a recommendations table.
I extended the Zend_Db_Table_Abstract to model each table (as well described in the documentation). That was easy; I like that.