DANSS

Tables (9)

Attack_data

  • attack_id — SERIAL — Primary key — NOT NULL
  • traffic_id — INTEGER — NOT NULL
  • detected_at — TIMESTAMPTZ — NOT NULL
  • attack_type — VARCHAR(50) — NOT NULL
  • severity — VARCHAR(20) — NOT NULL
  • confidence — NUMERIC(5,2) — NOT NULL — 0%
  • description — TEXT — NOT NULL
  • response_type — VARCHAR(50)
  • responded_at — TIMESTAMPTZ

Block_ip

  • block_id — SERIAL — Primary key — NOT NULL
  • attack_id — INTEGER
  • ip_address — INET — NOT NULL
  • blocked_at — TIMESTAMPTZ — NOT NULL
  • block_reason — VARCHAR(100) — NOT NULL
  • expires_at — TIMESTAMPTZ

Dashboard_events

  • event_id — SERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • details — JSONB
  • event_time — TIMESTAMPTZ — NOT NULL

Incident_reports

  • report_id — SERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • attack_id — INTEGER — NOT NULL
  • summary — TEXT — NOT NULL
  • recommendations — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • sent_email — BOOLEAN — NOT NULL
  • sent_popup — BOOLEAN — NOT NULL

Log_data

  • log_id — SERIAL — Primary key — NOT NULL
  • traffic_id — INTEGER — NOT NULL
  • log_time — TIMESTAMPTZ — NOT NULL
  • log_level — VARCHAR(20) — NOT NULL
  • message — TEXT — NOT NULL
  • metadata — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

Policy_actions

  • action_id — SERIAL — Primary key — NOT NULL
  • attack_id — INTEGER
  • action_type — VARCHAR(50) — NOT NULL
  • target — VARCHAR(100) — NOT NULL
  • triggered_at — TIMESTAMPTZ — NOT NULL
  • executed_at — TIMESTAMPTZ
  • status — VARCHAR(20) — NOT NULL

Sessions

  • session_id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • user_agent — TEXT — NOT NULL
  • ip_address — INET — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • failed_count — INT — NOT NULL

Traffic_data

  • traffic_id — SERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • timestamp — TIMESTAMPTZ — NOT NULL
  • src_ip — INET — NOT NULL
  • dst_ip — INET — NOT NULL
  • protocol — VARCHAR(10) — NOT NULL
  • bytes_sent — BIGINT — NOT NULL
  • packets — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

Users

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • emp_number — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL