Home / Schemas
Schemas
The datasets the engine is proved against, and the graph both relation walkers agree on.
The demonstration schema
A production-shaped ERP schema: 34 tables joined by 58 foreign-key relations. It is not a toy, and that matters — positional traversal and the house SELECT agreeing on a three-table question proves considerably less than agreeing on this one.
Runtime-proven The whole thing restores from a single plain-text workspace file: open areas, attached indexes, selected tag orders, aliases, and every declared relation.
Dual carrier
Runtime-proven Teaching schemas ship twice — as x64base tables and as a sealed SQLite copy. The SQLite side is the authority for checking, which is what lets a lesson ask "is the engine right?" and get an answer rather than an assurance.
Teaching datasets
| Form | Purpose |
|---|---|
x64 DBF_64 | The current format: 64-bit headers, wide metadata, 64-bit memo identifiers |
| Classic x32 DBF | The MS-DOS-era baseline, for comparison |
| Visual FoxPro DBF | Field and data-type compatibility, including currency types |
| Reference copy | Known-good values for checking a lab's output |
Because the same data exists in every flavor, "what changed between generations" is something a student can diff rather than take on faith.