Speaking of the field active:
If you want to use activeboth inactivefor status marking activeand inactiveany record (for example, a user model), you can use a data type tinyint.
Bool, Boolean: These types are synonyms for TINYINT (1). A value of zero is considered false. Nonzero values are considered true.
Soft removal
, Laravel deleted_at , soft delete, , .