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