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...