Project

General

Profile

Statistics
| Branch: | Tag: | Revision:

cdmlib / cdmlib-ext / src / test / resources / dbscripts / 001-cdm.h2.sql @ 481b893b

History | View | Annotate | Download (349 KB)

1
SET CLUSTER '';
2
SET DEFAULT_TABLE_TYPE 0;
3
SET WRITE_DELAY 500;
4
SET DEFAULT_LOCK_TIMEOUT 2000;
5
SET CACHE_SIZE 16384;
6
;
7
CREATE USER IF NOT EXISTS EDIT PASSWORD '' ADMIN;
8
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC START WITH 4 BELONGS_TO_TABLE;
9

    
10

    
11
CREATE CACHED TABLE PUBLIC.ADDRESS(
12
    ID INTEGER NOT NULL,
13
    CREATED TIMESTAMP,
14
    UUID VARCHAR(36),
15
    UPDATED TIMESTAMP,
16
    LOCALITY VARCHAR(255),
17
    LOCATION_ERRORRADIUS INTEGER,
18
    LOCATION_LATITUDE DOUBLE,
19
    LOCATION_LONGITUDE DOUBLE,
20
    POBOX VARCHAR(255),
21
    POSTCODE VARCHAR(255),
22
    REGION VARCHAR(255),
23
    STREET VARCHAR(255),
24
    CREATEDBY_ID INTEGER,
25
    UPDATEDBY_ID INTEGER,
26
    COUNTRY_ID INTEGER,
27
    LOCATION_REFERENCESYSTEM_ID INTEGER
28
);
29
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ADDRESS;
30
CREATE CACHED TABLE PUBLIC.ADDRESS_AUD(
31
    ID INTEGER NOT NULL,
32
    REV INTEGER NOT NULL,
33
    REVTYPE TINYINT,
34
    CREATED TIMESTAMP,
35
    UUID VARCHAR(36),
36
    UPDATED TIMESTAMP,
37
    LOCALITY VARCHAR(255),
38
    LOCATION_ERRORRADIUS INTEGER,
39
    LOCATION_LATITUDE DOUBLE,
40
    LOCATION_LONGITUDE DOUBLE,
41
    POBOX VARCHAR(255),
42
    POSTCODE VARCHAR(255),
43
    REGION VARCHAR(255),
44
    STREET VARCHAR(255),
45
    CREATEDBY_ID INTEGER,
46
    UPDATEDBY_ID INTEGER,
47
    COUNTRY_ID INTEGER,
48
    LOCATION_REFERENCESYSTEM_ID INTEGER
49
);
50
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ADDRESS_AUD;
51
CREATE CACHED TABLE PUBLIC.AGENTBASE(
52
    DTYPE VARCHAR(31) NOT NULL,
53
    ID INTEGER NOT NULL,
54
    CREATED TIMESTAMP,
55
    UUID VARCHAR(36),
56
    UPDATED TIMESTAMP,
57
    LSID_AUTHORITY VARCHAR(255),
58
    LSID_LSID VARCHAR(255),
59
    LSID_NAMESPACE VARCHAR(255),
60
    LSID_OBJECT VARCHAR(255),
61
    LSID_REVISION VARCHAR(255),
62
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
63
    TITLECACHE VARCHAR(255),
64
    CODE VARCHAR(255),
65
    NAME VARCHAR(255),
66
    NOMENCLATURALTITLE VARCHAR(255),
67
    FIRSTNAME VARCHAR(255),
68
    LASTNAME VARCHAR(255),
69
    LIFESPAN_END VARCHAR(255),
70
    LIFESPAN_FREETEXT VARCHAR(255),
71
    LIFESPAN_START VARCHAR(255),
72
    PREFIX VARCHAR(255),
73
    SUFFIX VARCHAR(255),
74
    PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,
75
    CREATEDBY_ID INTEGER,
76
    UPDATEDBY_ID INTEGER,
77
    ISPARTOF_ID INTEGER
78
);
79
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE;
80
CREATE INDEX PUBLIC.AGENTTITLECACHEINDEX ON PUBLIC.AGENTBASE(TITLECACHE);
81
CREATE CACHED TABLE PUBLIC.AGENTBASE_AUD(
82
    DTYPE VARCHAR(31) NOT NULL,
83
    ID INTEGER NOT NULL,
84
    REV INTEGER NOT NULL,
85
    REVTYPE TINYINT,
86
    CREATED TIMESTAMP,
87
    UUID VARCHAR(36),
88
    UPDATED TIMESTAMP,
89
    LSID_AUTHORITY VARCHAR(255),
90
    LSID_LSID VARCHAR(255),
91
    LSID_NAMESPACE VARCHAR(255),
92
    LSID_OBJECT VARCHAR(255),
93
    LSID_REVISION VARCHAR(255),
94
    PROTECTEDTITLECACHE BOOLEAN,
95
    TITLECACHE VARCHAR(255),
96
    CREATEDBY_ID INTEGER,
97
    UPDATEDBY_ID INTEGER,
98
    NOMENCLATURALTITLE VARCHAR(255),
99
    PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,
100
    FIRSTNAME VARCHAR(255),
101
    LASTNAME VARCHAR(255),
102
    LIFESPAN_END VARCHAR(255),
103
    LIFESPAN_FREETEXT VARCHAR(255),
104
    LIFESPAN_START VARCHAR(255),
105
    PREFIX VARCHAR(255),
106
    SUFFIX VARCHAR(255),
107
    CODE VARCHAR(255),
108
    NAME VARCHAR(255),
109
    ISPARTOF_ID INTEGER
110
);
111
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AUD;
112
CREATE CACHED TABLE PUBLIC.AGENTBASE_ADDRESS(
113
    AGENTBASE_ID INTEGER NOT NULL,
114
    CONTACT_ADDRESSES_ID INTEGER NOT NULL
115
);
116
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ADDRESS;
117
CREATE CACHED TABLE PUBLIC.AGENTBASE_ADDRESS_AUD(
118
    REV INTEGER NOT NULL,
119
    AGENTBASE_ID INTEGER NOT NULL,
120
    CONTACT_ADDRESSES_ID INTEGER NOT NULL,
121
    REVTYPE TINYINT
122
);
123
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ADDRESS_AUD;
124
CREATE CACHED TABLE PUBLIC.AGENTBASE_AGENTBASE(
125
    AGENTBASE_ID INTEGER NOT NULL,
126
    TEAMMEMBERS_ID INTEGER NOT NULL,
127
    SORTINDEX INTEGER NOT NULL
128
);
129
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AGENTBASE;
130
CREATE CACHED TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD(
131
    REV INTEGER NOT NULL,
132
    AGENTBASE_ID INTEGER NOT NULL,
133
    TEAMMEMBERS_ID INTEGER NOT NULL,
134
    SORTINDEX INTEGER NOT NULL,
135
    REVTYPE TINYINT
136
);
137
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AGENTBASE_AUD;
138
CREATE CACHED TABLE PUBLIC.AGENTBASE_ANNOTATION(
139
    AGENTBASE_ID INTEGER NOT NULL,
140
    ANNOTATIONS_ID INTEGER NOT NULL
141
);
142
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ANNOTATION;
143
CREATE CACHED TABLE PUBLIC.AGENTBASE_ANNOTATION_AUD(
144
    REV INTEGER NOT NULL,
145
    AGENTBASE_ID INTEGER NOT NULL,
146
    ANNOTATIONS_ID INTEGER NOT NULL,
147
    REVTYPE TINYINT
148
);
149
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ANNOTATION_AUD;
150
CREATE CACHED TABLE PUBLIC.AGENTBASE_CREDIT(
151
    AGENTBASE_ID INTEGER NOT NULL,
152
    CREDITS_ID INTEGER NOT NULL,
153
    SORTINDEX INTEGER NOT NULL
154
);
155
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CREDIT;
156
CREATE CACHED TABLE PUBLIC.AGENTBASE_CREDIT_AUD(
157
    REV INTEGER NOT NULL,
158
    AGENTBASE_ID INTEGER NOT NULL,
159
    CREDITS_ID INTEGER NOT NULL,
160
    SORTINDEX INTEGER NOT NULL,
161
    REVTYPE TINYINT
162
);
163
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CREDIT_AUD;
164
CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE(
165
    AGENTBASE_ID INTEGER NOT NULL,
166
    TYPES_ID INTEGER NOT NULL
167
);
168
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_DEFINEDTERMBASE;
169
CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD(
170
    REV INTEGER NOT NULL,
171
    AGENTBASE_ID INTEGER NOT NULL,
172
    TYPES_ID INTEGER NOT NULL,
173
    REVTYPE TINYINT
174
);
175
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD;
176
CREATE CACHED TABLE PUBLIC.AGENTBASE_EXTENSION(
177
    AGENTBASE_ID INTEGER NOT NULL,
178
    EXTENSIONS_ID INTEGER NOT NULL
179
);
180
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_EXTENSION;
181
CREATE CACHED TABLE PUBLIC.AGENTBASE_EXTENSION_AUD(
182
    REV INTEGER NOT NULL,
183
    AGENTBASE_ID INTEGER NOT NULL,
184
    EXTENSIONS_ID INTEGER NOT NULL,
185
    REVTYPE TINYINT
186
);
187
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_EXTENSION_AUD;
188
CREATE CACHED TABLE PUBLIC.AGENTBASE_MARKER(
189
    AGENTBASE_ID INTEGER NOT NULL,
190
    MARKERS_ID INTEGER NOT NULL
191
);
192
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MARKER;
193
CREATE CACHED TABLE PUBLIC.AGENTBASE_MARKER_AUD(
194
    REV INTEGER NOT NULL,
195
    AGENTBASE_ID INTEGER NOT NULL,
196
    MARKERS_ID INTEGER NOT NULL,
197
    REVTYPE TINYINT
198
);
199
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MARKER_AUD;
200
CREATE CACHED TABLE PUBLIC.AGENTBASE_MEDIA(
201
    AGENTBASE_ID INTEGER NOT NULL,
202
    MEDIA_ID INTEGER NOT NULL
203
);
204
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MEDIA;
205
CREATE CACHED TABLE PUBLIC.AGENTBASE_MEDIA_AUD(
206
    REV INTEGER NOT NULL,
207
    AGENTBASE_ID INTEGER NOT NULL,
208
    MEDIA_ID INTEGER NOT NULL,
209
    REVTYPE TINYINT
210
);
211
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MEDIA_AUD;
212
CREATE CACHED TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE(
213
    AGENTBASE_ID INTEGER NOT NULL,
214
    SOURCES_ID INTEGER NOT NULL
215
);
216
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ORIGINALSOURCEBASE;
217
CREATE CACHED TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD(
218
    REV INTEGER NOT NULL,
219
    AGENTBASE_ID INTEGER NOT NULL,
220
    SOURCES_ID INTEGER NOT NULL,
221
    REVTYPE TINYINT
222
);
223
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD;
224
CREATE CACHED TABLE PUBLIC.AGENTBASE_RIGHTS(
225
    AGENTBASE_ID INTEGER NOT NULL,
226
    RIGHTS_ID INTEGER NOT NULL
227
);
228
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_RIGHTS;
229
CREATE CACHED TABLE PUBLIC.AGENTBASE_RIGHTS_AUD(
230
    REV INTEGER NOT NULL,
231
    AGENTBASE_ID INTEGER NOT NULL,
232
    RIGHTS_ID INTEGER NOT NULL,
233
    REVTYPE TINYINT
234
);
235
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_RIGHTS_AUD;
236
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES(
237
    AGENTBASE_ID INTEGER NOT NULL,
238
    CONTACT_EMAILADDRESSES_ELEMENT VARCHAR(255)
239
);
240
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES;
241
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD(
242
    REV INTEGER NOT NULL,
243
    AGENTBASE_ID INTEGER NOT NULL,
244
    CONTACT_EMAILADDRESSES_ELEMENT VARCHAR(255) NOT NULL,
245
    REVTYPE TINYINT
246
);
247
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD;
248
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS(
249
    AGENTBASE_ID INTEGER NOT NULL,
250
    CONTACT_FAXNUMBERS_ELEMENT VARCHAR(255)
251
);
252
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS;
253
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD(
254
    REV INTEGER NOT NULL,
255
    AGENTBASE_ID INTEGER NOT NULL,
256
    CONTACT_FAXNUMBERS_ELEMENT VARCHAR(255) NOT NULL,
257
    REVTYPE TINYINT
258
);
259
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD;
260
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS(
261
    AGENTBASE_ID INTEGER NOT NULL,
262
    CONTACT_PHONENUMBERS_ELEMENT VARCHAR(255)
263
);
264
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS;
265
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD(
266
    REV INTEGER NOT NULL,
267
    AGENTBASE_ID INTEGER NOT NULL,
268
    CONTACT_PHONENUMBERS_ELEMENT VARCHAR(255) NOT NULL,
269
    REVTYPE TINYINT
270
);
271
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD;
272
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_URLS(
273
    AGENTBASE_ID INTEGER NOT NULL,
274
    CONTACT_URLS_ELEMENT VARCHAR(255)
275
);
276
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_URLS;
277
CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_URLS_AUD(
278
    REV INTEGER NOT NULL,
279
    AGENTBASE_ID INTEGER NOT NULL,
280
    CONTACT_URLS_ELEMENT VARCHAR(255) NOT NULL,
281
    REVTYPE TINYINT
282
);
283
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_URLS_AUD;
284
CREATE CACHED TABLE PUBLIC.ANNOTATION(
285
    ID INTEGER NOT NULL,
286
    CREATED TIMESTAMP,
287
    UUID VARCHAR(36),
288
    UPDATED TIMESTAMP,
289
    TEXT CLOB,
290
    ANNOTATEDOBJ_TYPE VARCHAR(255),
291
    ANNOTATEDOBJ_ID INTEGER NOT NULL,
292
    LINKBACKURL BINARY(255),
293
    CREATEDBY_ID INTEGER,
294
    UPDATEDBY_ID INTEGER,
295
    LANGUAGE_ID INTEGER,
296
    ANNOTATIONTYPE_ID INTEGER,
297
    COMMENTATOR_ID INTEGER
298
);
299
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION;
300
CREATE CACHED TABLE PUBLIC.ANNOTATION_AUD(
301
    ID INTEGER NOT NULL,
302
    REV INTEGER NOT NULL,
303
    REVTYPE TINYINT,
304
    CREATED TIMESTAMP,
305
    UUID VARCHAR(36),
306
    UPDATED TIMESTAMP,
307
    TEXT CLOB,
308
    LINKBACKURL BINARY(255),
309
    CREATEDBY_ID INTEGER,
310
    UPDATEDBY_ID INTEGER,
311
    LANGUAGE_ID INTEGER,
312
    ANNOTATIONTYPE_ID INTEGER,
313
    COMMENTATOR_ID INTEGER
314
);
315
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_AUD;
316
CREATE CACHED TABLE PUBLIC.ANNOTATION_ANNOTATION(
317
    ANNOTATION_ID INTEGER NOT NULL,
318
    ANNOTATIONS_ID INTEGER NOT NULL
319
);
320
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_ANNOTATION;
321
CREATE CACHED TABLE PUBLIC.ANNOTATION_ANNOTATION_AUD(
322
    REV INTEGER NOT NULL,
323
    ANNOTATION_ID INTEGER NOT NULL,
324
    ANNOTATIONS_ID INTEGER NOT NULL,
325
    REVTYPE TINYINT
326
);
327
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_ANNOTATION_AUD;
328
CREATE CACHED TABLE PUBLIC.ANNOTATION_MARKER(
329
    ANNOTATION_ID INTEGER NOT NULL,
330
    MARKERS_ID INTEGER NOT NULL
331
);
332
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_MARKER;
333
CREATE CACHED TABLE PUBLIC.ANNOTATION_MARKER_AUD(
334
    REV INTEGER NOT NULL,
335
    ANNOTATION_ID INTEGER NOT NULL,
336
    MARKERS_ID INTEGER NOT NULL,
337
    REVTYPE TINYINT
338
);
339
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_MARKER_AUD;
340
CREATE CACHED TABLE PUBLIC.AUDITEVENT(
341
    REVISIONNUMBER INTEGER DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC,
342
    DATE TIMESTAMP,
343
    TIMESTAMP BIGINT,
344
    UUID VARCHAR(255)
345
);
346
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.AUDITEVENT;
347
CREATE CACHED TABLE PUBLIC.CDM_VIEW(
348
    ID INTEGER NOT NULL,
349
    CREATED TIMESTAMP,
350
    UUID VARCHAR(36),
351
    DESCRIPTION VARCHAR(255),
352
    NAME VARCHAR(255),
353
    CREATEDBY_ID INTEGER,
354
    REFERENCE_ID INTEGER
355
);
356
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CDM_VIEW;
357
CREATE CACHED TABLE PUBLIC.CDM_VIEW_CDM_VIEW(
358
    CDM_VIEW_ID INTEGER NOT NULL,
359
    SUPERVIEWS_ID INTEGER NOT NULL
360
);
361
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CDM_VIEW_CDM_VIEW;
362
CREATE CACHED TABLE PUBLIC.CDMMETADATA(
363
    ID INTEGER NOT NULL,
364
    CREATED TIMESTAMP,
365
    UUID VARCHAR(36),
366
    PROPERTYNAME INTEGER,
367
    VALUE VARCHAR(255),
368
    CREATEDBY_ID INTEGER
369
);
370
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;
371
CREATE CACHED TABLE PUBLIC.CLASSIFICATION(
372
    ID INTEGER NOT NULL,
373
    CREATED TIMESTAMP,
374
    UUID VARCHAR(36),
375
    UPDATED TIMESTAMP,
376
    LSID_AUTHORITY VARCHAR(255),
377
    LSID_LSID VARCHAR(255),
378
    LSID_NAMESPACE VARCHAR(255),
379
    LSID_OBJECT VARCHAR(255),
380
    LSID_REVISION VARCHAR(255),
381
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
382
    TITLECACHE VARCHAR(255),
383
    MICROREFERENCE VARCHAR(255),
384
    CREATEDBY_ID INTEGER,
385
    UPDATEDBY_ID INTEGER,
386
    NAME_ID INTEGER,
387
    REFERENCE_ID INTEGER
388
);
389
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION;
390
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_AUD(
391
    ID INTEGER NOT NULL,
392
    REV INTEGER NOT NULL,
393
    REVTYPE TINYINT,
394
    CREATED TIMESTAMP,
395
    UUID VARCHAR(36),
396
    UPDATED TIMESTAMP,
397
    LSID_AUTHORITY VARCHAR(255),
398
    LSID_LSID VARCHAR(255),
399
    LSID_NAMESPACE VARCHAR(255),
400
    LSID_OBJECT VARCHAR(255),
401
    LSID_REVISION VARCHAR(255),
402
    PROTECTEDTITLECACHE BOOLEAN,
403
    TITLECACHE VARCHAR(255),
404
    MICROREFERENCE VARCHAR(255),
405
    CREATEDBY_ID INTEGER,
406
    UPDATEDBY_ID INTEGER,
407
    NAME_ID INTEGER,
408
    REFERENCE_ID INTEGER
409
);
410
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_AUD;
411
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION(
412
    CLASSIFICATION_ID INTEGER NOT NULL,
413
    ANNOTATIONS_ID INTEGER NOT NULL
414
);
415
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION;
416
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION_AUD(
417
    REV INTEGER NOT NULL,
418
    CLASSIFICATION_ID INTEGER NOT NULL,
419
    ANNOTATIONS_ID INTEGER NOT NULL,
420
    REVTYPE TINYINT
421
);
422
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION_AUD;
423
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_CREDIT(
424
    CLASSIFICATION_ID INTEGER NOT NULL,
425
    CREDITS_ID INTEGER NOT NULL,
426
    SORTINDEX INTEGER NOT NULL
427
);
428
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT;
429
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_CREDIT_AUD(
430
    REV INTEGER NOT NULL,
431
    CLASSIFICATION_ID INTEGER NOT NULL,
432
    CREDITS_ID INTEGER NOT NULL,
433
    SORTINDEX INTEGER NOT NULL,
434
    REVTYPE TINYINT
435
);
436
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT_AUD;
437
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_EXTENSION(
438
    CLASSIFICATION_ID INTEGER NOT NULL,
439
    EXTENSIONS_ID INTEGER NOT NULL
440
);
441
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_EXTENSION;
442
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_EXTENSION_AUD(
443
    REV INTEGER NOT NULL,
444
    CLASSIFICATION_ID INTEGER NOT NULL,
445
    EXTENSIONS_ID INTEGER NOT NULL,
446
    REVTYPE TINYINT
447
);
448
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_EXTENSION_AUD;
449
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_MARKER(
450
    CLASSIFICATION_ID INTEGER NOT NULL,
451
    MARKERS_ID INTEGER NOT NULL
452
);
453
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_MARKER;
454
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_MARKER_AUD(
455
    REV INTEGER NOT NULL,
456
    CLASSIFICATION_ID INTEGER NOT NULL,
457
    MARKERS_ID INTEGER NOT NULL,
458
    REVTYPE TINYINT
459
);
460
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_MARKER_AUD;
461
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE(
462
    CLASSIFICATION_ID INTEGER NOT NULL,
463
    SOURCES_ID INTEGER NOT NULL
464
);
465
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE;
466
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD(
467
    REV INTEGER NOT NULL,
468
    CLASSIFICATION_ID INTEGER NOT NULL,
469
    SOURCES_ID INTEGER NOT NULL,
470
    REVTYPE TINYINT
471
);
472
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD;
473
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_RIGHTS(
474
    CLASSIFICATION_ID INTEGER NOT NULL,
475
    RIGHTS_ID INTEGER NOT NULL
476
);
477
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_RIGHTS;
478
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_RIGHTS_AUD(
479
    REV INTEGER NOT NULL,
480
    CLASSIFICATION_ID INTEGER NOT NULL,
481
    RIGHTS_ID INTEGER NOT NULL,
482
    REVTYPE TINYINT
483
);
484
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_RIGHTS_AUD;
485
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_TAXONNODE(
486
    CLASSIFICATION_ID INTEGER NOT NULL,
487
    ROOTNODES_ID INTEGER NOT NULL
488
);
489
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_TAXONNODE;
490
CREATE CACHED TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD(
491
    REV INTEGER NOT NULL,
492
    CLASSIFICATION_ID INTEGER NOT NULL,
493
    ROOTNODES_ID INTEGER NOT NULL,
494
    REVTYPE TINYINT
495
);
496
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_TAXONNODE_AUD;
497
CREATE CACHED TABLE PUBLIC.COLLECTION(
498
    ID INTEGER NOT NULL,
499
    CREATED TIMESTAMP,
500
    UUID VARCHAR(36),
501
    UPDATED TIMESTAMP,
502
    LSID_AUTHORITY VARCHAR(255),
503
    LSID_LSID VARCHAR(255),
504
    LSID_NAMESPACE VARCHAR(255),
505
    LSID_OBJECT VARCHAR(255),
506
    LSID_REVISION VARCHAR(255),
507
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
508
    TITLECACHE VARCHAR(255),
509
    CODE VARCHAR(255),
510
    CODESTANDARD VARCHAR(255),
511
    NAME VARCHAR(255),
512
    TOWNORLOCATION VARCHAR(255),
513
    CREATEDBY_ID INTEGER,
514
    UPDATEDBY_ID INTEGER,
515
    INSTITUTE_ID INTEGER,
516
    SUPERCOLLECTION_ID INTEGER
517
);
518
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION;
519
CREATE INDEX PUBLIC.COLLECTIONTITLECACHEINDEX ON PUBLIC.COLLECTION(TITLECACHE);
520
CREATE CACHED TABLE PUBLIC.COLLECTION_AUD(
521
    ID INTEGER NOT NULL,
522
    REV INTEGER NOT NULL,
523
    REVTYPE TINYINT,
524
    CREATED TIMESTAMP,
525
    UUID VARCHAR(36),
526
    UPDATED TIMESTAMP,
527
    LSID_AUTHORITY VARCHAR(255),
528
    LSID_LSID VARCHAR(255),
529
    LSID_NAMESPACE VARCHAR(255),
530
    LSID_OBJECT VARCHAR(255),
531
    LSID_REVISION VARCHAR(255),
532
    PROTECTEDTITLECACHE BOOLEAN,
533
    TITLECACHE VARCHAR(255),
534
    CODE VARCHAR(255),
535
    CODESTANDARD VARCHAR(255),
536
    NAME VARCHAR(255),
537
    TOWNORLOCATION VARCHAR(255),
538
    CREATEDBY_ID INTEGER,
539
    UPDATEDBY_ID INTEGER,
540
    INSTITUTE_ID INTEGER,
541
    SUPERCOLLECTION_ID INTEGER
542
);
543
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_AUD;
544
CREATE CACHED TABLE PUBLIC.COLLECTION_ANNOTATION(
545
    COLLECTION_ID INTEGER NOT NULL,
546
    ANNOTATIONS_ID INTEGER NOT NULL
547
);
548
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ANNOTATION;
549
CREATE CACHED TABLE PUBLIC.COLLECTION_ANNOTATION_AUD(
550
    REV INTEGER NOT NULL,
551
    COLLECTION_ID INTEGER NOT NULL,
552
    ANNOTATIONS_ID INTEGER NOT NULL,
553
    REVTYPE TINYINT
554
);
555
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ANNOTATION_AUD;
556
CREATE CACHED TABLE PUBLIC.COLLECTION_CREDIT(
557
    COLLECTION_ID INTEGER NOT NULL,
558
    CREDITS_ID INTEGER NOT NULL,
559
    SORTINDEX INTEGER NOT NULL
560
);
561
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_CREDIT;
562
CREATE CACHED TABLE PUBLIC.COLLECTION_CREDIT_AUD(
563
    REV INTEGER NOT NULL,
564
    COLLECTION_ID INTEGER NOT NULL,
565
    CREDITS_ID INTEGER NOT NULL,
566
    SORTINDEX INTEGER NOT NULL,
567
    REVTYPE TINYINT
568
);
569
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_CREDIT_AUD;
570
CREATE CACHED TABLE PUBLIC.COLLECTION_EXTENSION(
571
    COLLECTION_ID INTEGER NOT NULL,
572
    EXTENSIONS_ID INTEGER NOT NULL
573
);
574
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_EXTENSION;
575
CREATE CACHED TABLE PUBLIC.COLLECTION_EXTENSION_AUD(
576
    REV INTEGER NOT NULL,
577
    COLLECTION_ID INTEGER NOT NULL,
578
    EXTENSIONS_ID INTEGER NOT NULL,
579
    REVTYPE TINYINT
580
);
581
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_EXTENSION_AUD;
582
CREATE CACHED TABLE PUBLIC.COLLECTION_MARKER(
583
    COLLECTION_ID INTEGER NOT NULL,
584
    MARKERS_ID INTEGER NOT NULL
585
);
586
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MARKER;
587
CREATE CACHED TABLE PUBLIC.COLLECTION_MARKER_AUD(
588
    REV INTEGER NOT NULL,
589
    COLLECTION_ID INTEGER NOT NULL,
590
    MARKERS_ID INTEGER NOT NULL,
591
    REVTYPE TINYINT
592
);
593
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MARKER_AUD;
594
CREATE CACHED TABLE PUBLIC.COLLECTION_MEDIA(
595
    COLLECTION_ID INTEGER NOT NULL,
596
    MEDIA_ID INTEGER NOT NULL
597
);
598
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MEDIA;
599
CREATE CACHED TABLE PUBLIC.COLLECTION_MEDIA_AUD(
600
    REV INTEGER NOT NULL,
601
    COLLECTION_ID INTEGER NOT NULL,
602
    MEDIA_ID INTEGER NOT NULL,
603
    REVTYPE TINYINT
604
);
605
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MEDIA_AUD;
606
CREATE CACHED TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE(
607
    COLLECTION_ID INTEGER NOT NULL,
608
    SOURCES_ID INTEGER NOT NULL
609
);
610
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ORIGINALSOURCEBASE;
611
CREATE CACHED TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE_AUD(
612
    REV INTEGER NOT NULL,
613
    COLLECTION_ID INTEGER NOT NULL,
614
    SOURCES_ID INTEGER NOT NULL,
615
    REVTYPE TINYINT
616
);
617
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ORIGINALSOURCEBASE_AUD;
618
CREATE CACHED TABLE PUBLIC.COLLECTION_RIGHTS(
619
    COLLECTION_ID INTEGER NOT NULL,
620
    RIGHTS_ID INTEGER NOT NULL
621
);
622
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_RIGHTS;
623
CREATE CACHED TABLE PUBLIC.COLLECTION_RIGHTS_AUD(
624
    REV INTEGER NOT NULL,
625
    COLLECTION_ID INTEGER NOT NULL,
626
    RIGHTS_ID INTEGER NOT NULL,
627
    REVTYPE TINYINT
628
);
629
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_RIGHTS_AUD;
630
CREATE CACHED TABLE PUBLIC.CREDIT(
631
    ID INTEGER NOT NULL,
632
    CREATED TIMESTAMP,
633
    UUID VARCHAR(36),
634
    UPDATED TIMESTAMP,
635
    TEXT CLOB,
636
    ABBREVIATEDTEXT VARCHAR(255),
637
    CREATEDBY_ID INTEGER,
638
    UPDATEDBY_ID INTEGER,
639
    LANGUAGE_ID INTEGER,
640
    AGENT_ID INTEGER
641
);
642
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT;
643
CREATE CACHED TABLE PUBLIC.CREDIT_AUD(
644
    ID INTEGER NOT NULL,
645
    REV INTEGER NOT NULL,
646
    REVTYPE TINYINT,
647
    CREATED TIMESTAMP,
648
    UUID VARCHAR(36),
649
    UPDATED TIMESTAMP,
650
    TEXT CLOB,
651
    ABBREVIATEDTEXT VARCHAR(255),
652
    CREATEDBY_ID INTEGER,
653
    UPDATEDBY_ID INTEGER,
654
    LANGUAGE_ID INTEGER,
655
    AGENT_ID INTEGER
656
);
657
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_AUD;
658
CREATE CACHED TABLE PUBLIC.CREDIT_ANNOTATION(
659
    CREDIT_ID INTEGER NOT NULL,
660
    ANNOTATIONS_ID INTEGER NOT NULL
661
);
662
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_ANNOTATION;
663
CREATE CACHED TABLE PUBLIC.CREDIT_ANNOTATION_AUD(
664
    REV INTEGER NOT NULL,
665
    CREDIT_ID INTEGER NOT NULL,
666
    ANNOTATIONS_ID INTEGER NOT NULL,
667
    REVTYPE TINYINT
668
);
669
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_ANNOTATION_AUD;
670
CREATE CACHED TABLE PUBLIC.CREDIT_MARKER(
671
    CREDIT_ID INTEGER NOT NULL,
672
    MARKERS_ID INTEGER NOT NULL
673
);
674
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_MARKER;
675
CREATE CACHED TABLE PUBLIC.CREDIT_MARKER_AUD(
676
    REV INTEGER NOT NULL,
677
    CREDIT_ID INTEGER NOT NULL,
678
    MARKERS_ID INTEGER NOT NULL,
679
    REVTYPE TINYINT
680
);
681
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_MARKER_AUD;
682
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE(
683
    DTYPE VARCHAR(31) NOT NULL,
684
    ID INTEGER NOT NULL,
685
    CREATED TIMESTAMP,
686
    UUID VARCHAR(36),
687
    UPDATED TIMESTAMP,
688
    TERMTYPE INTEGER,
689
    IDINVOCABULARY VARCHAR(255),
690
    LSID_AUTHORITY VARCHAR(255),
691
    LSID_LSID VARCHAR(255),
692
    LSID_NAMESPACE VARCHAR(255),
693
    LSID_OBJECT VARCHAR(255),
694
    LSID_REVISION VARCHAR(255),
695
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
696
    TITLECACHE VARCHAR(255),
697
    URI CLOB,
698
    ISO639_1 VARCHAR(2),
699
    RANKCLASS INTEGER,
700
    ISTECHNICAL BOOLEAN,
701
    ORDERINDEX INTEGER,
702
    SYMMETRICAL BOOLEAN,
703
    TRANSITIVE BOOLEAN,
704
    DEFAULTCOLOR VARCHAR(255),
705
    SUPPORTSCATEGORICALDATA BOOLEAN,
706
    SUPPORTSCOMMONTAXONNAME BOOLEAN,
707
    SUPPORTSDISTRIBUTION BOOLEAN,
708
    SUPPORTSINDIVIDUALASSOCIATION BOOLEAN,
709
    SUPPORTSQUANTITATIVEDATA BOOLEAN,
710
    SUPPORTSTAXONINTERACTION BOOLEAN,
711
    SUPPORTSTEXTDATA BOOLEAN,
712
    POINTAPPROXIMATION_ERRORRADIUS INTEGER,
713
    POINTAPPROXIMATION_LATITUDE DOUBLE,
714
    POINTAPPROXIMATION_LONGITUDE DOUBLE,
715
    VALIDPERIOD_END VARCHAR(255),
716
    VALIDPERIOD_FREETEXT VARCHAR(255),
717
    VALIDPERIOD_START VARCHAR(255),
718
    ISO3166_A2 VARCHAR(2),
719
    CREATEDBY_ID INTEGER,
720
    UPDATEDBY_ID INTEGER,
721
    KINDOF_ID INTEGER,
722
    PARTOF_ID INTEGER,
723
    VOCABULARY_ID INTEGER,
724
    LEVEL_ID INTEGER,
725
    POINTAPPROXIMATION_REFERENCESYSTEM_ID INTEGER,
726
    SHAPE_ID INTEGER,
727
    TYPE_ID INTEGER
728
);
729
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE;
730
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_AUD(
731
    DTYPE VARCHAR(31) NOT NULL,
732
    ID INTEGER NOT NULL,
733
    REV INTEGER NOT NULL,
734
    REVTYPE TINYINT,
735
    CREATED TIMESTAMP,
736
    UUID VARCHAR(36),
737
    UPDATED TIMESTAMP,
738
    TERMTYPE INTEGER,
739
    IDINVOCABULARY VARCHAR(255),
740
    LSID_AUTHORITY VARCHAR(255),
741
    LSID_LSID VARCHAR(255),
742
    LSID_NAMESPACE VARCHAR(255),
743
    LSID_OBJECT VARCHAR(255),
744
    LSID_REVISION VARCHAR(255),
745
    PROTECTEDTITLECACHE BOOLEAN,
746
    TITLECACHE VARCHAR(255),
747
    URI CLOB,
748
    CREATEDBY_ID INTEGER,
749
    UPDATEDBY_ID INTEGER,
750
    KINDOF_ID INTEGER,
751
    PARTOF_ID INTEGER,
752
    VOCABULARY_ID INTEGER,
753
    ORDERINDEX INTEGER,
754
    ISO639_1 VARCHAR(2),
755
    RANKCLASS INTEGER,
756
    SUPPORTSCATEGORICALDATA BOOLEAN,
757
    SUPPORTSCOMMONTAXONNAME BOOLEAN,
758
    SUPPORTSDISTRIBUTION BOOLEAN,
759
    SUPPORTSINDIVIDUALASSOCIATION BOOLEAN,
760
    SUPPORTSQUANTITATIVEDATA BOOLEAN,
761
    SUPPORTSTAXONINTERACTION BOOLEAN,
762
    SUPPORTSTEXTDATA BOOLEAN,
763
    ISTECHNICAL BOOLEAN,
764
    DEFAULTCOLOR VARCHAR(255),
765
    POINTAPPROXIMATION_ERRORRADIUS INTEGER,
766
    POINTAPPROXIMATION_LATITUDE DOUBLE,
767
    POINTAPPROXIMATION_LONGITUDE DOUBLE,
768
    VALIDPERIOD_END VARCHAR(255),
769
    VALIDPERIOD_FREETEXT VARCHAR(255),
770
    VALIDPERIOD_START VARCHAR(255),
771
    LEVEL_ID INTEGER,
772
    POINTAPPROXIMATION_REFERENCESYSTEM_ID INTEGER,
773
    SHAPE_ID INTEGER,
774
    TYPE_ID INTEGER,
775
    ISO3166_A2 VARCHAR(2),
776
    SYMMETRICAL BOOLEAN,
777
    TRANSITIVE BOOLEAN
778
);
779
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_AUD;
780
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION(
781
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
782
    ANNOTATIONS_ID INTEGER NOT NULL
783
);
784
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION;
785
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD(
786
    REV INTEGER NOT NULL,
787
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
788
    ANNOTATIONS_ID INTEGER NOT NULL,
789
    REVTYPE TINYINT
790
);
791
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD;
792
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT(
793
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
794
    CONTINENTS_ID INTEGER NOT NULL
795
);
796
-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT;
797
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD(
798
    REV INTEGER NOT NULL,
799
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
800
    CONTINENTS_ID INTEGER NOT NULL,
801
    REVTYPE TINYINT
802
);
803
-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD;
804
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CREDIT(
805
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
806
    CREDITS_ID INTEGER NOT NULL,
807
    SORTINDEX INTEGER NOT NULL
808
);
809
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CREDIT;
810
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CREDIT_AUD(
811
    REV INTEGER NOT NULL,
812
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
813
    CREDITS_ID INTEGER NOT NULL,
814
    SORTINDEX INTEGER NOT NULL,
815
    REVTYPE TINYINT
816
);
817
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CREDIT_AUD;
818
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION(
819
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
820
    EXTENSIONS_ID INTEGER NOT NULL
821
);
822
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_EXTENSION;
823
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD(
824
    REV INTEGER NOT NULL,
825
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
826
    EXTENSIONS_ID INTEGER NOT NULL,
827
    REVTYPE TINYINT
828
);
829
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD;
830
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MARKER(
831
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
832
    MARKERS_ID INTEGER NOT NULL
833
);
834
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MARKER;
835
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MARKER_AUD(
836
    REV INTEGER NOT NULL,
837
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
838
    MARKERS_ID INTEGER NOT NULL,
839
    REVTYPE TINYINT
840
);
841
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MARKER_AUD;
842
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT(
843
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
844
    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL
845
);
846
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT;
847
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD(
848
    REV INTEGER NOT NULL,
849
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
850
    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL,
851
    REVTYPE TINYINT
852
);
853
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD;
854
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEDIA(
855
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
856
    MEDIA_ID INTEGER NOT NULL
857
);
858
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEDIA;
859
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEDIA_AUD(
860
    REV INTEGER NOT NULL,
861
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
862
    MEDIA_ID INTEGER NOT NULL,
863
    REVTYPE TINYINT
864
);
865
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEDIA_AUD;
866
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE(
867
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
868
    SOURCES_ID INTEGER NOT NULL
869
);
870
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE;
871
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD(
872
    REV INTEGER NOT NULL,
873
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
874
    SOURCES_ID INTEGER NOT NULL,
875
    REVTYPE TINYINT
876
);
877
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD;
878
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION(
879
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
880
    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL
881
);
882
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION;
883
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD(
884
    REV INTEGER NOT NULL,
885
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
886
    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL,
887
    REVTYPE TINYINT
888
);
889
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD;
890
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION(
891
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
892
    REPRESENTATIONS_ID INTEGER NOT NULL
893
);
894
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_REPRESENTATION;
895
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD(
896
    REV INTEGER NOT NULL,
897
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
898
    REPRESENTATIONS_ID INTEGER NOT NULL,
899
    REVTYPE TINYINT
900
);
901
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD;
902
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS(
903
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
904
    RIGHTS_ID INTEGER NOT NULL
905
);
906
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RIGHTS;
907
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS_AUD(
908
    REV INTEGER NOT NULL,
909
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
910
    RIGHTS_ID INTEGER NOT NULL,
911
    REVTYPE TINYINT
912
);
913
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RIGHTS_AUD;
914
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE(
915
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
916
    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL
917
);
918
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE;
919
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD(
920
    REV INTEGER NOT NULL,
921
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
922
    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL,
923
    REVTYPE TINYINT
924
);
925
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD;
926
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION(
927
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
928
    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL
929
);
930
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION;
931
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD(
932
    REV INTEGER NOT NULL,
933
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
934
    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL,
935
    REVTYPE TINYINT
936
);
937
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD;
938
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_WATERBODYORCOUNTRY(
939
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
940
    WATERBODIESORCOUNTRIES_ID INTEGER NOT NULL
941
);
942
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_WATERBODYORCOUNTRY;
943
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_WATERBODYORCOUNTRY_AUD(
944
    REV INTEGER NOT NULL,
945
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
946
    WATERBODIESORCOUNTRIES_ID INTEGER NOT NULL,
947
    REVTYPE TINYINT
948
);
949
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_WATERBODYORCOUNTRY_AUD;
950
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT(
951
    ID INTEGER NOT NULL,
952
    CREATED TIMESTAMP,
953
    UUID VARCHAR(36),
954
    UPDATED TIMESTAMP,
955
    DESCRIPTION VARCHAR(255),
956
    TIMEPERIOD_END VARCHAR(255),
957
    TIMEPERIOD_FREETEXT VARCHAR(255),
958
    TIMEPERIOD_START VARCHAR(255),
959
    CREATEDBY_ID INTEGER,
960
    UPDATEDBY_ID INTEGER,
961
    ACTOR_ID INTEGER,
962
    TYPE_ID INTEGER
963
);
964
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT;
965
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_AUD(
966
    ID INTEGER NOT NULL,
967
    REV INTEGER NOT NULL,
968
    REVTYPE TINYINT,
969
    CREATED TIMESTAMP,
970
    UUID VARCHAR(36),
971
    UPDATED TIMESTAMP,
972
    DESCRIPTION VARCHAR(255),
973
    TIMEPERIOD_END VARCHAR(255),
974
    TIMEPERIOD_FREETEXT VARCHAR(255),
975
    TIMEPERIOD_START VARCHAR(255),
976
    CREATEDBY_ID INTEGER,
977
    UPDATEDBY_ID INTEGER,
978
    ACTOR_ID INTEGER,
979
    TYPE_ID INTEGER
980
);
981
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_AUD;
982
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION(
983
    DERIVATIONEVENT_ID INTEGER NOT NULL,
984
    ANNOTATIONS_ID INTEGER NOT NULL
985
);
986
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_ANNOTATION;
987
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD(
988
    REV INTEGER NOT NULL,
989
    DERIVATIONEVENT_ID INTEGER NOT NULL,
990
    ANNOTATIONS_ID INTEGER NOT NULL,
991
    REVTYPE TINYINT
992
);
993
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD;
994
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_MARKER(
995
    DERIVATIONEVENT_ID INTEGER NOT NULL,
996
    MARKERS_ID INTEGER NOT NULL
997
);
998
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_MARKER;
999
CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_MARKER_AUD(
1000
    REV INTEGER NOT NULL,
1001
    DERIVATIONEVENT_ID INTEGER NOT NULL,
1002
    MARKERS_ID INTEGER NOT NULL,
1003
    REVTYPE TINYINT
1004
);
1005
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_MARKER_AUD;
1006
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE(
1007
    DTYPE VARCHAR(31) NOT NULL,
1008
    ID INTEGER NOT NULL,
1009
    CREATED TIMESTAMP,
1010
    UUID VARCHAR(36),
1011
    UPDATED TIMESTAMP,
1012
    LSID_AUTHORITY VARCHAR(255),
1013
    LSID_LSID VARCHAR(255),
1014
    LSID_NAMESPACE VARCHAR(255),
1015
    LSID_OBJECT VARCHAR(255),
1016
    LSID_REVISION VARCHAR(255),
1017
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
1018
    TITLECACHE VARCHAR(255),
1019
    IMAGEGALLERY BOOLEAN NOT NULL,
1020
    CREATEDBY_ID INTEGER,
1021
    UPDATEDBY_ID INTEGER,
1022
    TAXON_ID INTEGER,
1023
    TAXONNAME_ID INTEGER
1024
);
1025
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE;
1026
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_AUD(
1027
    DTYPE VARCHAR(31) NOT NULL,
1028
    ID INTEGER NOT NULL,
1029
    REV INTEGER NOT NULL,
1030
    REVTYPE TINYINT,
1031
    CREATED TIMESTAMP,
1032
    UUID VARCHAR(36),
1033
    UPDATED TIMESTAMP,
1034
    LSID_AUTHORITY VARCHAR(255),
1035
    LSID_LSID VARCHAR(255),
1036
    LSID_NAMESPACE VARCHAR(255),
1037
    LSID_OBJECT VARCHAR(255),
1038
    LSID_REVISION VARCHAR(255),
1039
    PROTECTEDTITLECACHE BOOLEAN,
1040
    TITLECACHE VARCHAR(255),
1041
    IMAGEGALLERY BOOLEAN,
1042
    CREATEDBY_ID INTEGER,
1043
    UPDATEDBY_ID INTEGER,
1044
    TAXON_ID INTEGER,
1045
    TAXONNAME_ID INTEGER
1046
);
1047
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_AUD;
1048
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION(
1049
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1050
    ANNOTATIONS_ID INTEGER NOT NULL
1051
);
1052
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ANNOTATION;
1053
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD(
1054
    REV INTEGER NOT NULL,
1055
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1056
    ANNOTATIONS_ID INTEGER NOT NULL,
1057
    REVTYPE TINYINT
1058
);
1059
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD;
1060
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_CREDIT(
1061
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1062
    CREDITS_ID INTEGER NOT NULL,
1063
    SORTINDEX INTEGER NOT NULL
1064
);
1065
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_CREDIT;
1066
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_CREDIT_AUD(
1067
    REV INTEGER NOT NULL,
1068
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1069
    CREDITS_ID INTEGER NOT NULL,
1070
    SORTINDEX INTEGER NOT NULL,
1071
    REVTYPE TINYINT
1072
);
1073
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_CREDIT_AUD;
1074
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION(
1075
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1076
    EXTENSIONS_ID INTEGER NOT NULL
1077
);
1078
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_EXTENSION;
1079
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION_AUD(
1080
    REV INTEGER NOT NULL,
1081
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1082
    EXTENSIONS_ID INTEGER NOT NULL,
1083
    REVTYPE TINYINT
1084
);
1085
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_EXTENSION_AUD;
1086
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_FEATURE(
1087
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1088
    DESCRIPTIVESYSTEM_ID INTEGER NOT NULL
1089
);
1090
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_FEATURE;
1091
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_FEATURE_AUD(
1092
    REV INTEGER NOT NULL,
1093
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1094
    DESCRIPTIVESYSTEM_ID INTEGER NOT NULL,
1095
    REVTYPE TINYINT
1096
);
1097
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_FEATURE_AUD;
1098
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE(
1099
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1100
    GEOSCOPES_ID INTEGER NOT NULL
1101
);
1102
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_GEOSCOPE;
1103
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE_AUD(
1104
    REV INTEGER NOT NULL,
1105
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1106
    GEOSCOPES_ID INTEGER NOT NULL,
1107
    REVTYPE TINYINT
1108
);
1109
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_GEOSCOPE_AUD;
1110
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_MARKER(
1111
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1112
    MARKERS_ID INTEGER NOT NULL
1113
);
1114
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_MARKER;
1115
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_MARKER_AUD(
1116
    REV INTEGER NOT NULL,
1117
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1118
    MARKERS_ID INTEGER NOT NULL,
1119
    REVTYPE TINYINT
1120
);
1121
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_MARKER_AUD;
1122
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE(
1123
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1124
    SOURCES_ID INTEGER NOT NULL
1125
);
1126
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE;
1127
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD(
1128
    REV INTEGER NOT NULL,
1129
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1130
    SOURCES_ID INTEGER NOT NULL,
1131
    REVTYPE TINYINT
1132
);
1133
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD;
1134
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE(
1135
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1136
    DESCRIPTIONSOURCES_ID INTEGER NOT NULL
1137
);
1138
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_REFERENCE;
1139
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD(
1140
    REV INTEGER NOT NULL,
1141
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1142
    DESCRIPTIONSOURCES_ID INTEGER NOT NULL,
1143
    REVTYPE TINYINT
1144
);
1145
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD;
1146
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_RIGHTS(
1147
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1148
    RIGHTS_ID INTEGER NOT NULL
1149
);
1150
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_RIGHTS;
1151
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_RIGHTS_AUD(
1152
    REV INTEGER NOT NULL,
1153
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1154
    RIGHTS_ID INTEGER NOT NULL,
1155
    REVTYPE TINYINT
1156
);
1157
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_RIGHTS_AUD;
1158
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SCOPE(
1159
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1160
    SCOPES_ID INTEGER NOT NULL
1161
);
1162
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SCOPE;
1163
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SCOPE_AUD(
1164
    REV INTEGER NOT NULL,
1165
    DESCRIPTIONBASE_ID INTEGER NOT NULL,
1166
    SCOPES_ID INTEGER NOT NULL,
1167
    REVTYPE TINYINT
1168
);
1169
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SCOPE_AUD;
1170
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE(
1171
    DESCRIPTIONS_ID INTEGER NOT NULL,
1172
    DESCRIBEDSPECIMENOROBSERVATIONS_ID INTEGER NOT NULL
1173
);
1174
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE;
1175
CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD(
1176
    REV INTEGER NOT NULL,
1177
    DESCRIPTIONS_ID INTEGER NOT NULL,
1178
    DESCRIBEDSPECIMENOROBSERVATIONS_ID INTEGER NOT NULL,
1179
    REVTYPE TINYINT
1180
);
1181
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD;
1182
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE(
1183
    DTYPE VARCHAR(31) NOT NULL,
1184
    ID INTEGER NOT NULL,
1185
    CREATED TIMESTAMP,
1186
    UUID VARCHAR(36),
1187
    UPDATED TIMESTAMP,
1188
    ORDERRELEVANT BOOLEAN,
1189
    NAME VARCHAR(255),
1190
    CREATEDBY_ID INTEGER,
1191
    UPDATEDBY_ID INTEGER,
1192
    FEATURE_ID INTEGER,
1193
    INDESCRIPTION_ID INTEGER,
1194
    AREA_ID INTEGER,
1195
    LANGUAGE_ID INTEGER,
1196
    STATUS_ID INTEGER,
1197
    ASSOCIATEDSPECIMENOROBSERVATION_ID INTEGER,
1198
    UNIT_ID INTEGER,
1199
    TAXON2_ID INTEGER,
1200
    FORMAT_ID INTEGER
1201
);
1202
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE;
1203
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_AUD(
1204
    DTYPE VARCHAR(31) NOT NULL,
1205
    ID INTEGER NOT NULL,
1206
    REV INTEGER NOT NULL,
1207
    REVTYPE TINYINT,
1208
    CREATED TIMESTAMP,
1209
    UUID VARCHAR(36),
1210
    UPDATED TIMESTAMP,
1211
    CREATEDBY_ID INTEGER,
1212
    UPDATEDBY_ID INTEGER,
1213
    FEATURE_ID INTEGER,
1214
    INDESCRIPTION_ID INTEGER,
1215
    AREA_ID INTEGER,
1216
    STATUS_ID INTEGER,
1217
    TAXON2_ID INTEGER,
1218
    UNIT_ID INTEGER,
1219
    FORMAT_ID INTEGER,
1220
    ASSOCIATEDSPECIMENOROBSERVATION_ID INTEGER,
1221
    NAME VARCHAR(255),
1222
    LANGUAGE_ID INTEGER,
1223
    ORDERRELEVANT BOOLEAN
1224
);
1225
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_AUD;
1226
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION(
1227
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1228
    ANNOTATIONS_ID INTEGER NOT NULL
1229
);
1230
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION;
1231
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD(
1232
    REV INTEGER NOT NULL,
1233
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1234
    ANNOTATIONS_ID INTEGER NOT NULL,
1235
    REVTYPE TINYINT
1236
);
1237
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD;
1238
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING(
1239
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1240
    MULTILANGUAGETEXT_ID INTEGER NOT NULL,
1241
    MULTILANGUAGETEXT_MAPKEY_ID INTEGER NOT NULL
1242
);
1243
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING;
1244
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD(
1245
    REV INTEGER NOT NULL,
1246
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1247
    MULTILANGUAGETEXT_ID INTEGER NOT NULL,
1248
    MULTILANGUAGETEXT_MAPKEY_ID INTEGER NOT NULL,
1249
    REVTYPE TINYINT
1250
);
1251
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD;
1252
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER(
1253
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1254
    MARKERS_ID INTEGER NOT NULL
1255
);
1256
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MARKER;
1257
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER_AUD(
1258
    REV INTEGER NOT NULL,
1259
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1260
    MARKERS_ID INTEGER NOT NULL,
1261
    REVTYPE TINYINT
1262
);
1263
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MARKER_AUD;
1264
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA(
1265
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1266
    MEDIA_ID INTEGER NOT NULL,
1267
    SORTINDEX INTEGER NOT NULL
1268
);
1269
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA;
1270
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA_AUD(
1271
    REV INTEGER NOT NULL,
1272
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1273
    MEDIA_ID INTEGER NOT NULL,
1274
    SORTINDEX INTEGER NOT NULL,
1275
    REVTYPE TINYINT
1276
);
1277
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA_AUD;
1278
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER(
1279
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1280
    MODIFIERS_ID INTEGER NOT NULL
1281
);
1282
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER;
1283
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER_AUD(
1284
    REV INTEGER NOT NULL,
1285
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1286
    MODIFIERS_ID INTEGER NOT NULL,
1287
    REVTYPE TINYINT
1288
);
1289
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER_AUD;
1290
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT(
1291
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1292
    MODIFYINGTEXT_ID INTEGER NOT NULL,
1293
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
1294
);
1295
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT;
1296
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD(
1297
    REV INTEGER NOT NULL,
1298
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1299
    MODIFYINGTEXT_ID INTEGER NOT NULL,
1300
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
1301
    REVTYPE TINYINT
1302
);
1303
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD;
1304
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE(
1305
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1306
    SOURCES_ID INTEGER NOT NULL
1307
);
1308
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE;
1309
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD(
1310
    REV INTEGER NOT NULL,
1311
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1312
    SOURCES_ID INTEGER NOT NULL,
1313
    REVTYPE TINYINT
1314
);
1315
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD;
1316
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(
1317
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1318
    STATES_ID INTEGER NOT NULL
1319
);
1320
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA;
1321
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(
1322
    REV INTEGER NOT NULL,
1323
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1324
    STATES_ID INTEGER NOT NULL,
1325
    REVTYPE TINYINT
1326
);
1327
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD;
1328
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE(
1329
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1330
    STATISTICALVALUES_ID INTEGER NOT NULL
1331
);
1332
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE;
1333
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD(
1334
    REV INTEGER NOT NULL,
1335
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1336
    STATISTICALVALUES_ID INTEGER NOT NULL,
1337
    REVTYPE TINYINT
1338
);
1339
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD;
1340
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT(
1341
    ID INTEGER NOT NULL,
1342
    CREATED TIMESTAMP,
1343
    UUID VARCHAR(36),
1344
    UPDATED TIMESTAMP,
1345
    DESCRIPTION VARCHAR(255),
1346
    TIMEPERIOD_END VARCHAR(255),
1347
    TIMEPERIOD_FREETEXT VARCHAR(255),
1348
    TIMEPERIOD_START VARCHAR(255),
1349
    PREFERREDFLAG BOOLEAN NOT NULL,
1350
    CREATEDBY_ID INTEGER,
1351
    UPDATEDBY_ID INTEGER,
1352
    ACTOR_ID INTEGER,
1353
    IDENTIFIEDUNIT_ID INTEGER,
1354
    MODIFIER_ID INTEGER,
1355
    TAXON_ID INTEGER
1356
);
1357
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT;
1358
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_AUD(
1359
    ID INTEGER NOT NULL,
1360
    REV INTEGER NOT NULL,
1361
    REVTYPE TINYINT,
1362
    CREATED TIMESTAMP,
1363
    UUID VARCHAR(36),
1364
    UPDATED TIMESTAMP,
1365
    DESCRIPTION VARCHAR(255),
1366
    TIMEPERIOD_END VARCHAR(255),
1367
    TIMEPERIOD_FREETEXT VARCHAR(255),
1368
    TIMEPERIOD_START VARCHAR(255),
1369
    PREFERREDFLAG BOOLEAN,
1370
    CREATEDBY_ID INTEGER,
1371
    UPDATEDBY_ID INTEGER,
1372
    ACTOR_ID INTEGER,
1373
    IDENTIFIEDUNIT_ID INTEGER,
1374
    MODIFIER_ID INTEGER,
1375
    TAXON_ID INTEGER
1376
);
1377
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_AUD;
1378
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION(
1379
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1380
    ANNOTATIONS_ID INTEGER NOT NULL
1381
);
1382
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_ANNOTATION;
1383
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION_AUD(
1384
    REV INTEGER NOT NULL,
1385
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1386
    ANNOTATIONS_ID INTEGER NOT NULL,
1387
    REVTYPE TINYINT
1388
);
1389
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_ANNOTATION_AUD;
1390
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_MARKER(
1391
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1392
    MARKERS_ID INTEGER NOT NULL
1393
);
1394
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_MARKER;
1395
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_MARKER_AUD(
1396
    REV INTEGER NOT NULL,
1397
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1398
    MARKERS_ID INTEGER NOT NULL,
1399
    REVTYPE TINYINT
1400
);
1401
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_MARKER_AUD;
1402
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE(
1403
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1404
    SETOFREFERENCES_ID INTEGER NOT NULL
1405
);
1406
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_REFERENCE;
1407
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD(
1408
    REV INTEGER NOT NULL,
1409
    DETERMINATIONEVENT_ID INTEGER NOT NULL,
1410
    SETOFREFERENCES_ID INTEGER NOT NULL,
1411
    REVTYPE TINYINT
1412
);
1413
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD;
1414
CREATE CACHED TABLE PUBLIC.EXTENSION(
1415
    ID INTEGER NOT NULL,
1416
    CREATED TIMESTAMP,
1417
    UUID VARCHAR(36),
1418
    UPDATED TIMESTAMP,
1419
    EXTENDEDOBJ_TYPE VARCHAR(255),
1420
    EXTENDEDOBJ_ID INTEGER NOT NULL,
1421
    VALUE CLOB,
1422
    CREATEDBY_ID INTEGER,
1423
    UPDATEDBY_ID INTEGER,
1424
    TYPE_ID INTEGER
1425
);
1426
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.EXTENSION;
1427
CREATE CACHED TABLE PUBLIC.EXTENSION_AUD(
1428
    ID INTEGER NOT NULL,
1429
    REV INTEGER NOT NULL,
1430
    REVTYPE TINYINT,
1431
    CREATED TIMESTAMP,
1432
    UUID VARCHAR(36),
1433
    UPDATED TIMESTAMP,
1434
    VALUE CLOB,
1435
    CREATEDBY_ID INTEGER,
1436
    UPDATEDBY_ID INTEGER,
1437
    TYPE_ID INTEGER
1438
);
1439
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.EXTENSION_AUD;
1440
CREATE CACHED TABLE PUBLIC.FEATURENODE(
1441
    ID INTEGER NOT NULL,
1442
    CREATED TIMESTAMP,
1443
    UUID VARCHAR(36),
1444
    UPDATED TIMESTAMP,
1445
    SORTINDEX INTEGER,
1446
    TREEINDEX VARCHAR(255),
1447
    CREATEDBY_ID INTEGER,
1448
    UPDATEDBY_ID INTEGER,
1449
    FEATURE_ID INTEGER,
1450
    FEATURETREE_ID INTEGER,
1451
    PARENT_ID INTEGER
1452
);
1453
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE;
1454
CREATE CACHED TABLE PUBLIC.FEATURENODE_AUD(
1455
    ID INTEGER NOT NULL,
1456
    REV INTEGER NOT NULL,
1457
    REVTYPE TINYINT,
1458
    CREATED TIMESTAMP,
1459
    UUID VARCHAR(36),
1460
    UPDATED TIMESTAMP,
1461
    SORTINDEX INTEGER,
1462
    TREEINDEX VARCHAR(255),
1463
    CREATEDBY_ID INTEGER,
1464
    UPDATEDBY_ID INTEGER,
1465
    FEATURE_ID INTEGER,
1466
    FEATURETREE_ID INTEGER,
1467
    PARENT_ID INTEGER
1468
);
1469
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_AUD;
1470
CREATE CACHED TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF(
1471
    FEATURENODE_ID INTEGER NOT NULL,
1472
    INAPPLICABLEIF_ID INTEGER NOT NULL
1473
);
1474
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF;
1475
CREATE CACHED TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD(
1476
    REV INTEGER NOT NULL,
1477
    FEATURENODE_ID INTEGER NOT NULL,
1478
    INAPPLICABLEIF_ID INTEGER NOT NULL,
1479
    REVTYPE TINYINT
1480
);
1481
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD;
1482
CREATE CACHED TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE(
1483
    FEATURENODE_ID INTEGER NOT NULL,
1484
    ONLYAPPLICABLEIF_ID INTEGER NOT NULL
1485
);
1486
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE;
1487
CREATE CACHED TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE_AUD(
1488
    REV INTEGER NOT NULL,
1489
    FEATURENODE_ID INTEGER NOT NULL,
1490
    ONLYAPPLICABLEIF_ID INTEGER NOT NULL,
1491
    REVTYPE TINYINT
1492
);
1493
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE_AUD;
1494
CREATE CACHED TABLE PUBLIC.FEATURETREE(
1495
    ID INTEGER NOT NULL,
1496
    CREATED TIMESTAMP,
1497
    UUID VARCHAR(36),
1498
    UPDATED TIMESTAMP,
1499
    LSID_AUTHORITY VARCHAR(255),
1500
    LSID_LSID VARCHAR(255),
1501
    LSID_NAMESPACE VARCHAR(255),
1502
    LSID_OBJECT VARCHAR(255),
1503
    LSID_REVISION VARCHAR(255),
1504
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
1505
    TITLECACHE VARCHAR(255),
1506
    URI CLOB,
1507
    DESCRIPTIONSEPARATED BOOLEAN NOT NULL,
1508
    CREATEDBY_ID INTEGER,
1509
    UPDATEDBY_ID INTEGER,
1510
    ROOT_ID INTEGER
1511
);
1512
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE;
1513
CREATE CACHED TABLE PUBLIC.FEATURETREE_AUD(
1514
    ID INTEGER NOT NULL,
1515
    REV INTEGER NOT NULL,
1516
    REVTYPE TINYINT,
1517
    CREATED TIMESTAMP,
1518
    UUID VARCHAR(36),
1519
    UPDATED TIMESTAMP,
1520
    LSID_AUTHORITY VARCHAR(255),
1521
    LSID_LSID VARCHAR(255),
1522
    LSID_NAMESPACE VARCHAR(255),
1523
    LSID_OBJECT VARCHAR(255),
1524
    LSID_REVISION VARCHAR(255),
1525
    PROTECTEDTITLECACHE BOOLEAN,
1526
    TITLECACHE VARCHAR(255),
1527
    URI CLOB,
1528
    DESCRIPTIONSEPARATED BOOLEAN,
1529
    CREATEDBY_ID INTEGER,
1530
    UPDATEDBY_ID INTEGER,
1531
    ROOT_ID INTEGER
1532
);
1533
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_AUD;
1534
CREATE CACHED TABLE PUBLIC.FEATURETREE_ANNOTATION(
1535
    FEATURETREE_ID INTEGER NOT NULL,
1536
    ANNOTATIONS_ID INTEGER NOT NULL
1537
);
1538
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_ANNOTATION;
1539
CREATE CACHED TABLE PUBLIC.FEATURETREE_ANNOTATION_AUD(
1540
    REV INTEGER NOT NULL,
1541
    FEATURETREE_ID INTEGER NOT NULL,
1542
    ANNOTATIONS_ID INTEGER NOT NULL,
1543
    REVTYPE TINYINT
1544
);
1545
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_ANNOTATION_AUD;
1546
CREATE CACHED TABLE PUBLIC.FEATURETREE_CREDIT(
1547
    FEATURETREE_ID INTEGER NOT NULL,
1548
    CREDITS_ID INTEGER NOT NULL,
1549
    SORTINDEX INTEGER NOT NULL
1550
);
1551
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_CREDIT;
1552
CREATE CACHED TABLE PUBLIC.FEATURETREE_CREDIT_AUD(
1553
    REV INTEGER NOT NULL,
1554
    FEATURETREE_ID INTEGER NOT NULL,
1555
    CREDITS_ID INTEGER NOT NULL,
1556
    SORTINDEX INTEGER NOT NULL,
1557
    REVTYPE TINYINT
1558
);
1559
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_CREDIT_AUD;
1560
CREATE CACHED TABLE PUBLIC.FEATURETREE_EXTENSION(
1561
    FEATURETREE_ID INTEGER NOT NULL,
1562
    EXTENSIONS_ID INTEGER NOT NULL
1563
);
1564
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_EXTENSION;
1565
CREATE CACHED TABLE PUBLIC.FEATURETREE_EXTENSION_AUD(
1566
    REV INTEGER NOT NULL,
1567
    FEATURETREE_ID INTEGER NOT NULL,
1568
    EXTENSIONS_ID INTEGER NOT NULL,
1569
    REVTYPE TINYINT
1570
);
1571
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_EXTENSION_AUD;
1572
CREATE CACHED TABLE PUBLIC.FEATURETREE_MARKER(
1573
    FEATURETREE_ID INTEGER NOT NULL,
1574
    MARKERS_ID INTEGER NOT NULL
1575
);
1576
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_MARKER;
1577
CREATE CACHED TABLE PUBLIC.FEATURETREE_MARKER_AUD(
1578
    REV INTEGER NOT NULL,
1579
    FEATURETREE_ID INTEGER NOT NULL,
1580
    MARKERS_ID INTEGER NOT NULL,
1581
    REVTYPE TINYINT
1582
);
1583
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_MARKER_AUD;
1584
CREATE CACHED TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE(
1585
    FEATURETREE_ID INTEGER NOT NULL,
1586
    SOURCES_ID INTEGER NOT NULL
1587
);
1588
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_ORIGINALSOURCEBASE;
1589
CREATE CACHED TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE_AUD(
1590
    REV INTEGER NOT NULL,
1591
    FEATURETREE_ID INTEGER NOT NULL,
1592
    SOURCES_ID INTEGER NOT NULL,
1593
    REVTYPE TINYINT
1594
);
1595
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_ORIGINALSOURCEBASE_AUD;
1596
CREATE CACHED TABLE PUBLIC.FEATURETREE_REPRESENTATION(
1597
    FEATURETREE_ID INTEGER NOT NULL,
1598
    REPRESENTATIONS_ID INTEGER NOT NULL
1599
);
1600
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_REPRESENTATION;
1601
CREATE CACHED TABLE PUBLIC.FEATURETREE_REPRESENTATION_AUD(
1602
    REV INTEGER NOT NULL,
1603
    FEATURETREE_ID INTEGER NOT NULL,
1604
    REPRESENTATIONS_ID INTEGER NOT NULL,
1605
    REVTYPE TINYINT
1606
);
1607
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_REPRESENTATION_AUD;
1608
CREATE CACHED TABLE PUBLIC.FEATURETREE_RIGHTS(
1609
    FEATURETREE_ID INTEGER NOT NULL,
1610
    RIGHTS_ID INTEGER NOT NULL
1611
);
1612
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_RIGHTS;
1613
CREATE CACHED TABLE PUBLIC.FEATURETREE_RIGHTS_AUD(
1614
    REV INTEGER NOT NULL,
1615
    FEATURETREE_ID INTEGER NOT NULL,
1616
    RIGHTS_ID INTEGER NOT NULL,
1617
    REVTYPE TINYINT
1618
);
1619
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FEATURETREE_RIGHTS_AUD;
1620
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT(
1621
    ID INTEGER NOT NULL,
1622
    CREATED TIMESTAMP,
1623
    UUID VARCHAR(36),
1624
    UPDATED TIMESTAMP,
1625
    DESCRIPTION VARCHAR(255),
1626
    TIMEPERIOD_END VARCHAR(255),
1627
    TIMEPERIOD_FREETEXT VARCHAR(255),
1628
    TIMEPERIOD_START VARCHAR(255),
1629
    ABSOLUTEELEVATION INTEGER,
1630
    ABSOLUTEELEVATIONMAX INTEGER,
1631
    ABSOLUTEELEVATIONTEXT VARCHAR(30),
1632
    COLLECTINGMETHOD VARCHAR(255),
1633
    DISTANCETOGROUND DOUBLE,
1634
    DISTANCETOGROUNDMAX DOUBLE,
1635
    DISTANCETOGROUNDTEXT VARCHAR(30),
1636
    DISTANCETOWATERSURFACE DOUBLE,
1637
    DISTANCETOWATERSURFACEMAX DOUBLE,
1638
    DISTANCETOWATERSURFACETEXT VARCHAR(30),
1639
    EXACTLOCATION_ERRORRADIUS INTEGER,
1640
    EXACTLOCATION_LATITUDE DOUBLE,
1641
    EXACTLOCATION_LONGITUDE DOUBLE,
1642
    CREATEDBY_ID INTEGER,
1643
    UPDATEDBY_ID INTEGER,
1644
    ACTOR_ID INTEGER,
1645
    COUNTRY_ID INTEGER,
1646
    EXACTLOCATION_REFERENCESYSTEM_ID INTEGER,
1647
    LOCALITY_ID INTEGER
1648
);
1649
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT;
1650
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_AUD(
1651
    ID INTEGER NOT NULL,
1652
    REV INTEGER NOT NULL,
1653
    REVTYPE TINYINT,
1654
    CREATED TIMESTAMP,
1655
    UUID VARCHAR(36),
1656
    UPDATED TIMESTAMP,
1657
    DESCRIPTION VARCHAR(255),
1658
    TIMEPERIOD_END VARCHAR(255),
1659
    TIMEPERIOD_FREETEXT VARCHAR(255),
1660
    TIMEPERIOD_START VARCHAR(255),
1661
    ABSOLUTEELEVATION INTEGER,
1662
    ABSOLUTEELEVATIONMAX INTEGER,
1663
    ABSOLUTEELEVATIONTEXT VARCHAR(30),
1664
    COLLECTINGMETHOD VARCHAR(255),
1665
    DISTANCETOGROUND DOUBLE,
1666
    DISTANCETOGROUNDMAX DOUBLE,
1667
    DISTANCETOGROUNDTEXT VARCHAR(30),
1668
    DISTANCETOWATERSURFACE DOUBLE,
1669
    DISTANCETOWATERSURFACEMAX DOUBLE,
1670
    DISTANCETOWATERSURFACETEXT VARCHAR(30),
1671
    EXACTLOCATION_ERRORRADIUS INTEGER,
1672
    EXACTLOCATION_LATITUDE DOUBLE,
1673
    EXACTLOCATION_LONGITUDE DOUBLE,
1674
    CREATEDBY_ID INTEGER,
1675
    UPDATEDBY_ID INTEGER,
1676
    ACTOR_ID INTEGER,
1677
    COUNTRY_ID INTEGER,
1678
    EXACTLOCATION_REFERENCESYSTEM_ID INTEGER,
1679
    LOCALITY_ID INTEGER
1680
);
1681
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_AUD;
1682
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_ANNOTATION(
1683
    GATHERINGEVENT_ID INTEGER NOT NULL,
1684
    ANNOTATIONS_ID INTEGER NOT NULL
1685
);
1686
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_ANNOTATION;
1687
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_ANNOTATION_AUD(
1688
    REV INTEGER NOT NULL,
1689
    GATHERINGEVENT_ID INTEGER NOT NULL,
1690
    ANNOTATIONS_ID INTEGER NOT NULL,
1691
    REVTYPE TINYINT
1692
);
1693
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_ANNOTATION_AUD;
1694
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE(
1695
    GATHERINGEVENT_ID INTEGER NOT NULL,
1696
    COLLECTINGAREAS_ID INTEGER NOT NULL
1697
);
1698
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE;
1699
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE_AUD(
1700
    REV INTEGER NOT NULL,
1701
    GATHERINGEVENT_ID INTEGER NOT NULL,
1702
    COLLECTINGAREAS_ID INTEGER NOT NULL,
1703
    REVTYPE TINYINT
1704
);
1705
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE_AUD;
1706
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_MARKER(
1707
    GATHERINGEVENT_ID INTEGER NOT NULL,
1708
    MARKERS_ID INTEGER NOT NULL
1709
);
1710
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_MARKER;
1711
CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD(
1712
    REV INTEGER NOT NULL,
1713
    GATHERINGEVENT_ID INTEGER NOT NULL,
1714
    MARKERS_ID INTEGER NOT NULL,
1715
    REVTYPE TINYINT
1716
);
1717
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_MARKER_AUD;
1718
CREATE CACHED TABLE PUBLIC.GRANTEDAUTHORITYIMPL(
1719
    ID INTEGER NOT NULL,
1720
    CREATED TIMESTAMP,
1721
    UUID VARCHAR(36),
1722
    AUTHORITY VARCHAR(255),
1723
    CREATEDBY_ID INTEGER
1724
);
1725
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GRANTEDAUTHORITYIMPL;
1726
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP(
1727
    ID INTEGER NOT NULL,
1728
    CREATED TIMESTAMP,
1729
    UUID VARCHAR(36),
1730
    UPDATED TIMESTAMP,
1731
    CREATEDBY_ID INTEGER,
1732
    UPDATEDBY_ID INTEGER
1733
);
1734
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP;
1735
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_AUD(
1736
    ID INTEGER NOT NULL,
1737
    REV INTEGER NOT NULL,
1738
    REVTYPE TINYINT,
1739
    CREATED TIMESTAMP,
1740
    UUID VARCHAR(36),
1741
    UPDATED TIMESTAMP,
1742
    CREATEDBY_ID INTEGER,
1743
    UPDATEDBY_ID INTEGER
1744
);
1745
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_AUD;
1746
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION(
1747
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
1748
    ANNOTATIONS_ID INTEGER NOT NULL
1749
);
1750
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_ANNOTATION;
1751
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION_AUD(
1752
    REV INTEGER NOT NULL,
1753
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
1754
    ANNOTATIONS_ID INTEGER NOT NULL,
1755
    REVTYPE TINYINT
1756
);
1757
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_ANNOTATION_AUD;
1758
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_MARKER(
1759
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
1760
    MARKERS_ID INTEGER NOT NULL
1761
);
1762
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_MARKER;
1763
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_MARKER_AUD(
1764
    REV INTEGER NOT NULL,
1765
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
1766
    MARKERS_ID INTEGER NOT NULL,
1767
    REVTYPE TINYINT
1768
);
1769
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_MARKER_AUD;
1770
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP(
1771
    ID INTEGER NOT NULL,
1772
    CREATED TIMESTAMP,
1773
    UUID VARCHAR(36),
1774
    UPDATED TIMESTAMP,
1775
    CITATIONMICROREFERENCE VARCHAR(255),
1776
    ORIGINALNAMESTRING VARCHAR(255),
1777
    DOUBTFUL BOOLEAN NOT NULL,
1778
    RULECONSIDERED VARCHAR(255),
1779
    CREATEDBY_ID INTEGER,
1780
    UPDATEDBY_ID INTEGER,
1781
    CITATION_ID INTEGER,
1782
    RELATEDFROM_ID INTEGER,
1783
    RELATEDTO_ID INTEGER,
1784
    TYPE_ID INTEGER
1785
);
1786
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP;
1787
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_AUD(
1788
    ID INTEGER NOT NULL,
1789
    REV INTEGER NOT NULL,
1790
    REVTYPE TINYINT,
1791
    CREATED TIMESTAMP,
1792
    UUID VARCHAR(36),
1793
    UPDATED TIMESTAMP,
1794
    CITATIONMICROREFERENCE VARCHAR(255),
1795
    ORIGINALNAMESTRING VARCHAR(255),
1796
    DOUBTFUL BOOLEAN,
1797
    RULECONSIDERED VARCHAR(255),
1798
    CREATEDBY_ID INTEGER,
1799
    UPDATEDBY_ID INTEGER,
1800
    CITATION_ID INTEGER,
1801
    RELATEDFROM_ID INTEGER,
1802
    RELATEDTO_ID INTEGER,
1803
    TYPE_ID INTEGER
1804
);
1805
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_AUD;
1806
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION(
1807
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
1808
    ANNOTATIONS_ID INTEGER NOT NULL
1809
);
1810
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION;
1811
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD(
1812
    REV INTEGER NOT NULL,
1813
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
1814
    ANNOTATIONS_ID INTEGER NOT NULL,
1815
    REVTYPE TINYINT
1816
);
1817
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD;
1818
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER(
1819
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
1820
    MARKERS_ID INTEGER NOT NULL
1821
);
1822
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_MARKER;
1823
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER_AUD(
1824
    REV INTEGER NOT NULL,
1825
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
1826
    MARKERS_ID INTEGER NOT NULL,
1827
    REVTYPE TINYINT
1828
);
1829
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_MARKER_AUD;
1830
CREATE CACHED TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING(
1831
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1832
    DESCRIPTION_ID INTEGER NOT NULL,
1833
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
1834
);
1835
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING;
1836
CREATE CACHED TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING_AUD(
1837
    REV INTEGER NOT NULL,
1838
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1839
    DESCRIPTION_ID INTEGER NOT NULL,
1840
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
1841
    REVTYPE TINYINT
1842
);
1843
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING_AUD;
1844
CREATE CACHED TABLE PUBLIC.INSTITUTIONALMEMBERSHIP(
1845
    ID INTEGER NOT NULL,
1846
    CREATED TIMESTAMP,
1847
    UUID VARCHAR(36),
1848
    UPDATED TIMESTAMP,
1849
    DEPARTMENT VARCHAR(255),
1850
    PERIOD_END VARCHAR(255),
1851
    PERIOD_FREETEXT VARCHAR(255),
1852
    PERIOD_START VARCHAR(255),
1853
    ROLE VARCHAR(255),
1854
    CREATEDBY_ID INTEGER,
1855
    UPDATEDBY_ID INTEGER,
1856
    INSTITUTE_ID INTEGER,
1857
    PERSON_ID INTEGER
1858
);
1859
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INSTITUTIONALMEMBERSHIP;
1860
CREATE CACHED TABLE PUBLIC.INSTITUTIONALMEMBERSHIP_AUD(
1861
    ID INTEGER NOT NULL,
1862
    REV INTEGER NOT NULL,
1863
    REVTYPE TINYINT,
1864
    CREATED TIMESTAMP,
1865
    UUID VARCHAR(36),
1866
    UPDATED TIMESTAMP,
1867
    DEPARTMENT VARCHAR(255),
1868
    PERIOD_END VARCHAR(255),
1869
    PERIOD_FREETEXT VARCHAR(255),
1870
    PERIOD_START VARCHAR(255),
1871
    ROLE VARCHAR(255),
1872
    CREATEDBY_ID INTEGER,
1873
    UPDATEDBY_ID INTEGER,
1874
    INSTITUTE_ID INTEGER,
1875
    PERSON_ID INTEGER
1876
);
1877
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INSTITUTIONALMEMBERSHIP_AUD;
1878
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT(
1879
    ID INTEGER NOT NULL,
1880
    CREATED TIMESTAMP,
1881
    UUID VARCHAR(36),
1882
    UPDATED TIMESTAMP,
1883
    CREATEDBY_ID INTEGER,
1884
    UPDATEDBY_ID INTEGER
1885
);
1886
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT;
1887
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT_AUD(
1888
    ID INTEGER NOT NULL,
1889
    REV INTEGER NOT NULL,
1890
    REVTYPE TINYINT,
1891
    CREATED TIMESTAMP,
1892
    UUID VARCHAR(36),
1893
    UPDATED TIMESTAMP,
1894
    CREATEDBY_ID INTEGER,
1895
    UPDATEDBY_ID INTEGER
1896
);
1897
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT_AUD;
1898
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING(
1899
    KEYSTATEMENT_ID INTEGER NOT NULL,
1900
    LABEL_ID INTEGER NOT NULL,
1901
    LABEL_MAPKEY_ID INTEGER NOT NULL
1902
);
1903
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT_LANGUAGESTRING;
1904
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING_AUD(
1905
    REV INTEGER NOT NULL,
1906
    KEYSTATEMENT_ID INTEGER NOT NULL,
1907
    LABEL_ID INTEGER NOT NULL,
1908
    LABEL_MAPKEY_ID INTEGER NOT NULL,
1909
    REVTYPE TINYINT
1910
);
1911
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT_LANGUAGESTRING_AUD;
1912
CREATE CACHED TABLE PUBLIC.LSIDAUTHORITY(
1913
    ID INTEGER NOT NULL,
1914
    CREATED TIMESTAMP,
1915
    UUID VARCHAR(36),
1916
    AUTHORITY VARCHAR(255),
1917
    AUTHORITYWSDL CLOB,
1918
    PORT INTEGER NOT NULL,
1919
    SERVER VARCHAR(255),
1920
    URL VARCHAR(255),
1921
    CREATEDBY_ID INTEGER
1922
);
1923
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LSIDAUTHORITY;
1924
CREATE CACHED TABLE PUBLIC.LSIDAUTHORITY_NAMESPACES(
1925
    LSIDAUTHORITY_ID INTEGER NOT NULL,
1926
    NAMESPACES_ELEMENT VARCHAR(255),
1927
    NAMESPACES_MAPKEY VARCHAR(255) NOT NULL
1928
);
1929
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LSIDAUTHORITY_NAMESPACES;
1930
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING(
1931
    ID INTEGER NOT NULL,
1932
    CREATED TIMESTAMP,
1933
    UUID VARCHAR(36),
1934
    UPDATED TIMESTAMP,
1935
    TEXT CLOB,
1936
    CREATEDBY_ID INTEGER,
1937
    UPDATEDBY_ID INTEGER,
1938
    LANGUAGE_ID INTEGER
1939
);
1940
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING;
1941
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_AUD(
1942
    ID INTEGER NOT NULL,
1943
    REV INTEGER NOT NULL,
1944
    REVTYPE TINYINT,
1945
    CREATED TIMESTAMP,
1946
    UUID VARCHAR(36),
1947
    UPDATED TIMESTAMP,
1948
    TEXT CLOB,
1949
    CREATEDBY_ID INTEGER,
1950
    UPDATEDBY_ID INTEGER,
1951
    LANGUAGE_ID INTEGER
1952
);
1953
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_AUD;
1954
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_ANNOTATION(
1955
    LANGUAGESTRING_ID INTEGER NOT NULL,
1956
    ANNOTATIONS_ID INTEGER NOT NULL
1957
);
1958
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_ANNOTATION;
1959
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_ANNOTATION_AUD(
1960
    REV INTEGER NOT NULL,
1961
    LANGUAGESTRING_ID INTEGER NOT NULL,
1962
    ANNOTATIONS_ID INTEGER NOT NULL,
1963
    REVTYPE TINYINT
1964
);
1965
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_ANNOTATION_AUD;
1966
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_MARKER(
1967
    LANGUAGESTRING_ID INTEGER NOT NULL,
1968
    MARKERS_ID INTEGER NOT NULL
1969
);
1970
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_MARKER;
1971
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD(
1972
    REV INTEGER NOT NULL,
1973
    LANGUAGESTRING_ID INTEGER NOT NULL,
1974
    MARKERS_ID INTEGER NOT NULL,
1975
    REVTYPE TINYINT
1976
);
1977
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_MARKER_AUD;
1978
CREATE CACHED TABLE PUBLIC.LOCUS(
1979
    ID INTEGER NOT NULL,
1980
    CREATED TIMESTAMP,
1981
    UUID VARCHAR(36),
1982
    UPDATED TIMESTAMP,
1983
    DESCRIPTION VARCHAR(255),
1984
    NAME VARCHAR(255),
1985
    CREATEDBY_ID INTEGER,
1986
    UPDATEDBY_ID INTEGER
1987
);
1988
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LOCUS;
1989
CREATE CACHED TABLE PUBLIC.LOCUS_AUD(
1990
    ID INTEGER NOT NULL,
1991
    REV INTEGER NOT NULL,
1992
    REVTYPE TINYINT,
1993
    CREATED TIMESTAMP,
1994
    UUID VARCHAR(36),
1995
    UPDATED TIMESTAMP,
1996
    DESCRIPTION VARCHAR(255),
1997
    NAME VARCHAR(255),
1998
    CREATEDBY_ID INTEGER,
1999
    UPDATEDBY_ID INTEGER
2000
);
2001
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LOCUS_AUD;
2002
CREATE CACHED TABLE PUBLIC.MARKER(
2003
    ID INTEGER NOT NULL,
2004
    CREATED TIMESTAMP,
2005
    UUID VARCHAR(36),
2006
    UPDATED TIMESTAMP,
2007
    FLAG BOOLEAN NOT NULL,
2008
    MARKEDOBJ_TYPE VARCHAR(255),
2009
    MARKEDOBJ_ID INTEGER NOT NULL,
2010
    CREATEDBY_ID INTEGER,
2011
    UPDATEDBY_ID INTEGER,
2012
    MARKERTYPE_ID INTEGER
2013
);
2014
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MARKER;
2015
CREATE CACHED TABLE PUBLIC.MARKER_AUD(
2016
    ID INTEGER NOT NULL,
2017
    REV INTEGER NOT NULL,
2018
    REVTYPE TINYINT,
2019
    CREATED TIMESTAMP,
2020
    UUID VARCHAR(36),
2021
    UPDATED TIMESTAMP,
2022
    FLAG BOOLEAN,
2023
    CREATEDBY_ID INTEGER,
2024
    UPDATEDBY_ID INTEGER,
2025
    MARKERTYPE_ID INTEGER
2026
);
2027
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MARKER_AUD;
2028
CREATE CACHED TABLE PUBLIC.MEDIA(
2029
    DTYPE VARCHAR(31) NOT NULL,
2030
    ID INTEGER NOT NULL,
2031
    CREATED TIMESTAMP,
2032
    UUID VARCHAR(36),
2033
    UPDATED TIMESTAMP,
2034
    LSID_AUTHORITY VARCHAR(255),
2035
    LSID_LSID VARCHAR(255),
2036
    LSID_NAMESPACE VARCHAR(255),
2037
    LSID_OBJECT VARCHAR(255),
2038
    LSID_REVISION VARCHAR(255),
2039
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
2040
    TITLECACHE VARCHAR(255),
2041
    MEDIACREATED TIMESTAMP,
2042
    CITATIONMICROREFERENCE VARCHAR(255),
2043
    CREATEDBY_ID INTEGER,
2044
    UPDATEDBY_ID INTEGER,
2045
    ARTIST_ID INTEGER,
2046
    CITATION_ID INTEGER
2047
);
2048
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA;
2049
CREATE CACHED TABLE PUBLIC.MEDIAKEY_NAMEDAREA(
2050
    MEDIA_ID INTEGER NOT NULL,
2051
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
2052
);
2053
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_NAMEDAREA;
2054
CREATE CACHED TABLE PUBLIC.MEDIAKEY_NAMEDAREA_AUD(
2055
    REV INTEGER NOT NULL,
2056
    MEDIA_ID INTEGER NOT NULL,
2057
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
2058
    REVTYPE TINYINT
2059
);
2060
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_NAMEDAREA_AUD;
2061
CREATE CACHED TABLE PUBLIC.MEDIAKEY_SCOPE(
2062
    MEDIA_ID INTEGER NOT NULL,
2063
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
2064
);
2065
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_SCOPE;
2066
CREATE CACHED TABLE PUBLIC.MEDIAKEY_SCOPE_AUD(
2067
    REV INTEGER NOT NULL,
2068
    MEDIA_ID INTEGER NOT NULL,
2069
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
2070
    REVTYPE TINYINT
2071
);
2072
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_SCOPE_AUD;
2073
CREATE CACHED TABLE PUBLIC.MEDIAKEY_TAXON(
2074
    MEDIAKEY_ID INTEGER NOT NULL,
2075
    TAXON_ID INTEGER NOT NULL
2076
);
2077
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_TAXON;
2078
CREATE CACHED TABLE PUBLIC.MEDIAKEY_TAXON_AUD(
2079
    REV INTEGER NOT NULL,
2080
    MEDIAKEY_ID INTEGER NOT NULL,
2081
    TAXON_ID INTEGER NOT NULL,
2082
    REVTYPE TINYINT
2083
);
2084
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_TAXON_AUD;
2085
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION(
2086
    ID INTEGER NOT NULL,
2087
    CREATED TIMESTAMP,
2088
    UUID VARCHAR(36),
2089
    UPDATED TIMESTAMP,
2090
    MIMETYPE VARCHAR(255),
2091
    SUFFIX VARCHAR(255),
2092
    CREATEDBY_ID INTEGER,
2093
    UPDATEDBY_ID INTEGER,
2094
    MEDIA_ID INTEGER
2095
);
2096
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATION;
2097
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATIONPART(
2098
    DTYPE VARCHAR(31) NOT NULL,
2099
    ID INTEGER NOT NULL,
2100
    CREATED TIMESTAMP,
2101
    UUID VARCHAR(36),
2102
    UPDATED TIMESTAMP,
2103
    SIZE INTEGER,
2104
    URI CLOB,
2105
    DURATION INTEGER,
2106
    HEIGHT INTEGER,
2107
    WIDTH INTEGER,
2108
    CREATEDBY_ID INTEGER,
2109
    UPDATEDBY_ID INTEGER,
2110
    REPRESENTATION_ID INTEGER NOT NULL,
2111
    SORTINDEX INTEGER
2112
);
2113
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATIONPART;
2114
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD(
2115
    DTYPE VARCHAR(31) NOT NULL,
2116
    ID INTEGER NOT NULL,
2117
    REV INTEGER NOT NULL,
2118
    REVTYPE TINYINT,
2119
    CREATED TIMESTAMP,
2120
    UUID VARCHAR(36),
2121
    UPDATED TIMESTAMP,
2122
    SIZE INTEGER,
2123
    URI CLOB,
2124
    CREATEDBY_ID INTEGER,
2125
    UPDATEDBY_ID INTEGER,
2126
    REPRESENTATION_ID INTEGER,
2127
    DURATION INTEGER,
2128
    HEIGHT INTEGER,
2129
    WIDTH INTEGER
2130
);
2131
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATIONPART_AUD;
2132
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION_AUD(
2133
    ID INTEGER NOT NULL,
2134
    REV INTEGER NOT NULL,
2135
    REVTYPE TINYINT,
2136
    CREATED TIMESTAMP,
2137
    UUID VARCHAR(36),
2138
    UPDATED TIMESTAMP,
2139
    MIMETYPE VARCHAR(255),
2140
    SUFFIX VARCHAR(255),
2141
    CREATEDBY_ID INTEGER,
2142
    UPDATEDBY_ID INTEGER,
2143
    MEDIA_ID INTEGER
2144
);
2145
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATION_AUD;
2146
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD(
2147
    REV INTEGER NOT NULL,
2148
    REPRESENTATION_ID INTEGER NOT NULL,
2149
    ID INTEGER NOT NULL,
2150
    SORTINDEX INTEGER NOT NULL,
2151
    REVTYPE TINYINT
2152
);
2153
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD;
2154
CREATE CACHED TABLE PUBLIC.MEDIA_AUD(
2155
    DTYPE VARCHAR(31) NOT NULL,
2156
    ID INTEGER NOT NULL,
2157
    REV INTEGER NOT NULL,
2158
    REVTYPE TINYINT,
2159
    CREATED TIMESTAMP,
2160
    UUID VARCHAR(36),
2161
    UPDATED TIMESTAMP,
2162
    LSID_AUTHORITY VARCHAR(255),
2163
    LSID_LSID VARCHAR(255),
2164
    LSID_NAMESPACE VARCHAR(255),
2165
    LSID_OBJECT VARCHAR(255),
2166
    LSID_REVISION VARCHAR(255),
2167
    PROTECTEDTITLECACHE BOOLEAN,
2168
    TITLECACHE VARCHAR(255),
2169
    MEDIACREATED TIMESTAMP,
2170
    CREATEDBY_ID INTEGER,
2171
    UPDATEDBY_ID INTEGER,
2172
    ARTIST_ID INTEGER,
2173
    CITATIONMICROREFERENCE VARCHAR(255),
2174
    CITATION_ID INTEGER
2175
);
2176
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_AUD;
2177
CREATE CACHED TABLE PUBLIC.MEDIA_ANNOTATION(
2178
    MEDIA_ID INTEGER NOT NULL,
2179
    ANNOTATIONS_ID INTEGER NOT NULL
2180
);
2181
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ANNOTATION;
2182
CREATE CACHED TABLE PUBLIC.MEDIA_ANNOTATION_AUD(
2183
    REV INTEGER NOT NULL,
2184
    MEDIA_ID INTEGER NOT NULL,
2185
    ANNOTATIONS_ID INTEGER NOT NULL,
2186
    REVTYPE TINYINT
2187
);
2188
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ANNOTATION_AUD;
2189
CREATE CACHED TABLE PUBLIC.MEDIA_CREDIT(
2190
    MEDIA_ID INTEGER NOT NULL,
2191
    CREDITS_ID INTEGER NOT NULL,
2192
    SORTINDEX INTEGER NOT NULL
2193
);
2194
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_CREDIT;
2195
CREATE CACHED TABLE PUBLIC.MEDIA_CREDIT_AUD(
2196
    REV INTEGER NOT NULL,
2197
    MEDIA_ID INTEGER NOT NULL,
2198
    CREDITS_ID INTEGER NOT NULL,
2199
    SORTINDEX INTEGER NOT NULL,
2200
    REVTYPE TINYINT
2201
);
2202
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_CREDIT_AUD;
2203
CREATE CACHED TABLE PUBLIC.MEDIA_DESCRIPTION(
2204
    MEDIA_ID INTEGER NOT NULL,
2205
    DESCRIPTION_ID INTEGER NOT NULL,
2206
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
2207
);
2208
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_DESCRIPTION;
2209
CREATE CACHED TABLE PUBLIC.MEDIA_DESCRIPTION_AUD(
2210
    REV INTEGER NOT NULL,
2211
    MEDIA_ID INTEGER NOT NULL,
2212
    DESCRIPTION_ID INTEGER NOT NULL,
2213
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
2214
    REVTYPE TINYINT
2215
);
2216
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_DESCRIPTION_AUD;
2217
CREATE CACHED TABLE PUBLIC.MEDIA_EXTENSION(
2218
    MEDIA_ID INTEGER NOT NULL,
2219
    EXTENSIONS_ID INTEGER NOT NULL
2220
);
2221
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_EXTENSION;
2222
CREATE CACHED TABLE PUBLIC.MEDIA_EXTENSION_AUD(
2223
    REV INTEGER NOT NULL,
2224
    MEDIA_ID INTEGER NOT NULL,
2225
    EXTENSIONS_ID INTEGER NOT NULL,
2226
    REVTYPE TINYINT
2227
);
2228
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_EXTENSION_AUD;
2229
CREATE CACHED TABLE PUBLIC.MEDIA_LANGUAGESTRING(
2230
    MEDIA_ID INTEGER NOT NULL,
2231
    TITLE_ID INTEGER NOT NULL,
2232
    TITLE_MAPKEY_ID INTEGER NOT NULL
2233
);
2234
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_LANGUAGESTRING;
2235
CREATE CACHED TABLE PUBLIC.MEDIA_LANGUAGESTRING_AUD(
2236
    REV INTEGER NOT NULL,
2237
    MEDIA_ID INTEGER NOT NULL,
2238
    TITLE_ID INTEGER NOT NULL,
2239
    TITLE_MAPKEY_ID INTEGER NOT NULL,
2240
    REVTYPE TINYINT
2241
);
2242
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_LANGUAGESTRING_AUD;
2243
CREATE CACHED TABLE PUBLIC.MEDIA_MARKER(
2244
    MEDIA_ID INTEGER NOT NULL,
2245
    MARKERS_ID INTEGER NOT NULL
2246
);
2247
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_MARKER;
2248
CREATE CACHED TABLE PUBLIC.MEDIA_MARKER_AUD(
2249
    REV INTEGER NOT NULL,
2250
    MEDIA_ID INTEGER NOT NULL,
2251
    MARKERS_ID INTEGER NOT NULL,
2252
    REVTYPE TINYINT
2253
);
2254
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_MARKER_AUD;
2255
CREATE CACHED TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE(
2256
    MEDIA_ID INTEGER NOT NULL,
2257
    SOURCES_ID INTEGER NOT NULL
2258
);
2259
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ORIGINALSOURCEBASE;
2260
CREATE CACHED TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD(
2261
    REV INTEGER NOT NULL,
2262
    MEDIA_ID INTEGER NOT NULL,
2263
    SOURCES_ID INTEGER NOT NULL,
2264
    REVTYPE TINYINT
2265
);
2266
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD;
2267
CREATE CACHED TABLE PUBLIC.MEDIA_REPRESENTATION(
2268
    MEDIA_ID INTEGER NOT NULL,
2269
    KEYREPRESENTATIONS_ID INTEGER NOT NULL
2270
);
2271
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_REPRESENTATION;
2272
CREATE CACHED TABLE PUBLIC.MEDIA_REPRESENTATION_AUD(
2273
    REV INTEGER NOT NULL,
2274
    MEDIA_ID INTEGER NOT NULL,
2275
    KEYREPRESENTATIONS_ID INTEGER NOT NULL,
2276
    REVTYPE TINYINT
2277
);
2278
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_REPRESENTATION_AUD;
2279
CREATE CACHED TABLE PUBLIC.MEDIA_RIGHTS(
2280
    MEDIA_ID INTEGER NOT NULL,
2281
    RIGHTS_ID INTEGER NOT NULL
2282
);
2283
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTS;
2284
CREATE CACHED TABLE PUBLIC.MEDIA_RIGHTS_AUD(
2285
    REV INTEGER NOT NULL,
2286
    MEDIA_ID INTEGER NOT NULL,
2287
    RIGHTS_ID INTEGER NOT NULL,
2288
    REVTYPE TINYINT
2289
);
2290
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTS_AUD;
2291
CREATE CACHED TABLE PUBLIC.MEDIA_SEQUENCE(
2292
    MEDIA_ID INTEGER NOT NULL,
2293
    USEDSEQUENCES_ID INTEGER NOT NULL
2294
);
2295
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_SEQUENCE;
2296
CREATE CACHED TABLE PUBLIC.MEDIA_SEQUENCE_AUD(
2297
    REV INTEGER NOT NULL,
2298
    MEDIA_ID INTEGER NOT NULL,
2299
    USEDSEQUENCES_ID INTEGER NOT NULL,
2300
    REVTYPE TINYINT
2301
);
2302
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_SEQUENCE_AUD;
2303
CREATE CACHED TABLE PUBLIC.MEDIA_TAXONBASE(
2304
    MEDIA_ID INTEGER NOT NULL,
2305
    COVEREDTAXA_ID INTEGER NOT NULL
2306
);
2307
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_TAXONBASE;
2308
CREATE CACHED TABLE PUBLIC.MEDIA_TAXONBASE_AUD(
2309
    REV INTEGER NOT NULL,
2310
    MEDIA_ID INTEGER NOT NULL,
2311
    COVEREDTAXA_ID INTEGER NOT NULL,
2312
    REVTYPE TINYINT
2313
);
2314
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_TAXONBASE_AUD;
2315
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA(
2316
    WORKINGSET_ID INTEGER NOT NULL,
2317
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
2318
);
2319
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_NAMEDAREA;
2320
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD(
2321
    REV INTEGER NOT NULL,
2322
    WORKINGSET_ID INTEGER NOT NULL,
2323
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
2324
    REVTYPE TINYINT
2325
);
2326
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD;
2327
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_SCOPE(
2328
    WORKINGSET_ID INTEGER NOT NULL,
2329
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
2330
);
2331
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_SCOPE;
2332
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_SCOPE_AUD(
2333
    REV INTEGER NOT NULL,
2334
    WORKINGSET_ID INTEGER NOT NULL,
2335
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
2336
    REVTYPE TINYINT
2337
);
2338
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_SCOPE_AUD;
2339
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_TAXON(
2340
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2341
    TAXON_ID INTEGER NOT NULL
2342
);
2343
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_TAXON;
2344
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_TAXON_AUD(
2345
    REV INTEGER NOT NULL,
2346
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2347
    TAXON_ID INTEGER NOT NULL,
2348
    REVTYPE TINYINT
2349
);
2350
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_TAXON_AUD;
2351
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP(
2352
    ID INTEGER NOT NULL,
2353
    CREATED TIMESTAMP,
2354
    UUID VARCHAR(36),
2355
    UPDATED TIMESTAMP,
2356
    CITATIONMICROREFERENCE VARCHAR(255),
2357
    ORIGINALNAMESTRING VARCHAR(255),
2358
    DOUBTFUL BOOLEAN NOT NULL,
2359
    RULECONSIDERED VARCHAR(255),
2360
    CREATEDBY_ID INTEGER,
2361
    UPDATEDBY_ID INTEGER,
2362
    CITATION_ID INTEGER,
2363
    RELATEDFROM_ID INTEGER,
2364
    RELATEDTO_ID INTEGER,
2365
    TYPE_ID INTEGER
2366
);
2367
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP;
2368
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_AUD(
2369
    ID INTEGER NOT NULL,
2370
    REV INTEGER NOT NULL,
2371
    REVTYPE TINYINT,
2372
    CREATED TIMESTAMP,
2373
    UUID VARCHAR(36),
2374
    UPDATED TIMESTAMP,
2375
    CITATIONMICROREFERENCE VARCHAR(255),
2376
    ORIGINALNAMESTRING VARCHAR(255),
2377
    DOUBTFUL BOOLEAN,
2378
    RULECONSIDERED VARCHAR(255),
2379
    CREATEDBY_ID INTEGER,
2380
    UPDATEDBY_ID INTEGER,
2381
    CITATION_ID INTEGER,
2382
    RELATEDFROM_ID INTEGER,
2383
    RELATEDTO_ID INTEGER,
2384
    TYPE_ID INTEGER
2385
);
2386
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_AUD;
2387
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION(
2388
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2389
    ANNOTATIONS_ID INTEGER NOT NULL
2390
);
2391
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_ANNOTATION;
2392
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD(
2393
    REV INTEGER NOT NULL,
2394
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2395
    ANNOTATIONS_ID INTEGER NOT NULL,
2396
    REVTYPE TINYINT
2397
);
2398
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD;
2399
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_MARKER(
2400
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2401
    MARKERS_ID INTEGER NOT NULL
2402
);
2403
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_MARKER;
2404
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_MARKER_AUD(
2405
    REV INTEGER NOT NULL,
2406
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2407
    MARKERS_ID INTEGER NOT NULL,
2408
    REVTYPE TINYINT
2409
);
2410
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_MARKER_AUD;
2411
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS(
2412
    ID INTEGER NOT NULL,
2413
    CREATED TIMESTAMP,
2414
    UUID VARCHAR(36),
2415
    UPDATED TIMESTAMP,
2416
    CITATIONMICROREFERENCE VARCHAR(255),
2417
    ORIGINALNAMESTRING VARCHAR(255),
2418
    RULECONSIDERED VARCHAR(255),
2419
    CREATEDBY_ID INTEGER,
2420
    UPDATEDBY_ID INTEGER,
2421
    CITATION_ID INTEGER,
2422
    TYPE_ID INTEGER
2423
);
2424
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS;
2425
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_AUD(
2426
    ID INTEGER NOT NULL,
2427
    REV INTEGER NOT NULL,
2428
    REVTYPE TINYINT,
2429
    CREATED TIMESTAMP,
2430
    UUID VARCHAR(36),
2431
    UPDATED TIMESTAMP,
2432
    CITATIONMICROREFERENCE VARCHAR(255),
2433
    ORIGINALNAMESTRING VARCHAR(255),
2434
    RULECONSIDERED VARCHAR(255),
2435
    CREATEDBY_ID INTEGER,
2436
    UPDATEDBY_ID INTEGER,
2437
    CITATION_ID INTEGER,
2438
    TYPE_ID INTEGER
2439
);
2440
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_AUD;
2441
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION(
2442
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
2443
    ANNOTATIONS_ID INTEGER NOT NULL
2444
);
2445
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_ANNOTATION;
2446
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD(
2447
    REV INTEGER NOT NULL,
2448
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
2449
    ANNOTATIONS_ID INTEGER NOT NULL,
2450
    REVTYPE TINYINT
2451
);
2452
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD;
2453
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER(
2454
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
2455
    MARKERS_ID INTEGER NOT NULL
2456
);
2457
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_MARKER;
2458
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD(
2459
    REV INTEGER NOT NULL,
2460
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
2461
    MARKERS_ID INTEGER NOT NULL,
2462
    REVTYPE TINYINT
2463
);
2464
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD;
2465
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE(
2466
    DTYPE VARCHAR(31) NOT NULL,
2467
    ID INTEGER NOT NULL,
2468
    CREATED TIMESTAMP,
2469
    UUID VARCHAR(36),
2470
    UPDATED TIMESTAMP,
2471
    SOURCETYPE INTEGER NOT NULL,
2472
    CITATIONMICROREFERENCE VARCHAR(255),
2473
    ORIGINALNAMESTRING VARCHAR(255),
2474
    IDINSOURCE VARCHAR(255),
2475
    IDNAMESPACE VARCHAR(255),
2476
    SOURCEDOBJ_TYPE VARCHAR(255),
2477
    SOURCEDOBJ_ID INTEGER NOT NULL,
2478
    CREATEDBY_ID INTEGER,
2479
    UPDATEDBY_ID INTEGER,
2480
    CITATION_ID INTEGER,
2481
    NAMEUSEDINSOURCE_ID INTEGER
2482
);
2483
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE;
2484
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_AUD(
2485
    DTYPE VARCHAR(31) NOT NULL,
2486
    ID INTEGER NOT NULL,
2487
    REV INTEGER NOT NULL,
2488
    REVTYPE TINYINT,
2489
    CREATED TIMESTAMP,
2490
    UUID VARCHAR(36),
2491
    UPDATED TIMESTAMP,
2492
           SOURCETYPE INTEGER NOT NULL,
2493
    CITATIONMICROREFERENCE VARCHAR(255),
2494
    ORIGINALNAMESTRING VARCHAR(255),
2495
    IDINSOURCE VARCHAR(255),
2496
    IDNAMESPACE VARCHAR(255),
2497
    CREATEDBY_ID INTEGER,
2498
    UPDATEDBY_ID INTEGER,
2499
    CITATION_ID INTEGER,
2500
    NAMEUSEDINSOURCE_ID INTEGER
2501
);
2502
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_AUD;
2503
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION(
2504
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
2505
    ANNOTATIONS_ID INTEGER NOT NULL
2506
);
2507
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_ANNOTATION;
2508
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD(
2509
    REV INTEGER NOT NULL,
2510
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
2511
    ANNOTATIONS_ID INTEGER NOT NULL,
2512
    REVTYPE TINYINT
2513
);
2514
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD;
2515
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER(
2516
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
2517
    MARKERS_ID INTEGER NOT NULL
2518
);
2519
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_MARKER;
2520
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER_AUD(
2521
    REV INTEGER NOT NULL,
2522
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
2523
    MARKERS_ID INTEGER NOT NULL,
2524
    REVTYPE TINYINT
2525
);
2526
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_MARKER_AUD;
2527
CREATE CACHED TABLE PUBLIC.PERMISSIONGROUP(
2528
    ID INTEGER NOT NULL,
2529
    CREATED TIMESTAMP,
2530
    UUID VARCHAR(36),
2531
    NAME VARCHAR(255),
2532
    CREATEDBY_ID INTEGER
2533
);
2534
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PERMISSIONGROUP;
2535
CREATE CACHED TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL(
2536
    PERMISSIONGROUP_ID INTEGER NOT NULL,
2537
    GRANTEDAUTHORITIES_ID INTEGER NOT NULL
2538
);
2539
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL;
2540
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY(
2541
    ID INTEGER NOT NULL,
2542
    CREATED TIMESTAMP,
2543
    UUID VARCHAR(36),
2544
    UPDATED TIMESTAMP,
2545
    LSID_AUTHORITY VARCHAR(255),
2546
    LSID_LSID VARCHAR(255),
2547
    LSID_NAMESPACE VARCHAR(255),
2548
    LSID_OBJECT VARCHAR(255),
2549
    LSID_REVISION VARCHAR(255),
2550
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
2551
    TITLECACHE VARCHAR(255),
2552
    CREATEDBY_ID INTEGER,
2553
    UPDATEDBY_ID INTEGER,
2554
    ROOT_ID INTEGER
2555
);
2556
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY;
2557
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE(
2558
    ID INTEGER NOT NULL,
2559
    CREATED TIMESTAMP,
2560
    UUID VARCHAR(36),
2561
    UPDATED TIMESTAMP,
2562
    NODENUMBER INTEGER,
2563
    SORTINDEX INTEGER,
2564
    CREATEDBY_ID INTEGER,
2565
    UPDATEDBY_ID INTEGER,
2566
    FEATURE_ID INTEGER,
2567
    KEY_ID INTEGER,
2568
    OTHERNODE_ID INTEGER,
2569
    PARENT_ID INTEGER,
2570
    QUESTION_ID INTEGER,
2571
    STATEMENT_ID INTEGER,
2572
    SUBKEY_ID INTEGER,
2573
    TAXON_ID INTEGER
2574
);
2575
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE;
2576
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_AUD(
2577
    ID INTEGER NOT NULL,
2578
    REV INTEGER NOT NULL,
2579
    REVTYPE TINYINT,
2580
    CREATED TIMESTAMP,
2581
    UUID VARCHAR(36),
2582
    UPDATED TIMESTAMP,
2583
    NODENUMBER INTEGER,
2584
    SORTINDEX INTEGER,
2585
    CREATEDBY_ID INTEGER,
2586
    UPDATEDBY_ID INTEGER,
2587
    FEATURE_ID INTEGER,
2588
    KEY_ID INTEGER,
2589
    OTHERNODE_ID INTEGER,
2590
    PARENT_ID INTEGER,
2591
    QUESTION_ID INTEGER,
2592
    STATEMENT_ID INTEGER,
2593
    SUBKEY_ID INTEGER,
2594
    TAXON_ID INTEGER
2595
);
2596
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_AUD;
2597
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING(
2598
    POLYTOMOUSKEYNODE_ID INTEGER NOT NULL,
2599
    MODIFYINGTEXT_ID INTEGER NOT NULL,
2600
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
2601
);
2602
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING;
2603
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD(
2604
    REV INTEGER NOT NULL,
2605
    POLYTOMOUSKEYNODE_ID INTEGER NOT NULL,
2606
    MODIFYINGTEXT_ID INTEGER NOT NULL,
2607
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
2608
    REVTYPE TINYINT
2609
);
2610
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD;
2611
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_AUD(
2612
    ID INTEGER NOT NULL,
2613
    REV INTEGER NOT NULL,
2614
    REVTYPE TINYINT,
2615
    CREATED TIMESTAMP,
2616
    UUID VARCHAR(36),
2617
    UPDATED TIMESTAMP,
2618
    LSID_AUTHORITY VARCHAR(255),
2619
    LSID_LSID VARCHAR(255),
2620
    LSID_NAMESPACE VARCHAR(255),
2621
    LSID_OBJECT VARCHAR(255),
2622
    LSID_REVISION VARCHAR(255),
2623
    PROTECTEDTITLECACHE BOOLEAN,
2624
    TITLECACHE VARCHAR(255),
2625
    CREATEDBY_ID INTEGER,
2626
    UPDATEDBY_ID INTEGER,
2627
    ROOT_ID INTEGER
2628
);
2629
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_AUD;
2630
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION(
2631
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2632
    ANNOTATIONS_ID INTEGER NOT NULL
2633
);
2634
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ANNOTATION;
2635
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD(
2636
    REV INTEGER NOT NULL,
2637
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2638
    ANNOTATIONS_ID INTEGER NOT NULL,
2639
    REVTYPE TINYINT
2640
);
2641
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD;
2642
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_CREDIT(
2643
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2644
    CREDITS_ID INTEGER NOT NULL,
2645
    SORTINDEX INTEGER NOT NULL
2646
);
2647
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_CREDIT;
2648
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_CREDIT_AUD(
2649
    REV INTEGER NOT NULL,
2650
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2651
    CREDITS_ID INTEGER NOT NULL,
2652
    SORTINDEX INTEGER NOT NULL,
2653
    REVTYPE TINYINT
2654
);
2655
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_CREDIT_AUD;
2656
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION(
2657
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2658
    EXTENSIONS_ID INTEGER NOT NULL
2659
);
2660
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_EXTENSION;
2661
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD(
2662
    REV INTEGER NOT NULL,
2663
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2664
    EXTENSIONS_ID INTEGER NOT NULL,
2665
    REVTYPE TINYINT
2666
);
2667
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD;
2668
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_MARKER(
2669
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2670
    MARKERS_ID INTEGER NOT NULL
2671
);
2672
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_MARKER;
2673
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_MARKER_AUD(
2674
    REV INTEGER NOT NULL,
2675
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2676
    MARKERS_ID INTEGER NOT NULL,
2677
    REVTYPE TINYINT
2678
);
2679
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_MARKER_AUD;
2680
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA(
2681
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2682
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
2683
);
2684
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_NAMEDAREA;
2685
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD(
2686
    REV INTEGER NOT NULL,
2687
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2688
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
2689
    REVTYPE TINYINT
2690
);
2691
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD;
2692
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE(
2693
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2694
    SOURCES_ID INTEGER NOT NULL
2695
);
2696
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE;
2697
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD(
2698
    REV INTEGER NOT NULL,
2699
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2700
    SOURCES_ID INTEGER NOT NULL,
2701
    REVTYPE TINYINT
2702
);
2703
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD;
2704
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS(
2705
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2706
    RIGHTS_ID INTEGER NOT NULL
2707
);
2708
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_RIGHTS;
2709
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS_AUD(
2710
    REV INTEGER NOT NULL,
2711
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2712
    RIGHTS_ID INTEGER NOT NULL,
2713
    REVTYPE TINYINT
2714
);
2715
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_RIGHTS_AUD;
2716
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_SCOPE(
2717
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2718
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
2719
);
2720
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_SCOPE;
2721
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_SCOPE_AUD(
2722
    REV INTEGER NOT NULL,
2723
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2724
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
2725
    REVTYPE TINYINT
2726
);
2727
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_SCOPE_AUD;
2728
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXON(
2729
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2730
    TAXON_ID INTEGER NOT NULL
2731
);
2732
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXON;
2733
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE(
2734
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2735
    COVEREDTAXA_ID INTEGER NOT NULL
2736
);
2737
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXONBASE;
2738
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD(
2739
    REV INTEGER NOT NULL,
2740
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2741
    COVEREDTAXA_ID INTEGER NOT NULL,
2742
    REVTYPE TINYINT
2743
);
2744
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD;
2745
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXON_AUD(
2746
    REV INTEGER NOT NULL,
2747
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2748
    TAXON_ID INTEGER NOT NULL,
2749
    REVTYPE TINYINT
2750
);
2751
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXON_AUD;
2752
CREATE CACHED TABLE PUBLIC.REFERENCE(
2753
    DTYPE VARCHAR(31) NOT NULL,
2754
    ID INTEGER NOT NULL,
2755
    CREATED TIMESTAMP,
2756
    UUID VARCHAR(36),
2757
    UPDATED TIMESTAMP,
2758
    LSID_AUTHORITY VARCHAR(255),
2759
    LSID_LSID VARCHAR(255),
2760
    LSID_NAMESPACE VARCHAR(255),
2761
    LSID_OBJECT VARCHAR(255),
2762
    LSID_REVISION VARCHAR(255),
2763
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
2764
    TITLECACHE VARCHAR(255),
2765
    DATEPUBLISHED_END VARCHAR(255),
2766
    DATEPUBLISHED_FREETEXT VARCHAR(255),
2767
    DATEPUBLISHED_START VARCHAR(255),
2768
    EDITION VARCHAR(255),
2769
    EDITOR VARCHAR(255),
2770
    ISBN VARCHAR(255),
2771
    ISSN VARCHAR(255),
2772
    NOMENCLATURALLYRELEVANT BOOLEAN NOT NULL,
2773
    ORGANIZATION VARCHAR(255),
2774
    PAGES VARCHAR(255),
2775
    PARSINGPROBLEM INTEGER NOT NULL,
2776
    PLACEPUBLISHED VARCHAR(255),
2777
    PROBLEMENDS INTEGER NOT NULL,
2778
    PROBLEMSTARTS INTEGER NOT NULL,
2779
    PUBLISHER VARCHAR(255),
2780
    REFERENCEABSTRACT CLOB,
2781
    SERIES VARCHAR(255),
2782
    SERIESPART VARCHAR(255),
2783
    TITLE CLOB,
2784
    REFTYPE INTEGER,
2785
    URI CLOB,
2786
    VOLUME VARCHAR(255),
2787
    CREATEDBY_ID INTEGER,
2788
    UPDATEDBY_ID INTEGER,
2789
    AUTHORTEAM_ID INTEGER,
2790
    INREFERENCE_ID INTEGER,
2791
    INSTITUTION_ID INTEGER,
2792
    SCHOOL_ID INTEGER
2793
);
2794
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE;
2795
CREATE INDEX PUBLIC.REFERENCETITLECACHEINDEX ON PUBLIC.REFERENCE(TITLECACHE);
2796
CREATE CACHED TABLE PUBLIC.REFERENCE_AUD(
2797
    DTYPE VARCHAR(31) NOT NULL,
2798
    ID INTEGER NOT NULL,
2799
    REV INTEGER NOT NULL,
2800
    REVTYPE TINYINT,
2801
    CREATED TIMESTAMP,
2802
    UUID VARCHAR(36),
2803
    UPDATED TIMESTAMP,
2804
    LSID_AUTHORITY VARCHAR(255),
2805
    LSID_LSID VARCHAR(255),
2806
    LSID_NAMESPACE VARCHAR(255),
2807
    LSID_OBJECT VARCHAR(255),
2808
    LSID_REVISION VARCHAR(255),
2809
    PROTECTEDTITLECACHE BOOLEAN,
2810
    TITLECACHE VARCHAR(255),
2811
    DATEPUBLISHED_END VARCHAR(255),
2812
    DATEPUBLISHED_FREETEXT VARCHAR(255),
2813
    DATEPUBLISHED_START VARCHAR(255),
2814
    EDITION VARCHAR(255),
2815
    EDITOR VARCHAR(255),
2816
    ISBN VARCHAR(255),
2817
    ISSN VARCHAR(255),
2818
    NOMENCLATURALLYRELEVANT BOOLEAN,
2819
    ORGANIZATION VARCHAR(255),
2820
    PAGES VARCHAR(255),
2821
    PARSINGPROBLEM INTEGER,
2822
    PLACEPUBLISHED VARCHAR(255),
2823
    PROBLEMENDS INTEGER,
2824
    PROBLEMSTARTS INTEGER,
2825
    PUBLISHER VARCHAR(255),
2826
    REFERENCEABSTRACT CLOB,
2827
    SERIES VARCHAR(255),
2828
    SERIESPART VARCHAR(255),
2829
    TITLE CLOB,
2830
    REFTYPE INTEGER,
2831
    URI CLOB,
2832
    VOLUME VARCHAR(255),
2833
    CREATEDBY_ID INTEGER,
2834
    UPDATEDBY_ID INTEGER,
2835
    AUTHORTEAM_ID INTEGER,
2836
    INREFERENCE_ID INTEGER,
2837
    INSTITUTION_ID INTEGER,
2838
    SCHOOL_ID INTEGER
2839
);
2840
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_AUD;
2841
CREATE CACHED TABLE PUBLIC.REFERENCE_ANNOTATION(
2842
    REFERENCE_ID INTEGER NOT NULL,
2843
    ANNOTATIONS_ID INTEGER NOT NULL
2844
);
2845
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ANNOTATION;
2846
CREATE CACHED TABLE PUBLIC.REFERENCE_ANNOTATION_AUD(
2847
    REV INTEGER NOT NULL,
2848
    REFERENCE_ID INTEGER NOT NULL,
2849
    ANNOTATIONS_ID INTEGER NOT NULL,
2850
    REVTYPE TINYINT
2851
);
2852
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ANNOTATION_AUD;
2853
CREATE CACHED TABLE PUBLIC.REFERENCE_CREDIT(
2854
    REFERENCE_ID INTEGER NOT NULL,
2855
    CREDITS_ID INTEGER NOT NULL,
2856
    SORTINDEX INTEGER NOT NULL
2857
);
2858
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_CREDIT;
2859
CREATE CACHED TABLE PUBLIC.REFERENCE_CREDIT_AUD(
2860
    REV INTEGER NOT NULL,
2861
    REFERENCE_ID INTEGER NOT NULL,
2862
    CREDITS_ID INTEGER NOT NULL,
2863
    SORTINDEX INTEGER NOT NULL,
2864
    REVTYPE TINYINT
2865
);
2866
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_CREDIT_AUD;
2867
CREATE CACHED TABLE PUBLIC.REFERENCE_EXTENSION(
2868
    REFERENCE_ID INTEGER NOT NULL,
2869
    EXTENSIONS_ID INTEGER NOT NULL
2870
);
2871
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_EXTENSION;
2872
CREATE CACHED TABLE PUBLIC.REFERENCE_EXTENSION_AUD(
2873
    REV INTEGER NOT NULL,
2874
    REFERENCE_ID INTEGER NOT NULL,
2875
    EXTENSIONS_ID INTEGER NOT NULL,
2876
    REVTYPE TINYINT
2877
);
2878
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_EXTENSION_AUD;
2879
CREATE CACHED TABLE PUBLIC.REFERENCE_MARKER(
2880
    REFERENCE_ID INTEGER NOT NULL,
2881
    MARKERS_ID INTEGER NOT NULL
2882
);
2883
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MARKER;
2884
CREATE CACHED TABLE PUBLIC.REFERENCE_MARKER_AUD(
2885
    REV INTEGER NOT NULL,
2886
    REFERENCE_ID INTEGER NOT NULL,
2887
    MARKERS_ID INTEGER NOT NULL,
2888
    REVTYPE TINYINT
2889
);
2890
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MARKER_AUD;
2891
CREATE CACHED TABLE PUBLIC.REFERENCE_MEDIA(
2892
    REFERENCE_ID INTEGER NOT NULL,
2893
    MEDIA_ID INTEGER NOT NULL
2894
);
2895
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MEDIA;
2896
CREATE CACHED TABLE PUBLIC.REFERENCE_MEDIA_AUD(
2897
    REV INTEGER NOT NULL,
2898
    REFERENCE_ID INTEGER NOT NULL,
2899
    MEDIA_ID INTEGER NOT NULL,
2900
    REVTYPE TINYINT
2901
);
2902
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MEDIA_AUD;
2903
CREATE CACHED TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE(
2904
    REFERENCE_ID INTEGER NOT NULL,
2905
    SOURCES_ID INTEGER NOT NULL
2906
);
2907
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ORIGINALSOURCEBASE;
2908
CREATE CACHED TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD(
2909
    REV INTEGER NOT NULL,
2910
    REFERENCE_ID INTEGER NOT NULL,
2911
    SOURCES_ID INTEGER NOT NULL,
2912
    REVTYPE TINYINT
2913
);
2914
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD;
2915
CREATE CACHED TABLE PUBLIC.REFERENCE_RIGHTS(
2916
    REFERENCE_ID INTEGER NOT NULL,
2917
    RIGHTS_ID INTEGER NOT NULL
2918
);
2919
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTS;
2920
CREATE CACHED TABLE PUBLIC.REFERENCE_RIGHTS_AUD(
2921
    REV INTEGER NOT NULL,
2922
    REFERENCE_ID INTEGER NOT NULL,
2923
    RIGHTS_ID INTEGER NOT NULL,
2924
    REVTYPE TINYINT
2925
);
2926
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTS_AUD;
2927
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION(
2928
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
2929
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL
2930
);
2931
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION;
2932
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD(
2933
    REV INTEGER NOT NULL,
2934
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
2935
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL,
2936
    REVTYPE TINYINT
2937
);
2938
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD;
2939
CREATE CACHED TABLE PUBLIC.REPRESENTATION(
2940
    ID INTEGER NOT NULL,
2941
    CREATED TIMESTAMP,
2942
    UUID VARCHAR(36),
2943
    UPDATED TIMESTAMP,
2944
    TEXT CLOB,
2945
    ABBREVIATEDLABEL VARCHAR(255),
2946
    LABEL VARCHAR(255),
2947
    CREATEDBY_ID INTEGER,
2948
    UPDATEDBY_ID INTEGER,
2949
    LANGUAGE_ID INTEGER
2950
);
2951
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION;
2952
CREATE CACHED TABLE PUBLIC.REPRESENTATION_AUD(
2953
    ID INTEGER NOT NULL,
2954
    REV INTEGER NOT NULL,
2955
    REVTYPE TINYINT,
2956
    CREATED TIMESTAMP,
2957
    UUID VARCHAR(36),
2958
    UPDATED TIMESTAMP,
2959
    TEXT CLOB,
2960
    ABBREVIATEDLABEL VARCHAR(255),
2961
    LABEL VARCHAR(255),
2962
    CREATEDBY_ID INTEGER,
2963
    UPDATEDBY_ID INTEGER,
2964
    LANGUAGE_ID INTEGER
2965
);
2966
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_AUD;
2967
CREATE CACHED TABLE PUBLIC.REPRESENTATION_ANNOTATION(
2968
    REPRESENTATION_ID INTEGER NOT NULL,
2969
    ANNOTATIONS_ID INTEGER NOT NULL
2970
);
2971
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION;
2972
CREATE CACHED TABLE PUBLIC.REPRESENTATION_ANNOTATION_AUD(
2973
    REV INTEGER NOT NULL,
2974
    REPRESENTATION_ID INTEGER NOT NULL,
2975
    ANNOTATIONS_ID INTEGER NOT NULL,
2976
    REVTYPE TINYINT
2977
);
2978
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION_AUD;
2979
CREATE CACHED TABLE PUBLIC.REPRESENTATION_MARKER(
2980
    REPRESENTATION_ID INTEGER NOT NULL,
2981
    MARKERS_ID INTEGER NOT NULL
2982
);
2983
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_MARKER;
2984
CREATE CACHED TABLE PUBLIC.REPRESENTATION_MARKER_AUD(
2985
    REV INTEGER NOT NULL,
2986
    REPRESENTATION_ID INTEGER NOT NULL,
2987
    MARKERS_ID INTEGER NOT NULL,
2988
    REVTYPE TINYINT
2989
);
2990
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_MARKER_AUD;
2991
CREATE CACHED TABLE PUBLIC.RIGHTS(
2992
    ID INTEGER NOT NULL,
2993
    CREATED TIMESTAMP,
2994
    UUID VARCHAR(36),
2995
    UPDATED TIMESTAMP,
2996
    TEXT CLOB,
2997
    ABBREVIATEDTEXT VARCHAR(255),
2998
    URI CLOB,
2999
    CREATEDBY_ID INTEGER,
3000
    UPDATEDBY_ID INTEGER,
3001
    LANGUAGE_ID INTEGER,
3002
    AGENT_ID INTEGER,
3003
    TYPE_ID INTEGER
3004
);
3005
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS;
3006
CREATE CACHED TABLE PUBLIC.RIGHTS_AUD(
3007
    ID INTEGER NOT NULL,
3008
    REV INTEGER NOT NULL,
3009
    REVTYPE TINYINT,
3010
    CREATED TIMESTAMP,
3011
    UUID VARCHAR(36),
3012
    UPDATED TIMESTAMP,
3013
    TEXT CLOB,
3014
    ABBREVIATEDTEXT VARCHAR(255),
3015
    URI CLOB,
3016
    CREATEDBY_ID INTEGER,
3017
    UPDATEDBY_ID INTEGER,
3018
    LANGUAGE_ID INTEGER,
3019
    AGENT_ID INTEGER,
3020
    TYPE_ID INTEGER
3021
);
3022
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_AUD;
3023
CREATE CACHED TABLE PUBLIC.RIGHTS_ANNOTATION(
3024
    RIGHTS_ID INTEGER NOT NULL,
3025
    ANNOTATIONS_ID INTEGER NOT NULL
3026
);
3027
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_ANNOTATION;
3028
CREATE CACHED TABLE PUBLIC.RIGHTS_ANNOTATION_AUD(
3029
    REV INTEGER NOT NULL,
3030
    RIGHTS_ID INTEGER NOT NULL,
3031
    ANNOTATIONS_ID INTEGER NOT NULL,
3032
    REVTYPE TINYINT
3033
);
3034
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_ANNOTATION_AUD;
3035
CREATE CACHED TABLE PUBLIC.RIGHTS_MARKER(
3036
    RIGHTS_ID INTEGER NOT NULL,
3037
    MARKERS_ID INTEGER NOT NULL
3038
);
3039
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_MARKER;
3040
CREATE CACHED TABLE PUBLIC.RIGHTS_MARKER_AUD(
3041
    REV INTEGER NOT NULL,
3042
    RIGHTS_ID INTEGER NOT NULL,
3043
    MARKERS_ID INTEGER NOT NULL,
3044
    REVTYPE TINYINT
3045
);
3046
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_MARKER_AUD;
3047
CREATE CACHED TABLE PUBLIC.SEQUENCE(
3048
    ID INTEGER NOT NULL,
3049
    CREATED TIMESTAMP,
3050
    UUID VARCHAR(36),
3051
    UPDATED TIMESTAMP,
3052
    LSID_AUTHORITY VARCHAR(255),
3053
    LSID_LSID VARCHAR(255),
3054
    LSID_NAMESPACE VARCHAR(255),
3055
    LSID_OBJECT VARCHAR(255),
3056
    LSID_REVISION VARCHAR(255),
3057
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3058
    TITLECACHE VARCHAR(255),
3059
    BARCODE BOOLEAN NOT NULL,
3060
    GENBANKACCESSIONNUMBER VARCHAR(20),
3061
    GENBANKURI CLOB,
3062
    CITATIONMICROREFERENCE VARCHAR(255),
3063
    DATESEQUENCED TIMESTAMP,
3064
    LENGTH INTEGER,
3065
    SEQUENCE CLOB,
3066
    CREATEDBY_ID INTEGER,
3067
    UPDATEDBY_ID INTEGER,
3068
    LOCUS_ID INTEGER,
3069
    PUBLISHEDIN_ID INTEGER
3070
);
3071
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE;
3072
CREATE INDEX PUBLIC.SEQUENCETITLECACHEINDEX ON PUBLIC.SEQUENCE(TITLECACHE);
3073
CREATE CACHED TABLE PUBLIC.SEQUENCE_AUD(
3074
    ID INTEGER NOT NULL,
3075
    REV INTEGER NOT NULL,
3076
    REVTYPE TINYINT,
3077
    CREATED TIMESTAMP,
3078
    UUID VARCHAR(36),
3079
    UPDATED TIMESTAMP,
3080
    LSID_AUTHORITY VARCHAR(255),
3081
    LSID_LSID VARCHAR(255),
3082
    LSID_NAMESPACE VARCHAR(255),
3083
    LSID_OBJECT VARCHAR(255),
3084
    LSID_REVISION VARCHAR(255),
3085
    PROTECTEDTITLECACHE BOOLEAN,
3086
    TITLECACHE VARCHAR(255),
3087
    BARCODE BOOLEAN,
3088
    GENBANKACCESSIONNUMBER VARCHAR(20),
3089
    GENBANKURI CLOB,
3090
    CITATIONMICROREFERENCE VARCHAR(255),
3091
    DATESEQUENCED TIMESTAMP,
3092
    LENGTH INTEGER,
3093
    SEQUENCE CLOB,
3094
    CREATEDBY_ID INTEGER,
3095
    UPDATEDBY_ID INTEGER,
3096
    LOCUS_ID INTEGER,
3097
    PUBLISHEDIN_ID INTEGER
3098
);
3099
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_AUD;
3100
CREATE CACHED TABLE PUBLIC.SEQUENCE_ANNOTATION(
3101
    SEQUENCE_ID INTEGER NOT NULL,
3102
    ANNOTATIONS_ID INTEGER NOT NULL
3103
);
3104
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ANNOTATION;
3105
CREATE CACHED TABLE PUBLIC.SEQUENCE_ANNOTATION_AUD(
3106
    REV INTEGER NOT NULL,
3107
    SEQUENCE_ID INTEGER NOT NULL,
3108
    ANNOTATIONS_ID INTEGER NOT NULL,
3109
    REVTYPE TINYINT
3110
);
3111
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ANNOTATION_AUD;
3112
CREATE CACHED TABLE PUBLIC.SEQUENCE_CREDIT(
3113
    SEQUENCE_ID INTEGER NOT NULL,
3114
    CREDITS_ID INTEGER NOT NULL,
3115
    SORTINDEX INTEGER NOT NULL
3116
);
3117
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_CREDIT;
3118
CREATE CACHED TABLE PUBLIC.SEQUENCE_CREDIT_AUD(
3119
    REV INTEGER NOT NULL,
3120
    SEQUENCE_ID INTEGER NOT NULL,
3121
    CREDITS_ID INTEGER NOT NULL,
3122
    SORTINDEX INTEGER NOT NULL,
3123
    REVTYPE TINYINT
3124
);
3125
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_CREDIT_AUD;
3126
CREATE CACHED TABLE PUBLIC.SEQUENCE_EXTENSION(
3127
    SEQUENCE_ID INTEGER NOT NULL,
3128
    EXTENSIONS_ID INTEGER NOT NULL
3129
);
3130
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION;
3131
CREATE CACHED TABLE PUBLIC.SEQUENCE_EXTENSION_AUD(
3132
    REV INTEGER NOT NULL,
3133
    SEQUENCE_ID INTEGER NOT NULL,
3134
    EXTENSIONS_ID INTEGER NOT NULL,
3135
    REVTYPE TINYINT
3136
);
3137
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION_AUD;
3138
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER(
3139
    SEQUENCE_ID INTEGER NOT NULL,
3140
    MARKERS_ID INTEGER NOT NULL
3141
);
3142
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MARKER;
3143
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER_AUD(
3144
    REV INTEGER NOT NULL,
3145
    SEQUENCE_ID INTEGER NOT NULL,
3146
    MARKERS_ID INTEGER NOT NULL,
3147
    REVTYPE TINYINT
3148
);
3149
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MARKER_AUD;
3150
CREATE CACHED TABLE PUBLIC.SEQUENCE_MEDIA(
3151
    SEQUENCE_ID INTEGER NOT NULL,
3152
    CHROMATOGRAMS_ID INTEGER NOT NULL
3153
);
3154
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MEDIA;
3155
CREATE CACHED TABLE PUBLIC.SEQUENCE_MEDIA_AUD(
3156
    REV INTEGER NOT NULL,
3157
    SEQUENCE_ID INTEGER NOT NULL,
3158
    CHROMATOGRAMS_ID INTEGER NOT NULL,
3159
    REVTYPE TINYINT
3160
);
3161
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MEDIA_AUD;
3162
CREATE CACHED TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE(
3163
    SEQUENCE_ID INTEGER NOT NULL,
3164
    SOURCES_ID INTEGER NOT NULL
3165
);
3166
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ORIGINALSOURCEBASE;
3167
CREATE CACHED TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD(
3168
    REV INTEGER NOT NULL,
3169
    SEQUENCE_ID INTEGER NOT NULL,
3170
    SOURCES_ID INTEGER NOT NULL,
3171
    REVTYPE TINYINT
3172
);
3173
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD;
3174
CREATE CACHED TABLE PUBLIC.SEQUENCE_REFERENCE(
3175
    SEQUENCE_ID INTEGER NOT NULL,
3176
    CITATIONS_ID INTEGER NOT NULL
3177
);
3178
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_REFERENCE;
3179
CREATE CACHED TABLE PUBLIC.SEQUENCE_REFERENCE_AUD(
3180
    REV INTEGER NOT NULL,
3181
    SEQUENCE_ID INTEGER NOT NULL,
3182
    CITATIONS_ID INTEGER NOT NULL,
3183
    REVTYPE TINYINT
3184
);
3185
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_REFERENCE_AUD;
3186
CREATE CACHED TABLE PUBLIC.SEQUENCE_RIGHTS(
3187
    SEQUENCE_ID INTEGER NOT NULL,
3188
    RIGHTS_ID INTEGER NOT NULL
3189
);
3190
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_RIGHTS;
3191
CREATE CACHED TABLE PUBLIC.SEQUENCE_RIGHTS_AUD(
3192
    REV INTEGER NOT NULL,
3193
    SEQUENCE_ID INTEGER NOT NULL,
3194
    RIGHTS_ID INTEGER NOT NULL,
3195
    REVTYPE TINYINT
3196
);
3197
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_RIGHTS_AUD;
3198
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE(
3199
    DTYPE VARCHAR(31) NOT NULL,
3200
    ID INTEGER NOT NULL,
3201
    CREATED TIMESTAMP,
3202
    UUID VARCHAR(36),
3203
    UPDATED TIMESTAMP,
3204
    LSID_AUTHORITY VARCHAR(255),
3205
    LSID_LSID VARCHAR(255),
3206
    LSID_NAMESPACE VARCHAR(255),
3207
    LSID_OBJECT VARCHAR(255),
3208
    LSID_REVISION VARCHAR(255),
3209
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3210
    TITLECACHE VARCHAR(255),
3211
    INDIVIDUALCOUNT INTEGER,
3212
    ACCESSIONNUMBER VARCHAR(255),
3213
    BARCODE VARCHAR(255),
3214
    CATALOGNUMBER VARCHAR(255),
3215
    COLLECTORSNUMBER VARCHAR(255),
3216
    EXSICCATUM VARCHAR(255),
3217
    FIELDNOTES VARCHAR(255),
3218
    FIELDNUMBER VARCHAR(255),
3219
    CREATEDBY_ID INTEGER,
3220
    UPDATEDBY_ID INTEGER,
3221
    LIFESTAGE_ID INTEGER,
3222
    SEX_ID INTEGER,
3223
    COLLECTION_ID INTEGER,
3224
    DERIVEDFROM_ID INTEGER,
3225
    STOREDUNDER_ID INTEGER,
3226
    PRESERVATION_ID INTEGER,
3227
    GATHERINGEVENT_ID INTEGER,
3228
    PRIMARYCOLLECTOR_ID INTEGER
3229
);
3230
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE;
3231
CREATE INDEX PUBLIC.SPECIMENOROBSERVATIONBASETITLECACHEINDEX ON PUBLIC.SPECIMENOROBSERVATIONBASE(TITLECACHE);
3232
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD(
3233
    DTYPE VARCHAR(31) NOT NULL,
3234
    ID INTEGER NOT NULL,
3235
    REV INTEGER NOT NULL,
3236
    REVTYPE TINYINT,
3237
    CREATED TIMESTAMP,
3238
    UUID VARCHAR(36),
3239
    UPDATED TIMESTAMP,
3240
    LSID_AUTHORITY VARCHAR(255),
3241
    LSID_LSID VARCHAR(255),
3242
    LSID_NAMESPACE VARCHAR(255),
3243
    LSID_OBJECT VARCHAR(255),
3244
    LSID_REVISION VARCHAR(255),
3245
    PROTECTEDTITLECACHE BOOLEAN,
3246
    TITLECACHE VARCHAR(255),
3247
    INDIVIDUALCOUNT INTEGER,
3248
    CREATEDBY_ID INTEGER,
3249
    UPDATEDBY_ID INTEGER,
3250
    LIFESTAGE_ID INTEGER,
3251
    SEX_ID INTEGER,
3252
    ACCESSIONNUMBER VARCHAR(255),
3253
    BARCODE VARCHAR(255),
3254
    CATALOGNUMBER VARCHAR(255),
3255
    COLLECTORSNUMBER VARCHAR(255),
3256
    COLLECTION_ID INTEGER,
3257
    DERIVEDFROM_ID INTEGER,
3258
    STOREDUNDER_ID INTEGER,
3259
    EXSICCATUM VARCHAR(255),
3260
    PRESERVATION_ID INTEGER,
3261
    FIELDNOTES VARCHAR(255),
3262
    FIELDNUMBER VARCHAR(255),
3263
    GATHERINGEVENT_ID INTEGER,
3264
    PRIMARYCOLLECTOR_ID INTEGER
3265
);
3266
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_AUD;
3267
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION(
3268
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3269
    ANNOTATIONS_ID INTEGER NOT NULL
3270
);
3271
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION;
3272
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD(
3273
    REV INTEGER NOT NULL,
3274
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3275
    ANNOTATIONS_ID INTEGER NOT NULL,
3276
    REVTYPE TINYINT
3277
);
3278
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD;
3279
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT(
3280
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3281
    CREDITS_ID INTEGER NOT NULL,
3282
    SORTINDEX INTEGER NOT NULL
3283
);
3284
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT;
3285
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD(
3286
    REV INTEGER NOT NULL,
3287
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3288
    CREDITS_ID INTEGER NOT NULL,
3289
    SORTINDEX INTEGER NOT NULL,
3290
    REVTYPE TINYINT
3291
);
3292
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD;
3293
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT(
3294
    ORIGINALS_ID INTEGER NOT NULL,
3295
    DERIVATIONEVENTS_ID INTEGER NOT NULL
3296
);
3297
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT;
3298
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD(
3299
    REV INTEGER NOT NULL,
3300
    ORIGINALS_ID INTEGER NOT NULL,
3301
    DERIVATIONEVENTS_ID INTEGER NOT NULL,
3302
    REVTYPE TINYINT
3303
);
3304
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD;
3305
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION(
3306
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3307
    EXTENSIONS_ID INTEGER NOT NULL
3308
);
3309
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION;
3310
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD(
3311
    REV INTEGER NOT NULL,
3312
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3313
    EXTENSIONS_ID INTEGER NOT NULL,
3314
    REVTYPE TINYINT
3315
);
3316
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD;
3317
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING(
3318
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3319
    DEFINITION_ID INTEGER NOT NULL,
3320
    DEFINITION_MAPKEY_ID INTEGER NOT NULL
3321
);
3322
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING;
3323
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD(
3324
    REV INTEGER NOT NULL,
3325
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3326
    DEFINITION_ID INTEGER NOT NULL,
3327
    DEFINITION_MAPKEY_ID INTEGER NOT NULL,
3328
    REVTYPE TINYINT
3329
);
3330
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD;
3331
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER(
3332
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3333
    MARKERS_ID INTEGER NOT NULL
3334
);
3335
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER;
3336
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD(
3337
    REV INTEGER NOT NULL,
3338
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3339
    MARKERS_ID INTEGER NOT NULL,
3340
    REVTYPE TINYINT
3341
);
3342
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD;
3343
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA(
3344
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3345
    MEDIA_ID INTEGER NOT NULL
3346
);
3347
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA;
3348
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD(
3349
    REV INTEGER NOT NULL,
3350
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3351
    MEDIA_ID INTEGER NOT NULL,
3352
    REVTYPE TINYINT
3353
);
3354
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD;
3355
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE(
3356
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3357
    SOURCES_ID INTEGER NOT NULL
3358
);
3359
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE;
3360
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD(
3361
    REV INTEGER NOT NULL,
3362
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3363
    SOURCES_ID INTEGER NOT NULL,
3364
    REVTYPE TINYINT
3365
);
3366
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD;
3367
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS(
3368
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3369
    RIGHTS_ID INTEGER NOT NULL
3370
);
3371
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS;
3372
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD(
3373
    REV INTEGER NOT NULL,
3374
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3375
    RIGHTS_ID INTEGER NOT NULL,
3376
    REVTYPE TINYINT
3377
);
3378
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD;
3379
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE(
3380
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3381
    SEQUENCES_ID INTEGER NOT NULL
3382
);
3383
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE;
3384
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD(
3385
    REV INTEGER NOT NULL,
3386
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3387
    SEQUENCES_ID INTEGER NOT NULL,
3388
    REVTYPE TINYINT
3389
);
3390
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD;
3391
CREATE CACHED TABLE PUBLIC.STATEDATA(
3392
    ID INTEGER NOT NULL,
3393
    CREATED TIMESTAMP,
3394
    UUID VARCHAR(36),
3395
    UPDATED TIMESTAMP,
3396
    CREATEDBY_ID INTEGER,
3397
    UPDATEDBY_ID INTEGER,
3398
    STATE_ID INTEGER
3399
);
3400
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA;
3401
CREATE CACHED TABLE PUBLIC.STATEDATA_AUD(
3402
    ID INTEGER NOT NULL,
3403
    REV INTEGER NOT NULL,
3404
    REVTYPE TINYINT,
3405
    CREATED TIMESTAMP,
3406
    UUID VARCHAR(36),
3407
    UPDATED TIMESTAMP,
3408
    CREATEDBY_ID INTEGER,
3409
    UPDATEDBY_ID INTEGER,
3410
    STATE_ID INTEGER
3411
);
3412
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_AUD;
3413
CREATE CACHED TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE(
3414
    STATEDATA_ID INTEGER NOT NULL,
3415
    MODIFIERS_ID INTEGER NOT NULL
3416
);
3417
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_DEFINEDTERMBASE;
3418
CREATE CACHED TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD(
3419
    REV INTEGER NOT NULL,
3420
    STATEDATA_ID INTEGER NOT NULL,
3421
    MODIFIERS_ID INTEGER NOT NULL,
3422
    REVTYPE TINYINT
3423
);
3424
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD;
3425
CREATE CACHED TABLE PUBLIC.STATEDATA_LANGUAGESTRING(
3426
    STATEDATA_ID INTEGER NOT NULL,
3427
    MODIFYINGTEXT_ID INTEGER NOT NULL,
3428
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
3429
);
3430
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_LANGUAGESTRING;
3431
CREATE CACHED TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD(
3432
    REV INTEGER NOT NULL,
3433
    STATEDATA_ID INTEGER NOT NULL,
3434
    MODIFYINGTEXT_ID INTEGER NOT NULL,
3435
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
3436
    REVTYPE TINYINT
3437
);
3438
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_LANGUAGESTRING_AUD;
3439
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE(
3440
    ID INTEGER NOT NULL,
3441
    CREATED TIMESTAMP,
3442
    UUID VARCHAR(36),
3443
    UPDATED TIMESTAMP,
3444
    VALUE DOUBLE NOT NULL,
3445
    CREATEDBY_ID INTEGER,
3446
    UPDATEDBY_ID INTEGER,
3447
    TYPE_ID INTEGER
3448
);
3449
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE;
3450
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD(
3451
    ID INTEGER NOT NULL,
3452
    REV INTEGER NOT NULL,
3453
    REVTYPE TINYINT,
3454
    CREATED TIMESTAMP,
3455
    UUID VARCHAR(36),
3456
    UPDATED TIMESTAMP,
3457
    VALUE DOUBLE,
3458
    CREATEDBY_ID INTEGER,
3459
    UPDATEDBY_ID INTEGER,
3460
    TYPE_ID INTEGER
3461
);
3462
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_AUD;
3463
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE(
3464
    STATISTICALMEASUREMENTVALUE_ID INTEGER NOT NULL,
3465
    MODIFIERS_ID INTEGER NOT NULL
3466
);
3467
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE;
3468
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD(
3469
    REV INTEGER NOT NULL,
3470
    STATISTICALMEASUREMENTVALUE_ID INTEGER NOT NULL,
3471
    MODIFIERS_ID INTEGER NOT NULL,
3472
    REVTYPE TINYINT
3473
);
3474
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD;
3475
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP(
3476
    ID INTEGER NOT NULL,
3477
    CREATED TIMESTAMP,
3478
    UUID VARCHAR(36),
3479
    UPDATED TIMESTAMP,
3480
    CITATIONMICROREFERENCE VARCHAR(255),
3481
    ORIGINALNAMESTRING VARCHAR(255),
3482
    DOUBTFUL BOOLEAN NOT NULL,
3483
    PARTIAL BOOLEAN NOT NULL,
3484
    PROPARTE BOOLEAN NOT NULL,
3485
    CREATEDBY_ID INTEGER,
3486
    UPDATEDBY_ID INTEGER,
3487
    CITATION_ID INTEGER,
3488
    RELATEDFROM_ID INTEGER,
3489
    RELATEDTO_ID INTEGER,
3490
    TYPE_ID INTEGER
3491
);
3492
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP;
3493
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_AUD(
3494
    ID INTEGER NOT NULL,
3495
    REV INTEGER NOT NULL,
3496
    REVTYPE TINYINT,
3497
    CREATED TIMESTAMP,
3498
    UUID VARCHAR(36),
3499
    UPDATED TIMESTAMP,
3500
    CITATIONMICROREFERENCE VARCHAR(255),
3501
    ORIGINALNAMESTRING VARCHAR(255),
3502
    DOUBTFUL BOOLEAN,
3503
    PARTIAL BOOLEAN,
3504
    PROPARTE BOOLEAN,
3505
    CREATEDBY_ID INTEGER,
3506
    UPDATEDBY_ID INTEGER,
3507
    CITATION_ID INTEGER,
3508
    RELATEDFROM_ID INTEGER,
3509
    RELATEDTO_ID INTEGER,
3510
    TYPE_ID INTEGER
3511
);
3512
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_AUD;
3513
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION(
3514
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3515
    ANNOTATIONS_ID INTEGER NOT NULL
3516
);
3517
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION;
3518
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION_AUD(
3519
    REV INTEGER NOT NULL,
3520
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3521
    ANNOTATIONS_ID INTEGER NOT NULL,
3522
    REVTYPE TINYINT
3523
);
3524
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION_AUD;
3525
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER(
3526
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3527
    MARKERS_ID INTEGER NOT NULL
3528
);
3529
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_MARKER;
3530
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER_AUD(
3531
    REV INTEGER NOT NULL,
3532
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3533
    MARKERS_ID INTEGER NOT NULL,
3534
    REVTYPE TINYINT
3535
);
3536
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_MARKER_AUD;
3537
CREATE CACHED TABLE PUBLIC.TAXONBASE(
3538
    DTYPE VARCHAR(31) NOT NULL,
3539
    ID INTEGER NOT NULL,
3540
    CREATED TIMESTAMP,
3541
    UUID VARCHAR(36),
3542
    UPDATED TIMESTAMP,
3543
    LSID_AUTHORITY VARCHAR(255),
3544
    LSID_LSID VARCHAR(255),
3545
    LSID_NAMESPACE VARCHAR(255),
3546
    LSID_OBJECT VARCHAR(255),
3547
    LSID_REVISION VARCHAR(255),
3548
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3549
    TITLECACHE VARCHAR(255),
3550
    APPENDEDPHRASE VARCHAR(255),
3551
    DOUBTFUL BOOLEAN NOT NULL,
3552
    USENAMECACHE BOOLEAN NOT NULL,
3553
    EXCLUDED BOOLEAN,
3554
    TAXONSTATUSUNKNOWN BOOLEAN,
3555
    TAXONOMICCHILDRENCOUNT INTEGER,
3556
    UNPLACED BOOLEAN,
3557
    CREATEDBY_ID INTEGER,
3558
    UPDATEDBY_ID INTEGER,
3559
    NAME_ID INTEGER,
3560
    SEC_ID INTEGER,
3561
    TAXONOMICPARENTCACHE_ID INTEGER
3562
);
3563
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE;
3564
CREATE INDEX PUBLIC.TAXONBASETITLECACHEINDEX ON PUBLIC.TAXONBASE(TITLECACHE);
3565
CREATE CACHED TABLE PUBLIC.TAXONBASE_AUD(
3566
    DTYPE VARCHAR(31) NOT NULL,
3567
    ID INTEGER NOT NULL,
3568
    REV INTEGER NOT NULL,
3569
    REVTYPE TINYINT,
3570
    CREATED TIMESTAMP,
3571
    UUID VARCHAR(36),
3572
    UPDATED TIMESTAMP,
3573
    LSID_AUTHORITY VARCHAR(255),
3574
    LSID_LSID VARCHAR(255),
3575
    LSID_NAMESPACE VARCHAR(255),
3576
    LSID_OBJECT VARCHAR(255),
3577
    LSID_REVISION VARCHAR(255),
3578
    PROTECTEDTITLECACHE BOOLEAN,
3579
    TITLECACHE VARCHAR(255),
3580
    APPENDEDPHRASE VARCHAR(255),
3581
    DOUBTFUL BOOLEAN,
3582
    USENAMECACHE BOOLEAN,
3583
    CREATEDBY_ID INTEGER,
3584
    UPDATEDBY_ID INTEGER,
3585
    NAME_ID INTEGER,
3586
    SEC_ID INTEGER,
3587
    EXCLUDED BOOLEAN,
3588
    TAXONSTATUSUNKNOWN BOOLEAN,
3589
    TAXONOMICCHILDRENCOUNT INTEGER,
3590
    UNPLACED BOOLEAN,
3591
    TAXONOMICPARENTCACHE_ID INTEGER
3592
);
3593
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_AUD;
3594
CREATE CACHED TABLE PUBLIC.TAXONBASE_ANNOTATION(
3595
    TAXONBASE_ID INTEGER NOT NULL,
3596
    ANNOTATIONS_ID INTEGER NOT NULL
3597
);
3598
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ANNOTATION;
3599
CREATE CACHED TABLE PUBLIC.TAXONBASE_ANNOTATION_AUD(
3600
    REV INTEGER NOT NULL,
3601
    TAXONBASE_ID INTEGER NOT NULL,
3602
    ANNOTATIONS_ID INTEGER NOT NULL,
3603
    REVTYPE TINYINT
3604
);
3605
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ANNOTATION_AUD;
3606
CREATE CACHED TABLE PUBLIC.TAXONBASE_CREDIT(
3607
    TAXONBASE_ID INTEGER NOT NULL,
3608
    CREDITS_ID INTEGER NOT NULL,
3609
    SORTINDEX INTEGER NOT NULL
3610
);
3611
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_CREDIT;
3612
CREATE CACHED TABLE PUBLIC.TAXONBASE_CREDIT_AUD(
3613
    REV INTEGER NOT NULL,
3614
    TAXONBASE_ID INTEGER NOT NULL,
3615
    CREDITS_ID INTEGER NOT NULL,
3616
    SORTINDEX INTEGER NOT NULL,
3617
    REVTYPE TINYINT
3618
);
3619
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_CREDIT_AUD;
3620
CREATE CACHED TABLE PUBLIC.TAXONBASE_EXTENSION(
3621
    TAXONBASE_ID INTEGER NOT NULL,
3622
    EXTENSIONS_ID INTEGER NOT NULL
3623
);
3624
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_EXTENSION;
3625
CREATE CACHED TABLE PUBLIC.TAXONBASE_EXTENSION_AUD(
3626
    REV INTEGER NOT NULL,
3627
    TAXONBASE_ID INTEGER NOT NULL,
3628
    EXTENSIONS_ID INTEGER NOT NULL,
3629
    REVTYPE TINYINT
3630
);
3631
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_EXTENSION_AUD;
3632
CREATE CACHED TABLE PUBLIC.TAXONBASE_MARKER(
3633
    TAXONBASE_ID INTEGER NOT NULL,
3634
    MARKERS_ID INTEGER NOT NULL
3635
);
3636
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_MARKER;
3637
CREATE CACHED TABLE PUBLIC.TAXONBASE_MARKER_AUD(
3638
    REV INTEGER NOT NULL,
3639
    TAXONBASE_ID INTEGER NOT NULL,
3640
    MARKERS_ID INTEGER NOT NULL,
3641
    REVTYPE TINYINT
3642
);
3643
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_MARKER_AUD;
3644
CREATE CACHED TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE(
3645
    TAXONBASE_ID INTEGER NOT NULL,
3646
    SOURCES_ID INTEGER NOT NULL
3647
);
3648
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ORIGINALSOURCEBASE;
3649
CREATE CACHED TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE_AUD(
3650
    REV INTEGER NOT NULL,
3651
    TAXONBASE_ID INTEGER NOT NULL,
3652
    SOURCES_ID INTEGER NOT NULL,
3653
    REVTYPE TINYINT
3654
);
3655
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ORIGINALSOURCEBASE_AUD;
3656
CREATE CACHED TABLE PUBLIC.TAXONBASE_RIGHTS(
3657
    TAXONBASE_ID INTEGER NOT NULL,
3658
    RIGHTS_ID INTEGER NOT NULL
3659
);
3660
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_RIGHTS;
3661
CREATE CACHED TABLE PUBLIC.TAXONBASE_RIGHTS_AUD(
3662
    REV INTEGER NOT NULL,
3663
    TAXONBASE_ID INTEGER NOT NULL,
3664
    RIGHTS_ID INTEGER NOT NULL,
3665
    REVTYPE TINYINT
3666
);
3667
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_RIGHTS_AUD;
3668
CREATE CACHED TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING(
3669
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
3670
    DESCRIPTION_ID INTEGER NOT NULL,
3671
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
3672
);
3673
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONINTERACTION_LANGUAGESTRING;
3674
CREATE CACHED TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD(
3675
    REV INTEGER NOT NULL,
3676
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
3677
    DESCRIPTION_ID INTEGER NOT NULL,
3678
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
3679
    REVTYPE TINYINT
3680
);
3681
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD;
3682
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE(
3683
    DTYPE VARCHAR(31) NOT NULL,
3684
    ID INTEGER NOT NULL,
3685
    CREATED TIMESTAMP,
3686
    UUID VARCHAR(36),
3687
    UPDATED TIMESTAMP,
3688
    LSID_AUTHORITY VARCHAR(255),
3689
    LSID_LSID VARCHAR(255),
3690
    LSID_NAMESPACE VARCHAR(255),
3691
    LSID_OBJECT VARCHAR(255),
3692
    LSID_REVISION VARCHAR(255),
3693
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3694
    TITLECACHE VARCHAR(255),
3695
    APPENDEDPHRASE VARCHAR(255),
3696
    FULLTITLECACHE VARCHAR(330),
3697
    NOMENCLATURALMICROREFERENCE VARCHAR(255),
3698
    PARSINGPROBLEM INTEGER NOT NULL,
3699
    PROBLEMENDS INTEGER NOT NULL,
3700
    PROBLEMSTARTS INTEGER NOT NULL,
3701
    PROTECTEDFULLTITLECACHE BOOLEAN NOT NULL,
3702
    AUTHORSHIPCACHE VARCHAR(255),
3703
    BINOMHYBRID BOOLEAN,
3704
    GENUSORUNINOMIAL VARCHAR(255),
3705
    HYBRIDFORMULA BOOLEAN,
3706
    INFRAGENERICEPITHET VARCHAR(255),
3707
    INFRASPECIFICEPITHET VARCHAR(255),
3708
    MONOMHYBRID BOOLEAN,
3709
    NAMECACHE VARCHAR(255),
3710
    PROTECTEDAUTHORSHIPCACHE BOOLEAN,
3711
    PROTECTEDNAMECACHE BOOLEAN,
3712
    SPECIFICEPITHET VARCHAR(255),
3713
    TRINOMHYBRID BOOLEAN,
3714
    NAMEAPPROBATION VARCHAR(255),
3715
    SUBGENUSAUTHORSHIP VARCHAR(255),
3716
    ANAMORPHIC BOOLEAN,
3717
    CULTIVARNAME VARCHAR(255),
3718
    ACRONYM VARCHAR(255),
3719
    BREED VARCHAR(255),
3720
    ORIGINALPUBLICATIONYEAR INTEGER,
3721
    PUBLICATIONYEAR INTEGER,
3722
    CREATEDBY_ID INTEGER,
3723
    UPDATEDBY_ID INTEGER,
3724
    HOMOTYPICALGROUP_ID INTEGER,
3725
    NOMENCLATURALREFERENCE_ID INTEGER,
3726
    RANK_ID INTEGER,
3727
    BASIONYMAUTHORTEAM_ID INTEGER,
3728
    COMBINATIONAUTHORTEAM_ID INTEGER,
3729
    EXBASIONYMAUTHORTEAM_ID INTEGER,
3730
    EXCOMBINATIONAUTHORTEAM_ID INTEGER
3731
);
3732
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE;
3733
CREATE INDEX PUBLIC.TAXONNAMEBASETITLECACHEINDEX ON PUBLIC.TAXONNAMEBASE(TITLECACHE);
3734
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_AUD(
3735
    DTYPE VARCHAR(31) NOT NULL,
3736
    ID INTEGER NOT NULL,
3737
    REV INTEGER NOT NULL,
3738
    REVTYPE TINYINT,
3739
    CREATED TIMESTAMP,
3740
    UUID VARCHAR(36),
3741
    UPDATED TIMESTAMP,
3742
    LSID_AUTHORITY VARCHAR(255),
3743
    LSID_LSID VARCHAR(255),
3744
    LSID_NAMESPACE VARCHAR(255),
3745
    LSID_OBJECT VARCHAR(255),
3746
    LSID_REVISION VARCHAR(255),
3747
    PROTECTEDTITLECACHE BOOLEAN,
3748
    TITLECACHE VARCHAR(255),
3749
    APPENDEDPHRASE VARCHAR(255),
3750
    FULLTITLECACHE VARCHAR(330),
3751
    NOMENCLATURALMICROREFERENCE VARCHAR(255),
3752
    PARSINGPROBLEM INTEGER,
3753
    PROBLEMENDS INTEGER,
3754
    PROBLEMSTARTS INTEGER,
3755
    PROTECTEDFULLTITLECACHE BOOLEAN,
3756
    CREATEDBY_ID INTEGER,
3757
    UPDATEDBY_ID INTEGER,
3758
    HOMOTYPICALGROUP_ID INTEGER,
3759
    NOMENCLATURALREFERENCE_ID INTEGER,
3760
    RANK_ID INTEGER,
3761
    ACRONYM VARCHAR(255),
3762
    AUTHORSHIPCACHE VARCHAR(255),
3763
    BINOMHYBRID BOOLEAN,
3764
    GENUSORUNINOMIAL VARCHAR(255),
3765
    HYBRIDFORMULA BOOLEAN,
3766
    INFRAGENERICEPITHET VARCHAR(255),
3767
    INFRASPECIFICEPITHET VARCHAR(255),
3768
    MONOMHYBRID BOOLEAN,
3769
    NAMECACHE VARCHAR(255),
3770
    PROTECTEDAUTHORSHIPCACHE BOOLEAN,
3771
    PROTECTEDNAMECACHE BOOLEAN,
3772
    SPECIFICEPITHET VARCHAR(255),
3773
    TRINOMHYBRID BOOLEAN,
3774
    BASIONYMAUTHORTEAM_ID INTEGER,
3775
    COMBINATIONAUTHORTEAM_ID INTEGER,
3776
    EXBASIONYMAUTHORTEAM_ID INTEGER,
3777
    EXCOMBINATIONAUTHORTEAM_ID INTEGER,
3778
    ANAMORPHIC BOOLEAN,
3779
    CULTIVARNAME VARCHAR(255),
3780
    BREED VARCHAR(255),
3781
    ORIGINALPUBLICATIONYEAR INTEGER,
3782
    PUBLICATIONYEAR INTEGER,
3783
    NAMEAPPROBATION VARCHAR(255),
3784
    SUBGENUSAUTHORSHIP VARCHAR(255)
3785
);
3786
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_AUD;
3787
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION(
3788
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3789
    ANNOTATIONS_ID INTEGER NOT NULL
3790
);
3791
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ANNOTATION;
3792
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD(
3793
    REV INTEGER NOT NULL,
3794
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3795
    ANNOTATIONS_ID INTEGER NOT NULL,
3796
    REVTYPE TINYINT
3797
);
3798
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD;
3799
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_CREDIT(
3800
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3801
    CREDITS_ID INTEGER NOT NULL,
3802
    SORTINDEX INTEGER NOT NULL
3803
);
3804
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_CREDIT;
3805
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_CREDIT_AUD(
3806
    REV INTEGER NOT NULL,
3807
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3808
    CREDITS_ID INTEGER NOT NULL,
3809
    SORTINDEX INTEGER NOT NULL,
3810
    REVTYPE TINYINT
3811
);
3812
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_CREDIT_AUD;
3813
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_EXTENSION(
3814
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3815
    EXTENSIONS_ID INTEGER NOT NULL
3816
);
3817
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_EXTENSION;
3818
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_EXTENSION_AUD(
3819
    REV INTEGER NOT NULL,
3820
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3821
    EXTENSIONS_ID INTEGER NOT NULL,
3822
    REVTYPE TINYINT
3823
);
3824
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_EXTENSION_AUD;
3825
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_MARKER(
3826
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3827
    MARKERS_ID INTEGER NOT NULL
3828
);
3829
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_MARKER;
3830
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD(
3831
    REV INTEGER NOT NULL,
3832
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3833
    MARKERS_ID INTEGER NOT NULL,
3834
    REVTYPE TINYINT
3835
);
3836
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_MARKER_AUD;
3837
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS(
3838
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3839
    STATUS_ID INTEGER NOT NULL
3840
);
3841
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS;
3842
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD(
3843
    REV INTEGER NOT NULL,
3844
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3845
    STATUS_ID INTEGER NOT NULL,
3846
    REVTYPE TINYINT
3847
);
3848
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD;
3849
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE(
3850
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3851
    SOURCES_ID INTEGER NOT NULL
3852
);
3853
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE;
3854
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD(
3855
    REV INTEGER NOT NULL,
3856
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3857
    SOURCES_ID INTEGER NOT NULL,
3858
    REVTYPE TINYINT
3859
);
3860
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD;
3861
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_RIGHTS(
3862
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3863
    RIGHTS_ID INTEGER NOT NULL
3864
);
3865
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_RIGHTS;
3866
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_RIGHTS_AUD(
3867
    REV INTEGER NOT NULL,
3868
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3869
    RIGHTS_ID INTEGER NOT NULL,
3870
    REVTYPE TINYINT
3871
);
3872
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_RIGHTS_AUD;
3873
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE(
3874
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3875
    TYPEDESIGNATIONS_ID INTEGER NOT NULL
3876
);
3877
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE;
3878
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD(
3879
    REV INTEGER NOT NULL,
3880
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3881
    TYPEDESIGNATIONS_ID INTEGER NOT NULL,
3882
    REVTYPE TINYINT
3883
);
3884
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD;
3885
CREATE CACHED TABLE PUBLIC.TAXONNODE(
3886
    ID INTEGER NOT NULL,
3887
    CREATED TIMESTAMP,
3888
    UUID VARCHAR(36),
3889
    UPDATED TIMESTAMP,
3890
    SORTINDEX INTEGER,
3891
    TREEINDEX VARCHAR(255),
3892
    COUNTCHILDREN INTEGER NOT NULL,
3893
    MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
3894
    CREATEDBY_ID INTEGER,
3895
    UPDATEDBY_ID INTEGER,
3896
    CLASSIFICATION_ID INTEGER,
3897
    PARENT_ID INTEGER,
3898
    REFERENCEFORPARENTCHILDRELATION_ID INTEGER,
3899
    SYNONYMTOBEUSED_ID INTEGER,
3900
    TAXON_ID INTEGER
3901
);
3902
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE;
3903
CREATE CACHED TABLE PUBLIC.TAXONNODE_AUD(
3904
    ID INTEGER NOT NULL,
3905
    REV INTEGER NOT NULL,
3906
    REVTYPE TINYINT,
3907
    CREATED TIMESTAMP,
3908
    UUID VARCHAR(36),
3909
    UPDATED TIMESTAMP,
3910
    SORTINDEX INTEGER,
3911
    TREEINDEX VARCHAR(255),
3912
    COUNTCHILDREN INTEGER,
3913
    MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
3914
    CREATEDBY_ID INTEGER,
3915
    UPDATEDBY_ID INTEGER,
3916
    CLASSIFICATION_ID INTEGER,
3917
    PARENT_ID INTEGER,
3918
    REFERENCEFORPARENTCHILDRELATION_ID INTEGER,
3919
    SYNONYMTOBEUSED_ID INTEGER,
3920
    TAXON_ID INTEGER
3921
);
3922
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_AUD;
3923
CREATE CACHED TABLE PUBLIC.TAXONNODE_ANNOTATION(
3924
    TAXONNODE_ID INTEGER NOT NULL,
3925
    ANNOTATIONS_ID INTEGER NOT NULL
3926
);
3927
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_ANNOTATION;
3928
CREATE CACHED TABLE PUBLIC.TAXONNODE_ANNOTATION_AUD(
3929
    REV INTEGER NOT NULL,
3930
    TAXONNODE_ID INTEGER NOT NULL,
3931
    ANNOTATIONS_ID INTEGER NOT NULL,
3932
    REVTYPE TINYINT
3933
);
3934
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_ANNOTATION_AUD;
3935
CREATE CACHED TABLE PUBLIC.TAXONNODE_MARKER(
3936
    TAXONNODE_ID INTEGER NOT NULL,
3937
    MARKERS_ID INTEGER NOT NULL
3938
);
3939
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_MARKER;
3940
CREATE CACHED TABLE PUBLIC.TAXONNODE_MARKER_AUD(
3941
    REV INTEGER NOT NULL,
3942
    TAXONNODE_ID INTEGER NOT NULL,
3943
    MARKERS_ID INTEGER NOT NULL,
3944
    REVTYPE TINYINT
3945
);
3946
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_MARKER_AUD;
3947
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP(
3948
    ID INTEGER NOT NULL,
3949
    CREATED TIMESTAMP,
3950
    UUID VARCHAR(36),
3951
    UPDATED TIMESTAMP,
3952
    CITATIONMICROREFERENCE VARCHAR(255),
3953
    ORIGINALNAMESTRING VARCHAR(255),
3954
    DOUBTFUL BOOLEAN NOT NULL,
3955
    CREATEDBY_ID INTEGER,
3956
    UPDATEDBY_ID INTEGER,
3957
    CITATION_ID INTEGER,
3958
    RELATEDFROM_ID INTEGER,
3959
    RELATEDTO_ID INTEGER,
3960
    TYPE_ID INTEGER
3961
);
3962
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP;
3963
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_AUD(
3964
    ID INTEGER NOT NULL,
3965
    REV INTEGER NOT NULL,
3966
    REVTYPE TINYINT,
3967
    CREATED TIMESTAMP,
3968
    UUID VARCHAR(36),
3969
    UPDATED TIMESTAMP,
3970
    CITATIONMICROREFERENCE VARCHAR(255),
3971
    ORIGINALNAMESTRING VARCHAR(255),
3972
    DOUBTFUL BOOLEAN,
3973
    CREATEDBY_ID INTEGER,
3974
    UPDATEDBY_ID INTEGER,
3975
    CITATION_ID INTEGER,
3976
    RELATEDFROM_ID INTEGER,
3977
    RELATEDTO_ID INTEGER,
3978
    TYPE_ID INTEGER
3979
);
3980
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_AUD;
3981
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION(
3982
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
3983
    ANNOTATIONS_ID INTEGER NOT NULL
3984
);
3985
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_ANNOTATION;
3986
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION_AUD(
3987
    REV INTEGER NOT NULL,
3988
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
3989
    ANNOTATIONS_ID INTEGER NOT NULL,
3990
    REVTYPE TINYINT
3991
);
3992
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_ANNOTATION_AUD;
3993
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_MARKER(
3994
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
3995
    MARKERS_ID INTEGER NOT NULL
3996
);
3997
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_MARKER;
3998
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_MARKER_AUD(
3999
    REV INTEGER NOT NULL,
4000
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
4001
    MARKERS_ID INTEGER NOT NULL,
4002
    REVTYPE TINYINT
4003
);
4004
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_MARKER_AUD;
4005
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY(
4006
    DTYPE VARCHAR(31) NOT NULL,
4007
    ID INTEGER NOT NULL,
4008
    CREATED TIMESTAMP,
4009
    UUID VARCHAR(36),
4010
    UPDATED TIMESTAMP,
4011
    TERMTYPE INTEGER,
4012
    LSID_AUTHORITY VARCHAR(255),
4013
    LSID_LSID VARCHAR(255),
4014
    LSID_NAMESPACE VARCHAR(255),
4015
    LSID_OBJECT VARCHAR(255),
4016
    LSID_REVISION VARCHAR(255),
4017
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
4018
    TITLECACHE VARCHAR(255),
4019
    URI CLOB,
4020
    TERMSOURCEURI CLOB,
4021
    CREATEDBY_ID INTEGER,
4022
    UPDATEDBY_ID INTEGER
4023
);
4024
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY;
4025
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_AUD(
4026
    DTYPE VARCHAR(31) NOT NULL,
4027
    ID INTEGER NOT NULL,
4028
    REV INTEGER NOT NULL,
4029
    REVTYPE TINYINT,
4030
    CREATED TIMESTAMP,
4031
    UUID VARCHAR(36),
4032
    UPDATED TIMESTAMP,
4033
    TERMTYPE INTEGER,
4034
    LSID_AUTHORITY VARCHAR(255),
4035
    LSID_LSID VARCHAR(255),
4036
    LSID_NAMESPACE VARCHAR(255),
4037
    LSID_OBJECT VARCHAR(255),
4038
    LSID_REVISION VARCHAR(255),
4039
    PROTECTEDTITLECACHE BOOLEAN,
4040
    TITLECACHE VARCHAR(255),
4041
    URI CLOB,
4042
    TERMSOURCEURI CLOB,
4043
    CREATEDBY_ID INTEGER,
4044
    UPDATEDBY_ID INTEGER
4045
);
4046
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_AUD;
4047
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ANNOTATION(
4048
    TERMVOCABULARY_ID INTEGER NOT NULL,
4049
    ANNOTATIONS_ID INTEGER NOT NULL
4050
);
4051
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ANNOTATION;
4052
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ANNOTATION_AUD(
4053
    REV INTEGER NOT NULL,
4054
    TERMVOCABULARY_ID INTEGER NOT NULL,
4055
    ANNOTATIONS_ID INTEGER NOT NULL,
4056
    REVTYPE TINYINT
4057
);
4058
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ANNOTATION_AUD;
4059
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_CREDIT(
4060
    TERMVOCABULARY_ID INTEGER NOT NULL,
4061
    CREDITS_ID INTEGER NOT NULL,
4062
    SORTINDEX INTEGER NOT NULL
4063
);
4064
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_CREDIT;
4065
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_CREDIT_AUD(
4066
    REV INTEGER NOT NULL,
4067
    TERMVOCABULARY_ID INTEGER NOT NULL,
4068
    CREDITS_ID INTEGER NOT NULL,
4069
    SORTINDEX INTEGER NOT NULL,
4070
    REVTYPE TINYINT
4071
);
4072
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_CREDIT_AUD;
4073
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_EXTENSION(
4074
    TERMVOCABULARY_ID INTEGER NOT NULL,
4075
    EXTENSIONS_ID INTEGER NOT NULL
4076
);
4077
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_EXTENSION;
4078
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_EXTENSION_AUD(
4079
    REV INTEGER NOT NULL,
4080
    TERMVOCABULARY_ID INTEGER NOT NULL,
4081
    EXTENSIONS_ID INTEGER NOT NULL,
4082
    REVTYPE TINYINT
4083
);
4084
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_EXTENSION_AUD;
4085
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_MARKER(
4086
    TERMVOCABULARY_ID INTEGER NOT NULL,
4087
    MARKERS_ID INTEGER NOT NULL
4088
);
4089
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_MARKER;
4090
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_MARKER_AUD(
4091
    REV INTEGER NOT NULL,
4092
    TERMVOCABULARY_ID INTEGER NOT NULL,
4093
    MARKERS_ID INTEGER NOT NULL,
4094
    REVTYPE TINYINT
4095
);
4096
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_MARKER_AUD;
4097
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE(
4098
    TERMVOCABULARY_ID INTEGER NOT NULL,
4099
    SOURCES_ID INTEGER NOT NULL
4100
);
4101
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE;
4102
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD(
4103
    REV INTEGER NOT NULL,
4104
    TERMVOCABULARY_ID INTEGER NOT NULL,
4105
    SOURCES_ID INTEGER NOT NULL,
4106
    REVTYPE TINYINT
4107
);
4108
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD;
4109
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION(
4110
    TERMVOCABULARY_ID INTEGER NOT NULL,
4111
    REPRESENTATIONS_ID INTEGER NOT NULL
4112
);
4113
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_REPRESENTATION;
4114
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD(
4115
    REV INTEGER NOT NULL,
4116
    TERMVOCABULARY_ID INTEGER NOT NULL,
4117
    REPRESENTATIONS_ID INTEGER NOT NULL,
4118
    REVTYPE TINYINT
4119
);
4120
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD;
4121
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_RIGHTS(
4122
    TERMVOCABULARY_ID INTEGER NOT NULL,
4123
    RIGHTS_ID INTEGER NOT NULL
4124
);
4125
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_RIGHTS;
4126
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_RIGHTS_AUD(
4127
    REV INTEGER NOT NULL,
4128
    TERMVOCABULARY_ID INTEGER NOT NULL,
4129
    RIGHTS_ID INTEGER NOT NULL,
4130
    REVTYPE TINYINT
4131
);
4132
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_RIGHTS_AUD;
4133
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE(
4134
    DTYPE VARCHAR(31) NOT NULL,
4135
    ID INTEGER NOT NULL,
4136
    CREATED TIMESTAMP,
4137
    UUID VARCHAR(36),
4138
    UPDATED TIMESTAMP,
4139
    CITATIONMICROREFERENCE VARCHAR(255),
4140
    ORIGINALNAMESTRING VARCHAR(255),
4141
    NOTDESIGNATED BOOLEAN NOT NULL,
4142
    CONSERVEDTYPE BOOLEAN,
4143
    REJECTEDTYPE BOOLEAN,
4144
    CREATEDBY_ID INTEGER,
4145
    UPDATEDBY_ID INTEGER,
4146
    CITATION_ID INTEGER,
4147
    TYPESTATUS_ID INTEGER,
4148
    TYPENAME_ID INTEGER,
4149
    TYPESPECIMEN_ID INTEGER
4150
);
4151
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE;
4152
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD(
4153
    DTYPE VARCHAR(31) NOT NULL,
4154
    ID INTEGER NOT NULL,
4155
    REV INTEGER NOT NULL,
4156
    REVTYPE TINYINT,
4157
    CREATED TIMESTAMP,
4158
    UUID VARCHAR(36),
4159
    UPDATED TIMESTAMP,
4160
    CITATIONMICROREFERENCE VARCHAR(255),
4161
    ORIGINALNAMESTRING VARCHAR(255),
4162
    NOTDESIGNATED BOOLEAN,
4163
    CREATEDBY_ID INTEGER,
4164
    UPDATEDBY_ID INTEGER,
4165
    CITATION_ID INTEGER,
4166
    TYPESTATUS_ID INTEGER,
4167
    CONSERVEDTYPE BOOLEAN,
4168
    REJECTEDTYPE BOOLEAN,
4169
    TYPENAME_ID INTEGER,
4170
    TYPESPECIMEN_ID INTEGER
4171
);
4172
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_AUD;
4173
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION(
4174
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4175
    ANNOTATIONS_ID INTEGER NOT NULL
4176
);
4177
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION;
4178
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION_AUD(
4179
    REV INTEGER NOT NULL,
4180
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4181
    ANNOTATIONS_ID INTEGER NOT NULL,
4182
    REVTYPE TINYINT
4183
);
4184
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION_AUD;
4185
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER(
4186
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4187
    MARKERS_ID INTEGER NOT NULL
4188
);
4189
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_MARKER;
4190
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD(
4191
    REV INTEGER NOT NULL,
4192
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4193
    MARKERS_ID INTEGER NOT NULL,
4194
    REVTYPE TINYINT
4195
);
4196
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD;
4197
CREATE CACHED TABLE PUBLIC.USERACCOUNT(
4198
    ID INTEGER NOT NULL,
4199
    CREATED TIMESTAMP,
4200
    UUID VARCHAR(36),
4201
    ACCOUNTNONEXPIRED BOOLEAN NOT NULL,
4202
    ACCOUNTNONLOCKED BOOLEAN NOT NULL,
4203
    CREDENTIALSNONEXPIRED BOOLEAN NOT NULL,
4204
    EMAILADDRESS VARCHAR(255),
4205
    ENABLED BOOLEAN NOT NULL,
4206
    PASSWORD VARCHAR(255),
4207
    USERNAME VARCHAR(255),
4208
    CREATEDBY_ID INTEGER,
4209
    PERSON_ID INTEGER
4210
);
4211
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT;
4212
CREATE CACHED TABLE PUBLIC.USERACCOUNT_AUD(
4213
    ID INTEGER NOT NULL,
4214
    REV INTEGER NOT NULL,
4215
    REVTYPE TINYINT,
4216
    CREATED TIMESTAMP,
4217
    UUID VARCHAR(36),
4218
    ACCOUNTNONEXPIRED BOOLEAN,
4219
    ACCOUNTNONLOCKED BOOLEAN,
4220
    CREDENTIALSNONEXPIRED BOOLEAN,
4221
    EMAILADDRESS VARCHAR(255),
4222
    ENABLED BOOLEAN,
4223
    USERNAME VARCHAR(255),
4224
    CREATEDBY_ID INTEGER,
4225
    PERSON_ID INTEGER
4226
);
4227
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_AUD;
4228
CREATE CACHED TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL(
4229
    USERACCOUNT_ID INTEGER NOT NULL,
4230
    GRANTEDAUTHORITIES_ID INTEGER NOT NULL
4231
);
4232
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL;
4233
CREATE CACHED TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP(
4234
    MEMBERS_ID INTEGER NOT NULL,
4235
    GROUPS_ID INTEGER NOT NULL
4236
);
4237
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_PERMISSIONGROUP;
4238
CREATE CACHED TABLE PUBLIC.WORKINGSET(
4239
    DTYPE VARCHAR(31) NOT NULL,
4240
    ID INTEGER NOT NULL,
4241
    CREATED TIMESTAMP,
4242
    UUID VARCHAR(36),
4243
    UPDATED TIMESTAMP,
4244
    CREATEDBY_ID INTEGER,
4245
    UPDATEDBY_ID INTEGER,
4246
    DESCRIPTIVESYSTEM_ID INTEGER
4247
);
4248
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET;
4249
CREATE CACHED TABLE PUBLIC.WORKINGSET_AUD(
4250
    DTYPE VARCHAR(31) NOT NULL,
4251
    ID INTEGER NOT NULL,
4252
    REV INTEGER NOT NULL,
4253
    REVTYPE TINYINT,
4254
    CREATED TIMESTAMP,
4255
    UUID VARCHAR(36),
4256
    UPDATED TIMESTAMP,
4257
    CREATEDBY_ID INTEGER,
4258
    UPDATEDBY_ID INTEGER,
4259
    DESCRIPTIVESYSTEM_ID INTEGER
4260
);
4261
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_AUD;
4262
CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION(
4263
    WORKINGSET_ID INTEGER NOT NULL,
4264
    ANNOTATIONS_ID INTEGER NOT NULL
4265
);
4266
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION;
4267
CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD(
4268
    REV INTEGER NOT NULL,
4269
    WORKINGSET_ID INTEGER NOT NULL,
4270
    ANNOTATIONS_ID INTEGER NOT NULL,
4271
    REVTYPE TINYINT
4272
);
4273
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION_AUD;
4274
CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE(
4275
    WORKINGSET_ID INTEGER NOT NULL,
4276
    DESCRIPTIONS_ID INTEGER NOT NULL
4277
);
4278
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_DESCRIPTIONBASE;
4279
CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD(
4280
    REV INTEGER NOT NULL,
4281
    WORKINGSET_ID INTEGER NOT NULL,
4282
    DESCRIPTIONS_ID INTEGER NOT NULL,
4283
    REVTYPE TINYINT
4284
);
4285
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD;
4286
CREATE CACHED TABLE PUBLIC.WORKINGSET_MARKER(
4287
    WORKINGSET_ID INTEGER NOT NULL,
4288
    MARKERS_ID INTEGER NOT NULL
4289
);
4290
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_MARKER;
4291
CREATE CACHED TABLE PUBLIC.WORKINGSET_MARKER_AUD(
4292
    REV INTEGER NOT NULL,
4293
    WORKINGSET_ID INTEGER NOT NULL,
4294
    MARKERS_ID INTEGER NOT NULL,
4295
    REVTYPE TINYINT
4296
);
4297
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_MARKER_AUD;
4298
CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION(
4299
    WORKINGSET_ID INTEGER NOT NULL,
4300
    REPRESENTATIONS_ID INTEGER NOT NULL
4301
);
4302
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_REPRESENTATION;
4303
CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION_AUD(
4304
    REV INTEGER NOT NULL,
4305
    WORKINGSET_ID INTEGER NOT NULL,
4306
    REPRESENTATIONS_ID INTEGER NOT NULL,
4307
    REVTYPE TINYINT
4308
);
4309
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_REPRESENTATION_AUD;
4310
CREATE CACHED TABLE PUBLIC.WORKINGSET_TAXONBASE(
4311
    WORKINGSET_ID INTEGER NOT NULL,
4312
    COVEREDTAXA_ID INTEGER NOT NULL
4313
);
4314
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_TAXONBASE;
4315
CREATE CACHED TABLE PUBLIC.WORKINGSET_TAXONBASE_AUD(
4316
    REV INTEGER NOT NULL,
431