comments

Module: main

User comments attached to activity records.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Comment ID
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		EXTRACT(epoch FROM now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
record records.ID	bigint			Record ID (**dependency**)
date	bigint		EXTRACT(epoch FROM now())	Designated date and time as a Unix timestamp (defaults to current date and time on creation)
sender	text		''	Sender
text	text		''	Comment text (Markdown for rich text representation)
meta	json			JSON-encoded metadata (object)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_comments_record					btree	record
i_comments_date					btree	date
pk_comments					btree	ID
s_comments_text					gin	text

Name	Type
dc_comments_meta	check
dc_comments_sender	check
dc_comments_text	check
fk_comments_record	foreign_key
pk_comments	primary_key

Loading...