in reply to (OT) Database design: omitted partially filled fields.

Howdy!

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.

yours,
Michael
  • Comment on Re: (OT) Database design: omitted partially filled fields.