Archived

Difference between revisions of "Database schema standards"

From Joomla! Documentation

Line 3: Line 3:
 
* 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.
 
* Cross referencing table names should always reflect multiplicity, e.g.: 1 to N: user_sessions, M to N: users_usergroups
 
* Cross referencing table names should always reflect multiplicity, e.g.: 1 to N: user_sessions, M to N: users_usergroups
 +
<nowiki><math>Masukkan teks yang tidak akan diformat di sini</m
 +
----
 +
a--~~~~<nowiki><math>Masukkan teks yang tidak akan diformat di sini</math>[[File:[Contoh.jpg][http://www.example.c'''Teks ini akan dicetak tebal'''om judul pranala]]]</nowiki>th>[[Judul pranala]]</nowiki>
  
 
== Field Naming Conventions ==
 
== Field Naming Conventions ==

Revision as of 10:42, 15 March 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

<math>Masukkan teks yang tidak akan diformat di sini</m ---- a--~~~~<nowiki><math>Masukkan teks yang tidak akan diformat di sini</math>[[File:[Contoh.jpg][http://www.example.c'''Teks ini akan dicetak tebal'''om judul pranala]]]th>Judul pranala</nowiki>

Field Naming Conventions[edit]

Field Type Recommendations[edit]