I am looking to build a simple database that stores prices of items from ingame traders for the DayZ game.
I have some experience using SQL but this wix collections has me baffled.
In a SQL enviroment I would create a separate table for the items from each trader with each item having a unique ID. I could then easily display either items from one particular trader or if I wanted all items from all traders. This would make entering data simple as I would only have to update a few fields in a form rather than having to enter the trader and category for each item as well.
THis is a basic schema of how I envisage the database being set up. TRADERPRICES being the name of the database
TRADERPRICES
SEA TRADER
category
Item
HUNTING TRADER
category
Item
BLACK MARKET TRADER
category
Item
For each item there would be a single record with the following fields
ItemID (unique identifier assigned automatically by database)
Description (text)
Sell Price (number)
Buy Price (number)
Size (number)
I see no way of creating sub categories within Wix Collections. Nor do I see a way of combining multiple collections in to a single entity.
Can someone please explain how I could achieve the above?