As status and type is reserved key in MySQL, I need a column name similar to status to identify the status of a row.
I know there is way to ignore this problem but in different language and different framework it suddenly arise this problem in different way, so I need to ignore this word and need a similar word that sound almost same and can be understandable from the name.
The potential values for my use case are true/false. What do you suggest to name a Boolean column that defines the status of that row?
Here status is defining that row if it is active or inactive. And not every where I'm using status column for this purpose, Somewhere status column is defining if the status is pending, current, confirmed, applied, rejected, etc. Like this shorts of key.
is_active
and set it to true or false. Not just does that make more sense, it provides a sexy syntaxSELECT * FROM t WHERE is_active
If it means means pending, createis_pending
oris_current
status only makes sense over an enumeration of discrete valuesSELECT * FROM listings WHERE status IN ( 'sold', 'terminated', 'active' );
etc. In that case, I would go with @Joe W's suggestionlisting_status
-- from a DBA's perspective Joe is right.