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
- value_id generated by gen_random_uuid()
- created_at via onCreate; updated_at via onCreate + onUpdate hooks
- NO deleted_at — values are not soft-deleted; they cascade-delete with their custom_column (deleteRule: cascade)
- Indexed on (custom_column, record_id)
- record_id is the target record’s PUBLIC UUID (root-agnostic join key) — no FK to the underlying entity table
- value shape is written by the enrichment worker: or for amount columns
Example
apps/api/src/database/entities/CustomColumnValue.ts · domain: records / data-views · tier: Infrastructure