Airtable · Schema

Airtable Table

An Airtable table is a collection of records organized with a defined set of fields and views within a base. Tables define the structure and schema of the data they contain.

ApplicationsCollaborationDataDatabasesLow-CodeProductivitySpreadsheets

Properties

Name Type Description
id string The unique identifier for the table. Table IDs always start with the 'tbl' prefix.
name string The display name of the table.
description stringnull An optional description of the table's purpose and contents.
primaryFieldId string The ID of the primary field for this table. The primary field serves as the main identifier for records.
fields array The field definitions (columns) in the table.
views array The view definitions in the table.
View JSON Schema on GitHub

JSON Schema

airtable-table-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://schemas.airtable.com/table.json",
  "title": "Airtable Table",
  "description": "An Airtable table is a collection of records organized with a defined set of fields and views within a base. Tables define the structure and schema of the data they contain.",
  "type": "object",
  "properties": {
    "id": {
      "type": "string",
      "description": "The unique identifier for the table. Table IDs always start with the 'tbl' prefix.",
      "pattern": "^tbl[a-zA-Z0-9]+$",
      "examples": ["tblABC123def456"]
    },
    "name": {
      "type": "string",
      "description": "The display name of the table."
    },
    "description": {
      "type": ["string", "null"],
      "description": "An optional description of the table's purpose and contents."
    },
    "primaryFieldId": {
      "type": "string",
      "description": "The ID of the primary field for this table. The primary field serves as the main identifier for records.",
      "pattern": "^fld[a-zA-Z0-9]+$"
    },
    "fields": {
      "type": "array",
      "description": "The field definitions (columns) in the table.",
      "items": {
        "$ref": "https://schemas.airtable.com/field.json"
      }
    },
    "views": {
      "type": "array",
      "description": "The view definitions in the table.",
      "items": {
        "$ref": "https://schemas.airtable.com/view.json"
      }
    }
  },
  "required": ["id", "name", "fields", "views"],
  "additionalProperties": false
}