Project

General

Profile

Statistics
| Branch: | Tag: | Revision:

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

History | View | Annotate | Download (350 KB)

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

    
10

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