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