notes
Rich text notes with file attachments.
Status codes
| Status | ID | Color |
|---|---|---|
| Draft | 0 | green |
| Feedback required | 1 | orange |
| In revision | 2 | green |
| Awaiting approval | 3 | orange |
| Final | 4 | black |
| Obsolete | 5 | black |
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | integer | Note ID | ||
fork forks.ID | integer | Fork ID (`null` for base module) | ||
owneruser users.ID | integer | Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
ownergroup groups.ID | integer | Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
creator | integer | Creator user ID (defaults to authenticated user on creation) | ||
assigneduser users.ID | integer | Assigned user ID | ||
creationdate | bigint | date_part('epoch', now()) | Creation date and time as a Unix timestamp (defaults to current date and time on creation) | |
lastmodified | bigint | date_part('epoch', now()) | Last modification date and time as a Unix timestamp (auto-reset on modification) | |
binfile binfiles.ID | integer | Binary file ID; is read-only (not for `PUT` or `PATCH`) | ||
visibility | smallint | 0 | Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED) | |
name | text | Name | ||
status | smallint | 0 | Status (`0`=DRAFT, `1`=FEEDBACKREQUIRED, `2`=INREVISION, `3`=AWAITINGAPPROVAL, `4`=FINAL, `5`=OBSOLETE) | |
contenttype | text | '' | Content MIME type (RFC 2045) | |
text | text | '' | Plain text version of content | |
attachments | text[] | Array-encoded attachments (filenames) | ||
description | text | '' | Detailed general description |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_notes_assigneduser | gin | assigneduser | ||||
| fk_notes_binfile | btree | binfile | ||||
| fk_notes_fork | gin | fork | ||||
| fk_notes_ownergroup | gin | ownergroup | ||||
| fk_notes_owneruser | gin | owneruser | ||||
| i_notes_nofork | gin | fork | ||||
| i_notes_noowner | gin | ownergroup | ||||
| pk_notes | btree | ID | ||||
| s_notes_name | gin | name |
| Name | Type |
|---|---|
| c_notes_owner | check |
| dc_notes_contenttype | check |
| dc_notes_description | check |
| dc_notes_name | check |
| dc_notes_status | check |
| dc_notes_text | check |
| dc_notes_visibility | check |
| fk_notes_assigneduser | foreign_key |
| fk_notes_binfile | foreign_key |
| fk_notes_fork | foreign_key |
| fk_notes_ownergroup | foreign_key |
| fk_notes_owneruser | foreign_key |
| pk_notes | primary_key |
Loading...