Project

General

Profile

Statistics
| Branch: | Tag: | Revision:

cdmlib / cdmlib-services / src / test / resources / dbscripts / 001-cdm.h2.sql @ 6a5088e0

History | View | Annotate | Download (352 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.GENBANKACCESSION(
1719
    ID INTEGER NOT NULL,
1720
    CREATED TIMESTAMP,
1721
    UUID VARCHAR(36),
1722
    UPDATED TIMESTAMP,
1723
    ACCESSIONNUMBER VARCHAR(255),
1724
    URI CLOB,
1725
    CREATEDBY_ID INTEGER,
1726
    UPDATEDBY_ID INTEGER
1727
);
1728
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION;
1729
CREATE CACHED TABLE PUBLIC.GENBANKACCESSION_AUD(
1730
    ID INTEGER NOT NULL,
1731
    REV INTEGER NOT NULL,
1732
    REVTYPE TINYINT,
1733
    CREATED TIMESTAMP,
1734
    UUID VARCHAR(36),
1735
    UPDATED TIMESTAMP,
1736
    ACCESSIONNUMBER VARCHAR(255),
1737
    URI CLOB,
1738
    CREATEDBY_ID INTEGER,
1739
    UPDATEDBY_ID INTEGER
1740
);
1741
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION_AUD;
1742
CREATE CACHED TABLE PUBLIC.GRANTEDAUTHORITYIMPL(
1743
    ID INTEGER NOT NULL,
1744
    CREATED TIMESTAMP,
1745
    UUID VARCHAR(36),
1746
    AUTHORITY VARCHAR(255),
1747
    CREATEDBY_ID INTEGER
1748
);
1749
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GRANTEDAUTHORITYIMPL;
1750
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP(
1751
    ID INTEGER NOT NULL,
1752
    CREATED TIMESTAMP,
1753
    UUID VARCHAR(36),
1754
    UPDATED TIMESTAMP,
1755
    CREATEDBY_ID INTEGER,
1756
    UPDATEDBY_ID INTEGER
1757
);
1758
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP;
1759
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_AUD(
1760
    ID INTEGER NOT NULL,
1761
    REV INTEGER NOT NULL,
1762
    REVTYPE TINYINT,
1763
    CREATED TIMESTAMP,
1764
    UUID VARCHAR(36),
1765
    UPDATED TIMESTAMP,
1766
    CREATEDBY_ID INTEGER,
1767
    UPDATEDBY_ID INTEGER
1768
);
1769
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_AUD;
1770
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION(
1771
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
1772
    ANNOTATIONS_ID INTEGER NOT NULL
1773
);
1774
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_ANNOTATION;
1775
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION_AUD(
1776
    REV INTEGER NOT NULL,
1777
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
1778
    ANNOTATIONS_ID INTEGER NOT NULL,
1779
    REVTYPE TINYINT
1780
);
1781
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_ANNOTATION_AUD;
1782
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_MARKER(
1783
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
1784
    MARKERS_ID INTEGER NOT NULL
1785
);
1786
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_MARKER;
1787
CREATE CACHED TABLE PUBLIC.HOMOTYPICALGROUP_MARKER_AUD(
1788
    REV INTEGER NOT NULL,
1789
    HOMOTYPICALGROUP_ID INTEGER NOT NULL,
1790
    MARKERS_ID INTEGER NOT NULL,
1791
    REVTYPE TINYINT
1792
);
1793
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HOMOTYPICALGROUP_MARKER_AUD;
1794
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP(
1795
    ID INTEGER NOT NULL,
1796
    CREATED TIMESTAMP,
1797
    UUID VARCHAR(36),
1798
    UPDATED TIMESTAMP,
1799
    CITATIONMICROREFERENCE VARCHAR(255),
1800
    ORIGINALNAMESTRING VARCHAR(255),
1801
    DOUBTFUL BOOLEAN NOT NULL,
1802
    RULECONSIDERED VARCHAR(255),
1803
    CREATEDBY_ID INTEGER,
1804
    UPDATEDBY_ID INTEGER,
1805
    CITATION_ID INTEGER,
1806
    RELATEDFROM_ID INTEGER,
1807
    RELATEDTO_ID INTEGER,
1808
    TYPE_ID INTEGER
1809
);
1810
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP;
1811
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_AUD(
1812
    ID INTEGER NOT NULL,
1813
    REV INTEGER NOT NULL,
1814
    REVTYPE TINYINT,
1815
    CREATED TIMESTAMP,
1816
    UUID VARCHAR(36),
1817
    UPDATED TIMESTAMP,
1818
    CITATIONMICROREFERENCE VARCHAR(255),
1819
    ORIGINALNAMESTRING VARCHAR(255),
1820
    DOUBTFUL BOOLEAN,
1821
    RULECONSIDERED VARCHAR(255),
1822
    CREATEDBY_ID INTEGER,
1823
    UPDATEDBY_ID INTEGER,
1824
    CITATION_ID INTEGER,
1825
    RELATEDFROM_ID INTEGER,
1826
    RELATEDTO_ID INTEGER,
1827
    TYPE_ID INTEGER
1828
);
1829
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_AUD;
1830
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION(
1831
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
1832
    ANNOTATIONS_ID INTEGER NOT NULL
1833
);
1834
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION;
1835
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD(
1836
    REV INTEGER NOT NULL,
1837
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
1838
    ANNOTATIONS_ID INTEGER NOT NULL,
1839
    REVTYPE TINYINT
1840
);
1841
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD;
1842
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER(
1843
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
1844
    MARKERS_ID INTEGER NOT NULL
1845
);
1846
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_MARKER;
1847
CREATE CACHED TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER_AUD(
1848
    REV INTEGER NOT NULL,
1849
    HYBRIDRELATIONSHIP_ID INTEGER NOT NULL,
1850
    MARKERS_ID INTEGER NOT NULL,
1851
    REVTYPE TINYINT
1852
);
1853
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_MARKER_AUD;
1854
CREATE CACHED TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING(
1855
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1856
    DESCRIPTION_ID INTEGER NOT NULL,
1857
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
1858
);
1859
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING;
1860
CREATE CACHED TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING_AUD(
1861
    REV INTEGER NOT NULL,
1862
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1863
    DESCRIPTION_ID INTEGER NOT NULL,
1864
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
1865
    REVTYPE TINYINT
1866
);
1867
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING_AUD;
1868
CREATE CACHED TABLE PUBLIC.INSTITUTIONALMEMBERSHIP(
1869
    ID INTEGER NOT NULL,
1870
    CREATED TIMESTAMP,
1871
    UUID VARCHAR(36),
1872
    UPDATED TIMESTAMP,
1873
    DEPARTMENT VARCHAR(255),
1874
    PERIOD_END VARCHAR(255),
1875
    PERIOD_FREETEXT VARCHAR(255),
1876
    PERIOD_START VARCHAR(255),
1877
    ROLE VARCHAR(255),
1878
    CREATEDBY_ID INTEGER,
1879
    UPDATEDBY_ID INTEGER,
1880
    INSTITUTE_ID INTEGER,
1881
    PERSON_ID INTEGER
1882
);
1883
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INSTITUTIONALMEMBERSHIP;
1884
CREATE CACHED TABLE PUBLIC.INSTITUTIONALMEMBERSHIP_AUD(
1885
    ID INTEGER NOT NULL,
1886
    REV INTEGER NOT NULL,
1887
    REVTYPE TINYINT,
1888
    CREATED TIMESTAMP,
1889
    UUID VARCHAR(36),
1890
    UPDATED TIMESTAMP,
1891
    DEPARTMENT VARCHAR(255),
1892
    PERIOD_END VARCHAR(255),
1893
    PERIOD_FREETEXT VARCHAR(255),
1894
    PERIOD_START VARCHAR(255),
1895
    ROLE VARCHAR(255),
1896
    CREATEDBY_ID INTEGER,
1897
    UPDATEDBY_ID INTEGER,
1898
    INSTITUTE_ID INTEGER,
1899
    PERSON_ID INTEGER
1900
);
1901
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INSTITUTIONALMEMBERSHIP_AUD;
1902
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT(
1903
    ID INTEGER NOT NULL,
1904
    CREATED TIMESTAMP,
1905
    UUID VARCHAR(36),
1906
    UPDATED TIMESTAMP,
1907
    CREATEDBY_ID INTEGER,
1908
    UPDATEDBY_ID INTEGER
1909
);
1910
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT;
1911
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT_AUD(
1912
    ID INTEGER NOT NULL,
1913
    REV INTEGER NOT NULL,
1914
    REVTYPE TINYINT,
1915
    CREATED TIMESTAMP,
1916
    UUID VARCHAR(36),
1917
    UPDATED TIMESTAMP,
1918
    CREATEDBY_ID INTEGER,
1919
    UPDATEDBY_ID INTEGER
1920
);
1921
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT_AUD;
1922
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING(
1923
    KEYSTATEMENT_ID INTEGER NOT NULL,
1924
    LABEL_ID INTEGER NOT NULL,
1925
    LABEL_MAPKEY_ID INTEGER NOT NULL
1926
);
1927
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT_LANGUAGESTRING;
1928
CREATE CACHED TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING_AUD(
1929
    REV INTEGER NOT NULL,
1930
    KEYSTATEMENT_ID INTEGER NOT NULL,
1931
    LABEL_ID INTEGER NOT NULL,
1932
    LABEL_MAPKEY_ID INTEGER NOT NULL,
1933
    REVTYPE TINYINT
1934
);
1935
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.KEYSTATEMENT_LANGUAGESTRING_AUD;
1936
CREATE CACHED TABLE PUBLIC.LSIDAUTHORITY(
1937
    ID INTEGER NOT NULL,
1938
    CREATED TIMESTAMP,
1939
    UUID VARCHAR(36),
1940
    AUTHORITY VARCHAR(255),
1941
    AUTHORITYWSDL CLOB,
1942
    PORT INTEGER NOT NULL,
1943
    SERVER VARCHAR(255),
1944
    URL VARCHAR(255),
1945
    CREATEDBY_ID INTEGER
1946
);
1947
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LSIDAUTHORITY;
1948
CREATE CACHED TABLE PUBLIC.LSIDAUTHORITY_NAMESPACES(
1949
    LSIDAUTHORITY_ID INTEGER NOT NULL,
1950
    NAMESPACES_ELEMENT VARCHAR(255),
1951
    NAMESPACES_MAPKEY VARCHAR(255) NOT NULL
1952
);
1953
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LSIDAUTHORITY_NAMESPACES;
1954
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING(
1955
    ID INTEGER NOT NULL,
1956
    CREATED TIMESTAMP,
1957
    UUID VARCHAR(36),
1958
    UPDATED TIMESTAMP,
1959
    TEXT CLOB,
1960
    CREATEDBY_ID INTEGER,
1961
    UPDATEDBY_ID INTEGER,
1962
    LANGUAGE_ID INTEGER
1963
);
1964
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING;
1965
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_AUD(
1966
    ID INTEGER NOT NULL,
1967
    REV INTEGER NOT NULL,
1968
    REVTYPE TINYINT,
1969
    CREATED TIMESTAMP,
1970
    UUID VARCHAR(36),
1971
    UPDATED TIMESTAMP,
1972
    TEXT CLOB,
1973
    CREATEDBY_ID INTEGER,
1974
    UPDATEDBY_ID INTEGER,
1975
    LANGUAGE_ID INTEGER
1976
);
1977
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_AUD;
1978
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_ANNOTATION(
1979
    LANGUAGESTRING_ID INTEGER NOT NULL,
1980
    ANNOTATIONS_ID INTEGER NOT NULL
1981
);
1982
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_ANNOTATION;
1983
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_ANNOTATION_AUD(
1984
    REV INTEGER NOT NULL,
1985
    LANGUAGESTRING_ID INTEGER NOT NULL,
1986
    ANNOTATIONS_ID INTEGER NOT NULL,
1987
    REVTYPE TINYINT
1988
);
1989
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_ANNOTATION_AUD;
1990
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_MARKER(
1991
    LANGUAGESTRING_ID INTEGER NOT NULL,
1992
    MARKERS_ID INTEGER NOT NULL
1993
);
1994
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_MARKER;
1995
CREATE CACHED TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD(
1996
    REV INTEGER NOT NULL,
1997
    LANGUAGESTRING_ID INTEGER NOT NULL,
1998
    MARKERS_ID INTEGER NOT NULL,
1999
    REVTYPE TINYINT
2000
);
2001
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LANGUAGESTRING_MARKER_AUD;
2002
CREATE CACHED TABLE PUBLIC.LOCUS(
2003
    ID INTEGER NOT NULL,
2004
    CREATED TIMESTAMP,
2005
    UUID VARCHAR(36),
2006
    UPDATED TIMESTAMP,
2007
    DESCRIPTION VARCHAR(255),
2008
    NAME VARCHAR(255),
2009
    CREATEDBY_ID INTEGER,
2010
    UPDATEDBY_ID INTEGER
2011
);
2012
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LOCUS;
2013
CREATE CACHED TABLE PUBLIC.LOCUS_AUD(
2014
    ID INTEGER NOT NULL,
2015
    REV INTEGER NOT NULL,
2016
    REVTYPE TINYINT,
2017
    CREATED TIMESTAMP,
2018
    UUID VARCHAR(36),
2019
    UPDATED TIMESTAMP,
2020
    DESCRIPTION VARCHAR(255),
2021
    NAME VARCHAR(255),
2022
    CREATEDBY_ID INTEGER,
2023
    UPDATEDBY_ID INTEGER
2024
);
2025
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LOCUS_AUD;
2026
CREATE CACHED TABLE PUBLIC.MARKER(
2027
    ID INTEGER NOT NULL,
2028
    CREATED TIMESTAMP,
2029
    UUID VARCHAR(36),
2030
    UPDATED TIMESTAMP,
2031
    FLAG BOOLEAN NOT NULL,
2032
    MARKEDOBJ_TYPE VARCHAR(255),
2033
    MARKEDOBJ_ID INTEGER NOT NULL,
2034
    CREATEDBY_ID INTEGER,
2035
    UPDATEDBY_ID INTEGER,
2036
    MARKERTYPE_ID INTEGER
2037
);
2038
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MARKER;
2039
CREATE CACHED TABLE PUBLIC.MARKER_AUD(
2040
    ID INTEGER NOT NULL,
2041
    REV INTEGER NOT NULL,
2042
    REVTYPE TINYINT,
2043
    CREATED TIMESTAMP,
2044
    UUID VARCHAR(36),
2045
    UPDATED TIMESTAMP,
2046
    FLAG BOOLEAN,
2047
    CREATEDBY_ID INTEGER,
2048
    UPDATEDBY_ID INTEGER,
2049
    MARKERTYPE_ID INTEGER
2050
);
2051
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MARKER_AUD;
2052
CREATE CACHED TABLE PUBLIC.MEDIA(
2053
    DTYPE VARCHAR(31) NOT NULL,
2054
    ID INTEGER NOT NULL,
2055
    CREATED TIMESTAMP,
2056
    UUID VARCHAR(36),
2057
    UPDATED TIMESTAMP,
2058
    LSID_AUTHORITY VARCHAR(255),
2059
    LSID_LSID VARCHAR(255),
2060
    LSID_NAMESPACE VARCHAR(255),
2061
    LSID_OBJECT VARCHAR(255),
2062
    LSID_REVISION VARCHAR(255),
2063
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
2064
    TITLECACHE VARCHAR(255),
2065
    MEDIACREATED TIMESTAMP,
2066
    CITATIONMICROREFERENCE VARCHAR(255),
2067
    CREATEDBY_ID INTEGER,
2068
    UPDATEDBY_ID INTEGER,
2069
    ARTIST_ID INTEGER,
2070
    CITATION_ID INTEGER
2071
);
2072
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA;
2073
CREATE CACHED TABLE PUBLIC.MEDIAKEY_NAMEDAREA(
2074
    MEDIA_ID INTEGER NOT NULL,
2075
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
2076
);
2077
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_NAMEDAREA;
2078
CREATE CACHED TABLE PUBLIC.MEDIAKEY_NAMEDAREA_AUD(
2079
    REV INTEGER NOT NULL,
2080
    MEDIA_ID INTEGER NOT NULL,
2081
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
2082
    REVTYPE TINYINT
2083
);
2084
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_NAMEDAREA_AUD;
2085
CREATE CACHED TABLE PUBLIC.MEDIAKEY_SCOPE(
2086
    MEDIA_ID INTEGER NOT NULL,
2087
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
2088
);
2089
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_SCOPE;
2090
CREATE CACHED TABLE PUBLIC.MEDIAKEY_SCOPE_AUD(
2091
    REV INTEGER NOT NULL,
2092
    MEDIA_ID INTEGER NOT NULL,
2093
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
2094
    REVTYPE TINYINT
2095
);
2096
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_SCOPE_AUD;
2097
CREATE CACHED TABLE PUBLIC.MEDIAKEY_TAXON(
2098
    MEDIAKEY_ID INTEGER NOT NULL,
2099
    TAXON_ID INTEGER NOT NULL
2100
);
2101
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_TAXON;
2102
CREATE CACHED TABLE PUBLIC.MEDIAKEY_TAXON_AUD(
2103
    REV INTEGER NOT NULL,
2104
    MEDIAKEY_ID INTEGER NOT NULL,
2105
    TAXON_ID INTEGER NOT NULL,
2106
    REVTYPE TINYINT
2107
);
2108
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_TAXON_AUD;
2109
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION(
2110
    ID INTEGER NOT NULL,
2111
    CREATED TIMESTAMP,
2112
    UUID VARCHAR(36),
2113
    UPDATED TIMESTAMP,
2114
    MIMETYPE VARCHAR(255),
2115
    SUFFIX VARCHAR(255),
2116
    CREATEDBY_ID INTEGER,
2117
    UPDATEDBY_ID INTEGER,
2118
    MEDIA_ID INTEGER
2119
);
2120
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATION;
2121
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATIONPART(
2122
    DTYPE VARCHAR(31) NOT NULL,
2123
    ID INTEGER NOT NULL,
2124
    CREATED TIMESTAMP,
2125
    UUID VARCHAR(36),
2126
    UPDATED TIMESTAMP,
2127
    SIZE INTEGER,
2128
    URI CLOB,
2129
    DURATION INTEGER,
2130
    HEIGHT INTEGER,
2131
    WIDTH INTEGER,
2132
    CREATEDBY_ID INTEGER,
2133
    UPDATEDBY_ID INTEGER,
2134
    REPRESENTATION_ID INTEGER NOT NULL,
2135
    SORTINDEX INTEGER
2136
);
2137
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATIONPART;
2138
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD(
2139
    DTYPE VARCHAR(31) NOT NULL,
2140
    ID INTEGER NOT NULL,
2141
    REV INTEGER NOT NULL,
2142
    REVTYPE TINYINT,
2143
    CREATED TIMESTAMP,
2144
    UUID VARCHAR(36),
2145
    UPDATED TIMESTAMP,
2146
    SIZE INTEGER,
2147
    URI CLOB,
2148
    CREATEDBY_ID INTEGER,
2149
    UPDATEDBY_ID INTEGER,
2150
    REPRESENTATION_ID INTEGER,
2151
    DURATION INTEGER,
2152
    HEIGHT INTEGER,
2153
    WIDTH INTEGER
2154
);
2155
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATIONPART_AUD;
2156
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION_AUD(
2157
    ID INTEGER NOT NULL,
2158
    REV INTEGER NOT NULL,
2159
    REVTYPE TINYINT,
2160
    CREATED TIMESTAMP,
2161
    UUID VARCHAR(36),
2162
    UPDATED TIMESTAMP,
2163
    MIMETYPE VARCHAR(255),
2164
    SUFFIX VARCHAR(255),
2165
    CREATEDBY_ID INTEGER,
2166
    UPDATEDBY_ID INTEGER,
2167
    MEDIA_ID INTEGER
2168
);
2169
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATION_AUD;
2170
CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD(
2171
    REV INTEGER NOT NULL,
2172
    REPRESENTATION_ID INTEGER NOT NULL,
2173
    ID INTEGER NOT NULL,
2174
    SORTINDEX INTEGER NOT NULL,
2175
    REVTYPE TINYINT
2176
);
2177
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD;
2178
CREATE CACHED TABLE PUBLIC.MEDIA_AUD(
2179
    DTYPE VARCHAR(31) NOT NULL,
2180
    ID INTEGER NOT NULL,
2181
    REV INTEGER NOT NULL,
2182
    REVTYPE TINYINT,
2183
    CREATED TIMESTAMP,
2184
    UUID VARCHAR(36),
2185
    UPDATED TIMESTAMP,
2186
    LSID_AUTHORITY VARCHAR(255),
2187
    LSID_LSID VARCHAR(255),
2188
    LSID_NAMESPACE VARCHAR(255),
2189
    LSID_OBJECT VARCHAR(255),
2190
    LSID_REVISION VARCHAR(255),
2191
    PROTECTEDTITLECACHE BOOLEAN,
2192
    TITLECACHE VARCHAR(255),
2193
    MEDIACREATED TIMESTAMP,
2194
    CREATEDBY_ID INTEGER,
2195
    UPDATEDBY_ID INTEGER,
2196
    ARTIST_ID INTEGER,
2197
    CITATIONMICROREFERENCE VARCHAR(255),
2198
    CITATION_ID INTEGER
2199
);
2200
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_AUD;
2201
CREATE CACHED TABLE PUBLIC.MEDIA_ANNOTATION(
2202
    MEDIA_ID INTEGER NOT NULL,
2203
    ANNOTATIONS_ID INTEGER NOT NULL
2204
);
2205
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ANNOTATION;
2206
CREATE CACHED TABLE PUBLIC.MEDIA_ANNOTATION_AUD(
2207
    REV INTEGER NOT NULL,
2208
    MEDIA_ID INTEGER NOT NULL,
2209
    ANNOTATIONS_ID INTEGER NOT NULL,
2210
    REVTYPE TINYINT
2211
);
2212
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ANNOTATION_AUD;
2213
CREATE CACHED TABLE PUBLIC.MEDIA_CREDIT(
2214
    MEDIA_ID INTEGER NOT NULL,
2215
    CREDITS_ID INTEGER NOT NULL,
2216
    SORTINDEX INTEGER NOT NULL
2217
);
2218
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_CREDIT;
2219
CREATE CACHED TABLE PUBLIC.MEDIA_CREDIT_AUD(
2220
    REV INTEGER NOT NULL,
2221
    MEDIA_ID INTEGER NOT NULL,
2222
    CREDITS_ID INTEGER NOT NULL,
2223
    SORTINDEX INTEGER NOT NULL,
2224
    REVTYPE TINYINT
2225
);
2226
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_CREDIT_AUD;
2227
CREATE CACHED TABLE PUBLIC.MEDIA_DESCRIPTION(
2228
    MEDIA_ID INTEGER NOT NULL,
2229
    DESCRIPTION_ID INTEGER NOT NULL,
2230
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
2231
);
2232
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_DESCRIPTION;
2233
CREATE CACHED TABLE PUBLIC.MEDIA_DESCRIPTION_AUD(
2234
    REV INTEGER NOT NULL,
2235
    MEDIA_ID INTEGER NOT NULL,
2236
    DESCRIPTION_ID INTEGER NOT NULL,
2237
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
2238
    REVTYPE TINYINT
2239
);
2240
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_DESCRIPTION_AUD;
2241
CREATE CACHED TABLE PUBLIC.MEDIA_EXTENSION(
2242
    MEDIA_ID INTEGER NOT NULL,
2243
    EXTENSIONS_ID INTEGER NOT NULL
2244
);
2245
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_EXTENSION;
2246
CREATE CACHED TABLE PUBLIC.MEDIA_EXTENSION_AUD(
2247
    REV INTEGER NOT NULL,
2248
    MEDIA_ID INTEGER NOT NULL,
2249
    EXTENSIONS_ID INTEGER NOT NULL,
2250
    REVTYPE TINYINT
2251
);
2252
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_EXTENSION_AUD;
2253
CREATE CACHED TABLE PUBLIC.MEDIA_LANGUAGESTRING(
2254
    MEDIA_ID INTEGER NOT NULL,
2255
    TITLE_ID INTEGER NOT NULL,
2256
    TITLE_MAPKEY_ID INTEGER NOT NULL
2257
);
2258
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_LANGUAGESTRING;
2259
CREATE CACHED TABLE PUBLIC.MEDIA_LANGUAGESTRING_AUD(
2260
    REV INTEGER NOT NULL,
2261
    MEDIA_ID INTEGER NOT NULL,
2262
    TITLE_ID INTEGER NOT NULL,
2263
    TITLE_MAPKEY_ID INTEGER NOT NULL,
2264
    REVTYPE TINYINT
2265
);
2266
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_LANGUAGESTRING_AUD;
2267
CREATE CACHED TABLE PUBLIC.MEDIA_MARKER(
2268
    MEDIA_ID INTEGER NOT NULL,
2269
    MARKERS_ID INTEGER NOT NULL
2270
);
2271
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_MARKER;
2272
CREATE CACHED TABLE PUBLIC.MEDIA_MARKER_AUD(
2273
    REV INTEGER NOT NULL,
2274
    MEDIA_ID INTEGER NOT NULL,
2275
    MARKERS_ID INTEGER NOT NULL,
2276
    REVTYPE TINYINT
2277
);
2278
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_MARKER_AUD;
2279
CREATE CACHED TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE(
2280
    MEDIA_ID INTEGER NOT NULL,
2281
    SOURCES_ID INTEGER NOT NULL
2282
);
2283
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ORIGINALSOURCEBASE;
2284
CREATE CACHED TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD(
2285
    REV INTEGER NOT NULL,
2286
    MEDIA_ID INTEGER NOT NULL,
2287
    SOURCES_ID INTEGER NOT NULL,
2288
    REVTYPE TINYINT
2289
);
2290
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD;
2291
CREATE CACHED TABLE PUBLIC.MEDIA_REPRESENTATION(
2292
    MEDIA_ID INTEGER NOT NULL,
2293
    KEYREPRESENTATIONS_ID INTEGER NOT NULL
2294
);
2295
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_REPRESENTATION;
2296
CREATE CACHED TABLE PUBLIC.MEDIA_REPRESENTATION_AUD(
2297
    REV INTEGER NOT NULL,
2298
    MEDIA_ID INTEGER NOT NULL,
2299
    KEYREPRESENTATIONS_ID INTEGER NOT NULL,
2300
    REVTYPE TINYINT
2301
);
2302
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_REPRESENTATION_AUD;
2303
CREATE CACHED TABLE PUBLIC.MEDIA_RIGHTS(
2304
    MEDIA_ID INTEGER NOT NULL,
2305
    RIGHTS_ID INTEGER NOT NULL
2306
);
2307
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTS;
2308
CREATE CACHED TABLE PUBLIC.MEDIA_RIGHTS_AUD(
2309
    REV INTEGER NOT NULL,
2310
    MEDIA_ID INTEGER NOT NULL,
2311
    RIGHTS_ID INTEGER NOT NULL,
2312
    REVTYPE TINYINT
2313
);
2314
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTS_AUD;
2315
CREATE CACHED TABLE PUBLIC.MEDIA_SEQUENCE(
2316
    MEDIA_ID INTEGER NOT NULL,
2317
    USEDSEQUENCES_ID INTEGER NOT NULL
2318
);
2319
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_SEQUENCE;
2320
CREATE CACHED TABLE PUBLIC.MEDIA_SEQUENCE_AUD(
2321
    REV INTEGER NOT NULL,
2322
    MEDIA_ID INTEGER NOT NULL,
2323
    USEDSEQUENCES_ID INTEGER NOT NULL,
2324
    REVTYPE TINYINT
2325
);
2326
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_SEQUENCE_AUD;
2327
CREATE CACHED TABLE PUBLIC.MEDIA_TAXONBASE(
2328
    MEDIA_ID INTEGER NOT NULL,
2329
    COVEREDTAXA_ID INTEGER NOT NULL
2330
);
2331
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_TAXONBASE;
2332
CREATE CACHED TABLE PUBLIC.MEDIA_TAXONBASE_AUD(
2333
    REV INTEGER NOT NULL,
2334
    MEDIA_ID INTEGER NOT NULL,
2335
    COVEREDTAXA_ID INTEGER NOT NULL,
2336
    REVTYPE TINYINT
2337
);
2338
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_TAXONBASE_AUD;
2339
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA(
2340
    WORKINGSET_ID INTEGER NOT NULL,
2341
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
2342
);
2343
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_NAMEDAREA;
2344
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD(
2345
    REV INTEGER NOT NULL,
2346
    WORKINGSET_ID INTEGER NOT NULL,
2347
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
2348
    REVTYPE TINYINT
2349
);
2350
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD;
2351
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_SCOPE(
2352
    WORKINGSET_ID INTEGER NOT NULL,
2353
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
2354
);
2355
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_SCOPE;
2356
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_SCOPE_AUD(
2357
    REV INTEGER NOT NULL,
2358
    WORKINGSET_ID INTEGER NOT NULL,
2359
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
2360
    REVTYPE TINYINT
2361
);
2362
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_SCOPE_AUD;
2363
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_TAXON(
2364
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2365
    TAXON_ID INTEGER NOT NULL
2366
);
2367
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_TAXON;
2368
CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_TAXON_AUD(
2369
    REV INTEGER NOT NULL,
2370
    MULTIACCESSKEY_ID INTEGER NOT NULL,
2371
    TAXON_ID INTEGER NOT NULL,
2372
    REVTYPE TINYINT
2373
);
2374
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_TAXON_AUD;
2375
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP(
2376
    ID INTEGER NOT NULL,
2377
    CREATED TIMESTAMP,
2378
    UUID VARCHAR(36),
2379
    UPDATED TIMESTAMP,
2380
    CITATIONMICROREFERENCE VARCHAR(255),
2381
    ORIGINALNAMESTRING VARCHAR(255),
2382
    DOUBTFUL BOOLEAN NOT NULL,
2383
    RULECONSIDERED VARCHAR(255),
2384
    CREATEDBY_ID INTEGER,
2385
    UPDATEDBY_ID INTEGER,
2386
    CITATION_ID INTEGER,
2387
    RELATEDFROM_ID INTEGER,
2388
    RELATEDTO_ID INTEGER,
2389
    TYPE_ID INTEGER
2390
);
2391
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP;
2392
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_AUD(
2393
    ID INTEGER NOT NULL,
2394
    REV INTEGER NOT NULL,
2395
    REVTYPE TINYINT,
2396
    CREATED TIMESTAMP,
2397
    UUID VARCHAR(36),
2398
    UPDATED TIMESTAMP,
2399
    CITATIONMICROREFERENCE VARCHAR(255),
2400
    ORIGINALNAMESTRING VARCHAR(255),
2401
    DOUBTFUL BOOLEAN,
2402
    RULECONSIDERED VARCHAR(255),
2403
    CREATEDBY_ID INTEGER,
2404
    UPDATEDBY_ID INTEGER,
2405
    CITATION_ID INTEGER,
2406
    RELATEDFROM_ID INTEGER,
2407
    RELATEDTO_ID INTEGER,
2408
    TYPE_ID INTEGER
2409
);
2410
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_AUD;
2411
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION(
2412
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2413
    ANNOTATIONS_ID INTEGER NOT NULL
2414
);
2415
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_ANNOTATION;
2416
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD(
2417
    REV INTEGER NOT NULL,
2418
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2419
    ANNOTATIONS_ID INTEGER NOT NULL,
2420
    REVTYPE TINYINT
2421
);
2422
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD;
2423
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_MARKER(
2424
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2425
    MARKERS_ID INTEGER NOT NULL
2426
);
2427
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_MARKER;
2428
CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP_MARKER_AUD(
2429
    REV INTEGER NOT NULL,
2430
    NAMERELATIONSHIP_ID INTEGER NOT NULL,
2431
    MARKERS_ID INTEGER NOT NULL,
2432
    REVTYPE TINYINT
2433
);
2434
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NAMERELATIONSHIP_MARKER_AUD;
2435
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS(
2436
    ID INTEGER NOT NULL,
2437
    CREATED TIMESTAMP,
2438
    UUID VARCHAR(36),
2439
    UPDATED TIMESTAMP,
2440
    CITATIONMICROREFERENCE VARCHAR(255),
2441
    ORIGINALNAMESTRING VARCHAR(255),
2442
    RULECONSIDERED VARCHAR(255),
2443
    CREATEDBY_ID INTEGER,
2444
    UPDATEDBY_ID INTEGER,
2445
    CITATION_ID INTEGER,
2446
    TYPE_ID INTEGER
2447
);
2448
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS;
2449
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_AUD(
2450
    ID INTEGER NOT NULL,
2451
    REV INTEGER NOT NULL,
2452
    REVTYPE TINYINT,
2453
    CREATED TIMESTAMP,
2454
    UUID VARCHAR(36),
2455
    UPDATED TIMESTAMP,
2456
    CITATIONMICROREFERENCE VARCHAR(255),
2457
    ORIGINALNAMESTRING VARCHAR(255),
2458
    RULECONSIDERED VARCHAR(255),
2459
    CREATEDBY_ID INTEGER,
2460
    UPDATEDBY_ID INTEGER,
2461
    CITATION_ID INTEGER,
2462
    TYPE_ID INTEGER
2463
);
2464
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_AUD;
2465
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION(
2466
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
2467
    ANNOTATIONS_ID INTEGER NOT NULL
2468
);
2469
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_ANNOTATION;
2470
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD(
2471
    REV INTEGER NOT NULL,
2472
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
2473
    ANNOTATIONS_ID INTEGER NOT NULL,
2474
    REVTYPE TINYINT
2475
);
2476
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD;
2477
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER(
2478
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
2479
    MARKERS_ID INTEGER NOT NULL
2480
);
2481
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_MARKER;
2482
CREATE CACHED TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD(
2483
    REV INTEGER NOT NULL,
2484
    NOMENCLATURALSTATUS_ID INTEGER NOT NULL,
2485
    MARKERS_ID INTEGER NOT NULL,
2486
    REVTYPE TINYINT
2487
);
2488
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD;
2489
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE(
2490
    DTYPE VARCHAR(31) NOT NULL,
2491
    ID INTEGER NOT NULL,
2492
    CREATED TIMESTAMP,
2493
    UUID VARCHAR(36),
2494
    UPDATED TIMESTAMP,
2495
    SOURCETYPE INTEGER NOT NULL,
2496
    CITATIONMICROREFERENCE VARCHAR(255),
2497
    ORIGINALNAMESTRING VARCHAR(255),
2498
    IDINSOURCE VARCHAR(255),
2499
    IDNAMESPACE VARCHAR(255),
2500
    SOURCEDOBJ_TYPE VARCHAR(255),
2501
    SOURCEDOBJ_ID INTEGER NOT NULL,
2502
    CREATEDBY_ID INTEGER,
2503
    UPDATEDBY_ID INTEGER,
2504
    CITATION_ID INTEGER,
2505
    NAMEUSEDINSOURCE_ID INTEGER
2506
);
2507
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE;
2508
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_AUD(
2509
    DTYPE VARCHAR(31) NOT NULL,
2510
    ID INTEGER NOT NULL,
2511
    REV INTEGER NOT NULL,
2512
    REVTYPE TINYINT,
2513
    CREATED TIMESTAMP,
2514
    UUID VARCHAR(36),
2515
    UPDATED TIMESTAMP,
2516
           SOURCETYPE INTEGER NOT NULL,
2517
    CITATIONMICROREFERENCE VARCHAR(255),
2518
    ORIGINALNAMESTRING VARCHAR(255),
2519
    IDINSOURCE VARCHAR(255),
2520
    IDNAMESPACE VARCHAR(255),
2521
    CREATEDBY_ID INTEGER,
2522
    UPDATEDBY_ID INTEGER,
2523
    CITATION_ID INTEGER,
2524
    NAMEUSEDINSOURCE_ID INTEGER
2525
);
2526
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_AUD;
2527
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION(
2528
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
2529
    ANNOTATIONS_ID INTEGER NOT NULL
2530
);
2531
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_ANNOTATION;
2532
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD(
2533
    REV INTEGER NOT NULL,
2534
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
2535
    ANNOTATIONS_ID INTEGER NOT NULL,
2536
    REVTYPE TINYINT
2537
);
2538
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD;
2539
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER(
2540
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
2541
    MARKERS_ID INTEGER NOT NULL
2542
);
2543
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_MARKER;
2544
CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER_AUD(
2545
    REV INTEGER NOT NULL,
2546
    ORIGINALSOURCEBASE_ID INTEGER NOT NULL,
2547
    MARKERS_ID INTEGER NOT NULL,
2548
    REVTYPE TINYINT
2549
);
2550
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ORIGINALSOURCEBASE_MARKER_AUD;
2551
CREATE CACHED TABLE PUBLIC.PERMISSIONGROUP(
2552
    ID INTEGER NOT NULL,
2553
    CREATED TIMESTAMP,
2554
    UUID VARCHAR(36),
2555
    NAME VARCHAR(255),
2556
    CREATEDBY_ID INTEGER
2557
);
2558
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PERMISSIONGROUP;
2559
CREATE CACHED TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL(
2560
    PERMISSIONGROUP_ID INTEGER NOT NULL,
2561
    GRANTEDAUTHORITIES_ID INTEGER NOT NULL
2562
);
2563
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL;
2564
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY(
2565
    ID INTEGER NOT NULL,
2566
    CREATED TIMESTAMP,
2567
    UUID VARCHAR(36),
2568
    UPDATED TIMESTAMP,
2569
    LSID_AUTHORITY VARCHAR(255),
2570
    LSID_LSID VARCHAR(255),
2571
    LSID_NAMESPACE VARCHAR(255),
2572
    LSID_OBJECT VARCHAR(255),
2573
    LSID_REVISION VARCHAR(255),
2574
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
2575
    TITLECACHE VARCHAR(255),
2576
    CREATEDBY_ID INTEGER,
2577
    UPDATEDBY_ID INTEGER,
2578
    ROOT_ID INTEGER
2579
);
2580
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY;
2581
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE(
2582
    ID INTEGER NOT NULL,
2583
    CREATED TIMESTAMP,
2584
    UUID VARCHAR(36),
2585
    UPDATED TIMESTAMP,
2586
    NODENUMBER INTEGER,
2587
    SORTINDEX INTEGER,
2588
    CREATEDBY_ID INTEGER,
2589
    UPDATEDBY_ID INTEGER,
2590
    FEATURE_ID INTEGER,
2591
    KEY_ID INTEGER,
2592
    OTHERNODE_ID INTEGER,
2593
    PARENT_ID INTEGER,
2594
    QUESTION_ID INTEGER,
2595
    STATEMENT_ID INTEGER,
2596
    SUBKEY_ID INTEGER,
2597
    TAXON_ID INTEGER
2598
);
2599
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE;
2600
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_AUD(
2601
    ID INTEGER NOT NULL,
2602
    REV INTEGER NOT NULL,
2603
    REVTYPE TINYINT,
2604
    CREATED TIMESTAMP,
2605
    UUID VARCHAR(36),
2606
    UPDATED TIMESTAMP,
2607
    NODENUMBER INTEGER,
2608
    SORTINDEX INTEGER,
2609
    CREATEDBY_ID INTEGER,
2610
    UPDATEDBY_ID INTEGER,
2611
    FEATURE_ID INTEGER,
2612
    KEY_ID INTEGER,
2613
    OTHERNODE_ID INTEGER,
2614
    PARENT_ID INTEGER,
2615
    QUESTION_ID INTEGER,
2616
    STATEMENT_ID INTEGER,
2617
    SUBKEY_ID INTEGER,
2618
    TAXON_ID INTEGER
2619
);
2620
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_AUD;
2621
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING(
2622
    POLYTOMOUSKEYNODE_ID INTEGER NOT NULL,
2623
    MODIFYINGTEXT_ID INTEGER NOT NULL,
2624
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
2625
);
2626
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING;
2627
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD(
2628
    REV INTEGER NOT NULL,
2629
    POLYTOMOUSKEYNODE_ID INTEGER NOT NULL,
2630
    MODIFYINGTEXT_ID INTEGER NOT NULL,
2631
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
2632
    REVTYPE TINYINT
2633
);
2634
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD;
2635
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_AUD(
2636
    ID INTEGER NOT NULL,
2637
    REV INTEGER NOT NULL,
2638
    REVTYPE TINYINT,
2639
    CREATED TIMESTAMP,
2640
    UUID VARCHAR(36),
2641
    UPDATED TIMESTAMP,
2642
    LSID_AUTHORITY VARCHAR(255),
2643
    LSID_LSID VARCHAR(255),
2644
    LSID_NAMESPACE VARCHAR(255),
2645
    LSID_OBJECT VARCHAR(255),
2646
    LSID_REVISION VARCHAR(255),
2647
    PROTECTEDTITLECACHE BOOLEAN,
2648
    TITLECACHE VARCHAR(255),
2649
    CREATEDBY_ID INTEGER,
2650
    UPDATEDBY_ID INTEGER,
2651
    ROOT_ID INTEGER
2652
);
2653
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_AUD;
2654
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION(
2655
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2656
    ANNOTATIONS_ID INTEGER NOT NULL
2657
);
2658
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ANNOTATION;
2659
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD(
2660
    REV INTEGER NOT NULL,
2661
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2662
    ANNOTATIONS_ID INTEGER NOT NULL,
2663
    REVTYPE TINYINT
2664
);
2665
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD;
2666
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_CREDIT(
2667
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2668
    CREDITS_ID INTEGER NOT NULL,
2669
    SORTINDEX INTEGER NOT NULL
2670
);
2671
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_CREDIT;
2672
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_CREDIT_AUD(
2673
    REV INTEGER NOT NULL,
2674
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2675
    CREDITS_ID INTEGER NOT NULL,
2676
    SORTINDEX INTEGER NOT NULL,
2677
    REVTYPE TINYINT
2678
);
2679
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_CREDIT_AUD;
2680
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION(
2681
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2682
    EXTENSIONS_ID INTEGER NOT NULL
2683
);
2684
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_EXTENSION;
2685
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD(
2686
    REV INTEGER NOT NULL,
2687
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2688
    EXTENSIONS_ID INTEGER NOT NULL,
2689
    REVTYPE TINYINT
2690
);
2691
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD;
2692
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_MARKER(
2693
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2694
    MARKERS_ID INTEGER NOT NULL
2695
);
2696
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_MARKER;
2697
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_MARKER_AUD(
2698
    REV INTEGER NOT NULL,
2699
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2700
    MARKERS_ID INTEGER NOT NULL,
2701
    REVTYPE TINYINT
2702
);
2703
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_MARKER_AUD;
2704
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA(
2705
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2706
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL
2707
);
2708
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_NAMEDAREA;
2709
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD(
2710
    REV INTEGER NOT NULL,
2711
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2712
    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,
2713
    REVTYPE TINYINT
2714
);
2715
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD;
2716
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE(
2717
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2718
    SOURCES_ID INTEGER NOT NULL
2719
);
2720
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE;
2721
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD(
2722
    REV INTEGER NOT NULL,
2723
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2724
    SOURCES_ID INTEGER NOT NULL,
2725
    REVTYPE TINYINT
2726
);
2727
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD;
2728
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS(
2729
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2730
    RIGHTS_ID INTEGER NOT NULL
2731
);
2732
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_RIGHTS;
2733
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS_AUD(
2734
    REV INTEGER NOT NULL,
2735
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2736
    RIGHTS_ID INTEGER NOT NULL,
2737
    REVTYPE TINYINT
2738
);
2739
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_RIGHTS_AUD;
2740
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_SCOPE(
2741
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2742
    SCOPERESTRICTIONS_ID INTEGER NOT NULL
2743
);
2744
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_SCOPE;
2745
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_SCOPE_AUD(
2746
    REV INTEGER NOT NULL,
2747
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2748
    SCOPERESTRICTIONS_ID INTEGER NOT NULL,
2749
    REVTYPE TINYINT
2750
);
2751
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_SCOPE_AUD;
2752
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXON(
2753
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2754
    TAXON_ID INTEGER NOT NULL
2755
);
2756
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXON;
2757
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE(
2758
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2759
    COVEREDTAXA_ID INTEGER NOT NULL
2760
);
2761
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXONBASE;
2762
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD(
2763
    REV INTEGER NOT NULL,
2764
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2765
    COVEREDTAXA_ID INTEGER NOT NULL,
2766
    REVTYPE TINYINT
2767
);
2768
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD;
2769
CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXON_AUD(
2770
    REV INTEGER NOT NULL,
2771
    POLYTOMOUSKEY_ID INTEGER NOT NULL,
2772
    TAXON_ID INTEGER NOT NULL,
2773
    REVTYPE TINYINT
2774
);
2775
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXON_AUD;
2776
CREATE CACHED TABLE PUBLIC.REFERENCE(
2777
    DTYPE VARCHAR(31) NOT NULL,
2778
    ID INTEGER NOT NULL,
2779
    CREATED TIMESTAMP,
2780
    UUID VARCHAR(36),
2781
    UPDATED TIMESTAMP,
2782
    LSID_AUTHORITY VARCHAR(255),
2783
    LSID_LSID VARCHAR(255),
2784
    LSID_NAMESPACE VARCHAR(255),
2785
    LSID_OBJECT VARCHAR(255),
2786
    LSID_REVISION VARCHAR(255),
2787
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
2788
    TITLECACHE VARCHAR(255),
2789
    DATEPUBLISHED_END VARCHAR(255),
2790
    DATEPUBLISHED_FREETEXT VARCHAR(255),
2791
    DATEPUBLISHED_START VARCHAR(255),
2792
    EDITION VARCHAR(255),
2793
    EDITOR VARCHAR(255),
2794
    ISBN VARCHAR(255),
2795
    ISSN VARCHAR(255),
2796
    NOMENCLATURALLYRELEVANT BOOLEAN NOT NULL,
2797
    ORGANIZATION VARCHAR(255),
2798
    PAGES VARCHAR(255),
2799
    PARSINGPROBLEM INTEGER NOT NULL,
2800
    PLACEPUBLISHED VARCHAR(255),
2801
    PROBLEMENDS INTEGER NOT NULL,
2802
    PROBLEMSTARTS INTEGER NOT NULL,
2803
    PUBLISHER VARCHAR(255),
2804
    REFERENCEABSTRACT CLOB,
2805
    SERIES VARCHAR(255),
2806
    SERIESPART VARCHAR(255),
2807
    TITLE CLOB,
2808
    REFTYPE INTEGER,
2809
    URI CLOB, VARCHAR(255),
2810
    VOLUME VARCHAR(255),
2811
    CREATEDBY_ID INTEGER,
2812
    UPDATEDBY_ID INTEGER,
2813
    AUTHORTEAM_ID INTEGER,
2814
    INREFERENCE_ID INTEGER,
2815
    INSTITUTION_ID INTEGER,
2816
    SCHOOL_ID INTEGER
2817
);
2818
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE;
2819
CREATE INDEX PUBLIC.REFERENCETITLECACHEINDEX ON PUBLIC.REFERENCE(TITLECACHE);
2820
CREATE CACHED TABLE PUBLIC.REFERENCE_AUD(
2821
    DTYPE VARCHAR(31) NOT NULL,
2822
    ID INTEGER NOT NULL,
2823
    REV INTEGER NOT NULL,
2824
    REVTYPE TINYINT,
2825
    CREATED TIMESTAMP,
2826
    UUID VARCHAR(36),
2827
    UPDATED TIMESTAMP,
2828
    LSID_AUTHORITY VARCHAR(255),
2829
    LSID_LSID VARCHAR(255),
2830
    LSID_NAMESPACE VARCHAR(255),
2831
    LSID_OBJECT VARCHAR(255),
2832
    LSID_REVISION VARCHAR(255),
2833
    PROTECTEDTITLECACHE BOOLEAN,
2834
    TITLECACHE VARCHAR(255),
2835
    DATEPUBLISHED_END VARCHAR(255),
2836
    DATEPUBLISHED_FREETEXT VARCHAR(255),
2837
    DATEPUBLISHED_START VARCHAR(255),
2838
    EDITION VARCHAR(255),
2839
    EDITOR VARCHAR(255),
2840
    ISBN VARCHAR(255),
2841
    ISSN VARCHAR(255),
2842
    NOMENCLATURALLYRELEVANT BOOLEAN,
2843
    ORGANIZATION VARCHAR(255),
2844
    PAGES VARCHAR(255),
2845
    PARSINGPROBLEM INTEGER,
2846
    PLACEPUBLISHED VARCHAR(255),
2847
    PROBLEMENDS INTEGER,
2848
    PROBLEMSTARTS INTEGER,
2849
    PUBLISHER VARCHAR(255),
2850
    REFERENCEABSTRACT CLOB,
2851
    SERIES VARCHAR(255),
2852
    SERIESPART VARCHAR(255),
2853
    TITLE CLOB,
2854
    REFTYPE INTEGER,
2855
    URI CLOB,
2856
    VOLUME VARCHAR(255),
2857
    CREATEDBY_ID INTEGER,
2858
    UPDATEDBY_ID INTEGER,
2859
    AUTHORTEAM_ID INTEGER,
2860
    INREFERENCE_ID INTEGER,
2861
    INSTITUTION_ID INTEGER,
2862
    SCHOOL_ID INTEGER
2863
);
2864
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_AUD;
2865
CREATE CACHED TABLE PUBLIC.REFERENCE_ANNOTATION(
2866
    REFERENCE_ID INTEGER NOT NULL,
2867
    ANNOTATIONS_ID INTEGER NOT NULL
2868
);
2869
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ANNOTATION;
2870
CREATE CACHED TABLE PUBLIC.REFERENCE_ANNOTATION_AUD(
2871
    REV INTEGER NOT NULL,
2872
    REFERENCE_ID INTEGER NOT NULL,
2873
    ANNOTATIONS_ID INTEGER NOT NULL,
2874
    REVTYPE TINYINT
2875
);
2876
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ANNOTATION_AUD;
2877
CREATE CACHED TABLE PUBLIC.REFERENCE_CREDIT(
2878
    REFERENCE_ID INTEGER NOT NULL,
2879
    CREDITS_ID INTEGER NOT NULL,
2880
    SORTINDEX INTEGER NOT NULL
2881
);
2882
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_CREDIT;
2883
CREATE CACHED TABLE PUBLIC.REFERENCE_CREDIT_AUD(
2884
    REV INTEGER NOT NULL,
2885
    REFERENCE_ID INTEGER NOT NULL,
2886
    CREDITS_ID INTEGER NOT NULL,
2887
    SORTINDEX INTEGER NOT NULL,
2888
    REVTYPE TINYINT
2889
);
2890
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_CREDIT_AUD;
2891
CREATE CACHED TABLE PUBLIC.REFERENCE_EXTENSION(
2892
    REFERENCE_ID INTEGER NOT NULL,
2893
    EXTENSIONS_ID INTEGER NOT NULL
2894
);
2895
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_EXTENSION;
2896
CREATE CACHED TABLE PUBLIC.REFERENCE_EXTENSION_AUD(
2897
    REV INTEGER NOT NULL,
2898
    REFERENCE_ID INTEGER NOT NULL,
2899
    EXTENSIONS_ID INTEGER NOT NULL,
2900
    REVTYPE TINYINT
2901
);
2902
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_EXTENSION_AUD;
2903
CREATE CACHED TABLE PUBLIC.REFERENCE_MARKER(
2904
    REFERENCE_ID INTEGER NOT NULL,
2905
    MARKERS_ID INTEGER NOT NULL
2906
);
2907
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MARKER;
2908
CREATE CACHED TABLE PUBLIC.REFERENCE_MARKER_AUD(
2909
    REV INTEGER NOT NULL,
2910
    REFERENCE_ID INTEGER NOT NULL,
2911
    MARKERS_ID INTEGER NOT NULL,
2912
    REVTYPE TINYINT
2913
);
2914
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MARKER_AUD;
2915
CREATE CACHED TABLE PUBLIC.REFERENCE_MEDIA(
2916
    REFERENCE_ID INTEGER NOT NULL,
2917
    MEDIA_ID INTEGER NOT NULL
2918
);
2919
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MEDIA;
2920
CREATE CACHED TABLE PUBLIC.REFERENCE_MEDIA_AUD(
2921
    REV INTEGER NOT NULL,
2922
    REFERENCE_ID INTEGER NOT NULL,
2923
    MEDIA_ID INTEGER NOT NULL,
2924
    REVTYPE TINYINT
2925
);
2926
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_MEDIA_AUD;
2927
CREATE CACHED TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE(
2928
    REFERENCE_ID INTEGER NOT NULL,
2929
    SOURCES_ID INTEGER NOT NULL
2930
);
2931
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ORIGINALSOURCEBASE;
2932
CREATE CACHED TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD(
2933
    REV INTEGER NOT NULL,
2934
    REFERENCE_ID INTEGER NOT NULL,
2935
    SOURCES_ID INTEGER NOT NULL,
2936
    REVTYPE TINYINT
2937
);
2938
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD;
2939
CREATE CACHED TABLE PUBLIC.REFERENCE_RIGHTS(
2940
    REFERENCE_ID INTEGER NOT NULL,
2941
    RIGHTS_ID INTEGER NOT NULL
2942
);
2943
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTS;
2944
CREATE CACHED TABLE PUBLIC.REFERENCE_RIGHTS_AUD(
2945
    REV INTEGER NOT NULL,
2946
    REFERENCE_ID INTEGER NOT NULL,
2947
    RIGHTS_ID INTEGER NOT NULL,
2948
    REVTYPE TINYINT
2949
);
2950
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTS_AUD;
2951
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION(
2952
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
2953
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL
2954
);
2955
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION;
2956
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD(
2957
    REV INTEGER NOT NULL,
2958
    DEFINEDTERMBASE_ID INTEGER NOT NULL,
2959
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL,
2960
    REVTYPE TINYINT
2961
);
2962
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD;
2963
CREATE CACHED TABLE PUBLIC.REPRESENTATION(
2964
    ID INTEGER NOT NULL,
2965
    CREATED TIMESTAMP,
2966
    UUID VARCHAR(36),
2967
    UPDATED TIMESTAMP,
2968
    TEXT CLOB,
2969
    ABBREVIATEDLABEL VARCHAR(255),
2970
    LABEL VARCHAR(255),
2971
    CREATEDBY_ID INTEGER,
2972
    UPDATEDBY_ID INTEGER,
2973
    LANGUAGE_ID INTEGER
2974
);
2975
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION;
2976
CREATE CACHED TABLE PUBLIC.REPRESENTATION_AUD(
2977
    ID INTEGER NOT NULL,
2978
    REV INTEGER NOT NULL,
2979
    REVTYPE TINYINT,
2980
    CREATED TIMESTAMP,
2981
    UUID VARCHAR(36),
2982
    UPDATED TIMESTAMP,
2983
    TEXT CLOB,
2984
    ABBREVIATEDLABEL VARCHAR(255),
2985
    LABEL VARCHAR(255),
2986
    CREATEDBY_ID INTEGER,
2987
    UPDATEDBY_ID INTEGER,
2988
    LANGUAGE_ID INTEGER
2989
);
2990
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_AUD;
2991
CREATE CACHED TABLE PUBLIC.REPRESENTATION_ANNOTATION(
2992
    REPRESENTATION_ID INTEGER NOT NULL,
2993
    ANNOTATIONS_ID INTEGER NOT NULL
2994
);
2995
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION;
2996
CREATE CACHED TABLE PUBLIC.REPRESENTATION_ANNOTATION_AUD(
2997
    REV INTEGER NOT NULL,
2998
    REPRESENTATION_ID INTEGER NOT NULL,
2999
    ANNOTATIONS_ID INTEGER NOT NULL,
3000
    REVTYPE TINYINT
3001
);
3002
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION_AUD;
3003
CREATE CACHED TABLE PUBLIC.REPRESENTATION_MARKER(
3004
    REPRESENTATION_ID INTEGER NOT NULL,
3005
    MARKERS_ID INTEGER NOT NULL
3006
);
3007
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_MARKER;
3008
CREATE CACHED TABLE PUBLIC.REPRESENTATION_MARKER_AUD(
3009
    REV INTEGER NOT NULL,
3010
    REPRESENTATION_ID INTEGER NOT NULL,
3011
    MARKERS_ID INTEGER NOT NULL,
3012
    REVTYPE TINYINT
3013
);
3014
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_MARKER_AUD;
3015
CREATE CACHED TABLE PUBLIC.RIGHTS(
3016
    ID INTEGER NOT NULL,
3017
    CREATED TIMESTAMP,
3018
    UUID VARCHAR(36),
3019
    UPDATED TIMESTAMP,
3020
    TEXT CLOB,
3021
    ABBREVIATEDTEXT VARCHAR(255),
3022
    URI CLOB,
3023
    CREATEDBY_ID INTEGER,
3024
    UPDATEDBY_ID INTEGER,
3025
    LANGUAGE_ID INTEGER,
3026
    AGENT_ID INTEGER,
3027
    TYPE_ID INTEGER
3028
);
3029
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS;
3030
CREATE CACHED TABLE PUBLIC.RIGHTS_AUD(
3031
    ID INTEGER NOT NULL,
3032
    REV INTEGER NOT NULL,
3033
    REVTYPE TINYINT,
3034
    CREATED TIMESTAMP,
3035
    UUID VARCHAR(36),
3036
    UPDATED TIMESTAMP,
3037
    TEXT CLOB,
3038
    ABBREVIATEDTEXT VARCHAR(255),
3039
    URI CLOB,
3040
    CREATEDBY_ID INTEGER,
3041
    UPDATEDBY_ID INTEGER,
3042
    LANGUAGE_ID INTEGER,
3043
    AGENT_ID INTEGER,
3044
    TYPE_ID INTEGER
3045
);
3046
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_AUD;
3047
CREATE CACHED TABLE PUBLIC.RIGHTS_ANNOTATION(
3048
    RIGHTS_ID INTEGER NOT NULL,
3049
    ANNOTATIONS_ID INTEGER NOT NULL
3050
);
3051
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_ANNOTATION;
3052
CREATE CACHED TABLE PUBLIC.RIGHTS_ANNOTATION_AUD(
3053
    REV INTEGER NOT NULL,
3054
    RIGHTS_ID INTEGER NOT NULL,
3055
    ANNOTATIONS_ID INTEGER NOT NULL,
3056
    REVTYPE TINYINT
3057
);
3058
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_ANNOTATION_AUD;
3059
CREATE CACHED TABLE PUBLIC.RIGHTS_MARKER(
3060
    RIGHTS_ID INTEGER NOT NULL,
3061
    MARKERS_ID INTEGER NOT NULL
3062
);
3063
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_MARKER;
3064
CREATE CACHED TABLE PUBLIC.RIGHTS_MARKER_AUD(
3065
    REV INTEGER NOT NULL,
3066
    RIGHTS_ID INTEGER NOT NULL,
3067
    MARKERS_ID INTEGER NOT NULL,
3068
    REVTYPE TINYINT
3069
);
3070
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_MARKER_AUD;
3071
CREATE CACHED TABLE PUBLIC.SEQUENCE(
3072
    ID INTEGER NOT NULL,
3073
    CREATED TIMESTAMP,
3074
    UUID VARCHAR(36),
3075
    UPDATED TIMESTAMP,
3076
    LSID_AUTHORITY VARCHAR(255),
3077
    LSID_LSID VARCHAR(255),
3078
    LSID_NAMESPACE VARCHAR(255),
3079
    LSID_OBJECT VARCHAR(255),
3080
    LSID_REVISION VARCHAR(255),
3081
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3082
    TITLECACHE VARCHAR(255),
3083
    BARCODE BOOLEAN NOT NULL,
3084
    CITATIONMICROREFERENCE VARCHAR(255),
3085
    DATESEQUENCED TIMESTAMP,
3086
    LENGTH INTEGER,
3087
    SEQUENCE CLOB,
3088
    CREATEDBY_ID INTEGER,
3089
    UPDATEDBY_ID INTEGER,
3090
    LOCUS_ID INTEGER,
3091
    PUBLISHEDIN_ID INTEGER
3092
);
3093
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE;
3094
CREATE INDEX PUBLIC.SEQUENCETITLECACHEINDEX ON PUBLIC.SEQUENCE(TITLECACHE);
3095
CREATE CACHED TABLE PUBLIC.SEQUENCE_AUD(
3096
    ID INTEGER NOT NULL,
3097
    REV INTEGER NOT NULL,
3098
    REVTYPE TINYINT,
3099
    CREATED TIMESTAMP,
3100
    UUID VARCHAR(36),
3101
    UPDATED TIMESTAMP,
3102
    LSID_AUTHORITY VARCHAR(255),
3103
    LSID_LSID VARCHAR(255),
3104
    LSID_NAMESPACE VARCHAR(255),
3105
    LSID_OBJECT VARCHAR(255),
3106
    LSID_REVISION VARCHAR(255),
3107
    PROTECTEDTITLECACHE BOOLEAN,
3108
    TITLECACHE VARCHAR(255),
3109
    BARCODE BOOLEAN,
3110
    CITATIONMICROREFERENCE VARCHAR(255),
3111
    DATESEQUENCED TIMESTAMP,
3112
    LENGTH INTEGER,
3113
    SEQUENCE CLOB,
3114
    CREATEDBY_ID INTEGER,
3115
    UPDATEDBY_ID INTEGER,
3116
    LOCUS_ID INTEGER,
3117
    PUBLISHEDIN_ID INTEGER
3118
);
3119
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_AUD;
3120
CREATE CACHED TABLE PUBLIC.SEQUENCE_ANNOTATION(
3121
    SEQUENCE_ID INTEGER NOT NULL,
3122
    ANNOTATIONS_ID INTEGER NOT NULL
3123
);
3124
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ANNOTATION;
3125
CREATE CACHED TABLE PUBLIC.SEQUENCE_ANNOTATION_AUD(
3126
    REV INTEGER NOT NULL,
3127
    SEQUENCE_ID INTEGER NOT NULL,
3128
    ANNOTATIONS_ID INTEGER NOT NULL,
3129
    REVTYPE TINYINT
3130
);
3131
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ANNOTATION_AUD;
3132
CREATE CACHED TABLE PUBLIC.SEQUENCE_CREDIT(
3133
    SEQUENCE_ID INTEGER NOT NULL,
3134
    CREDITS_ID INTEGER NOT NULL,
3135
    SORTINDEX INTEGER NOT NULL
3136
);
3137
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_CREDIT;
3138
CREATE CACHED TABLE PUBLIC.SEQUENCE_CREDIT_AUD(
3139
    REV INTEGER NOT NULL,
3140
    SEQUENCE_ID INTEGER NOT NULL,
3141
    CREDITS_ID INTEGER NOT NULL,
3142
    SORTINDEX INTEGER NOT NULL,
3143
    REVTYPE TINYINT
3144
);
3145
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_CREDIT_AUD;
3146
CREATE CACHED TABLE PUBLIC.SEQUENCE_EXTENSION(
3147
    SEQUENCE_ID INTEGER NOT NULL,
3148
    EXTENSIONS_ID INTEGER NOT NULL
3149
);
3150
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION;
3151
CREATE CACHED TABLE PUBLIC.SEQUENCE_EXTENSION_AUD(
3152
    REV INTEGER NOT NULL,
3153
    SEQUENCE_ID INTEGER NOT NULL,
3154
    EXTENSIONS_ID INTEGER NOT NULL,
3155
    REVTYPE TINYINT
3156
);
3157
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION_AUD;
3158
CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION(
3159
    SEQUENCE_ID INTEGER NOT NULL,
3160
    GENBANKACCESSION_ID INTEGER NOT NULL
3161
);
3162
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION;
3163
CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD(
3164
    REV INTEGER NOT NULL,
3165
    SEQUENCE_ID INTEGER NOT NULL,
3166
    GENBANKACCESSION_ID INTEGER NOT NULL,
3167
    REVTYPE TINYINT
3168
);
3169
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION_AUD;
3170
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER(
3171
    SEQUENCE_ID INTEGER NOT NULL,
3172
    MARKERS_ID INTEGER NOT NULL
3173
);
3174
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MARKER;
3175
CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER_AUD(
3176
    REV INTEGER NOT NULL,
3177
    SEQUENCE_ID INTEGER NOT NULL,
3178
    MARKERS_ID INTEGER NOT NULL,
3179
    REVTYPE TINYINT
3180
);
3181
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MARKER_AUD;
3182
CREATE CACHED TABLE PUBLIC.SEQUENCE_MEDIA(
3183
    SEQUENCE_ID INTEGER NOT NULL,
3184
    CHROMATOGRAMS_ID INTEGER NOT NULL
3185
);
3186
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MEDIA;
3187
CREATE CACHED TABLE PUBLIC.SEQUENCE_MEDIA_AUD(
3188
    REV INTEGER NOT NULL,
3189
    SEQUENCE_ID INTEGER NOT NULL,
3190
    CHROMATOGRAMS_ID INTEGER NOT NULL,
3191
    REVTYPE TINYINT
3192
);
3193
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MEDIA_AUD;
3194
CREATE CACHED TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE(
3195
    SEQUENCE_ID INTEGER NOT NULL,
3196
    SOURCES_ID INTEGER NOT NULL
3197
);
3198
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ORIGINALSOURCEBASE;
3199
CREATE CACHED TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD(
3200
    REV INTEGER NOT NULL,
3201
    SEQUENCE_ID INTEGER NOT NULL,
3202
    SOURCES_ID INTEGER NOT NULL,
3203
    REVTYPE TINYINT
3204
);
3205
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD;
3206
CREATE CACHED TABLE PUBLIC.SEQUENCE_REFERENCE(
3207
    SEQUENCE_ID INTEGER NOT NULL,
3208
    CITATIONS_ID INTEGER NOT NULL
3209
);
3210
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_REFERENCE;
3211
CREATE CACHED TABLE PUBLIC.SEQUENCE_REFERENCE_AUD(
3212
    REV INTEGER NOT NULL,
3213
    SEQUENCE_ID INTEGER NOT NULL,
3214
    CITATIONS_ID INTEGER NOT NULL,
3215
    REVTYPE TINYINT
3216
);
3217
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_REFERENCE_AUD;
3218
CREATE CACHED TABLE PUBLIC.SEQUENCE_RIGHTS(
3219
    SEQUENCE_ID INTEGER NOT NULL,
3220
    RIGHTS_ID INTEGER NOT NULL
3221
);
3222
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_RIGHTS;
3223
CREATE CACHED TABLE PUBLIC.SEQUENCE_RIGHTS_AUD(
3224
    REV INTEGER NOT NULL,
3225
    SEQUENCE_ID INTEGER NOT NULL,
3226
    RIGHTS_ID INTEGER NOT NULL,
3227
    REVTYPE TINYINT
3228
);
3229
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_RIGHTS_AUD;
3230
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE(
3231
    DTYPE VARCHAR(31) NOT NULL,
3232
    ID INTEGER NOT NULL,
3233
    CREATED TIMESTAMP,
3234
    UUID VARCHAR(36),
3235
    UPDATED TIMESTAMP,
3236
    LSID_AUTHORITY VARCHAR(255),
3237
    LSID_LSID VARCHAR(255),
3238
    LSID_NAMESPACE VARCHAR(255),
3239
    LSID_OBJECT VARCHAR(255),
3240
    LSID_REVISION VARCHAR(255),
3241
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3242
    TITLECACHE VARCHAR(255),
3243
    INDIVIDUALCOUNT INTEGER,
3244
    ACCESSIONNUMBER VARCHAR(255),
3245
    BARCODE VARCHAR(255),
3246
    CATALOGNUMBER VARCHAR(255),
3247
    COLLECTORSNUMBER VARCHAR(255),
3248
    EXSICCATUM VARCHAR(255),
3249
    FIELDNOTES VARCHAR(255),
3250
    FIELDNUMBER VARCHAR(255),
3251
    CREATEDBY_ID INTEGER,
3252
    UPDATEDBY_ID INTEGER,
3253
    LIFESTAGE_ID INTEGER,
3254
    SEX_ID INTEGER,
3255
    COLLECTION_ID INTEGER,
3256
    DERIVEDFROM_ID INTEGER,
3257
    STOREDUNDER_ID INTEGER,
3258
    PRESERVATION_ID INTEGER,
3259
    GATHERINGEVENT_ID INTEGER,
3260
    PRIMARYCOLLECTOR_ID INTEGER
3261
);
3262
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE;
3263
CREATE INDEX PUBLIC.SPECIMENOROBSERVATIONBASETITLECACHEINDEX ON PUBLIC.SPECIMENOROBSERVATIONBASE(TITLECACHE);
3264
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD(
3265
    DTYPE VARCHAR(31) NOT NULL,
3266
    ID INTEGER NOT NULL,
3267
    REV INTEGER NOT NULL,
3268
    REVTYPE TINYINT,
3269
    CREATED TIMESTAMP,
3270
    UUID VARCHAR(36),
3271
    UPDATED TIMESTAMP,
3272
    LSID_AUTHORITY VARCHAR(255),
3273
    LSID_LSID VARCHAR(255),
3274
    LSID_NAMESPACE VARCHAR(255),
3275
    LSID_OBJECT VARCHAR(255),
3276
    LSID_REVISION VARCHAR(255),
3277
    PROTECTEDTITLECACHE BOOLEAN,
3278
    TITLECACHE VARCHAR(255),
3279
    INDIVIDUALCOUNT INTEGER,
3280
    CREATEDBY_ID INTEGER,
3281
    UPDATEDBY_ID INTEGER,
3282
    LIFESTAGE_ID INTEGER,
3283
    SEX_ID INTEGER,
3284
    ACCESSIONNUMBER VARCHAR(255),
3285
    BARCODE VARCHAR(255),
3286
    CATALOGNUMBER VARCHAR(255),
3287
    COLLECTORSNUMBER VARCHAR(255),
3288
    COLLECTION_ID INTEGER,
3289
    DERIVEDFROM_ID INTEGER,
3290
    STOREDUNDER_ID INTEGER,
3291
    EXSICCATUM VARCHAR(255),
3292
    PRESERVATION_ID INTEGER,
3293
    FIELDNOTES VARCHAR(255),
3294
    FIELDNUMBER VARCHAR(255),
3295
    GATHERINGEVENT_ID INTEGER,
3296
    PRIMARYCOLLECTOR_ID INTEGER
3297
);
3298
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_AUD;
3299
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION(
3300
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3301
    ANNOTATIONS_ID INTEGER NOT NULL
3302
);
3303
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION;
3304
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD(
3305
    REV INTEGER NOT NULL,
3306
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3307
    ANNOTATIONS_ID INTEGER NOT NULL,
3308
    REVTYPE TINYINT
3309
);
3310
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD;
3311
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT(
3312
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3313
    CREDITS_ID INTEGER NOT NULL,
3314
    SORTINDEX INTEGER NOT NULL
3315
);
3316
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT;
3317
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD(
3318
    REV INTEGER NOT NULL,
3319
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3320
    CREDITS_ID INTEGER NOT NULL,
3321
    SORTINDEX INTEGER NOT NULL,
3322
    REVTYPE TINYINT
3323
);
3324
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD;
3325
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT(
3326
    ORIGINALS_ID INTEGER NOT NULL,
3327
    DERIVATIONEVENTS_ID INTEGER NOT NULL
3328
);
3329
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT;
3330
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD(
3331
    REV INTEGER NOT NULL,
3332
    ORIGINALS_ID INTEGER NOT NULL,
3333
    DERIVATIONEVENTS_ID INTEGER NOT NULL,
3334
    REVTYPE TINYINT
3335
);
3336
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD;
3337
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION(
3338
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3339
    EXTENSIONS_ID INTEGER NOT NULL
3340
);
3341
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION;
3342
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD(
3343
    REV INTEGER NOT NULL,
3344
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3345
    EXTENSIONS_ID INTEGER NOT NULL,
3346
    REVTYPE TINYINT
3347
);
3348
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD;
3349
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING(
3350
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3351
    DEFINITION_ID INTEGER NOT NULL,
3352
    DEFINITION_MAPKEY_ID INTEGER NOT NULL
3353
);
3354
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING;
3355
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD(
3356
    REV INTEGER NOT NULL,
3357
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3358
    DEFINITION_ID INTEGER NOT NULL,
3359
    DEFINITION_MAPKEY_ID INTEGER NOT NULL,
3360
    REVTYPE TINYINT
3361
);
3362
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD;
3363
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER(
3364
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3365
    MARKERS_ID INTEGER NOT NULL
3366
);
3367
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER;
3368
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD(
3369
    REV INTEGER NOT NULL,
3370
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3371
    MARKERS_ID INTEGER NOT NULL,
3372
    REVTYPE TINYINT
3373
);
3374
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD;
3375
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA(
3376
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3377
    MEDIA_ID INTEGER NOT NULL
3378
);
3379
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA;
3380
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD(
3381
    REV INTEGER NOT NULL,
3382
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3383
    MEDIA_ID INTEGER NOT NULL,
3384
    REVTYPE TINYINT
3385
);
3386
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD;
3387
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE(
3388
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3389
    SOURCES_ID INTEGER NOT NULL
3390
);
3391
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE;
3392
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD(
3393
    REV INTEGER NOT NULL,
3394
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3395
    SOURCES_ID INTEGER NOT NULL,
3396
    REVTYPE TINYINT
3397
);
3398
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD;
3399
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS(
3400
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3401
    RIGHTS_ID INTEGER NOT NULL
3402
);
3403
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS;
3404
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD(
3405
    REV INTEGER NOT NULL,
3406
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3407
    RIGHTS_ID INTEGER NOT NULL,
3408
    REVTYPE TINYINT
3409
);
3410
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD;
3411
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE(
3412
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3413
    SEQUENCES_ID INTEGER NOT NULL
3414
);
3415
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE;
3416
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD(
3417
    REV INTEGER NOT NULL,
3418
    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
3419
    SEQUENCES_ID INTEGER NOT NULL,
3420
    REVTYPE TINYINT
3421
);
3422
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD;
3423
CREATE CACHED TABLE PUBLIC.STATEDATA(
3424
    ID INTEGER NOT NULL,
3425
    CREATED TIMESTAMP,
3426
    UUID VARCHAR(36),
3427
    UPDATED TIMESTAMP,
3428
    CREATEDBY_ID INTEGER,
3429
    UPDATEDBY_ID INTEGER,
3430
    STATE_ID INTEGER
3431
);
3432
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA;
3433
CREATE CACHED TABLE PUBLIC.STATEDATA_AUD(
3434
    ID INTEGER NOT NULL,
3435
    REV INTEGER NOT NULL,
3436
    REVTYPE TINYINT,
3437
    CREATED TIMESTAMP,
3438
    UUID VARCHAR(36),
3439
    UPDATED TIMESTAMP,
3440
    CREATEDBY_ID INTEGER,
3441
    UPDATEDBY_ID INTEGER,
3442
    STATE_ID INTEGER
3443
);
3444
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_AUD;
3445
CREATE CACHED TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE(
3446
    STATEDATA_ID INTEGER NOT NULL,
3447
    MODIFIERS_ID INTEGER NOT NULL
3448
);
3449
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_DEFINEDTERMBASE;
3450
CREATE CACHED TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD(
3451
    REV INTEGER NOT NULL,
3452
    STATEDATA_ID INTEGER NOT NULL,
3453
    MODIFIERS_ID INTEGER NOT NULL,
3454
    REVTYPE TINYINT
3455
);
3456
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD;
3457
CREATE CACHED TABLE PUBLIC.STATEDATA_LANGUAGESTRING(
3458
    STATEDATA_ID INTEGER NOT NULL,
3459
    MODIFYINGTEXT_ID INTEGER NOT NULL,
3460
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL
3461
);
3462
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_LANGUAGESTRING;
3463
CREATE CACHED TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD(
3464
    REV INTEGER NOT NULL,
3465
    STATEDATA_ID INTEGER NOT NULL,
3466
    MODIFYINGTEXT_ID INTEGER NOT NULL,
3467
    MODIFYINGTEXT_MAPKEY_ID INTEGER NOT NULL,
3468
    REVTYPE TINYINT
3469
);
3470
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_LANGUAGESTRING_AUD;
3471
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE(
3472
    ID INTEGER NOT NULL,
3473
    CREATED TIMESTAMP,
3474
    UUID VARCHAR(36),
3475
    UPDATED TIMESTAMP,
3476
    VALUE DOUBLE NOT NULL,
3477
    CREATEDBY_ID INTEGER,
3478
    UPDATEDBY_ID INTEGER,
3479
    TYPE_ID INTEGER
3480
);
3481
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE;
3482
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD(
3483
    ID INTEGER NOT NULL,
3484
    REV INTEGER NOT NULL,
3485
    REVTYPE TINYINT,
3486
    CREATED TIMESTAMP,
3487
    UUID VARCHAR(36),
3488
    UPDATED TIMESTAMP,
3489
    VALUE DOUBLE,
3490
    CREATEDBY_ID INTEGER,
3491
    UPDATEDBY_ID INTEGER,
3492
    TYPE_ID INTEGER
3493
);
3494
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_AUD;
3495
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE(
3496
    STATISTICALMEASUREMENTVALUE_ID INTEGER NOT NULL,
3497
    MODIFIERS_ID INTEGER NOT NULL
3498
);
3499
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE;
3500
CREATE CACHED TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD(
3501
    REV INTEGER NOT NULL,
3502
    STATISTICALMEASUREMENTVALUE_ID INTEGER NOT NULL,
3503
    MODIFIERS_ID INTEGER NOT NULL,
3504
    REVTYPE TINYINT
3505
);
3506
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD;
3507
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP(
3508
    ID INTEGER NOT NULL,
3509
    CREATED TIMESTAMP,
3510
    UUID VARCHAR(36),
3511
    UPDATED TIMESTAMP,
3512
    CITATIONMICROREFERENCE VARCHAR(255),
3513
    ORIGINALNAMESTRING VARCHAR(255),
3514
    DOUBTFUL BOOLEAN NOT NULL,
3515
    PARTIAL BOOLEAN NOT NULL,
3516
    PROPARTE BOOLEAN NOT NULL,
3517
    CREATEDBY_ID INTEGER,
3518
    UPDATEDBY_ID INTEGER,
3519
    CITATION_ID INTEGER,
3520
    RELATEDFROM_ID INTEGER,
3521
    RELATEDTO_ID INTEGER,
3522
    TYPE_ID INTEGER
3523
);
3524
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP;
3525
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_AUD(
3526
    ID INTEGER NOT NULL,
3527
    REV INTEGER NOT NULL,
3528
    REVTYPE TINYINT,
3529
    CREATED TIMESTAMP,
3530
    UUID VARCHAR(36),
3531
    UPDATED TIMESTAMP,
3532
    CITATIONMICROREFERENCE VARCHAR(255),
3533
    ORIGINALNAMESTRING VARCHAR(255),
3534
    DOUBTFUL BOOLEAN,
3535
    PARTIAL BOOLEAN,
3536
    PROPARTE BOOLEAN,
3537
    CREATEDBY_ID INTEGER,
3538
    UPDATEDBY_ID INTEGER,
3539
    CITATION_ID INTEGER,
3540
    RELATEDFROM_ID INTEGER,
3541
    RELATEDTO_ID INTEGER,
3542
    TYPE_ID INTEGER
3543
);
3544
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_AUD;
3545
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION(
3546
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3547
    ANNOTATIONS_ID INTEGER NOT NULL
3548
);
3549
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION;
3550
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION_AUD(
3551
    REV INTEGER NOT NULL,
3552
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3553
    ANNOTATIONS_ID INTEGER NOT NULL,
3554
    REVTYPE TINYINT
3555
);
3556
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION_AUD;
3557
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER(
3558
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3559
    MARKERS_ID INTEGER NOT NULL
3560
);
3561
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_MARKER;
3562
CREATE CACHED TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER_AUD(
3563
    REV INTEGER NOT NULL,
3564
    SYNONYMRELATIONSHIP_ID INTEGER NOT NULL,
3565
    MARKERS_ID INTEGER NOT NULL,
3566
    REVTYPE TINYINT
3567
);
3568
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SYNONYMRELATIONSHIP_MARKER_AUD;
3569
CREATE CACHED TABLE PUBLIC.TAXONBASE(
3570
    DTYPE VARCHAR(31) NOT NULL,
3571
    ID INTEGER NOT NULL,
3572
    CREATED TIMESTAMP,
3573
    UUID VARCHAR(36),
3574
    UPDATED TIMESTAMP,
3575
    LSID_AUTHORITY VARCHAR(255),
3576
    LSID_LSID VARCHAR(255),
3577
    LSID_NAMESPACE VARCHAR(255),
3578
    LSID_OBJECT VARCHAR(255),
3579
    LSID_REVISION VARCHAR(255),
3580
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3581
    TITLECACHE VARCHAR(255),
3582
    APPENDEDPHRASE VARCHAR(255),
3583
    DOUBTFUL BOOLEAN NOT NULL,
3584
    USENAMECACHE BOOLEAN NOT NULL,
3585
    EXCLUDED BOOLEAN,
3586
    TAXONSTATUSUNKNOWN BOOLEAN,
3587
    TAXONOMICCHILDRENCOUNT INTEGER,
3588
    UNPLACED BOOLEAN,
3589
    CREATEDBY_ID INTEGER,
3590
    UPDATEDBY_ID INTEGER,
3591
    NAME_ID INTEGER,
3592
    SEC_ID INTEGER,
3593
    TAXONOMICPARENTCACHE_ID INTEGER
3594
);
3595
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE;
3596
CREATE INDEX PUBLIC.TAXONBASETITLECACHEINDEX ON PUBLIC.TAXONBASE(TITLECACHE);
3597
CREATE CACHED TABLE PUBLIC.TAXONBASE_AUD(
3598
    DTYPE VARCHAR(31) NOT NULL,
3599
    ID INTEGER NOT NULL,
3600
    REV INTEGER NOT NULL,
3601
    REVTYPE TINYINT,
3602
    CREATED TIMESTAMP,
3603
    UUID VARCHAR(36),
3604
    UPDATED TIMESTAMP,
3605
    LSID_AUTHORITY VARCHAR(255),
3606
    LSID_LSID VARCHAR(255),
3607
    LSID_NAMESPACE VARCHAR(255),
3608
    LSID_OBJECT VARCHAR(255),
3609
    LSID_REVISION VARCHAR(255),
3610
    PROTECTEDTITLECACHE BOOLEAN,
3611
    TITLECACHE VARCHAR(255),
3612
    APPENDEDPHRASE VARCHAR(255),
3613
    DOUBTFUL BOOLEAN,
3614
    USENAMECACHE BOOLEAN,
3615
    CREATEDBY_ID INTEGER,
3616
    UPDATEDBY_ID INTEGER,
3617
    NAME_ID INTEGER,
3618
    SEC_ID INTEGER,
3619
    EXCLUDED BOOLEAN,
3620
    TAXONSTATUSUNKNOWN BOOLEAN,
3621
    TAXONOMICCHILDRENCOUNT INTEGER,
3622
    UNPLACED BOOLEAN,
3623
    TAXONOMICPARENTCACHE_ID INTEGER
3624
);
3625
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_AUD;
3626
CREATE CACHED TABLE PUBLIC.TAXONBASE_ANNOTATION(
3627
    TAXONBASE_ID INTEGER NOT NULL,
3628
    ANNOTATIONS_ID INTEGER NOT NULL
3629
);
3630
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ANNOTATION;
3631
CREATE CACHED TABLE PUBLIC.TAXONBASE_ANNOTATION_AUD(
3632
    REV INTEGER NOT NULL,
3633
    TAXONBASE_ID INTEGER NOT NULL,
3634
    ANNOTATIONS_ID INTEGER NOT NULL,
3635
    REVTYPE TINYINT
3636
);
3637
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ANNOTATION_AUD;
3638
CREATE CACHED TABLE PUBLIC.TAXONBASE_CREDIT(
3639
    TAXONBASE_ID INTEGER NOT NULL,
3640
    CREDITS_ID INTEGER NOT NULL,
3641
    SORTINDEX INTEGER NOT NULL
3642
);
3643
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_CREDIT;
3644
CREATE CACHED TABLE PUBLIC.TAXONBASE_CREDIT_AUD(
3645
    REV INTEGER NOT NULL,
3646
    TAXONBASE_ID INTEGER NOT NULL,
3647
    CREDITS_ID INTEGER NOT NULL,
3648
    SORTINDEX INTEGER NOT NULL,
3649
    REVTYPE TINYINT
3650
);
3651
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_CREDIT_AUD;
3652
CREATE CACHED TABLE PUBLIC.TAXONBASE_EXTENSION(
3653
    TAXONBASE_ID INTEGER NOT NULL,
3654
    EXTENSIONS_ID INTEGER NOT NULL
3655
);
3656
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_EXTENSION;
3657
CREATE CACHED TABLE PUBLIC.TAXONBASE_EXTENSION_AUD(
3658
    REV INTEGER NOT NULL,
3659
    TAXONBASE_ID INTEGER NOT NULL,
3660
    EXTENSIONS_ID INTEGER NOT NULL,
3661
    REVTYPE TINYINT
3662
);
3663
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_EXTENSION_AUD;
3664
CREATE CACHED TABLE PUBLIC.TAXONBASE_MARKER(
3665
    TAXONBASE_ID INTEGER NOT NULL,
3666
    MARKERS_ID INTEGER NOT NULL
3667
);
3668
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_MARKER;
3669
CREATE CACHED TABLE PUBLIC.TAXONBASE_MARKER_AUD(
3670
    REV INTEGER NOT NULL,
3671
    TAXONBASE_ID INTEGER NOT NULL,
3672
    MARKERS_ID INTEGER NOT NULL,
3673
    REVTYPE TINYINT
3674
);
3675
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_MARKER_AUD;
3676
CREATE CACHED TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE(
3677
    TAXONBASE_ID INTEGER NOT NULL,
3678
    SOURCES_ID INTEGER NOT NULL
3679
);
3680
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ORIGINALSOURCEBASE;
3681
CREATE CACHED TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE_AUD(
3682
    REV INTEGER NOT NULL,
3683
    TAXONBASE_ID INTEGER NOT NULL,
3684
    SOURCES_ID INTEGER NOT NULL,
3685
    REVTYPE TINYINT
3686
);
3687
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_ORIGINALSOURCEBASE_AUD;
3688
CREATE CACHED TABLE PUBLIC.TAXONBASE_RIGHTS(
3689
    TAXONBASE_ID INTEGER NOT NULL,
3690
    RIGHTS_ID INTEGER NOT NULL
3691
);
3692
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_RIGHTS;
3693
CREATE CACHED TABLE PUBLIC.TAXONBASE_RIGHTS_AUD(
3694
    REV INTEGER NOT NULL,
3695
    TAXONBASE_ID INTEGER NOT NULL,
3696
    RIGHTS_ID INTEGER NOT NULL,
3697
    REVTYPE TINYINT
3698
);
3699
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_RIGHTS_AUD;
3700
CREATE CACHED TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING(
3701
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
3702
    DESCRIPTION_ID INTEGER NOT NULL,
3703
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL
3704
);
3705
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONINTERACTION_LANGUAGESTRING;
3706
CREATE CACHED TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD(
3707
    REV INTEGER NOT NULL,
3708
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
3709
    DESCRIPTION_ID INTEGER NOT NULL,
3710
    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,
3711
    REVTYPE TINYINT
3712
);
3713
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD;
3714
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE(
3715
    DTYPE VARCHAR(31) NOT NULL,
3716
    ID INTEGER NOT NULL,
3717
    CREATED TIMESTAMP,
3718
    UUID VARCHAR(36),
3719
    UPDATED TIMESTAMP,
3720
    LSID_AUTHORITY VARCHAR(255),
3721
    LSID_LSID VARCHAR(255),
3722
    LSID_NAMESPACE VARCHAR(255),
3723
    LSID_OBJECT VARCHAR(255),
3724
    LSID_REVISION VARCHAR(255),
3725
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3726
    TITLECACHE VARCHAR(255),
3727
    APPENDEDPHRASE VARCHAR(255),
3728
    FULLTITLECACHE VARCHAR(330),
3729
    NOMENCLATURALMICROREFERENCE VARCHAR(255),
3730
    PARSINGPROBLEM INTEGER NOT NULL,
3731
    PROBLEMENDS INTEGER NOT NULL,
3732
    PROBLEMSTARTS INTEGER NOT NULL,
3733
    PROTECTEDFULLTITLECACHE BOOLEAN NOT NULL,
3734
    AUTHORSHIPCACHE VARCHAR(255),
3735
    BINOMHYBRID BOOLEAN,
3736
    GENUSORUNINOMIAL VARCHAR(255),
3737
    HYBRIDFORMULA BOOLEAN,
3738
    INFRAGENERICEPITHET VARCHAR(255),
3739
    INFRASPECIFICEPITHET VARCHAR(255),
3740
    MONOMHYBRID BOOLEAN,
3741
    NAMECACHE VARCHAR(255),
3742
    PROTECTEDAUTHORSHIPCACHE BOOLEAN,
3743
    PROTECTEDNAMECACHE BOOLEAN,
3744
    SPECIFICEPITHET VARCHAR(255),
3745
    TRINOMHYBRID BOOLEAN,
3746
    NAMEAPPROBATION VARCHAR(255),
3747
    SUBGENUSAUTHORSHIP VARCHAR(255),
3748
    ANAMORPHIC BOOLEAN,
3749
    CULTIVARNAME VARCHAR(255),
3750
    ACRONYM VARCHAR(255),
3751
    BREED VARCHAR(255),
3752
    ORIGINALPUBLICATIONYEAR INTEGER,
3753
    PUBLICATIONYEAR INTEGER,
3754
    CREATEDBY_ID INTEGER,
3755
    UPDATEDBY_ID INTEGER,
3756
    HOMOTYPICALGROUP_ID INTEGER,
3757
    NOMENCLATURALREFERENCE_ID INTEGER,
3758
    RANK_ID INTEGER,
3759
    BASIONYMAUTHORTEAM_ID INTEGER,
3760
    COMBINATIONAUTHORTEAM_ID INTEGER,
3761
    EXBASIONYMAUTHORTEAM_ID INTEGER,
3762
    EXCOMBINATIONAUTHORTEAM_ID INTEGER
3763
);
3764
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE;
3765
CREATE INDEX PUBLIC.TAXONNAMEBASETITLECACHEINDEX ON PUBLIC.TAXONNAMEBASE(TITLECACHE);
3766
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_AUD(
3767
    DTYPE VARCHAR(31) NOT NULL,
3768
    ID INTEGER NOT NULL,
3769
    REV INTEGER NOT NULL,
3770
    REVTYPE TINYINT,
3771
    CREATED TIMESTAMP,
3772
    UUID VARCHAR(36),
3773
    UPDATED TIMESTAMP,
3774
    LSID_AUTHORITY VARCHAR(255),
3775
    LSID_LSID VARCHAR(255),
3776
    LSID_NAMESPACE VARCHAR(255),
3777
    LSID_OBJECT VARCHAR(255),
3778
    LSID_REVISION VARCHAR(255),
3779
    PROTECTEDTITLECACHE BOOLEAN,
3780
    TITLECACHE VARCHAR(255),
3781
    APPENDEDPHRASE VARCHAR(255),
3782
    FULLTITLECACHE VARCHAR(330),
3783
    NOMENCLATURALMICROREFERENCE VARCHAR(255),
3784
    PARSINGPROBLEM INTEGER,
3785
    PROBLEMENDS INTEGER,
3786
    PROBLEMSTARTS INTEGER,
3787
    PROTECTEDFULLTITLECACHE BOOLEAN,
3788
    CREATEDBY_ID INTEGER,
3789
    UPDATEDBY_ID INTEGER,
3790
    HOMOTYPICALGROUP_ID INTEGER,
3791
    NOMENCLATURALREFERENCE_ID INTEGER,
3792
    RANK_ID INTEGER,
3793
    ACRONYM VARCHAR(255),
3794
    AUTHORSHIPCACHE VARCHAR(255),
3795
    BINOMHYBRID BOOLEAN,
3796
    GENUSORUNINOMIAL VARCHAR(255),
3797
    HYBRIDFORMULA BOOLEAN,
3798
    INFRAGENERICEPITHET VARCHAR(255),
3799
    INFRASPECIFICEPITHET VARCHAR(255),
3800
    MONOMHYBRID BOOLEAN,
3801
    NAMECACHE VARCHAR(255),
3802
    PROTECTEDAUTHORSHIPCACHE BOOLEAN,
3803
    PROTECTEDNAMECACHE BOOLEAN,
3804
    SPECIFICEPITHET VARCHAR(255),
3805
    TRINOMHYBRID BOOLEAN,
3806
    BASIONYMAUTHORTEAM_ID INTEGER,
3807
    COMBINATIONAUTHORTEAM_ID INTEGER,
3808
    EXBASIONYMAUTHORTEAM_ID INTEGER,
3809
    EXCOMBINATIONAUTHORTEAM_ID INTEGER,
3810
    ANAMORPHIC BOOLEAN,
3811
    CULTIVARNAME VARCHAR(255),
3812
    BREED VARCHAR(255),
3813
    ORIGINALPUBLICATIONYEAR INTEGER,
3814
    PUBLICATIONYEAR INTEGER,
3815
    NAMEAPPROBATION VARCHAR(255),
3816
    SUBGENUSAUTHORSHIP VARCHAR(255)
3817
);
3818
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_AUD;
3819
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION(
3820
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3821
    ANNOTATIONS_ID INTEGER NOT NULL
3822
);
3823
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ANNOTATION;
3824
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD(
3825
    REV INTEGER NOT NULL,
3826
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3827
    ANNOTATIONS_ID INTEGER NOT NULL,
3828
    REVTYPE TINYINT
3829
);
3830
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD;
3831
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_CREDIT(
3832
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3833
    CREDITS_ID INTEGER NOT NULL,
3834
    SORTINDEX INTEGER NOT NULL
3835
);
3836
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_CREDIT;
3837
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_CREDIT_AUD(
3838
    REV INTEGER NOT NULL,
3839
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3840
    CREDITS_ID INTEGER NOT NULL,
3841
    SORTINDEX INTEGER NOT NULL,
3842
    REVTYPE TINYINT
3843
);
3844
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_CREDIT_AUD;
3845
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_EXTENSION(
3846
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3847
    EXTENSIONS_ID INTEGER NOT NULL
3848
);
3849
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_EXTENSION;
3850
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_EXTENSION_AUD(
3851
    REV INTEGER NOT NULL,
3852
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3853
    EXTENSIONS_ID INTEGER NOT NULL,
3854
    REVTYPE TINYINT
3855
);
3856
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_EXTENSION_AUD;
3857
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_MARKER(
3858
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3859
    MARKERS_ID INTEGER NOT NULL
3860
);
3861
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_MARKER;
3862
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD(
3863
    REV INTEGER NOT NULL,
3864
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3865
    MARKERS_ID INTEGER NOT NULL,
3866
    REVTYPE TINYINT
3867
);
3868
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_MARKER_AUD;
3869
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS(
3870
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3871
    STATUS_ID INTEGER NOT NULL
3872
);
3873
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS;
3874
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD(
3875
    REV INTEGER NOT NULL,
3876
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3877
    STATUS_ID INTEGER NOT NULL,
3878
    REVTYPE TINYINT
3879
);
3880
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD;
3881
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE(
3882
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3883
    SOURCES_ID INTEGER NOT NULL
3884
);
3885
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE;
3886
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD(
3887
    REV INTEGER NOT NULL,
3888
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3889
    SOURCES_ID INTEGER NOT NULL,
3890
    REVTYPE TINYINT
3891
);
3892
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD;
3893
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_RIGHTS(
3894
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3895
    RIGHTS_ID INTEGER NOT NULL
3896
);
3897
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_RIGHTS;
3898
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_RIGHTS_AUD(
3899
    REV INTEGER NOT NULL,
3900
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3901
    RIGHTS_ID INTEGER NOT NULL,
3902
    REVTYPE TINYINT
3903
);
3904
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_RIGHTS_AUD;
3905
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE(
3906
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3907
    TYPEDESIGNATIONS_ID INTEGER NOT NULL
3908
);
3909
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE;
3910
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD(
3911
    REV INTEGER NOT NULL,
3912
    TAXONNAMEBASE_ID INTEGER NOT NULL,
3913
    TYPEDESIGNATIONS_ID INTEGER NOT NULL,
3914
    REVTYPE TINYINT
3915
);
3916
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD;
3917
CREATE CACHED TABLE PUBLIC.TAXONNODE(
3918
    ID INTEGER NOT NULL,
3919
    CREATED TIMESTAMP,
3920
    UUID VARCHAR(36),
3921
    UPDATED TIMESTAMP,
3922
    SORTINDEX INTEGER,
3923
    TREEINDEX VARCHAR(255),
3924
    COUNTCHILDREN INTEGER NOT NULL,
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;
3935
CREATE CACHED TABLE PUBLIC.TAXONNODE_AUD(
3936
    ID INTEGER NOT NULL,
3937
    REV INTEGER NOT NULL,
3938
    REVTYPE TINYINT,
3939
    CREATED TIMESTAMP,
3940
    UUID VARCHAR(36),
3941
    UPDATED TIMESTAMP,
3942
    SORTINDEX INTEGER,
3943
    TREEINDEX VARCHAR(255),
3944
    COUNTCHILDREN INTEGER,
3945
    MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
3946
    CREATEDBY_ID INTEGER,
3947
    UPDATEDBY_ID INTEGER,
3948
    CLASSIFICATION_ID INTEGER,
3949
    PARENT_ID INTEGER,
3950
    REFERENCEFORPARENTCHILDRELATION_ID INTEGER,
3951
    SYNONYMTOBEUSED_ID INTEGER,
3952
    TAXON_ID INTEGER
3953
);
3954
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_AUD;
3955
CREATE CACHED TABLE PUBLIC.TAXONNODE_ANNOTATION(
3956
    TAXONNODE_ID INTEGER NOT NULL,
3957
    ANNOTATIONS_ID INTEGER NOT NULL
3958
);
3959
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_ANNOTATION;
3960
CREATE CACHED TABLE PUBLIC.TAXONNODE_ANNOTATION_AUD(
3961
    REV INTEGER NOT NULL,
3962
    TAXONNODE_ID INTEGER NOT NULL,
3963
    ANNOTATIONS_ID INTEGER NOT NULL,
3964
    REVTYPE TINYINT
3965
);
3966
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_ANNOTATION_AUD;
3967
CREATE CACHED TABLE PUBLIC.TAXONNODE_MARKER(
3968
    TAXONNODE_ID INTEGER NOT NULL,
3969
    MARKERS_ID INTEGER NOT NULL
3970
);
3971
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_MARKER;
3972
CREATE CACHED TABLE PUBLIC.TAXONNODE_MARKER_AUD(
3973
    REV INTEGER NOT NULL,
3974
    TAXONNODE_ID INTEGER NOT NULL,
3975
    MARKERS_ID INTEGER NOT NULL,
3976
    REVTYPE TINYINT
3977
);
3978
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_MARKER_AUD;
3979
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP(
3980
    ID INTEGER NOT NULL,
3981
    CREATED TIMESTAMP,
3982
    UUID VARCHAR(36),
3983
    UPDATED TIMESTAMP,
3984
    CITATIONMICROREFERENCE VARCHAR(255),
3985
    ORIGINALNAMESTRING VARCHAR(255),
3986
    DOUBTFUL BOOLEAN NOT NULL,
3987
    CREATEDBY_ID INTEGER,
3988
    UPDATEDBY_ID INTEGER,
3989
    CITATION_ID INTEGER,
3990
    RELATEDFROM_ID INTEGER,
3991
    RELATEDTO_ID INTEGER,
3992
    TYPE_ID INTEGER
3993
);
3994
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP;
3995
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_AUD(
3996
    ID INTEGER NOT NULL,
3997
    REV INTEGER NOT NULL,
3998
    REVTYPE TINYINT,
3999
    CREATED TIMESTAMP,
4000
    UUID VARCHAR(36),
4001
    UPDATED TIMESTAMP,
4002
    CITATIONMICROREFERENCE VARCHAR(255),
4003
    ORIGINALNAMESTRING VARCHAR(255),
4004
    DOUBTFUL BOOLEAN,
4005
    CREATEDBY_ID INTEGER,
4006
    UPDATEDBY_ID INTEGER,
4007
    CITATION_ID INTEGER,
4008
    RELATEDFROM_ID INTEGER,
4009
    RELATEDTO_ID INTEGER,
4010
    TYPE_ID INTEGER
4011
);
4012
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_AUD;
4013
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION(
4014
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
4015
    ANNOTATIONS_ID INTEGER NOT NULL
4016
);
4017
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_ANNOTATION;
4018
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION_AUD(
4019
    REV INTEGER NOT NULL,
4020
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
4021
    ANNOTATIONS_ID INTEGER NOT NULL,
4022
    REVTYPE TINYINT
4023
);
4024
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_ANNOTATION_AUD;
4025
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_MARKER(
4026
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
4027
    MARKERS_ID INTEGER NOT NULL
4028
);
4029
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_MARKER;
4030
CREATE CACHED TABLE PUBLIC.TAXONRELATIONSHIP_MARKER_AUD(
4031
    REV INTEGER NOT NULL,
4032
    TAXONRELATIONSHIP_ID INTEGER NOT NULL,
4033
    MARKERS_ID INTEGER NOT NULL,
4034
    REVTYPE TINYINT
4035
);
4036
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONRELATIONSHIP_MARKER_AUD;
4037
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY(
4038
    DTYPE VARCHAR(31) NOT NULL,
4039
    ID INTEGER NOT NULL,
4040
    CREATED TIMESTAMP,
4041
    UUID VARCHAR(36),
4042
    UPDATED TIMESTAMP,
4043
    TERMTYPE INTEGER,
4044
    LSID_AUTHORITY VARCHAR(255),
4045
    LSID_LSID VARCHAR(255),
4046
    LSID_NAMESPACE VARCHAR(255),
4047
    LSID_OBJECT VARCHAR(255),
4048
    LSID_REVISION VARCHAR(255),
4049
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
4050
    TITLECACHE VARCHAR(255),
4051
    URI CLOB,
4052
    TERMSOURCEURI CLOB,
4053
    CREATEDBY_ID INTEGER,
4054
    UPDATEDBY_ID INTEGER
4055
);
4056
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY;
4057
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_AUD(
4058
    DTYPE VARCHAR(31) NOT NULL,
4059
    ID INTEGER NOT NULL,
4060
    REV INTEGER NOT NULL,
4061
    REVTYPE TINYINT,
4062
    CREATED TIMESTAMP,
4063
    UUID VARCHAR(36),
4064
    UPDATED TIMESTAMP,
4065
    TERMTYPE INTEGER,
4066
    LSID_AUTHORITY VARCHAR(255),
4067
    LSID_LSID VARCHAR(255),
4068
    LSID_NAMESPACE VARCHAR(255),
4069
    LSID_OBJECT VARCHAR(255),
4070
    LSID_REVISION VARCHAR(255),
4071
    PROTECTEDTITLECACHE BOOLEAN,
4072
    TITLECACHE VARCHAR(255),
4073
    URI CLOB,
4074
    TERMSOURCEURI CLOB,
4075
    CREATEDBY_ID INTEGER,
4076
    UPDATEDBY_ID INTEGER
4077
);
4078
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_AUD;
4079
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ANNOTATION(
4080
    TERMVOCABULARY_ID INTEGER NOT NULL,
4081
    ANNOTATIONS_ID INTEGER NOT NULL
4082
);
4083
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ANNOTATION;
4084
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ANNOTATION_AUD(
4085
    REV INTEGER NOT NULL,
4086
    TERMVOCABULARY_ID INTEGER NOT NULL,
4087
    ANNOTATIONS_ID INTEGER NOT NULL,
4088
    REVTYPE TINYINT
4089
);
4090
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ANNOTATION_AUD;
4091
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_CREDIT(
4092
    TERMVOCABULARY_ID INTEGER NOT NULL,
4093
    CREDITS_ID INTEGER NOT NULL,
4094
    SORTINDEX INTEGER NOT NULL
4095
);
4096
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_CREDIT;
4097
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_CREDIT_AUD(
4098
    REV INTEGER NOT NULL,
4099
    TERMVOCABULARY_ID INTEGER NOT NULL,
4100
    CREDITS_ID INTEGER NOT NULL,
4101
    SORTINDEX INTEGER NOT NULL,
4102
    REVTYPE TINYINT
4103
);
4104
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_CREDIT_AUD;
4105
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_EXTENSION(
4106
    TERMVOCABULARY_ID INTEGER NOT NULL,
4107
    EXTENSIONS_ID INTEGER NOT NULL
4108
);
4109
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_EXTENSION;
4110
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_EXTENSION_AUD(
4111
    REV INTEGER NOT NULL,
4112
    TERMVOCABULARY_ID INTEGER NOT NULL,
4113
    EXTENSIONS_ID INTEGER NOT NULL,
4114
    REVTYPE TINYINT
4115
);
4116
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_EXTENSION_AUD;
4117
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_MARKER(
4118
    TERMVOCABULARY_ID INTEGER NOT NULL,
4119
    MARKERS_ID INTEGER NOT NULL
4120
);
4121
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_MARKER;
4122
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_MARKER_AUD(
4123
    REV INTEGER NOT NULL,
4124
    TERMVOCABULARY_ID INTEGER NOT NULL,
4125
    MARKERS_ID INTEGER NOT NULL,
4126
    REVTYPE TINYINT
4127
);
4128
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_MARKER_AUD;
4129
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE(
4130
    TERMVOCABULARY_ID INTEGER NOT NULL,
4131
    SOURCES_ID INTEGER NOT NULL
4132
);
4133
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE;
4134
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD(
4135
    REV INTEGER NOT NULL,
4136
    TERMVOCABULARY_ID INTEGER NOT NULL,
4137
    SOURCES_ID INTEGER NOT NULL,
4138
    REVTYPE TINYINT
4139
);
4140
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD;
4141
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION(
4142
    TERMVOCABULARY_ID INTEGER NOT NULL,
4143
    REPRESENTATIONS_ID INTEGER NOT NULL
4144
);
4145
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_REPRESENTATION;
4146
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD(
4147
    REV INTEGER NOT NULL,
4148
    TERMVOCABULARY_ID INTEGER NOT NULL,
4149
    REPRESENTATIONS_ID INTEGER NOT NULL,
4150
    REVTYPE TINYINT
4151
);
4152
-- 37 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD;
4153
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_RIGHTS(
4154
    TERMVOCABULARY_ID INTEGER NOT NULL,
4155
    RIGHTS_ID INTEGER NOT NULL
4156
);
4157
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_RIGHTS;
4158
CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_RIGHTS_AUD(
4159
    REV INTEGER NOT NULL,
4160
    TERMVOCABULARY_ID INTEGER NOT NULL,
4161
    RIGHTS_ID INTEGER NOT NULL,
4162
    REVTYPE TINYINT
4163
);
4164
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TERMVOCABULARY_RIGHTS_AUD;
4165
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE(
4166
    DTYPE VARCHAR(31) NOT NULL,
4167
    ID INTEGER NOT NULL,
4168
    CREATED TIMESTAMP,
4169
    UUID VARCHAR(36),
4170
    UPDATED TIMESTAMP,
4171
    CITATIONMICROREFERENCE VARCHAR(255),
4172
    ORIGINALNAMESTRING VARCHAR(255),
4173
    NOTDESIGNATED BOOLEAN NOT NULL,
4174
    CONSERVEDTYPE BOOLEAN,
4175
    REJECTEDTYPE BOOLEAN,
4176
    CREATEDBY_ID INTEGER,
4177
    UPDATEDBY_ID INTEGER,
4178
    CITATION_ID INTEGER,
4179
    HOMOTYPICALGROUP_ID INTEGER,
4180
    TYPESTATUS_ID INTEGER,
4181
    TYPENAME_ID INTEGER,
4182
    TYPESPECIMEN_ID INTEGER
4183
);
4184
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE;
4185
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD(
4186
    DTYPE VARCHAR(31) NOT NULL,
4187
    ID INTEGER NOT NULL,
4188
    REV INTEGER NOT NULL,
4189
    REVTYPE TINYINT,
4190
    CREATED TIMESTAMP,
4191
    UUID VARCHAR(36),
4192
    UPDATED TIMESTAMP,
4193
    CITATIONMICROREFERENCE VARCHAR(255),
4194
    ORIGINALNAMESTRING VARCHAR(255),
4195
    NOTDESIGNATED BOOLEAN,
4196
    CREATEDBY_ID INTEGER,
4197
    UPDATEDBY_ID INTEGER,
4198
    CITATION_ID INTEGER,
4199
    HOMOTYPICALGROUP_ID INTEGER,
4200
    TYPESTATUS_ID INTEGER,
4201
    CONSERVEDTYPE BOOLEAN,
4202
    REJECTEDTYPE BOOLEAN,
4203
    TYPENAME_ID INTEGER,
4204
    TYPESPECIMEN_ID INTEGER
4205
);
4206
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_AUD;
4207
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION(
4208
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4209
    ANNOTATIONS_ID INTEGER NOT NULL
4210
);
4211
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION;
4212
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION_AUD(
4213
    REV INTEGER NOT NULL,
4214
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4215
    ANNOTATIONS_ID INTEGER NOT NULL,
4216
    REVTYPE TINYINT
4217
);
4218
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION_AUD;
4219
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER(
4220
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4221
    MARKERS_ID INTEGER NOT NULL
4222
);
4223
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_MARKER;
4224
CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD(
4225
    REV INTEGER NOT NULL,
4226
    TYPEDESIGNATIONBASE_ID INTEGER NOT NULL,
4227
    MARKERS_ID INTEGER NOT NULL,
4228
    REVTYPE TINYINT
4229
);
4230
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD;
4231
CREATE CACHED TABLE PUBLIC.USERACCOUNT(
4232
    ID INTEGER NOT NULL,
4233
    CREATED TIMESTAMP,
4234
    UUID VARCHAR(36),
4235
    ACCOUNTNONEXPIRED BOOLEAN NOT NULL,
4236
    ACCOUNTNONLOCKED BOOLEAN NOT NULL,
4237
    CREDENTIALSNONEXPIRED BOOLEAN NOT NULL,
4238
    EMAILADDRESS VARCHAR(255),
4239
    ENABLED BOOLEAN NOT NULL,
4240
    PASSWORD VARCHAR(255),
4241
    USERNAME VARCHAR(255),
4242
    CREATEDBY_ID INTEGER,
4243
    PERSON_ID INTEGER
4244
);
4245
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT;
4246
CREATE CACHED TABLE PUBLIC.USERACCOUNT_AUD(
4247
    ID INTEGER NOT NULL,
4248
    REV INTEGER NOT NULL,
4249
    REVTYPE TINYINT,
4250
    CREATED TIMESTAMP,
4251
    UUID VARCHAR(36),
4252
    ACCOUNTNONEXPIRED BOOLEAN,
4253
    ACCOUNTNONLOCKED BOOLEAN,
4254
    CREDENTIALSNONEXPIRED BOOLEAN,
4255
    EMAILADDRESS VARCHAR(255),
4256
    ENABLED BOOLEAN,
4257
    USERNAME VARCHAR(255),
4258
    CREATEDBY_ID INTEGER,
4259
    PERSON_ID INTEGER
4260
);
4261
-- 1 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_AUD;
4262
CREATE CACHED TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL(
4263
    USERACCOUNT_ID INTEGER NOT NULL,
4264
    GRANTEDAUTHORITIES_ID INTEGER NOT NULL
4265
);
4266
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL;
4267
CREATE CACHED TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP(
4268
    MEMBERS_ID INTEGER NOT NULL,
4269
    GROUPS_ID INTEGER NOT NULL
4270
);
4271
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_PERMISSIONGROUP;
4272
CREATE CACHED TABLE PUBLIC.WORKINGSET(
4273
    DTYPE VARCHAR(31) NOT NULL,
4274
    ID INTEGER NOT NULL,
4275
    CREATED TIMESTAMP,
4276
    UUID VARCHAR(36),
4277
    UPDATED TIMESTAMP,
4278
    CREATEDBY_ID INTEGER,
4279
    UPDATEDBY_ID INTEGER,
4280
    DESCRIPTIVESYSTEM_ID INTEGER
4281
);
4282
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET;
4283
CREATE CACHED TABLE PUBLIC.WORKINGSET_AUD(
4284
    DTYPE VARCHAR(31) NOT NULL,
4285
    ID INTEGER NOT NULL,
4286
    REV INTEGER NOT NULL,
4287
    REVTYPE TINYINT,
4288
    CREATED TIMESTAMP,
4289
    UUID VARCHAR(36),
4290
    UPDATED TIMESTAMP,
4291
    CREATEDBY_ID INTEGER,
4292
    UPDATEDBY_ID INTEGER,
4293
    DESCRIPTIVESYSTEM_ID INTEGER
4294
);
4295
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_AUD;
4296
CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION(
4297
    WORKINGSET_ID INTEGER NOT NULL,
4298
    ANNOTATIONS_ID INTEGER NOT NULL
4299
);
4300
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION;
4301
CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD(
4302
    REV INTEGER NOT NULL,
4303
    WORKINGSET_ID INTEGER NOT NULL,
4304
    ANNOTATIONS_ID INTEGER NOT NULL,
4305
    REVTYPE TINYINT
4306
);
4307
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION_AUD;
4308
CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE(
4309
    WORKINGSET_ID INTEGER NOT NULL,
4310
    DESCRIPTIONS_ID INTEGER NOT NULL
4311
);
4312
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_DESCRIPTIONBASE;
4313
CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD(
4314
    REV INTEGER NOT NULL,
4315
    WORKINGSET_ID INTEGER NOT NULL,
4316
    DESCRIPTIONS_ID INTEGER NOT NULL,
4317
    REVTYPE TINYINT
4318
);