phishing

Tables (8)

alerts

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • result_id — BIGINT — Foreign key → detection_results.id — NOT NULL
  • is_read — BOOLEAN
  • created_at — DATETIME

daily_statistics

  • target_date — DATE
  • total_scans — INT
  • safe_count — INT
  • suspicious_count — INT
  • danger_count — INT

detection_results

  • id — BIGINT
  • log_id — BIGINT — Foreign key → message_logs.id — NOT NULL
  • extracted_urls — TEXT
  • step2_safebrowsing — ENUM('CLEAN', 'MALICIOUS')
  • step3_xgboost_score — FLOAT
  • step4_kcelectra_intent — VARCHAR(50)
  • final_risk_score — INT — NOT NULL
  • final_risk_grade — ENUM('SAFE', 'SUSPICIOUS', 'DANGER') — NOT NULL
  • llm_response_guide — TEXT
  • analyzed_at — DATETIME

devices

  • device_id — VARCHAR(255)
  • user_id — BIGINT — Foreign key → users.id
  • guest_usage_count — INT

message_logs

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id
  • device_id — VARCHAR(255) — Foreign key → devices.device_id — NOT NULL
  • source_app — VARCHAR(50)
  • sender — VARCHAR(100)
  • is_suspicious_sender — BOOLEAN
  • content — TEXT
  • has_url — BOOLEAN
  • collected_at — DATETIME

user_local_auth

  • user_id — BIGINT — Foreign key → users.id
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL

user_social_auth

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — ENUM('KAKAO', 'NAVER', 'GOOGLE') — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL

users

  • id — BIGINT
  • role — ENUM('USER', 'ADMIN')
  • created_at — DATETIME