RE7 Media file locations in SQL schema?

Ryan Gillies

Hello all, is there anyway to determine in Raisers Edge 7 the file storage locations for media that hasn't been embedded? I've searched through the database schema but I haven't had luck identifying possible fields, only embedded objects. Thanks!

Alex Wong

not sure exactly what you are trying to find. here's the table for constituent media

Ryan Gillies

Hi @Alex Wong, thanks for the reply, that's the table I'm currently looking at, but all I see are the embedded objects. If the media is linked rather than embedded, how does RE7 record this?

Alex Wong

I would think it's in the same table. However, I do not currently have access to a SQL db backup to test.

If you know a constituent record have a "link" type media but is not in the MEDIA table, then ask BB Support. (note, the PARENT_ID field is the system record id of the consittuent in the RECORDS table)

Here's a KB, maybe helpful

How to write a SQL statement to determine the type of media object stored in the MEDIA table