users

Module: admin

User accounts with authentication and session management.

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

Name	Unique	Nulls Distinct	Primary	Partial	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)

Name	Type
dc_users_activity	check
dc_users_description	check
dc_users_email	check
dc_users_name	check
dc_users_resetlogintoken	check
dc_users_settings	check
dc_users_signature	check
fk_users_contact	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

Loading...