I like the python style guide here: http://www.python.org/dev/peps/pep-0008/
has tips on naming conventions and such. i personally don't prefix table names or field names. and i let web2py name the primary key "id". most of the time my reference fields share the same name as the table they reference.
