AutessaDB

Tables and data modeling

AutessaDB tables are typed, related and computed: text, number, select and media columns, foreign keys, AutessaScript computed columns, write-once ledger tables and one-click knowledge bases.

Create a free database

support_tickets8 columnsSAMPLE

idINTEGERsystem

subjectSHORT_TEXTrequired

bodyLONG_TEXTsemantic

prioritySINGLE_SELECTp1 · p2 · p3

labelsMULTI_SELECT

screenshotIMAGE

call_audioAUDIOtranscribed

created_atDATETIMEsystem

-- why it matters

What does tables and data modeling cover?

How AutessaDB models data: typed tables, foreign keys and joins, computed columns, append-only tables and knowledge bases for document search.

A database is only as useful as its shape. AutessaDB gives you typed columns that people, scripts and agents all respect, links between tables, values that compute themselves, tables that can never be rewritten, and a one-click preset for documents.

Who works here

Builders and data owners design tables; teammates add and edit rows in the grid; agents and scripts read and write the same tables through tools and the API.

In one sentence each

Tables and column types · AutessaDB tables have typed columns from Short Text to Audio, with required flags, value limits, select lists and system columns on every row.
Foreign keys and joins · Integer columns can be foreign keys to rows in another table, and join queries follow them with filters, while each joined table keeps its own security.
Computed columns · A computed column runs a short script over the row after each write and stores the answer, recomputing only when the columns it depends on change.
Append-only tables · Append-only tables are write-once: rows can be added and read but never changed or removed, and the setting can be turned on but never off.
Knowledge bases · Drag files or whole folders into a knowledge base and they are indexed for semantic search, with a Create Agent shortcut for a ready-made search agent.

-- subtopics

Everything in tables and data modeling

Tables and column types

AutessaDB tables have typed columns from Short Text to Audio, with required flags, value limits, select lists and system columns on every row.

Foreign keys and joins

Integer columns can be foreign keys to rows in another table, and join queries follow them with filters, while each joined table keeps its own security.

Computed columns

A computed column runs a short script over the row after each write and stores the answer, recomputing only when the columns it depends on change.

Append-only tables

Append-only tables are write-once: rows can be added and read but never changed or removed, and the setting can be turned on but never off.

Knowledge bases

Drag files or whole folders into a knowledge base and they are indexed for semantic search, with a Create Agent shortcut for a ready-made search agent.

-- on screen

What it looks like

Foreign keys and joins

customers3 columnsSAMPLE

idINTEGERPK

nameSHORT_TEXT

regionSINGLE_SELECT

orders3 columnsSAMPLE

idINTEGERPK

customer_idINTEGERFK → customers

totalDECIMAL

join-query resultorders ⋈ customersSAMPLE

orders.id  customers.name       total
5531       Harbor Freight Co.   1,240.00
5534       Larkspur Clinic        318.50
where customers.region = 'west'

Computed columns

contacts · full_name (computed)dependsOn: 2SAMPLE

const first = variables.get("first_name");
const last  = variables.get("last_name");
response.setResponse(`${first} ${last}`);

first_namelast_namefull_namestatus

AnaRuizAna Ruizdone

DevPatelDev Pateldone

MeiChen…COMPUTING

-- faq

Questions about tables and data modeling

What column types does AutessaDB support?

Short Text, Long Text, File, Image, Video, Audio, Integer, Decimal, Boolean, Single Select and Multi Select. Every table also has system columns for id, creation time and last update.

Does AutessaDB support foreign keys?

Yes. An Integer column can be a foreign key to a row in another table, and those columns are always indexed.

What language are computed columns written in?

AutessaScript, the same JavaScript-based language Autessa uses for script tools, with a slimmer context focused on the row.

Can I turn append-only off?

No. Append-only is a one-way latch. You can turn it on for an existing table, but never off, which is what makes it trustworthy.

Is a knowledge base a separate vector database?

No. It is an AutessaDB table pre-configured for document storage and semantic search, so it shares the same security, sharing, triggers and APIs as every other table.

Other areas of AutessaDB

queries_and_apisQueries, APIs and SDKs →One query model everywhere: the same filters, sorts, aggregates and bulk writes work in the builder, the REST API, the CLI, scripts and agent tools.vector_searchSemantic search and AI →Vector search is a column setting, not a second database: flip it on and AutessaDB indexes, enriches and serves every value to people and agents.row_level_securityRow-level security and access →Every read and write, from a person, agent, script, app or API key, passes through the same row rules, column masks and access log.triggersTriggers and pipelines →Row changes become automation: triggers run tools, agents and writes, chain across tables, and leave a full execution history.data_lakeData lake and analytics →A columnar data lake for events, logs, history and exports: bulk loads, partitions, analytical SQL, a semantic layer, plain-language Ask, data agents and archive tiers, all under the same security as your tables.files_and_appsFiles, apps and operations →AutessaDB is also the backbone for files and apps: Drives, app sign-in tables and per-visitor rules, with soft delete as the safety net.

$ autessa autessadb tables create

Tables and data modeling, built into one database.

Use it out of the box, then shape it to how your company works. Tables, the data lake, security and triggers are all the same AutessaDB, from the builder, the API or the CLI.

Create a free database

Read the AutessaDB guide or install the CLI.

100% customizable, code and all

Make AutessaDB fully your own.

Use it out of the box, then change anything. Ask Autobot, Autessa’s AI builder, for a new field, screen, report, workflow or agent and it builds it into your copy of the app. Or open the code and edit it yourself. Nothing is locked: the app, its data and its code are yours.

Start free and make it yours