Code: Select all
[u]tb_user[/u]
[u]user_id[/u] | [u]name_first[/u] | [u]name_last[/u]
123456 | bill | smith
987654 | john | doe
[u]tb_game[/u]
[u]game_id[/u] | [u]game_data[/u] | [u]total_players[/u] | [u]complete[/u] | [u]start_date[/u]
0 | 71ce5... | JSON_DATA 2 | 0 | 2009-03-09 16:39:50
1 | c676c... | JSON_DATA 1 | 0 | 2009-03-09 17:39:50
[u]tb_match[/u]
[u]match_id[/u] | [u]game_id[/u] | [u]user_id[/u]
0 | 71ce5... | 123456
1 | 71ce5... | 987654
2 | c676c... | 123456
Code: Select all
[u]match_id[/u] | [u]game_id[/u] | [u]user_id[/u] | [u]game_data[/u] | [u]total_players[/u] | [u]complete[/u] | [u]start_date[/u] | [u]name_first[/u] | [u]name_last[/u]
0 | 71ce5... | 123456 | json_data | 2 | 0 | 2009-03-09 16:39:50 | bill | smith
2 | c676c... | 123456 | json_data | 1 | 0 | 2009-03-09 17:39:50 | bill | smith