From the execution efficiency of the field type, the int is the highest and the varchar is the lowest.
The Status Type field, using char or varchar is undesirable, the int type is easier to index and retrieve, after all, the numeric type is the basis of the database retrieval, after all, the char type needs to be transformed, and varchar is more complex, and the ordering needs not only conversion and computation, You also need to access and follow the collation of the database (in fact, Char also requires a collation) and consume more resources.
Therefore, it is common to use the int type field rather than the character type field in the database design, which has significant performance differences in the optimization of large and very large databases.
(go) the difference between int and varchar when storing a numeric field in a MySQL database