[elchief]

Some enterprise data model links here:

https://dba.stackexchange.com/questions/12991/ready-to-use-d...

Instead of soft deletes, move records to a history table

I agree w session issue. Had to rebuild sessions before and is a pita compared to just recording them at source

[konfusinomicon]

Good list in there. Len silverstons data model resource books are amazing.. especially volume 3. Reading that book and getting to the point where I actually understood the most generalized patterns in it was a total game changer for me