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 systema

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

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 (biblio.record_e

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 >

[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 v