I have spent a HUGE amount of time on semi-functional base design. However, I keep making iterative mistakes. The relational databases is, of course, the big appeal in airtable.
But I keep making mistakes with flow through consequences, and kind of need to rebuild our bases from the start.
There are many convoluted connections in this base design, and I am looking for advice on a framework for knowing how to rebuild without making the same mistakes? A lot of these issues come from "learning by doing," which has created a vast amount of data that isn't very easy for us to use (or input)!
I had a look at the beginner articles on airtable again, but they don't really seem to cover relational database design at a first principles level.