6 reputation
2
bio website
location Denver, CO
age 43
visits member for 2 years, 7 months
seen May 25 '12 at 16:56

May
23
comment Same field but different contents
How is the number of tables releavnt? Sure, I could have up to 1000gram. All of the tables have the same data, and I was asking whether it is better to put all that same data in a separate table (say, Details) and link them in as foreign keys, or to keep all the data in the main tables themselves (so every table has it's own Color field, and Season field, and Planet field, and so on). I've opted for the latter.
May
21
comment Same field but different contents
Now, since there won't be an answer here, do I need to do anything else to properly "close" the question?
May
21
comment Same field but different contents
After asking around IRL as well, the answer I've come to is that it's probably simpler and cleaner to incorporate all of the correspondences within each table, i.e. the triColor, triPerson, hexColor, hexPerson model. Since there won't be overlap between each of the correspondences, and every line will be distinct, there's no point in linking them to some other Correspondence table.
May
18
awarded  Editor
May
18
revised Same field but different contents
added 407 characters in body
May
18
comment Same field but different contents
Actually, I gave the above example because it's almost identical to the structure of my database. Adding in 50 fields from 30 other tables is pointless, and a waste of your time. I'm not sure how adding a few rows would make a difference, but I'll do it for one anyway.
May
18
awarded  Student
May
18
asked Same field but different contents