forks

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Fork ID
creator	integer	plain		users.ID	Creator user ID (defaults to authenticated user on creation)
creationdate	bigint	plain			Default: EXTRACT(epoch FROM now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint	plain			Default: EXTRACT(epoch FROM now())Last modification date and time as a Unix timestamp (auto-reset on modification)
group	integer	plain		groups.ID	Group ID
activity	smallint	plain			Default: 0Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
name	text	main			Name
identifier	character varying(200)	main			Unique fork identifier
module	text	main			Canonical module identifier
color	character varying(6)	extended			Default: ''Color code (CSS-style hexadecimal without `#`)
langaliases	json	extended			JSON-encoded language-specific aliases (object); use language code as object key
description	text	extended			Default: ''No description provided.
settings	json	extended			No description provided.

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_creator	foreign_key
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...