Data Types
Anythink supports a wide range of standard database data types, and some custom ones designed to make it really easy to manage specific data types within your business.
Text (Small & Large)
Text is perhaps the standard most basic input type, we support two types of text fields "small text" and "large text".
Small text is stored as a varchar, this allows you to store up to 255 characters. You can display small text as a standard input, or as a multi-select from a set of options that you define.
Large text is stored as a TEXT field and allows you to store larger text content (up to 65,535 characters), and also supports rendering as rich text and markup.
Numbers
Three number types are available:
Integer - Whole numbers from -2,147,483,648 to 2,147,483,647
Big Integer - Large whole numbers from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Decimal - Floating point numbers with configurable precision for financial calculations and measurements
Boolean
Simple true/false values, displayed as checkboxes or toggle switches. Perfect for yes/no questions, feature flags, or status indicators.
Date & Time
Date - Calendar date picker for selecting specific dates
Timestamp - Complete date and time with timezone support for precise temporal data
Advanced Types
JSON - Store complex nested data structures, arrays, and objects. Ideal for configuration data, metadata, or flexible schema requirements.
Geo Coordinates - Latitude and longitude pairs that perfectly integrate with our search functionality and map display functionality within Anythink. Enables location-based queries and geographic visualisations.
Relationships
Beyond standard types, relationships with other entities can be defined:
One-to-One (1:1) - Each record links to exactly one record in another entity
One-to-Many (1:many) - One record can link to multiple records in another entity
Many-to-One (many:1) - Multiple records link to one record in another entity
Many-to-Many (many:many) - Records can link to multiple records bidirectionally
Dynamic Reference - Flexible linking that can reference any entity type
File Management
Files can be attached via a file upload function, which stores files in the file manager with CDN reference for fast global delivery. Configure allowed file types including:
Images - JPG, PNG, GIF, WebP with automatic optimisation
Documents - PDFs, Word Documents, Excel Spreadsheets
All Files - Any file type for maximum flexibility
File uploads include automatic virus scanning, size limits, and public/private access controls.
User Assignment
Users can be directly assigned to records, creating a direct user relationship. This enables ownership tracking, access control, and workflow assignments within your application.