hr.person_equipment_assignments

Schema: hr
English table: hr.person_equipment_assignments
Italian original table: hr.ana_dotazioni
Description: Tracks assignment and return of equipment items to persons (employees).

Overview

• Columns: 13
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 0
• Indexes: 1

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Primary key identifier for the equipment assignment record.
person_equipment_assignment_id	anadot_id	integer	NO		Internal reference ID for the equipment assignment.
person_equipment_person_id	anadot_ana_id	integer	NO		Foreign key referencing the person (employee) who receives the equipment.
person_equipment_equipment_id	anadot_dot_id	integer	NO		Foreign key referencing the equipment item being assigned.
person_equipment_assigned_on	anadot_data_assegnazione	date	NO		Date when the equipment was assigned to the person.
person_equipment_is_returned	anadot_restituito	boolean	NO		Flag indicating whether the equipment has been returned.
person_equipment_returned_on	anadot_data_restituzione	date	NO		Date when the equipment was returned.
person_equipment_return_notes	anadot_note_restituzione	text	NO		Notes or comments regarding the return of the equipment.
person_equipment_is_noncompliant_return	anadot_restituzione_non_conforme	boolean	NO		Flag indicating if the return was non‑compliant (e.g., damaged, incomplete).
person_equipment_expires_on	anadot_data_scadenza	date	NO		Scheduled expiration/return date for the equipment assignment.
tenant_id	tenant_id	integer	YES		Multi‑tenant isolation column. References cloud._tenant.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	JSONB field for custom, tenant‑specific extensions.
_deleted	_deleted	boolean	YES	false	Soft‑delete flag. When true, the record is considered logically deleted.

Relationships

Outgoing foreign keys

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

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_person_equipment_assignments → id
• Unique: uk_person_equipment_assignments_assignment_tenant → person_equipment_assignment_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_peq_tenant	NO	btree	tenant_id

Navigation

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