Managing the Attributes in database tables

The Attributes that are available in the schema determine the types of data that can be stored in a table. You can add Attributes, modify, or remove Attributes from a table.

Important: Removing Attributes will result in any data stored in that Attribute to be removed from the records that contain it.
Each Attribute in a table is listed along with a summary:
Attribute Information Description
Name The name of the Attribute
Data Type The type of data that the Attribute stores
Unit or Discrete Type The Units for this attribute or the Discrete Type
Meta-Attributes Any Meta-Attributes that are associated with the Attribute
Search Filters Whether the Attribute can be used to refine searches.
Parameters A list of the parameters that the Attribute requires.
Columns Only used for tabular Attributes, a list of the Tabular Columns that are linked.
Expressions A list of the expressions used in equations and logical Attributes.
Data Validation Rule Any data validation rules that apply to the Attribute value.
To create Attributes:
  1. Open Administration > Schema Editor and select the database and table to add the Attribute to.
  2. Click Attributes, and select Create Attribute.
  3. Select the Data type and add the Attribute Name.
    Properties that are specific to the type of data will be displayed, along with any applicable Meta-Attributes and Parameters. For more information, see Data Types for Attributes.
  4. Select the properties for your Attribute, and enter any Meta-Attributes, and Parameters.
    Note: The Attribute can only be saved when all mandatory properties have been set.
  5. Click Save.