Table naming conventions
From Site Foundry
There's not much to say here accept that we like to keep things as defined as possible. All core tables are prefixed with the label sf_site - apart from the acl table.
It is best if you can prefix your module tables with sf_module_ etc. In this way, it is quite easy to look and see what's going on regarding tables with a MySQL editor such as phpMyAdmin.
For example, building a news module would require the following tables:
sf_module_news sf_module_news_categories
Of course these are only suggestions, and really, you can do whatever you would like to do.

