Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
12-09-2011, 10:48 AM #1
same db table for different deal types
If you have 15 different foreign exchange options trade types but they share 80% of the same fields would you use the same db table, and just allow null in non shared fields?
12-09-2011, 01:06 PM #2
- Join Date
- Mar 2006
- St. Catharines, Ontario Canada
- Thanked 147 Times in 138 Posts
Not enough information to really say. The important concept is normalizing your data.
12-09-2011, 08:12 PM #3
Big question might be "how many non-shared fields?" and what are their purposes.
And maybe there's a way to share fields (in a related table) that isn't obvious from lack of information.An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
12-10-2011, 12:04 PM #4
most banks allow to export data of trades in one big excel sheet even though many fields are blank as shared trades, only thing now is my trades table is so complex that the table is getting real hard to under stand.
I wish I build it with different tables, but I wanted to save time