Data Types

AtroCore supports various data types for entity fields and attributes. Each data type has specific characteristics and use cases. Understanding these data types helps you design effective entity structures and ensures data integrity.

Identifiers

Each entity record has a unique ID, which is set automatically when a new record is created. AtroCore uses UUID v7 identifiers, which we convert to ULIDs.

ID

This type of identifiers allows sorting. This means that the records that were created most recently will be at the top of the table by default.

When creating a record from the user interface, you cannot set your own IDs, but it is possible when creating records by import.

Numeric Data Types

Float

Used for decimal numbers with fractional parts.

Configuration options:

  • Disable null value: Prevents the field from being set to null
  • Database Index: Adds a database index for faster searching/filtering
  • Unique: Field value must be unique within the entity
  • Measure: Unit of measurement for the field value
  • Min, Max: Minimum and maximum allowed values
  • Amount of digits after comma: Number of decimal places to display
  • Default: Sets a default value for the field

Float Range

Defines a range of decimal values with minimum and maximum bounds. Useful for setting acceptable value ranges.

Configuration options:

  • Database Index: Adds a database index for faster searching/filtering
  • Measure: Unit of measurement for the field value
  • Amount of digits after comma: Number of decimal places to display
  • Default From, Default To: Sets default range values

Integer

Whole numbers without decimal places.

Configuration options:

  • Disable null value: Prevents the field from being set to null
  • Database Index: Adds a database index for faster searching/filtering
  • Unique: Field value must be unique within the entity
  • Measure: Unit of measurement for the field value
  • Min, Max: Minimum and maximum allowed values
  • Disable formatting: Disables number formatting (e.g., thousand separators)
  • Default: Sets a default value for the field

If your data is not truly an integer but a numeric string with a specific format, consider using the String type with a Regex pattern instead of Disable formatting option.

Integer Range

Defines a range of whole numbers with minimum and maximum bounds. Useful for age ranges, quantity limits, etc.

Configuration options:

  • Database Index: Adds a database index for faster searching/filtering
  • Measure: Unit of measurement for the field value
  • Default From, Default To: Sets default range values

Character Data Types

Email

Field only - Not available for attributes

Specifically designed for email addresses with built-in validation.

Configuration options:

  • Database Index: Adds a database index for faster searching/filtering
  • Unique: Field value must be unique within the entity
  • Remove leading and trailing whitespaces: Trims whitespace from the beginning and end of the value
  • Max length: Maximum number of characters allowed
  • Count bytes instead of characters: Counts bytes instead of characters for Max length validation
  • Regex pattern: Regular expression for input validation
  • Default: Sets a default value for the field

HTML

Rich text content with HTML markup support. Allows formatting, links, and embedded content.

Configuration options:

  • Multilingual: Allows field values to be set per language
  • Disable null value: Prevents the field from being set to null
  • Max length: Maximum number of characters allowed
  • Count bytes instead of characters: Counts bytes instead of characters for Max length validation
  • Disable Displayed Text Shortening: Prevents automatic shortening of displayed text
  • Min height (px): Sets the minimum height of the input field in pixels
  • Symbol amount to be displayed: Limits the number of symbols shown in the UI
  • Height (px): Sets the height of the input field in pixels
  • Use iframe in view mode: Displays the field content in an iframe in view mode
  • HTML Sanitizer: Enables HTML sanitization for input
  • Default Value Type: Options: Basic, Script. Determines how the default value is set
  • Default: Sets a default value for the field

Markdown

Text content with Markdown syntax support. Provides lightweight formatting options for documentation and notes.

Configuration options:

  • Multilingual: Allows field values to be set per language
  • Disable null value: Prevents the field from being set to null
  • Count bytes instead of characters: Counts bytes instead of characters for length validation
  • Disable Displayed Text Shortening: Prevents automatic shortening of displayed text
  • Min height (px): Sets the minimum height of the input field in pixels
  • Max height (px): Sets the maximum height of the input field in pixels
  • Symbol amount to be displayed: Limits the number of symbols shown in the UI
  • Default Value Type: Options: Basic, Script. Determines how the default value is set
  • Default: Sets a default value for the field

String

Short text fields for names, titles, and brief descriptions. Limited character count for concise information.

Configuration options:

  • Multilingual: Allows field values to be set per language
  • Disable null value: Prevents the field from being set to null
  • Database Index: Adds a database index for faster searching/filtering
  • Unique: Field value must be unique within the entity
  • Measure: Unit of measurement for the field value
  • Remove leading and trailing whitespaces: Trims whitespace from the beginning and end of the value
  • Max length: Maximum number of characters allowed
  • Count bytes instead of characters: Counts bytes instead of characters for Max length validation
  • Regex pattern: Regular expression for input validation
  • Default Value Type: Options: Basic, Script. Determines how the default value is set
  • Default: Sets a default value for the field

Text

Long-form text content for descriptions, notes, and detailed information. Supports multi-line content.

Configuration options:

  • Multilingual: Allows field values to be set per language
  • Disable null value: Prevents the field from being set to null
  • Max length: Maximum number of characters allowed
  • Count bytes instead of characters: Counts bytes instead of characters for Max length validation
  • Disable Displayed Text Shortening: Prevents automatic shortening of displayed text
  • Symbol amount to be displayed: Limits the number of symbols shown in the UI
  • Minimum number of rows of textarea: Sets the minimum number of rows for textarea input
  • Maximum number of rows of textarea: Sets the maximum number of rows for textarea input
  • Use disabled textarea in view mode: Displays the field as a disabled textarea in view mode
  • Default Value Type: Options: Basic, Script. Determines how the default value is set
  • Default: Sets a default value for the field

URL

Web addresses with validation.

Configuration options:

  • Multilingual: Allows field values to be set per language
  • Disable null value: Prevents the field from being set to null
  • Database Index: Adds a database index for faster searching/filtering
  • Unique: Field value must be unique within the entity
  • Max length: Maximum number of characters allowed
  • Count bytes instead of characters: Counts bytes instead of characters for Max length validation
  • Strip: Removes protocol and domain from the URL
  • Default: Sets a default value for the field

Date / Time Data Types

Date

Calendar dates without time information.

Configuration options:

  • Database Index: Adds a database index for faster searching/filtering
  • Unique: Field value must be unique within the entity
  • Use numeric format: Displays the value using a numeric format (e.g., timestamp)

Date-time

Combined date and time information.

Configuration options:

  • Database Index: Adds a database index for faster searching/filtering
  • Unique: Field value must be unique within the entity
  • Use numeric format: Displays the value using a numeric format (e.g., timestamp)

Reference Data Types

File

References to uploaded files (images, documents, etc).

Configuration options:

  • File Type: Restricts allowed file types for upload - see File Management for details
  • Preview size: Options: Small, Medium, Large. Sets the preview size for files
  • Default: Sets a default value for the field

Language

Field only - Not available for attributes

Single language selection from predefined options.

Configuration options:

  • Disable Empty Value: Prevents the field from being set to an empty value
  • Is sorted (alphabetically): Enables automatic alphabetical sorting of values

Languages

Field only - Not available for attributes

Multiple language selection.

Configuration options:

  • Is sorted (alphabetically): Enables automatic alphabetical sorting of values

Field only - Not available for attributes. Advanced Data Types module enables for attributes as well

Reference to another entity record. Creates relationships between different entities. See Fields and Relations for more details.

Configuration options:

  • Dropdown: Displays the field as a dropdown selection in the UI

List

Single selection from a customizable list of options. Used for categories, statuses, and enumerated values.

Configuration options:

  • List: Specifies the list of selectable values for the field
  • Dropdown: Displays the field as a dropdown selection in the UI
  • Disable Empty Value: Prevents the field from being set to an empty value
  • Default: Sets a default value for the field

Measure

Field only - Not available for attributes

Single selection from a customizable list of measure units.

Configuration options:

  • Measure: Specifies the list of selectable values for the field
  • Dropdown: Displays the field as a dropdown selection in the UI
  • Disable Empty Value: Prevents the field from being set to an empty value
  • Default: Sets a default value for the field

Multi-value List

Multiple selections from a customizable list. Allows multiple categories or tags per record.

Configuration options:

  • List: Specifies the list of selectable values for the field
  • Dropdown: Displays the field as a dropdown selection in the UI
  • Default: Sets a default value for the field

Field only - Not available for attributes

Multiple references to other entity records. Creates relationships between different entities. See Fields and Relations for more details.

Configuration options:

  • Log the change as a record activity: Records changes in this field as Activity

Common configuration options Create no record activity and No recording as modification on the other hand are not available for Multiple link field.

Other Data Types

Array

Array of strings.

Configuration options:

  • Multilingual: Allows field values to be set per language
  • Empty string value is not allowed: Prevents saving an empty string as a value

Boolean

True/false values. Used for flags, toggles, and simple yes/no decisions.

Configuration options:

  • Multilingual: Allows field values to be set per language
  • Disable null value: Prevents the field from being set to null
  • Default: Sets a default value for the field

Enabling Disable null value displays the boolean field or attribute as a checkbox; if not enabled, it appears as a dropdown with options: Null, Yes, No.

Color

Field only - Not available for attributes

Color values with picker interface.

Configuration options:

  • Database Index: Adds a database index for faster searching/filtering
  • Unique: Field value must be unique within the entity
  • Disable Empty Value: Prevents the field from being set to an empty value
  • Default: Sets a default value for the field

Currency List

Field only - Not available for attributes

Legacy: for new fields consider using List or Measure types instead

Single currency selection from predefined options.

Configuration options:

  • Is sorted (alphabetically): Enables automatic alphabetical sorting of values

Script

Available for both fields and attributes with Advanced Data Types module

Custom script-based data type for advanced functionality and calculations.

Configuration options:

  • Multilingual: Allows field values to be set per language
  • Script: Script code to calculate or validate the field value
  • Output Type: Options: Text, Integer, Float, Boolean, Date, Date-time. Specifies the output data type

Common configuration options Required and Read-only are not available for Script field.

For common configuration options available across all or most data types, see Fields and Attributes.

Table of contents