Skip to main content

documents

NameTypeStorageNullableForeign KeysDefault Value & Notes
PKIDintegerplainDocument 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: EXTRACT(epoch FROM now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodifiedbigintplainDefault: EXTRACT(epoch FROM now())Last modification date and time as a Unix timestamp (auto-reset on modification)
visibilitysmallintplainDefault: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
nametextmainName
documentnumtextmainDefault: ''Document number
statussmallintplainDefault: 0Status (`0`=DRAFT, `1`=FEEDBACKREQUIRED, `2`=INREVISION, `3`=AWAITINGAPPROVAL, `4`=FINAL, `5`=OBSOLETE)
filenametextmainDefault: ''Filename
mimetypetextmainDefault: 'application/octet-stream'MIME type (RFC 2045)
publicsmallintplainDefault: 0Publicly accessible
descriptiontextextendedDefault: ''Detailed general description
binfileintegerplainbinfiles.IDBinary file ID; is read-only (not for `PUT` or `PATCH`)
NameUniqueNulls DistinctPrimaryPartialMethodKeys
fk_documents_assigneduserginassigneduser
fk_documents_binfilebtreebinfile
fk_documents_forkginfork
fk_documents_ownergroupginownergroup
fk_documents_owneruserginowneruser
i_documents_noforkginfork
i_documents_noownerginownergroup
pk_documentsbtreeID
s_documents_documentnumgindocumentnum
s_documents_filenameginfilename
s_documents_nameginname
NameType
c_documents_ownercheck
dc_documents_descriptioncheck
dc_documents_documentnumcheck
dc_documents_filenamecheck
dc_documents_namecheck
dc_documents_statuscheck
dc_documents_visibilitycheck
dc_files_mimetypecheck
fk_documents_assigneduserforeign_key
fk_documents_binfileforeign_key
fk_documents_creatorforeign_key
fk_documents_forkforeign_key
fk_documents_ownergroupforeign_key
fk_documents_owneruserforeign_key
pk_documentsprimary_key
Loading...