in reply to (OT) Database design: omitted partially filled fields.
It's hard to tell. Sometimes your first option is the correct one.
Do you have a normalized scheme for the data? Are there repeated fields? Are they all distinct (if sometimes/often null)?
If there really are thirty attributes, you may well need thirty columns. Don't reject it because it "feels wrong", although your concern is not misplaced.
Option 2 might be workable, but that depends on how the data is set up and used.
|
|---|