hr.company_announcement_reads
Schema: hr
English table: hr.company_announcement_reads
Italian original table: hr.comunicati_aziendali_link
Description: Read/acknowledgement tracking for company announcements per employment relationship.
Overview
- Columns: 8
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 5
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
car_read_id | comazl_id | integer | NO | Read tracking identifier within the tenant. | |
car_announcement_id | comazl_comaz_id | integer | NO | Announcement identifier (links to company announcements). | |
car_employment_id | comazl_rap_id | integer | NO | Employment relationship identifier of the reader (employment record). | |
car_read_on | comazl_dt_read | date | NO | Date when the announcement was marked as read. | |
tenant_id | tenant_id | integer | YES | Tenant identifier for row ownership and RLS filtering. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Soft-delete flag (technical). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_car_announcement_id | car_announcement_id, tenant_id | hr.company_announcements | ca_announcement_id, tenant_id | RESTRICT | RESTRICT |
fk_car_employment_id | car_employment_id, tenant_id | hr.employment_relationships | er_id, tenant_id | RESTRICT | CASCADE |
fk_car_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_company_announcement_reads→id - Unique:
uk_car_read_tenant→car_read_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_car_tenant | NO | btree | tenant_id |
idx_car_tenant_announcement | NO | btree | tenant_id, car_announcement_id) WHERE (_deleted = false |
idx_car_tenant_announcement_employment | NO | btree | tenant_id, car_announcement_id, car_employment_id) WHERE (_deleted = false |
idx_car_tenant_employment | NO | btree | tenant_id, car_employment_id) WHERE (_deleted = false |
idx_car_tenant_read | NO | btree | tenant_id, car_read_id) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)