Actions

Archived

Difference between revisions of "Database schema standards"

From Joomla! Documentation

(New page: == Table Naming Conventions == == Field Naming Conventions == == Field Type Recommendations ==)
 
(Table Naming Conventions)
Line 1: Line 1:
 
== Table Naming Conventions ==
 
== 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 Naming Conventions ==

Revision as of 19:31, 3 November 2009

Replacement filing cabinet.png
This page has been archived - Please Do Not Edit or Create Pages placed in this namespace. The pages in the Archived namespace exist only as a historical reference, it will not be improved and its content may be incomplete.

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