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
- ORE Studio Variability Model — the bundle this feature belongs to.