[K0P]

Hi,im making a group system and some other things,i need some help making their tables,how can i make a neat table that can store lots of information,like for VIP system i want to store the following information on an existing table (`players`)

Код:

VIP Level

Big Label Slot 1
Slot 2 
Slot 3 

Small Label Slot 1
Slot 2
Slot 3

Pickup Slot 1
Slot 2
Slot 3

And much more info...

But i want to ask that a single table will be able to handle 80+ columns? Because most of the columns will be null if the player is not VIP.

[Vince]

A single table probably shouldn't even exceed 15 columns, let alone 80. The way I see it you need at least three tables: your existing player table, a table that lists types (big label, small label, pickup, ...) and an association table that links both of them together.

[K0P]

Quote:

Originally Posted by Vince A single table probably shouldn't even exceed 15 columns, let alone 80. The way I see it you need at least three tables: your existing player table, a table that lists types (big label, small label, pickup, ...) and an association table that links both of them together.

Thanks.