MySQL table creation
#4

Anything that is not directly related to the player or that does not apply to all players should not be in the player table. For example, I don't think every player is in a company. So what you need is a third table, known as an association entity. Call it "companyMembers" or something. This entity then consists of atleast a) userid and b) companyid. The extra information you need (joindate and so on) may also be in that table.

Likewise, not every player is banned (luckily) so that information also shouldn't be in the player table.
Reply


Messages In This Thread
MySQL table creation - by PowerPC603 - 18.05.2015, 21:35
Re: MySQL table creation - by Abagail - 18.05.2015, 21:37
Re: MySQL table creation - by PowerPC603 - 19.05.2015, 09:09
Re: MySQL table creation - by Vince - 19.05.2015, 09:15
Re: MySQL table creation - by PowerPC603 - 19.05.2015, 10:54
Re: MySQL table creation - by Vince - 19.05.2015, 13:11
Re: MySQL table creation - by PowerPC603 - 19.05.2015, 15:17

Forum Jump:


Users browsing this thread: 1 Guest(s)