hr.expense_note_currencies

Schema: hr
English table: hr.expense_note_currencies
Italian original table: hr.in_notaspese_valute
Description: Currencies used in the expense note module (multi-tenant).

Overview

• Columns: 7
• 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.
enc_id	nsv_id	integer	NO		Logical currency identifier (unique per tenant).
enc_description	nsv_description	character varying(100)	NO		Currency description/name.
enc_code	nsv_abbr	character varying(3)	NO		Currency code (3 chars, typically ISO 4217).
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields (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_enc_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.expense_note_lines	fk_enl_currency_id	enl_currency_id, tenant_id	enc_id, tenant_id
hr.person_wallet_ledger	fk_pwl_currency_id	pwl_currency_id, tenant_id	enc_id, tenant_id

Constraints

• Primary key: pk_expense_note_currencies → id
• Unique: uk_enc_id_tenant → enc_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_expense_note_currencies_enc_id_tenant	NO	btree	tenant_id, enc_id) WHERE (_deleted = false
idx_expense_note_currencies_tenant	NO	btree	tenant_id

Navigation

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