Data definition with entity relations #5

New issue

Open

opened 2026-07-28 07:18:15 +02:00 by c.fahner · 0 comments

c.fahner commented

2026-07-28 07:18:15 +02:00

Owner

Entities should be able to refer to other entities. Their relationships should show up in the schema so that databases can create the necessary indices.

Various relationships should be taken into account:

one entity having a single unique reference to the id of another
one entity having a collection of references to the id of another (requiring a linker table)
dependencies, where a "subentity" holds a reference to the main entity
bi-directionality, where one entity holds a collection of references and the referenced entities all refer back to the main entity
more...?

An Entity always lives in its own table. Directly nesting an Entity inside a JSON field is out of scope (for now).

Entities should be able to refer to other entities. Their relationships should show up in the schema so that databases can create the necessary indices. Various relationships should be taken into account: * one entity having a single unique reference to the id of another * one entity having a collection of references to the id of another (requiring a linker table) * dependencies, where a "subentity" holds a reference to the main entity * bi-directionality, where one entity holds a collection of references and the referenced entities all refer back to the main entity * more...? An `Entity` always lives in its own table. Directly nesting an `Entity` inside a JSON field is out of scope (for now).

c.fahner added the

Kind/Feature

label

2026-07-28 07:18:15 +02:00

c.fahner added this to the v0.2 milestone

2026-08-20 19:51:15 +02:00