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