Member Avatar for SunnySideUp

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
  • 110 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by SunnySideUp
Member Avatar for theonly

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.

Member Avatar for SunnySideUp

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.