records

Module: main

Activity feed records with comments, files, and monitor entries.

Meta data

You can utilize the meta column to store additional meta data about the site or element you are referencing - this works similar to Twitter Cards or Facebook's Open Graph API.

The following attributes are supported

Parameter name	Description
url	The website URL
site	The website name
title	The website title
description	Content description
image	Preview image
video	Embedded video
icon	Icon for external application 16x16px

Monitor entries

Records are also being used to store information about changes that occured with the related object. Those records are flagged as "Monitor entry" (flag: 3)

The record text represents the changeset that occured. The text value consists of the following elements:

Text

{ACTION} {entity} {index} {name}

For instance, when an object (in the following example a "task") is created, ZeyOS automatically creates a record with the following text:

Text

CREATE tasks 123 Sample task

The following action labels exist:

• CREATE
• MODIFY
• DELETE
• ACTIVATE
• DEACTIVATE
• ARCHIVE
• RESTORE

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Record ID
fork forks.ID	integer			Fork ID (`null` for base module); inherited from entity
owneruser users.ID	integer			Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroup groups.ID	integer			Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creator	integer			Creator user ID (defaults to authenticated user on creation)
assigneduser users.ID	integer			Assigned user (recipient) ID; must be distinct from `creator`
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
entity	t_entity			Canonical entity
index	integer			Entity ID; is required if `entity` is not `null`, otherwise must be `null`
channel channels.ID	integer			Channel ID
flag	smallint		0	Flag (`0`=REGULAR, `1`=ASSOCONLY, `2`=MINDLOGONLY, `3`=MONITOR, `4`=FEED); must be REGULAR or FEED if `entity` is `null`
date	bigint		date_part('epoch', now())	Designated date and time as a Unix timestamp (defaults to current date and time on creation)
stickydate	bigint			Sticky date and time as a Unix timestamp
sender	text		''	Sender
location	text		''	Location (e.g. coordinates)
text	text		''	Record text (Markdown for rich text representation)
meta	json			JSON-encoded metadata (object)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_records_assigneduser					gin	assigneduser
fk_records_channel					btree	channel
fk_records_fork					gin	fork
fk_records_ownergroup					gin	ownergroup
fk_records_owneruser					gin	owneruser
i_records_creator					gin	creator
i_records_date					btree	date
i_records_entity_index					btree	entity, index
i_records_noowner					gin	ownergroup
i_records_stickydate					btree	stickydate
pk_records					btree	ID
s_records_sender					gin	sender
s_records_text					gin	text

Name	Type
c_records_association	check
c_records_owner	check
dc_records_flag	check
dc_records_location	check
dc_records_meta	check
dc_records_sender	check
dc_records_text	check
fk_records_assigneduser	foreign_key
fk_records_channel	foreign_key
fk_records_fork	foreign_key
fk_records_ownergroup	foreign_key
fk_records_owneruser	foreign_key
pk_records	primary_key

Loading...