Field naming conventions

When you create a table in the database, you should follow relevant conventions for naming fields. This topic aims to help developers standardize field naming in the database.

Field naming

• Use either all uppercase letters or all lowercase letters for field names. Do not use a combination of uppercase and lowercase letters.

• Start field names with letters.

• Use field names that clearly indicate the content, for example, "NAME".

• Do not start or end field names with underscores.

• Do not start field names with digits.

• Do not use system reserved words or keywords in field names.

• Do not use only digits between underscores in field names.

• Do not use plural nouns for field names.

• Use the feature name or standard abbreviation that the field represents, separated by "_". The recommended format is "business name_field purpose", for example, "TASK_NUM", "CREATE_DATE", "STATION_DESC", "TASK_ID".