I would like some suggestions on table design. The app I am writing has an accounts table and what I need to do is track the contracts and their version that the accounts have agreed to, the date they agreed to it, the expiration date of the contract, etc. Then in my PHP code I will need to check if any have expired or are expiring, generate reports on the accounts that haven't agreed to certain contracts, etc.
How many tables should I use? One for contracts and their versions, and one to relate the account and the acceptance date to that contract id?
Brian Snipes
How many tables should I use? One for contracts and their versions, and one to relate the account and the acceptance date to that contract id?
Brian Snipes