Skip to main content

notes

NameTypeStorageNullableForeign KeysDefault Value & Notes
PKIDintegerplainNote ID
forkintegerplainforks.IDFork ID (`null` for base module)
owneruserintegerplainusers.IDOwner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroupintegerplaingroups.IDOwner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creatorintegerplainusers.IDCreator user ID (defaults to authenticated user on creation)
assigneduserintegerplainusers.IDAssigned user ID
creationdatebigintplainDefault: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodifiedbigintplainDefault: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
visibilitysmallintplainDefault: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
nametextmainName
statussmallintplainDefault: 0Status (`0`=DRAFT, `1`=FEEDBACKREQUIRED, `2`=INREVISION, `3`=AWAITINGAPPROVAL, `4`=FINAL, `5`=OBSOLETE)
contenttypetextextendedDefault: ''Content MIME type (RFC 2045)
texttextextendedDefault: ''Plain text version of content
attachmentstext[]extendedArray-encoded attachments (filenames)
descriptiontextextendedDefault: ''Detailed general description
binfileintegerplainbinfiles.IDBinary file ID; is read-only (not for `PUT` or `PATCH`)
NameUniqueNulls DistinctPrimaryPartialMethodKeys
fk_notes_assigneduserginassigneduser
fk_notes_binfilebtreebinfile
fk_notes_forkginfork
fk_notes_ownergroupginownergroup
fk_notes_owneruserginowneruser
i_notes_noforkginfork
i_notes_noownerginownergroup
pk_notesbtreeID
s_notes_nameginname
NameType
c_notes_ownercheck
dc_notes_contenttypecheck
dc_notes_descriptioncheck
dc_notes_namecheck
dc_notes_statuscheck
dc_notes_textcheck
dc_notes_visibilitycheck
fk_notes_assigneduserforeign_key
fk_notes_binfileforeign_key
fk_notes_creatorforeign_key
fk_notes_forkforeign_key
fk_notes_ownergroupforeign_key
fk_notes_owneruserforeign_key
pk_notesprimary_key
Loading...