Table naming conventions

From Site Foundry

Jump to: navigation, search

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.

Personal tools