(click inside the picture to download full-size version)
The schema was extracted with PostgreSQL Autodoc, then modified manually with dia, and exported in dia as a 2172 x 1928 PNG file.
Links between tables (the arrows) normally represent foreign key constraints. In this case, they have been added manually (and liberally).