Hi fellow bubblers!
I do need help with a database design question.
Short explanation: A User answers questions (Single and Multiple Choice) and gets a product recommended.
When the user answers a question, some rows in “user point allocation” and “user product point” shall be created, or if answers exist, updated (see tables below).
Thus, I want to JOIN “point allocation” and “User answer” using “question name” and “Answer name” as key, to fill in data in “user point allocation”.
Then, I want to JOIN “user point allocation” with “products” using “Apple” as key, to fill in data in “user product point”.
For “user point allocation”, I made a workflow where I deleted and then created the three entries separately (however, this is approach is not variable).
For “user product point”, I currently do not have a solution to ensure that all “Apple” are combined.
My questions:
- How do I JOIN those tables properly? Maybe I think to SQLish - do I need another structure for bubble?
- What columns are recommended to make separate things? perhaps question (name) or answer (name)?
- Do you have other tips to make this workflow fast?
Thank you so much! I appreciate any helpful answer and feedback!
&
→
&
→