hr._q_data_sync

Schema: hr
English table: hr._q_data_sync
Italian original table: hr._q_sincro_dati
Description: Technical queue table for inbound data synchronization events (raw payloads and processing status).

Overview

• Columns: 14
• 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		Surrogate primary key.
ds_sync_id	sincro_id	integer	NO		Source synchronization identifier (unique per tenant).
ds_inserted_at	sincro_dataora_ins	character varying(14)	NO		Insertion timestamp in YYYYMMDDHH24MISS format (stored as text).
ds_tax_code	sincro_cf	character varying(16)	NO		Tax code (Codice Fiscale) associated with the synchronized data.
ds_source_table	sincro_tabella	character varying(50)	NO		Name of the source table/entity for the synchronized data.
ds_payload	sincro_dati	text	NO		Raw synchronization payload.
ds_is_processed	sincro_elaborato	boolean	NO		Indicates whether the synchronization event has been processed.
ds_result_code	sincro_esito	numeric(1,0)	NO		Processing result code (stored as numeric(1,0)).
ds_processed_at	sincro_dataora_elaborazione	character varying(14)	NO		Processing timestamp in YYYYMMDDHH24MISS format (stored as text).
ds_operation	sincro_operazione	text	NO		Operation performed (as provided by the source).
ds_valid_on	sincro_data_validita	character varying(8)	NO		Validity date in YYYYMMDD format (stored as text).
ds_employment_start_on	sincro_data_inizio_rapporto	character varying(8)	NO		Employment start date in YYYYMMDD format (stored as text).
ds_company_code	sincro_codice_azienda	character varying(10)	NO		Company code provided by the source system.
tenant_id	tenant_id	integer	YES		Tenant identifier for row-level security and data partitioning.

Relationships

Outgoing foreign keys

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

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_q_data_sync → id
• Unique: uk_qds_sync_tenant → ds_sync_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_qds_tenant	NO	btree	tenant_id

Navigation

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