How to make this tables

[phpmady]

Hi Guys,

 

I building a system, where i have a customer table where user info is saved, and customer can choose the package like silver, gold, and platinum

 

customer table:

 

ID

Username

Password

Name

Address

Active

 

 

Now i want to make a table for choosing packages:

 

package table:

 

Package_ID

Package_Name

Package_Description

Package_Duration

Package_Amount

Package_Active

 

 

1.Now my doubt is, whether Duration can be kept in days/month

 

for example:

90 days or January, February, March

 

2.Package_Amount: what currency to be specify.

Because am building a system for international users, what currency to be specify.

(500 INR or 10USD)

 

3. what about upgrade of package: give me some ideas how to handle this.

 

Please Help me, and i guess i have a design a table right.

 

Thanks,

 

 

 

 

[sunfighter]

If you only allow one package per customer you can combine all info into one table.

 

If they can have more than one then the two tables you propose is good BUT you need to link customer table: and link that to the package table: Or do the link via ID.

 

Duration. Make two columns A start time and an end time. Now you don't need to do math when you check the tables.

 

You can store the Package_Amount: as 10USD if you want. Or make two columns - your choice.

 

Upgrading or changing the package is done via forms.