--- /dev/null
+<?xml version="1.0" encoding="UTF-8" ?>\r
+<chapter 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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>label</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ </tbody>\r
+ </tgroup>\r
+ </informaltable>\r
+ <para>\r
+ \r
+ \r
+ \r
+ <itemizedlist>\r
+ <title>\r
+ Tables referencing acq.exchange_rate via Foreign Key Constraints\r
+ </title>\r
+ \r
+ <listitem>\r
+ <para><xref linkend="acq.table.exchange-rate"/></para>\r
+ </listitem>\r
+ \r
+ \r
+ \r
+ <listitem>\r
+ <para><xref linkend="acq.table.fund"/></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.funding-source"/></para>\r
+ </listitem>\r
+ \r
+ \r
+ \r
+ <listitem>\r
+ <para><xref linkend="acq.table.provider"/></para>\r
+ </listitem>\r
+ \r
+ </itemizedlist>\r
+ \r
+ \r
+ \r
+ \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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>owner</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="actor.table.org-unit"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>name</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>skip_count</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>formula</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.distribution-formula"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>position</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>item_count</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>owning_lib</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="actor.table.org-unit"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>location</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="asset.table.copy-location"/>\r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>from_currency</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.currency-type"/>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>to_currency</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.currency-type"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>ratio</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>name</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>calendar</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ UNIQUE#2\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.fiscal-calendar"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>year</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>year_begin</entry>\r
+ <entry>timestamp with time zone</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#2\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>year_end</entry>\r
+ <entry>timestamp with time zone</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>org</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#2\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="actor.table.org-unit"/>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>name</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>year</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#2\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ DEFAULT date_part('year'::text, now());\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>currency_type</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.currency-type"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>code</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#2\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>funding_source</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.funding-source"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>fund</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.fund"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>percent</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>allocator</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="actor.table.usr"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>note</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>create_time</entry>\r
+ <entry>timestamp with time zone</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ DEFAULT now();\r
+ \r
+ \r
+ </para></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 >= 0.0) AND (percent <= 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><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric(100,2)</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>fund</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.fund"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>origin_amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>origin_currency_type</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.currency-type"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>encumbrance</entry>\r
+ <entry>boolean</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ DEFAULT true;\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>debit_type</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>xfer_destination</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.fund"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>create_time</entry>\r
+ <entry>timestamp with time zone</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ DEFAULT now();\r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>encumbrance</entry>\r
+ <entry>boolean</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>owner</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="actor.table.org-unit"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>name</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>fund</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.fund"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>tag</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.fund-tag"/>\r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>name</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>owner</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE#1\r
+ ;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="actor.table.org-unit"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>currency_type</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.currency-type"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>code</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ UNIQUE;\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric(100,2)</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric(100,2)</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>funding_source</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.funding-source"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>note</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>amount</entry>\r
+ <entry>numeric</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></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><para>\r
+ \r
+ \r
+ PRIMARY KEY\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>creator</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="actor.table.usr"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>editor</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="actor.table.usr"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>selector</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="actor.table.usr"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>provider</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.provider"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>purchase_order</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.purchase-order"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>picklist</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="acq.table.picklist"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>expected_recv_time</entry>\r
+ <entry>timestamp with time zone</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>create_time</entry>\r
+ <entry>timestamp with time zone</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ DEFAULT now();\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>edit_time</entry>\r
+ <entry>timestamp with time zone</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ DEFAULT now();\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>marc</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>eg_bib_id</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ \r
+ <xref linkend="biblio.table.record-entry"/>\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>source_label</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>item_count</entry>\r
+ <entry>integer</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ <row>\r
+ <entry>state</entry>\r
+ <entry>text</entry>\r
+ <entry><para>\r
+ \r
+ \r
+ NOT NULL;\r
+ \r
+ \r
+ DEFAULT 'new'::text;\r
+ \r
+ \r
+ </para></entry>\r
+ </row>\r
+ \r
+ </tbody>\r
+ </tgroup>\r
+ </informaltable>\r
+ <para>\r
+ \r
+ \r
+ <variablelist>\r
+ <title>Constraints on lineitem</title>\r
+ \r