Field name conventions

The rules that apply to the naming of new columns depend on the used database. If you think of the following rule, you always create valid column names for the databases supported by CAS genesisWorld.

• The first sign must be a letter. Under no circumstances should one of the following signs be used:

umlaut

underscore (_)

at sign (@)

number sign (#)

• Other signs of the name must not be umlaut either. However, the following signs are permitted:

letter

number

at sign (@)

dollar sign ($)

number sign (#)

underscore (_)

• The name must not contain any space characters.
• The column name must not be a word reserved from the database, for example, SELECT, TABLE, COLUMN, ...
• A list with the reserved words can be obtained from the documentation of your database system.
• The maximum length of 30 characters for a column name must not be exceeded.