Need to know about some relationships
Posted by: Sajith Perera
Date: February 24, 2012 12:34PM

Hello there, I have a small problem. Its about the table pattern and some relationships...
This is my explanation...

I have my own web application with multi user registrations.
After registration, they can create a page for free.
After that they can modify the pages too.
In this case I have giving them some opportunities to buy some logo packs to modify own page as them wish.
There are 3 logo packs.
In user by user must be save in database, which logo packs they already purchased.
Example, User1 have Pack2/Pack3. User2 have Pack1/Pack2/Pack3. User3 have Pack3.
In admin panel, they must have to use the packs which already purchased.

I want to know that what is the relationship about those tables? or Which pattern of MySQL?
Single User table and More tables for each Logo Packs? or Single user table and single table for every logo packs? and or What relationships?

Please explain how to do this... please...

Options: ReplyQuote


Subject
Written By
Posted
Need to know about some relationships
February 24, 2012 12:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.