Semesta Production · sid-modular-production cluster · 1st iteration

Data Catalog — Full ERD

For building a report or dashboard: start on Summary to see how the two data sources connect, then use PostgreSQL or MongoDB to find the exact tables/collections and join columns for your query.

22 Postgres databases 430 tables 31 explicit FKs 9 Mongo databases 160 collections

PostgreSQL — sid-modular-production

MongoDB — same cluster

VERIFIED — confirmed against real data this session INFERRED — naming-convention match only, not checked Click any box to jump to its detail tab.

Connection detail

SourceTargetEvidence
Not diagrammed: MongoDB data_references (65 lookup collections — genders, banks, religions, schools, universities, etc.) is very likely referenced by *_id-suffixed fields across most other domains by naming convention (e.g. gender_id → genders), but that fans out to dozens of plausible targets cluster-wide and none were checked individually — see the MongoDB tab for the full collection list.

Everything above is INFERRED unless labeled VERIFIED or FK. Source markdown: docs/*.md, README.md. This is a first iteration — not final; the project owner will provide the authoritative relationship set next.

FK — explicit constraint VERIFIED — checked against real rows TEAM — confirmed by the owning service team INFERRED — naming/type match only

Relationship detail

FromToEvidence

Arrow points from the referencing table/column to the referenced table key. Layout is force-directed and computed client-side — drag a table to untangle a busy graph, scroll to zoom, drag the canvas to pan, click a table to filter the detail table below. Source markdown: erd/tables/<database>.md. Raw match-rate evidence: schema-inventory/postgres/_final_table_relationships.json. Cross-database joins: erd/team/ERD-tribe3.md (Learning & Assessment) where noted.

How this connects

SourceTargetEvidence

Collections

Click a tag to filter the list below

Tags above are naming-pattern heuristics (does the collection name contain snapshot, history, log, backup/leading underscore) — not a verified classification. Source: schema-inventory/mongodb/<database>.collections.txt.