deepfake
Tables (7)
detection_requests
- id — BIGINT
- request_id — VARCHAR(36) — NOT NULL
- user_id — BIGINT
- source_type — ENUM('url', 'upload', 'file') — NOT NULL
- source_url — TEXT
- file_path — VARCHAR(500)
- original_filename — VARCHAR(255)
- video_duration — DECIMAL(10,2)
- file_size — BIGINT
- video_format — VARCHAR(20)
- status — ENUM('pending', 'processing', 'completed', 'failed')
- progress — INT
- created_at — TIMESTAMP
- started_at — TIMESTAMP
- completed_at — TIMESTAMP
- INDEX — idx_user_created
- INDEX — idx_status
- INDEX — idx_request_id
detection_results
- id — BIGINT
- request_id — VARCHAR(36) — NOT NULL
- final_verdict — ENUM('REAL', 'FAKE', 'UNCERTAIN') — NOT NULL
- confidence_score — DECIMAL(5,2) — NOT NULL
- visual_score — DECIMAL(5,2)
- audio_score — DECIMAL(5,2)
- sync_score — DECIMAL(5,2)
- model_version — VARCHAR(50)
- processing_time — DECIMAL(10,3)
- created_at — TIMESTAMP
- INDEX — idx_verdict
- INDEX — idx_confidence
explainability_data
- id — BIGINT
- request_id — VARCHAR(36) — NOT NULL
- analysis_type — ENUM('gradcam', 'modality', 'attention') — NOT NULL
- heatmap_path — VARCHAR(500)
- focus_regions — JSON
- key_findings — JSON
- timestamp — DECIMAL(10,3)
- INDEX — idx_request_type
modality_analysis
- id — BIGINT
- request_id — VARCHAR(36) — NOT NULL
- modality — ENUM('visual', 'audio') — NOT NULL
- feature_vector — JSON
- anomaly_scores — JSON
- detected_techniques — JSON
- INDEX — idx_request_modality
suspicious_segments
- id — BIGINT
- request_id — VARCHAR(36) — NOT NULL
- start_time — DECIMAL(10,3) — NOT NULL
- end_time — DECIMAL(10,3) — NOT NULL
- segment_type — ENUM('visual', 'audio', 'sync', 'combined') — NOT NULL
- severity — ENUM('low', 'medium', 'high', 'critical') — NOT NULL
- avg_probability — DECIMAL(5,4)
- description — TEXT
- INDEX — idx_request_severity
temporal_analysis
- id — BIGINT
- request_id — VARCHAR(36) — NOT NULL
- timestamp — DECIMAL(10,3) — NOT NULL
- fake_probability — DECIMAL(5,4) — NOT NULL
- visual_prob — DECIMAL(5,4)
- audio_prob — DECIMAL(5,4)
- INDEX — idx_request_timestamp
user_feedback
- id — BIGINT
- request_id — VARCHAR(36) — NOT NULL
- user_id — BIGINT
- is_correct — BOOLEAN
- actual_label — ENUM('REAL', 'FAKE')
- feedback_text — TEXT
- rating — INT
- created_at — TIMESTAMP
- INDEX — idx_request