Do you have any documentation on the naming conventions and common practices you follow with your projects that you sell to make navigating them easier?

Hi,

We have a legend for the field naming convention in the upper left of the relationship graph. It looks like this:

Legend

_c_ Constant Field

_k Key Field

_kprime Primary Key (the unique, primary key in this table)

_kf Foreign Key (the primary key of another table)

_k_Calc Calculated Key (usually used in filter relationships)

z_ Developer Field

That is really the only naming conventions we use: scripts are named naturally and table occurrences are named from left to right (parent to child) down the relationship chain, abbreviating as necessary.

Hope that helps.

Is there something specific you wanted to know?