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