CSKE ER Diagram Visual Index

Progressive-disclosure architecture visuals · delivery v2.0.1 · diagram set v2.0.0 · generated 2026-08-25

Current database baseline: cske_dev PostgreSQL 18.4; exact committed 0360/0361/0362/0363; observed 2026-08-25 08:58:53-04 · ARCHITECTURE VISUAL DELIVERY WORKING DRAFT — NO NEW REPORTING OR MUTATION AUTHORITY

Snapshot reconciliation: The accepted 2026-08-24 Mermaid package remains labeled POST_0356_VERIFIED_PENDING_MASTER_CONTROL. It is preserved as point-in-time evidence and is not silently relabeled. Current visuals represent POST_0363_ACCEPTED / 0364 NOT_RUN, 703 tables and 1,475 physical FKs; 0364 was absent at the read-only census.
Filters subject, detailed, and accepted-family entries. Press / to focus search.

How to read a detailed ER diagram

PK
Primary key: the column or columns that uniquely identify one row.
FK
Foreign key: a database-enforced link from a row to its parent table.
UQ
Unique: duplicate values are prohibited for the identified column set.
Nullable ?
The column may be empty. On a relationship, many → 0..1 means the parent link is optional; many → 1 means it is required.
Logical relationship
A dashed amber link supported by architecture meaning, naming, or a view dependency but not enforced as an ordinary PostgreSQL foreign key. It must not be treated as physically guaranteed.

Keyboard: use Tab to move through controls; in the diagram viewer use +/− to zoom, arrow keys to pan, 0 to reset, and Esc to return.

Start here — database-wide map

A nontechnical overview of the ten content areas and their physically enforced cross-domain relationships.

PNG · source

Current subject maps

Annual Reports and Town Meeting

100 tables

source
Family maps (44)
cske.atm_article_*sourcecske.atm_budget_*sourcecske.atm_control_*sourcecske.atm_election_*sourcecske.atm_meeting_*sourcecske.atm_motion_*sourcecske.atm_parliamentary_*sourcecske.atm_recommendation_*sourcecske.atm_ref_*sourcecske.atm_reference_*sourcecske.atm_revolving_*sourcecske.atm_source_*sourcecske.atm_vote_*sourcecske.atm_warrant_*sourcecske.atr_blu_*sourcecske.atr_extraction_*sourcecske.atr_fin_*sourcecske.atr_hhs_*sourcecske.atr_hr_*sourcecske.atr_hwy_*sourcecske.atr_layout_*sourcecske.atr_mapping_*sourcecske.atr_overlap_*sourcecske.atr_page_*sourcecske.atr_prc_*sourcecske.atr_ps_*sourcecske.atr_pw_*sourcecske.atr_repeated_*sourcecske.atr_report_*sourcecske.atr_resource_*sourcecske.atr_sch_*sourcecske.atr_structure_*sourcecske.atr_tc_*sourcecske.atr_text_*sourcecske.atr_topic_*sourcecske.atr_validation_*sourcecske_atr.change_*sourcecske_atr.core_*sourcecske_atr.extraction_*sourcecske_atr.municipality_*sourcecske_atr.population_*sourcecske_atr.reconciliation_*sourcecske_atr.report_*sourcecske_atr.schema_*source

BUC, Scenarios and Decision Support

48 tables

source
Family maps (22)
cske.buc_amount_*sourcecske.buc_annual_*sourcecske.buc_asset_*sourcecske.buc_capital_*sourcecske.buc_decision_*sourcecske.buc_evidence_*sourcecske.buc_existing_*sourcecske.buc_governance_*sourcecske.buc_operating_*sourcecske.buc_professional_*sourcecske.buc_property_*sourcecske.buc_public_*sourcecske.buc_quality_*sourcecske.buc_request_*sourcecske.buc_reused_*sourcecske.buc_scenario_*sourcecske.buc_service_*sourcecske.buc_source_*sourcecske.buc_work_*sourcecske.decision_*sourcecske.research_*sourcecske.scenario_*source

Municipal Finance, Accounting and Affordability

200 tables

source
Family maps (36)
cske.acs_*sourcecske.affordability_*sourcecske.cherry_*sourcecske.comp_agreement_*sourcecske.comp_bargaining_*sourcecske.comp_benefit_*sourcecske.comp_contract_*sourcecske.comp_coverage_*sourcecske.comp_entity_*sourcecske.comp_extraction_*sourcecske.comp_labor_*sourcecske.comp_opeb_*sourcecske.comp_pay_*sourcecske.comp_pension_*sourcecske.comp_position_*sourcecske.comp_retirement_*sourcecske.comp_source_*sourcecske.comp_validation_*sourcecske.comp_workforce_*sourcecske.dor_*sourcecske.finrpt_amount_*sourcecske.finrpt_assurance_*sourcecske.finrpt_audit_*sourcecske.finrpt_disclosure_*sourcecske.finrpt_entity_*sourcecske.finrpt_general_*sourcecske.finrpt_measurement_*sourcecske.finrpt_metric_*sourcecske.finrpt_observation_*sourcecske.finrpt_period_*sourcecske.finrpt_ref_*sourcecske.finrpt_reporting_*sourcecske.finrpt_unit_*sourcecske.finrpt_verification_*sourcecske.local_*sourcecske.town_acct_*source

Schools and HWRSD

70 tables

source
Family maps (39)
cske.sch_agreement_*sourcecske.sch_asset_*sourcecske.sch_bargaining_*sourcecske.sch_budget_*sourcecske.sch_business_*sourcecske.sch_chapter70_*sourcecske.sch_class_*sourcecske.sch_compensation_*sourcecske.sch_debt_*sourcecske.sch_district_*sourcecske.sch_document_*sourcecske.sch_enrollment_*sourcecske.sch_facility_*sourcecske.sch_finance_*sourcecske.sch_financial_*sourcecske.sch_governance_*sourcecske.sch_governing_*sourcecske.sch_member_*sourcecske.sch_middle_*sourcecske.sch_msba_*sourcecske.sch_normalization_*sourcecske.sch_official_*sourcecske.sch_operating_*sourcecske.sch_operational_*sourcecske.sch_organization_*sourcecske.sch_placement_*sourcecske.sch_program_*sourcecske.sch_public_*sourcecske.sch_ref_*sourcecske.sch_reserve_*sourcecske.sch_resident_*sourcecske.sch_school_*sourcecske.sch_source_*sourcecske.sch_special_*sourcecske.sch_sped_*sourcecske.sch_staffing_*sourcecske.sch_state_*sourcecske.sch_town_*sourcecske.sch_workforce_*source

Traditional detailed ER views

Subject-sized views show schemas, PK/FK/UQ markers, important columns and types, physical cardinality, selected semantic views and documented logical links.

Annual Reports — typed public safety, public works, school and recreation facts

16 tables · 0 physical FKs · 4 views · 15 logical links

Open reproducible source specification

Accepted v1.0.0 subject/family maps — rendered without changing their snapshot

These SVGs render every Mermaid family block in the accepted package. They remain point-in-time evidence at POST_0356_VERIFIED_PENDING_MASTER_CONTROL.

SubjectFamilyTablesVisualSource
annual-reports-town-meetingcske.atm_article_*5SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_budget_*5SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_control_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_election_*2SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_meeting_*4SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_motion_*2SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_parliamentary_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_recommendation_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_ref_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_reference_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_revolving_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_source_*4SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_vote_*3SVGpreserved Mermaid source
annual-reports-town-meetingcske.atm_warrant_*5SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_blu_*4SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_extraction_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_fin_*10SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_hhs_*3SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_hr_*3SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_hwy_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_layout_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_mapping_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_overlap_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_page_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_prc_*3SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_ps_*5SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_pw_*5SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_repeated_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_report_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_resource_*2SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_sch_*2SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_structure_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_tc_*2SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_text_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_topic_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske.atr_validation_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske_atr.change_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske_atr.core_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske_atr.extraction_*2SVGpreserved Mermaid source
annual-reports-town-meetingcske_atr.municipality_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske_atr.population_*3SVGpreserved Mermaid source
annual-reports-town-meetingcske_atr.reconciliation_*1SVGpreserved Mermaid source
annual-reports-town-meetingcske_atr.report_*3SVGpreserved Mermaid source
annual-reports-town-meetingcske_atr.schema_*1SVGpreserved Mermaid source
assessment-findingscske.assessment_*5SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_amount_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_annual_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_asset_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_capital_*2SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_decision_*2SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_evidence_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_existing_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_governance_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_operating_*3SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_professional_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_property_*2SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_public_*2SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_quality_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_request_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_reused_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_scenario_*2SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_service_*2SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_source_*5SVGpreserved Mermaid source
buc-scenarios-decisionscske.buc_work_*2SVGpreserved Mermaid source
buc-scenarios-decisionscske.decision_*1SVGpreserved Mermaid source
buc-scenarios-decisionscske.research_*2SVGpreserved Mermaid source
buc-scenarios-decisionscske.scenario_*13SVGpreserved Mermaid source
capital-assets-projectscske.cap_*12SVGpreserved Mermaid source
capital-assets-projectscske.capital_*12SVGpreserved Mermaid source
capital-assets-projectscske.capplan_*16SVGpreserved Mermaid source
capital-assets-projectscske.funding_*2SVGpreserved Mermaid source
capital-assets-projectscske.fundlife_*16SVGpreserved Mermaid source
capital-assets-projectscske.grant_*4SVGpreserved Mermaid source
debt-securitiescske.sec_contractual_*1SVGpreserved Mermaid source
debt-securitiescske.sec_debt_*25SVGpreserved Mermaid source
debt-securitiescske.sec_direct_*1SVGpreserved Mermaid source
debt-securitiescske.sec_official_*14SVGpreserved Mermaid source
debt-securitiescske.sec_ref_*3SVGpreserved Mermaid source
debt-securitiescske.sec_security_*7SVGpreserved Mermaid source
municipal-finance-accountingcske.acs_*4SVGpreserved Mermaid source
municipal-finance-accountingcske.affordability_*9SVGpreserved Mermaid source
municipal-finance-accountingcske.cherry_*18SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_agreement_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_bargaining_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_benefit_*4SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_contract_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_coverage_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_entity_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_extraction_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_labor_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_opeb_*2SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_pay_*2SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_pension_*6SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_position_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_retirement_*2SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_source_*3SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_validation_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.comp_workforce_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.dor_*11SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_amount_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_assurance_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_audit_*24SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_disclosure_*36SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_entity_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_general_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_measurement_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_metric_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_observation_*3SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_period_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_ref_*13SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_reporting_*2SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_unit_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.finrpt_verification_*1SVGpreserved Mermaid source
municipal-finance-accountingcske.local_*8SVGpreserved Mermaid source
municipal-finance-accountingcske.town_acct_*34SVGpreserved Mermaid source
parcels-gis-propertycske.gis_card_*27SVGpreserved Mermaid source
parcels-gis-propertycske.gis_parcel_*5SVGpreserved Mermaid source
parcels-gis-propertycske.parcel_*12SVGpreserved Mermaid source
parcels-gis-propertycske.property_*11SVGpreserved Mermaid source
parcels-gis-propertycske_gis.massgis_*5SVGpreserved Mermaid source
parcels-gis-propertycske_wilbraham_gis.gis_card_*27SVGpreserved Mermaid source
parcels-gis-propertycske_wilbraham_gis.map_*3SVGpreserved Mermaid source
parks-recreation-conservationcske.prct_*15SVGpreserved Mermaid source
schools-hwrsdcske.sch_agreement_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_asset_*2SVGpreserved Mermaid source
schools-hwrsdcske.sch_bargaining_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_budget_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_business_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_chapter70_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_class_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_compensation_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_debt_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_district_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_document_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_enrollment_*3SVGpreserved Mermaid source
schools-hwrsdcske.sch_facility_*6SVGpreserved Mermaid source
schools-hwrsdcske.sch_finance_*3SVGpreserved Mermaid source
schools-hwrsdcske.sch_financial_*2SVGpreserved Mermaid source
schools-hwrsdcske.sch_governance_*3SVGpreserved Mermaid source
schools-hwrsdcske.sch_governing_*2SVGpreserved Mermaid source
schools-hwrsdcske.sch_member_*4SVGpreserved Mermaid source
schools-hwrsdcske.sch_middle_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_msba_*2SVGpreserved Mermaid source
schools-hwrsdcske.sch_normalization_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_official_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_operating_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_operational_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_organization_*3SVGpreserved Mermaid source
schools-hwrsdcske.sch_placement_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_program_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_public_*6SVGpreserved Mermaid source
schools-hwrsdcske.sch_ref_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_reserve_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_resident_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_school_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_source_*2SVGpreserved Mermaid source
schools-hwrsdcske.sch_special_*4SVGpreserved Mermaid source
schools-hwrsdcske.sch_sped_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_staffing_*2SVGpreserved Mermaid source
schools-hwrsdcske.sch_state_*2SVGpreserved Mermaid source
schools-hwrsdcske.sch_town_*1SVGpreserved Mermaid source
schools-hwrsdcske.sch_workforce_*1SVGpreserved Mermaid source
shared-core-provenancecske.control_*17SVGpreserved Mermaid source
shared-core-provenancecske.core_*14SVGpreserved Mermaid source
shared-core-provenancecske.evidence_*3SVGpreserved Mermaid source
shared-core-provenancecske.loader_*3SVGpreserved Mermaid source
shared-core-provenancecske.map_*10SVGpreserved Mermaid source
shared-core-provenancecske.reporting_*1SVGpreserved Mermaid source
shared-core-provenancecske.source_*9SVGpreserved Mermaid source