Help modelling data structure relationship
Hi all, thanks in advance for any help
I am writing a database interface, very basic stuff really. But I'm essentially a newbie and I've realised it's not easy to poorly design your application with RoR, where I would of probably used some funky looking logic with SQL with PHP for example. I'm a bit lost with how to structure it in Rails.
Basicly, it is a database for a business that has to store information aboout
Councils, Project Builders and fees respectively.
For each council there is static fees, but for each Project Builder there is fees that are unique to each Council.
I want the data to be displayed by, Council displaying all the static council fees. (Easy part, got that working fine.)
And for each Project Builder to display a list of Councils and their respective fees (which are unique to that council for that builder. Quite baffled here.)
I was thinking, to have a table for each Project Builder, with Council as the unique ID. But I don't know how to let the user create a table with RoR, and then be able to populate it with rows.
Thanks for any advice, this has been driving me crazy for days.