hr._document_templates
Schema: hr
English table: hr._document_templates
Italian original table: hr._doc_template
Description: Document template definitions used for generating and managing HR documents (tenant-scoped).
Overview
- Columns: 14
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 5
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Primary key. | |
dct_template_id | doct_id | integer | NO | Business identifier of the document template. | |
dct_description | doct_description | character varying(100) | NO | Template description. | |
dct_folder | doct_folder | character varying(100) | NO | Storage folder path for the template. | |
dct_filename | doct_filename | character varying(200) | NO | Template output filename. | |
dct_file_template | doct_filetemplate | character varying(100) | NO | Base template file name or template reference. | |
dct_is_attachment | doct_allegato | boolean | NO | Whether the generated document is treated as an attachment. | |
dct_attachment_type_id | doct_tipall_id | integer | NO | Attachment type identifier. | |
dct_requires_confirmation | doct_da_confermare | boolean | NO | Whether the document requires confirmation before use. | |
dct_requires_printing | doct_da_stampare | boolean | NO | Whether the document should be printed. | |
dct_printer_name | doct_stampante | character varying(100) | NO | Default printer name for printing. | |
dct_origin | doct_origin | character varying(25) | NO | Origin or context code used to categorize the template. | |
dct_send_email | doct_invia_email | boolean | NO | Whether the document should be sent by email. | |
tenant_id | tenant_id | integer | YES | Tenant identifier. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk__document_templates_attachment_type | dct_attachment_type_id, tenant_id | hr.attachment_types | atty_id, tenant_id | RESTRICT | RESTRICT |
fk__document_templates_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk__document_templates→id - Unique:
uk_dct_template_id_tenant→dct_template_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_dct_tenant | NO | btree | tenant_id |
idx_dct_tenant_attachment_type | NO | btree | tenant_id, dct_attachment_type_id |
idx_dct_tenant_attachment_type_origin | NO | btree | tenant_id, dct_attachment_type_id, dct_origin |
idx_dct_tenant_origin | NO | btree | tenant_id, dct_origin |
idx_dct_tenant_template | NO | btree | tenant_id, dct_template_id |
Navigation
- Back to main index
- [Back to
hrindex]../)