Public feed
#378580
mysql> desc network_ports;
+-----------+--------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+-------------------+-------+
| asset_id | int(11) | NO | PRI | 0 | |
| mac_addr | varchar(17) | YES | UNI | NULL | |
| if_name | varchar(255) | YES | | NULL | |
| dev_name | varchar(255) | YES | | NULL | |
| switch_id | int(11) | YES | MUL | NULL | |
| port_phys | varchar(255) | YES | | NULL | |
| port_virt | int(11) | YES | | NULL | |
| stamp | timestamp | NO | | CURRENT_TIMESTAMP | |
+-----------+--------------+------+-----+-------------------+-------+
8 rows in set (0.00 sec)