Columns

Columns are the components of tables in which data is actually stored. Columns have an external and a physical name. You can use the physical name to refer to the storage structure in your RDBMS. The external name (i.e. field name) appears in the user interface.

Columns are defined on a domain. A domain characterizes the set of values that are allowed as input for a column. You must define at least one domain for each RDBMS data type that you use in your application.

A database column will appear as a field on the window of the table to which it belongs (unless you set its Displayed value to No). However, you can also define fields that display information from some other table (the so-called joined columns), or fields that display the result of some computation (the so-called virtuals).