Tables

> Define your data schema with typed columns and unique row IDs.

Tables are the foundation of Brickr's database. Each table has a name, a set of columns with defined types, and a unique row_id for identifying individual rows.

Creating a table

1. Navigate to Dashboard > Databases. 2. Click Create Table. 3. Enter a table name (e.g., users, products, orders). 4. Add columns and set their types. 5. Save the table.

Use descriptive, lowercase table names with underscores for readability. For example: order_items, user_settings.

Column types

Each column has a type that determines what data it can hold.

| Column Type | Description | Example Values | |------------|-------------|----------------| | String | Text of any length | "John Doe", "hello@example.com" | | Number | Integer or decimal numbers | 42, 3.14, -10 | | Boolean | True or false | true, false | | Object | JSON objects | {"key": "value"} | | Formatted_Text | Rich text with formatting | HTML or markdown content | | File | File reference | Uploaded document | | Image | Image file reference | Uploaded image | | Date | Calendar date | "2025-01-15" | | Time | Time of day | "14:30" | | URL | Web link | "https://example.com" | | Email | Email address | "user@example.com" |

Array column types

For columns that hold multiple values:

| Column Type | Description | |------------|-------------| | String_Array | List of text values | | Number_Array | List of numbers | | Boolean_Array | List of true/false values | | File_Array | List of file references | | Image_Array | List of image references | | URL_Array | List of URLs | | Email_Array | List of email addresses | | Date_Array | List of dates | | Time_Array | List of times | | Enum_Array | List of enum values |

Row IDs

Every row has a unique row_id string. Brickr generates one automatically when you create a row, but you can also set or edit it yourself as long as it stays unique inside that table.

row_id is the public identifier used by table row nodes, inline row editing, imports, and API flows. Treat it as the stable row reference you pass between nodes.

Editing a table schema

To modify an existing table:

1. Click on the table in the Databases section. 2. Click Edit Schema or use the column header options. 3. Add new columns, rename existing ones, or change types. 4. Save your changes.

Changing a column's type may cause data loss if existing values are not compatible with the new type. Removing a column deletes all data in that column permanently.

Browsing data

The table viewer in the dashboard shows all rows in a spreadsheet-like interface. You can:

• Sort by any column
• Search across all columns
• Edit row IDs inline with uniqueness checks
• Edit individual cell values inline
• Add new rows manually
• Delete rows

What's next?

| Topic | Description | |-------|-------------| | Operations | Query and modify data from your flows | | Relations | Link tables with foreign keys | | Type System | How database types map to builder types |