messagereads

Module: messages

Read receipts for messages by user.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Message-read ID
creator users.ID	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)
message messages.ID	integer			Message ID (**dependency**)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
pk_messagereads					btree	ID
u_messagereads_message_creator					btree	message, creator

Name	Type
fk_messagereads_creator	foreign_key
fk_messagereads_message	foreign_key
pk_messagereads	primary_key
u_messagereads_message_creator	unique

Loading...