Modèle de données¶

erDiagram transcripts ||--o{ reliability_suggestions : "1..N (CASCADE)" transcripts ||--o{ reliability_score_snapshots : "1..N (CASCADE)" transcripts ||--o{ reliability_actions : "1..N (CASCADE)" reliability_suggestions ||--o{ reliability_actions : "1..N (CASCADE)" enriched_segments ||--o{ reliability_suggestions : "0..N (SET NULL)" segments ||--o{ reliability_suggestions : "0..N (SET NULL)" users ||--o{ reliability_corrections_quarantine : "1..N (CASCADE)" reliability_suggestions ||--o{ reliability_corrections_quarantine : "0..N (SET NULL)" transcripts ||--o{ reliability_corrections_quarantine : "0..N (SET NULL)" reliability_suggestions { string id PK string transcript_id FK string enriched_segment_id FK string segment_id FK int segment_index string suggestion_type text original_value text suggested_value text normalized_original text normalized_suggested float confidence_score string source string status string reason_code json evidence_json string dedupe_key string analysis_version datetime created_at datetime updated_at } reliability_actions { string id PK string suggestion_id FK string transcript_id FK string action_type string actor_type string actor_id string idempotency_key json payload_json datetime created_at } reliability_score_snapshots { string id PK string transcript_id FK float global_score float score_places float score_persons float score_acronyms float score_orgs float score_typos int pending_count int validated_count int ignored_count int auto_applied_count string calculation_version datetime created_at } reliability_corrections_quarantine { string id PK string qdrant_point_id UK string user_id FK string source_suggestion_id FK string transcript_id FK string entity_type text original_text text final_text text context_phrase string action int frequency bool promoted_to_canonical datetime quarantine_until datetime created_at datetime updated_at }