Column Type Size Nulls Auto Default Children Parents Comments
ID int8 19 null
files.comment fk_files_comment C

Comment ID

creator int4 10 null
users.ID fk_comments_creator N

Creator user ID (defaults to authenticated user on creation)

creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

record int8 19 null
records.ID fk_comments_record C

Record ID (**dependency**)

sender text 2147483647 ''::text


text text 2147483647 ''::text

Comment text (Markdown for rich text representation)

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_comments Primary key Asc ID
fk_comments_record Performance Asc record
i_comments_creationdate Performance Asc creationdate