12-07-2018, 08:48 PM
Haha. I don't know about that, but I'm happy to help.
One other tip I do to make the database more readable on things like that. I always do 0 and 1 instead of 1 and 2. 0 always means off or no. 1 always means on or yes. I title the db accordingly so...
if the column is private
1 would mean yes, private
if it's public
1 would mean yes, public
It doesn't seem like a big deal, but 6 months from now it saves you from having to go back in the code and figure out what's what.
One other tip I do to make the database more readable on things like that. I always do 0 and 1 instead of 1 and 2. 0 always means off or no. 1 always means on or yes. I title the db accordingly so...
if the column is private
1 would mean yes, private
if it's public
1 would mean yes, public
It doesn't seem like a big deal, but 6 months from now it saves you from having to go back in the code and figure out what's what.