153 reputation
15
bio website
location Stockholm, Sweden
age
visits member for 2 years, 5 months
seen Mar 6 at 19:29

Mar
8
awarded  Notable Question
Jan
6
awarded  Nice Question
Feb
21
awarded  Popular Question
Nov
17
comment Best way to design tournament database
@David how do you solve it?
Nov
16
comment Best way to design tournament database
@David Primary key/foreign key I presume
Nov
16
comment Best way to design tournament database
@JackDouglas I spent last night implementing your design proposal, it actually works out really well. Just wanted to let you know! The knockout application logic was fairly simple to code. I filled the tables with dummy data, and can change the outcome of the entire tournament just by altering results in the results table.
Nov
15
awarded  Scholar
Nov
15
accepted Best way to design tournament database
Nov
15
comment Best way to design tournament database
Thanks, but I don't think I would've use constraints anyway since I'm not very familiar with it. Will validate all data in my application before it's sent to the DB, keeping it simple
Nov
15
comment Best way to design tournament database
No problem I get the PK/FK :-) I am a beginner in this forum though, thanks for the advice about @ the user
Nov
15
comment Best way to design tournament database
David, I appreciate your answers, but your solution is hard for me to understand. I'm not familiar with gray code or implementing binary trees in databases. It would be much easier if you suggested a design like Jack did, for what parts would go in the database, and what parts would be application/view logic.
Nov
15
comment Best way to design tournament database
Pretty much settled.. Are there any advantages/disadvantages with MySQL I should be aware of?
Nov
15
comment Best way to design tournament database
This might be a good solution! Thank you for the hands-on example. @David how would you do your data model? Not sure I fully understand what you are suggesting, you speak in terms above my paygrade... :)
Nov
15
awarded  Supporter
Nov
15
awarded  Student
Nov
14
asked Best way to design tournament database