threatlens
Tables (5)
admin_access_logs
- id — bigint — Primary key — NOT NULL
- id (admin_user) — int — Foreign key → auth_user.id — NOT NULL
- login_id — varchar(150) — NOT NULL
- login_at — datetime — NOT NULL
- ip_address — varchar(45) — NOT NULL
- is_success — tinyint — NOT NULL
auth_user
- id — int — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime
- is_superuser — tinyint — NOT NULL
- username — varchar(150) — NOT NULL
- first_name — varchar(150) — NOT NULL
- last_name — varchar(150) — NOT NULL
- email — varchar(254) — NOT NULL
- is_staff — tinyint — NOT NULL
- is_active — tinyint — NOT NULL
- date_joined — datetime — NOT NULL
black_list_policies
- policy_id — char(12) — Primary key — NOT NULL
- id (creator_id) — int — Foreign key → auth_user.id — NOT NULL
- id (updator_id) — int — Foreign key → auth_user.id — NOT NULL
- policy_name — varchar(50) — NOT NULL
- domain — varchar(512)
- regex_pattern — varchar(512)
- is_apply — tinyint — NOT NULL
- is_temporary — tinyint — NOT NULL
- expired_at — datetime
- danger_level — tinyint — NOT NULL
- category — varchar(50) — NOT NULL
- created_source — tinyint — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- description — mediumtext
packet_detection_logs
- log_id — bigint — Primary key — NOT NULL
- src_ip — varchar(45) — NOT NULL
- dst_ip — varchar(45) — NOT NULL
- detected_at — datetime — NOT NULL
- src_port — int — NOT NULL
- dst_port — int — NOT NULL
- protocol — tinyint — NOT NULL
- ttl — int — NOT NULL
- matched_type — tinyint — NOT NULL
- policy_id — char(12)
- action_taken — tinyint — NOT NULL
- ai_version — varchar(20)
- ai_score — decimal(3,2)
- threshold — decimal(3,2)
- domain — varchar(512) — NOT NULL
- request_url — mediumtext — NOT NULL
- src_mac — char(17) — NOT NULL
- dst_mac — char(17) — NOT NULL
- description — mediumtext
white_list_policies
- policy_id — char(12) — Primary key — NOT NULL
- id (updator_id) — int — Foreign key → auth_user.id — NOT NULL
- id (creator_id) — int — Foreign key → auth_user.id — NOT NULL
- policy_name — varchar(50) — NOT NULL
- domain — varchar(512) — NOT NULL
- is_apply — tinyint — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- description — mediumtext