Click here to get back home

Database design (need help with a schema)

 HomeNewsGroups | Search | About
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Database design (need help with a schema) tekhneek 08-20-2006
Get Chitika Premium
Posted by tekhneek on August 20, 2006, 3:43 am
Please log in for more thread options
I'm building a site for my family & friends to all keep in touch and
the two features I'm coming to a halt about is this (in database
design)
I let users create their own pages (with a title and content) but there
is pre-defined pages that every user has and SOME are user specific.

For example, blog, calendar and comments are 3 normal pages everyone
will have on their profile page, where, tour dates and projects are
pages only my brother should have (because he's a musician) Then on top
of that...
There are "objects" like photos, videos, tags, favorites, etc. Music...
whatever they want.

I'm trying to figure out how to do this in a database.

To have "system" pages that every user will have depening on, what user
type they are? and then to allow a user to create his own custom pages
AND possibly include DYNAMIC widgets inside these pages!

Also, the blocks and objects should be interchangeable with pages
(unless the page is a system page) so, a user can drag his photos into
his custom "Gallery" page and the object stays within that page.

I'm just trying to figure out how to set this up with a database. I
need help.

So, if you didn't get all of that, I'll try to be as frank as possible
right here.
I need system pages that all users will have (depending on their user
type) and I need to allow them to create their own custom pages AND
manage all of the pages weight. System or Custom page.

I want custom pages to be able to have widgets (like photos, and
things) and the profile page of the user already has objects that
aren't pages (like sidebar widgets)


Similar ThreadsPosted
Database schema ideas November 25, 2005, 9:10 am
Question about database design August 22, 2005, 9:35 pm
Database design question November 30, 2005, 5:06 am
looking for recommendation for database design book August 8, 2005, 11:44 am
Database design/ query question August 6, 2006, 10:24 am
Help With Database Design: Multiple Vendor Data Submitting November 15, 2005, 12:19 pm
Question about schema October 28, 2006, 8:51 pm
Copying a table from one schema to another January 29, 2006, 11:41 pm
partial schema retrieval November 18, 2006, 4:05 pm
adding contraints FK refs to existing schema April 19, 2006, 11:25 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap