-
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)
table Content(id,title,content,image)
table Users(id,username,password,name,institution,created,modified)
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.
Thank you.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks