i have database large-ish primary table has several attached secondary tables. each secondary contains 2 fields: foreign key attaching principal table, , single piece of data. this:
this looks me it's semantically equivalent having nullable field on principal table, i'm wondering:
is there advantage having nullable fields split out own table?
if there's no advantage, there historical reason schema might have ended way?
Comments
Post a Comment