Understanding Your Data Model › Using Fields › Field Usages › Database Field Usages

Previous Topic: Database Fields

Next Topic: Function Fields

Database Field Usages

Type

Description

Example

CDE

ATR

Code (key)

Data attribute

Company code

Company name

Key database fields are given the usage type of CDE (code); attribute database fields have the usage type of ATR (attribute). CA 2E automatically supplies the usage type according to how the field is first used in a relation. You can change the usage type using the Edit Field Details panel.

If the field has a usage of CDE and is being associated with a file that has an attribute relation (Has), a warning message is issued that the usage is different. This is also true if a field usage is defined as ATR, and the field is the referenced object of a key relation (Known by, Qualified by).