Primary Keys, Alternate Keys Clarification

[mikeloc]

Hi there, @bluesyBlues… a longtime Bubbler named Nigel has written some great posts on this topic. Maybe this particular post could be helpful…

Understanding Relational Database Nature of Bubble

Fundamentally, this is the bit that makes Bubble (and others) a bit different to a traditional relational DB. You don’t need to do it. Yes, you can set up something that looks like a foreign key, but it makes it much much more complex. The way you “tie” A Project to many Timeslips, and a Timeslip to One Project is by embedding a particular thing in the database record. So the TimeSlip has a field of Type ProjectData, that gets set to a particular Project. Not the key or an Id, the whole thing…

… and check out his responses in this thread, too…

How to learn about database models and database structure

I feel that a lot of new users struggle with bubble, not just because there is a learning curve to the bubble platform itself, but because most are non-coders and do not have a background in database design. Personally, once I began to understand database design a bit more, it had profound impacts on how I was able to build using bubble, especially when it came to ease of manipulating data. I also feel, that a lot of new users forget about Google…that powerful search engine that can point you …

Hope this helps.

Best…
Mike