Unified Quote Journal (parts_log) v3
- New unified append-only quote log table parts_log replaces three
separate log tables (stock_log, partnumber_log_competitors, lot_log)
- Migrations 042-049: extend supplier, create parts_log/import_formats/
ignore_rules, rework qt_lot_metadata composite PK, add lead_time_weeks
to pricelist_items, backfill data, migrate ignore rules
- New services: PartsLogBackfillService, ImportFormatService,
UnifiedImportService; new world pricelist type (all supplier types)
- qt_lot_metadata PK changed to (lot_name, pricelist_type); all queries
now filter WHERE pricelist_type='estimate'
- Fix pre-existing bug: qt_component_usage_stats column names
quotes_last30d/quotes_last7d (no underscore) — added explicit gorm tags
- Bible: full table inventory, baseline schema snapshot, updated pricelist/
data-rules/api/history/architecture docs
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
5f8aec456b