TINYINT is a small SQL integer type that uses one byte of storage. Its numeric range depends on whether it is signed or unsigned: signed TINYINT reaches 127, while unsigned TINYINT reaches 255. section 4.6
Use these rules when choosing an integer type:
- Compare the attribute’s required values with the available signed or unsigned range. section 4.6
- Prefer a larger integer type when the attribute can exceed TINYINT’s limits. section 4.6
- Remember that unsigned numbers cannot be negative, while signed numbers can. section 4.6
Choosing a type for payment_id
A payment_id is a numeric identifier, but TINYINT is too small for a growing online store. INT is considered large enough for now, while BIGINT supports an even larger future scale. section 4.6
