Is the column type id: ID! @id guaranteed to be unique across all tables?

Not necessarily. For what kind of database is this?

Hi it's MySQL

Actually it is. We generate a cuid with @id directive. https://github.com/ericelliott/cuid/blob/master/README.md Chances of collision are very very low