[OPEN-ILS-GENERAL] Question about the Database Schema

[Kathy Lussier]

Hi Jon,

Codey Kolasinski, who used to work for CW MARS, created some diagrams a
couple of years ago. They aren't current, but I'm hoping they're helpful.

https://drive.google.com/drive/folders/1VuhjLIWTKwT-ZoNfHfJ9xBojIqpichQR?usp=sharing

Kathy Lussier

On Wed, May 30, 2018 at 6:45 PM, JonGeorg SageLibrary <
jongeorg.sagelibrary at gmail.com> wrote:

> Thank you. I was actually aware of that link but am a very visual person
> and so was hoping there was something more 'diagramy' out there. I really
> appreciate the response though.
> -Jon
>
> On Wed, May 30, 2018 at 12:44 PM, Soulliere, Robert <robert.soulliere@
> mohawkcollege.ca> wrote:
>
>> Hi Jon,
>>
>>
>>
>> There are schema diagrams on the EG docs page:
>>
>> http://docs.evergreen-ils.org/
>>
>>
>>
>> There is a section called :
>> Database Schema Map
>>
>>
>>
>> Here is the schema for 3.1:
>>
>> http://docs.evergreen-ils.org/3.1_schema/
>>
>>
>>
>> It is not very “diagrammy”, but I use it all the time when putting
>> together queries and finding names of tables and fields.
>>
>>
>>
>> Cheers,
>>
>> Robert
>>
>>
>>
>>
>>
>>
>>
>> *From:* Open-ils-general <open-ils-general-bounces at list
>> .georgialibraries.org> *On Behalf Of *JonGeorg SageLibrary
>> *Sent:* Wednesday, May 30, 2018 3:37 PM
>> *To:* open-ils-general at list.georgialibraries.org
>> *Subject:* [OPEN-ILS-GENERAL] Question about the Database Schema
>>
>>
>>
>> This may be a silly question, but I'll ask it anyway. I'm hoping to find
>> someone that has done a relational diagram of the base Evergreen Database
>> Schema [it doesn't even have to be the most recent version] so that I can
>> better wrap my head around what is what and where it lives.
>>
>> -Jon
>>
>> ------------------------------
>>
>> This E-mail contains privileged and confidential information intended
>> only for the individual or entity named in the message. If the reader
>> of this message is not the intended recipient, or the agent responsible
>> to deliver it to the intended recipient, you are hereby notified that
>> any review, dissemination, distribution or copying of this communication
>> is prohibited. If this communication was received in error, please
>> notify the sender by reply E-mail immediately, and delete and destroy
>> the original message.
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20180531/11490ee1/attachment.html>