{
  "time_frame": [
    {"time_start": "08:00", "time_end": "12:00", "process": 300},
    {"time_start": "13:00", "time_end": "17:00", "process": 400},
    {"time_start": "19:00", "time_end": "22:00", "process": 255}
  ],
  "time_on_page": [
    {"time_min": 30, "time_max": 120}
  ]
}

Redis SET user:activity:{user_id} = "2026-03-26T09:30:00+07:00"
TTL = SESSION_TIMEOUT (mặc định 1 giờ)

Redis GET user:activity:{user_id}
→ Parse thành time.Time
→ Kiểm tra time.Since(lastActive) > SESSION_TIMEOUT
→ Nếu quá hạn: trả về 401 Unauthorized
→ Nếu còn hạn: tiếp tục xử lý request

Redis DEL user:activity:{user_id}
MySQL UPDATE users SET is_logged_in=0, device_token='' WHERE id=?

MySQL (tool_traffic_api)
═══════════════════════════════════════════════════════════════
users (id, email, role, device_token, is_logged_in)
  │
  ├──► campaigns (id, user_id, name, configs)
  │         │
  │         └──► projects (id, campaign_id, user_id, status,
  │                   │     total_process, traffic_type, links,
  │                   │     attribute, geolocation, is_kill)
  │                   │
  │                   ├──► project_details (project_id, date, hour,
  │                   │                     total_process, total_success,
  │                   │                     total_fail, rank)
  │                   │
  │                   └──► project_settings (project_id, server_id)
  │
  ├──► activity_logs (user_id, action, model_name, model_id,
  │                   old_value, new_value, ip_address)
  │
servers (id, name, ip, is_active, limit_process, current_process)
  │
  └──► server_hourly_reports (server_id, report_date, hour_start,
                               process, success, fail, captcha,
                               error, notfound, r_success, r_fail)

system_settings (key, value)
setup_fires (campaign_gg_id, campaign_cc_id)
locations (id, name, region, geolocation)


MongoDB (tool-traffic-api)
═══════════════════════════════════════════════════════════════
proxies (ip, port, rotate_url, is_active, used_count,
         domain_used, proxy_package_id, expired_at)
  │
  ├──► proxy_packages (code, name, price, proxy_provider_id)
  │         │
  │         └──► proxy_providers (name, account, domain)
  │
  └──► proxy_ip_logs (proxy_id, ip, supplier, total)

tasks (project_id→MySQL, traffic_type, status, result_status,
       profile_id, server_id→MySQL, geolocation)

profiles (email, password, is_active, cooldown_end,
          user_agent, screen_resolution, latitude, longitude)
  │
  └──► profile_sessions (profile_id, session_id, is_active, expires_at)

keywords (keyword, status, device, engine, result_num)
  │
  ├──► keyword_results (keyword_id, device, engine, search_data)
  │         └── search_data.ads[]: {url, rank, type, action_status}
  │         └── search_data.search[]: {url, rank, type, action_status}
  │
  └──► keyword_schedules (keyword_id, engine, scan_desktop, scan_mb)

task_logs (keyword, user_agent, link, date)
backup_proxies (host, port, type, is_working, failure_count)
free_proxies (host, port, type, is_working, failure_count)
coccoc_tokens (token{cc_t,uid}, locked, used, success_count)


Redis
═══════════════════════════════════════════════════════════════
user:activity:{user_id}  → last_active_at (TTL: SESSION_TIMEOUT)
lock:cron:{job_name}     → "1" (TTL: job duration)
cache:proxy:{id}         → proxy JSON (TTL: 5 phút)


Cross-Database References
═══════════════════════════════════════════════════════════════
tasks.project_id (MongoDB) ←→ projects.id (MySQL)
tasks.server_id (MongoDB)  ←→ servers.id (MySQL)
tasks.profile_id (MongoDB) ←→ profiles._id (MongoDB)
projects.keyword_id (MySQL) ←→ keywords._id (MongoDB)
proxies.proxy_package_id (MongoDB) ←→ proxy_packages._id (MongoDB)
proxy_packages.proxy_provider_id (MongoDB) ←→ proxy_providers._id (MongoDB)
proxy_ip_logs.proxy_id (MongoDB) ←→ proxies._id (MongoDB)
profile_sessions.profile_id (MongoDB) ←→ profiles._id (MongoDB)
keyword_results.keyword_id (MongoDB) ←→ keywords._id (MongoDB)
keyword_schedules.keyword_id (MongoDB) ←→ keywords._id (MongoDB)