Differences

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

--- acq:serials:basic_predicting_and_receiving [2010/05/17 14:09] – miker
+++ 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 ======
 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 =====
 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,
         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
 	-- TODO: add columns for separate enumeration/chronology values