hr._table_relationships
Schema: hr
English table: hr._table_relationships
Italian original table: hr._relazioni_tabelle
Description: Technical metadata table defining relationships between tables and their key/date columns for processing.
Overview
- Columns: 10
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 0
- Indexes: 5
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
tr_relationship_id | reltab_id | integer | NO | Logical relationship identifier (unique per tenant). | |
tr_primary_table | reltab_prima_tabella | character varying(50) | NO | Name of the primary table in the relationship. | |
tr_secondary_table | reltab_seconda_tabella | character varying(50) | NO | Name of the secondary table in the relationship. | |
tr_primary_table_key | reltab_key_primatab | character varying(50) | NO | Key column name used on the primary table. | |
tr_secondary_table_key | reltab_key_secondatab | character varying(50) | NO | Key column name used on the secondary table. | |
tr_secondary_table_date_column | reltab_data_seconda_tab | character varying(50) | NO | Date column name on the secondary table used for temporal logic. | |
tr_secondary_table_primary_key | reltab_primary_key_seconda_tab | character varying(50) | NO | Primary key column name on the secondary table. | |
tr_creates_period | reltab_crea_periodo | boolean | NO | Indicates whether a validity period should be generated for the relationship. | |
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_tr_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_table_relationships→id - Unique:
uk_tr_relationship_tenant→tr_relationship_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_tr_tenant | NO | btree | tenant_id |
idx_tr_tenant_primary | NO | btree | tenant_id, tr_primary_table |
idx_tr_tenant_primary_secondary | NO | btree | tenant_id, tr_primary_table, tr_secondary_table |
idx_tr_tenant_rel | NO | btree | tenant_id, tr_relationship_id |
idx_tr_tenant_secondary | NO | btree | tenant_id, tr_secondary_table |
Navigation
- Back to main index
- [Back to
hrindex]../)