Normalization

wxdqz

New Member
Wondering which would be best method. For an item table there is a column for condition, the user would choose 1 of 4 values from a drop down menu, poor, fair, good, excellent. My question is, which would be better (MySQL) to have the value entered into the column or sent to condition table and a condition_id value entered in item table?
It appears the best method might even be Enum but I cant seem to find enough information on this data type, or how to create it using phpadmin.
Thanks in advance,
Jim
 
Back
Top