I'm trying to create a simple advertisment booking system for a community newspaper. The paper is published (printed) every two weeks and relies on local small businesses taking out small ads.
We want to keep track of all of our customers, and their bookings both past and future.
Each issue has it's own number number (e.g. Issue 138 will be published on 21 March).
I'm just wondering what is the best design for each table of data?
Should I have a table for each issue? I know I need a table of customers. I'd also like to be able to add notes to each customer record (for phone calls etc.).
Structure is what I looking for!
Any help appreciated.