Tables (Database)

The Tables section provides complete database management for your project. You can create tables, add data, edit, and delete.

---

Table List

In the left sidebar you'll see a list of all your tables:

• If you have more than 3 tables, you can search
• Create a new table with the + button
• Delete a table with the trash icon

Warning

Deleting a table also deletes all its data and cannot be undone!

---

Creating a New Table

1. Click the + button in the sidebar
2. Enter the table name (English, no spaces)
3. Define the columns

Data Types

Type	What it stores	Example
TEXT	Text	"Hello World"
INTEGER	Whole numbers	42
NUMERIC	Decimal numbers	3.14
BOOLEAN	True/False	true or false
TIMESTAMP	Date and time	2024-01-15 10:30:00
UUID	Unique identifier	550e8400-e29b-41d4-a716-446655440000
JSONB	JSON data	{"name": "John", "age": 25}

Automatic Columns

These columns are created automatically:

• id: Unique identifier for each row
• created_at: When the row was created
• updated_at: Last edit time

---

Data Management

Search

1. Select the target column from the dropdown
2. Enter your search text
3. Results will be filtered

Pagination

Choose how many rows per page:

• 25
• 50
• 100
• 200

Adding a Row

1. Click the "Add Row" or + button
2. Enter the values
3. Save

Editing a Row

1. Click the pencil icon on the desired row
2. Change the values
3. Save

Deleting a Row

Click the trash icon on the desired row.

---

Exporting Data

You can download data in these formats:

Format	Use case
Excel	Open in Excel
CSV	Simple text format
JSON	For programming

---

Important Notes

Tip

For JSONB columns, always use valid JSON format. For example:

{"key": "value", "number": 123}

Warning

Always backup before deleting a table!