01KSQH918VJNBR7509D2S3R5ZEOne entity of kind range. HEAD column = current value per catalog attribute (factWithStamp); log = every assertion ever made on this entity, newest first.
HEAD attrs come from Snapshot.factWithStamp(entity, attr) — for each attribute:
SELECT value, asserted_at, asserted_by
FROM current_facts
WHERE entity = 'range:01KSQH918VJNBR7509D2S3R5ZE' 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 = 'range:01KSQH918VJNBR7509D2S3R5ZE'
ORDER BY asserted_at ASC, id ASC| attribute | type | value | last asserted | by |
|---|---|---|---|---|
after
|
int |
— | — | — |
before
|
int |
— | — | — |
category
|
text |
— | — | — |
description
content
|
text |
— | — | — |
ends_at
|
time |
— | — | — |
kind
|
text |
— | participant:01KSJHM69VCEB59WTFA1D5XYBZ |
|
lat
|
real |
47.617032269329506 | participant:01KSJHM69VCEB59WTFA1D5XYBZ |
|
layer
|
text |
foreground | participant:01KSJHM69VCEB59WTFA1D5XYBZ |
|
lifecycle
|
text |
— | — | — |
lng
|
real |
-122.31918102269579 | participant:01KSJHM69VCEB59WTFA1D5XYBZ |
|
pixels
content
|
blob |
<234432 bytes> | participant:01KSJHM69VCEB59WTFA1D5XYBZ |
|
pixels_h
|
int |
333 | participant:01KSJHM69VCEB59WTFA1D5XYBZ |
|
pixels_w
|
int |
176 | participant:01KSJHM69VCEB59WTFA1D5XYBZ |
|
starts_at
req
|
time |
1779980076 | participant:01KSJHM69VCEB59WTFA1D5XYBZ |
|
title
content
|
text |
Cal Anderson Park | participant:01KSJHM69VCEB59WTFA1D5XYBZ |
|
tombstoned
|
bool |
— | — | — |
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.