Field Names

Each remaining field should start with a prefix using 2-4 lower case characters that represents the table it belongs to and is unique relative to any other table prefix in the database.

The prefix should be followed by the field name with each word separated by an underscore.
e.g. To insert the field of a first name from the ‘customer’ table: cus_first_name

Any field that links to the Primary Key field of another table must be made up of the prefix used for the table it is in,
followed by the exact fieldname of the field it will be linking to, followed by the letters “id” and all separated by underscores.
e.g. If the primary table is ‘investor’ and you wish to link it with the ‘customer’ table: inv_customer_id

Created by: system. Last Modification: Thursday 26 of March, 2009 14:23:07 CST by simon.