Data dictionary is introduced in the coming release of Calem R2021. It is intended for power users, administrators and system integrators. For instance, one can use data dictionary to find out the field type for asset number.
The following objects are included in the data dictionary.
|Table||A table is a Calem object implemented in MySQL as a able. For instance, work orders are implemented as the work order table and child tables such as work order comments, work order labort and material, etc.|
|View||A view is a Calem presentation object implemented in MySQL as a view. For instance, a work order view may include selective fields from work order and asset tables.|
|Class Attributes||Class attributes are sets of attributes for a class. Data objects assigned to a class can have class attributes of that class and attributes of the parent classes. Classes and attributes are added by customers.|
|Dropdown||A dropdown is a list of values that can be used for a field. For instance, work order priorities are implemented as a dropdown.|
|My Dropdown||My Dropdowns are dropdowns added by customers.|
Data dictionary is available from Admin module:
Click a row to drill down to an object. For instance, click "cm_wo" row to see its fields below.
Click a lookup table link (such as "cm_asset" above in blue) to drill into a lookup table to view the fields of a lookup table.