I am looking for a way to store user activity on the database, so you can see what has been adjusted on a site by who and when.

Currently have a structure like this

Site
  Notes
  CommunicationRecords
  Actions
    Task

If a user uploads or edits Notes or communication record, I want this information to be stored against the site, so when you go to the site you can then see the history.

I have a table called SiteHistory on Site and its basic for now, just a string, and siteID

This would work for stuff like Notes and Communication Record, however it would still be the Site parent that would control adding that history note to its self, but when you get down to Task it has no concept of who its Parent site is.

What is the best way to create a SiteHistory where you can call any of the properties that hang off site or their children and it logs it to the Site history, and then when its being displayed you only have to look up the site ID and all activity will be shown.

Having them hang off the Site, but gran-children do not contain the SiteID