𝗢𝗻𝗲 𝗡𝘂𝗹𝗹𝗮𝗯𝗹𝗲 𝗧𝗶𝗺𝗲𝘀𝘁𝗮𝗺𝗽, 𝗙𝗼𝘂𝗿 𝗔𝗰𝗰𝗼𝘂𝗻𝘁 𝗦𝘁𝗮𝘁𝗲𝘀

𝗢𝗻𝗲 𝗡𝘂𝗹𝗹𝗮𝗯𝗹𝗲 𝗧𝗶𝗺𝗲𝘀𝘁𝗮𝗺𝗽, 𝗙𝗼𝘂𝗿 𝗔𝗰𝗰𝗼𝘂𝗻𝘁 𝗦𝘁𝗮𝘁𝗲𝘀

Stop using status columns in your Laravel user tables. You waste space and create bugs.

Use one nullable timestamp to track status. This method keeps your data clean.

Here is how it works:

• No email verification: User is pending.
• Email verified and no suspension date: User is active.
• Email verified and has suspension date: User is suspended.
• No email verification and has suspension date: User is banned.

You get four states with two columns. Your database stays small. Your logic stays simple.

Source: https://dev.to/nasrulhazim/one-nullable-timestamp-four-account-states-deriving-user-status-in-laravel-1d00