---
title: "How to use column constraints"
canonical: "https://support.appfire.com/space/PSJ/15482044/How%20to%20use%20column%20constraints"
format: markdown
---
> Macro (aura-html)

## 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** |
| --- | --- | --- |
| **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. | ![image](media://9c7a989c-c9df-4d2d-95c8-1f2b3d710cd8) |
| **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.Ç | > Macro (nested-table) |
| **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). | ![image](media://f2bb5406-bb4c-4b4e-880d-156188d438a5) |

## 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** |
| --- | --- | --- | --- | --- | --- | --- | --- |
| **Min/Max** | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :check_mark: | :check_mark: |
| **Static List** | :cross_mark: | :cross_mark: | :check_mark: | :cross_mark: | :check_mark: | :cross_mark: | :cross_mark: |
| **Dynamic List** | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :cross_mark: | :cross_mark: |

---