Includes all notes created in Affinity with content, metadata, and mentions. Note transcripts are stored separately in the transcripts table.
Name: notes
Grant access to the Snowflake 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 |
