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
Post a Comment