Explore the Airtable Data Model

Pulling data from the Airtable API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SYNCHUB, we not only sync your Airtable API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

What can you do with your Airtable data?

Connect your AI chatbots & agentic workflows

Our Universal MCP Server lets you query your Airtable data using Claude, ChatGPT or your favourite AI tool.

Empower your BI dashboards

Our Airtable Connector connects your Airtable data to favourite reporting tools.

Your business runs on more than just Airtable

We connect to over over 70+ cloud services, letting you manage the data needs of your entire business in a single location.

Endpoints

Browse the data model below, or if you'd prefer, we also have an interactive ERD over here.

Database

Documentation: https://airtable.com/developers/web/api/list-bases

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
PermissionLevel	string	-	-

Record

Documentation: https://airtable.com/developers/web/api/list-bases

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
DatabaseID	string	Database → ID	-
TableID	string	DataTable → ID	-
CreatedTime	datetime	-	-
LastModifiedTime	datetime	-	-
CommentCount	int	-	-

DataTable

Documentation: https://airtable.com/developers/web/api/get-base-schema

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
DatabaseID	string	Database → ID	-
PrimaryFieldID	string	TableView → ID	-

RecordComment

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordRemoteID	string	Record → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
RecordID	string	Record → ID	-
CreatedTime	datetime	-	-
LastUpdatedTime	datetime	-	-
AuthorID	string	-	23 Dec 2025 Foreign Key - Refers to 'User' (not implemented - locked behind Enterprise).
Text	string	-	-
ParentCommentID	string	RecordComment → ID	-

RecordFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordRemoteID	string	Record → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordID	string	Record → ID	-
FieldID	string	TableField → ID	-
StringValue	string	-	-
DateValue	datetime	-	-
BoolValue	boolean	-	-
DecimalValue	decimal	-	-
IntegerValue	int	-	-
UserIDValue	string	-	23 Dec 2025 Foreign Key - Refers to 'User' (not implemented - locked behind Enterprise).

TableView

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableRemoteID	string	DataTable → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
TableID	string	DataTable → ID	-
Type	string	-	-

TableField

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableRemoteID	string	DataTable → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
TableID	string	DataTable → ID	-
Type	string	-	-

RecordCommentReaction

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordCommentRemoteID	string	RecordComment → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordCommentID	string	RecordComment → ID	-
LineNumber	int	-	-
EmojiUnicodeCharacter	string	-	-
ReactingUserID	string	-	23 Dec 2025 Foreign Key - Refers to 'User' (not implemented - locked behind Enterprise).

RecordCommentMentioned

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordCommentRemoteID	string	RecordComment → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordCommentID	string	RecordComment → ID	-
MentionedID	string	-	-
MentionedType	string	-	-
MentionedUserID	string	-	23 Dec 2025 Foreign Key - Refers to 'User' (not implemented - locked behind Enterprise).
MentionedUserGroupID	string	-	23 Dec 2025 Foreign Key - Refers to 'UserGroup' (not implemented - locked behind Enterprise).

RecordFieldValueAttachment

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordFieldValueRemoteID	string	RecordFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
RecordID	string	Record → ID	-
RecordFieldID	string	RecordFieldValue → FieldID	-
Width	int	-	-
Height	int	-	-
Url	string	-	-
Filename	string	-	-
Size	long	-	-
Type	string	-	-

RecordFieldValueBarcode

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordFieldValueRemoteID	string	RecordFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordID	string	Record → ID	-
RecordFieldID	string	RecordFieldValue → FieldID	-
Text	string	-	-
Type	string	-	-

RecordFieldValueLinkedRecord

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordFieldValueRemoteID	string	RecordFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordID	string	Record → ID	-
RecordFieldID	string	RecordFieldValue → FieldID	-
LinkedRecordID	string	-	-

RecordFieldValueRollup

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordFieldValueRemoteID	string	RecordFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordID	string	Record → ID	-
RecordFieldID	string	RecordFieldValue → FieldID	-
LineNumber	int	-	-
RollupValue	string	-	-

RecordFieldValueSelect

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordFieldValueRemoteID	string	RecordFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordID	string	Record → ID	-
RecordFieldID	string	RecordFieldValue → FieldID	-
LineNumber	int	-	-
SelectValue	string	-	-

RecordFieldValueButton

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordFieldValueRemoteID	string	RecordFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordID	string	Record → ID	-
RecordFieldID	string	RecordFieldValue → FieldID	-
Label	string	-	-
Url	string	-	-

RecordFieldValueAIText

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordFieldValueRemoteID	string	RecordFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordID	string	Record → ID	-
RecordFieldID	string	RecordFieldValue → FieldID	-
State	string	-	-
Value	string	-	-
IsStale	boolean	-	-
ErrorType	string	-	-

RecordFieldValueCollaborator

Column	Type	Relates to	Notes
RemoteID	string	-	-
RecordFieldValueRemoteID	string	RecordFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RecordID	string	Record → ID	-
RecordFieldID	string	RecordFieldValue → FieldID	-
CollaboratorID	string	-	23 Dec 2025 Foreign Key - Refers to 'User' (not implemented - locked behind Enterprise).

TableFieldOptionDate

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
DateFormatName	string	-	-
DateFormat	string	-	-

TableFieldOptionSelect

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-

TableFieldOptionNumber

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
Precision	int	-	-

TableFieldOptionCheckbox

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
Icon	string	-	-
Color	string	-	-

TableFieldOptionFormula

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
Formula	string	-	-
IsValid	boolean	-	-
ResultType	string	-	-
ResultPrecision	int	-	-

TableFieldOptionAttachment

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
IsReversed	boolean	-	-

TableFieldOptionDuration

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
DurationFormat	string	-	-

TableFieldOptionCount

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
IsValid	boolean	-	-
RecordLinkFieldID	string	TableField → ID	-

TableFieldOptionRating

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
Icon	string	-	-
Max	int	-	-
Color	string	-	-

TableFieldOptionRecordLink

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
LinkedTableID	string	DataTable → ID	-
IsReversed	boolean	-	-
PrefersSingleRecordLink	boolean	-	-
InverseLinkFieldID	string	TableField → ID	-

TableFieldOptionDateTime

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
TimeZone	string	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
IsValid	boolean	-	-
ResultType	string	-	-
DateFormatName	string	-	-
DateFormat	string	-	-
TimeFormatName	string	-	-
TimeFormat	string	-	-

TableFieldOptionRollup

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-
RecordLinkFieldID	string	TableField → ID	-
FieldIdInLinkedTable	string	TableField → ID	-
IsValid	boolean	-	-
ResultType	string	-	-
ResultPrecision	int	-	-

TableFieldOptionAIText

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldRemoteID	string	TableField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableField → ID	-

TableFieldOptionSelectChoice

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldOptionSelectRemoteID	string	TableFieldOptionSelect → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableFieldOptionSelect → TableFieldID	-
Color	string	-	-

TableFieldOptionFormulaReferencedField

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldOptionFormulaRemoteID	string	TableFieldOptionFormula → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableFieldOptionFormula → TableFieldID	-
LinkedFieldID	string	TableField → ID	-

TableFieldOptionDateTimeReferencedField

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldOptionDateTimeRemoteID	string	TableFieldOptionDateTime → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableFieldOptionDateTime → TableFieldID	-
LinkedFieldID	string	TableField → ID	-

TableFieldOptionRollupReferencedField

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldOptionRollupRemoteID	string	TableFieldOptionRollup → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableFieldOptionRollup → TableFieldID	-
LinkedFieldID	string	TableField → ID	-

TableFieldOptionAITextReferencedField

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldOptionAITextRemoteID	string	TableFieldOptionAIText → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableFieldOptionAIText → TableFieldID	-
LinkedFieldID	string	TableField → ID	-

TableFieldOptionAITextPromptString

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldOptionAITextRemoteID	string	TableFieldOptionAIText → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableFieldOptionAIText → TableFieldID	-
LineNumber	int	-	-
PromptString	string	-	-

TableFieldOptionAITextPromptField

Column	Type	Relates to	Notes
RemoteID	string	-	-
TableFieldOptionAITextRemoteID	string	TableFieldOptionAIText → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TableID	string	DataTable → ID	-
TableFieldID	string	TableFieldOptionAIText → TableFieldID	-
LineNumber	int	-	-
PromptFieldID	string	-	-

Need more?

SYNCHUB lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Airtable data Querying Airtable using regular SQL

Explore the Airtable API data model

See how the various Airtable endpoints relate to each other, using our handy Entity Relationship Diagram