hr.inventory_movements

Schema: hr
English table: hr.inventory_movements
Italian original table: hr.in_articoli_magazzino
Description: Inventory movements — stock in/out operations for warehouse items.

Overview

• Columns: 10
• Primary key: id
• Outgoing foreign keys: 2
• Incoming foreign keys: 0
• Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
im_id	artma_id	integer	NO		Logical identifier of the inventory movement (unique per tenant).
im_item_id	artma_art_id	integer	NO		Reference to the inventory item.
im_date	artma_data	date	NO		Movement date.
im_type	artma_tipo	character varying(2)	NO		Movement type (e.g. IN, OUT).
im_quantity	artma_quantita	numeric(6,2)	NO		Movement quantity.
im_report_id	artma_rap_id	integer	NO		Reference to related report (rap).
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_im_item	im_item_id, tenant_id	hr.inventory_items	itm_id, tenant_id	RESTRICT	RESTRICT
fk_tenant_id	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: inventory_movements_pkey → id
• Unique: uk_im_id_tenant → im_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_inventory_movements_im_item_id_tenant	NO	btree	tenant_id, im_item_id) WHERE (_deleted = false
idx_inventory_movements_im_id_tenant	NO	btree	tenant_id, im_id) WHERE (_deleted = false
idx_inventory_movements_im_report_id_tenant	NO	btree	tenant_id, im_report_id) WHERE (_deleted = false
idx_inventory_movements_tenant	NO	btree	tenant_id

Navigation

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