Archived

Database schema standards

From Joomla! Documentation

Revision as of 08:06, 20 September 2010 by Batch1211 (talk | contribs)

This page has been archived. This page contains information for an unsupported Joomla! version or is no longer relevant. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

Table Naming Conventions[edit]

  • 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[edit]

Field Type Recommendations[edit]