+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| description | text             | YES  |     | NULL    |                |
| sig_id      | int(11)          | YES  |     | NULL    |                |
| ip_src      | varchar(50)      | YES  |     | NULL    |                |
| ip_dst      | varchar(50)      | YES  |     | NULL    |                |
| user_id     | int(11)          | YES  |     | NULL    |                |
| user_ids    | mediumtext       | YES  |     | NULL    |                |
| sensor_ids  | mediumtext       | YES  |     | NULL    |                |
| created_at  | datetime         | NO   |     | NULL    |                |
| updated_at  | datetime         | NO   |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+

Back to Database Schema

Back to Snorby E-Book