Great idea Wikiphil
Heres a quick markup of what the SQL table will look like:
port_id
port_number
port_description
port_connected_asset - References an asset that does not have associated ID custom asset not listed under assets
port_ip_address
port_connected_asset_id - references another asset by id
port_network_id - References Network along with the vLAN
port_asset_id - References the switch, firewall device etc