update 1.6 schema appendix to ver. 1.6.1.6.
[working/Evergreen.git] / 1.6 / appendices / schema1.6.1.6.xml
1 <?xml version="1.0" encoding="UTF-8" ?>\r
2 <chapter id="databaseschema">\r
3         <title>Database Schema</title>\r
4         <para>This is the schema for the Evergreen database.</para>\r
5         \r
6         <section id="acq.schema">\r
7                 <title>Schema acq</title>\r
8                 \r
9                 <simplesect id="acq.table.currency-type" xreflabel="acq.currency_type">         \r
10                         <title>currency_type</title>\r
11                         <informaltable>\r
12                                 <tgroup cols="3">\r
13                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
14                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
15                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
16                                         <thead>\r
17                                                 <row>\r
18                                                         <entry>Field</entry>\r
19                                                         <entry>Data Type</entry>\r
20                                                         <entry>Constraints and References</entry>\r
21                                                 </row>\r
22                                                 </thead>\r
23                                                 <tbody>\r
24                                                 \r
25                                                         <row>\r
26                                                                 <entry>code</entry>\r
27                                                                 <entry>text</entry>\r
28                                                                 <entry><para>\r
29                                                                         \r
30                                                                                 \r
31                                                                                         PRIMARY KEY\r
32                                                                                                                 \r
33                                                                         \r
34                                                                         \r
35                                                                         \r
36                                                                         \r
37                                                                         \r
38                                                                                 \r
39                                                                         \r
40                                                                         </para></entry>\r
41                                                         </row>\r
42                                                 \r
43                                                         <row>\r
44                                                                 <entry>label</entry>\r
45                                                                 <entry>text</entry>\r
46                                                                 <entry><para>\r
47                                                                         \r
48                                                                         \r
49                                                                         \r
50                                                                         \r
51                                                                         </para></entry>\r
52                                                         </row>\r
53                                                 \r
54                                                 </tbody>\r
55                                         </tgroup>\r
56                                 </informaltable>\r
57                                 <para>\r
58                                 \r
59                                 \r
60                                 \r
61                                         <itemizedlist>\r
62                                                 <title>\r
63                                                         Tables referencing acq.exchange_rate via Foreign Key Constraints\r
64                                                 </title>\r
65                                 \r
66                                                         <listitem>\r
67                                                                 <para><xref linkend="acq.table.exchange-rate"/></para>\r
68                                                         </listitem>\r
69                                                         \r
70                                 \r
71                                 \r
72                                                         <listitem>\r
73                                                                 <para><xref linkend="acq.table.fund"/></para>\r
74                                                         </listitem>\r
75                                                         \r
76                                 \r
77                                 \r
78                                                         <listitem>\r
79                                                                 <para><xref linkend="acq.table.fund-debit"/></para>\r
80                                                         </listitem>\r
81                                                         \r
82                                 \r
83                                 \r
84                                                         <listitem>\r
85                                                                 <para><xref linkend="acq.table.funding-source"/></para>\r
86                                                         </listitem>\r
87                                                         \r
88                                 \r
89                                 \r
90                                                         <listitem>\r
91                                                                 <para><xref linkend="acq.table.provider"/></para>\r
92                                                         </listitem>\r
93                                                         \r
94                                         </itemizedlist>\r
95                                 \r
96                                 \r
97                                 \r
98                                 \r
99                 </para>\r
100                 </simplesect>\r
101                 \r
102                 <simplesect id="acq.table.distribution-formula" xreflabel="acq.distribution_formula">           \r
103                         <title>distribution_formula</title>\r
104                         <informaltable>\r
105                                 <tgroup cols="3">\r
106                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
107                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
108                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
109                                         <thead>\r
110                                                 <row>\r
111                                                         <entry>Field</entry>\r
112                                                         <entry>Data Type</entry>\r
113                                                         <entry>Constraints and References</entry>\r
114                                                 </row>\r
115                                                 </thead>\r
116                                                 <tbody>\r
117                                                 \r
118                                                         <row>\r
119                                                                 <entry>id</entry>\r
120                                                                 <entry>serial</entry>\r
121                                                                 <entry><para>\r
122                                                                         \r
123                                                                                 \r
124                                                                                         PRIMARY KEY\r
125                                                                                                                 \r
126                                                                         \r
127                                                                         \r
128                                                                         \r
129                                                                         \r
130                                                                         \r
131                                                                                 \r
132                                                                         \r
133                                                                         </para></entry>\r
134                                                         </row>\r
135                                                 \r
136                                                         <row>\r
137                                                                 <entry>owner</entry>\r
138                                                                 <entry>integer</entry>\r
139                                                                 <entry><para>\r
140                                                                         \r
141                                                                                                                 \r
142                                                                         \r
143                                                                                 UNIQUE#1\r
144                                                                                 ;\r
145                                                                                 \r
146                                                                         \r
147                                                                                                                 \r
148                                                                         \r
149                                                                         \r
150                                                                         \r
151                                                                                 NOT NULL;\r
152                                                                         \r
153                                                                         \r
154                                                                         \r
155                                                                                 \r
156                                                                         \r
157                                                                                 \r
158                                                                                 <xref linkend="actor.table.org-unit"/>\r
159                                                                                 \r
160                                                                         \r
161                                                                         </para></entry>\r
162                                                         </row>\r
163                                                 \r
164                                                         <row>\r
165                                                                 <entry>name</entry>\r
166                                                                 <entry>text</entry>\r
167                                                                 <entry><para>\r
168                                                                         \r
169                                                                                                                 \r
170                                                                         \r
171                                                                                 UNIQUE#1\r
172                                                                                 ;\r
173                                                                                 \r
174                                                                         \r
175                                                                         \r
176                                                                                 NOT NULL;\r
177                                                                         \r
178                                                                         \r
179                                                                         \r
180                                                                                 \r
181                                                                         \r
182                                                                         </para></entry>\r
183                                                         </row>\r
184                                                 \r
185                                                         <row>\r
186                                                                 <entry>skip_count</entry>\r
187                                                                 <entry>integer</entry>\r
188                                                                 <entry><para>\r
189                                                                         \r
190                                                                         \r
191                                                                                 NOT NULL;\r
192                                                                         \r
193                                                                         \r
194                                                                         \r
195                                                                         </para></entry>\r
196                                                         </row>\r
197                                                 \r
198                                                 </tbody>\r
199                                         </tgroup>\r
200                                 </informaltable>\r
201                                 <para>\r
202                                 \r
203                                 \r
204                                 \r
205                                         <itemizedlist>\r
206                                                 <title>\r
207                                                         Tables referencing acq.distribution_formula_entry via Foreign Key Constraints\r
208                                                 </title>\r
209                                 \r
210                                                         <listitem>\r
211                                                                 <para><xref linkend="acq.table.distribution-formula-entry"/></para>\r
212                                                         </listitem>\r
213                                                         \r
214                                         </itemizedlist>\r
215                                 \r
216                                 \r
217                                 \r
218                                 \r
219                 </para>\r
220                 </simplesect>\r
221                 \r
222                 <simplesect id="acq.table.distribution-formula-entry" xreflabel="acq.distribution_formula_entry">               \r
223                         <title>distribution_formula_entry</title>\r
224                         <informaltable>\r
225                                 <tgroup cols="3">\r
226                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
227                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
228                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
229                                         <thead>\r
230                                                 <row>\r
231                                                         <entry>Field</entry>\r
232                                                         <entry>Data Type</entry>\r
233                                                         <entry>Constraints and References</entry>\r
234                                                 </row>\r
235                                                 </thead>\r
236                                                 <tbody>\r
237                                                 \r
238                                                         <row>\r
239                                                                 <entry>id</entry>\r
240                                                                 <entry>serial</entry>\r
241                                                                 <entry><para>\r
242                                                                         \r
243                                                                                 \r
244                                                                                         PRIMARY KEY\r
245                                                                                                                 \r
246                                                                         \r
247                                                                         \r
248                                                                         \r
249                                                                         \r
250                                                                         \r
251                                                                                 \r
252                                                                         \r
253                                                                         </para></entry>\r
254                                                         </row>\r
255                                                 \r
256                                                         <row>\r
257                                                                 <entry>formula</entry>\r
258                                                                 <entry>integer</entry>\r
259                                                                 <entry><para>\r
260                                                                         \r
261                                                                                                                 \r
262                                                                         \r
263                                                                                 UNIQUE#1\r
264                                                                                 ;\r
265                                                                                 \r
266                                                                         \r
267                                                                                                                 \r
268                                                                         \r
269                                                                         \r
270                                                                         \r
271                                                                                 NOT NULL;\r
272                                                                         \r
273                                                                         \r
274                                                                         \r
275                                                                                 \r
276                                                                         \r
277                                                                                 \r
278                                                                                 <xref linkend="acq.table.distribution-formula"/>\r
279                                                                                 \r
280                                                                         \r
281                                                                         </para></entry>\r
282                                                         </row>\r
283                                                 \r
284                                                         <row>\r
285                                                                 <entry>position</entry>\r
286                                                                 <entry>integer</entry>\r
287                                                                 <entry><para>\r
288                                                                         \r
289                                                                                                                 \r
290                                                                         \r
291                                                                                 UNIQUE#1\r
292                                                                                 ;\r
293                                                                                 \r
294                                                                         \r
295                                                                         \r
296                                                                                 NOT NULL;\r
297                                                                         \r
298                                                                         \r
299                                                                         \r
300                                                                                 \r
301                                                                         \r
302                                                                         </para></entry>\r
303                                                         </row>\r
304                                                 \r
305                                                         <row>\r
306                                                                 <entry>item_count</entry>\r
307                                                                 <entry>integer</entry>\r
308                                                                 <entry><para>\r
309                                                                         \r
310                                                                         \r
311                                                                                 NOT NULL;\r
312                                                                         \r
313                                                                         \r
314                                                                         \r
315                                                                         </para></entry>\r
316                                                         </row>\r
317                                                 \r
318                                                         <row>\r
319                                                                 <entry>owning_lib</entry>\r
320                                                                 <entry>integer</entry>\r
321                                                                 <entry><para>\r
322                                                                         \r
323                                                                                                                 \r
324                                                                         \r
325                                                                         \r
326                                                                         \r
327                                                                         \r
328                                                                         \r
329                                                                                 \r
330                                                                                 <xref linkend="actor.table.org-unit"/>\r
331                                                                                 \r
332                                                                         \r
333                                                                         </para></entry>\r
334                                                         </row>\r
335                                                 \r
336                                                         <row>\r
337                                                                 <entry>location</entry>\r
338                                                                 <entry>integer</entry>\r
339                                                                 <entry><para>\r
340                                                                         \r
341                                                                                                                 \r
342                                                                         \r
343                                                                         \r
344                                                                         \r
345                                                                         \r
346                                                                         \r
347                                                                                 \r
348                                                                                 <xref linkend="asset.table.copy-location"/>\r
349                                                                                 \r
350                                                                         \r
351                                                                         </para></entry>\r
352                                                         </row>\r
353                                                 \r
354                                                 </tbody>\r
355                                         </tgroup>\r
356                                 </informaltable>\r
357                                 <para>\r
358                                 \r
359                                 \r
360                                         <variablelist>\r
361                                                 <title>Constraints on distribution_formula_entry</title>\r
362                                                 \r
363                                                 <varlistentry>\r
364                                                         <term>acqdfe_must_be_somewhere</term>\r
365                                                         <listitem><para>CHECK (((owning_lib IS NOT NULL) OR (location IS NOT NULL)))</para></listitem>\r
366                                                 </varlistentry>\r
367                                                 \r
368                                         </variablelist>\r
369                                 \r
370                                 \r
371                                 \r
372                                 \r
373                                 \r
374                 </para>\r
375                 </simplesect>\r
376                 \r
377                 <simplesect id="acq.table.exchange-rate" xreflabel="acq.exchange_rate">         \r
378                         <title>exchange_rate</title>\r
379                         <informaltable>\r
380                                 <tgroup cols="3">\r
381                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
382                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
383                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
384                                         <thead>\r
385                                                 <row>\r
386                                                         <entry>Field</entry>\r
387                                                         <entry>Data Type</entry>\r
388                                                         <entry>Constraints and References</entry>\r
389                                                 </row>\r
390                                                 </thead>\r
391                                                 <tbody>\r
392                                                 \r
393                                                         <row>\r
394                                                                 <entry>id</entry>\r
395                                                                 <entry>serial</entry>\r
396                                                                 <entry><para>\r
397                                                                         \r
398                                                                                 \r
399                                                                                         PRIMARY KEY\r
400                                                                                                                 \r
401                                                                         \r
402                                                                         \r
403                                                                         \r
404                                                                         \r
405                                                                         \r
406                                                                                 \r
407                                                                         \r
408                                                                         </para></entry>\r
409                                                         </row>\r
410                                                 \r
411                                                         <row>\r
412                                                                 <entry>from_currency</entry>\r
413                                                                 <entry>text</entry>\r
414                                                                 <entry><para>\r
415                                                                         \r
416                                                                                                                 \r
417                                                                         \r
418                                                                         \r
419                                                                                                                 \r
420                                                                         \r
421                                                                                 UNIQUE#1\r
422                                                                                 ;\r
423                                                                                 \r
424                                                                         \r
425                                                                         \r
426                                                                                 NOT NULL;\r
427                                                                         \r
428                                                                         \r
429                                                                         \r
430                                                                                 \r
431                                                                                 <xref linkend="acq.table.currency-type"/>\r
432                                                                                 \r
433                                                                         \r
434                                                                                 \r
435                                                                         \r
436                                                                         </para></entry>\r
437                                                         </row>\r
438                                                 \r
439                                                         <row>\r
440                                                                 <entry>to_currency</entry>\r
441                                                                 <entry>text</entry>\r
442                                                                 <entry><para>\r
443                                                                         \r
444                                                                                                                 \r
445                                                                         \r
446                                                                                 UNIQUE#1\r
447                                                                                 ;\r
448                                                                                 \r
449                                                                         \r
450                                                                                                                 \r
451                                                                         \r
452                                                                         \r
453                                                                         \r
454                                                                                 NOT NULL;\r
455                                                                         \r
456                                                                         \r
457                                                                         \r
458                                                                                 \r
459                                                                         \r
460                                                                                 \r
461                                                                                 <xref linkend="acq.table.currency-type"/>\r
462                                                                                 \r
463                                                                         \r
464                                                                         </para></entry>\r
465                                                         </row>\r
466                                                 \r
467                                                         <row>\r
468                                                                 <entry>ratio</entry>\r
469                                                                 <entry>numeric</entry>\r
470                                                                 <entry><para>\r
471                                                                         \r
472                                                                         \r
473                                                                                 NOT NULL;\r
474                                                                         \r
475                                                                         \r
476                                                                         \r
477                                                                         </para></entry>\r
478                                                         </row>\r
479                                                 \r
480                                                 </tbody>\r
481                                         </tgroup>\r
482                                 </informaltable>\r
483                                 <para>\r
484                                 \r
485                                 \r
486                                 \r
487                                 \r
488                 </para>\r
489                 </simplesect>\r
490                 \r
491                 <simplesect id="acq.table.fiscal-calendar" xreflabel="acq.fiscal_calendar">             \r
492                         <title>fiscal_calendar</title>\r
493                         <informaltable>\r
494                                 <tgroup cols="3">\r
495                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
496                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
497                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
498                                         <thead>\r
499                                                 <row>\r
500                                                         <entry>Field</entry>\r
501                                                         <entry>Data Type</entry>\r
502                                                         <entry>Constraints and References</entry>\r
503                                                 </row>\r
504                                                 </thead>\r
505                                                 <tbody>\r
506                                                 \r
507                                                         <row>\r
508                                                                 <entry>id</entry>\r
509                                                                 <entry>serial</entry>\r
510                                                                 <entry><para>\r
511                                                                         \r
512                                                                                 \r
513                                                                                         PRIMARY KEY\r
514                                                                                                                 \r
515                                                                         \r
516                                                                         \r
517                                                                         \r
518                                                                         \r
519                                                                         \r
520                                                                                 \r
521                                                                         \r
522                                                                         </para></entry>\r
523                                                         </row>\r
524                                                 \r
525                                                         <row>\r
526                                                                 <entry>name</entry>\r
527                                                                 <entry>text</entry>\r
528                                                                 <entry><para>\r
529                                                                         \r
530                                                                         \r
531                                                                                 NOT NULL;\r
532                                                                         \r
533                                                                         \r
534                                                                         \r
535                                                                         </para></entry>\r
536                                                         </row>\r
537                                                 \r
538                                                 </tbody>\r
539                                         </tgroup>\r
540                                 </informaltable>\r
541                                 <para>\r
542                                 \r
543                                 \r
544                                 \r
545                                         <itemizedlist>\r
546                                                 <title>\r
547                                                         Tables referencing acq.fiscal_year via Foreign Key Constraints\r
548                                                 </title>\r
549                                 \r
550                                                         <listitem>\r
551                                                                 <para><xref linkend="acq.table.fiscal-year"/></para>\r
552                                                         </listitem>\r
553                                                         \r
554                                         </itemizedlist>\r
555                                 \r
556                                 \r
557                                 \r
558                                 \r
559                 </para>\r
560                 </simplesect>\r
561                 \r
562                 <simplesect id="acq.table.fiscal-year" xreflabel="acq.fiscal_year">             \r
563                         <title>fiscal_year</title>\r
564                         <informaltable>\r
565                                 <tgroup cols="3">\r
566                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
567                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
568                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
569                                         <thead>\r
570                                                 <row>\r
571                                                         <entry>Field</entry>\r
572                                                         <entry>Data Type</entry>\r
573                                                         <entry>Constraints and References</entry>\r
574                                                 </row>\r
575                                                 </thead>\r
576                                                 <tbody>\r
577                                                 \r
578                                                         <row>\r
579                                                                 <entry>id</entry>\r
580                                                                 <entry>serial</entry>\r
581                                                                 <entry><para>\r
582                                                                         \r
583                                                                                 \r
584                                                                                         PRIMARY KEY\r
585                                                                                                                 \r
586                                                                         \r
587                                                                         \r
588                                                                         \r
589                                                                         \r
590                                                                         \r
591                                                                                 \r
592                                                                         \r
593                                                                         </para></entry>\r
594                                                         </row>\r
595                                                 \r
596                                                         <row>\r
597                                                                 <entry>calendar</entry>\r
598                                                                 <entry>integer</entry>\r
599                                                                 <entry><para>\r
600                                                                         \r
601                                                                                                                 \r
602                                                                         \r
603                                                                                 UNIQUE#1\r
604                                                                                 ;\r
605                                                                                 \r
606                                                                         \r
607                                                                                                                 \r
608                                                                         \r
609                                                                                 UNIQUE#2\r
610                                                                                 ;\r
611                                                                                 \r
612                                                                         \r
613                                                                                                                 \r
614                                                                         \r
615                                                                         \r
616                                                                         \r
617                                                                                 NOT NULL;\r
618                                                                         \r
619                                                                         \r
620                                                                         \r
621                                                                                 \r
622                                                                         \r
623                                                                                 \r
624                                                                         \r
625                                                                                 \r
626                                                                                 <xref linkend="acq.table.fiscal-calendar"/>\r
627                                                                                 \r
628                                                                         \r
629                                                                         </para></entry>\r
630                                                         </row>\r
631                                                 \r
632                                                         <row>\r
633                                                                 <entry>year</entry>\r
634                                                                 <entry>integer</entry>\r
635                                                                 <entry><para>\r
636                                                                         \r
637                                                                                                                 \r
638                                                                         \r
639                                                                                 UNIQUE#1\r
640                                                                                 ;\r
641                                                                                 \r
642                                                                         \r
643                                                                         \r
644                                                                                 NOT NULL;\r
645                                                                         \r
646                                                                         \r
647                                                                         \r
648                                                                                 \r
649                                                                         \r
650                                                                         </para></entry>\r
651                                                         </row>\r
652                                                 \r
653                                                         <row>\r
654                                                                 <entry>year_begin</entry>\r
655                                                                 <entry>timestamp with time zone</entry>\r
656                                                                 <entry><para>\r
657                                                                         \r
658                                                                                                                 \r
659                                                                         \r
660                                                                                 UNIQUE#2\r
661                                                                                 ;\r
662                                                                                 \r
663                                                                         \r
664                                                                         \r
665                                                                                 NOT NULL;\r
666                                                                         \r
667                                                                         \r
668                                                                         \r
669                                                                                 \r
670                                                                         \r
671                                                                         </para></entry>\r
672                                                         </row>\r
673                                                 \r
674                                                         <row>\r
675                                                                 <entry>year_end</entry>\r
676                                                                 <entry>timestamp with time zone</entry>\r
677                                                                 <entry><para>\r
678                                                                         \r
679                                                                         \r
680                                                                                 NOT NULL;\r
681                                                                         \r
682                                                                         \r
683                                                                         \r
684                                                                         </para></entry>\r
685                                                         </row>\r
686                                                 \r
687                                                 </tbody>\r
688                                         </tgroup>\r
689                                 </informaltable>\r
690                                 <para>\r
691                                 \r
692                                 \r
693                                 \r
694                                 \r
695                 </para>\r
696                 </simplesect>\r
697                 \r
698                 <simplesect id="acq.table.fund" xreflabel="acq.fund">           \r
699                         <title>fund</title>\r
700                         <informaltable>\r
701                                 <tgroup cols="3">\r
702                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
703                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
704                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
705                                         <thead>\r
706                                                 <row>\r
707                                                         <entry>Field</entry>\r
708                                                         <entry>Data Type</entry>\r
709                                                         <entry>Constraints and References</entry>\r
710                                                 </row>\r
711                                                 </thead>\r
712                                                 <tbody>\r
713                                                 \r
714                                                         <row>\r
715                                                                 <entry>id</entry>\r
716                                                                 <entry>serial</entry>\r
717                                                                 <entry><para>\r
718                                                                         \r
719                                                                                 \r
720                                                                                         PRIMARY KEY\r
721                                                                                                                 \r
722                                                                         \r
723                                                                         \r
724                                                                         \r
725                                                                         \r
726                                                                         \r
727                                                                                 \r
728                                                                         \r
729                                                                         </para></entry>\r
730                                                         </row>\r
731                                                 \r
732                                                         <row>\r
733                                                                 <entry>org</entry>\r
734                                                                 <entry>integer</entry>\r
735                                                                 <entry><para>\r
736                                                                         \r
737                                                                                                                 \r
738                                                                         \r
739                                                                                 UNIQUE#2\r
740                                                                                 ;\r
741                                                                                 \r
742                                                                         \r
743                                                                                                                 \r
744                                                                         \r
745                                                                         \r
746                                                                                                                 \r
747                                                                         \r
748                                                                                 UNIQUE#1\r
749                                                                                 ;\r
750                                                                                 \r
751                                                                         \r
752                                                                         \r
753                                                                                 NOT NULL;\r
754                                                                         \r
755                                                                         \r
756                                                                         \r
757                                                                                 \r
758                                                                         \r
759                                                                                 \r
760                                                                                 <xref linkend="actor.table.org-unit"/>\r
761                                                                                 \r
762                                                                         \r
763                                                                                 \r
764                                                                         \r
765                                                                         </para></entry>\r
766                                                         </row>\r
767                                                 \r
768                                                         <row>\r
769                                                                 <entry>name</entry>\r
770                                                                 <entry>text</entry>\r
771                                                                 <entry><para>\r
772                                                                         \r
773                                                                                                                 \r
774                                                                         \r
775                                                                                 UNIQUE#1\r
776                                                                                 ;\r
777                                                                                 \r
778                                                                         \r
779                                                                         \r
780                                                                                 NOT NULL;\r
781                                                                         \r
782                                                                         \r
783                                                                         \r
784                                                                                 \r
785                                                                         \r
786                                                                         </para></entry>\r
787                                                         </row>\r
788                                                 \r
789                                                         <row>\r
790                                                                 <entry>year</entry>\r
791                                                                 <entry>integer</entry>\r
792                                                                 <entry><para>\r
793                                                                         \r
794                                                                                                                 \r
795                                                                         \r
796                                                                                 UNIQUE#2\r
797                                                                                 ;\r
798                                                                                 \r
799                                                                         \r
800                                                                                                                 \r
801                                                                         \r
802                                                                                 UNIQUE#1\r
803                                                                                 ;\r
804                                                                                 \r
805                                                                         \r
806                                                                         \r
807                                                                                 NOT NULL;\r
808                                                                         \r
809                                                                         \r
810                                                                                 DEFAULT date_part(&apos;year&apos;::text, now());\r
811                                                                         \r
812                                                                         \r
813                                                                                 \r
814                                                                         \r
815                                                                                 \r
816                                                                         \r
817                                                                         </para></entry>\r
818                                                         </row>\r
819                                                 \r
820                                                         <row>\r
821                                                                 <entry>currency_type</entry>\r
822                                                                 <entry>text</entry>\r
823                                                                 <entry><para>\r
824                                                                         \r
825                                                                                                                 \r
826                                                                         \r
827                                                                         \r
828                                                                         \r
829                                                                                 NOT NULL;\r
830                                                                         \r
831                                                                         \r
832                                                                         \r
833                                                                                 \r
834                                                                                 <xref linkend="acq.table.currency-type"/>\r
835                                                                                 \r
836                                                                         \r
837                                                                         </para></entry>\r
838                                                         </row>\r
839                                                 \r
840                                                         <row>\r
841                                                                 <entry>code</entry>\r
842                                                                 <entry>text</entry>\r
843                                                                 <entry><para>\r
844                                                                         \r
845                                                                                                                 \r
846                                                                         \r
847                                                                                 UNIQUE#2\r
848                                                                                 ;\r
849                                                                                 \r
850                                                                         \r
851                                                                         \r
852                                                                         \r
853                                                                         \r
854                                                                                 \r
855                                                                         \r
856                                                                         </para></entry>\r
857                                                         </row>\r
858                                                 \r
859                                                 </tbody>\r
860                                         </tgroup>\r
861                                 </informaltable>\r
862                                 <para>\r
863                                 \r
864                                 \r
865                                 \r
866                                         <itemizedlist>\r
867                                                 <title>\r
868                                                         Tables referencing acq.fund_allocation via Foreign Key Constraints\r
869                                                 </title>\r
870                                 \r
871                                                         <listitem>\r
872                                                                 <para><xref linkend="acq.table.fund-allocation"/></para>\r
873                                                         </listitem>\r
874                                                         \r
875                                 \r
876                                 \r
877                                                         <listitem>\r
878                                                                 <para><xref linkend="acq.table.fund-debit"/></para>\r
879                                                         </listitem>\r
880                                                         \r
881                                 \r
882                                 \r
883                                                         <listitem>\r
884                                                                 <para><xref linkend="acq.table.fund-tag-map"/></para>\r
885                                                         </listitem>\r
886                                                         \r
887                                 \r
888                                 \r
889                                                         <listitem>\r
890                                                                 <para><xref linkend="acq.table.lineitem-detail"/></para>\r
891                                                         </listitem>\r
892                                                         \r
893                                         </itemizedlist>\r
894                                 \r
895                                 \r
896                                 \r
897                                 \r
898                 </para>\r
899                 </simplesect>\r
900                 \r
901                 <simplesect id="acq.table.fund-allocation" xreflabel="acq.fund_allocation">             \r
902                         <title>fund_allocation</title>\r
903                         <informaltable>\r
904                                 <tgroup cols="3">\r
905                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
906                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
907                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
908                                         <thead>\r
909                                                 <row>\r
910                                                         <entry>Field</entry>\r
911                                                         <entry>Data Type</entry>\r
912                                                         <entry>Constraints and References</entry>\r
913                                                 </row>\r
914                                                 </thead>\r
915                                                 <tbody>\r
916                                                 \r
917                                                         <row>\r
918                                                                 <entry>id</entry>\r
919                                                                 <entry>serial</entry>\r
920                                                                 <entry><para>\r
921                                                                         \r
922                                                                                 \r
923                                                                                         PRIMARY KEY\r
924                                                                                                                 \r
925                                                                         \r
926                                                                         \r
927                                                                         \r
928                                                                         \r
929                                                                         \r
930                                                                                 \r
931                                                                         \r
932                                                                         </para></entry>\r
933                                                         </row>\r
934                                                 \r
935                                                         <row>\r
936                                                                 <entry>funding_source</entry>\r
937                                                                 <entry>integer</entry>\r
938                                                                 <entry><para>\r
939                                                                         \r
940                                                                                                                 \r
941                                                                         \r
942                                                                         \r
943                                                                         \r
944                                                                                 NOT NULL;\r
945                                                                         \r
946                                                                         \r
947                                                                         \r
948                                                                                 \r
949                                                                                 <xref linkend="acq.table.funding-source"/>\r
950                                                                                 \r
951                                                                         \r
952                                                                         </para></entry>\r
953                                                         </row>\r
954                                                 \r
955                                                         <row>\r
956                                                                 <entry>fund</entry>\r
957                                                                 <entry>integer</entry>\r
958                                                                 <entry><para>\r
959                                                                         \r
960                                                                                                                 \r
961                                                                         \r
962                                                                         \r
963                                                                         \r
964                                                                                 NOT NULL;\r
965                                                                         \r
966                                                                         \r
967                                                                         \r
968                                                                                 \r
969                                                                                 <xref linkend="acq.table.fund"/>\r
970                                                                                 \r
971                                                                         \r
972                                                                         </para></entry>\r
973                                                         </row>\r
974                                                 \r
975                                                         <row>\r
976                                                                 <entry>amount</entry>\r
977                                                                 <entry>numeric</entry>\r
978                                                                 <entry><para>\r
979                                                                         \r
980                                                                         \r
981                                                                         \r
982                                                                         \r
983                                                                         </para></entry>\r
984                                                         </row>\r
985                                                 \r
986                                                         <row>\r
987                                                                 <entry>percent</entry>\r
988                                                                 <entry>numeric</entry>\r
989                                                                 <entry><para>\r
990                                                                         \r
991                                                                         \r
992                                                                         \r
993                                                                         \r
994                                                                         </para></entry>\r
995                                                         </row>\r
996                                                 \r
997                                                         <row>\r
998                                                                 <entry>allocator</entry>\r
999                                                                 <entry>integer</entry>\r
1000                                                                 <entry><para>\r
1001                                                                         \r
1002                                                                                                                 \r
1003                                                                         \r
1004                                                                         \r
1005                                                                         \r
1006                                                                                 NOT NULL;\r
1007                                                                         \r
1008                                                                         \r
1009                                                                         \r
1010                                                                                 \r
1011                                                                                 <xref linkend="actor.table.usr"/>\r
1012                                                                                 \r
1013                                                                         \r
1014                                                                         </para></entry>\r
1015                                                         </row>\r
1016                                                 \r
1017                                                         <row>\r
1018                                                                 <entry>note</entry>\r
1019                                                                 <entry>text</entry>\r
1020                                                                 <entry><para>\r
1021                                                                         \r
1022                                                                         \r
1023                                                                         \r
1024                                                                         \r
1025                                                                         </para></entry>\r
1026                                                         </row>\r
1027                                                 \r
1028                                                         <row>\r
1029                                                                 <entry>create_time</entry>\r
1030                                                                 <entry>timestamp with time zone</entry>\r
1031                                                                 <entry><para>\r
1032                                                                         \r
1033                                                                         \r
1034                                                                                 NOT NULL;\r
1035                                                                         \r
1036                                                                         \r
1037                                                                                 DEFAULT now();\r
1038                                                                         \r
1039                                                                         \r
1040                                                                         </para></entry>\r
1041                                                         </row>\r
1042                                                 \r
1043                                                 </tbody>\r
1044                                         </tgroup>\r
1045                                 </informaltable>\r
1046                                 <para>\r
1047                                 \r
1048                                 \r
1049                                         <variablelist>\r
1050                                                 <title>Constraints on fund_allocation</title>\r
1051                                                 \r
1052                                                 <varlistentry>\r
1053                                                         <term>allocation_amount_or_percent</term>\r
1054                                                         <listitem><para>CHECK ((((percent IS NULL) AND (amount IS NOT NULL)) OR ((percent IS NOT NULL) AND (amount IS NULL))))</para></listitem>\r
1055                                                 </varlistentry>\r
1056                                                 \r
1057                                 \r
1058                                 \r
1059                                                 <varlistentry>\r
1060                                                         <term>fund_allocation_percent_check</term>\r
1061                                                         <listitem><para>CHECK (((percent IS NULL) OR ((percent &gt;= 0.0) AND (percent &lt;= 100.0))))</para></listitem>\r
1062                                                 </varlistentry>\r
1063                                                 \r
1064                                         </variablelist>\r
1065                                 \r
1066                                 \r
1067                                 \r
1068                                 \r
1069                                 \r
1070                 </para>\r
1071                 </simplesect>\r
1072                 \r
1073                 <simplesect id="acq.view.fund-allocation-total" xreflabel="acq.fund_allocation_total">          \r
1074                         <title>fund_allocation_total</title>\r
1075                         <informaltable>\r
1076                                 <tgroup cols="3">\r
1077                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
1078                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
1079                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
1080                                         <thead>\r
1081                                                 <row>\r
1082                                                         <entry>Field</entry>\r
1083                                                         <entry>Data Type</entry>\r
1084                                                         <entry>Constraints and References</entry>\r
1085                                                 </row>\r
1086                                                 </thead>\r
1087                                                 <tbody>\r
1088                                                 \r
1089                                                         <row>\r
1090                                                                 <entry>fund</entry>\r
1091                                                                 <entry>integer</entry>\r
1092                                                                 <entry><para>\r
1093                                                                         \r
1094                                                                         \r
1095                                                                         \r
1096                                                                         \r
1097                                                                         </para></entry>\r
1098                                                         </row>\r
1099                                                 \r
1100                                                         <row>\r
1101                                                                 <entry>amount</entry>\r
1102                                                                 <entry>numeric(100,2)</entry>\r
1103                                                                 <entry><para>\r
1104                                                                         \r
1105                                                                         \r
1106                                                                         \r
1107                                                                         \r
1108                                                                         </para></entry>\r
1109                                                         </row>\r
1110                                                 \r
1111                                                 </tbody>\r
1112                                         </tgroup>\r
1113                                 </informaltable>\r
1114                                 <para>\r
1115                                 \r
1116                                 \r
1117                                 \r
1118                                 \r
1119                 </para>\r
1120                 </simplesect>\r
1121                 \r
1122                 <simplesect id="acq.view.fund-combined-balance" xreflabel="acq.fund_combined_balance">          \r
1123                         <title>fund_combined_balance</title>\r
1124                         <informaltable>\r
1125                                 <tgroup cols="3">\r
1126                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
1127                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
1128                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
1129                                         <thead>\r
1130                                                 <row>\r
1131                                                         <entry>Field</entry>\r
1132                                                         <entry>Data Type</entry>\r
1133                                                         <entry>Constraints and References</entry>\r
1134                                                 </row>\r
1135                                                 </thead>\r
1136                                                 <tbody>\r
1137                                                 \r
1138                                                         <row>\r
1139                                                                 <entry>fund</entry>\r
1140                                                                 <entry>integer</entry>\r
1141                                                                 <entry><para>\r
1142                                                                         \r
1143                                                                         \r
1144                                                                         \r
1145                                                                         \r
1146                                                                         </para></entry>\r
1147                                                         </row>\r
1148                                                 \r
1149                                                         <row>\r
1150                                                                 <entry>amount</entry>\r
1151                                                                 <entry>numeric</entry>\r
1152                                                                 <entry><para>\r
1153                                                                         \r
1154                                                                         \r
1155                                                                         \r
1156                                                                         \r
1157                                                                         </para></entry>\r
1158                                                         </row>\r
1159                                                 \r
1160                                                 </tbody>\r
1161                                         </tgroup>\r
1162                                 </informaltable>\r
1163                                 <para>\r
1164                                 \r
1165                                 \r
1166                                 \r
1167                                 \r
1168                 </para>\r
1169                 </simplesect>\r
1170                 \r
1171                 <simplesect id="acq.table.fund-debit" xreflabel="acq.fund_debit">               \r
1172                         <title>fund_debit</title>\r
1173                         <informaltable>\r
1174                                 <tgroup cols="3">\r
1175                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
1176                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
1177                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
1178                                         <thead>\r
1179                                                 <row>\r
1180                                                         <entry>Field</entry>\r
1181                                                         <entry>Data Type</entry>\r
1182                                                         <entry>Constraints and References</entry>\r
1183                                                 </row>\r
1184                                                 </thead>\r
1185                                                 <tbody>\r
1186                                                 \r
1187                                                         <row>\r
1188                                                                 <entry>id</entry>\r
1189                                                                 <entry>serial</entry>\r
1190                                                                 <entry><para>\r
1191                                                                         \r
1192                                                                                 \r
1193                                                                                         PRIMARY KEY\r
1194                                                                                                                 \r
1195                                                                         \r
1196                                                                         \r
1197                                                                         \r
1198                                                                         \r
1199                                                                         \r
1200                                                                                 \r
1201                                                                         \r
1202                                                                         </para></entry>\r
1203                                                         </row>\r
1204                                                 \r
1205                                                         <row>\r
1206                                                                 <entry>fund</entry>\r
1207                                                                 <entry>integer</entry>\r
1208                                                                 <entry><para>\r
1209                                                                         \r
1210                                                                                                                 \r
1211                                                                         \r
1212                                                                         \r
1213                                                                         \r
1214                                                                                 NOT NULL;\r
1215                                                                         \r
1216                                                                         \r
1217                                                                         \r
1218                                                                                 \r
1219                                                                                 <xref linkend="acq.table.fund"/>\r
1220                                                                                 \r
1221                                                                         \r
1222                                                                         </para></entry>\r
1223                                                         </row>\r
1224                                                 \r
1225                                                         <row>\r
1226                                                                 <entry>origin_amount</entry>\r
1227                                                                 <entry>numeric</entry>\r
1228                                                                 <entry><para>\r
1229                                                                         \r
1230                                                                         \r
1231                                                                                 NOT NULL;\r
1232                                                                         \r
1233                                                                         \r
1234                                                                         \r
1235                                                                         </para></entry>\r
1236                                                         </row>\r
1237                                                 \r
1238                                                         <row>\r
1239                                                                 <entry>origin_currency_type</entry>\r
1240                                                                 <entry>text</entry>\r
1241                                                                 <entry><para>\r
1242                                                                         \r
1243                                                                                                                 \r
1244                                                                         \r
1245                                                                         \r
1246                                                                         \r
1247                                                                                 NOT NULL;\r
1248                                                                         \r
1249                                                                         \r
1250                                                                         \r
1251                                                                                 \r
1252                                                                                 <xref linkend="acq.table.currency-type"/>\r
1253                                                                                 \r
1254                                                                         \r
1255                                                                         </para></entry>\r
1256                                                         </row>\r
1257                                                 \r
1258                                                         <row>\r
1259                                                                 <entry>amount</entry>\r
1260                                                                 <entry>numeric</entry>\r
1261                                                                 <entry><para>\r
1262                                                                         \r
1263                                                                         \r
1264                                                                                 NOT NULL;\r
1265                                                                         \r
1266                                                                         \r
1267                                                                         \r
1268                                                                         </para></entry>\r
1269                                                         </row>\r
1270                                                 \r
1271                                                         <row>\r
1272                                                                 <entry>encumbrance</entry>\r
1273                                                                 <entry>boolean</entry>\r
1274                                                                 <entry><para>\r
1275                                                                         \r
1276                                                                         \r
1277                                                                                 NOT NULL;\r
1278                                                                         \r
1279                                                                         \r
1280                                                                                 DEFAULT true;\r
1281                                                                         \r
1282                                                                         \r
1283                                                                         </para></entry>\r
1284                                                         </row>\r
1285                                                 \r
1286                                                         <row>\r
1287                                                                 <entry>debit_type</entry>\r
1288                                                                 <entry>text</entry>\r
1289                                                                 <entry><para>\r
1290                                                                         \r
1291                                                                         \r
1292                                                                                 NOT NULL;\r
1293                                                                         \r
1294                                                                         \r
1295                                                                         \r
1296                                                                         </para></entry>\r
1297                                                         </row>\r
1298                                                 \r
1299                                                         <row>\r
1300                                                                 <entry>xfer_destination</entry>\r
1301                                                                 <entry>integer</entry>\r
1302                                                                 <entry><para>\r
1303                                                                         \r
1304                                                                                                                 \r
1305                                                                         \r
1306                                                                         \r
1307                                                                         \r
1308                                                                         \r
1309                                                                         \r
1310                                                                                 \r
1311                                                                                 <xref linkend="acq.table.fund"/>\r
1312                                                                                 \r
1313                                                                         \r
1314                                                                         </para></entry>\r
1315                                                         </row>\r
1316                                                 \r
1317                                                         <row>\r
1318                                                                 <entry>create_time</entry>\r
1319                                                                 <entry>timestamp with time zone</entry>\r
1320                                                                 <entry><para>\r
1321                                                                         \r
1322                                                                         \r
1323                                                                                 NOT NULL;\r
1324                                                                         \r
1325                                                                         \r
1326                                                                                 DEFAULT now();\r
1327                                                                         \r
1328                                                                         \r
1329                                                                         </para></entry>\r
1330                                                         </row>\r
1331                                                 \r
1332                                                 </tbody>\r
1333                                         </tgroup>\r
1334                                 </informaltable>\r
1335                                 <para>\r
1336                                 \r
1337                                 \r
1338                                 \r
1339                                         <itemizedlist>\r
1340                                                 <title>\r
1341                                                         Tables referencing acq.lineitem_detail via Foreign Key Constraints\r
1342                                                 </title>\r
1343                                 \r
1344                                                         <listitem>\r
1345                                                                 <para><xref linkend="acq.table.lineitem-detail"/></para>\r
1346                                                         </listitem>\r
1347                                                         \r
1348                                         </itemizedlist>\r
1349                                 \r
1350                                 \r
1351                                 \r
1352                                 \r
1353                 </para>\r
1354                 </simplesect>\r
1355                 \r
1356                 <simplesect id="acq.view.fund-debit-total" xreflabel="acq.fund_debit_total">            \r
1357                         <title>fund_debit_total</title>\r
1358                         <informaltable>\r
1359                                 <tgroup cols="3">\r
1360                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
1361                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
1362                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
1363                                         <thead>\r
1364                                                 <row>\r
1365                                                         <entry>Field</entry>\r
1366                                                         <entry>Data Type</entry>\r
1367                                                         <entry>Constraints and References</entry>\r
1368                                                 </row>\r
1369                                                 </thead>\r
1370                                                 <tbody>\r
1371                                                 \r
1372                                                         <row>\r
1373                                                                 <entry>fund</entry>\r
1374                                                                 <entry>integer</entry>\r
1375                                                                 <entry><para>\r
1376                                                                         \r
1377                                                                         \r
1378                                                                         \r
1379                                                                         \r
1380                                                                         </para></entry>\r
1381                                                         </row>\r
1382                                                 \r
1383                                                         <row>\r
1384                                                                 <entry>encumbrance</entry>\r
1385                                                                 <entry>boolean</entry>\r
1386                                                                 <entry><para>\r
1387                                                                         \r
1388                                                                         \r
1389                                                                         \r
1390                                                                         \r
1391                                                                         </para></entry>\r
1392                                                         </row>\r
1393                                                 \r
1394                                                         <row>\r
1395                                                                 <entry>amount</entry>\r
1396                                                                 <entry>numeric</entry>\r
1397                                                                 <entry><para>\r
1398                                                                         \r
1399                                                                         \r
1400                                                                         \r
1401                                                                         \r
1402                                                                         </para></entry>\r
1403                                                         </row>\r
1404                                                 \r
1405                                                 </tbody>\r
1406                                         </tgroup>\r
1407                                 </informaltable>\r
1408                                 <para>\r
1409                                 \r
1410                                 \r
1411                                 \r
1412                                 \r
1413                 </para>\r
1414                 </simplesect>\r
1415                 \r
1416                 <simplesect id="acq.view.fund-encumbrance-total" xreflabel="acq.fund_encumbrance_total">                \r
1417                         <title>fund_encumbrance_total</title>\r
1418                         <informaltable>\r
1419                                 <tgroup cols="3">\r
1420                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
1421                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
1422                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
1423                                         <thead>\r
1424                                                 <row>\r
1425                                                         <entry>Field</entry>\r
1426                                                         <entry>Data Type</entry>\r
1427                                                         <entry>Constraints and References</entry>\r
1428                                                 </row>\r
1429                                                 </thead>\r
1430                                                 <tbody>\r
1431                                                 \r
1432                                                         <row>\r
1433                                                                 <entry>fund</entry>\r
1434                                                                 <entry>integer</entry>\r
1435                                                                 <entry><para>\r
1436                                                                         \r
1437                                                                         \r
1438                                                                         \r
1439                                                                         \r
1440                                                                         </para></entry>\r
1441                                                         </row>\r
1442                                                 \r
1443                                                         <row>\r
1444                                                                 <entry>amount</entry>\r
1445                                                                 <entry>numeric</entry>\r
1446                                                                 <entry><para>\r
1447                                                                         \r
1448                                                                         \r
1449                                                                         \r
1450                                                                         \r
1451                                                                         </para></entry>\r
1452                                                         </row>\r
1453                                                 \r
1454                                                 </tbody>\r
1455                                         </tgroup>\r
1456                                 </informaltable>\r
1457                                 <para>\r
1458                                 \r
1459                                 \r
1460                                 \r
1461                                 \r
1462                 </para>\r
1463                 </simplesect>\r
1464                 \r
1465                 <simplesect id="acq.view.fund-spent-balance" xreflabel="acq.fund_spent_balance">                \r
1466                         <title>fund_spent_balance</title>\r
1467                         <informaltable>\r
1468                                 <tgroup cols="3">\r
1469                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
1470                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
1471                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
1472                                         <thead>\r
1473                                                 <row>\r
1474                                                         <entry>Field</entry>\r
1475                                                         <entry>Data Type</entry>\r
1476                                                         <entry>Constraints and References</entry>\r
1477                                                 </row>\r
1478                                                 </thead>\r
1479                                                 <tbody>\r
1480                                                 \r
1481                                                         <row>\r
1482                                                                 <entry>fund</entry>\r
1483                                                                 <entry>integer</entry>\r
1484                                                                 <entry><para>\r
1485                                                                         \r
1486                                                                         \r
1487                                                                         \r
1488                                                                         \r
1489                                                                         </para></entry>\r
1490                                                         </row>\r
1491                                                 \r
1492                                                         <row>\r
1493                                                                 <entry>amount</entry>\r
1494                                                                 <entry>numeric</entry>\r
1495                                                                 <entry><para>\r
1496                                                                         \r
1497                                                                         \r
1498                                                                         \r
1499                                                                         \r
1500                                                                         </para></entry>\r
1501                                                         </row>\r
1502                                                 \r
1503                                                 </tbody>\r
1504                                         </tgroup>\r
1505                                 </informaltable>\r
1506                                 <para>\r
1507                                 \r
1508                                 \r
1509                                 \r
1510                                 \r
1511                 </para>\r
1512                 </simplesect>\r
1513                 \r
1514                 <simplesect id="acq.view.fund-spent-total" xreflabel="acq.fund_spent_total">            \r
1515                         <title>fund_spent_total</title>\r
1516                         <informaltable>\r
1517                                 <tgroup cols="3">\r
1518                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
1519                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
1520                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
1521                                         <thead>\r
1522                                                 <row>\r
1523                                                         <entry>Field</entry>\r
1524                                                         <entry>Data Type</entry>\r
1525                                                         <entry>Constraints and References</entry>\r
1526                                                 </row>\r
1527                                                 </thead>\r
1528                                                 <tbody>\r
1529                                                 \r
1530                                                         <row>\r
1531                                                                 <entry>fund</entry>\r
1532                                                                 <entry>integer</entry>\r
1533                                                                 <entry><para>\r
1534                                                                         \r
1535                                                                         \r
1536                                                                         \r
1537                                                                         \r
1538                                                                         </para></entry>\r
1539                                                         </row>\r
1540                                                 \r
1541                                                         <row>\r
1542                                                                 <entry>amount</entry>\r
1543                                                                 <entry>numeric</entry>\r
1544                                                                 <entry><para>\r
1545                                                                         \r
1546                                                                         \r
1547                                                                         \r
1548                                                                         \r
1549                                                                         </para></entry>\r
1550                                                         </row>\r
1551                                                 \r
1552                                                 </tbody>\r
1553                                         </tgroup>\r
1554                                 </informaltable>\r
1555                                 <para>\r
1556                                 \r
1557                                 \r
1558                                 \r
1559                                 \r
1560                 </para>\r
1561                 </simplesect>\r
1562                 \r
1563                 <simplesect id="acq.table.fund-tag" xreflabel="acq.fund_tag">           \r
1564                         <title>fund_tag</title>\r
1565                         <informaltable>\r
1566                                 <tgroup cols="3">\r
1567                                         <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
1568                                         <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
1569                                         <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
1570                                         <thead>\r
1571                                                 <row>\r
1572                                                         <entry>Field</entry>\r
1573                                                         <entry>Data Type</entry>\r
1574                                                         <entry>Constraints and References</entry>\r
1575                                                 </row>\r
1576                                                 </thead>\r
1577                                                 <tbody>\r
1578                                                 \r
1579                                                         <row>\r
1580                                                                 <entry>id</entry>\r
1581                                                                 <entry>serial</entry>\r
1582                                                                 <entry><para>\r
1583                                                                         \r
1584                                                                                 \r
1585                                                                                         PRIMARY KEY\r
1586                                                                                                                 \r
1587                                                                         \r
1588                                                                         \r
1589                                                                         \r
1590                                                                         \r
1591                                                                         \r
1592                                                                                 \r
1593                                                                         \r
1594                                                                         </para></entry>\r
1595                                                         </row>\r
1596                                                 \r
1597                                                         <row>\r
1598                                                                 <entry>owner</entry>\r
1599                                                                 <entry>integer</entry>\r
1600                                                                 <entry><para>\r
1601                                                                         \r
1602                                                                                                                 \r
1603                                                                         \r
1604                                                                                 UNIQUE#1\r
1605                                                                                 ;\r
1606                                                                                 \r
1607                                                                         \r
1608                                                                                                                 \r
1609                                                                         \r
1610                                                                         \r
1611                                                                         \r
1612                                                                                 NOT NULL;\r
1613                                                                         \r
1614                                                                         \r
1615                                                                         \r
1616                                                                                 \r
1617                                                                         \r
1618                                                                                 \r
1619                                                                                 <xref linkend="actor.table.org-unit"/>\r
1620                                                                                 \r
1621                                                                         \r
1622                                                                         </para></entry>\r
1623                                                         </row>\r
1624                                                 \r
1625                                                         <row>\r
1626                                                                 <entry>name</entry>\r
1627                                                                 <entry>text</entry>\r
1628                                                                 <entry><para>\r
1629                                                                         \r
1630                                                                                                                 \r
1631                                                                         \r
1632                                                                                 UNIQUE#1\r
1633                                                                                 ;\r
1634                                                                                 \r
1635                                                                         \r
1636                                                                         \r
1637                                                                                 NOT NULL;\r
1638                                                                         \r
1639                                                                         \r
1640                                                                         \r
1641                                                                                 \r
1642                                                                         \r
1643                                                                         </para></entry>\r
1644                                                         </row>\r
1645                                                 \r
1646                                                 </tbody>\r
1647                                         </tgroup>\r
1648                                 </informaltable>\r
1649                                 <para>\r
1650                                 \r
1651                                 \r
1652                                 \r