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)