Skip to main content

comments

NameTypeStorageNullableForeign KeysDefault Value & Notes
PKIDbigintplainComment ID
creatorintegerplainusers.IDCreator user ID (defaults to authenticated user on creation)
creationdatebigintplainDefault: date_part('epoch', 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)
recordbigintplainrecords.IDRecord ID (**dependency**)
datebigintplainDefault: EXTRACT(epoch FROM now())Designated date and time as a Unix timestamp (defaults to current date and time on creation)
sendertextmainDefault: ''Sender
texttextextendedDefault: ''Comment text (Markdown for rich text representation)
metajsonextendedJSON-encoded metadata (object)
NameUniqueNulls DistinctPrimaryPartialMethodKeys
fk_comments_recordbtreerecord
i_comments_datebtreedate
pk_commentsbtreeID
NameType
dc_comments_metacheck
dc_comments_sendercheck
dc_comments_textcheck
fk_comments_creatorforeign_key
fk_comments_recordforeign_key
pk_commentsprimary_key
Loading...