Columns & Schema

Columns define the structure of your data. Each column has a type, a display widget, and optional constraints.

Adding a Column

1. Open the File menu
2. Select New Column
3. Choose the column type and configure its properties
4. The column will be added to the current view

All column types (regular, computed, and relationship) are created through the same POST /api/columns endpoint. The presence of specific fields determines the column type:

• Regular column — displayName + widgetType (creates a physical database column)
• Computed column — includes formula field (no database column, evaluated at query time)
• Relationship column — includes targetColumnName + relationshipPath (displays data from a related entity)

Column Types

SchemaStack supports a range of data types:

Type	Description	Widget Examples
String	Short text	Text input
Text	Long text	Textarea, Rich Text editor
Number	Numeric values	Number input
Boolean	True/false	Checkbox, toggle
Date	Date values	Date picker
DateTime	Date and time	DateTime picker
Email	Email addresses	Email input with validation
URL	Web addresses	URL input with validation
Phone	Phone numbers	Phone input with formatting
Currency	Monetary values	Currency input
Percentage	Percentage values	Percentage input
Image	Image files	Image thumbnail, upload
File	File attachments	File link, upload
UUID	Unique identifier	Read-only text

Column Properties

Select a column in the properties panel to configure:

• Name — Display label
• Description — Help text shown to users
• Widget Type — How the data is displayed and edited
• Required — Whether the field must have a value
• Default Value — Pre-filled value for new rows
• Hidden — Hide from the current view without deleting
• Constraints — Validation rules (e.g., Not Blank, Max Length, Email) can be set when creating a column

Reordering Columns

Drag column headers to reorder them. The new order is saved automatically and synced to other users.

Resizing Columns

Drag the right edge of a column header to resize it.

Rich Text Editing

Text columns can use the Rich Text widget, which provides a TipTap-based editor with a formatting toolbar. Supported formatting:

• Bold, Italic, and Strikethrough
• Ordered and unordered lists
• Links
• Inline code and code blocks

Rich text content is stored as HTML. When switching a Text column from a plain textarea to the Rich Text widget, existing plain text is preserved.

File & Image Columns

Image and File columns let you attach files to rows.

• Click the cell to open the upload dialog, or drag and drop a file onto it
• Image columns display a thumbnail preview in the cell. Click the thumbnail to view full size
• Image cropping — After uploading an image, use the built-in cropping tool to adjust the visible area before saving
• File columns display the file name as a link. Click to download
• Automatic cleanup — When you replace a file or image, the old file is automatically removed from storage. Clearing a file cell also removes the stored file

Supported image formats: JPEG, PNG, GIF, WebP, SVG.

Image Mode

Image columns support two modes, configurable via the column's widget options:

• Managed (default) — Images are uploaded through SchemaStack. Thumbnails are pre-generated on upload for fast display. Cell values are stored as JSON with file metadata (key, thumbnail key, file name, MIME type, size).
• URL — The column contains plain image URLs (e.g. https://example.com/photo.jpg). Thumbnails are generated lazily on first view and cached for subsequent requests. Use this mode when your data already contains image URLs from external sources. The cache refreshes weekly, so if an image at the same URL changes, the thumbnail updates within 7 days.

Computed Columns

Computed columns calculate values from other columns using SQL expressions (e.g., price * quantity or CONCAT(first_name, ' ', last_name)). They have no physical database column — values are calculated at query time.

See Computed Columns for full documentation.

Display Groups

Display groups let you combine multiple columns into a single cell, separated by a configurable character (e.g., a space, dash, or comma).

To create a display group:

1. Open the Properties Panel and select a column
2. Click Create Display Group
3. Select the columns to include in the group
4. Set the separator character
5. The grouped columns appear as a single cell in the view

Editing a grouped cell opens a form with each column as a separate field.