Project

General

Profile

Statistics
| Branch: | Tag: | Revision:

cdmlib / cdmlib-persistence / src / test / resources / dbscripts / 001-cdm.h2.sql @ f6cb3385

History | View | Annotate | Download (350 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
    STARTNUMBER INTEGER,
2553
    CREATEDBY_ID INTEGER,
2554
    UPDATEDBY_ID INTEGER,
2555
    ROOT_ID INTEGER
2556
);
2557
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY;
2558
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE(
2559
    ID INTEGER NOT NULL,
2560
    CREATED TIMESTAMP,
2561
    UUID VARCHAR(36),
2562
    UPDATED TIMESTAMP,
2563
    NODENUMBER INTEGER,
2564
    SORTINDEX INTEGER,
2565
    CREATEDBY_ID INTEGER,
2566
    UPDATEDBY_ID INTEGER,
2567
    FEATURE_ID INTEGER,
2568
    KEY_ID INTEGER,
2569
    OTHERNODE_ID INTEGER,
2570
    PARENT_ID INTEGER,
2571
    QUESTION_ID INTEGER,
2572
    STATEMENT_ID INTEGER,
2573
    SUBKEY_ID INTEGER,
2574
    TAXON_ID INTEGER
2575
);
2576
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE;
2577
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_AUD(
2578
    ID INTEGER NOT NULL,
2579
    REV INTEGER NOT NULL,
2580
    REVTYPE TINYINT,
2581
    CREATED TIMESTAMP,
2582
    UUID VARCHAR(36),
2583
    UPDATED TIMESTAMP,
2584
    NODENUMBER INTEGER,
2585
    SORTINDEX INTEGER,
2586
    CREATEDBY_ID INTEGER,
2587
    UPDATEDBY_ID INTEGER,
2588
    FEATURE_ID INTEGER,
2589
    KEY_ID INTEGER,
2590
    OTHERNODE_ID INTEGER,
2591
    PARENT_ID INTEGER,
2592
    QUESTION_ID INTEGER,
2593
    STATEMENT_ID INTEGER,
2594
    SUBKEY_ID INTEGER,
2595
    TAXON_ID INTEGER
2596
);
2597
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_AUD;
2598
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING(
2599
    POLYTOMOUSKEYNODE_ID INTEGER NOT NULL,
2600
    MODIFYINGTEXT_ID INTEGER NOT NULL,
2601
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
2602
);
2603
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING;
2604
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD(
2605
    REV INTEGER NOT NULL,
2606
    POLYTOMOUSKEYNODE_ID INTEGER NOT NULL,
2607
    MODIFYINGTEXT_ID INTEGER NOT NULL,
2608
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
2609
    REVTYPE TINYINT
2610
);
2611
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD;
2612
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_AUD(
2613
    ID INTEGER NOT NULL,
2614
    REV INTEGER NOT NULL,
2615
    REVTYPE TINYINT,
2616
    CREATED TIMESTAMP,
2617
    UUID VARCHAR(36),
2618
    UPDATED TIMESTAMP,
2619
    LSID_AUTHORITY VARCHAR(255),
2620
    LSID_LSID VARCHAR(255),
2621
    LSID_NAMESPACE VARCHAR(255),
2622
    LSID_OBJECT VARCHAR(255),
2623
    LSID_REVISION VARCHAR(255),
2624
    PROTECTEDTITLECACHE BOOLEAN,
2625
    TITLECACHE VARCHAR(255),
2626
    STARTNUMBER INTEGER,
2627
    CREATEDBY_ID INTEGER,
2628
    UPDATEDBY_ID INTEGER,
2629
    ROOT_ID INTEGER
2630
);
2631
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_AUD;
2632
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION(
2633
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2634
    ANNOTATIONS_ID INTEGER NOT NULL
2635
);
2636
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ANNOTATION;
2637
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD(
2638
    REV INTEGER NOT NULL,
2639
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2640
    ANNOTATIONS_ID INTEGER NOT NULL,
2641
    REVTYPE TINYINT
2642
);
2643
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD;
2644
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_CREDIT(
2645
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2646
    CREDITS_ID INTEGER NOT NULL,
2647
    SORTINDEX INTEGER NOT NULL
2648
);
2649
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_CREDIT;
2650
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_CREDIT_AUD(
2651
    REV INTEGER NOT NULL,
2652
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2653
    CREDITS_ID INTEGER NOT NULL,
2654
    SORTINDEX INTEGER NOT NULL,
2655
    REVTYPE TINYINT
2656
);
2657
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_CREDIT_AUD;
2658
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION(
2659
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2660
    EXTENSIONS_ID INTEGER NOT NULL
2661
);
2662
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_EXTENSION;
2663
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD(
2664
    REV INTEGER NOT NULL,
2665
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2666
    EXTENSIONS_ID INTEGER NOT NULL,
2667
    REVTYPE TINYINT
2668
);
2669
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD;
2670
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_MARKER(
2671
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2672
    MARKERS_ID INTEGER NOT NULL
2673
);
2674
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_MARKER;
2675
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_MARKER_AUD(
2676
    REV INTEGER NOT NULL,
2677
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2678
    MARKERS_ID INTEGER NOT NULL,
2679
    REVTYPE TINYINT
2680
);
2681
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_MARKER_AUD;
2682
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA(
2683
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2684
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
2685
);
2686
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_NAMEDAREA;
2687
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD(
2688
    REV INTEGER NOT NULL,
2689
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2690
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
2691
    REVTYPE TINYINT
2692
);
2693
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD;
2694
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE(
2695
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2696
    SOURCES_ID INTEGER NOT NULL
2697
);
2698
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE;
2699
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD(
2700
    REV INTEGER NOT NULL,
2701
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2702
    SOURCES_ID INTEGER NOT NULL,
2703
    REVTYPE TINYINT
2704
);
2705
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD;
2706
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS(
2707
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2708
    RIGHTS_ID INTEGER NOT NULL
2709
);
2710
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_RIGHTS;
2711
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS_AUD(
2712
    REV INTEGER NOT NULL,
2713
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2714
    RIGHTS_ID INTEGER NOT NULL,
2715
    REVTYPE TINYINT
2716
);
2717
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_RIGHTS_AUD;
2718
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_SCOPE(
2719
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2720
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
2721
);
2722
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_SCOPE;
2723
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_SCOPE_AUD(
2724
    REV INTEGER NOT NULL,
2725
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2726
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
2727
    REVTYPE TINYINT
2728
);
2729
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_SCOPE_AUD;
2730
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXON(
2731
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2732
    TAXON_ID INTEGER NOT NULL
2733
);
2734
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXON;
2735
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE(
2736
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2737
    COVEREDTAXA_ID INTEGER NOT NULL
2738
);
2739
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXONBASE;
2740
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD(
2741
    REV INTEGER NOT NULL,
2742
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2743
    COVEREDTAXA_ID INTEGER NOT NULL,
2744
    REVTYPE TINYINT
2745
);
2746
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD;
2747
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXON_AUD(
2748
    REV INTEGER NOT NULL,
2749
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2750
    TAXON_ID INTEGER NOT NULL,
2751
    REVTYPE TINYINT
2752
);
2753
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXON_AUD;
2754
CREATE CACHED TABLE PUBLIC.REFERENCE(
2755
    DTYPE VARCHAR(31) NOT NULL,
2756
    ID INTEGER NOT NULL,
2757
    CREATED TIMESTAMP,
2758
    UUID VARCHAR(36),
2759
    UPDATED TIMESTAMP,
2760
    LSID_AUTHORITY VARCHAR(255),
2761
    LSID_LSID VARCHAR(255),
2762
    LSID_NAMESPACE VARCHAR(255),
2763
    LSID_OBJECT VARCHAR(255),
2764
    LSID_REVISION VARCHAR(255),
2765
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
2766
    TITLECACHE VARCHAR(255),
2767
    DATEPUBLISHED_END VARCHAR(255),
2768
    DATEPUBLISHED_FREETEXT VARCHAR(255),
2769
    DATEPUBLISHED_START VARCHAR(255),
2770
    EDITION VARCHAR(255),
2771
    EDITOR VARCHAR(255),
2772
    ISBN VARCHAR(255),
2773
    ISSN VARCHAR(255),
2774
    NOMENCLATURALLYRELEVANT BOOLEAN NOT NULL,
2775
    ORGANIZATION VARCHAR(255),
2776
    PAGES VARCHAR(255),
2777
    PARSINGPROBLEM INTEGER NOT NULL,
2778
    PLACEPUBLISHED VARCHAR(255),
2779
    PROBLEMENDS INTEGER NOT NULL,
2780
    PROBLEMSTARTS INTEGER NOT NULL,
2781
    PUBLISHER VARCHAR(255),
2782
    REFERENCEABSTRACT CLOB,
2783
    SERIES VARCHAR(255),
2784
    SERIESPART VARCHAR(255),
2785
    TITLE CLOB,
2786
    ABBREVTITLE VARCHAR(255),
2787
    ABBREVTITLECACHE CLOB,
2788
    PROTECTEDABBREVTITLECACHE BOOLEAN,
2789
    REFTYPE INTEGER,
2790
    URI CLOB,
2791
    VOLUME VARCHAR(255),
2792
    CREATEDBY_ID INTEGER,
2793
    UPDATEDBY_ID INTEGER,
2794
    AUTHORTEAM_ID INTEGER,
2795
    INREFERENCE_ID INTEGER,
2796
    INSTITUTION_ID INTEGER,
2797
    SCHOOL_ID INTEGER
2798
);
2799
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE;
2800
CREATE INDEX PUBLIC.REFERENCETITLECACHEINDEX ON PUBLIC.REFERENCE(TITLECACHE);
2801
CREATE CACHED TABLE PUBLIC.REFERENCE_AUD(
2802
    DTYPE VARCHAR(31) NOT NULL,
2803
    ID INTEGER NOT NULL,
2804
    REV INTEGER NOT NULL,
2805
    REVTYPE TINYINT,
2806
    CREATED TIMESTAMP,
2807
    UUID VARCHAR(36),
2808
    UPDATED TIMESTAMP,
2809
    LSID_AUTHORITY VARCHAR(255),
2810
    LSID_LSID VARCHAR(255),
2811
    LSID_NAMESPACE VARCHAR(255),
2812
    LSID_OBJECT VARCHAR(255),
2813
    LSID_REVISION VARCHAR(255),
2814
    PROTECTEDTITLECACHE BOOLEAN,
2815
    TITLECACHE VARCHAR(255),
2816
    DATEPUBLISHED_END VARCHAR(255),
2817
    DATEPUBLISHED_FREETEXT VARCHAR(255),
2818
    DATEPUBLISHED_START VARCHAR(255),
2819
    EDITION VARCHAR(255),
2820
    EDITOR VARCHAR(255),
2821
    ISBN VARCHAR(255),
2822
    ISSN VARCHAR(255),
2823
    NOMENCLATURALLYRELEVANT BOOLEAN,
2824
    ORGANIZATION VARCHAR(255),
2825
    PAGES VARCHAR(255),
2826
    PARSINGPROBLEM INTEGER,
2827
    PLACEPUBLISHED VARCHAR(255),
2828
    PROBLEMENDS INTEGER,
2829
    PROBLEMSTARTS INTEGER,
2830
    PUBLISHER VARCHAR(255),
2831
    REFERENCEABSTRACT CLOB,
2832
    SERIES VARCHAR(255),
2833
    SERIESPART VARCHAR(255),
2834
    TITLE CLOB,
2835
    ABBREVTITLE VARCHAR(255),
2836
    ABBREVTITLECACHE CLOB,
2837
    PROTECTEDABBREVTITLECACHE BOOLEAN,
2838
    REFTYPE INTEGER,
2839
    URI CLOB,
2840
    VOLUME VARCHAR(255),
2841
    CREATEDBY_ID INTEGER,
2842
    UPDATEDBY_ID INTEGER,
2843
    AUTHORTEAM_ID INTEGER,
2844
    INREFERENCE_ID INTEGER,
2845
    INSTITUTION_ID INTEGER,
2846
    SCHOOL_ID INTEGER
2847
);
2848
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_AUD;
2849
CREATE CACHED TABLE PUBLIC.REFERENCE_ANNOTATION(
2850
    REFERENCE_ID INTEGER NOT NULL,
2851
    ANNOTATIONS_ID INTEGER NOT NULL
2852
);
2853
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ANNOTATION;
2854
CREATE CACHED TABLE PUBLIC.REFERENCE_ANNOTATION_AUD(
2855
    REV INTEGER NOT NULL,
2856
    REFERENCE_ID INTEGER NOT NULL,
2857
    ANNOTATIONS_ID INTEGER NOT NULL,
2858
    REVTYPE TINYINT
2859
);
2860
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ANNOTATION_AUD;
2861
CREATE CACHED TABLE PUBLIC.REFERENCE_CREDIT(
2862
    REFERENCE_ID INTEGER NOT NULL,
2863
    CREDITS_ID INTEGER NOT NULL,
2864
    SORTINDEX INTEGER NOT NULL
2865
);
2866
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_CREDIT;
2867
CREATE CACHED TABLE PUBLIC.REFERENCE_CREDIT_AUD(
2868
    REV INTEGER NOT NULL,
2869
    REFERENCE_ID INTEGER NOT NULL,
2870
    CREDITS_ID INTEGER NOT NULL,
2871
    SORTINDEX INTEGER NOT NULL,
2872
    REVTYPE TINYINT
2873
);
2874
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_CREDIT_AUD;
2875
CREATE CACHED TABLE PUBLIC.REFERENCE_EXTENSION(
2876
    REFERENCE_ID INTEGER NOT NULL,
2877
    EXTENSIONS_ID INTEGER NOT NULL
2878
);
2879
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_EXTENSION;
2880
CREATE CACHED TABLE PUBLIC.REFERENCE_EXTENSION_AUD(
2881
    REV INTEGER NOT NULL,
2882
    REFERENCE_ID INTEGER NOT NULL,
2883
    EXTENSIONS_ID INTEGER NOT NULL,
2884
    REVTYPE TINYINT
2885
);
2886
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_EXTENSION_AUD;
2887
CREATE CACHED TABLE PUBLIC.REFERENCE_MARKER(
2888
    REFERENCE_ID INTEGER NOT NULL,
2889
    MARKERS_ID INTEGER NOT NULL
2890
);
2891
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MARKER;
2892
CREATE CACHED TABLE PUBLIC.REFERENCE_MARKER_AUD(
2893
    REV INTEGER NOT NULL,
2894
    REFERENCE_ID INTEGER NOT NULL,
2895
    MARKERS_ID INTEGER NOT NULL,
2896
    REVTYPE TINYINT
2897
);
2898
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MARKER_AUD;
2899
CREATE CACHED TABLE PUBLIC.REFERENCE_MEDIA(
2900
    REFERENCE_ID INTEGER NOT NULL,
2901
    MEDIA_ID INTEGER NOT NULL
2902
);
2903
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MEDIA;
2904
CREATE CACHED TABLE PUBLIC.REFERENCE_MEDIA_AUD(
2905
    REV INTEGER NOT NULL,
2906
    REFERENCE_ID INTEGER NOT NULL,
2907
    MEDIA_ID INTEGER NOT NULL,
2908
    REVTYPE TINYINT
2909
);
2910
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MEDIA_AUD;
2911
CREATE CACHED TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE(
2912
    REFERENCE_ID INTEGER NOT NULL,
2913
    SOURCES_ID INTEGER NOT NULL
2914
);
2915
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ORIGINALSOURCEBASE;
2916
CREATE CACHED TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD(
2917
    REV INTEGER NOT NULL,
2918
    REFERENCE_ID INTEGER NOT NULL,
2919
    SOURCES_ID INTEGER NOT NULL,
2920
    REVTYPE TINYINT
2921
);
2922
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD;
2923
CREATE CACHED TABLE PUBLIC.REFERENCE_RIGHTS(
2924
    REFERENCE_ID INTEGER NOT NULL,
2925
    RIGHTS_ID INTEGER NOT NULL
2926
);
2927
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTS;
2928
CREATE CACHED TABLE PUBLIC.REFERENCE_RIGHTS_AUD(
2929
    REV INTEGER NOT NULL,
2930
    REFERENCE_ID INTEGER NOT NULL,
2931
    RIGHTS_ID INTEGER NOT NULL,
2932
    REVTYPE TINYINT
2933
);
2934
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTS_AUD;
2935
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION(
2936
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
2937
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL
2938
);
2939
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION;
2940
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD(
2941
    REV INTEGER NOT NULL,
2942
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
2943
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL,
2944
    REVTYPE TINYINT
2945
);
2946
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD;
2947
CREATE CACHED TABLE PUBLIC.REPRESENTATION(
2948
    ID INTEGER NOT NULL,
2949
    CREATED TIMESTAMP,
2950
    UUID VARCHAR(36),
2951
    UPDATED TIMESTAMP,
2952
    TEXT CLOB,
2953
    ABBREVIATEDLABEL VARCHAR(255),
2954
    LABEL VARCHAR(255),
2955
    CREATEDBY_ID INTEGER,
2956
    UPDATEDBY_ID INTEGER,
2957
    LANGUAGE_ID INTEGER
2958
);
2959
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION;
2960
CREATE CACHED TABLE PUBLIC.REPRESENTATION_AUD(
2961
    ID INTEGER NOT NULL,
2962
    REV INTEGER NOT NULL,
2963
    REVTYPE TINYINT,
2964
    CREATED TIMESTAMP,
2965
    UUID VARCHAR(36),
2966
    UPDATED TIMESTAMP,
2967
    TEXT CLOB,
2968
    ABBREVIATEDLABEL VARCHAR(255),
2969
    LABEL VARCHAR(255),
2970
    CREATEDBY_ID INTEGER,
2971
    UPDATEDBY_ID INTEGER,
2972
    LANGUAGE_ID INTEGER
2973
);
2974
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_AUD;
2975
CREATE CACHED TABLE PUBLIC.REPRESENTATION_ANNOTATION(
2976
    REPRESENTATION_ID INTEGER NOT NULL,
2977
    ANNOTATIONS_ID INTEGER NOT NULL
2978
);
2979
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION;
2980
CREATE CACHED TABLE PUBLIC.REPRESENTATION_ANNOTATION_AUD(
2981
    REV INTEGER NOT NULL,
2982
    REPRESENTATION_ID INTEGER NOT NULL,
2983
    ANNOTATIONS_ID INTEGER NOT NULL,
2984
    REVTYPE TINYINT
2985
);
2986
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION_AUD;
2987
CREATE CACHED TABLE PUBLIC.REPRESENTATION_MARKER(
2988
    REPRESENTATION_ID INTEGER NOT NULL,
2989
    MARKERS_ID INTEGER NOT NULL
2990
);
2991
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_MARKER;
2992
CREATE CACHED TABLE PUBLIC.REPRESENTATION_MARKER_AUD(
2993
    REV INTEGER NOT NULL,
2994
    REPRESENTATION_ID INTEGER NOT NULL,
2995
    MARKERS_ID INTEGER NOT NULL,
2996
    REVTYPE TINYINT
2997
);
2998
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_MARKER_AUD;
2999
CREATE CACHED TABLE PUBLIC.RIGHTS(
3000
    ID INTEGER NOT NULL,
3001
    CREATED TIMESTAMP,
3002
    UUID VARCHAR(36),
3003
    UPDATED TIMESTAMP,
3004
    TEXT CLOB,
3005
    ABBREVIATEDTEXT VARCHAR(255),
3006
    URI CLOB,
3007
    CREATEDBY_ID INTEGER,
3008
    UPDATEDBY_ID INTEGER,
3009
    LANGUAGE_ID INTEGER,
3010
    AGENT_ID INTEGER,
3011
    TYPE_ID INTEGER
3012
);
3013
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS;
3014
CREATE CACHED TABLE PUBLIC.RIGHTS_AUD(
3015
    ID INTEGER NOT NULL,
3016
    REV INTEGER NOT NULL,
3017
    REVTYPE TINYINT,
3018
    CREATED TIMESTAMP,
3019
    UUID VARCHAR(36),
3020
    UPDATED TIMESTAMP,
3021
    TEXT CLOB,
3022
    ABBREVIATEDTEXT VARCHAR(255),
3023
    URI CLOB,
3024
    CREATEDBY_ID INTEGER,
3025
    UPDATEDBY_ID INTEGER,
3026
    LANGUAGE_ID INTEGER,
3027
    AGENT_ID INTEGER,
3028
    TYPE_ID INTEGER
3029
);
3030
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_AUD;
3031
CREATE CACHED TABLE PUBLIC.RIGHTS_ANNOTATION(
3032
    RIGHTS_ID INTEGER NOT NULL,
3033
    ANNOTATIONS_ID INTEGER NOT NULL
3034
);
3035
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_ANNOTATION;
3036
CREATE CACHED TABLE PUBLIC.RIGHTS_ANNOTATION_AUD(
3037
    REV INTEGER NOT NULL,
3038
    RIGHTS_ID INTEGER NOT NULL,
3039
    ANNOTATIONS_ID INTEGER NOT NULL,
3040
    REVTYPE TINYINT
3041
);
3042
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_ANNOTATION_AUD;
3043
CREATE CACHED TABLE PUBLIC.RIGHTS_MARKER(
3044
    RIGHTS_ID INTEGER NOT NULL,
3045
    MARKERS_ID INTEGER NOT NULL
3046
);
3047
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_MARKER;
3048
CREATE CACHED TABLE PUBLIC.RIGHTS_MARKER_AUD(
3049
    REV INTEGER NOT NULL,
3050
    RIGHTS_ID INTEGER NOT NULL,
3051
    MARKERS_ID INTEGER NOT NULL,
3052
    REVTYPE TINYINT
3053
);
3054
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_MARKER_AUD;
3055
CREATE CACHED TABLE PUBLIC.SEQUENCE(
3056
    ID INTEGER NOT NULL,
3057
    CREATED TIMESTAMP,
3058
    UUID VARCHAR(36),
3059
    UPDATED TIMESTAMP,
3060
    LSID_AUTHORITY VARCHAR(255),
3061
    LSID_LSID VARCHAR(255),
3062
    LSID_NAMESPACE VARCHAR(255),
3063
    LSID_OBJECT VARCHAR(255),
3064
    LSID_REVISION VARCHAR(255),
3065
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3066
    TITLECACHE VARCHAR(255),
3067
    BARCODE BOOLEAN NOT NULL,
3068
    GENBANKACCESSIONNUMBER VARCHAR(20),
3069
    GENBANKURI CLOB,
3070
    CITATIONMICROREFERENCE VARCHAR(255),
3071
    DATESEQUENCED TIMESTAMP,
3072
    LENGTH INTEGER,
3073
    SEQUENCE CLOB,
3074
    CREATEDBY_ID INTEGER,
3075
    UPDATEDBY_ID INTEGER,
3076
    LOCUS_ID INTEGER,
3077
    PUBLISHEDIN_ID INTEGER
3078
);
3079
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE;
3080
CREATE INDEX PUBLIC.SEQUENCETITLECACHEINDEX ON PUBLIC.SEQUENCE(TITLECACHE);
3081
CREATE CACHED TABLE PUBLIC.SEQUENCE_AUD(
3082
    ID INTEGER NOT NULL,
3083
    REV INTEGER NOT NULL,
3084
    REVTYPE TINYINT,
3085
    CREATED TIMESTAMP,
3086
    UUID VARCHAR(36),
3087
    UPDATED TIMESTAMP,
3088
    LSID_AUTHORITY VARCHAR(255),
3089
    LSID_LSID VARCHAR(255),
3090
    LSID_NAMESPACE VARCHAR(255),
3091
    LSID_OBJECT VARCHAR(255),
3092
    LSID_REVISION VARCHAR(255),
3093
    PROTECTEDTITLECACHE BOOLEAN,
3094
    TITLECACHE VARCHAR(255),
3095
    BARCODE BOOLEAN,
3096
    GENBANKACCESSIONNUMBER VARCHAR(20),
3097
    GENBANKURI CLOB,
3098
    CITATIONMICROREFERENCE VARCHAR(255),
3099
    DATESEQUENCED TIMESTAMP,
3100
    LENGTH INTEGER,
3101
    SEQUENCE CLOB,
3102
    CREATEDBY_ID INTEGER,
3103
    UPDATEDBY_ID INTEGER,
3104
    LOCUS_ID INTEGER,
3105
    PUBLISHEDIN_ID INTEGER
3106
);
3107
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_AUD;
3108
CREATE CACHED TABLE PUBLIC.SEQUENCE_ANNOTATION(
3109
    SEQUENCE_ID INTEGER NOT NULL,
3110
    ANNOTATIONS_ID INTEGER NOT NULL
3111
);
3112
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ANNOTATION;
3113
CREATE CACHED TABLE PUBLIC.SEQUENCE_ANNOTATION_AUD(
3114
    REV INTEGER NOT NULL,
3115
    SEQUENCE_ID INTEGER NOT NULL,
3116
    ANNOTATIONS_ID INTEGER NOT NULL,
3117
    REVTYPE TINYINT
3118
);
3119
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ANNOTATION_AUD;
3120
CREATE CACHED TABLE PUBLIC.SEQUENCE_CREDIT(
3121
    SEQUENCE_ID INTEGER NOT NULL,
3122
    CREDITS_ID INTEGER NOT NULL,
3123
    SORTINDEX INTEGER NOT NULL
3124
);
3125
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_CREDIT;
3126
CREATE CACHED TABLE PUBLIC.SEQUENCE_CREDIT_AUD(
3127
    REV INTEGER NOT NULL,
3128
    SEQUENCE_ID INTEGER NOT NULL,
3129
    CREDITS_ID INTEGER NOT NULL,
3130
    SORTINDEX INTEGER NOT NULL,
3131
    REVTYPE TINYINT
3132
);
3133
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_CREDIT_AUD;
3134
CREATE CACHED TABLE PUBLIC.SEQUENCE_EXTENSION(
3135
    SEQUENCE_ID INTEGER NOT NULL,
3136
    EXTENSIONS_ID INTEGER NOT NULL
3137
);
3138
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION;
3139
CREATE CACHED TABLE PUBLIC.SEQUENCE_EXTENSION_AUD(
3140
    REV INTEGER NOT NULL,
3141
    SEQUENCE_ID INTEGER NOT NULL,
3142
    EXTENSIONS_ID INTEGER NOT NULL,
3143
    REVTYPE TINYINT
3144
);
3145
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION_AUD;
3146
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER(
3147
    SEQUENCE_ID INTEGER NOT NULL,
3148
    MARKERS_ID INTEGER NOT NULL
3149
);
3150
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MARKER;
3151
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER_AUD(
3152
    REV INTEGER NOT NULL,
3153
    SEQUENCE_ID INTEGER NOT NULL,
3154
    MARKERS_ID INTEGER NOT NULL,
3155
    REVTYPE TINYINT
3156
);
3157
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MARKER_AUD;
3158
CREATE CACHED TABLE PUBLIC.SEQUENCE_MEDIA(
3159
    SEQUENCE_ID INTEGER NOT NULL,
3160
    CHROMATOGRAMS_ID INTEGER NOT NULL
3161
);
3162
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MEDIA;
3163
CREATE CACHED TABLE PUBLIC.SEQUENCE_MEDIA_AUD(
3164
    REV INTEGER NOT NULL,
3165
    SEQUENCE_ID INTEGER NOT NULL,
3166
    CHROMATOGRAMS_ID INTEGER NOT NULL,
3167
    REVTYPE TINYINT
3168
);
3169
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MEDIA_AUD;
3170
CREATE CACHED TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE(
3171
    SEQUENCE_ID INTEGER NOT NULL,
3172
    SOURCES_ID INTEGER NOT NULL
3173
);
3174
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ORIGINALSOURCEBASE;
3175
CREATE CACHED TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD(
3176
    REV INTEGER NOT NULL,
3177
    SEQUENCE_ID INTEGER NOT NULL,
3178
    SOURCES_ID INTEGER NOT NULL,
3179
    REVTYPE TINYINT
3180
);
3181
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD;
3182
CREATE CACHED TABLE PUBLIC.SEQUENCE_REFERENCE(
3183
    SEQUENCE_ID INTEGER NOT NULL,
3184
    CITATIONS_ID INTEGER NOT NULL
3185
);
3186
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_REFERENCE;
3187
CREATE CACHED TABLE PUBLIC.SEQUENCE_REFERENCE_AUD(
3188
    REV INTEGER NOT NULL,
3189
    SEQUENCE_ID INTEGER NOT NULL,
3190
    CITATIONS_ID INTEGER NOT NULL,
3191
    REVTYPE TINYINT
3192
);
3193
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_REFERENCE_AUD;
3194
CREATE CACHED TABLE PUBLIC.SEQUENCE_RIGHTS(
3195
    SEQUENCE_ID INTEGER NOT NULL,
3196
    RIGHTS_ID INTEGER NOT NULL
3197
);
3198
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_RIGHTS;
3199
CREATE CACHED TABLE PUBLIC.SEQUENCE_RIGHTS_AUD(
3200
    REV INTEGER NOT NULL,
3201
    SEQUENCE_ID INTEGER NOT NULL,
3202
    RIGHTS_ID INTEGER NOT NULL,
3203
    REVTYPE TINYINT
3204
);
3205
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_RIGHTS_AUD;
3206
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE(
3207
    DTYPE VARCHAR(31) NOT NULL,
3208
    ID INTEGER NOT NULL,
3209
    CREATED TIMESTAMP,
3210
    UUID VARCHAR(36),
3211
    UPDATED TIMESTAMP,
3212
    LSID_AUTHORITY VARCHAR(255),
3213
    LSID_LSID VARCHAR(255),
3214
    LSID_NAMESPACE VARCHAR(255),
3215
    LSID_OBJECT VARCHAR(255),
3216
    LSID_REVISION VARCHAR(255),
3217
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3218
    TITLECACHE VARCHAR(255),
3219
    PUBLISH BOOLEAN,
3220
    INDIVIDUALCOUNT INTEGER,
3221
    ACCESSIONNUMBER VARCHAR(255),
3222
    BARCODE VARCHAR(255),
3223
    CATALOGNUMBER VARCHAR(255),
3224
    COLLECTORSNUMBER VARCHAR(255),
3225
    EXSICCATUM VARCHAR(255),
3226
    FIELDNOTES VARCHAR(255),
3227
    FIELDNUMBER VARCHAR(255),
3228
    CREATEDBY_ID INTEGER,
3229
    UPDATEDBY_ID INTEGER,
3230
    LIFESTAGE_ID INTEGER,
3231
    SEX_ID INTEGER,
3232
    COLLECTION_ID INTEGER,
3233
    DERIVEDFROM_ID INTEGER,
3234
    STOREDUNDER_ID INTEGER,
3235
    PRESERVATION_ID INTEGER,
3236
    GATHERINGEVENT_ID INTEGER,
3237
    PRIMARYCOLLECTOR_ID INTEGER
3238
);
3239
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE;
3240
CREATE INDEX PUBLIC.SPECIMENOROBSERVATIONBASETITLECACHEINDEX ON PUBLIC.SPECIMENOROBSERVATIONBASE(TITLECACHE);
3241
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD(
3242
    DTYPE VARCHAR(31) NOT NULL,
3243
    ID INTEGER NOT NULL,
3244
    REV INTEGER NOT NULL,
3245
    REVTYPE TINYINT,
3246
    CREATED TIMESTAMP,
3247
    UUID VARCHAR(36),
3248
    UPDATED TIMESTAMP,
3249
    LSID_AUTHORITY VARCHAR(255),
3250
    LSID_LSID VARCHAR(255),
3251
    LSID_NAMESPACE VARCHAR(255),
3252
    LSID_OBJECT VARCHAR(255),
3253
    LSID_REVISION VARCHAR(255),
3254
    PROTECTEDTITLECACHE BOOLEAN,
3255
    TITLECACHE VARCHAR(255),
3256
    PUBLISH BOOLEAN,
3257
    INDIVIDUALCOUNT INTEGER,
3258
    CREATEDBY_ID INTEGER,
3259
    UPDATEDBY_ID INTEGER,
3260
    LIFESTAGE_ID INTEGER,
3261
    SEX_ID INTEGER,
3262
    ACCESSIONNUMBER VARCHAR(255),
3263
    BARCODE VARCHAR(255),
3264
    CATALOGNUMBER VARCHAR(255),
3265
    COLLECTORSNUMBER VARCHAR(255),
3266
    COLLECTION_ID INTEGER,
3267
    DERIVEDFROM_ID INTEGER,
3268
    STOREDUNDER_ID INTEGER,
3269
    EXSICCATUM VARCHAR(255),
3270
    PRESERVATION_ID INTEGER,
3271
    FIELDNOTES VARCHAR(255),
3272
    FIELDNUMBER VARCHAR(255),
3273
    GATHERINGEVENT_ID INTEGER,
3274
    PRIMARYCOLLECTOR_ID INTEGER
3275
);
3276
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_AUD;
3277
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION(
3278
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3279
    ANNOTATIONS_ID INTEGER NOT NULL
3280
);
3281
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION;
3282
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD(
3283
    REV INTEGER NOT NULL,
3284
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3285
    ANNOTATIONS_ID INTEGER NOT NULL,
3286
    REVTYPE TINYINT
3287
);
3288
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD;
3289
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT(
3290
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3291
    CREDITS_ID INTEGER NOT NULL,
3292
    SORTINDEX INTEGER NOT NULL
3293
);
3294
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT;
3295
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD(
3296
    REV INTEGER NOT NULL,
3297
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3298
    CREDITS_ID INTEGER NOT NULL,
3299
    SORTINDEX INTEGER NOT NULL,
3300
    REVTYPE TINYINT
3301
);
3302
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD;
3303
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT(
3304
    ORIGINALS_ID INTEGER NOT NULL,
3305
    DERIVATIONEVENTS_ID INTEGER NOT NULL
3306
);
3307
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT;
3308
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD(
3309
    REV INTEGER NOT NULL,
3310
    ORIGINALS_ID INTEGER NOT NULL,
3311
    DERIVATIONEVENTS_ID INTEGER NOT NULL,
3312
    REVTYPE TINYINT
3313
);
3314
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD;
3315
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION(
3316
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3317
    EXTENSIONS_ID INTEGER NOT NULL
3318
);
3319
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION;
3320
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD(
3321
    REV INTEGER NOT NULL,
3322
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3323
    EXTENSIONS_ID INTEGER NOT NULL,
3324
    REVTYPE TINYINT
3325
);
3326
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD;
3327
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING(
3328
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3329
    DEFINITION_ID INTEGER NOT NULL,
3330
    DEFINITION_MAPKEY_ID INTEGER NOT NULL
3331
);
3332
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING;
3333
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD(
3334
    REV INTEGER NOT NULL,
3335
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3336
    DEFINITION_ID INTEGER NOT NULL,
3337
    DEFINITION_MAPKEY_ID INTEGER NOT NULL,
3338
    REVTYPE TINYINT
3339
);
3340
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD;
3341
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER(
3342
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3343
    MARKERS_ID INTEGER NOT NULL
3344
);
3345
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER;
3346
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD(
3347
    REV INTEGER NOT NULL,
3348
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3349
    MARKERS_ID INTEGER NOT NULL,
3350
    REVTYPE TINYINT
3351
);
3352
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD;
3353
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA(
3354
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3355
    MEDIA_ID INTEGER NOT NULL
3356
);
3357
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA;
3358
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD(
3359
    REV INTEGER NOT NULL,
3360
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3361
    MEDIA_ID INTEGER NOT NULL,
3362
    REVTYPE TINYINT
3363
);
3364
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD;
3365
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE(
3366
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3367
    SOURCES_ID INTEGER NOT NULL
3368
);
3369
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE;
3370
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD(
3371
    REV INTEGER NOT NULL,
3372
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3373
    SOURCES_ID INTEGER NOT NULL,
3374
    REVTYPE TINYINT
3375
);
3376
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD;
3377
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS(
3378
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3379
    RIGHTS_ID INTEGER NOT NULL
3380
);
3381
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS;
3382
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD(
3383
    REV INTEGER NOT NULL,
3384
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3385
    RIGHTS_ID INTEGER NOT NULL,
3386
    REVTYPE TINYINT
3387
);
3388
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD;
3389
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE(
3390
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3391
    SEQUENCES_ID INTEGER NOT NULL
3392
);
3393
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE;
3394
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD(
3395
    REV INTEGER NOT NULL,
3396
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3397
    SEQUENCES_ID INTEGER NOT NULL,
3398
    REVTYPE TINYINT
3399
);
3400
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD;
3401
CREATE CACHED TABLE PUBLIC.STATEDATA(
3402
    ID INTEGER NOT NULL,
3403
    CREATED TIMESTAMP,
3404
    UUID VARCHAR(36),
3405
    UPDATED TIMESTAMP,
3406
    CREATEDBY_ID INTEGER,
3407
    UPDATEDBY_ID INTEGER,
3408
    STATE_ID INTEGER
3409
);
3410
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA;
3411
CREATE CACHED TABLE PUBLIC.STATEDATA_AUD(
3412
    ID INTEGER NOT NULL,
3413
    REV INTEGER NOT NULL,
3414
    REVTYPE TINYINT,
3415
    CREATED TIMESTAMP,
3416
    UUID VARCHAR(36),
3417
    UPDATED TIMESTAMP,
3418
    CREATEDBY_ID INTEGER,
3419
    UPDATEDBY_ID INTEGER,
3420
    STATE_ID INTEGER
3421
);
3422
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_AUD;
3423
CREATE CACHED TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE(
3424
    STATEDATA_ID INTEGER NOT NULL,
3425
    MODIFIERS_ID INTEGER NOT NULL
3426
);
3427
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_DEFINEDTERMBASE;
3428
CREATE CACHED TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD(
3429
    REV INTEGER NOT NULL,
3430
    STATEDATA_ID INTEGER NOT NULL,
3431
    MODIFIERS_ID INTEGER NOT NULL,
3432
    REVTYPE TINYINT
3433
);
3434
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD;
3435
CREATE CACHED TABLE PUBLIC.STATEDATA_LANGUAGESTRING(
3436
    STATEDATA_ID INTEGER NOT NULL,
3437
    MODIFYINGTEXT_ID INTEGER NOT NULL,
3438
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
3439
);
3440
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_LANGUAGESTRING;
3441
CREATE CACHED TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD(
3442
    REV INTEGER NOT NULL,
3443
    STATEDATA_ID INTEGER NOT NULL,
3444
    MODIFYINGTEXT_ID INTEGER NOT NULL,
3445
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
3446
    REVTYPE TINYINT
3447
);
3448
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_LANGUAGESTRING_AUD;
3449
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE(
3450
    ID INTEGER NOT NULL,
3451
    CREATED TIMESTAMP,
3452
    UUID VARCHAR(36),
3453
    UPDATED TIMESTAMP,
3454
    VALUE DOUBLE NOT NULL,
3455
    CREATEDBY_ID INTEGER,
3456
    UPDATEDBY_ID INTEGER,
3457
    TYPE_ID INTEGER
3458
);
3459
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE;
3460
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD(
3461
    ID INTEGER NOT NULL,
3462
    REV INTEGER NOT NULL,
3463
    REVTYPE TINYINT,
3464
    CREATED TIMESTAMP,
3465
    UUID VARCHAR(36),
3466
    UPDATED TIMESTAMP,
3467
    VALUE DOUBLE,
3468
    CREATEDBY_ID INTEGER,
3469
    UPDATEDBY_ID INTEGER,
3470
    TYPE_ID INTEGER
3471
);
3472
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_AUD;
3473
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE(
3474
    STATISTICALMEASUREMENTVALUE_ID INTEGER NOT NULL,
3475
    MODIFIERS_ID INTEGER NOT NULL
3476
);
3477
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE;
3478
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD(
3479
    REV INTEGER NOT NULL,
3480
    STATISTICALMEASUREMENTVALUE_ID INTEGER NOT NULL,
3481
    MODIFIERS_ID INTEGER NOT NULL,
3482
    REVTYPE TINYINT
3483
);
3484
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD;
3485
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP(
3486
    ID INTEGER NOT NULL,
3487
    CREATED TIMESTAMP,
3488
    UUID VARCHAR(36),
3489
    UPDATED TIMESTAMP,
3490
    CITATIONMICROREFERENCE VARCHAR(255),
3491
    ORIGINALNAMESTRING VARCHAR(255),
3492
    DOUBTFUL BOOLEAN NOT NULL,
3493
    PARTIAL BOOLEAN NOT NULL,
3494
    PROPARTE BOOLEAN NOT NULL,
3495
    CREATEDBY_ID INTEGER,
3496
    UPDATEDBY_ID INTEGER,
3497
    CITATION_ID INTEGER,
3498
    RELATEDFROM_ID INTEGER,
3499
    RELATEDTO_ID INTEGER,
3500
    TYPE_ID INTEGER
3501
);
3502
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP;
3503
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_AUD(
3504
    ID INTEGER NOT NULL,
3505
    REV INTEGER NOT NULL,
3506
    REVTYPE TINYINT,
3507
    CREATED TIMESTAMP,
3508
    UUID VARCHAR(36),
3509
    UPDATED TIMESTAMP,
3510
    CITATIONMICROREFERENCE VARCHAR(255),
3511
    ORIGINALNAMESTRING VARCHAR(255),
3512
    DOUBTFUL BOOLEAN,
3513
    PARTIAL BOOLEAN,
3514
    PROPARTE BOOLEAN,
3515
    CREATEDBY_ID INTEGER,
3516
    UPDATEDBY_ID INTEGER,
3517
    CITATION_ID INTEGER,
3518
    RELATEDFROM_ID INTEGER,
3519
    RELATEDTO_ID INTEGER,
3520
    TYPE_ID INTEGER
3521
);
3522
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_AUD;
3523
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION(
3524
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3525
    ANNOTATIONS_ID INTEGER NOT NULL
3526
);
3527
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION;
3528
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION_AUD(
3529
    REV INTEGER NOT NULL,
3530
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3531
    ANNOTATIONS_ID INTEGER NOT NULL,
3532
    REVTYPE TINYINT
3533
);
3534
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION_AUD;
3535
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER(
3536
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3537
    MARKERS_ID INTEGER NOT NULL
3538
);
3539
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_MARKER;
3540
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER_AUD(
3541
    REV INTEGER NOT NULL,
3542
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3543
    MARKERS_ID INTEGER NOT NULL,
3544
    REVTYPE TINYINT
3545
);
3546
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_MARKER_AUD;
3547
CREATE CACHED TABLE PUBLIC.TAXONBASE(
3548
    DTYPE VARCHAR(31) NOT NULL,
3549
    ID INTEGER NOT NULL,
3550
    CREATED TIMESTAMP,
3551
    UUID VARCHAR(36),
3552
    UPDATED TIMESTAMP,
3553
    LSID_AUTHORITY VARCHAR(255),
3554
    LSID_LSID VARCHAR(255),
3555
    LSID_NAMESPACE VARCHAR(255),
3556
    LSID_OBJECT VARCHAR(255),
3557
    LSID_REVISION VARCHAR(255),
3558
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3559
    TITLECACHE VARCHAR(255),
3560
    APPENDEDPHRASE VARCHAR(255),
3561
    DOUBTFUL BOOLEAN NOT NULL,
3562
    PUBLISH BOOLEAN,
3563
    USENAMECACHE BOOLEAN NOT NULL,
3564
    EXCLUDED BOOLEAN,
3565
    TAXONSTATUSUNKNOWN BOOLEAN,
3566
    TAXONOMICCHILDRENCOUNT INTEGER,
3567
    UNPLACED BOOLEAN,
3568
    CREATEDBY_ID INTEGER,
3569
    UPDATEDBY_ID INTEGER,
3570
    NAME_ID INTEGER,
3571
    SEC_ID INTEGER,
3572
    TAXONOMICPARENTCACHE_ID INTEGER
3573
);
3574
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE;
3575
CREATE INDEX PUBLIC.TAXONBASETITLECACHEINDEX ON PUBLIC.TAXONBASE(TITLECACHE);
3576
CREATE CACHED TABLE PUBLIC.TAXONBASE_AUD(
3577
    DTYPE VARCHAR(31) NOT NULL,
3578
    ID INTEGER NOT NULL,
3579
    REV INTEGER NOT NULL,
3580
    REVTYPE TINYINT,
3581
    CREATED TIMESTAMP,
3582
    UUID VARCHAR(36),
3583
    UPDATED TIMESTAMP,
3584
    LSID_AUTHORITY VARCHAR(255),
3585
    LSID_LSID VARCHAR(255),
3586
    LSID_NAMESPACE VARCHAR(255),
3587
    LSID_OBJECT VARCHAR(255),
3588
    LSID_REVISION VARCHAR(255),
3589
    PROTECTEDTITLECACHE BOOLEAN,
3590
    TITLECACHE VARCHAR(255),
3591
    APPENDEDPHRASE VARCHAR(255),
3592
    DOUBTFUL BOOLEAN,
3593
    PUBLISH BOOLEAN,
3594
    USENAMECACHE BOOLEAN,
3595
    CREATEDBY_ID INTEGER,
3596
    UPDATEDBY_ID INTEGER,
3597
    NAME_ID INTEGER,
3598
    SEC_ID INTEGER,
3599
    EXCLUDED BOOLEAN,
3600
    TAXONSTATUSUNKNOWN BOOLEAN,
3601
    TAXONOMICCHILDRENCOUNT INTEGER,
3602
    UNPLACED BOOLEAN,
3603
    TAXONOMICPARENTCACHE_ID INTEGER
3604
);
3605
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_AUD;
3606
CREATE CACHED TABLE PUBLIC.TAXONBASE_ANNOTATION(
3607
    TAXONBASE_ID INTEGER NOT NULL,
3608
    ANNOTATIONS_ID INTEGER NOT NULL
3609
);
3610
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ANNOTATION;
3611
CREATE CACHED TABLE PUBLIC.TAXONBASE_ANNOTATION_AUD(
3612
    REV INTEGER NOT NULL,
3613
    TAXONBASE_ID INTEGER NOT NULL,
3614
    ANNOTATIONS_ID INTEGER NOT NULL,
3615
    REVTYPE TINYINT
3616
);
3617
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ANNOTATION_AUD;
3618
CREATE CACHED TABLE PUBLIC.TAXONBASE_CREDIT(
3619
    TAXONBASE_ID INTEGER NOT NULL,
3620
    CREDITS_ID INTEGER NOT NULL,
3621
    SORTINDEX INTEGER NOT NULL
3622
);
3623
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_CREDIT;
3624
CREATE CACHED TABLE PUBLIC.TAXONBASE_CREDIT_AUD(
3625
    REV INTEGER NOT NULL,
3626
    TAXONBASE_ID INTEGER NOT NULL,
3627
    CREDITS_ID INTEGER NOT NULL,
3628
    SORTINDEX INTEGER NOT NULL,
3629
    REVTYPE TINYINT
3630
);
3631
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_CREDIT_AUD;
3632
CREATE CACHED TABLE PUBLIC.TAXONBASE_EXTENSION(
3633
    TAXONBASE_ID INTEGER NOT NULL,
3634
    EXTENSIONS_ID INTEGER NOT NULL
3635
);
3636
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_EXTENSION;
3637
CREATE CACHED TABLE PUBLIC.TAXONBASE_EXTENSION_AUD(
3638
    REV INTEGER NOT NULL,
3639
    TAXONBASE_ID INTEGER NOT NULL,
3640
    EXTENSIONS_ID INTEGER NOT NULL,
3641
    REVTYPE TINYINT
3642
);
3643
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_EXTENSION_AUD;
3644
CREATE CACHED TABLE PUBLIC.TAXONBASE_MARKER(
3645
    TAXONBASE_ID INTEGER NOT NULL,
3646
    MARKERS_ID INTEGER NOT NULL
3647
);
3648
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_MARKER;
3649
CREATE CACHED TABLE PUBLIC.TAXONBASE_MARKER_AUD(
3650
    REV INTEGER NOT NULL,
3651
    TAXONBASE_ID INTEGER NOT NULL,
3652
    MARKERS_ID INTEGER NOT NULL,
3653
    REVTYPE TINYINT
3654
);
3655
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_MARKER_AUD;
3656
CREATE CACHED TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE(
3657
    TAXONBASE_ID INTEGER NOT NULL,
3658
    SOURCES_ID INTEGER NOT NULL
3659
);
3660
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ORIGINALSOURCEBASE;
3661
CREATE CACHED TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE_AUD(
3662
    REV INTEGER NOT NULL,
3663
    TAXONBASE_ID INTEGER NOT NULL,
3664
    SOURCES_ID INTEGER NOT NULL,
3665
    REVTYPE TINYINT
3666
);
3667
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ORIGINALSOURCEBASE_AUD;
3668
CREATE CACHED TABLE PUBLIC.TAXONBASE_RIGHTS(
3669
    TAXONBASE_ID INTEGER NOT NULL,
3670
    RIGHTS_ID INTEGER NOT NULL
3671
);
3672
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_RIGHTS;
3673
CREATE CACHED TABLE PUBLIC.TAXONBASE_RIGHTS_AUD(
3674
    REV INTEGER NOT NULL,
3675
    TAXONBASE_ID INTEGER NOT NULL,
3676
    RIGHTS_ID INTEGER NOT NULL,
3677
    REVTYPE TINYINT
3678
);
3679
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_RIGHTS_AUD;
3680
CREATE CACHED TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING(
3681
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
3682
    DESCRIPTION_ID INTEGER NOT NULL,
3683
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
3684
);
3685
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONINTERACTION_LANGUAGESTRING;
3686
CREATE CACHED TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD(
3687
    REV INTEGER NOT NULL,
3688
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
3689
    DESCRIPTION_ID INTEGER NOT NULL,
3690
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
3691
    REVTYPE TINYINT
3692
);
3693
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD;
3694
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE(
3695
    DTYPE VARCHAR(31) NOT NULL,
3696
    ID INTEGER NOT NULL,
3697
    CREATED TIMESTAMP,
3698
    UUID VARCHAR(36),
3699
    UPDATED TIMESTAMP,
3700
    LSID_AUTHORITY VARCHAR(255),
3701
    LSID_LSID VARCHAR(255),
3702
    LSID_NAMESPACE VARCHAR(255),
3703
    LSID_OBJECT VARCHAR(255),
3704
    LSID_REVISION VARCHAR(255),
3705
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3706
    TITLECACHE VARCHAR(255),
3707
    APPENDEDPHRASE VARCHAR(255),
3708
    FULLTITLECACHE VARCHAR(330),
3709
    NOMENCLATURALMICROREFERENCE VARCHAR(255),
3710
    PARSINGPROBLEM INTEGER NOT NULL,
3711
    PROBLEMENDS INTEGER NOT NULL,
3712
    PROBLEMSTARTS INTEGER NOT NULL,
3713
    PROTECTEDFULLTITLECACHE BOOLEAN NOT NULL,
3714
    AUTHORSHIPCACHE VARCHAR(255),
3715
    BINOMHYBRID BOOLEAN,
3716
    GENUSORUNINOMIAL VARCHAR(255),
3717
    HYBRIDFORMULA BOOLEAN,
3718
    INFRAGENERICEPITHET VARCHAR(255),
3719
    INFRASPECIFICEPITHET VARCHAR(255),
3720
    MONOMHYBRID BOOLEAN,
3721
    NAMECACHE VARCHAR(255),
3722
    PROTECTEDAUTHORSHIPCACHE BOOLEAN,
3723
    PROTECTEDNAMECACHE BOOLEAN,
3724
    SPECIFICEPITHET VARCHAR(255),
3725
    TRINOMHYBRID BOOLEAN,
3726
    NAMEAPPROBATION VARCHAR(255),
3727
    SUBGENUSAUTHORSHIP VARCHAR(255),
3728
    ANAMORPHIC BOOLEAN,
3729
    CULTIVARNAME VARCHAR(255),
3730
    ACRONYM VARCHAR(255),
3731
    BREED VARCHAR(255),
3732
    ORIGINALPUBLICATIONYEAR INTEGER,
3733
    PUBLICATIONYEAR INTEGER,
3734
    CREATEDBY_ID INTEGER,
3735
    UPDATEDBY_ID INTEGER,
3736
    HOMOTYPICALGROUP_ID INTEGER,
3737
    NOMENCLATURALREFERENCE_ID INTEGER,
3738
    RANK_ID INTEGER,
3739
    BASIONYMAUTHORTEAM_ID INTEGER,
3740
    COMBINATIONAUTHORTEAM_ID INTEGER,
3741
    EXBASIONYMAUTHORTEAM_ID INTEGER,
3742
    EXCOMBINATIONAUTHORTEAM_ID INTEGER
3743
);
3744
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE;
3745
CREATE INDEX PUBLIC.TAXONNAMEBASETITLECACHEINDEX ON PUBLIC.TAXONNAMEBASE(TITLECACHE);
3746
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_AUD(
3747
    DTYPE VARCHAR(31) NOT NULL,
3748
    ID INTEGER NOT NULL,
3749
    REV INTEGER NOT NULL,
3750
    REVTYPE TINYINT,
3751
    CREATED TIMESTAMP,
3752
    UUID VARCHAR(36),
3753
    UPDATED TIMESTAMP,
3754
    LSID_AUTHORITY VARCHAR(255),
3755
    LSID_LSID VARCHAR(255),
3756
    LSID_NAMESPACE VARCHAR(255),
3757
    LSID_OBJECT VARCHAR(255),
3758
    LSID_REVISION VARCHAR(255),
3759
    PROTECTEDTITLECACHE BOOLEAN,
3760
    TITLECACHE VARCHAR(255),
3761
    APPENDEDPHRASE VARCHAR(255),
3762
    FULLTITLECACHE VARCHAR(330),
3763
    NOMENCLATURALMICROREFERENCE VARCHAR(255),
3764
    PARSINGPROBLEM INTEGER,
3765
    PROBLEMENDS INTEGER,
3766
    PROBLEMSTARTS INTEGER,
3767
    PROTECTEDFULLTITLECACHE BOOLEAN,
3768
    CREATEDBY_ID INTEGER,
3769
    UPDATEDBY_ID INTEGER,
3770
    HOMOTYPICALGROUP_ID INTEGER,
3771
    NOMENCLATURALREFERENCE_ID INTEGER,
3772
    RANK_ID INTEGER,
3773
    ACRONYM VARCHAR(255),
3774
    AUTHORSHIPCACHE VARCHAR(255),
3775
    BINOMHYBRID BOOLEAN,
3776
    GENUSORUNINOMIAL VARCHAR(255),
3777
    HYBRIDFORMULA BOOLEAN,
3778
    INFRAGENERICEPITHET VARCHAR(255),
3779
    INFRASPECIFICEPITHET VARCHAR(255),
3780
    MONOMHYBRID BOOLEAN,
3781
    NAMECACHE VARCHAR(255),
3782
    PROTECTEDAUTHORSHIPCACHE BOOLEAN,
3783
    PROTECTEDNAMECACHE BOOLEAN,
3784
    SPECIFICEPITHET VARCHAR(255),
3785
    TRINOMHYBRID BOOLEAN,
3786
    BASIONYMAUTHORTEAM_ID INTEGER,
3787
    COMBINATIONAUTHORTEAM_ID INTEGER,
3788
    EXBASIONYMAUTHORTEAM_ID INTEGER,
3789
    EXCOMBINATIONAUTHORTEAM_ID INTEGER,
3790
    ANAMORPHIC BOOLEAN,
3791
    CULTIVARNAME VARCHAR(255),
3792
    BREED VARCHAR(255),
3793
    ORIGINALPUBLICATIONYEAR INTEGER,
3794
    PUBLICATIONYEAR INTEGER,
3795
    NAMEAPPROBATION VARCHAR(255),
3796
    SUBGENUSAUTHORSHIP VARCHAR(255)
3797
);
3798
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_AUD;
3799
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION(
3800
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3801
    ANNOTATIONS_ID INTEGER NOT NULL
3802
);
3803
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ANNOTATION;
3804
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD(
3805
    REV INTEGER NOT NULL,
3806
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3807
    ANNOTATIONS_ID INTEGER NOT NULL,
3808
    REVTYPE TINYINT
3809
);
3810
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD;
3811
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_CREDIT(
3812
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3813
    CREDITS_ID INTEGER NOT NULL,
3814
    SORTINDEX INTEGER NOT NULL
3815
);
3816
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_CREDIT;
3817
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_CREDIT_AUD(
3818
    REV INTEGER NOT NULL,
3819
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3820
    CREDITS_ID INTEGER NOT NULL,
3821
    SORTINDEX INTEGER NOT NULL,
3822
    REVTYPE TINYINT
3823
);
3824
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_CREDIT_AUD;
3825
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_EXTENSION(
3826
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3827
    EXTENSIONS_ID INTEGER NOT NULL
3828
);
3829
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_EXTENSION;
3830
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_EXTENSION_AUD(
3831
    REV INTEGER NOT NULL,
3832
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3833
    EXTENSIONS_ID INTEGER NOT NULL,
3834
    REVTYPE TINYINT
3835
);
3836
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_EXTENSION_AUD;
3837
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_MARKER(
3838
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3839
    MARKERS_ID INTEGER NOT NULL
3840
);
3841
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_MARKER;
3842
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD(
3843
    REV INTEGER NOT NULL,
3844
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3845
    MARKERS_ID INTEGER NOT NULL,
3846
    REVTYPE TINYINT
3847
);
3848
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_MARKER_AUD;
3849
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS(
3850
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3851
    STATUS_ID INTEGER NOT NULL
3852
);
3853
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS;
3854
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD(
3855
    REV INTEGER NOT NULL,
3856
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3857
    STATUS_ID INTEGER NOT NULL,
3858
    REVTYPE TINYINT
3859
);
3860
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD;
3861
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE(
3862
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3863
    SOURCES_ID INTEGER NOT NULL
3864
);
3865
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE;
3866
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD(
3867
    REV INTEGER NOT NULL,
3868
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3869
    SOURCES_ID INTEGER NOT NULL,
3870
    REVTYPE TINYINT
3871
);
3872
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD;
3873
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_RIGHTS(
3874
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3875
    RIGHTS_ID INTEGER NOT NULL
3876
);
3877
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_RIGHTS;
3878
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_RIGHTS_AUD(
3879
    REV INTEGER NOT NULL,
3880
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3881
    RIGHTS_ID INTEGER NOT NULL,
3882
    REVTYPE TINYINT
3883
);
3884
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_RIGHTS_AUD;
3885
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE(
3886
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3887
    TYPEDESIGNATIONS_ID INTEGER NOT NULL
3888
);
3889
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE;
3890
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD(
3891
    REV INTEGER NOT NULL,
3892
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3893
    TYPEDESIGNATIONS_ID INTEGER NOT NULL,
3894
    REVTYPE TINYINT
3895
);
3896
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD;
3897
CREATE CACHED TABLE PUBLIC.TAXONNODE(
3898
    ID INTEGER NOT NULL,
3899
    CREATED TIMESTAMP,
3900
    UUID VARCHAR(36),
3901
    UPDATED TIMESTAMP,
3902
    SORTINDEX INTEGER,
3903
    TREEINDEX VARCHAR(255),
3904
    COUNTCHILDREN INTEGER NOT NULL,
3905
    MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
3906
    CREATEDBY_ID INTEGER,
3907
    UPDATEDBY_ID INTEGER,
3908
    CLASSIFICATION_ID INTEGER,
3909
    PARENT_ID INTEGER,
3910
    REFERENCEFORPARENTCHILDRELATION_ID INTEGER,
3911
    SYNONYMTOBEUSED_ID INTEGER,
3912
    TAXON_ID INTEGER
3913
);
3914
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE;
3915
CREATE CACHED TABLE PUBLIC.TAXONNODE_AUD(
3916
    ID INTEGER NOT NULL,
3917
    REV INTEGER NOT NULL,
3918
    REVTYPE TINYINT,
3919
    CREATED TIMESTAMP,
3920
    UUID VARCHAR(36),
3921
    UPDATED TIMESTAMP,
3922
    SORTINDEX INTEGER,
3923
    TREEINDEX VARCHAR(255),
3924
    COUNTCHILDREN INTEGER,
3925
    MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
3926
    CREATEDBY_ID INTEGER,
3927
    UPDATEDBY_ID INTEGER,
3928
    CLASSIFICATION_ID INTEGER,
3929
    PARENT_ID INTEGER,
3930
    REFERENCEFORPARENTCHILDRELATION_ID INTEGER,
3931
    SYNONYMTOBEUSED_ID INTEGER,
3932
    TAXON_ID INTEGER
3933
);
3934
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_AUD;
3935
CREATE CACHED TABLE PUBLIC.TAXONNODE_ANNOTATION(
3936
    TAXONNODE_ID INTEGER NOT NULL,
3937
    ANNOTATIONS_ID INTEGER NOT NULL
3938
);
3939
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_ANNOTATION;
3940
CREATE CACHED TABLE PUBLIC.TAXONNODE_ANNOTATION_AUD(
3941
    REV INTEGER NOT NULL,
3942
    TAXONNODE_ID INTEGER NOT NULL,
3943
    ANNOTATIONS_ID INTEGER NOT NULL,
3944
    REVTYPE TINYINT
3945
);
3946
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_ANNOTATION_AUD;
3947
CREATE CACHED TABLE PUBLIC.TAXONNODE_MARKER(
3948
    TAXONNODE_ID INTEGER NOT NULL,
3949
    MARKERS_ID INTEGER NOT NULL
3950
);
3951
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_MARKER;
3952
CREATE CACHED TABLE PUBLIC.TAXONNODE_MARKER_AUD(
3953
    REV INTEGER NOT NULL,
3954
    TAXONNODE_ID INTEGER NOT NULL,
3955
    MARKERS_ID INTEGER NOT NULL,
3956
    REVTYPE TINYINT
3957
);
3958
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_MARKER_AUD;
3959
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP(
3960
    ID INTEGER NOT NULL,
3961
    CREATED TIMESTAMP,
3962
    UUID VARCHAR(36),
3963
    UPDATED TIMESTAMP,
3964
    CITATIONMICROREFERENCE VARCHAR(255),
3965
    ORIGINALNAMESTRING VARCHAR(255),
3966
    DOUBTFUL BOOLEAN NOT NULL,
3967
    CREATEDBY_ID INTEGER,
3968
    UPDATEDBY_ID INTEGER,
3969
    CITATION_ID INTEGER,
3970
    RELATEDFROM_ID INTEGER,
3971
    RELATEDTO_ID INTEGER,
3972
    TYPE_ID INTEGER
3973
);
3974
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP;
3975
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_AUD(
3976
    ID INTEGER NOT NULL,
3977
    REV INTEGER NOT NULL,
3978
    REVTYPE TINYINT,
3979
    CREATED TIMESTAMP,
3980
    UUID VARCHAR(36),
3981
    UPDATED TIMESTAMP,
3982
    CITATIONMICROREFERENCE VARCHAR(255),
3983
    ORIGINALNAMESTRING VARCHAR(255),
3984
    DOUBTFUL BOOLEAN,
3985
    CREATEDBY_ID INTEGER,
3986
    UPDATEDBY_ID INTEGER,
3987
    CITATION_ID INTEGER,
3988
    RELATEDFROM_ID INTEGER,
3989
    RELATEDTO_ID INTEGER,
3990
    TYPE_ID INTEGER
3991
);
3992
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_AUD;
3993
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION(
3994
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
3995
    ANNOTATIONS_ID INTEGER NOT NULL
3996
);
3997
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_ANNOTATION;
3998
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION_AUD(
3999
    REV INTEGER NOT NULL,
4000
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
4001
    ANNOTATIONS_ID INTEGER NOT NULL,
4002
    REVTYPE TINYINT
4003
);
4004
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_ANNOTATION_AUD;
4005
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_MARKER(
4006
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
4007
    MARKERS_ID INTEGER NOT NULL
4008
);
4009
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_MARKER;
4010
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_MARKER_AUD(
4011
    REV INTEGER NOT NULL,
4012
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
4013
    MARKERS_ID INTEGER NOT NULL,
4014
    REVTYPE TINYINT
4015
);
4016
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_MARKER_AUD;
4017
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY(
4018
    DTYPE VARCHAR(31) NOT NULL,
4019
    ID INTEGER NOT NULL,
4020
    CREATED TIMESTAMP,
4021
    UUID VARCHAR(36),
4022
    UPDATED TIMESTAMP,
4023
    TERMTYPE INTEGER,
4024
    LSID_AUTHORITY VARCHAR(255),
4025
    LSID_LSID VARCHAR(255),
4026
    LSID_NAMESPACE VARCHAR(255),
4027
    LSID_OBJECT VARCHAR(255),
4028
    LSID_REVISION VARCHAR(255),
4029
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
4030
    TITLECACHE VARCHAR(255),
4031
    URI CLOB,
4032
    TERMSOURCEURI CLOB,
4033
    CREATEDBY_ID INTEGER,
4034
    UPDATEDBY_ID INTEGER
4035
);
4036
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY;
4037
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_AUD(
4038
    DTYPE VARCHAR(31) NOT NULL,
4039
    ID INTEGER NOT NULL,
4040
    REV INTEGER NOT NULL,
4041
    REVTYPE TINYINT,
4042
    CREATED TIMESTAMP,
4043
    UUID VARCHAR(36),
4044
    UPDATED TIMESTAMP,
4045
    TERMTYPE INTEGER,
4046
    LSID_AUTHORITY VARCHAR(255),
4047
    LSID_LSID VARCHAR(255),
4048
    LSID_NAMESPACE VARCHAR(255),
4049
    LSID_OBJECT VARCHAR(255),
4050
    LSID_REVISION VARCHAR(255),
4051
    PROTECTEDTITLECACHE BOOLEAN,
4052
    TITLECACHE VARCHAR(255),
4053
    URI CLOB,
4054
    TERMSOURCEURI CLOB,
4055
    CREATEDBY_ID INTEGER,
4056
    UPDATEDBY_ID INTEGER
4057
);
4058
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_AUD;
4059
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ANNOTATION(
4060
    TERMVOCABULARY_ID INTEGER NOT NULL,
4061
    ANNOTATIONS_ID INTEGER NOT NULL
4062
);
4063
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ANNOTATION;
4064
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ANNOTATION_AUD(
4065
    REV INTEGER NOT NULL,
4066
    TERMVOCABULARY_ID INTEGER NOT NULL,
4067
    ANNOTATIONS_ID INTEGER NOT NULL,
4068
    REVTYPE TINYINT
4069
);
4070
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ANNOTATION_AUD;
4071
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_CREDIT(
4072
    TERMVOCABULARY_ID INTEGER NOT NULL,
4073
    CREDITS_ID INTEGER NOT NULL,
4074
    SORTINDEX INTEGER NOT NULL
4075
);
4076
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_CREDIT;
4077
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_CREDIT_AUD(
4078
    REV INTEGER NOT NULL,
4079
    TERMVOCABULARY_ID INTEGER NOT NULL,
4080
    CREDITS_ID INTEGER NOT NULL,
4081
    SORTINDEX INTEGER NOT NULL,
4082
    REVTYPE TINYINT
4083
);
4084
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_CREDIT_AUD;
4085
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_EXTENSION(
4086
    TERMVOCABULARY_ID INTEGER NOT NULL,
4087
    EXTENSIONS_ID INTEGER NOT NULL
4088
);
4089
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_EXTENSION;
4090
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_EXTENSION_AUD(
4091
    REV INTEGER NOT NULL,
4092
    TERMVOCABULARY_ID INTEGER NOT NULL,
4093
    EXTENSIONS_ID INTEGER NOT NULL,
4094
    REVTYPE TINYINT
4095
);
4096
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_EXTENSION_AUD;
4097
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_MARKER(
4098
    TERMVOCABULARY_ID INTEGER NOT NULL,
4099
    MARKERS_ID INTEGER NOT NULL
4100
);
4101
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_MARKER;
4102
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_MARKER_AUD(
4103
    REV INTEGER NOT NULL,
4104
    TERMVOCABULARY_ID INTEGER NOT NULL,
4105
    MARKERS_ID INTEGER NOT NULL,
4106
    REVTYPE TINYINT
4107
);
4108
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_MARKER_AUD;
4109
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE(
4110
    TERMVOCABULARY_ID INTEGER NOT NULL,
4111
    SOURCES_ID INTEGER NOT NULL
4112
);
4113
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE;
4114
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD(
4115
    REV INTEGER NOT NULL,
4116
    TERMVOCABULARY_ID INTEGER NOT NULL,
4117
    SOURCES_ID INTEGER NOT NULL,
4118
    REVTYPE TINYINT
4119
);
4120
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD;
4121
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION(
4122
    TERMVOCABULARY_ID INTEGER NOT NULL,
4123
    REPRESENTATIONS_ID INTEGER NOT NULL
4124
);
4125
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_REPRESENTATION;
4126
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD(
4127
    REV INTEGER NOT NULL,
4128
    TERMVOCABULARY_ID INTEGER NOT NULL,
4129
    REPRESENTATIONS_ID INTEGER NOT NULL,
4130
    REVTYPE TINYINT
4131
);
4132
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD;
4133
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_RIGHTS(
4134
    TERMVOCABULARY_ID INTEGER NOT NULL,
4135
    RIGHTS_ID INTEGER NOT NULL
4136
);
4137
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_RIGHTS;
4138
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_RIGHTS_AUD(
4139
    REV INTEGER NOT NULL,
4140
    TERMVOCABULARY_ID INTEGER NOT NULL,
4141
    RIGHTS_ID INTEGER NOT NULL,
4142
    REVTYPE TINYINT
4143
);
4144
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_RIGHTS_AUD;
4145
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE(
4146
    DTYPE VARCHAR(31) NOT NULL,
4147
    ID INTEGER NOT NULL,
4148
    CREATED TIMESTAMP,
4149
    UUID VARCHAR(36),
4150
    UPDATED TIMESTAMP,
4151
    CITATIONMICROREFERENCE VARCHAR(255),
4152
    ORIGINALNAMESTRING VARCHAR(255),
4153
    NOTDESIGNATED BOOLEAN NOT NULL,
4154
    CONSERVEDTYPE BOOLEAN,
4155
    REJECTEDTYPE BOOLEAN,
4156
    CREATEDBY_ID INTEGER,
4157
    UPDATEDBY_ID INTEGER,
4158
    CITATION_ID INTEGER,
4159
    TYPESTATUS_ID INTEGER,
4160
    TYPENAME_ID INTEGER,
4161
    TYPESPECIMEN_ID INTEGER
4162
);
4163
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE;
4164
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD(
4165
    DTYPE VARCHAR(31) NOT NULL,
4166
    ID INTEGER NOT NULL,
4167
    REV INTEGER NOT NULL,
4168
    REVTYPE TINYINT,
4169
    CREATED TIMESTAMP,
4170
    UUID VARCHAR(36),
4171
    UPDATED TIMESTAMP,
4172
    CITATIONMICROREFERENCE VARCHAR(255),
4173
    ORIGINALNAMESTRING VARCHAR(255),
4174
    NOTDESIGNATED BOOLEAN,
4175
    CREATEDBY_ID INTEGER,
4176
    UPDATEDBY_ID INTEGER,
4177
    CITATION_ID INTEGER,
4178
    TYPESTATUS_ID INTEGER,
4179
    CONSERVEDTYPE BOOLEAN,
4180
    REJECTEDTYPE BOOLEAN,
4181
    TYPENAME_ID INTEGER,
4182
    TYPESPECIMEN_ID INTEGER
4183
);
4184
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_AUD;
4185
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION(
4186
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4187
    ANNOTATIONS_ID INTEGER NOT NULL
4188
);
4189
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION;
4190
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION_AUD(
4191
    REV INTEGER NOT NULL,
4192
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4193
    ANNOTATIONS_ID INTEGER NOT NULL,
4194
    REVTYPE TINYINT
4195
);
4196
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION_AUD;
4197
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER(
4198
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4199
    MARKERS_ID INTEGER NOT NULL
4200
);
4201
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_MARKER;
4202
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD(
4203
    REV INTEGER NOT NULL,
4204
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4205
    MARKERS_ID INTEGER NOT NULL,
4206
    REVTYPE TINYINT
4207
);
4208
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD;
4209
CREATE CACHED TABLE PUBLIC.USERACCOUNT(
4210
    ID INTEGER NOT NULL,
4211
    CREATED TIMESTAMP,
4212
    UUID VARCHAR(36),
4213
    ACCOUNTNONEXPIRED BOOLEAN NOT NULL,
4214
    ACCOUNTNONLOCKED BOOLEAN NOT NULL,
4215
    CREDENTIALSNONEXPIRED BOOLEAN NOT NULL,
4216
    EMAILADDRESS VARCHAR(255),
4217
    ENABLED BOOLEAN NOT NULL,
4218
    PASSWORD VARCHAR(255),
4219
    USERNAME VARCHAR(255),
4220
    CREATEDBY_ID INTEGER,
4221
    PERSON_ID INTEGER
4222
);
4223
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT;
4224
CREATE CACHED TABLE PUBLIC.USERACCOUNT_AUD(
4225
    ID INTEGER NOT NULL,
4226
    REV INTEGER NOT NULL,
4227
    REVTYPE TINYINT,
4228
    CREATED TIMESTAMP,
4229
    UUID VARCHAR(36),
4230
    ACCOUNTNONEXPIRED BOOLEAN,
4231
    ACCOUNTNONLOCKED BOOLEAN,
4232
    CREDENTIALSNONEXPIRED BOOLEAN,
4233
    EMAILADDRESS VARCHAR(255),
4234
    ENABLED BOOLEAN,
4235
    USERNAME VARCHAR(255),
4236
    CREATEDBY_ID INTEGER,
4237
    PERSON_ID INTEGER
4238
);
4239
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_AUD;
4240
CREATE CACHED TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL(
4241
    USERACCOUNT_ID INTEGER NOT NULL,
4242
    GRANTEDAUTHORITIES_ID INTEGER NOT NULL
4243
);
4244
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL;
4245
CREATE CACHED TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP(
4246
    MEMBERS_ID INTEGER NOT NULL,
4247
    GROUPS_ID INTEGER NOT NULL
4248
);
4249
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_PERMISSIONGROUP;
4250
CREATE CACHED TABLE PUBLIC.WORKINGSET(
4251
    DTYPE VARCHAR(31) NOT NULL,
4252
    ID INTEGER NOT NULL,
4253
    CREATED TIMESTAMP,
4254
    UUID VARCHAR(36),
4255
    UPDATED TIMESTAMP,
4256
    CREATEDBY_ID INTEGER,
4257
    UPDATEDBY_ID INTEGER,
4258
    DESCRIPTIVESYSTEM_ID INTEGER
4259
);
4260
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET;
4261
CREATE CACHED TABLE PUBLIC.WORKINGSET_AUD(
4262
    DTYPE VARCHAR(31) NOT NULL,
4263
    ID INTEGER NOT NULL,
4264
    REV INTEGER NOT NULL,
4265
    REVTYPE TINYINT,
4266
    CREATED TIMESTAMP,
4267
    UUID VARCHAR(36),
4268
    UPDATED TIMESTAMP,
4269
    CREATEDBY_ID INTEGER,
4270
    UPDATEDBY_ID INTEGER,
4271
    DESCRIPTIVESYSTEM_ID INTEGER
4272
);
4273
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_AUD;
4274
CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION(
4275
    WORKINGSET_ID INTEGER NOT NULL,
4276
    ANNOTATIONS_ID INTEGER NOT NULL
4277
);
4278
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION;
4279
CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD(
4280
    REV INTEGER NOT NULL,
4281
    WORKINGSET_ID INTEGER NOT NULL,
4282
    ANNOTATIONS_ID INTEGER NOT NULL,
4283
    REVTYPE TINYINT
4284
);
4285
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION_AUD;
4286
CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE(
4287
    WORKINGSET_ID INTEGER NOT NULL,
4288
    DESCRIPTIONS_ID INTEGER NOT NULL
4289
);
4290
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_DESCRIPTIONBASE;
4291
CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD(
4292
    REV INTEGER NOT NULL,
4293
    WORKINGSET_ID INTEGER NOT NULL,
4294
    DESCRIPTIONS_ID INTEGER NOT NULL,
4295
    REVTYPE TINYINT
4296
);
4297
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD;
4298
CREATE CACHED TABLE PUBLIC.WORKINGSET_MARKER(
4299
    WORKINGSET_ID INTEGER NOT NULL,
4300
    MARKERS_ID INTEGER NOT NULL
4301
);
4302
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_MARKER;
4303
CREATE CACHED TABLE PUBLIC.WORKINGSET_MARKER_AUD(
4304
    REV INTEGER NOT NULL,
4305
    WORKINGSET_ID INTEGER NOT NULL,
4306
    MARKERS_ID INTEGER NOT NULL,
4307
    REVTYPE TINYINT
4308
);
4309
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_MARKER_AUD;
4310
CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION(
4311
    WORKINGSET_ID INTEGER NOT NULL,
4312
    REPRESENTATIONS_ID INTEGER NOT NULL
4313
);
4314
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_REPRESENTATION;
4315
CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION_AUD(
4316
    REV INTEGER NOT NULL,
4317
    WORKINGSET_ID INTEGER NOT NULL,
4318