Perhaps it'd help you to check out a framework that "does MVC" and see how the tables/columns are setup in that DB...?
For example: http://cfwheels.org/docs/1-1/chapter/beginner-tutorial-hello-database On Sat, Jul 28, 2012 at 4:54 AM, Andrew Scott <andr...@andyscott.id.au>wrote: > > Well I am not sure what your looking at achieving either, the question you > posed was answered correctly. > > The thing that you need to take into consideration, that everything you do > whether it is MVC or not has nothing to do with the design of a database. > The reason behind this is that something like a database is and should be > considered a different tier to your application design. > > So if you are after something more specific, the answer given is exactly > that, what exactly are you trying to achieve in your design? > > -- > Regards, > Andrew Scott > WebSite: http://www.andyscott.id.au/ > Google+: http://plus.google.com/113032480415921517411< > http://plus.google.com/108193156965451149543> > > > > On Sat, Jul 28, 2012 at 5:52 PM, Don <danfar...@hotmail.com> wrote: > > > > > Sounds to me like you didn't understand the question! > > > > >Speaking from a purist perspective, the database has nothing to do with > > >MVC. Perhaps you should ask more specific questions so folks can have > an > > >idea of what you're really after? > > > > > >HTH > > > > > > > > > > > > > > >> > > >> What are some best practices in structuring the website database to > > >> accomodate good integration with an MVC model? > > >> > > >> > > >> > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352007 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm