More tables or more columns (in my simple example)? 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 User(as an 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?
Typically user would have the fk

user:
ID (pk)
Name
StatusID (fk referencing status.ID)    

status:
ID (pk)
Name  

A user has a status - not a status has a user