objects

Module: objects

Generic JSON data objects with entity typing.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Object ID
fork forks.ID	integer			Fork ID (`null` for base module)
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 ID
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)
binfile binfiles.ID	integer			Binary file ID; is read-only (not for `PUT` or `PATCH`)
visibility	smallint		0	Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text			Name
entity	text			Custom entity
date	bigint		EXTRACT(epoch FROM now())	Designated date and time as a Unix timestamp (defaults to current date and time on creation)
description	text		''	Detailed general description
data	json			JSON-encoded object data (array or object)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_objects_assigneduser					gin	assigneduser
fk_objects_binfile					btree	binfile
fk_objects_fork					gin	fork
fk_objects_ownergroup					gin	ownergroup
fk_objects_owneruser					gin	owneruser
i_objects_date					btree	date
i_objects_entity					gin	entity
i_objects_nofork					gin	fork
i_objects_noowner					gin	ownergroup
pk_objects					btree	ID
s_objects_name					gin	name

Name	Type
c_objects_owner	check
dc_objects_data	check
dc_objects_description	check
dc_objects_entity	check
dc_objects_name	check
dc_objects_visibility	check
fk_objects_assigneduser	foreign_key
fk_objects_binfile	foreign_key
fk_objects_fork	foreign_key
fk_objects_ownergroup	foreign_key
fk_objects_owneruser	foreign_key
pk_objects	primary_key

Loading...