Entity Relationship Diagram

Steven Ensslen

Hi ?
I load a backup of RE into my data lake and then run further analysis of it there.
A lot of time is spent trying to figure out the relationships between objects, i.e. what are the correct SQL joins to get from table A to table B.
I presume there's a document with a diagram in it somewhere, but I haven't located it yet. Can someone post a link?

Thanks,
Steven

Alan French

@Steven Ensslen you would think so, wouldn't you? ? I've never seen one, just a schema document that hasn't been updated in years so it doesn't cover any of the new tables like consents etc. I don't even think it reflects the changes to phones and emails in 7.94.

If you're self-hosted, the schema should be here: C:\\Program Files (x86)\\Blackbaud\\The Raisers Edge 7\\Help\\RE7Schema.chm

Alex Wong

@Steven Ensslen
If you are still looking for this. here's the one for v7.96 which includes phone/email “detachment” from address.RE7Schema.zip