Ron McLeod wrote:It looks like Respawns is effectively just an attribute of Hunts - I don't see what value that the Respawn_Per_Hunt and Respawns tables bring.
Gerard Ramon Monte wrote:A tiny detail is that i don't really want to store the people names, so could i use the table Hunter this way?
ID - Role
1 - EK
2 - ED
3 - RP
4 - MS
And then, in participation asign 1 to 4 depending of the vocation?
So storing all the data this way, will allow me to keep showing the information in my table i shown you before? I supose i will have to do some SQL queries to get the information i want.
**The ¿? fields are things I don't know if I would have to add, or I can just calculate it and then show it in the application table using SQL queries.
Then the participation table, will have (in the case we are 3 people in party), 3 rows refering to that hunt
HuntID HunterID Waste Transfer 1 1(EK) 100 150 1 2(ED) 300 350 1 3(RP) 50 100
Then, to show this information in the application table, I can do SQL queries to get almost all the data, exept the things in ¿? wich I could just calculate at the moment.