[OPEN-ILS-GENERAL] introduction and quick database question

[Don McMorris]

I believe you're looking for biblio.record_entry.  This (generally)
corresponds to the "source" or "record" value of your metabib tables
(if you do a '\d metabib.title_field_entry' [for example], you should
see a "foreign key constraint').

An item (asset.copy) will link to a title (biblio.record_entry) via a
volume (asset.call_number).

There are also a number of useful views in the reporter schema.

If you haven't yet seen it, this
(http://open-ils.org/documentation/evergreen-schema-1.4.0.2.html) can
be pretty helpful.  There are some additions in 1.6 (Ex: Acq), but I
find it quite helpful quite often.

Hope this helps!

--Don

On Mon, Dec 7, 2009 at 6:30 PM, Jesse Ephraim <jephraim at roanoketexas.com> wrote:
> I am the director of a library in a consortium of small libraries in the
> Dallas-Fort Worth metroplex area of Texas.  We launched Evergreen a few
> months ago.
>
>
>
> I am working on some reports that go beyond the basic capabilities of the
> built-in reporting tool in Evergreen, so I am pulling the data via standard
> SQL queries.   I have one quick question:
>
>
>
> I don’t see “title” and “author” information anywhere within any of the
> ASSET tables (other than empty “dummy_title” and “dummy_author” fields in
> asset_copy), so I looked to the METABIB table to pull that information.
> However, I am having trouble locating the common identifier to tie the
> tables together when I JOIN them so I can link the appropriate author and
> title information to the individual copies.  I know I must be overlooking
> something obvious, but if someone could give me a quick hint, I would really
> appreciate it!
>
>
>
> Thanks!
>
>
>
> Jesse Ephraim
>
>
>
> Director, Roanoke Public Library
>
> 308 S. Walnut
>
> Roanoke, Texas 76262
>
> (817) 491-2691
>
> jephraim at roanoketexas.com
>
>
>
>