database design for private area
I need to set up a private area on a website. It should have several pages with text and pictures at the same time. I created some tables but not sure if it is the best to design them.
table Menu(id,menu_text,url, parent,order)
I am not sure how I link content items with menu items. Do I need to create a field in the content table called Menu_id which has id from Menu table? Is it the best way?
I never created a database driven website before so any suggestions would be grately appreciated.