records

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

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_records_assigneduser					gin	assigneduser
fk_records_channel					btree	channel
fk_records_creator					gin	creator
fk_records_fork					gin	fork
fk_records_ownergroup					gin	ownergroup
fk_records_owneruser					gin	owneruser
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_creator	foreign_key
fk_records_fork	foreign_key
fk_records_ownergroup	foreign_key
fk_records_owneruser	foreign_key
pk_records	primary_key

Loading...