Inspect the current database and app relationships.

This view shows the live server-side backend, relational table structures, collection counts, connection settings, and the main application-level relationships between records.

Tables and collections

Each store below shows its active tables, row counts, and schema details. The portal store also includes the JSON-backed application collections currently kept in kv_store.

Visual table relationships

This diagram shows the current PostgreSQL tables and the main relationships the application already uses across identity, master data, operational data, and analytics.

Current app-level relationships

These relationships are currently enforced by application logic rather than full physical PostgreSQL foreign-key constraints.