Jump to content

I am having a problem with my logic on creating these tables


ccrevcypsys

Recommended Posts

I am having a problem with my logic on creating these tables

I want to have my home page so that people can add and remove sections that are displayed on that page. I also want them to be able to change the position of the sections. But i dont know how i should set up the db tables... So can someone help me?

 

The idea i had for them is this (but im sure it wont work):

 

----portals----          ----myHome----        ----portalPos----

portal_id      ---+      id                            id

portal_name      +---portal_id      -----+    position

                              customer_id        +---portal_id

 

   

         

Portal

-----

id

html

         

         

User

-----

id

first_name

last_name

         

         

User_Portal

-----

user_id

portal_id

         

   

 

When the user is created or a new portal is created, the portal(s) will be added.  The User_Portal table is a link between users and portals :)

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.