As far as I
know, it is unique within the entire database.
But it need
not be unique throughout the entire lifetime of the system. If the ID is no
longer present in the database, it can be reused.
If the number space is exhausted, there will be an overflow and the ID starts
all over again.
I wonder if that's ever happened at someone. :)