System and Virtual Columns

Katmandoo stores data using two distinct field types, system columns and virtual columns (factors).

System columns are built into the underlying Katmandoo database structure. Because these fields are defined within the database schema, their data type and length cannot be altered. Their caption, description and validation options can be customised.

Virtual Columns are defined by the user. They allow customisation of sections of the database to fit specific data sets. Virtual columns have the same field options as system columns but allow greater flexibility.