Skip to main content
View as Markdown

Field Types

Sovrium provides 49 field types, organized into 9 categories. Every field shares the base field properties (id, name, type, required, unique, indexed) and adds type-specific properties on top.

The 9 Categories

Category Count Field types
Text 6 single-line-text, long-text, rich-text, email, url, phone-number
Numeric 6 integer, decimal, currency, percentage, rating, progress
Date & Time 7 date, datetime, time, duration, created-at, updated-at, deleted-at
Selection 4 checkbox, single-select, multi-select, status
Relational 3 relationship, lookup, rollup
User & Audit 4 user, created-by, updated-by, deleted-by
Attachment / Media 3 single-attachment, multiple-attachments, barcode
Computed & Action 4 formula, count, autonumber, button
Structured & Media 5 json, array, color, code, geolocation
AI 7 ai-generate, ai-summary, ai-categorize, ai-extract, ai-sentiment, ai-tag, ai-translate
Total 49

Quick Summary

Type Category What it stores
single-line-text Text Short single-line text (names, titles, labels).
long-text Text Multi-line plain text (notes, descriptions).
rich-text Text Formatted HTML via a WYSIWYG editor.
email Text Email address with RFC 5322 validation.
url Text Web address with URL validation.
phone-number Text Phone number stored as text (international formats).
integer Numeric Whole numbers with optional min/max.
decimal Numeric Fixed-precision decimals (1–10 places).
currency Numeric Monetary values with ISO 4217 code and formatting.
percentage Numeric Percentage values, displayed with %.
rating Numeric Star/icon rating (max 1–10).
progress Numeric Progress bar 0–100 with optional color.
date Date & Time Calendar date, optional time.
datetime Date & Time Date plus time, timezone-aware.
time Date & Time Time-of-day without a date.
duration Date & Time Elapsed time / work hours.
created-at Date & Time System-set creation timestamp.
updated-at Date & Time System-updated modification timestamp.
deleted-at Date & Time Soft-delete timestamp (NULL = active).
checkbox Selection Boolean true/false.
single-select Selection One option from a list.
multi-select Selection Multiple options from a list.
status Selection Colored workflow states.
relationship Relational Foreign-key link to another table.
lookup Relational A field read from a related record.
rollup Relational Aggregation over related records.
user User/Audit Reference to a user (single or multiple).
created-by User/Audit System-set creating user.
updated-by User/Audit System-set last-modifying user.
deleted-by User/Audit System-set deleting user.
single-attachment Attachment One uploaded file.
multiple-attachments Attachment Many uploaded files.
barcode Attachment Barcode value (product identification).
formula Advanced Computed value from a formula expression.
count Advanced Count of related records.
autonumber Advanced Auto-incrementing number with prefix/padding.
button Advanced Interactive button triggering a URL or automation.
json Advanced Structured JSON data.
array Advanced Array of typed values.
color Advanced Hex color value.
code Advanced Source code with syntax highlighting.
geolocation Advanced Latitude/longitude coordinates.
ai-generate AI AI-generated text from a prompt.
ai-summary AI AI summary of source fields.
ai-categorize AI AI single-category classification.
ai-extract AI AI structured extraction (JSON Schema).
ai-sentiment AI AI sentiment analysis.
ai-tag AI AI multi-tag assignment from an allow-list.
ai-translate AI AI translation to a target language.

Category Pages

Last updated August 11, 2026

Edit this pageReport an issue

This documentation was written with AI, so errors or outdated content are possible. Sovrium is in beta. Contributions and corrections are welcome.

Built with Sovrium