+-------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| sid | int(11) | YES | | NULL | |
| cid | int(11) | YES | | NULL | |
| ran_at | datetime | YES | | NULL | |
| event_count | int(11) | YES | | 0 | |
| tcp_count | int(11) | YES | | 0 | |
| udp_count | int(11) | YES | | 0 | |
| icmp_count | int(11) | YES | | 0 | |
| severity_metrics | mediumtext | YES | | NULL | |
| signature_metrics | mediumtext | YES | | NULL | |
| src_ips | mediumtext | YES | | NULL | |
| dst_ips | mediumtext | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+-------------------+------------------+------+-----+---------+----------------+
Back to Database Schema
Back to Snorby E-Book