Now that we are adding user defined schemas, there aren't many reasons to provide cross database object references. In particular, cross database type references can lead to problems around cockroach dump, as well as DROP TYPE affecting data in other databases. It seems like we should disallow creating tables with types in other databases.

Relates to #47765.