03.02.2015, 16:04
Once more a perfect example of how a table should not look like. Anything that has a number in it belongs in a separate table.
I reckon that this is a lot easier to read and a lot easier to work with. It also allow for virtually unlimited ranks and it doesn't waste space if a rank isn't used. The same goes for 'division' and the guns and their associated costs.
| groupid {PK, FK} | rank {PK} | description | pay |
| 5 | 0 | Intern | 5000 |
| 5 | 1 | Agent | 15000 |
| 5 | 2 | Senior Agent | 20000 |
I reckon that this is a lot easier to read and a lot easier to work with. It also allow for virtually unlimited ranks and it doesn't waste space if a rank isn't used. The same goes for 'division' and the guns and their associated costs.