hr.customer_project_activity_groups

Schema: hr
English table: hr.customer_project_activity_groups
Italian original table: hr.in_commesse_attivita_gruppi
Description: Associations between project activities and element groups for classification or visibility.

Overview

• Columns: 7
• Primary key: id
• Outgoing foreign keys: 3
• Incoming foreign keys: 0
• Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Technical primary key (surrogate).
pag_id	comatg_id	integer	NO		Functional identifier for the activity group association.
pag_activity_id	comatg_comat_id	integer	NO		Reference to the project activity (cpa_id).
pag_group_id	comatg_grp_id	integer	NO		Reference to the element group (grp_id).
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	JSON structure for custom fields.
_deleted	_deleted	boolean	YES	false	Technical soft delete flag.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_cust_proj_act_groups_activity_id	pag_activity_id, tenant_id	hr.customer_project_activities	cpa_id, tenant_id	RESTRICT	RESTRICT
fk_cust_proj_act_groups_group_id	pag_group_id, tenant_id	hr.element_groups	eg_id, tenant_id	RESTRICT	RESTRICT
fk_cust_proj_act_groups_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_customer_project_activity_groups → id
• Unique: uk_customer_project_activity_groups_pag_id → pag_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_pag_activity_id_tenant	NO	btree	tenant_id, pag_activity_id) WHERE (_deleted = false
idx_pag_group_id_tenant	NO	btree	tenant_id, pag_group_id) WHERE (_deleted = false
idx_pag_id_tenant	NO	btree	tenant_id, pag_id) WHERE (_deleted = false
idx_pag_tenant	NO	btree	tenant_id

Navigation

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