The tables MUST be files (place, path, name, ext, size, media_type, mtime, rev, kind, depth), content (the columns of files and text, is_text, redacted), revisions (place, path, rev, size, instant) and places (uri, kind, capabilities, consistency, max_object), each column with a type of int, text, bool or timestamp, and SELECT * MUST give a table's columns in this order; a path in a row MUST be the path in the store, and mtime and instant whole seconds, or no value where the store does not say.
Enforced (check): .github: cd commons/anyfs-query && bun run verify — suite/language.test.ts
Proved by: anyfs-query/suite/language.test.ts
Written in: anyfs-query/src/governance/tables.ts, anyfs-query/src/logical/dialect.ts, anyfs-query/src/logical/media.ts
Tests: passed: suite/language.test.ts each table has the columns and types it is documented with, and SELECT * gives them in ord
Cited by: governance/tables, AnyFS Query, logical/dialect, logical/media