VALDERO / ENGINEERING MAPREAD-ONLY SNAPSHOT · 23 NOV 2026

Inside the complete platform

Production Homepoint-db · PostgreSQL 17 · all public tables and declared foreign keys, plus a separate application architecture map.

Interactive structural snapshot only — no customer records, secrets, login, or live database connection.

83public tables
1,574actual table columns
159foreign-key constraints
11public views
83/83RLS enabled

Entire public schema — 83 tables

Every rectangle represents an actual database table. Select one to highlight its foreign keys and display all columns, primary keys and inbound/outbound references. The small relationship lines are muted by default to keep the map readable.

Accounts & identity8 tablesMarketing & analytics10 tablesCRM & relationships15 tablesBilling infrastructure7 tablesProperty evidence5 tablesData lab & imports7 tablesValuation & engine lab19 tablesHistorical & holdouts12 tablesagency_branding_events.agency_id → public.agencies.idagency_product_access.agency_id → public.agencies.idagency_product_access_audit.agency_id → public.agencies.idagent_branding.agent_id → public.agent_profiles.idagent_profiles.agency_id → public.agencies.idagent_testimonials.agency_id → public.agencies.idagent_testimonials.agent_id → public.agent_profiles.idanalytics_journey_exclusions.agency_id → public.agencies.idanalytics_journey_exclusions.agent_id → public.agent_profiles.idanalytics_journey_exclusions.representative_lead_id → public.leads.idanalytics_journey_exclusions.visitor_session_id → public.visitor_sessions.idbilling_account_admins.account_id,agency_id → public.billing_accounts.id,agency_idbilling_account_admins.profile_id,agency_id → public.agent_profiles.id,agency_idbilling_account_audit.account_id → public.billing_accounts.idbilling_account_members.account_id,agency_id → public.billing_subscriptions.account_id,agency_idbilling_account_members.profile_id,agency_id → public.agent_profiles.id,agency_idbilling_accounts.agency_id → public.agencies.idbilling_accounts.owner_profile_id,agency_id → public.agent_profiles.id,agency_idbilling_stripe_events.intent_id → public.billing_stripe_intents.idbilling_stripe_intents.account_id,agency_id → public.billing_accounts.id,agency_idbilling_stripe_intents.account_id → public.billing_accounts.idbilling_stripe_intents.owner_profile_id,agency_id → public.agent_profiles.id,agency_idbilling_subscriptions.account_id,agency_id → public.billing_accounts.id,agency_idcampaign_channel_executions.campaign_id → public.campaigns.idcampaigns.agency_id → public.agencies.idcampaigns.agent_id → public.agent_profiles.idcontact_notes.contact_id → public.contacts.idcontact_notes.created_by_profile_id → public.agent_profiles.idcontact_notes.deleted_by_profile_id → public.agent_profiles.idcontact_properties.added_by_profile_id → public.agent_profiles.idcontact_properties.canonical_property_id → public.canonical_properties.idcontact_properties.contact_id → public.contacts.idcontact_properties.source_lead_id → public.leads.idcontact_tags.agency_id → public.agencies.idcontact_tags.contact_id → public.contacts.idcontact_tags.created_by_profile_id → public.agent_profiles.idcontact_tags.removed_by_profile_id → public.agent_profiles.idcontact_tags.tag_id → public.crm_tags.idcontacts.assigned_agent_id → public.agent_profiles.idcontacts.deleted_by_profile_id → public.agent_profiles.idcontacts.merged_by_profile_id → public.agent_profiles.idcontacts.merged_into_contact_id → public.contacts.idcontacts.original_lead_id → public.leads.idcrm_activities.actor_agent_id → public.agent_profiles.idcrm_activities.canonical_property_id → public.canonical_properties.idcrm_activities.contact_id → public.contacts.idcrm_agent_access_grants.agency_id → public.agencies.idcrm_agent_access_grants.created_by_profile_id → public.agent_profiles.idcrm_agent_access_grants.grantee_profile_id → public.agent_profiles.idcrm_agent_access_grants.owner_agent_id → public.agent_profiles.idcrm_agent_access_grants.revoked_by_profile_id → public.agent_profiles.idcrm_appointments.agency_id → public.agencies.idcrm_appointments.completed_by_profile_id → public.agent_profiles.idcrm_appointments.contact_id → public.contacts.idcrm_appointments.created_by_profile_id → public.agent_profiles.idcrm_appointments.owner_agent_id → public.agent_profiles.idcrm_appointments.canonical_property_id → public.canonical_properties.idcrm_audit_log.actor_agent_id → public.agent_profiles.idcrm_book_management_grants.agency_id → public.agencies.idcrm_book_management_grants.manager_profile_id,agency_id → public.agent_profiles.id,agency_idcrm_book_management_grants.owner_agent_id,agency_id → public.agent_profiles.id,agency_idcrm_calendar_connections.agency_id → public.agencies.idcrm_calendar_connections.owner_agent_id → public.agent_profiles.idcrm_calendar_event_links.agency_id → public.agencies.idcrm_calendar_event_links.appointment_id → public.crm_appointments.idcrm_calendar_event_links.connection_id → public.crm_calendar_connections.idcrm_lead_queue.agency_id → public.agencies.idcrm_lead_queue.canonical_property_id → public.canonical_properties.idcrm_lead_queue.contact_id → public.contacts.idcrm_lead_queue.converted_opportunity_id → public.crm_opportunities.idcrm_lead_queue.last_action_by_profile_id → public.agent_profiles.idcrm_lead_queue.owner_agent_id → public.agent_profiles.idcrm_lead_queue.source_lead_id → public.leads.idcrm_opportunities.agency_id → public.agencies.idcrm_opportunities.canonical_property_id → public.canonical_properties.idcrm_opportunities.contact_id → public.contacts.idcrm_opportunities.created_by_profile_id → public.agent_profiles.idcrm_opportunities.owner_agent_id → public.agent_profiles.idcrm_opportunities.source_lead_id → public.leads.idcrm_opportunities.stage_changed_by_profile_id → public.agent_profiles.idcrm_tags.agency_id → public.agencies.idcrm_tags.created_by_profile_id → public.agent_profiles.idcrm_tasks.agency_id → public.agencies.idcrm_tasks.completed_by_profile_id → public.agent_profiles.idcrm_tasks.contact_id → public.contacts.idcrm_tasks.created_by_profile_id → public.agent_profiles.idcrm_tasks.owner_agent_id → public.agent_profiles.idcrm_tasks.canonical_property_id → public.canonical_properties.iddata_lab_area_suburbs.area_id → public.data_lab_areas.iddata_lab_promotion_attempts.import_run_id → public.property_sales_import_runs.iddata_lab_review_candidates.import_run_id → public.property_sales_import_runs.iddata_lab_sales_staging.area_id → public.data_lab_areas.iddata_lab_sales_staging.import_run_id → public.property_sales_import_runs.iddata_lab_sales_staging.market_id → public.data_lab_markets.idlead_alert_queue.submission_receipt_id → public.public_lead_submissions.idleads.agent_id → public.agent_profiles.idleads.campaign_id → public.campaigns.idleads.canonical_property_id → public.canonical_properties.idleads.contact_id → public.contacts.idleads.visitor_session_id → public.visitor_sessions.idprofile_tuning_ai_analyses.requested_by → public.agent_profiles.idprofile_tuning_ai_analyses.run_id → public.profile_tuning_runs.idprofile_tuning_approvals.approved_by → public.agent_profiles.idprofile_tuning_approvals.revision_id → public.profile_tuning_revisions.idprofile_tuning_approvals.supporting_run_id → public.profile_tuning_runs.idprofile_tuning_batch_members.batch_id → public.profile_tuning_batches.idprofile_tuning_batches.baseline_revision_id → public.profile_tuning_revisions.idprofile_tuning_batches.created_by → public.agent_profiles.idprofile_tuning_batches.revision_id → public.profile_tuning_revisions.idprofile_tuning_cleanup_jobs.performed_by → public.agent_profiles.idprofile_tuning_profiles.active_revision_id → public.profile_tuning_revisions.idprofile_tuning_profiles.created_by → public.agent_profiles.idprofile_tuning_promotions.holdout_run_id → public.profile_tuning_runs.idprofile_tuning_promotions.performed_by → public.agent_profiles.idprofile_tuning_promotions.previous_revision_id → public.profile_tuning_revisions.idprofile_tuning_promotions.profile_id → public.profile_tuning_profiles.idprofile_tuning_promotions.revision_id → public.profile_tuning_revisions.idprofile_tuning_property_results.run_id → public.profile_tuning_runs.idprofile_tuning_revisions.approved_by → public.agent_profiles.idprofile_tuning_revisions.based_on_active_revision_id → public.profile_tuning_revisions.idprofile_tuning_revisions.created_by → public.agent_profiles.idprofile_tuning_revisions.parent_revision_id → public.profile_tuning_revisions.idprofile_tuning_revisions.profile_id → public.profile_tuning_profiles.idprofile_tuning_revisions.promoted_by → public.agent_profiles.idprofile_tuning_runs.baseline_revision_id → public.profile_tuning_revisions.idprofile_tuning_runs.batch_id → public.profile_tuning_batches.idprofile_tuning_runs.candidate_revision_id → public.profile_tuning_revisions.idprofile_tuning_runs.created_by → public.agent_profiles.idprofile_tuning_segment_results.run_id → public.profile_tuning_runs.idproperty_sales.ingestion_run_id → public.property_sales_import_runs.idpublic_lead_submissions.agent_id → public.agent_profiles.idpublic_lead_submissions.lead_id → public.leads.idvaluation_market_areas.market_profile_id → public.valuation_market_profiles.idvaluation_profile_versions.market_profile_id → public.valuation_market_profiles.idvaluation_test_cases.market_profile_id → public.valuation_market_profiles.idvaluation_test_results.market_profile_id → public.valuation_market_profiles.idvaluation_test_results.profile_version_id → public.valuation_profile_versions.idvaluation_test_results.test_case_id → public.valuation_test_cases.idvaluation_test_results.test_run_id → public.valuation_test_runs.idvaluation_test_runs.market_profile_id → public.valuation_market_profiles.idvaluation_test_runs.profile_version_id → public.valuation_profile_versions.idvisitor_events.agency_id → public.agencies.idvisitor_events.agent_id → public.agent_profiles.idvisitor_events.campaign_id → public.campaigns.idvisitor_events.canonical_property_id → public.canonical_properties.idvisitor_events.channel_execution_id → public.campaign_channel_executions.idvisitor_events.lead_id → public.leads.idvisitor_events.session_id → public.visitor_sessions.idvisitor_sessions.agency_id → public.agencies.idvisitor_sessions.agent_id → public.agent_profiles.idvisitor_sessions.campaign_id → public.campaigns.idvisitor_sessions.canonical_property_id → public.canonical_properties.idvisitor_sessions.channel_execution_id → public.campaign_channel_executions.idvisitor_sessions.lead_id → public.leads.idagenciesPK: id · 15 colsagencies: 15 columns, ~2 rowsagent_profilesPK: id · 24 colsagent_profiles: 24 columns, ~15 rowsagent_brandingPK: id · 13 colsagent_branding: 13 columns, ~2 rowsagent_testimonialsPK: id · 14 colsagent_testimonials: 14 columns, ~14 rowsdemo_requestsPK: id · 19 colsdemo_requests: 19 columns, ~3 rowsagency_branding_eventsPK: id · 8 colsagency_branding_events: 8 columns, ~0 rowsagency_product_accessPK: agency_id · 10 colsagency_product_access: 10 columns, ~0 rowsagency_product_access_auditPK: change_id · 8 colsagency_product_access_audit: 8 columns, ~0 rowscampaignsPK: id · 20 colscampaigns: 20 columns, ~28 rowscampaign_channel_executionsPK: id · 13 colscampaign_channel_executions: 13 columns, ~13 rowsvisitor_sessionsPK: id · 56 colsvisitor_sessions: 56 columns, ~1,226 rowsvisitor_eventsPK: id · 30 colsvisitor_events: 30 columns, ~1,879 rowsleadsPK: id · 42 colsleads: 42 columns, ~172 rowslead_alert_queuePK: id · 33 colslead_alert_queue: 33 columns, ~174 rowspublic_lead_submissionsPK: id · 9 colspublic_lead_submissions: 9 columns, ~30 rowsanalytics_internal_devicesPK: id · 8 colsanalytics_internal_devices: 8 columns, ~2 rowsanalytics_excluded_networksPK: id · 8 colsanalytics_excluded_networks: 8 columns, ~0 rowsanalytics_journey_exclusionsPK: id · 14 colsanalytics_journey_exclusions: 14 columns, ~28 rowscontactsPK: id · 32 colscontacts: 32 columns, ~35 rowscontact_notesPK: id · 11 colscontact_notes: 11 columns, ~5 rowscontact_propertiesPK: id · 15 colscontact_properties: 15 columns, ~32 rowscrm_activitiesPK: id · 12 colscrm_activities: 12 columns, ~95 rowscrm_audit_logPK: id · 12 colscrm_audit_log: 12 columns, ~213 rowscrm_agent_access_grantsPK: id · 11 colscrm_agent_access_grants: 11 columns, ~1 rowscrm_tagsPK: id · 9 colscrm_tags: 9 columns, ~1 rowscontact_tagsPK: id · 9 colscontact_tags: 9 columns, ~0 rowscrm_tasksPK: id · 18 colscrm_tasks: 18 columns, ~2 rowscrm_appointmentsPK: id · 21 colscrm_appointments: 21 columns, ~7 rowscrm_opportunitiesPK: id · 20 colscrm_opportunities: 20 columns, ~4 rowscrm_lead_queuePK: id · 24 colscrm_lead_queue: 24 columns, ~82 rowscrm_calendar_connectionsPK: id · 14 colscrm_calendar_connections: 14 columns, ~0 rowscrm_calendar_event_linksPK: id · 13 colscrm_calendar_event_links: 13 columns, ~0 rowscrm_book_management_grantsPK: id · 8 colscrm_book_management_grants: 8 columns, ~0 rowsproperty_salesPK: record_id · 58 colsproperty_sales: 58 columns, ~168,132 rowsproperty_sales_canonical_identi…PK: canonical_identity · 2 colsproperty_sales_canonical_identity_claims: 2 columns, ~293,439 rowscanonical_propertiesPK: id · 18 colscanonical_properties: 18 columns, ~57 rowsproperty_sales_stagingPK: no PK defined · 48 colsproperty_sales_staging: 48 columns, ~0 rowsproperty_sales_import_20260520_allPK: no PK defined · 48 colsproperty_sales_import_20260520_all: 48 columns, ~0 rowsaccuracy_check_inputPK: no PK defined · 34 colsaccuracy_check_input: 34 columns, ~0 rowsrecent_90_day_test_holdoutPK: no PK defined · 21 colsrecent_90_day_test_holdout: 21 columns, ~0 rowsvaluation_market_profilesPK: id · 11 colsvaluation_market_profiles: 11 columns, ~1 rowsvaluation_profile_versionsPK: id · 10 colsvaluation_profile_versions: 10 columns, ~1 rowsvaluation_market_areasPK: id · 16 colsvaluation_market_areas: 16 columns, ~3 rowsvaluation_test_casesPK: id · 20 colsvaluation_test_cases: 20 columns, ~0 rowsvaluation_test_runsPK: id · 11 colsvaluation_test_runs: 11 columns, ~0 rowsvaluation_test_resultsPK: id · 14 colsvaluation_test_results: 14 columns, ~0 rowsprofile_tuning_profilesPK: id · 12 colsprofile_tuning_profiles: 12 columns, ~5 rowsprofile_tuning_revisionsPK: id · 19 colsprofile_tuning_revisions: 19 columns, ~33 rowsprofile_tuning_batchesPK: id · 17 colsprofile_tuning_batches: 17 columns, ~31 rowsprofile_tuning_batch_membersPK: batch_id, property_sale_key · 7 colsprofile_tuning_batch_members: 7 columns, ~3,100 rowsprofile_tuning_runsPK: id · 27 colsprofile_tuning_runs: 27 columns, ~33 rowsprofile_tuning_property_resultsPK: id · 20 colsprofile_tuning_property_results: 20 columns, ~2,580 rowsprofile_tuning_segment_resultsPK: id · 9 colsprofile_tuning_segment_results: 9 columns, ~467 rowsprofile_tuning_approvalsPK: id · 8 colsprofile_tuning_approvals: 8 columns, ~0 rowsprofile_tuning_promotionsPK: id · 10 colsprofile_tuning_promotions: 10 columns, ~1 rowsprofile_tuning_ai_analysesPK: id · 16 colsprofile_tuning_ai_analyses: 16 columns, ~0 rowsprofile_tuning_cleanup_jobsPK: id · 6 colsprofile_tuning_cleanup_jobs: 6 columns, ~0 rowsdata_lab_marketsPK: id · 9 colsdata_lab_markets: 9 columns, ~1 rowsproperty_sales_import_runsPK: id · 21 colsproperty_sales_import_runs: 21 columns, ~41 rowsdata_lab_sales_stagingPK: id · 19 colsdata_lab_sales_staging: 19 columns, ~259 rowsdata_lab_areasPK: id · 12 colsdata_lab_areas: 12 columns, ~11 rowsdata_lab_area_suburbsPK: area_id, suburb, postcode · 6 colsdata_lab_area_suburbs: 6 columns, ~44 rowsdata_lab_review_candidatesPK: import_run_id, staging_transa · 8 colsdata_lab_review_candidates: 8 columns, ~543 rowsdata_lab_promotion_attemptsPK: id · 10 colsdata_lab_promotion_attempts: 10 columns, ~574 rowsbilling_accountsPK: id · 7 colsbilling_accounts: 7 columns, ~0 rowsbilling_subscriptionsPK: account_id · 10 colsbilling_subscriptions: 10 columns, ~0 rowsbilling_account_adminsPK: account_id, profile_id · 3 colsbilling_account_admins: 3 columns, ~0 rowsbilling_account_membersPK: profile_id · 5 colsbilling_account_members: 5 columns, ~0 rowsbilling_account_auditPK: change_id · 8 colsbilling_account_audit: 8 columns, ~0 rowsbilling_stripe_intentsPK: id · 19 colsbilling_stripe_intents: 19 columns, ~0 rowsbilling_stripe_eventsPK: event_id · 7 colsbilling_stripe_events: 7 columns, ~0 rowsarchive_leads_pre_20260706PK: no PK defined · 40 colsarchive_leads_pre_20260706: 40 columns, ~854 rowsarchive_lead_alert_queue_pre_20…PK: no PK defined · 19 colsarchive_lead_alert_queue_pre_20260706: 19 columns, ~123 rowsjeff_area_blind_holdoutPK: no PK defined · 48 colsjeff_area_blind_holdout: 48 columns, ~975 rowsjeff_area_restore_backupPK: no PK defined · 48 colsjeff_area_restore_backup: 48 columns, ~969 rowsjeff_enriched_stagingPK: no PK defined · 47 colsjeff_enriched_staging: 47 columns, ~1,235 rowsjeff_candidate_exports_20260626…PK: no PK defined · 20 colsjeff_candidate_exports_20260626_raw: 20 columns, ~1,937 rowsjeff_candidate_exports_20260626PK: no PK defined · 20 colsjeff_candidate_exports_20260626: 20 columns, ~1,937 rowsjeff_candidate_property_sales_m…PK: no PK defined · 22 colsjeff_candidate_property_sales_matches_20260626: 22 columns, ~14 rowsjeff_candidate_property_sales_m…PK: no PK defined · 22 colsjeff_candidate_property_sales_matches_20260626_safe: 22 columns, ~876 rowsproperty_sales_jeff_before_enri…PK: no PK defined · 48 colsproperty_sales_jeff_before_enrichment_restore_20260701: 48 columns, ~969 rowsjeff_area_blind_holdout_workingPK: no PK defined · 49 colsjeff_area_blind_holdout_working: 49 columns, ~975 rowsjeff_holdout_production_exclusi…PK: no PK defined · 12 colsjeff_holdout_production_exclusion_groups: 12 columns, ~1,041 rows
Tip: on a phone, scroll the diagram and tap any table. Use the search field to jump directly to a specific table. All 159 FKs, including those targeting auth.users, are listed under “All 159 relationships”.

End-to-end application architecture

Conceptual system map grounded in the checked production database schema and main-branch package dependencies. Solid lines depict the principal data/workflow layers; dashed lines depict library-backed or conceptual service connections, not necessarily confirmed live traffic.

Valdero application architecture diagram from public and admin Next.js experiences through APIs, valuation engine, CRM, Supabase and service integrations
Verified in database83 public tables, RLS flags, campaigns, CRM, analytics, valuation and billing schema.
Verified in repositoryNext.js 16, React 19, Supabase SDK, Resend, Stripe SDK and Google Maps library in package.json.
What it does not proveSDK presence does not prove live integration, deployment health or security. This isn't a code-level call graph.

Every declared foreign key

All 159 individual constraints, including repeated links that use different columns and references to auth.users. Click a record to inspect its source table on the ERD.

What's actually inside each subsystem

These are categories assigned to actual public tables. Approximate rows are metadata estimates; archived, staging and transactional identities aren't necessarily unique customers or properties.