Internal object. Not currently exposed on the public REST API. The operations below describe the intended contract.
API operations
Data model
Attributes
Relationships
System-computed
- pk โ auto-increment serial integer, internal join key only; never exposed via the public API.
- created_at โ set by MikroORM onCreate hook (onCreate: () => new Date()) at row insertion; not updated on subsequent writes.
- deleted_at โ managed by the soft-delete lifecycle; NULL on creation, set to current timestamp when the pivot link is logically removed. Queries must always filter deleted_at IS NULL to respect soft-delete semantics.
- Note on migration parity gap: the Migration20250919154301.ts DDL created the table with an updated_at timestamptz NULL column, but the entity class declares no @Property for updated_at. The column exists in the database but is unmapped in ORM layer โ it will remain NULL for all rows unless manually backfilled or the entity is amended.
Example
apps/api/src/database/entities/PersonMedia.ts ยท domain: financial-graph ยท tier: Supporting