MySQL column name standards / conventions -


I am looking for a document (suggestions) with column name standards or conventions for MySQL, any suggestions to anyone can give?

In this place, the "standard" Sun's old Java conventions

  • T_
  • for the view v_

    / li>

  • idx_ for the index
  • for the text field Tx_
  • dt_ for date fields
  • for numeric field n_
  • to identify id_field
  • for some nm_ Typically name
  • is for booleans, whether 0/1, yes / no or otherwise
  • is an optional foreign key ide As ntifier fk_; You may also like to be with ID_, however, to keep the field as its primary key equivalent, e.g. Id_customer - & gt; Id_customer instead of a fk_customer

Comments