Difference between revisions of "Database schema standards"
From Joomla! Documentation
| Line 1: | Line 1: | ||
| − | == | + | == Naming Conventions == |
* Table names should always go in plural form, e.g.: users, sessions, usergroups, etc. | * Table names should always go in plural form, e.g.: users, sessions, usergroups, etc. | ||
Revision as of 20:10, 30 September 2012
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.
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]
Page Actively Being Edited!
This archived page is actively undergoing a major edit for a short while.
As a courtesy, please do not edit this page while this message is displayed. The user who added this notice will be listed in the page history. This message is intended to help reduce edit conflicts; please remove it between editing sessions to allow others to edit the page.
If this page has not been edited for several hours, please remove this template, or replace it with {{underconstruction}} or {{incomplete}}.