Schema & Tables

See Python Quickstart — Create a table for a quick introduction.

DDL reference

CREATE HYPEREDGE TABLE <name> (<member_type>)
    [BUCKET_SECONDS <int>]
    [COMPACT_THRESHOLD <int>]

DROP HYPEREDGE TABLE <name>

ALTER TABLE <name> ADD COLUMN <col> <type> [DEFAULT <value>]
ALTER TABLE <name> DROP COLUMN <col>
ALTER TABLE <name> RENAME TO <new_name>

Column types

Type	Description
INTEGER	64-bit signed integer
REAL / FLOAT	64-bit IEEE double
TEXT	Variable-length UTF-8 string

Built-in columns (event_ts, members, weight, mean_dist_m, formation) are always present and cannot be dropped.