Notes

Includes all notes created in Affinity with content, metadata, and mentions. Note transcripts are stored separately in the transcripts table. Name: v1_0.notes Deleted and merged records are covered in Deletes & Merges.

Grant access to the share only to users who are authorized to view all organization data. There are no per-user or per-role visibility filters applied at the share level.

Columns

Column	Description
`id`	The note’s unique identifier
`content`	The note’s content in html
`creator_id`	The ID of the person who created the note
`created_at`	The timestamp of when the note was created
`type`	The categorized type of note: ai-notetaker (AI summary root), ai-notetaker-reply (reply to AI summary), user-reply (reply to any note), interaction (email/meeting/call/chat), or entities (standard note)
`mentions`	Array of person IDs mentioned in the note
`parent_id`	The ID of the parent note if this is a reply or comment
`is_deleted`	Whether the note has been deleted
`last_updated_at`	Timestamp when this record was last updated

Getting Started

Example Queries

V1_0

Changelog

Columns

​Columns

Columns