Structure

[Rodgerwilco]

Don't want to go into too much detail on what my project is about..

 

Lets say you have a table "Members". This table includes <id> <username> <password> <group_id>

 

For the sake of explanation, each member will be given a random number between 1-100 every time they request a number. Would you create a new table, "Random" and have each id correspond to their initial account?

 

<id> <username> <password> <group_id>

0  admin  password 0

1  player1  password 1

2 player2 password 1

3 player3 password 1

 

 

Let's say player1, player2, and player3 get some random numbers and the output is

 

Table : Random : Structure <id> <number>

1 100

1 30

2 50

3 50

2 60

3 80

1 90

3 50

2 50

 

Each player has 3 numbers, but at different times. Now my project consists of thousands of numbers, ultimately probably an average of 200,000 random numbers generated.

 

How would you approach the situation?

[AyKay47]

Would you create a new table, "Random" and have each id correspond to their initial account?

 

Quite simply, yes.