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

2018-06-04 Thread Carol Yarrison 
Yes, thank you.

On Thu, May 31, 2018 at 2:55 PM, JonGeorg SageLibrary <
jongeorg.sagelibr...@gmail.com> wrote:

> That's exactly what I was looking for. Thank you!
> -Jon
>
> On Thu, May 31, 2018 at 11:43 AM, Kathy Lussier 
> wrote:
>
>> 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-ZoNfHfJ9
>> xBojIqpichQR?usp=sharing
>>
>> Kathy Lussier
>>
>> On Wed, May 30, 2018 at 6:45 PM, JonGeorg SageLibrary <
>> jongeorg.sagelibr...@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.soulli...@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 >>> .georgialibraries.org> *On Behalf Of *JonGeorg SageLibrary
 *Sent:* Wednesday, May 30, 2018 3:37 PM
 *To:* open-ils-general@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.

>>>
>>>
>>
>


-- 
“What in the world would we do without our libraries?”
― Katharine Hepburn


Carol Yarrison
Help Desk Coordinator/Trainer
Bibliomation, Inc
24 Wooster Ave
Waterbury, CT
203-577-4070 x112

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

2018-05-31 Thread JonGeorg SageLibrary 
That's exactly what I was looking for. Thank you!
-Jon

On Thu, May 31, 2018 at 11:43 AM, Kathy Lussier 
wrote:

> 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.sagelibr...@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.soulli...@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 >> .georgialibraries.org> *On Behalf Of *JonGeorg SageLibrary
>>> *Sent:* Wednesday, May 30, 2018 3:37 PM
>>> *To:* open-ils-general@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.
>>>
>>
>>
>

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

2018-05-31 Thread 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.sagelibr...@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  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 > .georgialibraries.org> *On Behalf Of *JonGeorg SageLibrary
>> *Sent:* Wednesday, May 30, 2018 3:37 PM
>> *To:* open-ils-general@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.
>>
>
>

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

2018-05-30 Thread JonGeorg SageLibrary 
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.soulli...@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  list.georgialibraries.org> *On Behalf Of *JonGeorg SageLibrary
> *Sent:* Wednesday, May 30, 2018 3:37 PM
> *To:* open-ils-general@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.
>

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

2018-05-30 Thread Soulliere, Robert 
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  On 
Behalf Of JonGeorg SageLibrary
Sent: Wednesday, May 30, 2018 3:37 PM
To: open-ils-general@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.