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.