Phishing Guard

Tables (5)

AnalysisAction (Untitled5)

  • analysis_id (Key) — INT — Primary key — NOT NULL
  • action_no (Key2) — INT — Primary key — NOT NULL
  • report_id (Key4) — INT — Foreign key → PhishingReport.report_id — NOT NULL
  • analyst_id (Key3) — INT — Foreign key → Analyst.analyst_id — NOT NULL
  • result_type (Field3) — VARCHAR(30) — NOT NULL
  • risk_level (Field4) — VARCHAR(20) — NOT NULL
  • confidence_score (Field5) — DECIMAL(5,2)
  • analyzed_at (Field6) — DATETIME — NOT NULL
  • analysis_comment (Field7) — TEXT
  • action_type (Field8) — VARCHAR(50) — NOT NULL
  • action _detail (Field9) — TEXT
  • action_status (Field10) — VARCHAR(20) — NOT NULL
  • action_time (Field11) — DATETIME — NOT NULL
  • completed_at (Field12) — DATETIME

Analyst (Untitled4)

  • analyst_id (Key) — INT — Primary key — NOT NULL
  • analyst_name (Field) — VARCHAR(50) — NOT NULL
  • analyst_email (Field2) — VARCHAR(100) — NOT NULL
  • analyst_phone (Field3) — VARCHAR(20)
  • position (Field4) — VARCHAR(50) — NOT NULL
  • department_name (Field5) — VARCHAR(100) — NOT NULL
  • department_phone (Field6) — VARCHAR(20)
  • department_location (Field7) — VARCHAR(100)
  • is_available (Field8) — BOOLEAN — NOT NULL

PhishingReport (Untitled3)

  • report_id (Key) — INT — Primary key — NOT NULL
  • reporter_id (Key2) — INT — Foreign key → Reporter.reporter_id — NOT NULL
  • email_id (Key3) — INT — Foreign key → SuspiciousEmail.email_id — NOT NULL
  • report_reason (Field3) — VARCHAR(255) — NOT NULL
  • report_status (Field4) — VARCHAR(20) — NOT NULL
  • priority (Field5) — VARCHAR(20) — NOT NULL
  • reported_at (Field6) — DATETIME — NOT NULL
  • reporter_comment (Field7) — TEXT
  • attachment_names (Field8) — TEXT
  • attachment_types (Field9) — TEXT
  • attachment_sizes (Field10) — TEXT
  • atttachment_hashes (Field11) — TEXT

Reporter (Untitled)

  • reporter_id (Key) — INT — Primary key — NOT NULL
  • reporter_name (Field) — VARCHAR(50) — NOT NULL
  • reporter_email (Field2) — VARCHAR(100) — NOT NULL
  • reporter_phone (Field3) — VARCHAR(20)
  • reporter_role (Field4) — VARCHAR(20) — NOT NULL
  • department_name (Field5) — VARCHAR(100) — NOT NULL
  • department_phone (Field6) — VARCHAR(20)
  • department_location (Field7) — VARCHAR(100)
  • registered_at (Field8) — DATETIME — NOT NULL

SuspiciousEmail (Untitled2)

  • email_id (Key) — INT — Primary key — NOT NULL
  • sender_address (Field) — VARCHAR(150) — NOT NULL
  • sender_domain (Field2) — VARCHAR(100) — NOT NULL
  • domain_reputation_score (Field3) — INT
  • domain_blacklist_status (Field4) — BOOLEAN — NOT NULL
  • email_subject (Field5) — VARCHAR(255) — NOT NULL
  • received_at (Field6) — DATETIME — NOT NULL
  • body_summary (Field7) — TEXT
  • email_hash (Field8) — VARCHAR(64) — NOT NULL