Create an Event feature with Wix Code

I am using both Wix Events and Wix Code in my site. But Wix Events does not allow me to directly link my members database with all our events (we have one eveng every saturday) and members registration to an event (since only approved members can register to our event). Consequently, our members cannot see who has previously registered to a coming event, cannot cancel their registration to an event, cannot see at whim events they have already registered, …
I am therefore considering ‘creating’ my own event feature using Wix Code. I currently bump on the problem of database collections: I have about 170 members in one collection, about 40 events per year listed in another collection but will probably need one more collection per each event (about 40 more collections?!?) to list all registrations to an event (one registration to an event consists of 1 to 9 different data depending on what sort of service the member is requesting). In short, it makes the job very complex using Wix Code …

My questions:

  • has anybody previously faced similar situation and created a similar event which I could ‘copy’ and adjust?
  • can anybody advise me on the best way/approach so I can avoid creating one database collection per each event?
  • Any other suggestions / advises?

Thanks a lot for your assistance