Pinger Data Analysis

mysql> use pinger
Database changed
mysql> show tables;
+------------------+
| Tables_in_pinger|
+------------------+
| DATA               |
| NODE             |
+------------------+
2 rows in set (0.00 sec)

mysql> desc NODE;
+-------------------------+--------------------------------------+
| Field   | Type            | Null | Key | Default     |     Extra              |
+-------------------------+-------------------------------------+
| id        | smallint(6)     | NO   | PRI | NULL    | auto_increment    |
| name  |  varchar(100) | YES  |       | NULL      |                          |
| ip        | varchar(15)   | YES  |        | NULL       |                         |
+-------------------------+--------------------------------------+
3 rows in set (0.01 sec)
mysql> desc DATA;
+-------------------------------+-------------------+
| Field           |  Type        | Null | Key | Default | Extra |
+-------------------------------+-------------------+
| source        | smallint(6) | YES  |     | NULL    |       |
| destination  | smallint(6) | YES  |     | NULL    |       |
| packet_size | smallint(6) | YES  |     | NULL    |       |
| epock         | int(11)     | YES  |     | NULL    |       |
| packet_loss | tinyint(4)  | YES  |     | NULL    |       |
| min            | float(4,2)  | YES  |     | NULL    |       |
| avg            | float(4,2)  | YES  |     | NULL    |       |
| max           | float(4,2)  | YES  |     | NULL    |       |
+------------------------------+--------------------+
8 rows in set (0.00 sec)