Update the new schema appendix to include notes. Change formatting to not use docbook...
[working/Evergreen.git] / 2.0 / appendices / schema.xml
index 7916c66..763f1c0 100644 (file)
-<?xml version="1.0" encoding="UTF-8" ?>\r
-<appendix id="databaseschema">\r
-       <title>Database Schema</title>\r
-       <para>This is the schema for the Evergreen database.</para>\r
-       \r
-       <section id="acq.schema">\r
-               <title>Schema acq</title>\r
-               \r
-               <simplesect id="acq.table.currency-type" xreflabel="acq.currency_type">         \r
-                       <title>currency_type</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>label</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>          \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                                       <itemizedlist>\r
-                                               <title>Tables referencing acq.exchange_rate via Foreign Key Constraints</title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.exchange-rate"/></para>\r
-                                                       </listitem><listitem>\r
-                                                               <para><xref linkend="acq.table.fund"/></para>\r
-                                                       </listitem><listitem>\r
-                                                               <para><xref linkend="acq.table.fund-debit"/></para>\r
-                                                       </listitem>\r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.funding-source"/></para>\r
-                                                       </listitem>\r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.provider"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                       </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.distribution-formula" xreflabel="acq.distribution_formula">           \r
-                       <title>distribution_formula</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>owner</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>skip_count</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.distribution_formula_entry via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.distribution-formula-entry"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.distribution-formula-entry" xreflabel="acq.distribution_formula_entry">               \r
-                       <title>distribution_formula_entry</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>formula</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="acq.table.distribution-formula"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>position</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>item_count</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>owning_lib</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="actor.table.org-unit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>location</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="asset.table.copy-location"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                                       <variablelist>\r
-                                               <title>Constraints on distribution_formula_entry</title>\r
-                                               \r
-                                               <varlistentry>\r
-                                                       <term>acqdfe_must_ be_somewhere</term>\r
-                                                       <listitem><para>CHECK (((owning_lib IS NOT NULL) OR (location IS NOT NULL)))</para></listitem>\r
-                                               </varlistentry>\r
-                                               \r
-                                       </variablelist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.exchange-rate" xreflabel="acq.exchange_rate">         \r
-                       <title>exchange_rate</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>from_currency</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="acq.table.currency-type"/>\r
-                                                                               \r
-                                                                       \r
-                                                                               \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>to_currency</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="acq.table.currency-type"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>ratio</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.fiscal-calendar" xreflabel="acq.fiscal_calendar">             \r
-                       <title>fiscal_calendar</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.fiscal_year via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.fiscal-year"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.fiscal-year" xreflabel="acq.fiscal_year">             \r
-                       <title>fiscal_year</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>calendar</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1 ;UNIQUE#2; NOT NULL;\r
-                                                               <xref linkend="acq.table.fiscal-calendar"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>year</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>year_begin</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>UNIQUE#2; NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>year_end</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.fund" xreflabel="acq.fund">           \r
-                       <title>fund</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>org</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#2; UNIQUE#1; NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>year</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#2; UNIQUE#1; NOT NULL; DEFAULT date_part( &apos;year&apos;::text, now() );</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>currency_type</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.currency-type"/> </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#2;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.fund_allocation via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.fund-allocation"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.fund-debit"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.fund-tag-map"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.fund-allocation" xreflabel="acq.fund_allocation">             \r
-                       <title>fund_allocation</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>funding_source</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.funding-source"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.fund"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>percent</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>allocator</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>note</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>create_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now(); </entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                                       <variablelist>\r
-                                               <title>Constraints on fund_allocation</title>\r
-                                               \r
-                                               <varlistentry>\r
-                                                       <term>allocation_amount _or_percent</term>\r
-                                                       <listitem><para>CHECK ((((percent IS NULL) AND (amount IS NOT NULL)) OR ((percent IS NOT NULL) AND (amount IS NULL))))</para></listitem>\r
-                                               </varlistentry>\r
-                                               \r
-                               \r
-                               \r
-                                               <varlistentry>\r
-                                                       <term>fund_allocation_ percent_check</term>\r
-                                                       <listitem><para>CHECK (((percent IS NULL) OR ((percent &gt;= 0.0) AND (percent &lt;= 100.0))))</para></listitem>\r
-                                               </varlistentry>\r
-                                               \r
-                                       </variablelist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.view.fund-allocation-total" xreflabel="acq.fund_allocation_total">          \r
-                       <title>fund_allocation_total</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>\r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric(100,2)</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.view.fund-combined-balance" xreflabel="acq.fund_combined_balance">          \r
-                       <title>fund_combined_balance</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.fund-debit" xreflabel="acq.fund_debit">               \r
-                       <title>fund_debit</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.fund"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>origin_amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>origin_currency_type</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.currency-type"/> </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>encumbrance</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry>NOT NULL; DEFAULT true;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>debit_type</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>xfer_destination</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="acq.table.fund"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>create_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.lineitem_detail via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.view.fund-debit-total" xreflabel="acq.fund_debit_total">            \r
-                       <title>fund_debit_total</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>encumbrance</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.view.fund-encumbrance-total" xreflabel="acq.fund_encumbrance_total">                \r
-                       <title>fund_encumbrance_total</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.view.fund-spent-balance" xreflabel="acq.fund_spent_balance">                \r
-                       <title>fund_spent_balance</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.view.fund-spent-total" xreflabel="acq.fund_spent_total">            \r
-                       <title>fund_spent_total</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.fund-tag" xreflabel="acq.fund_tag">           \r
-                       <title>fund_tag</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>owner</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.fund_tag_map via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.fund-tag-map"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.fund-tag-map" xreflabel="acq.fund_tag_map">           \r
-                       <title>fund_tag_map</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="acq.table.fund"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>tag</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; <xref linkend="acq.table.fund-tag"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.funding-source" xreflabel="acq.funding_source">               \r
-                       <title>funding_source</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>owner</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>currency_type</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.currency-type"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.fund_allocation via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.fund-allocation"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.funding-source-credit"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.view.funding-source-allocation-total" xreflabel="acq.funding_source_allocation_total">              \r
-                       <title>funding_source_allocation_total</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>funding_source</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric(100,2)</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.view.funding-source-balance" xreflabel="acq.funding_source_balance">                \r
-                       <title>funding_source_balance</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>funding_source</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>\r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric(100,2)</entry>\r
-                                                               <entry>\r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.funding-source-credit" xreflabel="acq.funding_source_credit">         \r
-                       <title>funding_source_credit</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>funding_source</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.funding-source"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>note</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.view.funding-source-credit-total" xreflabel="acq.funding_source_credit_total">              \r
-                       <title>funding_source_credit_total</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>funding_source</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>amount</entry>\r
-                                                               <entry>numeric</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.lineitem" xreflabel="acq.lineitem">           \r
-                       <title>lineitem</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>bigserial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>creator</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>editor</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL;<xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>selector</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL;<xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>provider</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="acq.table.provider"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>purchase_order</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="acq.table.purchase-order"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>picklist</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="acq.table.picklist"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>expected_recv_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>create_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>edit_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now(); </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>marc</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>eg_bib_id</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="biblio.table.record-entry"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>source_label</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>item_count</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>state</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;DEFAULT &apos;new&apos;::text;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                                       <variablelist>\r
-                                               <title>Constraints on lineitem</title>\r
-                                               \r
-                                               <varlistentry>\r
-                                                       <term>picklist_or_po</term>\r
-                                                       <listitem><para>CHECK (((picklist IS NOT NULL) OR (purchase_order IS NOT NULL)))</para></listitem>\r
-                                               </varlistentry>\r
-                                               \r
-                                       </variablelist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.lineitem_attr via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.lineitem-attr"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.lineitem-note"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.lineitem-attr" xreflabel="acq.lineitem_attr">         \r
-                       <title>lineitem_attr</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>bigserial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>definition</entry>\r
-                                                               <entry>bigint</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>lineitem</entry>\r
-                                                               <entry>bigint</entry>\r
-                                                               <entry>NOT NULL;<xref linkend="acq.table.lineitem"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>attr_type</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>attr_name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>attr_value</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.lineitem-attr-definition" xreflabel="acq.lineitem_attr_definition">           \r
-                       <title>lineitem_attr_definition</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>bigserial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>description</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>remove</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>ident</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.lineitem-detail" xreflabel="acq.lineitem_detail">             \r
-                       <title>lineitem_detail</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>bigserial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>lineitem</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.lineitem"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="acq.table.fund"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>fund_debit</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="acq.table.fund-debit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>eg_copy_id</entry>\r
-                                                               <entry>bigint</entry>\r
-                                                               <entry><xref linkend="asset.table.copy"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>barcode</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>cn_label</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>note</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>collection_code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>circ_modifier</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry><xref linkend="config.table.circ-modifier"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>owning_lib</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="actor.table.org-unit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>location</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry><xref linkend="asset.table.copy-location"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>recv_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.lineitem-generated-attr-definition" xreflabel="acq.lineitem_generated_attr_definition">               \r
-                       <title>lineitem_generated_attr_definition</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>bigint</entry>\r
-                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>description</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>remove</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>ident</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>xpath</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-               </para>\r
-               </simplesect>\r
-               <simplesect id="acq.table.lineitem-local-attr-definition" xreflabel="acq.lineitem_local_attr_definition">               \r
-                       <title>lineitem_local_attr_definition</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>bigint</entry>\r
-                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>description</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>remove</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>ident</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry>NOT NULL;DEFAULT false;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.lineitem-marc-attr-definition" xreflabel="acq.lineitem_marc_attr_definition">         \r
-                       <title>lineitem_marc_attr_definition</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>bigint</entry>\r
-                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>description</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>remove</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>ident</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>xpath</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.lineitem-note" xreflabel="acq.lineitem_note">         \r
-                       <title>lineitem_note</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>lineitem</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.lineitem"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>creator</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>editor</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>create_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>edit_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>value</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.lineitem-provider-attr-definition" xreflabel="acq.lineitem_provider_attr_definition">         \r
-                       <title>lineitem_provider_attr_definition</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>bigint</entry>\r
-                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>description</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>remove</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>ident</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>xpath</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>provider</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.provider"/> </entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.lineitem-usr-attr-definition" xreflabel="acq.lineitem_usr_attr_definition">           \r
-                       <title>lineitem_usr_attr_definition</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>bigint</entry>\r
-                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );\r
-                                                                       \r
-                                                                       \r
-                                                                               \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>description</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>remove</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>ident</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>usr</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.picklist" xreflabel="acq.picklist">           \r
-                       <title>picklist</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>owner</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>creator</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>editor</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>org_unit</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>create_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL;DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>edit_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL;DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.lineitem via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.lineitem"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.po-note" xreflabel="acq.po_note">             \r
-                       <title>po_note</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>purchase_order</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL;<xref linkend="acq.table.purchase-order"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>creator</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL;<xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>editor</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL;<xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>create_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>edit_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>value</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry> NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.provider" xreflabel="acq.provider">           \r
-                       <title>provider</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#1;NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>owner</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#2;UNIQUE#1;NOT NULL;<xref linkend="actor.table.org-unit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>currency_type</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;<xref linkend="acq.table.currency-type"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#2;NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>holding_tag</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.lineitem via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.lineitem"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.lineitem-provider-attr-definition"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.provider-address"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.provider-contact"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.provider-holding-subfield-map"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.purchase-order"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.provider-address" xreflabel="acq.provider_address">           \r
-                       <title>provider_address</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>valid</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry>NOT NULL; DEFAULT true;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>address_type</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>provider</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.provider"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>street1</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>street2</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>city</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>county</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>state</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>country</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>post_code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.provider-contact" xreflabel="acq.provider_contact">           \r
-                       <title>provider_contact</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>provider</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.provider"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>role</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>email</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>phone</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.provider_contact_address via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.provider-contact-address"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.provider-contact-address" xreflabel="acq.provider_contact_address">           \r
-                       <title>provider_contact_address</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>valid</entry>\r
-                                                               <entry>boolean</entry>\r
-                                                               <entry>NOT NULL; DEFAULT true;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>address_type</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>contact</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.provider-contact"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>street1</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>street2</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>city</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>county</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>state</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>country</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>post_code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para></para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.provider-holding-subfield-map" xreflabel="acq.provider_holding_subfield_map">         \r
-                       <title>provider_holding_subfield_map</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>provider</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="acq.table.provider"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>UNIQUE#1;NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>subfield</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                               \r
-               </para>\r
-               </simplesect>\r
-               \r
-               <simplesect id="acq.table.purchase-order" xreflabel="acq.purchase_order">               \r
-                       <title>purchase_order</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>id</entry>\r
-                                                               <entry>serial</entry>\r
-                                                               <entry>PRIMARY KEY</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>owner</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>creator</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>editor</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>ordering_agency</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>create_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>edit_time</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>provider</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>NOT NULL; <xref linkend="acq.table.provider"/></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>state</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL; DEFAULT &apos;new&apos;::text;</entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>order_date</entry>\r
-                                                               <entry>timestamp with time zone</entry>\r
-                                                               <entry></entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>name</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>NOT NULL;</entry>\r
-                                                       </row>\r
-                                               \r
-                                               </tbody>\r
-                                       </tgroup>\r
-                               </informaltable>\r
-                               <para>\r
-                               \r
-                               \r
-                               \r
-                                       <itemizedlist>\r
-                                               <title>\r
-                                                       Tables referencing acq.lineitem via Foreign Key Constraints\r
-                                               </title>\r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.lineitem"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                               \r
-                               \r
-                                                       <listitem>\r
-                                                               <para><xref linkend="acq.table.po-note"/></para>\r
-                                                       </listitem>\r
-                                                       \r
-                                       </itemizedlist>\r
-                                       \r
-               </para>\r
-               </simplesect>\r
-               \r
-       </section>\r
-       \r
-       <section id="action.schema">\r
-               <title>Schema action</title>\r
-               \r
-               <simplesect id="action.table.aged-circulation" xreflabel="action.aged_circulation">             \r
-                       <title>aged_circulation</title>\r
-                       <informaltable>\r
-                               <tgroup cols="3">\r
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
-                                       <thead>\r
-                                               <row>\r
-                                                       <entry>Field</entry>\r
-                                                       <entry>Data Type</entry>\r
-                                                       <entry>Constraints and References</entry>\r
-                                               </row>\r
-                                               </thead>\r
-                                               <tbody>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>usr_post_code</entry>\r
-                                                               <entry>text</entry>\r
-                                                               <entry>\r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>usr_home_ou</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>\r
-                                                                       \r
-                                                                       \r
-                                                                               NOT NULL;\r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>usr_profile</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>\r
-                                                                       \r
-                                                                       \r
-                                                                               NOT NULL;\r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>usr_birth_year</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>\r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>copy_call_number</entry>\r
-                                                               <entry>integer</entry>\r
-                                                               <entry>\r
-                                                                       \r
-                                                                       \r
-                                                                               NOT NULL;\r
-                                                                       \r
-                                                                       \r
-                                                                       \r
-                                                                       </entry>\r
-                                                       </row>\r
-                                               \r
-                                                       <row>\r
-                                                               <entry>copy_location</entry>\r
-