How to handle status columns in designing tables
Posted
by
altsyset
on Programmers
See other posts from Programmers
or by altsyset
Published on 2013-10-19T14:26:14Z
Indexed on
2013/10/19
16:07 UTC
Read the original article
Hit count: 187
design
|object-oriented
How to handle multiple statuses for a table entry, for example an item table may have an active, inactive, fast moving, and/or batch statuses. And I wanted to handle them in single column with VARCHAR type. Also I might set each of those attributes as a boolean with different columns. But I am not sure what consequences this might lead to. So if you have experienced such situations which one would be the best way to handle it?
© Programmers or respective owner
