Salsa Database Structure (partial)

In the process of creating some reports for a client the other day, for the umpteenth time I found myself wishing for a visual picture of the back-end database for Salsa. I worked up a partial diagram, including the tables that I was particularly curious about. Note that I have *only* included primary and foreign key fields -- just as a way to map the relationships between the tables.

If you'd like to view the diagram (ERD style) click on this thumbnail, or right-click and choose "Save Link As..." save the image to your computer. (Note: Do not choose "Save Image As" on this page or you will only get the thumbnail.)

UPDATE 2010-09-02: An omitted join table has been added (supporter-chapter), and the number of crossing lines has been minimized by color-coding chapter_KEY wherever it occurs rather than drawing lines for the chapter_KEY relationships. Much easier to interpret now!