I'm modelling DB and wondering if I should create more very simple tables or just have more columns in tables.
I mean, let's assume I have s table named
User, each user can have status(ACTIVE, INACTIVE, BLOCKED, ...). Should I store status directly in
ENUM?) table or maybe it's better to create a table named
UserStatus with status ID, status name and FK pointing to the user?
Similar with employees and their position(manager, developer, etc.).
Can you give me some advices?