Machine Learning Feature Engineering Database Schema

Design a PostgreSQL schema optimized for machine learning feature extraction in predictive healthcare modeling. Create tables and relationships that can efficiently store longitudinal patient data, including time-series medical measurements, categorical diagnoses, and complex medical history. Implement advanced indexing strategies that support high-performance feature vector generation, with specific attention to handling sparse medical datasets and enabling rapid feature selection for predictive models.