I’ve started to put together a diagram using the excellent MySQL Workbench (from Sun). The ERD does need splitting up into functional units, but here is what I have done so far: The complete model: phplist-2109.mwb The ERD as a PDF: model2.pdf Hope this is of some help. I will post updates when I get around to them, depending on feedback.