v0.12.0
Minor Changes
-
f001a3d: Make
acrm_valuewritable with the obvious four-column INSERT (issue #51). The schema previously requiredattribute_type(already known fromacrm_attribute) andactive_from(mechanical bookkeeping), so the natural query failed with a validation error and new developers hit the wall on their first direct write.-
acrm_value.attribute_typeis removed. The type lives onacrm_attribute— join when you need it (acrm-queryskill has the canonical pattern). The two internal read sites that pulledattribute_typefromacrm_value(the dedupe flow'sloadActiveValues/loadInboundRefs) now JOIN toacrm_attribute. -
acrm_value.active_fromis now Lix-defaulted tolix_timestamp(). Writers don't have to pass it.idwas already defaulted tolix_uuid_v7().
The naive insert from the issue now works:
INSERT INTO acrm_value (object_slug, record_id, attribute_slug, value_json) VALUES ('people', 'person_1', 'name', '{"full_name":"Ada Lovelace"}');
normalized_key/ref_object/ref_record_idstay as nullable indexed columns onacrm_value— direct-SQL writers still populate them for unique-keyed attrs and record-references (documented in theacrm-queryskill). -