Explore the Airtable API data model

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

Try our interactive ERD Or, browse below

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.

Endpoints

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