0

Hi,

I am looking to create a Jobs Board Database which will work with PHP 5 and PayPal, but I am having trouble figuring out the relationships:

I know I might have a table for Company details and another one for Job Details but what do I do with regard to Package Details they purchase ?

1) A company/Employer can post a Job Advertisement based on one of the following packages they choose 1 month, 14 days, 7 days.

2) Do I need a seperate table for package details like ID, Description, Price, start date, end date.

I seem to be getting myself into a mess...

Any help would be much appreciated...

SunnySideUp

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by SunnySideUp
0

Using a separated table for package is my recommendation. Making the table "Package" a dependent (weak entity) of the table company/employer would benefit you in the long haul.

0

So could you exaplain a little more please....

I would call the package details from the database and display them on my page.

The Employer/Recruitment company would then get that package id and insert the id into the Employers and Job details table ?

Is that correct ??

Thanks

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.