# Notes: Nextcloud Nextcloud Notes ## Documentation Notes of the connected account, one row per note. Insert creates a note, update changes its content, category or favourite flag, delete removes it. Zero rows when the Notes app is not installed. - Catalog: `Notes` - Schema: `Notes` - Primary Keys: `id` - Label: Nextcloud Notes Can retrieve data and change data using insert, update and delete. ## Columns of Table Function The columns of the table function `Notes` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `category` | `varchar2` | | ☐ | Category of the note; empty for an uncategorised note. | | `content` | `varchar2` | | ☐ | Content of the note, in Markdown. | | `etag` | `varchar2` | | ☐ | Entity tag of the note's own content. | | `favorite` | `char` | | ☐ | Whether the note is marked as a favourite. | | `id` | `int64` | | ☑ | Identifier of the note. | | `internal_path` | `varchar2` | | ☐ | Path of the note's own Markdown file, relative to the account's files. | | `is_shared` | `char` | | ☐ | Whether the note is shared with another account. | | `modified` | `datetime` | | ☐ | Moment last modified (UTC). | | `readonly` | `char` | | ☐ | Whether the connected account may not edit the note - true for a note shared with read-only access. | | `title` | `varchar2` | | ☐ | Title of the note. |