customfields

Module: admin

Custom field definitions for extending entity schemas.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Custom field ID
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		EXTRACT(epoch FROM 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)
activity	smallint		0	Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
name	text			Name
identifier	character varying(200)			Unique field identifier
context	text			Context (mainly entity)
source	smallint		0	Data source (`0`=EXTDATA, `1`=TAGS, `2`=INTERNAL)
reference	text			Data reference (extdata field name or tag name)
indexed	smallint		0	Indexed
type	text		''	Data type
entity	t_entity			Canonical entity; only for `type`=`entity`
options	json			JSON-encoded option values and labels (array or object); only relevant for `type`=`list`
langaliases	json			JSON-encoded language-specific aliases (object); use language code as object key
pattern	text		''

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
pk_customfields					btree	ID
s_customfields_context					gin	context
s_customfields_identifier					gin	identifier
s_customfields_name					gin	name
s_customfields_reference					gin	reference
u_customfields_identifier					btree	identifier

Name	Type
c_customfields_entity	check
c_customfields_type	check
dc_customfields_activity	check
dc_customfields_context	check
dc_customfields_identifier	check
dc_customfields_langaliases	check
dc_customfields_name	check
dc_customfields_options	check
dc_customfields_pattern	check
dc_customfields_reference	check
dc_customfields_source	check
pk_customfields	primary_key
u_customfields_identifier	unique

Loading...