Database Naming Conventions
Class
Title with a capital letter — for example, Customer. When these are viewed in the Report Writer, they are always displayed in red and are not prefixed with an image.
Attributes
These always begin with a lower case letter and are prefixed with a specific image depending on their type:
- Alphanumeric attributes are
prefixed with this image:
— for example, code.
- Numeric attributes are prefixed
with the following:
— for example, creditLimit.
- Dates attributes are prefixed
with this image:
— for example, createDate.
- True/false attributes are prefixed
with the following image:
— for example, isCheckingCredit.
If two or more words are used to describe an attribute, subsequent words are prefixed with a capital letter — for example, creditLimit, emailAddress.
Collections
These always begin with all
and are prefixed with this image: — for example, allUnappliedTransactions,
allUserFields.
References
These always begin with my
and are prefixed with this image:
— for example, myAddress and
myARControl.
Trees
These are named using the trees set up on the Tree Maintenance form,
and are prefixed with this image:
— for example, Customer Type.
User Defined Fields
These are named using the user defined fields set up in the module,
and are prefixed with this image:
— for example, Business Type.