hr.equipment_types

Schema: hr
English table: hr.equipment_types
Italian original table: hr.tipi_dotazioni
Description: Definitions of equipment categories and assets (e.g., Laptop, Safety Shoes, Mobile Phone).

Overview

• Columns: 8
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 2
• Indexes: 2

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
eqt_id	tipdo_id	integer	NO		Identifier of the related eqt record.
eqt_description	tipdo_description	character varying(50)	NO		Description text.
eqt_is_mandatory	tipdo_obligatory	boolean	NO		Flags if the equipment type is required for specific roles by default.
eqt_is_biological	tipdo_bio	boolean	NO		Boolean flag.
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	JSON payload containing additional attributes.
_deleted	_deleted	boolean	YES	false	Flag indicating whether the record is soft-deleted.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_tenant_id	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.equipment	fk_equipment_type	eq_type_id, tenant_id	eqt_id, tenant_id
hr.position_equipment_requirements	fk_per_equipment_type	per_equipment_type_id, tenant_id	eqt_id, tenant_id

Constraints

• Primary key: pk_equipment_types → id
• Unique: uk_eqt_id_tenant → eqt_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_eqt_id_tenant	NO	btree	tenant_id, eqt_id) WHERE (_deleted = false
idx_eqt_tenant	NO	btree	tenant_id

Navigation

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