Схема таблиц базы данных

Напоминаем, что NeTAMS создает базу данных, и все таблицы, автоматически по мере необходимости, обычно в момент первого запуска.

Список всех таблиц (кроме опциональной системы биллинга):

mysql> show tables;
+------------------+
| Tables_in_netams |
+------------------+
| events           | системные события 
| monitor          | детальный мониторинг трафика юнитов
| oids             | соответствие имени и идентификатора объекта
| quota            | значения квот для юнитов
| raw              | "сырые" данные по потокам трафика
| summary          | агрегированные данные по потокам трафика
+------------------+

mysql> describe events;
+-------------+------------------+------+-----+---------+
| Field       | Type             | Null | Key | Default |
+-------------+------------------+------+-----+---------+
| time        | int(10) unsigned | YES  |     | NULL    | 
| type        | varchar(8)       | YES  |     | NULL    |
| unit_oid    | int(10) unsigned | YES  |     | NULL    | 
| user_oid    | int(10) unsigned | YES  |     | NULL    | 
| account_oid | int(10) unsigned | YES  |     | NULL    | 
| param       | varchar(254)     | YES  |     | NULL    | 
+-------------+------------------+------+-----+---------+

mysql> describe monitor;
+----------+----------------------+------+-----+---------+
| Field    | Type                 | Null | Key | Default |
+----------+----------------------+------+-----+---------+
| time     | int(10) unsigned     | NO   | MUL | NULL    |
| flowt    | int(10) unsigned     | YES  |     | NULL    |
| unit_oid | int(10) unsigned     | YES  | MUL | NULL    |
| proto    | tinyint(3) unsigned  | YES  |     | NULL    |
| src      | int(10) unsigned     | NO   |     | NULL    |
| srcport  | smallint(5) unsigned | YES  |     | NULL    |
| dst      | int(10) unsigned     | NO   |     | NULL    |
| dstport  | smallint(5) unsigned | YES  |     | NULL    |
| if_in    | smallint(5) unsigned | YES  |     | NULL    |
| if_out   | smallint(5) unsigned | YES  |     | NULL    |
| as_src   | smallint(5) unsigned | YES  |     | NULL    |
| as_dst   | smallint(5) unsigned | YES  |     | NULL    |
| dpkts    | bigint(20) unsigned  | YES  |     | NULL    |
| len      | bigint(20) unsigned  | YES  |     | NULL    |
| layer7   | varchar(80)          | YES  |     | NULL    |
+----------+----------------------+------+-----+---------+

mysql> describe oids;
+-------+------------------+------+-----+---------+
| Field | Type             | Null | Key | Default |
+-------+------------------+------+-----+---------+
| oid   | int(10) unsigned | NO   | PRI | NULL    |
| name  | varchar(32)      | YES  |     | NULL    |
+-------+------------------+------+-----+---------+

mysql> describe quota;
+--------------------+---------------------+------+-----+---------+
| Field              | Type                | Null | Key | Default |
+--------------------+---------------------+------+-----+---------+
| unit_oid           | int(10) unsigned    | NO   | PRI | NULL    |
| policy_oid         | int(10) unsigned    | NO   | PRI | NULL    |
| syspolicy_oid      | int(10) unsigned    | YES  |     | NULL    |
| soft_treshold      | int(10) unsigned    | YES  |     | NULL    |
| flags              | int(10) unsigned    | YES  |     | NULL    |
| last_blocked_time  | int(10) unsigned    | YES  |     | NULL    |
| notify_soft_oid    | int(10) unsigned    | YES  |     | NULL    |
| notify_hard_oid    | int(10) unsigned    | YES  |     | NULL    |
| notify_return_oid  | int(10) unsigned    | YES  |     | NULL    |
| h_in               | bigint(20) unsigned | YES  |     | NULL    |
| h_out              | bigint(20) unsigned | YES  |     | NULL    |
| h_sum              | bigint(20) unsigned | YES  |     | NULL    |
| d_in               | bigint(20) unsigned | YES  |     | NULL    |
| d_out              | bigint(20) unsigned | YES  |     | NULL    |
| d_sum              | bigint(20) unsigned | YES  |     | NULL    |
| w_in               | bigint(20) unsigned | YES  |     | NULL    |
| w_out              | bigint(20) unsigned | YES  |     | NULL    |
| w_sum              | bigint(20) unsigned | YES  |     | NULL    |
| m_in               | bigint(20) unsigned | YES  |     | NULL    |
| m_out              | bigint(20) unsigned | YES  |     | NULL    |
| m_sum              | bigint(20) unsigned | YES  |     | NULL    |
| block_policy       | int(10) unsigned    | YES  |     | NULL    |
| block_policy_flags | int(10) unsigned    | YES  |     | NULL    |
+--------------------+---------------------+------+-----+---------+

mysql> describe raw;
+------------+---------------------+------+-----+---------+
| Field      | Type                | Null | Key | Default |
+------------+---------------------+------+-----+---------+
| unit_oid   | int(10) unsigned    | NO   | MUL | NULL    |
| policy_oid | int(10) unsigned    | NO   | MUL | NULL    |
| t_from     | int(10) unsigned    | NO   | MUL | NULL    |
| t_to       | int(10) unsigned    | NO   | MUL | NULL    |
| bytes_in   | bigint(20) unsigned | YES  |     | NULL    |
| bytes_out  | bigint(20) unsigned | YES  |     | NULL    |
+------------+---------------------+------+-----+---------+

mysql> describe summary;
+------------+-----------------------+------+-----+---------+
| Field      | Type                  | Null | Key | Default |
+------------+-----------------------+------+-----+---------+
| prefix     | enum('M','W','D','H') | NO   | PRI | NULL    |
| unit_oid   | int(10) unsigned      | NO   | PRI | NULL    |
| policy_oid | int(10) unsigned      | NO   | PRI | NULL    |
| t_from     | int(10) unsigned      | NO   | PRI | NULL    |
| bytes_in   | bigint(20) unsigned   | YES  |     | NULL    |
| bytes_out  | bigint(20) unsigned   | YES  |     | NULL    |
+------------+-----------------------+------+-----+---------+