acq:serials:basic_predicting_and_receiving
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
acq:serials:basic_predicting_and_receiving [2010/05/13 16:49] – fixed constraints, more constraints, dropped 'dummy' cols dbw2 | acq: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:// | ||
+ | |||
===== 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. | 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. | ||
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,' | + | holding_type TEXT DEFAULT NULL CHECK ( holding_type IS NULL OR holding_type IN (' |
holding_link_id INT DEFAULT NULL | holding_link_id INT DEFAULT NULL | ||
-- TODO: add columns for separate enumeration/ | -- TODO: add columns for separate enumeration/ | ||
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 ' | It is also desirable for the user to have the ability to ' | ||
+ | |||
+ | ===== Historical info of potential interest ===== | ||
+ | [[acq: | ||
===== 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)