Is there a list of database tables for the suite - I want to go thru and make sure I drop some old leftover tables of old apps that are not in use. 

The easiest way to create such a list is to create a fresh install, and check what tables are there.

Having said that, some tables are only created when you use a specific app or part of an app, so some common sense will have to be applied when dropping all other tables. Naming conventions of such tables may give a good indication whether they can be removed or not, and alternatively, you can always browse the contents to get an idea.

HTH, kind regards, Wim