Daily caches

describe daily_caches;

+-------------------+------------------+------+-----+---------+----------------+
| 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