Active deactivate user. Column or role

Hi!

I’m implementing the feature to active / deactivate users.

Two ways came to mind.

1 add a Boolean column to the User table 2 add the role and assign the users to active deactivated roles.

Any thoughts? Better ways?

Best regards, Tobias

Tray2

4 years ago

Best Answer

Level 73

I think you are on the right track.

I would go with an active column on the users table.

When it comes to the roles I take it you have a many-to-many relationship, then I suggest adding the active to the role_user pivot table. Unless of course you activate and deactivate the role in the roles table.

TobiasS

4 years ago

Level 10

@Tray2 I thought of making a role “deactivated” and then add that role to the deactivated users

Tray2

4 years ago

Level 73

@TobiasS It's the user that is deactivated not the role, so I say put it on the users table.

1 like

TobiasS

4 years ago

Level 10

@Tray2 Thx! Sounds like the easiest and most clean way

Please or to participate in this conversation.