> For the complete documentation index, see [llms.txt](https://docs.ondeva.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ondeva.com/data/custom-tables/table-structure.md).

# Table Structure

In Ondeva, **tables define your application's data model**. Think of them as the backbone of your backend — every form, automation, query, or dashboard ultimately connects to data that lives here.

The **Table Structure** view is where you define fields, their types, validations, and behavior. It's also where you configure table-level settings like per-user limits or identifying columns. Ondeva ensures changes are saved instantly, so structure editing is frictionless and production-safe.

### Accessing the Table Structure

To edit a table:

* Navigate to the **Data** tab from the left sidebar.
* Select a table from the list (or create a new one).
* You'll be taken directly to the **Structure** tab — the schema editor for your table.

Here, you'll define columns, choose their types, configure field properties, and manage table-level settings.

### Table Settings

Clicking on an empty space in the **Structure** view reveals general settings for the table in the right-hand panel.

#### Available Table-Level Settings

* **Table Name**\
  Editable directly from the top title bar. The name is persisted across all references (queries, workflows, API exposure).
* **One Entry Per User**\
  When enabled, this restricts each frontend user to a single entry in the table. Ideal for profiles, preferences, or single submissions.

### Working with Fields

Each table is composed of [**fields**](/data/custom-tables/field-types-and-configuration.md) (columns).\
You can:

* Add fields with the "+" button
* Rename by clicking the label
* Reorder by drag-and-drop
* Remove fields via the trash icon

Fields can also be marked as:

* **Identifying Column**: This becomes the default display label across UI components, dropdowns, and table references.

{% hint style="info" %}
Note: Every structural change — adding fields, renaming columns, changing types — is **persisted immediately**. You can refresh or return later and all definitions will remain intact.
{% endhint %}

### Summary

The **Table Structure** area in Ondeva gives you full control over your data model with:

* Instant updates
* Developer-grade validations
* A wide range of input types
* Full support for relationships, geodata, and advanced field logic

Whether you're modeling a CRM, form backend, analytics dashboard, or a marketplace database, your table starts here.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.ondeva.com/data/custom-tables/table-structure.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.