Property Investment

Overview

Real estate investment portfolio tracker schema for individual and institutional investors. Models fractional ownership, property valuations, income/expense tracking, and distribution management.

Key Design Decisions

• Fractional Ownership: Multiple investors per property with share-based distributions
• Valuation History: Time-series property valuations for appreciation tracking
• Income/Expense Ledger: Categorized financial records per property for P&L reporting
• Portfolio View: Aggregate metrics across multiple investment properties

Tables

10-14 tables covering investors, properties, property types, ownership shares, valuations, income records, expense records, expense categories, portfolios, portfolio-property mappings, distributions, and documents.