hr.users

Schema: hr
English table: hr.users
Italian original table: hr.utenti
Description: Application users (credentials, permissions, profile and related person).

Overview

• Columns: 30
• Primary key: id
• Outgoing foreign keys: 3
• Incoming foreign keys: 3
• Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
usr_id	ut_id	integer	NO		Logical user identifier (unique per tenant).
usr_username	ut_username	character varying(50)	NO		Username.
usr_password	ut_password	text	NO		Password hash or credential payload (implementation-specific).
usr_display_name	ut_nominativo	character varying(100)	NO		Display name / full name shown in UI.
usr_profile_id	ut_tipo	integer	NO		User profile identifier (references user profiles).
usr_email	ut_email	character varying(100)	NO		Email address.
usr_language_id	ut_lng_id	integer	NO		Language identifier.
usr_companies	ut_aziende	character varying(50)	NO		Authorized companies scope (serialized list).
usr_areas	ut_aree	text	NO		Authorized areas scope (serialized list).
usr_groups	ut_gruppi	text	NO		Authorized groups scope (serialized list).
usr_data	ut_dati	text	NO		Additional permissions/data payload (serialized).
usr_apps	ut_appl	text	NO		Enabled applications/modules (serialized list).
usr_password_changed_on	ut_pwd_data	date	NO		Date when password was last changed.
usr_password_expired	ut_pwd_scad	boolean	NO		Password expired flag.
usr_password_valid_days	ut_pwd_day	numeric(3,0)	NO		Password validity duration in days.
usr_ip	ut_ip	text	NO		Last known IP address (or allowed IPs, depending on implementation).
usr_permission	ut_permission	character varying(10)	NO		Permission code / level (implementation-specific).
usr_person_id	ut_ana_id	integer	YES		Related person identifier (references person registry).
usr_status	ut_stato	character varying(250)	NO		User status (implementation-specific text).
usr_last_access	ut_ultimo_accesso	character varying(14)	NO		Last access timestamp (stored as varchar(14), e.g. YYYYMMDDHH24MISS).
usr_app_template	ut_app_template	character varying(30)	NO		Application template / UI preset.
usr_activation_email_sent	ut_mail_attivazione	boolean	NO		Activation email sent flag.
usr_receive_notifications	ut_ricevi_notifiche	boolean	NO		Receive notifications flag.
usr_new_app	ut_nuova_app	integer	NO		New app flag/version selector (implementation-specific).
usr_default_page	ut_page_default	character varying(50)	NO		Default landing page.
usr_has_api_key	ut_apikey	boolean	NO		API key enabled/available flag.
tenant_id	tenant_id	integer	YES		Tenant identifier (multi-tenant isolation).
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields payload (JSON).
_deleted	_deleted	boolean	YES	false	Technical soft-delete flag.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_users_person	usr_person_id, tenant_id	hr.person_registry	pr_id, tenant_id	RESTRICT	CASCADE
fk_users_profile	usr_profile_id, tenant_id	hr.user_profiles	upr_id, tenant_id	RESTRICT	RESTRICT
fk_users_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.user_session	fk_user_session_user	us_user_id, tenant_id	usr_id, tenant_id
hr.user_session_var	fk_user_session_var_user	usv_user_id, tenant_id	usr_id, tenant_id
hr.user_widget	fk_user_widget_user	uw_user_id, tenant_id	usr_id, tenant_id

Constraints

• Primary key: users_pkey → id
• Unique: uk_usr_id_tenant → usr_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_users_tenant	NO	btree	tenant_id
idx_users_usr_id_tenant	NO	btree	tenant_id, usr_id) WHERE (_deleted = false
idx_users_usr_language_id_tenant	NO	btree	tenant_id, usr_language_id) WHERE (_deleted = false
idx_users_usr_person_id_tenant	NO	btree	tenant_id, usr_person_id) WHERE (_deleted = false

Navigation

• Back to main index
• [Back to hr index]../)