How to build a data table index like filter

Snip20160818_5.png

Want to know how this filter index is appropriate to build the index.
It is not necessary to see the order of different kinds of filter from the graph, is this an index for a single field?

The database structure is probably like this
Id
GOODS_ID (Product ID)
For_who (Gift object)
At_where (Gift occasion)
XXXX (personality)
.... (Additional fields may be extended later)

Reply content:

Snip20160818_5.png

Want to know how this filter index is appropriate to build the index.
It is not necessary to see the order of different kinds of filter from the graph, is this an index for a single field?

The database structure is probably like this
Id
GOODS_ID (Product ID)
For_who (Gift object)
At_where (Gift occasion)
XXXX (personality)
.... (Additional fields may be extended later)

Although the order of the user point is inconsistent, but your own program can be in order to match Ah, this is the value of the yard farm

For example, you will always be in the order of objects, occasions and personalities when you query, so you can build a composite index (object, occasion, personality).

