Above is the new database design I have come up with. I’ve completed the redesign of the database tables to suit this too. This meant re-creating lots of the test data as well. It became a very lengthy task in the end. I wish i had the feedback a little earlier so I could of done these changes last week. Anyway I now need to create a set of procedure that fit this. I’ve made quite few but a few will need to be changed to match the new database layout.
Im also going to meet up with Jared tomorrow to give him a hand.