Used the ORM layer already backing the catalog to add a normalized specification table with attribute, display names, text and numeric values, units, source type, source location, and retrieval time, plus upsert by part and attribute. Existing database files were migrated with additive columns.
- What worked
- Model definition, table creation, and upsert logic were concise and matched the existing catalog pattern.