User Tools

Site Tools


acq:serials:basic_predicting_and_receiving

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
acq:serials:basic_predicting_and_receiving [2010/05/13 16:49] – fixed constraints, more constraints, dropped 'dummy' cols dbw2acq:serials:basic_predicting_and_receiving [2022/02/10 13:34] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ====== Proposal: Serials - Basic Predicting and Receiving ====== ====== Proposal: Serials - Basic Predicting and Receiving ======
 FIXME This proposal is still in progress, please do not edit yet FIXME FIXME This proposal is still in progress, please do not edit yet FIXME
 +
 +Okay - but let's keep a link to the [[https://docs.google.com/drawings/view?id=196Cyl9CAIzZ33cOVt0AphvUSbAwc9kfRGRB5Nz-5tTI&hl=en&pli=1|latest schema diagram]] handy, at least.
 +
 ===== Summary ===== ===== Summary =====
 Now that MFHD records can be added and are linked to bib records, the next step is to start populating the issuance table in order to predict and receive issues. As issues are received the MFHD record must be updated accordingly.  This proposal will focus on fleshing-out the database schema and defining how the MFHD record will hook in. Now that MFHD records can be added and are linked to bib records, the next step is to start populating the issuance table in order to predict and receive issues. As issues are received the MFHD record must be updated accordingly.  This proposal will focus on fleshing-out the database schema and defining how the MFHD record will hook in.
Line 71: Line 74:
         date_published TIMESTAMP WITH TIME ZONE DEFAULT NULL,         date_published TIMESTAMP WITH TIME ZONE DEFAULT NULL,
         holding_code TEXT DEFAULT NULL,         holding_code TEXT DEFAULT NULL,
-        holding_type TEXT DEFAULT NULL CHECK (holding_type IN (NULL,'basic','supplement','index')),+        holding_type TEXT DEFAULT NULL CHECK ( holding_type IS NULL OR holding_type IN ('basic','supplement','index') ),
         holding_link_id INT DEFAULT NULL         holding_link_id INT DEFAULT NULL
  -- TODO: add columns for separate enumeration/chronology values  -- TODO: add columns for separate enumeration/chronology values
Line 318: Line 321:
   - The system will then temporarily reinstantiate the last available issuance for the journal in question, predict another issuance based on this instance, then add the new issuance to the database.   - The system will then temporarily reinstantiate the last available issuance for the journal in question, predict another issuance based on this instance, then add the new issuance to the database.
 It is also desirable for the user to have the ability to 'regenerate all predictions' for any given serial. It is also desirable for the user to have the ability to 'regenerate all predictions' for any given serial.
 +
 +===== Historical info of potential interest =====
 +[[acq:serials:proto_schema_geometry|Proto-schema using geometric datatypes for issuance tracking and indexing]]
  
 ===== Status Updates ===== ===== Status Updates =====
 +  * 2010-05-17: Added historical proto-schema
   * 2010-05-03: Schema and diagram updated   * 2010-05-03: Schema and diagram updated
   * 2010-03-03: Schema proposal update, diagram added   * 2010-03-03: Schema proposal update, diagram added
   * 2009-11: Initial preview   * 2009-11: Initial preview
acq/serials/basic_predicting_and_receiving.1273783781.txt.gz · Last modified: 2022/02/10 13:33 (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

© 2008-2022 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a U.S. 501(c)3 non-profit organization.