I got help with a table design last month. It's below.
I can have flags like Reserved, NBX, Catalog.
I created an enum;
public enum OrderFlag
Reserved = 'R',
NXX = 'X',
Catalog = 'C'
When I insert into Main Table, I will insert using OrderFlag.Reserved. In MainTableFlag, I will insert R.
Do I need that FlagTable to hold the description of the flags. Or is that Enum enough.
Better way of doing this?
Open in new window