MySQL data precision confusion
NUMBER_PRECISION is useless except for one case:  ZEROFILL.  Otherwise, it is an indication of how many columns of output are needed to display the largest number.

INT UNSIGNED needs 10 digits.  INT SIGNED needs 11 columns -- a sign (if negative) and 10 digits.

Ignore the column there.  Ignore it when you see int(11).

And don't bother declaring a column to be INT(100) or INT(2); it is still a 32-bit (4-byte) signed binary number.