users

Name	Type	Storage	Foreign Keys	Default Value & Notes
PKID	integer	plain		User ID
creator	integer	plain	users.ID	Creator user ID (defaults to authenticated user on creation)
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)
contact	integer	plain	contacts.ID	Contact ID
activity	smallint	plain		Default: 0Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
name	text	main		Username (case-insensitively unique)
email	text	main		System e-mail address (case-insensitively unique)
nopublic	smallint	plain		Default: 0Deny access to public data
apionly	smallint	plain		Default: 0Restricted to API access, no regular login
expdate	bigint	plain		Expiry date and time as a Unix timestamp
password	text	extended		Default: ''No description provided.
resetlogintoken	bytea	extended		No description provided.
persistentlogintoken	bytea	extended		No description provided.
signature	bytea	extended		No description provided.
description	text	extended		Default: ''No description provided.
otpsecret	bytea	extended		No description provided.
settings	json	extended		No description provided.

Name	Method	Keys
fk_users_contact	btree	contact
pk_users	btree	ID
s_users_email	gin	email
s_users_name	gin	name
u_users_email	btree	lower(email)
u_users_name	btree	lower(name)
u_users_persistentlogintoken	btree	persistentlogintoken

Name	Type
dc_users_activity	check
dc_users_description	check
dc_users_email	check
dc_users_name	check
dc_users_persistentlogintoken	check
dc_users_resetlogintoken	check
dc_users_settings	check
dc_users_signature	check
fk_users_contact	foreign_key
fk_users_creator	foreign_key
pk_users	primary_key

Name	Type	Events	Function	Definition
td_users_internal	before	delete	ft_integrity
tu_users_internal	before	update	ft_integrity