Standard to create the columns:

  1. The column name should be of the form XX<Abbr/Name><suffix> (XXX represents the abbreviation of the Table Name.It should be a meaningful abbreviation of the table name to which the column belongs.<suffix> is a meaningful suffix).
  2. Column name should  not be  longer than 30  Alphanumeric characters.
  3. Column name (<Abbr/Name> only) should be same throughout an  application even though the field may be present in more than one table.

The following suffixes can be used for better understanding.

ata Suffix
CODES Code
IDENTIFIER Id
INDICATOR/FLAG Flag
AMOUNT Amount
RATES Rate
KEY Key
Number Number
Name Name
Type Type