Database Schema

note

Content migrating from alianza-infra/docs/DATABASE_SCHEMA.md

See CoquiTitle Data Model for the ridpr schema.

Public Schema Tables

Core Real Estate

• properties - Central property listings
• catastros - CRIM cadastral records (1.44M records)
• municipios - PR municipalities (78)
• barrios - PR barrios with geometries (902)

Auctions & Legal

• subastas - Judicial property auctions
• cases - Legal case records
• abogados - Attorney directory

Appraisals & Comparables

• tasamax - Property appraisals (100K+)
• properties_comps - Comparable sales links

Listing Sources

• finditpr - FindItPR MLS listings
• clasificados - Clasificados Online
• listings - Unified listing table