Archived

Difference between revisions of "Database schema standards"

From Joomla! Documentation

m (Reverted edits by Dedy prayitno (talk) to last revision by Batch1211)
Line 9: Line 9:
 
== Field Type Recommendations ==
 
== Field Type Recommendations ==
  
[[Category:Stubs]][[Category:Working Groups]]
+
[[Category:InUse]][[Category:Working Groups]]
{{stub}}
+
{{inuse}}

Revision as of 19:48, 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.

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]

Quill icon.png
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}}.