How to use column constraints

Constraints define validation rules that input data must satisfy before values can be saved in Power Database Fields. They ensure data integrity by enforcing specific conditions such as value ranges, predefined option lists, or dynamic validation based on context.

The available constraint types depend on the column's data type configuration. When applied, the constraints icon turns green in the Column List to indicate active validation rules.

Contents: 1 Overview of constraint types 2 Available constraints by data type See also: How to use the Advanced Configuration How to use the Configuration Wizard

Overview of constraint types

The following table describes each constraint type with configuration examples to help you choose the appropriate validation rules for your specific requirements.

Constraint type	Description	Example

Constraint type

Description

Example

Min/Max

Enforces numeric or date range limits by setting minimum and maximum acceptable values.
Input must fall within these boundaries for operations to complete successfully.

Min/Max constraint configuration dialog with minimum and maximum value input fields

Static List

Restricts input to a predefined list of options.
Configure key-value pairs where keys match database values for proper synchronization, while display text can be customized for improved user experience.Ç

Static List constraint interface with key-value pair configuration and dropdown selection preview

Dynamic List

Generates constraint options dynamically using custom scripts or database lookups.
Enables context-aware validation based on factors like project, user roles, or related field values.
Can reference separate lookup tables within the same database.(for example, use a [make_code, make_details] table to populate constraints for a make_code column).

Dynamic List constraint interface with script configuration panel

Available constraints by data type

The following table shows which constraint types are available for each data type:

Constraint Type	SEQUENCE	BOOLEAN	NUMBER	REAL	STRING	DATE	DATETIME

Constraint Type	SEQUENCE	BOOLEAN	NUMBER	REAL	STRING	DATE	DATETIME
Min/Max
Static List
Dynamic List