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