[Dayrion]

Quote:

Originally Posted by [HLF]Southclaw In that case, your current implementation looks fine. Unless of course you want to adjust the amount of ranks and make it dynamic. In which case you'd create another table for just ranks with this schema: (rank precedence, rank name, faction ID) Then you can grab all the ranks with a SELECT * FROM ranks WHERE factionID = etc... you can have n ranks for every faction, adjust that limit based on some other factor whenever you want and you also have a record for each individual rank allowing you to build other data models around this (for example, you could link a player to a rank and a vehicle to a rank then the lookup becomes a JOIN between those three relations).

I thought the same things but it looks like too much no? I mean, I'll get a toon of "line" (I forget the correct word).
8 * 10 (max factions) = 80.
It's better (performance, optimization, ease of use) to do :
- Like you explained : one line, one rank
- The first method : on line, on faction with 8 ranks max
?
(Sorry for every english mistakes...)