Is it possible to move the description VARCHAR(255) field from many different tables to a separate table?

Question

Database design

There are many different tables, and almost every one of them has a description VARCHAR(255) field.
Is it possible to create a separate table Description (id INT, description VARCHAR(255)), and in the source tables to define foreign keys to this table?
How correct is this approach?

Answer 1

Yes, of course you can. The only question is whether it is necessary. What will it give? What problem will it solve? What result do you expect (increased productivity, ease of editing, etc.)? Don't forget that now to get a record from any table, along with its description, you will have to do a JOIN - is this an acceptable price for such a controversial "normalization"?