Communal Computer

Entity 01KSXGGJ4N6E7P9JXS69A1QY7E

One entity of kind participant. HEAD column = current value per catalog attribute (factWithStamp); log = every assertion ever made on this entity, newest first.

14attrs
2assertions
id
participant:01KSXGGJ4N6E7P9JXS69A1QY7E
kind
participant
created_at
created_by
system
state
pending
Read path

HEAD attrs come from Snapshot.factWithStamp(entity, attr) — for each attribute:

SELECT value, asserted_at, asserted_by
FROM current_facts
WHERE entity = 'participant:01KSXGGJ4N6E7P9JXS69A1QY7E' AND attribute = '<attr>'

The log comes from Snapshot.EntityHistory(entity) — one query, no view, ordered:

SELECT attribute, value, asserted_at, asserted_by
FROM facts
WHERE entity = 'participant:01KSXGGJ4N6E7P9JXS69A1QY7E'
ORDER BY asserted_at ASC, id ASC

HEAD attributes (at t=1780597913)

attributetypevaluelast assertedby
auth content text — — —
endpoint content text — — —
first_name content text — — —
is_operator int — — —
kind text — system
last_name content text — — —
lifecycle text — — —
p256dh content text — — —
pid text 27b47f2d1c0877237d3b4271d91ef7c1 system
profile_pixels content blob — — —
status_message content text — — —
tombstoned bool — — —
verified_lat real — — —
verified_lng real — — —

Raw fact log 2 assertions

Every assertion is here forever — the chronicle is append-only. Excised rows are tombstone markers: the value column was set to NULL, but that the fact was asserted at this moment + by this actor stays in the log.

tattributevalueby
pid 27b47f2d1c0877237d3b4271d91ef7c1 system
kind participant system