Currently entries into xf_node_type are not associated with an addon_id, so if you use an add-on that creates a new node type and you disable that add-on it will still show up when you try to create a new node, but you'll get an error that the route wasn't found.