type: summary
created: Mon Apr 06 2026 02:00:00 GMT+0200 (Central European Summer Time)
updated: Mon Apr 06 2026 02:00:00 GMT+0200 (Central European Summer Time)
sources: raw/articles/unitcycle-database-map.html
tags: database schema architecture

Summary: Database Map

abstract

Full database introspection — all 254 tables, columns, types, relations, indices, and foreign keys. Interactive browsable schema at 1.9MB.

Key Points

Complete schema for the unitcycle_demo PostgreSQL 17 database
254 tables, ~483K rows
All foreign key relationships mapped
Column types, indices, and constraints documented
Interactive browser for exploring table relationships

URL

https://demo.unitcycle.com/assets/docs/unitcycle-database-map.html

Source

raw/articles/unitcycle-database-map.html

Related

wiki/concepts/tech-stack — database details
wiki/concepts/companion-table-pattern — managed=False vs managed=True tables
wiki/summaries/platform-blueprint — architecture companion
wiki/entities/yardi — source of most tables