hr._payslip_template
Schema: hr
English table: hr._payslip_template
Italian original table: hr._cedolino_template
Description: Payslip PDF template configuration used by the parser. Defines template metadata and parsing behavior.
Overview
- Columns: 6
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 1
- Indexes: 2
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
pst_id | cedtempl_id | integer | NO | Logical template identifier (unique per tenant). | |
pst_description | cedtempl_descrizione | character varying(50) | NO | Template description/name. | |
pst_is_cu | cedtempl_cu | boolean | NO | If true, the template refers to CU (Certificazione Unica) layout/variant. | |
pst_has_non_consecutive_pages | cedtempl_pagine_non_consecutive | boolean | NO | If true, the template may include non-consecutive pages when parsing multi-page PDFs. | |
tenant_id | tenant_id | integer | YES | Tenant identifier (multi-tenant isolation). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_pst_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr._payslip_marker | fk_psm_payslip_template | psm_payslip_template_id, tenant_id | pst_id, tenant_id |
Constraints
- Primary key:
_payslip_template_pkey→id - Unique:
uk_pst_id_tenant→pst_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx__payslip_template_tenant | NO | btree | tenant_id |
idx__payslip_template_tenant_pst_id | NO | btree | tenant_id, pst_id |
Navigation
- Back to main index
- [Back to
hrindex]../)