We are trying to build a database based on data that looks like this: (for example)
The attributes are the items that customers bought
As you can imagine, the store has over 100+ (but finite) number of items that a customer can buy. We do have a list of all the possible items that someone can buy.
Due to permutations of possible attributes and individual behavior, the customers cannot be categorized into pre-defined types (i.e. fruit-only buyers, dairy-only buyers etc.)
How can we build such a database?
We are using SailsJS and MongoDB