asked on Idea needed; Inserting flags
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?
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?
MainTable
ID
other columns
MainTableFlag
ID
FlagCode
FlagTable
FlagCode
Description
ASP.NET
Last Comment
nmarun
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
otherwise, it's an ok design? should I keep that FlagTable? This table is like a lookup table but I dont think i need it because i have the Enum in the code..no?
The design seems good. Keep the FlagTable just for reference.. later some day when someone looks at the main table and wonder what on earth would 'R' mean.. they'll have something to bank on.