Next up matchrounds

Ok.. matches have rounds. So there needs to be a connection between them...

mrid
this is the basic id to identify the complete rounds

mrmid
this is the same id which is connected to the match. The way I usuaully end up naming the fields is to take the first part for the table name (which is MR = MatchRounds), then take the id which is connected to (which is in this case Match.Mid). This makes the fields always unique (unless the abbreviation is similar to another).

I just forgot to add the game and the game mode to the previous table... I just thought of this.

mrgmid
This is the gamemode id

mrgid
This is the game id... Ok, this is the part I addressed before where I think it stupid to have it here.. but you'll never know.

mrdate
Just for safe keepings... I will add the date to the rounds aswell. Just incase some idiot decides to have the rounds spread over multiple days. I like to plan ahead because I assume it will eventually happen one day. Default the date of the match should overrule this section (just like the game and the game mode).

mrteam1
This is the same team as in the match. But just for reference, lets have it here too... I like inconsistancy :)

mrteam2
This is the same team as in the match. But just for reference, lets have it here too... I like inconsistancy

mrscore1
mrscore2

These two are the scores per round for team a and team b. This is also why I want the teams to be stored on round level aswell, since it shows visually in the table who team 1 and team 2 are.

mserverid
This is where it gets puzzling... where am i going to keep record of the servers? do the teams enter the servers they play on? or is this something done by an admin? or both?

But anyways... this does leave me with adding the server information in a specific table. But just to be on the safe side... Lets add the following too:

mrservername
This is the server name

mrserverip
And thats the server ip

mrserverport
And thats the server port...

The reason why I am keeping track of the servers per round, is because of the situation I described before... The rounds can be played on different servers (host/guest setup). But this also needs to be added to the Match table so that can overrule the rounds!

mrMapId
this is the current map. Again this leads me back to the next section:

I NEED A MAP TABLE!
Oh yeah!

Ow.. another thought: created by? I don't have this in the match yet... Ok.. need to add this aswell.

Just added
mcreatedby
macceptedby


To the match table. Same as all the server info.. and game info.

So i think that covers that bunch so far.