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

2009-12-08 Thread Repke de Vries
Acquisitions is one addition in 1.6, Serials and all holding information in *separate* records (following MFHD) another: is there an update of the 1.4 schema below that covers the 1.6 serials schema and everything related ? Did a Google search and found bits and pieces but nothing

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

2009-12-07 Thread Jesse Ephraim
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

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

2009-12-07 Thread Jason Etheridge
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

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

2009-12-07 Thread 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

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

2009-12-07 Thread Jesse Ephraim
Don and Jason; That's perfect - exactly what I needed! Thanks much (and thanks for the link to the schema)! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com