Assessor_2.0/server/postgres/migrations
Binh 6a784a7626 feat(compliance): direct BSI mapping, ISO/BSI review and hybrid search
Release 2.23.0 (Phase 13F, BSI Grundschutz++ stage 2).

- Map rules directly to BSI Kernel requirements from a dedicated BSI
  corpus in Qdrant; mappings and decisions carry a framework
  (migration 029, verified backup before applying).
- Compare directly accepted BSI requirements with those derived from
  accepted ISO controls (Consistent / Inconsistent / No ISO reference)
  in a new "ISO <-> BSI review" tile in the Client Info Compliance tab,
  with Accept/Reject and "Mark reviewed" per fingerprint.
- Hybrid retrieval for ISO and BSI: German restatement of the public
  query, dense English + dense German + German BM25 fused by
  reciprocal rank; BSI skips BES/DLS/GEB/PERS and sends 16 candidates.
- ISO prompt 1.3.0 gives the model the full ISO/IEC 27002 control text
  (never sent to the browser).
- Auto-accept only the first two strong proposals (primary, high or
  medium confidence).
- Recognize Purple Knight scoped tool ids and SI indicator ids in the
  mapping query.
- Rename Result DB "Map all ISO controls" to "Compliance mapping" with
  ISO and BSI batches; "Mapping history" lists ISO and BSI runs.
- Data Hub BSI tile shows the BSI search index state and can build or
  rebuild it.
- Update AGENTS.md and the implementation plan with these decisions.
2026-10-14 11:54:49 +02:00
..
001_initial_schema.sql Initial import 2026-08-24 09:16:16 +02:00
002_import_fingerprints.sql Initial import 2026-08-24 09:16:16 +02:00
003_ingestion_artifacts_jobs.sql Initial import 2026-08-24 09:16:16 +02:00
004_gpo_ingestion_job.sql Initial import 2026-08-24 09:16:16 +02:00
005_gpo_backup_analysis.sql Initial import 2026-08-24 09:16:16 +02:00
006_artifact_deletion_outbox.sql Initial import 2026-08-24 09:16:16 +02:00
007_unified_result_read_model.sql Initial import 2026-08-24 09:16:16 +02:00
008_result_contract_facets.sql Initial import 2026-08-24 09:16:16 +02:00
009_asset_graph.sql Initial import 2026-08-24 09:16:16 +02:00
010_finding_occurrence_mapping_provenance.sql Initial import 2026-08-24 09:16:16 +02:00
011_microsoft_security_baselines.sql Initial import 2026-08-24 09:16:16 +02:00
012_microsoft_security_baseline_classifications.sql Initial import 2026-08-24 09:16:16 +02:00
013_policy_identity_and_baseline_analysis.sql Initial import 2026-08-24 09:16:16 +02:00
014_environment_profiles_and_policy_snapshots.sql Initial import 2026-08-24 09:16:16 +02:00
015_policy_evaluations.sql Initial import 2026-08-24 09:16:16 +02:00
016_policy_evaluation_rule_catalogs.sql Initial import 2026-08-24 09:16:16 +02:00
017_policy_finding_factory.sql Initial import 2026-08-24 09:16:16 +02:00
018_scanner_environment_context.sql Initial import 2026-08-24 09:16:16 +02:00
019_native_policy_targets.sql GPO Implementierung Testbereit 2026-09-06 20:54:33 +02:00
020_baseline_driven_policy_evaluation.sql GPO Implementierung Testbereit 2026-09-06 20:54:33 +02:00
023_reference_recognition.sql 2.8.6: reference recognition, scanner report first read and CIS section titles 2026-09-26 20:12:33 +02:00
024_result_db_materialization.sql 2.9.0: privacy-compliant Result DB, materialized rows and disclosure policy 3.4.0 2026-09-29 14:29:52 +02:00
025_ai_overview_runs.sql feat: add AI Overview panel and integrate AI overview functionality 2026-10-14 11:51:25 +02:00
026_regulatory_mapping.sql feat: add regulatory mapping panel and hooks for managing regulatory mappings 2026-10-14 11:51:26 +02:00
027_vulnerability_finding_result_type.sql feat(defender-for-iot): introduce vulnerability finding result type 2026-10-14 11:51:31 +02:00
028_scoped_risk_acceptances.sql feat: scoped risk acceptance for Defender devices 2026-10-14 11:52:32 +02:00
029_regulatory_mapping_framework.sql feat(compliance): direct BSI mapping, ISO/BSI review and hybrid search 2026-10-14 11:54:49 +02:00