forks

Module: admin

Database fork configurations for multi-tenant setups.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Fork 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)
group groups.ID	integer			Group ID
activity	smallint		0	Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
name	text			Name
identifier	character varying(200)			Unique fork identifier
module	text			Canonical module identifier
color	character varying(6)		''	Color code (CSS-style hexadecimal without `#`)
langaliases	json			JSON-encoded language-specific aliases (object); use language code as object key
description	text		''
settings	json

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
pk_forks					btree	ID
s_forks_identifier					gin	identifier
s_forks_name					gin	name
u_forks_identifier					btree	identifier

Name	Type
dc_forks_activity	check
dc_forks_color	check
dc_forks_description	check
dc_forks_identifier	check
dc_forks_langaliases	check
dc_forks_module	check
dc_forks_name	check
dc_forks_settings	check
fk_forks_group	foreign_key
pk_forks	primary_key
u_forks_identifier	unique

Name	Type	Events	Function	Definition
tu_forks_module	before	update	ft_integrity

Loading...