Feature: has_parent_id

Table of Contents

This page is one authored MASD feature in ORE Studio Variability Model § "Projection configuration: how an existing artefact family is shaped". Any profile that fixes this feature's value links here rather than restating its effect.

Identity

Field Value
Literal name :has_parent_id:
Bundle ores.sql.schema
Type bool
Default false

Effect

Tells the ores.sql.schema facet to generate a <product>_<component>_<entity_plural>_hierarchy_fn(p_tenant_id, p_root_id, p_from_root) recursive-CTE function that walks the entity's self-referencing tree, so consumers never hand-write their own recursive query. See Codegen entity meta-model — SQL § "Hierarchy: has_parent_id" for the worked counterparty example and what the generated function does and does not cover.

Structural consequence

None directly on the entity's own columns — the function is generated independently of whether the self-referencing FK column exists. Two other properties become meaningful once this feature is set, :parent_id_column: and :hierarchy_name_field:, but both are themselves structural (they name real columns), not features; see Codegen entity meta-model — SQL.

Used by

See also

Emacs 29.3 (Org mode 9.6.15)