Expand description
DDL statements for the Macrame bitemporal schema as specified in §4.
Constants§
- ABORT_
DELETE_ GUARD - ABORT_
MONOTONIC_ RA - ABORT_
SINGLE_ OPEN - ANALYSIS_
LIMIT - The row cap that makes
ANALYZEbudgetable. - ANALYZE
- Refresh the query planner’s statistics (0.12.4, D-149).
- ARCHIVE_
SESSION_ MARKER - Marker table probed by the delete guards (D-008 revised).
- CREATE_
ANALYTICS_ ANNOTATIONS_ TABLE - Derived analytics output, keyed by concept and label (§5.4, D-041).
- CREATE_
CONCEPTS_ FTS - The keyword half of hybrid search: an FTS5 index over concept text (§5.9).
- CREATE_
CONCEPTS_ GUARD_ DELETE - The concepts delete guard, marker-gated since v9 (0.9.0, C2, D-126).
- CREATE_
CONCEPTS_ LOG_ INSERT - The concepts insert log trigger, marker-gated since v10 (0.9.0, C3).
- CREATE_
CONCEPTS_ TABLE - The
conceptsledger table (§4.1). - CREATE_
INDICES - Every index the schema declares.
- CREATE_
LINKS_ CURRENT_ TABLE - CREATE_
LINKS_ TABLE - CREATE_
TRANSACTION_ LOG_ TABLE - CREATE_
TRIGGERS - Every trigger the schema declares.
- OPTIMIZE
- Re-analyse only what has gone stale (0.12.4, D-149).
- REBUILD_
CONCEPTS_ FTS - Reconstruct the FTS index from
concepts(§5.9, D-036). - VERIFY_
CONCEPTS_ FTS - FTS5’s own consistency check — and it cannot see the failure that matters (§5.9, D-071).
- WEIGHT_
CHECK - Table-level CHECK on
links.weight(§4.7, T2.1, D-083).
Functions§
- create_
embeddings_ index - The DiskANN index over a model’s vectors.
- create_
embeddings_ table - The per-model embedding table (§4.1, D-005), for a validated model name.