Database schema standards

From Joomla! Documentation
Revision as of 19:48, 30 September 2012 by Uob opensource (Talk | contribs)

Jump to: navigation, search

Table Naming Conventions

  • Table names should always go in plural form, e.g.: users, sessions, usergroups, etc.
  • Cross referencing table names should always reflect multiplicity, e.g.: 1 to N: user_sessions, M to N: users_usergroups

Field Naming Conventions

Field Type Recommendations

Personal tools
Namespaces

Variants
Actions
Navigation
Joomla! Sites
Toolbox