Each base can contain multiple tables. A table is a structured data storage method used to store collections of related data within a base.

Each table typically contains multiple rows and columns, where each column represents a field and its attributes, while each row represents a record or data item. Tables are core components of bases, used for collecting, storing, and processing data for subsequent retrieval, manipulation, and base construction.

Teable’s tables are equivalent to tables in a database, a concept that helps understand the differences between Teable and traditional spreadsheets for better mastery of Teable.

​
Adding Tables

  1. Enter a specific base
  2. Click the + button in the directory

You can choose to:

  1. Create a new table
  2. Import a table from a CSV file
  3. Import a table from an Excel file

For specific import processes, see the Import section

​
Modifying Table Names

  1. In the application, double-click the table name in the directory
  2. Modify the table name
  3. Click any area outside the input box

​
Deleting Tables

  1. Hover over the table in the directory, click the ”…” button to open the menu
  2. Click the delete button in the menu

​
Trash

Click the trash button in the upper left of the base to enter the table trash interface and perform the following operations.

Table data in the trash can still be accessed by database connections

  • Empty trash: Permanently delete all table data
  • Restore: Restore tables back to the base

​
Designing Tables

Click the design button in the menu to enter the table design page, where you can view the table’s basic properties, including:

Table Related

  • Base Schema the table belongs to
  • Table name and its name in the physical table
  • Table description
  • Modification time

Database Connection

This shows how to directly access the current database through database connections

  • Database connection
  • Number of database connections

Field Information

Detailed field properties

  • id: Field ID
  • name: Field name
  • dbFieldName: Field name in the physical database
  • type: Field type
  • description: Field description
  • graph: View current field dependencies
  • cellValueType: Current field value type
  • isLookup: Whether it’s a field looked up from a linked table
  • isMultipleCellValue: Whether it’s an array value field
  • isComputed: Whether it’s a computed field (record values of computed fields cannot be modified)
  • isPending: Whether it’s in calculation
  • hasError: Whether there are calculation errors
  • notNull: Whether non-null validation is enabled
  • unique: Whether unique value validation is enabled

​
Ways to Access Tables

Users can access tables in three ways:

Views are the most intuitive of these methods. Users can search, manipulate, and build complex applications through various views.

Newly added tables will default to include a Grid View for users to quickly start processing data.

​
Table Features

Creating Views: Users can create various views to operate on tables, with different views meeting different scenario needs. For example: Grid views have the highest data density and operate similar to spreadsheets, making them the easiest to learn. While Kanban provides better support for project management scenarios.

Previous
Import
Next