nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Query Import Export

Comments

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