I'm creating a text based fighting game simulator that'll have people saving their characters on mySQL. How should I design my table(s) to store each characters fighting history?
John has wins against Eric, Joe, Peter, Kenny, and Chuck.
Joe has wins against Eric and Peter. Losses against Kenny and Chuck.
How would I design a database for this? I'm thinking the only way to do this is by creating a seperate table for each fighter. This is probably too broad of a question to ask but I'd appreciate any kind of input.