What is the best way to avoid repeating ENUM in the database?

Question

SQL

There are 2 boards. They have a field that is responsible for the order status, with a data type like
ENUM('BOOKED', 'SUBMITTED', 'PAID', 'CANCELLED', 'NOT_ACTIVE', 'REFUSE').
what if I have 10 such plates? and I want to change ENUM? How to make it more flexible and put it somewhere in one place? Thanks

Answer 1

To do this, all of a sudden, you can use a value table and foreign keys.
Although, of course, creating tables when working with a database may seem like a radical idea to someone.