Database schema standards

From Joomla! Documentation
(Difference between revisions)
Jump to: navigation, search
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

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