|
1
|
create table Address (
|
|
2
|
id integer not null,
|
|
3
|
created timestamp,
|
|
4
|
uuid varchar(36),
|
|
5
|
updated timestamp,
|
|
6
|
locality varchar(255),
|
|
7
|
location_errorradius integer,
|
|
8
|
location_latitude double,
|
|
9
|
location_longitude double,
|
|
10
|
pobox varchar(255),
|
|
11
|
postcode varchar(255),
|
|
12
|
region varchar(255),
|
|
13
|
street varchar(255),
|
|
14
|
createdby_id integer,
|
|
15
|
updatedby_id integer,
|
|
16
|
country_id integer,
|
|
17
|
location_referencesystem_id integer,
|
|
18
|
primary key (id),
|
|
19
|
unique (uuid)
|
|
20
|
);
|
|
21
|
|
|
22
|
create table Address_AUD (
|
|
23
|
id integer not null,
|
|
24
|
REV integer not null,
|
|
25
|
revtype tinyint,
|
|
26
|
created timestamp,
|
|
27
|
uuid varchar(36),
|
|
28
|
updated timestamp,
|
|
29
|
locality varchar(255),
|
|
30
|
location_errorradius integer,
|
|
31
|
location_latitude double,
|
|
32
|
location_longitude double,
|
|
33
|
pobox varchar(255),
|
|
34
|
postcode varchar(255),
|
|
35
|
region varchar(255),
|
|
36
|
street varchar(255),
|
|
37
|
createdby_id integer,
|
|
38
|
updatedby_id integer,
|
|
39
|
country_id integer,
|
|
40
|
location_referencesystem_id integer,
|
|
41
|
primary key (id, REV)
|
|
42
|
);
|
|
43
|
|
|
44
|
create table AgentBase (
|
|
45
|
DTYPE varchar(31) not null,
|
|
46
|
id integer not null,
|
|
47
|
created timestamp,
|
|
48
|
uuid varchar(36),
|
|
49
|
updated timestamp,
|
|
50
|
lsid_authority varchar(255),
|
|
51
|
lsid_lsid varchar(255),
|
|
52
|
lsid_namespace varchar(255),
|
|
53
|
lsid_object varchar(255),
|
|
54
|
lsid_revision varchar(255),
|
|
55
|
protectedtitlecache bit not null,
|
|
56
|
titleCache varchar(255),
|
|
57
|
code varchar(255),
|
|
58
|
name varchar(255),
|
|
59
|
nomenclaturaltitle varchar(255),
|
|
60
|
firstname varchar(255),
|
|
61
|
lastname varchar(255),
|
|
62
|
lifespan_end varchar(255),
|
|
63
|
lifespan_freetext varchar(255),
|
|
64
|
lifespan_start varchar(255),
|
|
65
|
prefix varchar(255),
|
|
66
|
suffix varchar(255),
|
|
67
|
protectednomenclaturaltitlecache bit,
|
|
68
|
createdby_id integer,
|
|
69
|
updatedby_id integer,
|
|
70
|
ispartof_id integer,
|
|
71
|
primary key (id),
|
|
72
|
unique (uuid)
|
|
73
|
);
|
|
74
|
|
|
75
|
create table AgentBase_AUD (
|
|
76
|
DTYPE varchar(31) not null,
|
|
77
|
id integer not null,
|
|
78
|
REV integer not null,
|
|
79
|
revtype tinyint,
|
|
80
|
created timestamp,
|
|
81
|
uuid varchar(36),
|
|
82
|
updated timestamp,
|
|
83
|
lsid_authority varchar(255),
|
|
84
|
lsid_lsid varchar(255),
|
|
85
|
lsid_namespace varchar(255),
|
|
86
|
lsid_object varchar(255),
|
|
87
|
lsid_revision varchar(255),
|
|
88
|
protectedtitlecache bit,
|
|
89
|
titleCache varchar(255),
|
|
90
|
createdby_id integer,
|
|
91
|
updatedby_id integer,
|
|
92
|
code varchar(255),
|
|
93
|
name varchar(255),
|
|
94
|
ispartof_id integer,
|
|
95
|
nomenclaturaltitle varchar(255),
|
|
96
|
firstname varchar(255),
|
|
97
|
lastname varchar(255),
|
|
98
|
lifespan_end varchar(255),
|
|
99
|
lifespan_freetext varchar(255),
|
|
100
|
lifespan_start varchar(255),
|
|
101
|
prefix varchar(255),
|
|
102
|
suffix varchar(255),
|
|
103
|
protectednomenclaturaltitlecache bit,
|
|
104
|
primary key (id, REV)
|
|
105
|
);
|
|
106
|
|
|
107
|
create table AgentBase_Address (
|
|
108
|
AgentBase_id integer not null,
|
|
109
|
contact_addresses_id integer not null,
|
|
110
|
primary key (AgentBase_id, contact_addresses_id),
|
|
111
|
unique (contact_addresses_id)
|
|
112
|
);
|
|
113
|
|
|
114
|
create table AgentBase_Address_AUD (
|
|
115
|
REV integer not null,
|
|
116
|
AgentBase_id integer not null,
|
|
117
|
contact_addresses_id integer not null,
|
|
118
|
revtype tinyint,
|
|
119
|
primary key (REV, AgentBase_id, contact_addresses_id)
|
|
120
|
);
|
|
121
|
|
|
122
|
create table AgentBase_AgentBase (
|
|
123
|
AgentBase_id integer not null,
|
|
124
|
teammembers_id integer not null,
|
|
125
|
sortIndex integer not null,
|
|
126
|
primary key (AgentBase_id, sortIndex)
|
|
127
|
);
|
|
128
|
|
|
129
|
create table AgentBase_AgentBase_AUD (
|
|
130
|
REV integer not null,
|
|
131
|
AgentBase_id integer not null,
|
|
132
|
teammembers_id integer not null,
|
|
133
|
sortIndex integer not null,
|
|
134
|
revtype tinyint,
|
|
135
|
primary key (REV, AgentBase_id, teammembers_id, sortIndex)
|
|
136
|
);
|
|
137
|
|
|
138
|
create table AgentBase_Annotation (
|
|
139
|
AgentBase_id integer not null,
|
|
140
|
annotations_id integer not null,
|
|
141
|
primary key (AgentBase_id, annotations_id),
|
|
142
|
unique (annotations_id)
|
|
143
|
);
|
|
144
|
|
|
145
|
create table AgentBase_Annotation_AUD (
|
|
146
|
REV integer not null,
|
|
147
|
AgentBase_id integer not null,
|
|
148
|
annotations_id integer not null,
|
|
149
|
revtype tinyint,
|
|
150
|
primary key (REV, AgentBase_id, annotations_id)
|
|
151
|
);
|
|
152
|
|
|
153
|
create table AgentBase_Credit (
|
|
154
|
AgentBase_id integer not null,
|
|
155
|
credits_id integer not null,
|
|
156
|
sortIndex integer not null,
|
|
157
|
primary key (AgentBase_id, sortIndex),
|
|
158
|
unique (credits_id)
|
|
159
|
);
|
|
160
|
|
|
161
|
create table AgentBase_Credit_AUD (
|
|
162
|
REV integer not null,
|
|
163
|
AgentBase_id integer not null,
|
|
164
|
credits_id integer not null,
|
|
165
|
sortIndex integer not null,
|
|
166
|
revtype tinyint,
|
|
167
|
primary key (REV, AgentBase_id, credits_id, sortIndex)
|
|
168
|
);
|
|
169
|
|
|
170
|
create table AgentBase_DefinedTermBase (
|
|
171
|
AgentBase_id integer not null,
|
|
172
|
types_id integer not null,
|
|
173
|
primary key (AgentBase_id, types_id)
|
|
174
|
);
|
|
175
|
|
|
176
|
create table AgentBase_DefinedTermBase_AUD (
|
|
177
|
REV integer not null,
|
|
178
|
AgentBase_id integer not null,
|
|
179
|
types_id integer not null,
|
|
180
|
revtype tinyint,
|
|
181
|
primary key (REV, AgentBase_id, types_id)
|
|
182
|
);
|
|
183
|
|
|
184
|
create table AgentBase_Extension (
|
|
185
|
AgentBase_id integer not null,
|
|
186
|
extensions_id integer not null,
|
|
187
|
primary key (AgentBase_id, extensions_id),
|
|
188
|
unique (extensions_id)
|
|
189
|
);
|
|
190
|
|
|
191
|
create table AgentBase_Extension_AUD (
|
|
192
|
REV integer not null,
|
|
193
|
AgentBase_id integer not null,
|
|
194
|
extensions_id integer not null,
|
|
195
|
revtype tinyint,
|
|
196
|
primary key (REV, AgentBase_id, extensions_id)
|
|
197
|
);
|
|
198
|
|
|
199
|
create table AgentBase_Marker (
|
|
200
|
AgentBase_id integer not null,
|
|
201
|
markers_id integer not null,
|
|
202
|
primary key (AgentBase_id, markers_id),
|
|
203
|
unique (markers_id)
|
|
204
|
);
|
|
205
|
|
|
206
|
create table AgentBase_Marker_AUD (
|
|
207
|
REV integer not null,
|
|
208
|
AgentBase_id integer not null,
|
|
209
|
markers_id integer not null,
|
|
210
|
revtype tinyint,
|
|
211
|
primary key (REV, AgentBase_id, markers_id)
|
|
212
|
);
|
|
213
|
|
|
214
|
create table AgentBase_Media (
|
|
215
|
AgentBase_id integer not null,
|
|
216
|
media_id integer not null,
|
|
217
|
primary key (AgentBase_id, media_id)
|
|
218
|
);
|
|
219
|
|
|
220
|
create table AgentBase_Media_AUD (
|
|
221
|
REV integer not null,
|
|
222
|
AgentBase_id integer not null,
|
|
223
|
media_id integer not null,
|
|
224
|
revtype tinyint,
|
|
225
|
primary key (REV, AgentBase_id, media_id)
|
|
226
|
);
|
|
227
|
|
|
228
|
create table AgentBase_OriginalSourceBase (
|
|
229
|
AgentBase_id integer not null,
|
|
230
|
sources_id integer not null,
|
|
231
|
primary key (AgentBase_id, sources_id),
|
|
232
|
unique (sources_id)
|
|
233
|
);
|
|
234
|
|
|
235
|
create table AgentBase_OriginalSourceBase_AUD (
|
|
236
|
REV integer not null,
|
|
237
|
AgentBase_id integer not null,
|
|
238
|
sources_id integer not null,
|
|
239
|
revtype tinyint,
|
|
240
|
primary key (REV, AgentBase_id, sources_id)
|
|
241
|
);
|
|
242
|
|
|
243
|
create table AgentBase_Rights (
|
|
244
|
AgentBase_id integer not null,
|
|
245
|
rights_id integer not null,
|
|
246
|
primary key (AgentBase_id, rights_id),
|
|
247
|
unique (rights_id)
|
|
248
|
);
|
|
249
|
|
|
250
|
create table AgentBase_Rights_AUD (
|
|
251
|
REV integer not null,
|
|
252
|
AgentBase_id integer not null,
|
|
253
|
rights_id integer not null,
|
|
254
|
revtype tinyint,
|
|
255
|
primary key (REV, AgentBase_id, rights_id)
|
|
256
|
);
|
|
257
|
|
|
258
|
create table AgentBase_contact_emailaddresses (
|
|
259
|
AgentBase_id integer not null,
|
|
260
|
contact_emailaddresses_element varchar(255)
|
|
261
|
);
|
|
262
|
|
|
263
|
create table AgentBase_contact_emailaddresses_AUD (
|
|
264
|
REV integer not null,
|
|
265
|
AgentBase_id integer not null,
|
|
266
|
contact_emailaddresses_element varchar(255) not null,
|
|
267
|
revtype tinyint,
|
|
268
|
primary key (REV, AgentBase_id, contact_emailaddresses_element)
|
|
269
|
);
|
|
270
|
|
|
271
|
create table AgentBase_contact_faxnumbers (
|
|
272
|
AgentBase_id integer not null,
|
|
273
|
contact_faxnumbers_element varchar(255)
|
|
274
|
);
|
|
275
|
|
|
276
|
create table AgentBase_contact_faxnumbers_AUD (
|
|
277
|
REV integer not null,
|
|
278
|
AgentBase_id integer not null,
|
|
279
|
contact_faxnumbers_element varchar(255) not null,
|
|
280
|
revtype tinyint,
|
|
281
|
primary key (REV, AgentBase_id, contact_faxnumbers_element)
|
|
282
|
);
|
|
283
|
|
|
284
|
create table AgentBase_contact_phonenumbers (
|
|
285
|
AgentBase_id integer not null,
|
|
286
|
contact_phonenumbers_element varchar(255)
|
|
287
|
);
|
|
288
|
|
|
289
|
create table AgentBase_contact_phonenumbers_AUD (
|
|
290
|
REV integer not null,
|
|
291
|
AgentBase_id integer not null,
|
|
292
|
contact_phonenumbers_element varchar(255) not null,
|
|
293
|
revtype tinyint,
|
|
294
|
primary key (REV, AgentBase_id, contact_phonenumbers_element)
|
|
295
|
);
|
|
296
|
|
|
297
|
create table AgentBase_contact_urls (
|
|
298
|
AgentBase_id integer not null,
|
|
299
|
contact_urls_element varchar(255)
|
|
300
|
);
|
|
301
|
|
|
302
|
create table AgentBase_contact_urls_AUD (
|
|
303
|
REV integer not null,
|
|
304
|
AgentBase_id integer not null,
|
|
305
|
contact_urls_element varchar(255) not null,
|
|
306
|
revtype tinyint,
|
|
307
|
primary key (REV, AgentBase_id, contact_urls_element)
|
|
308
|
);
|
|
309
|
|
|
310
|
create table Annotation (
|
|
311
|
id integer not null,
|
|
312
|
created timestamp,
|
|
313
|
uuid varchar(36),
|
|
314
|
updated timestamp,
|
|
315
|
text longvarchar,
|
|
316
|
annotatedObj_type varchar(255),
|
|
317
|
annotatedObj_id integer not null,
|
|
318
|
linkbackurl varbinary(255),
|
|
319
|
createdby_id integer,
|
|
320
|
updatedby_id integer,
|
|
321
|
language_id integer,
|
|
322
|
annotationtype_id integer,
|
|
323
|
commentator_id integer,
|
|
324
|
primary key (id),
|
|
325
|
unique (uuid)
|
|
326
|
);
|
|
327
|
|
|
328
|
create table Annotation_AUD (
|
|
329
|
id integer not null,
|
|
330
|
REV integer not null,
|
|
331
|
revtype tinyint,
|
|
332
|
created timestamp,
|
|
333
|
uuid varchar(36),
|
|
334
|
updated timestamp,
|
|
335
|
text longvarchar,
|
|
336
|
linkbackurl varbinary(255),
|
|
337
|
createdby_id integer,
|
|
338
|
updatedby_id integer,
|
|
339
|
language_id integer,
|
|
340
|
annotationtype_id integer,
|
|
341
|
commentator_id integer,
|
|
342
|
primary key (id, REV)
|
|
343
|
);
|
|
344
|
|
|
345
|
create table Annotation_Annotation (
|
|
346
|
Annotation_id integer not null,
|
|
347
|
annotations_id integer not null,
|
|
348
|
primary key (Annotation_id, annotations_id),
|
|
349
|
unique (annotations_id)
|
|
350
|
);
|
|
351
|
|
|
352
|
create table Annotation_Annotation_AUD (
|
|
353
|
REV integer not null,
|
|
354
|
Annotation_id integer not null,
|
|
355
|
annotations_id integer not null,
|
|
356
|
revtype tinyint,
|
|
357
|
primary key (REV, Annotation_id, annotations_id)
|
|
358
|
);
|
|
359
|
|
|
360
|
create table Annotation_Marker (
|
|
361
|
Annotation_id integer not null,
|
|
362
|
markers_id integer not null,
|
|
363
|
primary key (Annotation_id, markers_id),
|
|
364
|
unique (markers_id)
|
|
365
|
);
|
|
366
|
|
|
367
|
create table Annotation_Marker_AUD (
|
|
368
|
REV integer not null,
|
|
369
|
Annotation_id integer not null,
|
|
370
|
markers_id integer not null,
|
|
371
|
revtype tinyint,
|
|
372
|
primary key (REV, Annotation_id, markers_id)
|
|
373
|
);
|
|
374
|
|
|
375
|
create table AuditEvent (
|
|
376
|
revisionnumber integer generated by default as identity (start with 1),
|
|
377
|
date timestamp,
|
|
378
|
timestamp bigint,
|
|
379
|
uuid varchar(255),
|
|
380
|
primary key (revisionnumber)
|
|
381
|
);
|
|
382
|
|
|
383
|
create table CDM_VIEW (
|
|
384
|
id integer not null,
|
|
385
|
created timestamp,
|
|
386
|
uuid varchar(36),
|
|
387
|
description varchar(255),
|
|
388
|
name varchar(255),
|
|
389
|
createdby_id integer,
|
|
390
|
reference_id integer,
|
|
391
|
primary key (id),
|
|
392
|
unique (uuid)
|
|
393
|
);
|
|
394
|
|
|
395
|
create table CDM_VIEW_CDM_VIEW (
|
|
396
|
CDM_VIEW_id integer not null,
|
|
397
|
superviews_id integer not null,
|
|
398
|
primary key (CDM_VIEW_id, superviews_id),
|
|
399
|
unique (superviews_id)
|
|
400
|
);
|
|
401
|
|
|
402
|
|
|
403
|
create table Classification (
|
|
404
|
id integer not null,
|
|
405
|
created timestamp,
|
|
406
|
uuid varchar(36),
|
|
407
|
updated timestamp,
|
|
408
|
lsid_authority varchar(255),
|
|
409
|
lsid_lsid varchar(255),
|
|
410
|
lsid_namespace varchar(255),
|
|
411
|
lsid_object varchar(255),
|
|
412
|
lsid_revision varchar(255),
|
|
413
|
protectedtitlecache bit not null,
|
|
414
|
titleCache varchar(255),
|
|
415
|
microreference varchar(255),
|
|
416
|
createdby_id integer,
|
|
417
|
updatedby_id integer,
|
|
418
|
name_id integer,
|
|
419
|
reference_id integer,
|
|
420
|
primary key (id),
|
|
421
|
unique (uuid)
|
|
422
|
);
|
|
423
|
|
|
424
|
create table Classification_AUD (
|
|
425
|
id integer not null,
|
|
426
|
REV integer not null,
|
|
427
|
revtype tinyint,
|
|
428
|
created timestamp,
|
|
429
|
uuid varchar(36),
|
|
430
|
updated timestamp,
|
|
431
|
lsid_authority varchar(255),
|
|
432
|
lsid_lsid varchar(255),
|
|
433
|
lsid_namespace varchar(255),
|
|
434
|
lsid_object varchar(255),
|
|
435
|
lsid_revision varchar(255),
|
|
436
|
protectedtitlecache bit,
|
|
437
|
titleCache varchar(255),
|
|
438
|
microreference varchar(255),
|
|
439
|
createdby_id integer,
|
|
440
|
updatedby_id integer,
|
|
441
|
name_id integer,
|
|
442
|
reference_id integer,
|
|
443
|
primary key (id, REV)
|
|
444
|
);
|
|
445
|
|
|
446
|
create table Classification_Annotation (
|
|
447
|
Classification_id integer not null,
|
|
448
|
annotations_id integer not null,
|
|
449
|
primary key (Classification_id, annotations_id),
|
|
450
|
unique (annotations_id)
|
|
451
|
);
|
|
452
|
|
|
453
|
create table Classification_Annotation_AUD (
|
|
454
|
REV integer not null,
|
|
455
|
Classification_id integer not null,
|
|
456
|
annotations_id integer not null,
|
|
457
|
revtype tinyint,
|
|
458
|
primary key (REV, Classification_id, annotations_id)
|
|
459
|
);
|
|
460
|
|
|
461
|
create table Classification_Credit (
|
|
462
|
Classification_id integer not null,
|
|
463
|
credits_id integer not null,
|
|
464
|
sortIndex integer not null,
|
|
465
|
primary key (Classification_id, sortIndex),
|
|
466
|
unique (credits_id)
|
|
467
|
);
|
|
468
|
|
|
469
|
create table Classification_Credit_AUD (
|
|
470
|
REV integer not null,
|
|
471
|
Classification_id integer not null,
|
|
472
|
credits_id integer not null,
|
|
473
|
sortIndex integer not null,
|
|
474
|
revtype tinyint,
|
|
475
|
primary key (REV, Classification_id, credits_id, sortIndex)
|
|
476
|
);
|
|
477
|
|
|
478
|
create table Classification_Extension (
|
|
479
|
Classification_id integer not null,
|
|
480
|
extensions_id integer not null,
|
|
481
|
primary key (Classification_id, extensions_id),
|
|
482
|
unique (extensions_id)
|
|
483
|
);
|
|
484
|
|
|
485
|
create table Classification_Extension_AUD (
|
|
486
|
REV integer not null,
|
|
487
|
Classification_id integer not null,
|
|
488
|
extensions_id integer not null,
|
|
489
|
revtype tinyint,
|
|
490
|
primary key (REV, Classification_id, extensions_id)
|
|
491
|
);
|
|
492
|
|
|
493
|
create table Classification_Marker (
|
|
494
|
Classification_id integer not null,
|
|
495
|
markers_id integer not null,
|
|
496
|
primary key (Classification_id, markers_id),
|
|
497
|
unique (markers_id)
|
|
498
|
);
|
|
499
|
|
|
500
|
create table Classification_Marker_AUD (
|
|
501
|
REV integer not null,
|
|
502
|
Classification_id integer not null,
|
|
503
|
markers_id integer not null,
|
|
504
|
revtype tinyint,
|
|
505
|
primary key (REV, Classification_id, markers_id)
|
|
506
|
);
|
|
507
|
|
|
508
|
create table Classification_OriginalSourceBase (
|
|
509
|
Classification_id integer not null,
|
|
510
|
sources_id integer not null,
|
|
511
|
primary key (Classification_id, sources_id),
|
|
512
|
unique (sources_id)
|
|
513
|
);
|
|
514
|
|
|
515
|
create table Classification_OriginalSourceBase_AUD (
|
|
516
|
REV integer not null,
|
|
517
|
Classification_id integer not null,
|
|
518
|
sources_id integer not null,
|
|
519
|
revtype tinyint,
|
|
520
|
primary key (REV, Classification_id, sources_id)
|
|
521
|
);
|
|
522
|
|
|
523
|
create table Classification_Rights (
|
|
524
|
Classification_id integer not null,
|
|
525
|
rights_id integer not null,
|
|
526
|
primary key (Classification_id, rights_id),
|
|
527
|
unique (rights_id)
|
|
528
|
);
|
|
529
|
|
|
530
|
create table Classification_Rights_AUD (
|
|
531
|
REV integer not null,
|
|
532
|
Classification_id integer not null,
|
|
533
|
rights_id integer not null,
|
|
534
|
revtype tinyint,
|
|
535
|
primary key (REV, Classification_id, rights_id)
|
|
536
|
);
|
|
537
|
|
|
538
|
create table Classification_TaxonNode (
|
|
539
|
Classification_id integer not null,
|
|
540
|
rootnodes_id integer not null,
|
|
541
|
primary key (Classification_id, rootnodes_id),
|
|
542
|
unique (rootnodes_id)
|
|
543
|
);
|
|
544
|
|
|
545
|
create table Classification_TaxonNode_AUD (
|
|
546
|
REV integer not null,
|
|
547
|
Classification_id integer not null,
|
|
548
|
rootnodes_id integer not null,
|
|
549
|
revtype tinyint,
|
|
550
|
primary key (REV, Classification_id, rootnodes_id)
|
|
551
|
);
|
|
552
|
|
|
553
|
|
|
554
|
create table Collection (
|
|
555
|
id integer not null,
|
|
556
|
created timestamp,
|
|
557
|
uuid varchar(36),
|
|
558
|
updated timestamp,
|
|
559
|
lsid_authority varchar(255),
|
|
560
|
lsid_lsid varchar(255),
|
|
561
|
lsid_namespace varchar(255),
|
|
562
|
lsid_object varchar(255),
|
|
563
|
lsid_revision varchar(255),
|
|
564
|
protectedtitlecache bit not null,
|
|
565
|
titleCache varchar(255),
|
|
566
|
code varchar(255),
|
|
567
|
codestandard varchar(255),
|
|
568
|
name varchar(255),
|
|
569
|
townorlocation varchar(255),
|
|
570
|
createdby_id integer,
|
|
571
|
updatedby_id integer,
|
|
572
|
institute_id integer,
|
|
573
|
supercollection_id integer,
|
|
574
|
primary key (id),
|
|
575
|
unique (uuid)
|
|
576
|
);
|
|
577
|
|
|
578
|
create table Collection_AUD (
|
|
579
|
id integer not null,
|
|
580
|
REV integer not null,
|
|
581
|
revtype tinyint,
|
|
582
|
created timestamp,
|
|
583
|
uuid varchar(36),
|
|
584
|
updated timestamp,
|
|
585
|
lsid_authority varchar(255),
|
|
586
|
lsid_lsid varchar(255),
|
|
587
|
lsid_namespace varchar(255),
|
|
588
|
lsid_object varchar(255),
|
|
589
|
lsid_revision varchar(255),
|
|
590
|
protectedtitlecache bit,
|
|
591
|
titleCache varchar(255),
|
|
592
|
code varchar(255),
|
|
593
|
codestandard varchar(255),
|
|
594
|
name varchar(255),
|
|
595
|
townorlocation varchar(255),
|
|
596
|
createdby_id integer,
|
|
597
|
updatedby_id integer,
|
|
598
|
institute_id integer,
|
|
599
|
supercollection_id integer,
|
|
600
|
primary key (id, REV)
|
|
601
|
);
|
|
602
|
|
|
603
|
create table Collection_Annotation (
|
|
604
|
Collection_id integer not null,
|
|
605
|
annotations_id integer not null,
|
|
606
|
primary key (Collection_id, annotations_id),
|
|
607
|
unique (annotations_id)
|
|
608
|
);
|
|
609
|
|
|
610
|
create table Collection_Annotation_AUD (
|
|
611
|
REV integer not null,
|
|
612
|
Collection_id integer not null,
|
|
613
|
annotations_id integer not null,
|
|
614
|
revtype tinyint,
|
|
615
|
primary key (REV, Collection_id, annotations_id)
|
|
616
|
);
|
|
617
|
|
|
618
|
create table Collection_Credit (
|
|
619
|
Collection_id integer not null,
|
|
620
|
credits_id integer not null,
|
|
621
|
sortIndex integer not null,
|
|
622
|
primary key (Collection_id, sortIndex),
|
|
623
|
unique (credits_id)
|
|
624
|
);
|
|
625
|
|
|
626
|
create table Collection_Credit_AUD (
|
|
627
|
REV integer not null,
|
|
628
|
Collection_id integer not null,
|
|
629
|
credits_id integer not null,
|
|
630
|
sortIndex integer not null,
|
|
631
|
revtype tinyint,
|
|
632
|
primary key (REV, Collection_id, credits_id, sortIndex)
|
|
633
|
);
|
|
634
|
|
|
635
|
create table Collection_Extension (
|
|
636
|
Collection_id integer not null,
|
|
637
|
extensions_id integer not null,
|
|
638
|
primary key (Collection_id, extensions_id),
|
|
639
|
unique (extensions_id)
|
|
640
|
);
|
|
641
|
|
|
642
|
create table Collection_Extension_AUD (
|
|
643
|
REV integer not null,
|
|
644
|
Collection_id integer not null,
|
|
645
|
extensions_id integer not null,
|
|
646
|
revtype tinyint,
|
|
647
|
primary key (REV, Collection_id, extensions_id)
|
|
648
|
);
|
|
649
|
|
|
650
|
create table Collection_Marker (
|
|
651
|
Collection_id integer not null,
|
|
652
|
markers_id integer not null,
|
|
653
|
primary key (Collection_id, markers_id),
|
|
654
|
unique (markers_id)
|
|
655
|
);
|
|
656
|
|
|
657
|
create table Collection_Marker_AUD (
|
|
658
|
REV integer not null,
|
|
659
|
Collection_id integer not null,
|
|
660
|
markers_id integer not null,
|
|
661
|
revtype tinyint,
|
|
662
|
primary key (REV, Collection_id, markers_id)
|
|
663
|
);
|
|
664
|
|
|
665
|
create table Collection_Media (
|
|
666
|
Collection_id integer not null,
|
|
667
|
media_id integer not null,
|
|
668
|
primary key (Collection_id, media_id)
|
|
669
|
);
|
|
670
|
|
|
671
|
create table Collection_Media_AUD (
|
|
672
|
REV integer not null,
|
|
673
|
Collection_id integer not null,
|
|
674
|
media_id integer not null,
|
|
675
|
revtype tinyint,
|
|
676
|
primary key (REV, Collection_id, media_id)
|
|
677
|
);
|
|
678
|
|
|
679
|
create table Collection_OriginalSourceBase (
|
|
680
|
Collection_id integer not null,
|
|
681
|
sources_id integer not null,
|
|
682
|
primary key (Collection_id, sources_id),
|
|
683
|
unique (sources_id)
|
|
684
|
);
|
|
685
|
|
|
686
|
create table Collection_OriginalSourceBase_AUD (
|
|
687
|
REV integer not null,
|
|
688
|
Collection_id integer not null,
|
|
689
|
sources_id integer not null,
|
|
690
|
revtype tinyint,
|
|
691
|
primary key (REV, Collection_id, sources_id)
|
|
692
|
);
|
|
693
|
|
|
694
|
create table Collection_Rights (
|
|
695
|
Collection_id integer not null,
|
|
696
|
rights_id integer not null,
|
|
697
|
primary key (Collection_id, rights_id),
|
|
698
|
unique (rights_id)
|
|
699
|
);
|
|
700
|
|
|
701
|
create table Collection_Rights_AUD (
|
|
702
|
REV integer not null,
|
|
703
|
Collection_id integer not null,
|
|
704
|
rights_id integer not null,
|
|
705
|
revtype tinyint,
|
|
706
|
primary key (REV, Collection_id, rights_id)
|
|
707
|
);
|
|
708
|
|
|
709
|
create table Credit (
|
|
710
|
id integer not null,
|
|
711
|
created timestamp,
|
|
712
|
uuid varchar(36),
|
|
713
|
updated timestamp,
|
|
714
|
text longvarchar,
|
|
715
|
abbreviatedtext varchar(255),
|
|
716
|
createdby_id integer,
|
|
717
|
updatedby_id integer,
|
|
718
|
language_id integer,
|
|
719
|
agent_id integer,
|
|
720
|
primary key (id),
|
|
721
|
unique (uuid)
|
|
722
|
);
|
|
723
|
|
|
724
|
create table Credit_AUD (
|
|
725
|
id integer not null,
|
|
726
|
REV integer not null,
|
|
727
|
revtype tinyint,
|
|
728
|
created timestamp,
|
|
729
|
uuid varchar(36),
|
|
730
|
updated timestamp,
|
|
731
|
text longvarchar,
|
|
732
|
abbreviatedtext varchar(255),
|
|
733
|
createdby_id integer,
|
|
734
|
updatedby_id integer,
|
|
735
|
language_id integer,
|
|
736
|
agent_id integer,
|
|
737
|
primary key (id, REV)
|
|
738
|
);
|
|
739
|
|
|
740
|
create table Credit_Annotation (
|
|
741
|
Credit_id integer not null,
|
|
742
|
annotations_id integer not null,
|
|
743
|
primary key (Credit_id, annotations_id),
|
|
744
|
unique (annotations_id)
|
|
745
|
);
|
|
746
|
|
|
747
|
create table Credit_Annotation_AUD (
|
|
748
|
REV integer not null,
|
|
749
|
Credit_id integer not null,
|
|
750
|
annotations_id integer not null,
|
|
751
|
revtype tinyint,
|
|
752
|
primary key (REV, Credit_id, annotations_id)
|
|
753
|
);
|
|
754
|
|
|
755
|
create table Credit_Marker (
|
|
756
|
Credit_id integer not null,
|
|
757
|
markers_id integer not null,
|
|
758
|
primary key (Credit_id, markers_id),
|
|
759
|
unique (markers_id)
|
|
760
|
);
|
|
761
|
|
|
762
|
create table Credit_Marker_AUD (
|
|
763
|
REV integer not null,
|
|
764
|
Credit_id integer not null,
|
|
765
|
markers_id integer not null,
|
|
766
|
revtype tinyint,
|
|
767
|
primary key (REV, Credit_id, markers_id)
|
|
768
|
);
|
|
769
|
|
|
770
|
create table DefinedTermBase (
|
|
771
|
DTYPE varchar(31) not null,
|
|
772
|
id integer not null,
|
|
773
|
created timestamp,
|
|
774
|
uuid varchar(36),
|
|
775
|
updated timestamp,
|
|
776
|
lsid_authority varchar(255),
|
|
777
|
lsid_lsid varchar(255),
|
|
778
|
lsid_namespace varchar(255),
|
|
779
|
lsid_object varchar(255),
|
|
780
|
lsid_revision varchar(255),
|
|
781
|
protectedtitlecache bit not null,
|
|
782
|
titleCache varchar(255),
|
|
783
|
uri varchar(255),
|
|
784
|
iso639_1 varchar(2),
|
|
785
|
iso639_2 varchar(3),
|
|
786
|
istechnical bit,
|
|
787
|
orderindex integer,
|
|
788
|
symmetrical bit,
|
|
789
|
transitive bit,
|
|
790
|
defaultcolor varchar(255),
|
|
791
|
supportscategoricaldata bit,
|
|
792
|
supportscommontaxonname bit,
|
|
793
|
supportsdistribution bit,
|
|
794
|
supportsindividualassociation bit,
|
|
795
|
supportsquantitativedata bit,
|
|
796
|
supportstaxoninteraction bit,
|
|
797
|
supportstextdata bit,
|
|
798
|
pointapproximation_errorradius integer,
|
|
799
|
pointapproximation_latitude double,
|
|
800
|
pointapproximation_longitude double,
|
|
801
|
validperiod_end varchar(255),
|
|
802
|
validperiod_freetext varchar(255),
|
|
803
|
validperiod_start varchar(255),
|
|
804
|
iso3166_a2 varchar(2),
|
|
805
|
createdby_id integer,
|
|
806
|
updatedby_id integer,
|
|
807
|
kindof_id integer,
|
|
808
|
partof_id integer,
|
|
809
|
vocabulary_id integer,
|
|
810
|
level_id integer,
|
|
811
|
pointapproximation_referencesystem_id integer,
|
|
812
|
shape_id integer,
|
|
813
|
type_id integer,
|
|
814
|
primary key (id),
|
|
815
|
unique (uuid)
|
|
816
|
);
|
|
817
|
|
|
818
|
create table DefinedTermBase_AUD (
|
|
819
|
DTYPE varchar(31) not null,
|
|
820
|
id integer not null,
|
|
821
|
REV integer not null,
|
|
822
|
revtype tinyint,
|
|
823
|
created timestamp,
|
|
824
|
uuid varchar(36),
|
|
825
|
updated timestamp,
|
|
826
|
lsid_authority varchar(255),
|
|
827
|
lsid_lsid varchar(255),
|
|
828
|
lsid_namespace varchar(255),
|
|
829
|
lsid_object varchar(255),
|
|
830
|
lsid_revision varchar(255),
|
|
831
|
protectedtitlecache bit,
|
|
832
|
titleCache varchar(255),
|
|
833
|
uri varchar(255),
|
|
834
|
createdby_id integer,
|
|
835
|
updatedby_id integer,
|
|
836
|
kindof_id integer,
|
|
837
|
partof_id integer,
|
|
838
|
vocabulary_id integer,
|
|
839
|
istechnical bit,
|
|
840
|
orderindex integer,
|
|
841
|
iso639_1 varchar(2),
|
|
842
|
iso639_2 varchar(3),
|
|
843
|
symmetrical bit,
|
|
844
|
transitive bit,
|
|
845
|
pointapproximation_errorradius integer,
|
|
846
|
pointapproximation_latitude double,
|
|
847
|
pointapproximation_longitude double,
|
|
848
|
validperiod_end varchar(255),
|
|
849
|
validperiod_freetext varchar(255),
|
|
850
|
validperiod_start varchar(255),
|
|
851
|
level_id integer,
|
|
852
|
pointapproximation_referencesystem_id integer,
|
|
853
|
shape_id integer,
|
|
854
|
type_id integer,
|
|
855
|
iso3166_a2 varchar(2),
|
|
856
|
defaultcolor varchar(255),
|
|
857
|
supportscategoricaldata bit,
|
|
858
|
supportscommontaxonname bit,
|
|
859
|
supportsdistribution bit,
|
|
860
|
supportsindividualassociation bit,
|
|
861
|
supportsquantitativedata bit,
|
|
862
|
supportstaxoninteraction bit,
|
|
863
|
supportstextdata bit,
|
|
864
|
primary key (id, REV)
|
|
865
|
);
|
|
866
|
|
|
867
|
create table DefinedTermBase_Annotation (
|
|
868
|
DefinedTermBase_id integer not null,
|
|
869
|
annotations_id integer not null,
|
|
870
|
primary key (DefinedTermBase_id, annotations_id),
|
|
871
|
unique (annotations_id)
|
|
872
|
);
|
|
873
|
|
|
874
|
create table DefinedTermBase_Annotation_AUD (
|
|
875
|
REV integer not null,
|
|
876
|
DefinedTermBase_id integer not null,
|
|
877
|
annotations_id integer not null,
|
|
878
|
revtype tinyint,
|
|
879
|
primary key (REV, DefinedTermBase_id, annotations_id)
|
|
880
|
);
|
|
881
|
|
|
882
|
create table DefinedTermBase_Continent (
|
|
883
|
DefinedTermBase_id integer not null,
|
|
884
|
continents_id integer not null,
|
|
885
|
primary key (DefinedTermBase_id, continents_id)
|
|
886
|
);
|
|
887
|
|
|
888
|
create table DefinedTermBase_Continent_AUD (
|
|
889
|
REV integer not null,
|
|
890
|
DefinedTermBase_id integer not null,
|
|
891
|
continents_id integer not null,
|
|
892
|
revtype tinyint,
|
|
893
|
primary key (REV, DefinedTermBase_id, continents_id)
|
|
894
|
);
|
|
895
|
|
|
896
|
create table DefinedTermBase_Credit (
|
|
897
|
DefinedTermBase_id integer not null,
|
|
898
|
credits_id integer not null,
|
|
899
|
sortIndex integer not null,
|
|
900
|
primary key (DefinedTermBase_id, sortIndex),
|
|
901
|
unique (credits_id)
|
|
902
|
);
|
|
903
|
|
|
904
|
create table DefinedTermBase_Credit_AUD (
|
|
905
|
REV integer not null,
|
|
906
|
DefinedTermBase_id integer not null,
|
|
907
|
credits_id integer not null,
|
|
908
|
sortIndex integer not null,
|
|
909
|
revtype tinyint,
|
|
910
|
primary key (REV, DefinedTermBase_id, credits_id, sortIndex)
|
|
911
|
);
|
|
912
|
|
|
913
|
create table DefinedTermBase_Extension (
|
|
914
|
DefinedTermBase_id integer not null,
|
|
915
|
extensions_id integer not null,
|
|
916
|
primary key (DefinedTermBase_id, extensions_id),
|
|
917
|
unique (extensions_id)
|
|
918
|
);
|
|
919
|
|
|
920
|
create table DefinedTermBase_Extension_AUD (
|
|
921
|
REV integer not null,
|
|
922
|
DefinedTermBase_id integer not null,
|
|
923
|
extensions_id integer not null,
|
|
924
|
revtype tinyint,
|
|
925
|
primary key (REV, DefinedTermBase_id, extensions_id)
|
|
926
|
);
|
|
927
|
|
|
928
|
create table DefinedTermBase_Marker (
|
|
929
|
DefinedTermBase_id integer not null,
|
|
930
|
markers_id integer not null,
|
|
931
|
primary key (DefinedTermBase_id, markers_id),
|
|
932
|
unique (markers_id)
|
|
933
|
);
|
|
934
|
|
|
935
|
create table DefinedTermBase_Marker_AUD (
|
|
936
|
REV integer not null,
|
|
937
|
DefinedTermBase_id integer not null,
|
|
938
|
markers_id integer not null,
|
|
939
|
revtype tinyint,
|
|
940
|
primary key (REV, DefinedTermBase_id, markers_id)
|
|
941
|
);
|
|
942
|
|
|
943
|
create table DefinedTermBase_MeasurementUnit (
|
|
944
|
DefinedTermBase_id integer not null,
|
|
945
|
recommendedmeasurementunits_id integer not null,
|
|
946
|
primary key (DefinedTermBase_id, recommendedmeasurementunits_id)
|
|
947
|
);
|
|
948
|
|
|
949
|
create table DefinedTermBase_MeasurementUnit_AUD (
|
|
950
|
REV integer not null,
|
|
951
|
DefinedTermBase_id integer not null,
|
|
952
|
recommendedmeasurementunits_id integer not null,
|
|
953
|
revtype tinyint,
|
|
954
|
primary key (REV, DefinedTermBase_id, recommendedmeasurementunits_id)
|
|
955
|
);
|
|
956
|
|
|
957
|
create table DefinedTermBase_Media (
|
|
958
|
DefinedTermBase_id integer not null,
|
|
959
|
media_id integer not null,
|
|
960
|
primary key (DefinedTermBase_id, media_id),
|
|
961
|
unique (media_id)
|
|
962
|
);
|
|
963
|
|
|
964
|
create table DefinedTermBase_Media_AUD (
|
|
965
|
REV integer not null,
|
|
966
|
DefinedTermBase_id integer not null,
|
|
967
|
media_id integer not null,
|
|
968
|
revtype tinyint,
|
|
969
|
primary key (REV, DefinedTermBase_id, media_id)
|
|
970
|
);
|
|
971
|
|
|
972
|
create table DefinedTermBase_OriginalSourceBase (
|
|
973
|
DefinedTermBase_id integer not null,
|
|
974
|
sources_id integer not null,
|
|
975
|
primary key (DefinedTermBase_id, sources_id),
|
|
976
|
unique (sources_id)
|
|
977
|
);
|
|
978
|
|
|
979
|
create table DefinedTermBase_OriginalSourceBase_AUD (
|
|
980
|
REV integer not null,
|
|
981
|
DefinedTermBase_id integer not null,
|
|
982
|
sources_id integer not null,
|
|
983
|
revtype tinyint,
|
|
984
|
primary key (REV, DefinedTermBase_id, sources_id)
|
|
985
|
);
|
|
986
|
|
|
987
|
create table DefinedTermBase_RecommendedModifierEnumeration (
|
|
988
|
DefinedTermBase_id integer not null,
|
|
989
|
recommendedmodifierenumeration_id integer not null,
|
|
990
|
primary key (DefinedTermBase_id, recommendedmodifierenumeration_id),
|
|
991
|
unique (recommendedmodifierenumeration_id)
|
|
992
|
);
|
|
993
|
|
|
994
|
create table DefinedTermBase_RecommendedModifierEnumeration_AUD (
|
|
995
|
REV integer not null,
|
|
996
|
DefinedTermBase_id integer not null,
|
|
997
|
recommendedmodifierenumeration_id integer not null,
|
|
998
|
revtype tinyint,
|
|
999
|
primary key (REV, DefinedTermBase_id, recommendedmodifierenumeration_id)
|
|
1000
|
);
|
|
1001
|
|
|
1002
|
create table DefinedTermBase_Representation (
|
|
1003
|
DefinedTermBase_id integer not null,
|
|
1004
|
representations_id integer not null,
|
|
1005
|
primary key (DefinedTermBase_id, representations_id),
|
|
1006
|
unique (representations_id)
|
|
1007
|
);
|
|
1008
|
|
|
1009
|
create table DefinedTermBase_Representation_AUD (
|
|
1010
|
REV integer not null,
|
|
1011
|
DefinedTermBase_id integer not null,
|
|
1012
|
representations_id integer not null,
|
|
1013
|
revtype tinyint,
|
|
1014
|
primary key (REV, DefinedTermBase_id, representations_id)
|
|
1015
|
);
|
|
1016
|
|
|
1017
|
create table DefinedTermBase_Rights (
|
|
1018
|
DefinedTermBase_id integer not null,
|
|
1019
|
rights_id integer not null,
|
|
1020
|
primary key (DefinedTermBase_id, rights_id),
|
|
1021
|
unique (rights_id)
|
|
1022
|
);
|
|
1023
|
|
|
1024
|
create table DefinedTermBase_Rights_AUD (
|
|
1025
|
REV integer not null,
|
|
1026
|
DefinedTermBase_id integer not null,
|
|
1027
|
rights_id integer not null,
|
|
1028
|
revtype tinyint,
|
|
1029
|
primary key (REV, DefinedTermBase_id, rights_id)
|
|
1030
|
);
|
|
1031
|
|
|
1032
|
create table DefinedTermBase_StatisticalMeasure (
|
|
1033
|
DefinedTermBase_id integer not null,
|
|
1034
|
recommendedstatisticalmeasures_id integer not null,
|
|
1035
|
primary key (DefinedTermBase_id, recommendedstatisticalmeasures_id)
|
|
1036
|
);
|
|
1037
|
|
|
1038
|
create table DefinedTermBase_StatisticalMeasure_AUD (
|
|
1039
|
REV integer not null,
|
|
1040
|
DefinedTermBase_id integer not null,
|
|
1041
|
recommendedstatisticalmeasures_id integer not null,
|
|
1042
|
revtype tinyint,
|
|
1043
|
primary key (REV, DefinedTermBase_id, recommendedstatisticalmeasures_id)
|
|
1044
|
);
|
|
1045
|
|
|
1046
|
create table DefinedTermBase_SupportedCategoricalEnumeration (
|
|
1047
|
DefinedTermBase_id integer not null,
|
|
1048
|
supportedcategoricalenumerations_id integer not null,
|
|
1049
|
primary key (DefinedTermBase_id, supportedcategoricalenumerations_id),
|
|
1050
|
unique (supportedcategoricalenumerations_id)
|
|
1051
|
);
|
|
1052
|
|
|
1053
|
create table DefinedTermBase_SupportedCategoricalEnumeration_AUD (
|
|
1054
|
REV integer not null,
|
|
1055
|
DefinedTermBase_id integer not null,
|
|
1056
|
supportedcategoricalenumerations_id integer not null,
|
|
1057
|
revtype tinyint,
|
|
1058
|
primary key (REV, DefinedTermBase_id, supportedcategoricalenumerations_id)
|
|
1059
|
);
|
|
1060
|
|
|
1061
|
create table DefinedTermBase_WaterbodyOrCountry (
|
|
1062
|
DefinedTermBase_id integer not null,
|
|
1063
|
waterbodiesorcountries_id integer not null,
|
|
1064
|
primary key (DefinedTermBase_id, waterbodiesorcountries_id)
|
|
1065
|
);
|
|
1066
|
|
|
1067
|
create table DefinedTermBase_WaterbodyOrCountry_AUD (
|
|
1068
|
REV integer not null,
|
|
1069
|
DefinedTermBase_id integer not null,
|
|
1070
|
waterbodiesorcountries_id integer not null,
|
|
1071
|
revtype tinyint,
|
|
1072
|
primary key (REV, DefinedTermBase_id, waterbodiesorcountries_id)
|
|
1073
|
);
|
|
1074
|
|
|
1075
|
create table DerivationEvent (
|
|
1076
|
id integer not null,
|
|
1077
|
created timestamp,
|
|
1078
|
uuid varchar(36),
|
|
1079
|
updated timestamp,
|
|
1080
|
description varchar(255),
|
|
1081
|
timeperiod_end varchar(255),
|
|
1082
|
timeperiod_freetext varchar(255),
|
|
1083
|
timeperiod_start varchar(255),
|
|
1084
|
createdby_id integer,
|
|
1085
|
updatedby_id integer,
|
|
1086
|
actor_id integer,
|
|
1087
|
type_id integer,
|
|
1088
|
primary key (id),
|
|
1089
|
unique (uuid)
|
|
1090
|
);
|
|
1091
|
|
|
1092
|
create table DerivationEvent_AUD (
|
|
1093
|
id integer not null,
|
|
1094
|
REV integer not null,
|
|
1095
|
revtype tinyint,
|
|
1096
|
created timestamp,
|
|
1097
|
uuid varchar(36),
|
|
1098
|
updated timestamp,
|
|
1099
|
description varchar(255),
|
|
1100
|
timeperiod_end varchar(255),
|
|
1101
|
timeperiod_freetext varchar(255),
|
|
1102
|
timeperiod_start varchar(255),
|
|
1103
|
createdby_id integer,
|
|
1104
|
updatedby_id integer,
|
|
1105
|
actor_id integer,
|
|
1106
|
type_id integer,
|
|
1107
|
primary key (id, REV)
|
|
1108
|
);
|
|
1109
|
|
|
1110
|
create table DerivationEvent_Annotation (
|
|
1111
|
DerivationEvent_id integer not null,
|
|
1112
|
annotations_id integer not null,
|
|
1113
|
primary key (DerivationEvent_id, annotations_id),
|
|
1114
|
unique (annotations_id)
|
|
1115
|
);
|
|
1116
|
|
|
1117
|
create table DerivationEvent_Annotation_AUD (
|
|
1118
|
REV integer not null,
|
|
1119
|
DerivationEvent_id integer not null,
|
|
1120
|
annotations_id integer not null,
|
|
1121
|
revtype tinyint,
|
|
1122
|
primary key (REV, DerivationEvent_id, annotations_id)
|
|
1123
|
);
|
|
1124
|
|
|
1125
|
create table DerivationEvent_Marker (
|
|
1126
|
DerivationEvent_id integer not null,
|
|
1127
|
markers_id integer not null,
|
|
1128
|
primary key (DerivationEvent_id, markers_id),
|
|
1129
|
unique (markers_id)
|
|
1130
|
);
|
|
1131
|
|
|
1132
|
create table DerivationEvent_Marker_AUD (
|
|
1133
|
REV integer not null,
|
|
1134
|
DerivationEvent_id integer not null,
|
|
1135
|
markers_id integer not null,
|
|
1136
|
revtype tinyint,
|
|
1137
|
primary key (REV, DerivationEvent_id, markers_id)
|
|
1138
|
);
|
|
1139
|
|
|
1140
|
create table DescriptionBase (
|
|
1141
|
DTYPE varchar(31) not null,
|
|
1142
|
id integer not null,
|
|
1143
|
created timestamp,
|
|
1144
|
uuid varchar(36),
|
|
1145
|
updated timestamp,
|
|
1146
|
lsid_authority varchar(255),
|
|
1147
|
lsid_lsid varchar(255),
|
|
1148
|
lsid_namespace varchar(255),
|
|
1149
|
lsid_object varchar(255),
|
|
1150
|
lsid_revision varchar(255),
|
|
1151
|
protectedtitlecache bit not null,
|
|
1152
|
titleCache varchar(255),
|
|
1153
|
imagegallery bit not null,
|
|
1154
|
createdby_id integer,
|
|
1155
|
updatedby_id integer,
|
|
1156
|
taxon_id integer,
|
|
1157
|
taxonname_id integer,
|
|
1158
|
primary key (id),
|
|
1159
|
unique (uuid)
|
|
1160
|
);
|
|
1161
|
|
|
1162
|
create table DescriptionBase_AUD (
|
|
1163
|
DTYPE varchar(31) not null,
|
|
1164
|
id integer not null,
|
|
1165
|
REV integer not null,
|
|
1166
|
revtype tinyint,
|
|
1167
|
created timestamp,
|
|
1168
|
uuid varchar(36),
|
|
1169
|
updated timestamp,
|
|
1170
|
lsid_authority varchar(255),
|
|
1171
|
lsid_lsid varchar(255),
|
|
1172
|
lsid_namespace varchar(255),
|
|
1173
|
lsid_object varchar(255),
|
|
1174
|
lsid_revision varchar(255),
|
|
1175
|
protectedtitlecache bit,
|
|
1176
|
titleCache varchar(255),
|
|
1177
|
imagegallery bit,
|
|
1178
|
createdby_id integer,
|
|
1179
|
updatedby_id integer,
|
|
1180
|
taxon_id integer,
|
|
1181
|
taxonname_id integer,
|
|
1182
|
primary key (id, REV)
|
|
1183
|
);
|
|
1184
|
|
|
1185
|
create table DescriptionBase_Annotation (
|
|
1186
|
DescriptionBase_id integer not null,
|
|
1187
|
annotations_id integer not null,
|
|
1188
|
primary key (DescriptionBase_id, annotations_id),
|
|
1189
|
unique (annotations_id)
|
|
1190
|
);
|
|
1191
|
|
|
1192
|
create table DescriptionBase_Annotation_AUD (
|
|
1193
|
REV integer not null,
|
|
1194
|
DescriptionBase_id integer not null,
|
|
1195
|
annotations_id integer not null,
|
|
1196
|
revtype tinyint,
|
|
1197
|
primary key (REV, DescriptionBase_id, annotations_id)
|
|
1198
|
);
|
|
1199
|
|
|
1200
|
create table DescriptionBase_Credit (
|
|
1201
|
DescriptionBase_id integer not null,
|
|
1202
|
credits_id integer not null,
|
|
1203
|
sortIndex integer not null,
|
|
1204
|
primary key (DescriptionBase_id, sortIndex),
|
|
1205
|
unique (credits_id)
|
|
1206
|
);
|
|
1207
|
|
|
1208
|
create table DescriptionBase_Credit_AUD (
|
|
1209
|
REV integer not null,
|
|
1210
|
DescriptionBase_id integer not null,
|
|
1211
|
credits_id integer not null,
|
|
1212
|
sortIndex integer not null,
|
|
1213
|
revtype tinyint,
|
|
1214
|
primary key (REV, DescriptionBase_id, credits_id, sortIndex)
|
|
1215
|
);
|
|
1216
|
|
|
1217
|
create table DescriptionBase_Extension (
|
|
1218
|
DescriptionBase_id integer not null,
|
|
1219
|
extensions_id integer not null,
|
|
1220
|
primary key (DescriptionBase_id, extensions_id),
|
|
1221
|
unique (extensions_id)
|
|
1222
|
);
|
|
1223
|
|
|
1224
|
create table DescriptionBase_Extension_AUD (
|
|
1225
|
REV integer not null,
|
|
1226
|
DescriptionBase_id integer not null,
|
|
1227
|
extensions_id integer not null,
|
|
1228
|
revtype tinyint,
|
|
1229
|
primary key (REV, DescriptionBase_id, extensions_id)
|
|
1230
|
);
|
|
1231
|
|
|
1232
|
create table DescriptionBase_Feature (
|
|
1233
|
DescriptionBase_id integer not null,
|
|
1234
|
descriptivesystem_id integer not null,
|
|
1235
|
primary key (DescriptionBase_id, descriptivesystem_id)
|
|
1236
|
);
|
|
1237
|
|
|
1238
|
create table DescriptionBase_Feature_AUD (
|
|
1239
|
REV integer not null,
|
|
1240
|
DescriptionBase_id integer not null,
|
|
1241
|
descriptivesystem_id integer not null,
|
|
1242
|
revtype tinyint,
|
|
1243
|
primary key (REV, DescriptionBase_id, descriptivesystem_id)
|
|
1244
|
);
|
|
1245
|
|
|
1246
|
create table DescriptionBase_GeoScope (
|
|
1247
|
DescriptionBase_id integer not null,
|
|
1248
|
geoscopes_id integer not null,
|
|
1249
|
primary key (DescriptionBase_id, geoscopes_id)
|
|
1250
|
);
|
|
1251
|
|
|
1252
|
create table DescriptionBase_GeoScope_AUD (
|
|
1253
|
REV integer not null,
|
|
1254
|
DescriptionBase_id integer not null,
|
|
1255
|
geoscopes_id integer not null,
|
|
1256
|
revtype tinyint,
|
|
1257
|
primary key (REV, DescriptionBase_id, geoscopes_id)
|
|
1258
|
);
|
|
1259
|
|
|
1260
|
create table DescriptionBase_Marker (
|
|
1261
|
DescriptionBase_id integer not null,
|
|
1262
|
markers_id integer not null,
|
|
1263
|
primary key (DescriptionBase_id, markers_id),
|
|
1264
|
unique (markers_id)
|
|
1265
|
);
|
|
1266
|
|
|
1267
|
create table DescriptionBase_Marker_AUD (
|
|
1268
|
REV integer not null,
|
|
1269
|
DescriptionBase_id integer not null,
|
|
1270
|
markers_id integer not null,
|
|
1271
|
revtype tinyint,
|
|
1272
|
primary key (REV, DescriptionBase_id, markers_id)
|
|
1273
|
);
|
|
1274
|
|
|
1275
|
create table DescriptionBase_OriginalSourceBase (
|
|
1276
|
DescriptionBase_id integer not null,
|
|
1277
|
sources_id integer not null,
|
|
1278
|
primary key (DescriptionBase_id, sources_id),
|
|
1279
|
unique (sources_id)
|
|
1280
|
);
|
|
1281
|
|
|
1282
|
create table DescriptionBase_OriginalSourceBase_AUD (
|
|
1283
|
REV integer not null,
|
|
1284
|
DescriptionBase_id integer not null,
|
|
1285
|
sources_id integer not null,
|
|
1286
|
revtype tinyint,
|
|
1287
|
primary key (REV, DescriptionBase_id, sources_id)
|
|
1288
|
);
|
|
1289
|
|
|
1290
|
create table DescriptionBase_Reference (
|
|
1291
|
DescriptionBase_id integer not null,
|
|
1292
|
descriptionsources_id integer not null,
|
|
1293
|
primary key (DescriptionBase_id, descriptionsources_id)
|
|
1294
|
);
|
|
1295
|
|
|
1296
|
create table DescriptionBase_Reference_AUD (
|
|
1297
|
REV integer not null,
|
|
1298
|
DescriptionBase_id integer not null,
|
|
1299
|
descriptionsources_id integer not null,
|
|
1300
|
revtype tinyint,
|
|
1301
|
primary key (REV, DescriptionBase_id, descriptionsources_id)
|
|
1302
|
);
|
|
1303
|
|
|
1304
|
create table DescriptionBase_Rights (
|
|
1305
|
DescriptionBase_id integer not null,
|
|
1306
|
rights_id integer not null,
|
|
1307
|
primary key (DescriptionBase_id, rights_id),
|
|
1308
|
unique (rights_id)
|
|
1309
|
);
|
|
1310
|
|
|
1311
|
create table DescriptionBase_Rights_AUD (
|
|
1312
|
REV integer not null,
|
|
1313
|
DescriptionBase_id integer not null,
|
|
1314
|
rights_id integer not null,
|
|
1315
|
revtype tinyint,
|
|
1316
|
primary key (REV, DescriptionBase_id, rights_id)
|
|
1317
|
);
|
|
1318
|
|
|
1319
|
create table DescriptionBase_Scope (
|
|
1320
|
DescriptionBase_id integer not null,
|
|
1321
|
scopes_id integer not null,
|
|
1322
|
primary key (DescriptionBase_id, scopes_id)
|
|
1323
|
);
|
|
1324
|
|
|
1325
|
create table DescriptionBase_Scope_AUD (
|
|
1326
|
REV integer not null,
|
|
1327
|
DescriptionBase_id integer not null,
|
|
1328
|
scopes_id integer not null,
|
|
1329
|
revtype tinyint,
|
|
1330
|
primary key (REV, DescriptionBase_id, scopes_id)
|
|
1331
|
);
|
|
1332
|
|
|
1333
|
create table DescriptionBase_SpecimenOrObservationBase (
|
|
1334
|
descriptions_id integer not null,
|
|
1335
|
describedspecimenorobservations_id integer not null,
|
|
1336
|
primary key (descriptions_id, describedspecimenorobservations_id)
|
|
1337
|
);
|
|
1338
|
|
|
1339
|
create table DescriptionBase_SpecimenOrObservationBase_AUD (
|
|
1340
|
REV integer not null,
|
|
1341
|
descriptions_id integer not null,
|
|
1342
|
describedspecimenorobservations_id integer not null,
|
|
1343
|
revtype tinyint,
|
|
1344
|
primary key (REV, descriptions_id, describedspecimenorobservations_id)
|
|
1345
|
);
|
|
1346
|
|
|
1347
|
create table DescriptionElementBase (
|
|
1348
|
DTYPE varchar(31) not null,
|
|
1349
|
id integer not null,
|
|
1350
|
created timestamp,
|
|
1351
|
uuid varchar(36),
|
|
1352
|
updated timestamp,
|
|
1353
|
orderrelevant bit,
|
|
1354
|
name varchar(255),
|
|
1355
|
createdby_id integer,
|
|
1356
|
updatedby_id integer,
|
|
1357
|
feature_id integer,
|
|
1358
|
indescription_id integer,
|
|
1359
|
language_id integer,
|
|
1360
|
area_id integer,
|
|
1361
|
status_id integer,
|
|
1362
|
associatedspecimenorobservation_id integer,
|
|
1363
|
unit_id integer,
|
|
1364
|
taxon2_id integer,
|
|
1365
|
format_id integer,
|
|
1366
|
primary key (id),
|
|
1367
|
unique (uuid)
|
|
1368
|
);
|
|
1369
|
|
|
1370
|
create table DescriptionElementBase_AUD (
|
|
1371
|
DTYPE varchar(31) not null,
|
|
1372
|
id integer not null,
|
|
1373
|
REV integer not null,
|
|
1374
|
revtype tinyint,
|
|
1375
|
created timestamp,
|
|
1376
|
uuid varchar(36),
|
|
1377
|
updated timestamp,
|
|
1378
|
createdby_id integer,
|
|
1379
|
updatedby_id integer,
|
|
1380
|
feature_id integer,
|
|
1381
|
indescription_id integer,
|
|
1382
|
orderrelevant bit,
|
|
1383
|
associatedspecimenorobservation_id integer,
|
|
1384
|
name varchar(255),
|
|
1385
|
language_id integer,
|
|
1386
|
taxon2_id integer,
|
|
1387
|
area_id integer,
|
|
1388
|
status_id integer,
|
|
1389
|
unit_id integer,
|
|
1390
|
format_id integer,
|
|
1391
|
primary key (id, REV)
|
|
1392
|
);
|
|
1393
|
|
|
1394
|
create table DescriptionElementBase_Annotation (
|
|
1395
|
DescriptionElementBase_id integer not null,
|
|
1396
|
annotations_id integer not null,
|
|
1397
|
primary key (DescriptionElementBase_id, annotations_id),
|
|
1398
|
unique (annotations_id)
|
|
1399
|
);
|
|
1400
|
|
|
1401
|
create table DescriptionElementBase_Annotation_AUD (
|
|
1402
|
REV integer not null,
|
|
1403
|
DescriptionElementBase_id integer not null,
|
|
1404
|
annotations_id integer not null,
|
|
1405
|
revtype tinyint,
|
|
1406
|
primary key (REV, DescriptionElementBase_id, annotations_id)
|
|
1407
|
);
|
|
1408
|
|
|
1409
|
create table DescriptionElementBase_LanguageString (
|
|
1410
|
DescriptionElementBase_id integer not null,
|
|
1411
|
multilanguagetext_id integer not null,
|
|
1412
|
multilanguagetext_mapkey_id integer not null,
|
|
1413
|
primary key (DescriptionElementBase_id, multilanguagetext_mapkey_id),
|
|
1414
|
unique (multilanguagetext_id)
|
|
1415
|
);
|
|
1416
|
|
|
1417
|
create table DescriptionElementBase_LanguageString_AUD (
|
|
1418
|
REV integer not null,
|
|
1419
|
DescriptionElementBase_id integer not null,
|
|
1420
|
multilanguagetext_id integer not null,
|
|
1421
|
multilanguagetext_mapkey_id integer not null,
|
|
1422
|
revtype tinyint,
|
|
1423
|
primary key (REV, DescriptionElementBase_id, multilanguagetext_id, multilanguagetext_mapkey_id)
|
|
1424
|
);
|
|
1425
|
|
|
1426
|
create table DescriptionElementBase_Marker (
|
|
1427
|
DescriptionElementBase_id integer not null,
|
|
1428
|
markers_id integer not null,
|
|
1429
|
primary key (DescriptionElementBase_id, markers_id),
|
|
1430
|
unique (markers_id)
|
|
1431
|
);
|
|
1432
|
|
|
1433
|
create table DescriptionElementBase_Marker_AUD (
|
|
1434
|
REV integer not null,
|
|
1435
|
DescriptionElementBase_id integer not null,
|
|
1436
|
markers_id integer not null,
|
|
1437
|
revtype tinyint,
|
|
1438
|
primary key (REV, DescriptionElementBase_id, markers_id)
|
|
1439
|
);
|
|
1440
|
|
|
1441
|
create table DescriptionElementBase_Media (
|
|
1442
|
DescriptionElementBase_id integer not null,
|
|
1443
|
media_id integer not null,
|
|
1444
|
sortIndex integer not null,
|
|
1445
|
primary key (DescriptionElementBase_id, sortIndex)
|
|
1446
|
);
|
|
1447
|
|
|
1448
|
create table DescriptionElementBase_Media_AUD (
|
|
1449
|
REV integer not null,
|
|
1450
|
DescriptionElementBase_id integer not null,
|
|
1451
|
media_id integer not null,
|
|
1452
|
sortIndex integer not null,
|
|
1453
|
revtype tinyint,
|
|
1454
|
primary key (REV, DescriptionElementBase_id, media_id, sortIndex)
|
|
1455
|
);
|
|
1456
|
|
|
1457
|
create table DescriptionElementBase_Modifier (
|
|
1458
|
DescriptionElementBase_id integer not null,
|
|
1459
|
modifiers_id integer not null,
|
|
1460
|
primary key (DescriptionElementBase_id, modifiers_id)
|
|
1461
|
);
|
|
1462
|
|
|
1463
|
create table DescriptionElementBase_Modifier_AUD (
|
|
1464
|
REV integer not null,
|
|
1465
|
DescriptionElementBase_id integer not null,
|
|
1466
|
modifiers_id integer not null,
|
|
1467
|
revtype tinyint,
|
|
1468
|
primary key (REV, DescriptionElementBase_id, modifiers_id)
|
|
1469
|
);
|
|
1470
|
|
|
1471
|
create table DescriptionElementBase_ModifyingText (
|
|
1472
|
DescriptionElementBase_id integer not null,
|
|
1473
|
modifyingtext_id integer not null,
|
|
1474
|
modifyingtext_mapkey_id integer not null,
|
|
1475
|
primary key (DescriptionElementBase_id, modifyingtext_mapkey_id),
|
|
1476
|
unique (modifyingtext_id)
|
|
1477
|
);
|
|
1478
|
|
|
1479
|
create table DescriptionElementBase_ModifyingText_AUD (
|
|
1480
|
REV integer not null,
|
|
1481
|
DescriptionElementBase_id integer not null,
|
|
1482
|
modifyingtext_id integer not null,
|
|
1483
|
modifyingtext_mapkey_id integer not null,
|
|
1484
|
revtype tinyint,
|
|
1485
|
primary key (REV, DescriptionElementBase_id, modifyingtext_id, modifyingtext_mapkey_id)
|
|
1486
|
);
|
|
1487
|
|
|
1488
|
create table DescriptionElementBase_OriginalSourceBase (
|
|
1489
|
DescriptionElementBase_id integer not null,
|
|
1490
|
sources_id integer not null,
|
|
1491
|
primary key (DescriptionElementBase_id, sources_id),
|
|
1492
|
unique (sources_id)
|
|
1493
|
);
|
|
1494
|
|
|
1495
|
create table DescriptionElementBase_OriginalSourceBase_AUD (
|
|
1496
|
REV integer not null,
|
|
1497
|
DescriptionElementBase_id integer not null,
|
|
1498
|
sources_id integer not null,
|
|
1499
|
revtype tinyint,
|
|
1500
|
primary key (REV, DescriptionElementBase_id, sources_id)
|
|
1501
|
);
|
|
1502
|
|
|
1503
|
create table DescriptionElementBase_StateData (
|
|
1504
|
DescriptionElementBase_id integer not null,
|
|
1505
|
states_id integer not null
|
|
1506
|
);
|
|
1507
|
|
|
1508
|
create table DescriptionElementBase_StateData_AUD (
|
|
1509
|
REV integer not null,
|
|
1510
|
DescriptionElementBase_id integer not null,
|
|
1511
|
states_id integer not null,
|
|
1512
|
revtype tinyint,
|
|
1513
|
primary key (REV, DescriptionElementBase_id, states_id)
|
|
1514
|
);
|
|
1515
|
|
|
1516
|
create table DescriptionElementBase_StatisticalMeasurementValue (
|
|
1517
|
DescriptionElementBase_id integer not null,
|
|
1518
|
statisticalvalues_id integer not null,
|
|
1519
|
primary key (DescriptionElementBase_id, statisticalvalues_id),
|
|
1520
|
unique (statisticalvalues_id)
|
|
1521
|
);
|
|
1522
|
|
|
1523
|
create table DescriptionElementBase_StatisticalMeasurementValue_AUD (
|
|
1524
|
REV integer not null,
|
|
1525
|
DescriptionElementBase_id integer not null,
|
|
1526
|
statisticalvalues_id integer not null,
|
|
1527
|
revtype tinyint,
|
|
1528
|
primary key (REV, DescriptionElementBase_id, statisticalvalues_id)
|
|
1529
|
);
|
|
1530
|
|
|
1531
|
create table DeterminationEvent (
|
|
1532
|
id integer not null,
|
|
1533
|
created timestamp,
|
|
1534
|
uuid varchar(36),
|
|
1535
|
updated timestamp,
|
|
1536
|
description varchar(255),
|
|
1537
|
timeperiod_end varchar(255),
|
|
1538
|
timeperiod_freetext varchar(255),
|
|
1539
|
timeperiod_start varchar(255),
|
|
1540
|
preferredflag bit not null,
|
|
1541
|
createdby_id integer,
|
|
1542
|
updatedby_id integer,
|
|
1543
|
actor_id integer,
|
|
1544
|
identifiedunit_id integer,
|
|
1545
|
modifier_id integer,
|
|
1546
|
taxon_id integer,
|
|
1547
|
primary key (id),
|
|
1548
|
unique (uuid)
|
|
1549
|
);
|
|
1550
|
|
|
1551
|
create table DeterminationEvent_AUD (
|
|
1552
|
id integer not null,
|
|
1553
|
REV integer not null,
|
|
1554
|
revtype tinyint,
|
|
1555
|
created timestamp,
|
|
1556
|
uuid varchar(36),
|
|
1557
|
updated timestamp,
|
|
1558
|
description varchar(255),
|
|
1559
|
timeperiod_end varchar(255),
|
|
1560
|
timeperiod_freetext varchar(255),
|
|
1561
|
timeperiod_start varchar(255),
|
|
1562
|
preferredflag bit,
|
|
1563
|
createdby_id integer,
|
|
1564
|
updatedby_id integer,
|
|
1565
|
actor_id integer,
|
|
1566
|
identifiedunit_id integer,
|
|
1567
|
modifier_id integer,
|
|
1568
|
taxon_id integer,
|
|
1569
|
primary key (id, REV)
|
|
1570
|
);
|
|
1571
|
|
|
1572
|
create table DeterminationEvent_Annotation (
|
|
1573
|
DeterminationEvent_id integer not null,
|
|
1574
|
annotations_id integer not null,
|
|
1575
|
primary key (DeterminationEvent_id, annotations_id),
|
|
1576
|
unique (annotations_id)
|
|
1577
|
);
|
|
1578
|
|
|
1579
|
create table DeterminationEvent_Annotation_AUD (
|
|
1580
|
REV integer not null,
|
|
1581
|
DeterminationEvent_id integer not null,
|
|
1582
|
annotations_id integer not null,
|
|
1583
|
revtype tinyint,
|
|
1584
|
primary key (REV, DeterminationEvent_id, annotations_id)
|
|
1585
|
);
|
|
1586
|
|
|
1587
|
create table DeterminationEvent_Marker (
|
|
1588
|
DeterminationEvent_id integer not null,
|
|
1589
|
markers_id integer not null,
|
|
1590
|
primary key (DeterminationEvent_id, markers_id),
|
|
1591
|
unique (markers_id)
|
|
1592
|
);
|
|
1593
|
|
|
1594
|
create table DeterminationEvent_Marker_AUD (
|
|
1595
|
REV integer not null,
|
|
1596
|
DeterminationEvent_id integer not null,
|
|
1597
|
markers_id integer not null,
|
|
1598
|
revtype tinyint,
|
|
1599
|
primary key (REV, DeterminationEvent_id, markers_id)
|
|
1600
|
);
|
|
1601
|
|
|
1602
|
create table DeterminationEvent_Reference (
|
|
1603
|
DeterminationEvent_id integer not null,
|
|
1604
|
setofreferences_id integer not null,
|
|
1605
|
primary key (DeterminationEvent_id, setofreferences_id)
|
|
1606
|
);
|
|
1607
|
|
|
1608
|
create table DeterminationEvent_Reference_AUD (
|
|
1609
|
REV integer not null,
|
|
1610
|
DeterminationEvent_id integer not null,
|
|
1611
|
setofreferences_id integer not null,
|
|
1612
|
revtype tinyint,
|
|
1613
|
primary key (REV, DeterminationEvent_id, setofreferences_id)
|
|
1614
|
);
|
|
1615
|
|
|
1616
|
create table Extension (
|
|
1617
|
id integer not null,
|
|
1618
|
created timestamp,
|
|
1619
|
uuid varchar(36),
|
|
1620
|
updated timestamp,
|
|
1621
|
extendedObj_type varchar(255),
|
|
1622
|
extendedObj_id integer not null,
|
|
1623
|
value longvarchar,
|
|
1624
|
createdby_id integer,
|
|
1625
|
updatedby_id integer,
|
|
1626
|
type_id integer,
|
|
1627
|
primary key (id),
|
|
1628
|
unique (uuid)
|
|
1629
|
);
|
|
1630
|
|
|
1631
|
create table Extension_AUD (
|
|
1632
|
id integer not null,
|
|
1633
|
REV integer not null,
|
|
1634
|
revtype tinyint,
|
|
1635
|
created timestamp,
|
|
1636
|
uuid varchar(36),
|
|
1637
|
updated timestamp,
|
|
1638
|
value longvarchar,
|
|
1639
|
createdby_id integer,
|
|
1640
|
updatedby_id integer,
|
|
1641
|
type_id integer,
|
|
1642
|
primary key (id, REV)
|
|
1643
|
);
|
|
1644
|
|
|
1645
|
create table FeatureNode (
|
|
1646
|
id integer not null,
|
|
1647
|
created timestamp,
|
|
1648
|
uuid varchar(36),
|
|
1649
|
updated timestamp,
|
|
1650
|
createdby_id integer,
|
|
1651
|
updatedby_id integer,
|
|
1652
|
featureTree_id integer not null,
|
|
1653
|
feature_id integer,
|
|
1654
|
parent_id integer,
|
|
1655
|
sortindex integer,
|
|
1656
|
primary key (id),
|
|
1657
|
unique (uuid)
|
|
1658
|
);
|
|
1659
|
|
|
1660
|
create table FeatureNode_AUD (
|
|
1661
|
id integer not null,
|
|
1662
|
REV integer not null,
|
|
1663
|
revtype tinyint,
|
|
1664
|
created timestamp,
|
|
1665
|
uuid varchar(36),
|
|
1666
|
updated timestamp,
|
|
1667
|
createdby_id integer,
|
|
1668
|
updatedby_id integer,
|
|
1669
|
featureTree_id integer not null,
|
|
1670
|
feature_id integer,
|
|
1671
|
parent_id integer,
|
|
1672
|
sortindex integer,
|
|
1673
|
primary key (id, REV)
|
|
1674
|
);
|
|
1675
|
|
|
1676
|
create table FeatureNode_DefinedTermBase_InapplicableIf (
|
|
1677
|
FeatureNode_id integer not null,
|
|
1678
|
inapplicableif_id integer not null,
|
|
1679
|
primary key (FeatureNode_id, inapplicableif_id)
|
|
1680
|
);
|
|
1681
|
|
|
1682
|
create table FeatureNode_DefinedTermBase_InapplicableIf_AUD (
|
|
1683
|
REV integer not null,
|
|
1684
|
FeatureNode_id integer not null,
|
|
1685
|
inapplicableif_id integer not null,
|
|
1686
|
revtype tinyint,
|
|
1687
|
primary key (REV, FeatureNode_id, inapplicableif_id)
|
|
1688
|
);
|
|
1689
|
|
|
1690
|
create table FeatureNode_DefinedTermBase_OnlyApplicable (
|
|
1691
|
FeatureNode_id integer not null,
|
|
1692
|
onlyapplicableif_id integer not null,
|
|
1693
|
primary key (FeatureNode_id, onlyapplicableif_id)
|
|
1694
|
);
|
|
1695
|
|
|
1696
|
create table FeatureNode_DefinedTermBase_OnlyApplicable_AUD (
|
|
1697
|
REV integer not null,
|
|
1698
|
FeatureNode_id integer not null,
|
|
1699
|
onlyapplicableif_id integer not null,
|
|
1700
|
revtype tinyint,
|
|
1701
|
primary key (REV, FeatureNode_id, onlyapplicableif_id)
|
|
1702
|
);
|
|
1703
|
|
|
1704
|
create table FeatureTree (
|
|
1705
|
id integer not null,
|
|
1706
|
created timestamp,
|
|
1707
|
uuid varchar(36),
|
|
1708
|
updated timestamp,
|
|
1709
|
lsid_authority varchar(255),
|
|
1710
|
lsid_lsid varchar(255),
|
|
1711
|
lsid_namespace varchar(255),
|
|
1712
|
lsid_object varchar(255),
|
|
1713
|
lsid_revision varchar(255),
|
|
1714
|
protectedtitlecache bit not null,
|
|
1715
|
titleCache varchar(255),
|
|
1716
|
uri varchar(255),
|
|
1717
|
descriptionseparated bit not null,
|
|
1718
|
createdby_id integer,
|
|
1719
|
updatedby_id integer,
|
|
1720
|
root_id integer,
|
|
1721
|
primary key (id),
|
|
1722
|
unique (uuid)
|
|
1723
|
);
|
|
1724
|
|
|
1725
|
create table FeatureTree_AUD (
|
|
1726
|
DTYPE varchar(31) not null,
|
|
1727
|
id integer not null,
|
|
1728
|
REV integer not null,
|
|
1729
|
revtype tinyint,
|
|
1730
|
created timestamp,
|
|
1731
|
uuid varchar(36),
|
|
1732
|
updated timestamp,
|
|
1733
|
lsid_authority varchar(255),
|
|
1734
|
lsid_lsid varchar(255),
|
|
1735
|
lsid_namespace varchar(255),
|
|
1736
|
lsid_object varchar(255),
|
|
1737
|
lsid_revision varchar(255),
|
|
1738
|
protectedtitlecache bit,
|
|
1739
|
titleCache varchar(255),
|
|
1740
|
uri varchar(255),
|
|
1741
|
descriptionseparated bit,
|
|
1742
|
createdby_id integer,
|
|
1743
|
updatedby_id integer,
|
|
1744
|
root_id integer,
|
|
1745
|
primary key (id, REV)
|
|
1746
|
);
|
|
1747
|
|
|
1748
|
create table FeatureTree_Annotation (
|
|
1749
|
FeatureTree_id integer not null,
|
|
1750
|
annotations_id integer not null,
|
|
1751
|
primary key (FeatureTree_id, annotations_id),
|
|
1752
|
unique (annotations_id)
|
|
1753
|
);
|
|
1754
|
|
|
1755
|
create table FeatureTree_Annotation_AUD (
|
|
1756
|
REV integer not null,
|
|
1757
|
FeatureTree_id integer not null,
|
|
1758
|
annotations_id integer not null,
|
|
1759
|
revtype tinyint,
|
|
1760
|
primary key (REV, FeatureTree_id, annotations_id)
|
|
1761
|
);
|
|
1762
|
|
|
1763
|
create table FeatureTree_Credit (
|
|
1764
|
FeatureTree_id integer not null,
|
|
1765
|
credits_id integer not null,
|
|
1766
|
sortIndex integer not null,
|
|
1767
|
primary key (FeatureTree_id, sortIndex),
|
|
1768
|
unique (credits_id)
|
|
1769
|
);
|
|
1770
|
|
|
1771
|
create table FeatureTree_Credit_AUD (
|
|
1772
|
REV integer not null,
|
|
1773
|
FeatureTree_id integer not null,
|
|
1774
|
credits_id integer not null,
|
|
1775
|
sortIndex integer not null,
|
|
1776
|
revtype tinyint,
|
|
1777
|
primary key (REV, FeatureTree_id, credits_id, sortIndex)
|
|
1778
|
);
|
|
1779
|
|
|
1780
|
create table FeatureTree_Extension (
|
|
1781
|
FeatureTree_id integer not null,
|
|
1782
|
extensions_id integer not null,
|
|
1783
|
primary key (FeatureTree_id, extensions_id),
|
|
1784
|
unique (extensions_id)
|
|
1785
|
);
|
|
1786
|
|
|
1787
|
create table FeatureTree_Extension_AUD (
|
|
1788
|
REV integer not null,
|
|
1789
|
FeatureTree_id integer not null,
|
|
1790
|
extensions_id integer not null,
|
|
1791
|
revtype tinyint,
|
|
1792
|
primary key (REV, FeatureTree_id, extensions_id)
|
|
1793
|
);
|
|
1794
|
|
|
1795
|
create table FeatureTree_Marker (
|
|
1796
|
FeatureTree_id integer not null,
|
|
1797
|
markers_id integer not null,
|
|
1798
|
primary key (FeatureTree_id, markers_id),
|
|
1799
|
unique (markers_id)
|
|
1800
|
);
|
|
1801
|
|
|
1802
|
create table FeatureTree_Marker_AUD (
|
|
1803
|
REV integer not null,
|
|
1804
|
FeatureTree_id integer not null,
|
|
1805
|
markers_id integer not null,
|
|
1806
|
revtype tinyint,
|
|
1807
|
primary key (REV, FeatureTree_id, markers_id)
|
|
1808
|
);
|
|
1809
|
|
|
1810
|
create table FeatureTree_OriginalSourceBase (
|
|
1811
|
FeatureTree_id integer not null,
|
|
1812
|
sources_id integer not null,
|
|
1813
|
primary key (FeatureTree_id, sources_id),
|
|
1814
|
unique (sources_id)
|
|
1815
|
);
|
|
1816
|
|
|
1817
|
create table FeatureTree_OriginalSourceBase_AUD (
|
|
1818
|
REV integer not null,
|
|
1819
|
FeatureTree_id integer not null,
|
|
1820
|
sources_id integer not null,
|
|
1821
|
revtype tinyint,
|
|
1822
|
primary key (REV, FeatureTree_id, sources_id)
|
|
1823
|
);
|
|
1824
|
|
|
1825
|
create table FeatureTree_Representation (
|
|
1826
|
FeatureTree_id integer not null,
|
|
1827
|
representations_id integer not null,
|
|
1828
|
primary key (FeatureTree_id, representations_id),
|
|
1829
|
unique (representations_id)
|
|
1830
|
);
|
|
1831
|
|
|
1832
|
create table FeatureTree_Representation_AUD (
|
|
1833
|
REV integer not null,
|
|
1834
|
FeatureTree_id integer not null,
|
|
1835
|
representations_id integer not null,
|
|
1836
|
revtype tinyint,
|
|
1837
|
primary key (REV, FeatureTree_id, representations_id)
|
|
1838
|
);
|
|
1839
|
|
|
1840
|
create table FeatureTree_Rights (
|
|
1841
|
FeatureTree_id integer not null,
|
|
1842
|
rights_id integer not null,
|
|
1843
|
primary key (FeatureTree_id, rights_id),
|
|
1844
|
unique (rights_id)
|
|
1845
|
);
|
|
1846
|
|
|
1847
|
create table FeatureTree_Rights_AUD (
|
|
1848
|
REV integer not null,
|
|
1849
|
FeatureTree_id integer not null,
|
|
1850
|
rights_id integer not null,
|
|
1851
|
revtype tinyint,
|
|
1852
|
primary key (REV, FeatureTree_id, rights_id)
|
|
1853
|
);
|
|
1854
|
|
|
1855
|
create table FeatureTree_TaxonBase (
|
|
1856
|
FeatureTree_id integer not null,
|
|
1857
|
coveredtaxa_id integer not null,
|
|
1858
|
primary key (FeatureTree_id, coveredtaxa_id)
|
|
1859
|
);
|
|
1860
|
|
|
1861
|
create table FeatureTree_TaxonBase_AUD (
|
|
1862
|
REV integer not null,
|
|
1863
|
FeatureTree_id integer not null,
|
|
1864
|
coveredtaxa_id integer not null,
|
|
1865
|
revtype tinyint,
|
|
1866
|
primary key (REV, FeatureTree_id, coveredtaxa_id)
|
|
1867
|
);
|
|
1868
|
|
|
1869
|
create table GatheringEvent (
|
|
1870
|
id integer not null,
|
|
1871
|
created timestamp,
|
|
1872
|
uuid varchar(36),
|
|
1873
|
updated timestamp,
|
|
1874
|
description varchar(255),
|
|
1875
|
timeperiod_end varchar(255),
|
|
1876
|
timeperiod_freetext varchar(255),
|
|
1877
|
timeperiod_start varchar(255),
|
|
1878
|
absoluteelevation integer,
|
|
1879
|
absoluteelevationerror integer,
|
|
1880
|
collectingmethod varchar(255),
|
|
1881
|
distancetoground integer,
|
|
1882
|
distancetowatersurface integer,
|
|
1883
|
exactlocation_errorradius integer,
|
|
1884
|
exactlocation_latitude double,
|
|
1885
|
exactlocation_longitude double,
|
|
1886
|
createdby_id integer,
|
|
1887
|
updatedby_id integer,
|
|
1888
|
country_id integer,
|
|
1889
|
actor_id integer,
|
|
1890
|
exactlocation_referencesystem_id integer,
|
|
1891
|
locality_id integer,
|
|
1892
|
primary key (id),
|
|
1893
|
unique (uuid)
|
|
1894
|
);
|
|
1895
|
|
|
1896
|
create table GatheringEvent_AUD (
|
|
1897
|
id integer not null,
|
|
1898
|
REV integer not null,
|
|
1899
|
revtype tinyint,
|
|
1900
|
created timestamp,
|
|
1901
|
uuid varchar(36),
|
|
1902
|
updated timestamp,
|
|
1903
|
description varchar(255),
|
|
1904
|
timeperiod_end varchar(255),
|
|
1905
|
timeperiod_freetext varchar(255),
|
|
1906
|
timeperiod_start varchar(255),
|
|
1907
|
absoluteelevation integer,
|
|
1908
|
absoluteelevationerror integer,
|
|
1909
|
collectingmethod varchar(255),
|
|
1910
|
distancetoground integer,
|
|
1911
|
distancetowatersurface integer,
|
|
1912
|
exactlocation_errorradius integer,
|
|
1913
|
exactlocation_latitude double,
|
|
1914
|
exactlocation_longitude double,
|
|
1915
|
createdby_id integer,
|
|
1916
|
updatedby_id integer,
|
|
1917
|
country_id integer,
|
|
1918
|
actor_id integer,
|
|
1919
|
exactlocation_referencesystem_id integer,
|
|
1920
|
locality_id integer,
|
|
1921
|
primary key (id, REV)
|
|
1922
|
);
|
|
1923
|
|
|
1924
|
create table GatheringEvent_Annotation (
|
|
1925
|
GatheringEvent_id integer not null,
|
|
1926
|
annotations_id integer not null,
|
|
1927
|
primary key (GatheringEvent_id, annotations_id),
|
|
1928
|
unique (annotations_id)
|
|
1929
|
);
|
|
1930
|
|
|
1931
|
create table GatheringEvent_Annotation_AUD (
|
|
1932
|
REV integer not null,
|
|
1933
|
GatheringEvent_id integer not null,
|
|
1934
|
annotations_id integer not null,
|
|
1935
|
revtype tinyint,
|
|
1936
|
primary key (REV, GatheringEvent_id, annotations_id)
|
|
1937
|
);
|
|
1938
|
|
|
1939
|
create table GatheringEvent_DefinedTermBase (
|
|
1940
|
GatheringEvent_id integer not null,
|
|
1941
|
collectingareas_id integer not null,
|
|
1942
|
primary key (GatheringEvent_id, collectingareas_id)
|
|
1943
|
);
|
|
1944
|
|
|
1945
|
create table GatheringEvent_DefinedTermBase_AUD (
|
|
1946
|
REV integer not null,
|
|
1947
|
GatheringEvent_id integer not null,
|
|
1948
|
collectingareas_id integer not null,
|
|
1949
|
revtype tinyint,
|
|
1950
|
primary key (REV, GatheringEvent_id, collectingareas_id)
|
|
1951
|
);
|
|
1952
|
|
|
1953
|
create table GatheringEvent_Marker (
|
|
1954
|
GatheringEvent_id integer not null,
|
|
1955
|
markers_id integer not null,
|
|
1956
|
primary key (GatheringEvent_id, markers_id),
|
|
1957
|
unique (markers_id)
|
|
1958
|
);
|
|
1959
|
|
|
1960
|
create table GatheringEvent_Marker_AUD (
|
|
1961
|
REV integer not null,
|
|
1962
|
GatheringEvent_id integer not null,
|
|
1963
|
markers_id integer not null,
|
|
1964
|
revtype tinyint,
|
|
1965
|
primary key (REV, GatheringEvent_id, markers_id)
|
|
1966
|
);
|
|
1967
|
|
|
1968
|
create table GenBankAccession (
|
|
1969
|
id integer not null,
|
|
1970
|
created timestamp,
|
|
1971
|
uuid varchar(36),
|
|
1972
|
updated timestamp,
|
|
1973
|
accessionnumber varchar(255),
|
|
1974
|
uri varchar(255),
|
|
1975
|
createdby_id integer,
|
|
1976
|
updatedby_id integer,
|
|
1977
|
primary key (id),
|
|
1978
|
unique (uuid)
|
|
1979
|
);
|
|
1980
|
|
|
1981
|
create table GenBankAccession_AUD (
|
|
1982
|
id integer not null,
|
|
1983
|
REV integer not null,
|
|
1984
|
revtype tinyint,
|
|
1985
|
created timestamp,
|
|
1986
|
uuid varchar(36),
|
|
1987
|
updated timestamp,
|
|
1988
|
accessionnumber varchar(255),
|
|
1989
|
uri varchar(255),
|
|
1990
|
createdby_id integer,
|
|
1991
|
updatedby_id integer,
|
|
1992
|
primary key (id, REV)
|
|
1993
|
);
|
|
1994
|
|
|
1995
|
create table GrantedAuthorityImpl (
|
|
1996
|
id integer not null,
|
|
1997
|
created timestamp,
|
|
1998
|
uuid varchar(36),
|
|
1999
|
authority varchar(255),
|
|
2000
|
createdby_id integer,
|
|
2001
|
primary key (id),
|
|
2002
|
unique (uuid, authority)
|
|
2003
|
);
|
|
2004
|
|
|
2005
|
create table hibernate_sequences (
|
|
2006
|
sequence_name varchar(255),
|
|
2007
|
next_val integer,
|
|
2008
|
primary key (sequence_name)
|
|
2009
|
);
|
|
2010
|
|
|
2011
|
create table HomotypicalGroup (
|
|
2012
|
id integer not null,
|
|
2013
|
created timestamp,
|
|
2014
|
uuid varchar(36),
|
|
2015
|
updated timestamp,
|
|
2016
|
createdby_id integer,
|
|
2017
|
updatedby_id integer,
|
|
2018
|
primary key (id),
|
|
2019
|
unique (uuid)
|
|
2020
|
);
|
|
2021
|
|
|
2022
|
create table HomotypicalGroup_AUD (
|
|
2023
|
id integer not null,
|
|
2024
|
REV integer not null,
|
|
2025
|
revtype tinyint,
|
|
2026
|
created timestamp,
|
|
2027
|
uuid varchar(36),
|
|
2028
|
updated timestamp,
|
|
2029
|
createdby_id integer,
|
|
2030
|
updatedby_id integer,
|
|
2031
|
primary key (id, REV)
|
|
2032
|
);
|
|
2033
|
|
|
2034
|
create table HomotypicalGroup_Annotation (
|
|
2035
|
HomotypicalGroup_id integer not null,
|
|
2036
|
annotations_id integer not null,
|
|
2037
|
primary key (HomotypicalGroup_id, annotations_id),
|
|
2038
|
unique (annotations_id)
|
|
2039
|
);
|
|
2040
|
|
|
2041
|
create table HomotypicalGroup_Annotation_AUD (
|
|
2042
|
REV integer not null,
|
|
2043
|
HomotypicalGroup_id integer not null,
|
|
2044
|
annotations_id integer not null,
|
|
2045
|
revtype tinyint,
|
|
2046
|
primary key (REV, HomotypicalGroup_id, annotations_id)
|
|
2047
|
);
|
|
2048
|
|
|
2049
|
create table HomotypicalGroup_Marker (
|
|
2050
|
HomotypicalGroup_id integer not null,
|
|
2051
|
markers_id integer not null,
|
|
2052
|
primary key (HomotypicalGroup_id, markers_id),
|
|
2053
|
unique (markers_id)
|
|
2054
|
);
|
|
2055
|
|
|
2056
|
create table HomotypicalGroup_Marker_AUD (
|
|
2057
|
REV integer not null,
|
|
2058
|
HomotypicalGroup_id integer not null,
|
|
2059
|
markers_id integer not null,
|
|
2060
|
revtype tinyint,
|
|
2061
|
primary key (REV, HomotypicalGroup_id, markers_id)
|
|
2062
|
);
|
|
2063
|
|
|
2064
|
create table HybridRelationship (
|
|
2065
|
id integer not null,
|
|
2066
|
created timestamp,
|
|
2067
|
uuid varchar(36),
|
|
2068
|
updated timestamp,
|
|
2069
|
citationmicroreference varchar(255),
|
|
2070
|
originalnamestring varchar(255),
|
|
2071
|
doubtful bit not null,
|
|
2072
|
ruleconsidered varchar(255),
|
|
2073
|
createdby_id integer,
|
|
2074
|
updatedby_id integer,
|
|
2075
|
citation_id integer,
|
|
2076
|
relatedfrom_id integer,
|
|
2077
|
relatedto_id integer,
|
|
2078
|
type_id integer,
|
|
2079
|
primary key (id),
|
|
2080
|
unique (uuid)
|
|
2081
|
);
|
|
2082
|
|
|
2083
|
create table HybridRelationship_AUD (
|
|
2084
|
id integer not null,
|
|
2085
|
REV integer not null,
|
|
2086
|
revtype tinyint,
|
|
2087
|
created timestamp,
|
|
2088
|
uuid varchar(36),
|
|
2089
|
updated timestamp,
|
|
2090
|
citationmicroreference varchar(255),
|
|
2091
|
originalnamestring varchar(255),
|
|
2092
|
doubtful bit,
|
|
2093
|
ruleconsidered varchar(255),
|
|
2094
|
createdby_id integer,
|
|
2095
|
updatedby_id integer,
|
|
2096
|
citation_id integer,
|
|
2097
|
relatedfrom_id integer,
|
|
2098
|
relatedto_id integer,
|
|
2099
|
type_id integer,
|
|
2100
|
primary key (id, REV)
|
|
2101
|
);
|
|
2102
|
|
|
2103
|
create table HybridRelationship_Annotation (
|
|
2104
|
HybridRelationship_id integer not null,
|
|
2105
|
annotations_id integer not null,
|
|
2106
|
primary key (HybridRelationship_id, annotations_id),
|
|
2107
|
unique (annotations_id)
|
|
2108
|
);
|
|
2109
|
|
|
2110
|
create table HybridRelationship_Annotation_AUD (
|
|
2111
|
REV integer not null,
|
|
2112
|
HybridRelationship_id integer not null,
|
|
2113
|
annotations_id integer not null,
|
|
2114
|
revtype tinyint,
|
|
2115
|
primary key (REV, HybridRelationship_id, annotations_id)
|
|
2116
|
);
|
|
2117
|
|
|
2118
|
create table HybridRelationship_Marker (
|
|
2119
|
HybridRelationship_id integer not null,
|
|
2120
|
markers_id integer not null,
|
|
2121
|
primary key (HybridRelationship_id, markers_id),
|
|
2122
|
unique (markers_id)
|
|
2123
|
);
|
|
2124
|
|
|
2125
|
create table HybridRelationship_Marker_AUD (
|
|
2126
|
REV integer not null,
|
|
2127
|
HybridRelationship_id integer not null,
|
|
2128
|
markers_id integer not null,
|
|
2129
|
revtype tinyint,
|
|
2130
|
primary key (REV, HybridRelationship_id, markers_id)
|
|
2131
|
);
|
|
2132
|
|
|
2133
|
create table IndividualAssociation_LanguageString (
|
|
2134
|
DescriptionElementBase_id integer not null,
|
|
2135
|
description_id integer not null,
|
|
2136
|
description_mapkey_id integer not null,
|
|
2137
|
primary key (DescriptionElementBase_id, description_mapkey_id),
|
|
2138
|
unique (description_id)
|
|
2139
|
);
|
|
2140
|
|
|
2141
|
create table IndividualAssociation_LanguageString_AUD (
|
|
2142
|
REV integer not null,
|
|
2143
|
DescriptionElementBase_id integer not null,
|
|
2144
|
description_id integer not null,
|
|
2145
|
description_mapkey_id integer not null,
|
|
2146
|
revtype tinyint,
|
|
2147
|
primary key (REV, DescriptionElementBase_id, description_id, description_mapkey_id)
|
|
2148
|
);
|
|
2149
|
|
|
2150
|
create table InstitutionalMembership (
|
|
2151
|
id integer not null,
|
|
2152
|
created timestamp,
|
|
2153
|
uuid varchar(36),
|
|
2154
|
updated timestamp,
|
|
2155
|
department varchar(255),
|
|
2156
|
period_end varchar(255),
|
|
2157
|
period_freetext varchar(255),
|
|
2158
|
period_start varchar(255),
|
|
2159
|
role varchar(255),
|
|
2160
|
createdby_id integer,
|
|
2161
|
updatedby_id integer,
|
|
2162
|
institute_id integer,
|
|
2163
|
person_id integer,
|
|
2164
|
primary key (id),
|
|
2165
|
unique (uuid)
|
|
2166
|
);
|
|
2167
|
|
|
2168
|
create table InstitutionalMembership_AUD (
|
|
2169
|
id integer not null,
|
|
2170
|
REV integer not null,
|
|
2171
|
revtype tinyint,
|
|
2172
|
created timestamp,
|
|
2173
|
uuid varchar(36),
|
|
2174
|
updated timestamp,
|
|
2175
|
department varchar(255),
|
|
2176
|
period_end varchar(255),
|
|
2177
|
period_freetext varchar(255),
|
|
2178
|
period_start varchar(255),
|
|
2179
|
role varchar(255),
|
|
2180
|
createdby_id integer,
|
|
2181
|
updatedby_id integer,
|
|
2182
|
institute_id integer,
|
|
2183
|
person_id integer,
|
|
2184
|
primary key (id, REV)
|
|
2185
|
);
|
|
2186
|
|
|
2187
|
create table KeyStatement (
|
|
2188
|
id integer not null,
|
|
2189
|
created timestamp,
|
|
2190
|
uuid varchar(36),
|
|
2191
|
updated timestamp,
|
|
2192
|
createdby_id integer,
|
|
2193
|
updatedby_id integer,
|
|
2194
|
primary key (id),
|
|
2195
|
unique (uuid)
|
|
2196
|
);
|
|
2197
|
|
|
2198
|
create table KeyStatement_AUD (
|
|
2199
|
id integer not null,
|
|
2200
|
REV integer not null,
|
|
2201
|
revtype tinyint,
|
|
2202
|
created timestamp,
|
|
2203
|
uuid varchar(36),
|
|
2204
|
updated timestamp,
|
|
2205
|
createdby_id integer,
|
|
2206
|
updatedby_id integer,
|
|
2207
|
primary key (id, REV)
|
|
2208
|
);
|
|
2209
|
|
|
2210
|
create table KeyStatement_LanguageString (
|
|
2211
|
keyStatement_id integer not null,
|
|
2212
|
label_id integer not null,
|
|
2213
|
label_mapkey_id integer not null,
|
|
2214
|
primary key (keyStatement_id, label_mapkey_id),
|
|
2215
|
unique (label_id)
|
|
2216
|
);
|
|
2217
|
|
|
2218
|
create table KeyStatement_LanguageString_AUD (
|
|
2219
|
REV integer not null,
|
|
2220
|
keyStatement_id integer not null,
|
|
2221
|
label_id integer not null,
|
|
2222
|
label_mapkey_id integer not null,
|
|
2223
|
revtype tinyint,
|
|
2224
|
primary key (REV, keyStatement_id, label_id, label_mapkey_id)
|
|
2225
|
);
|
|
2226
|
|
|
2227
|
create table LSIDAuthority (
|
|
2228
|
id integer not null,
|
|
2229
|
created timestamp,
|
|
2230
|
uuid varchar(36),
|
|
2231
|
authority varchar(255),
|
|
2232
|
authoritywsdl longvarchar,
|
|
2233
|
port integer not null,
|
|
2234
|
server varchar(255),
|
|
2235
|
url varchar(255),
|
|
2236
|
createdby_id integer,
|
|
2237
|
primary key (id),
|
|
2238
|
unique (uuid, authority)
|
|
2239
|
);
|
|
2240
|
|
|
2241
|
create table LSIDAuthority_namespaces (
|
|
2242
|
LSIDAuthority_id integer not null,
|
|
2243
|
namespaces_element varchar(255),
|
|
2244
|
namespaces_mapkey varchar(255),
|
|
2245
|
primary key (LSIDAuthority_id, namespaces_mapkey)
|
|
2246
|
);
|
|
2247
|
|
|
2248
|
create table LanguageString (
|
|
2249
|
id integer not null,
|
|
2250
|
created timestamp,
|
|
2251
|
uuid varchar(36),
|
|
2252
|
updated timestamp,
|
|
2253
|
text longvarchar,
|
|
2254
|
createdby_id integer,
|
|
2255
|
updatedby_id integer,
|
|
2256
|
language_id integer,
|
|
2257
|
primary key (id),
|
|
2258
|
unique (uuid)
|
|
2259
|
);
|
|
2260
|
|
|
2261
|
create table LanguageString_AUD (
|
|
2262
|
id integer not null,
|
|
2263
|
REV integer not null,
|
|
2264
|
revtype tinyint,
|
|
2265
|
created timestamp,
|
|
2266
|
uuid varchar(36),
|
|
2267
|
updated timestamp,
|
|
2268
|
text longvarchar,
|
|
2269
|
createdby_id integer,
|
|
2270
|
updatedby_id integer,
|
|
2271
|
language_id integer,
|
|
2272
|
primary key (id, REV)
|
|
2273
|
);
|
|
2274
|
|
|
2275
|
create table LanguageString_Annotation (
|
|
2276
|
LanguageString_id integer not null,
|
|
2277
|
annotations_id integer not null,
|
|
2278
|
primary key (LanguageString_id, annotations_id),
|
|
2279
|
unique (annotations_id)
|
|
2280
|
);
|
|
2281
|
|
|
2282
|
create table LanguageString_Annotation_AUD (
|
|
2283
|
REV integer not null,
|
|
2284
|
LanguageString_id integer not null,
|
|
2285
|
annotations_id integer not null,
|
|
2286
|
revtype tinyint,
|
|
2287
|
primary key (REV, LanguageString_id, annotations_id)
|
|
2288
|
);
|
|
2289
|
|
|
2290
|
create table LanguageString_Marker (
|
|
2291
|
LanguageString_id integer not null,
|
|
2292
|
markers_id integer not null,
|
|
2293
|
primary key (LanguageString_id, markers_id),
|
|
2294
|
unique (markers_id)
|
|
2295
|
);
|
|
2296
|
|
|
2297
|
create table LanguageString_Marker_AUD (
|
|
2298
|
REV integer not null,
|
|
2299
|
LanguageString_id integer not null,
|
|
2300
|
markers_id integer not null,
|
|
2301
|
revtype tinyint,
|
|
2302
|
primary key (REV, LanguageString_id, markers_id)
|
|
2303
|
);
|
|
2304
|
|
|
2305
|
create table Locus (
|
|
2306
|
id integer not null,
|
|
2307
|
created timestamp,
|
|
2308
|
uuid varchar(36),
|
|
2309
|
updated timestamp,
|
|
2310
|
description varchar(255),
|
|
2311
|
name varchar(255),
|
|
2312
|
createdby_id integer,
|
|
2313
|
updatedby_id integer,
|
|
2314
|
primary key (id),
|
|
2315
|
unique (uuid)
|
|
2316
|
);
|
|
2317
|
|
|
2318
|
create table Locus_AUD (
|
|
2319
|
id integer not null,
|
|
2320
|
REV integer not null,
|
|
2321
|
revtype tinyint,
|
|
2322
|
created timestamp,
|
|
2323
|
uuid varchar(36),
|
|
2324
|
updated timestamp,
|
|
2325
|
description varchar(255),
|
|
2326
|
name varchar(255),
|
|
2327
|
createdby_id integer,
|
|
2328
|
updatedby_id integer,
|
|
2329
|
primary key (id, REV)
|
|
2330
|
);
|
|
2331
|
|
|
2332
|
create table Marker (
|
|
2333
|
id integer not null,
|
|
2334
|
created timestamp,
|
|
2335
|
uuid varchar(36),
|
|
2336
|
updated timestamp,
|
|
2337
|
flag bit not null,
|
|
2338
|
markedObj_type varchar(255),
|
|
2339
|
markedObj_id integer not null,
|
|
2340
|
createdby_id integer,
|
|
2341
|
updatedby_id integer,
|
|
2342
|
markertype_id integer,
|
|
2343
|
primary key (id),
|
|
2344
|
unique (uuid)
|
|
2345
|
);
|
|
2346
|
|
|
2347
|
create table Marker_AUD (
|
|
2348
|
id integer not null,
|
|
2349
|
REV integer not null,
|
|
2350
|
revtype tinyint,
|
|
2351
|
created timestamp,
|
|
2352
|
uuid varchar(36),
|
|
2353
|
updated timestamp,
|
|
2354
|
flag bit,
|
|
2355
|
createdby_id integer,
|
|
2356
|
updatedby_id integer,
|
|
2357
|
markertype_id integer,
|
|
2358
|
primary key (id, REV)
|
|
2359
|
);
|
|
2360
|
|
|
2361
|
create table Media (
|
|
2362
|
DTYPE varchar(31) not null,
|
|
2363
|
id integer not null,
|
|
2364
|
created timestamp,
|
|
2365
|
uuid varchar(36),
|
|
2366
|
updated timestamp,
|
|
2367
|
lsid_authority varchar(255),
|
|
2368
|
lsid_lsid varchar(255),
|
|
2369
|
lsid_namespace varchar(255),
|
|
2370
|
lsid_object varchar(255),
|
|
2371
|
lsid_revision varchar(255),
|
|
2372
|
protectedtitlecache bit not null,
|
|
2373
|
titleCache varchar(255),
|
|
2374
|
mediacreated timestamp,
|
|
2375
|
citationmicroreference varchar(255),
|
|
2376
|
createdby_id integer,
|
|
2377
|
updatedby_id integer,
|
|
2378
|
artist_id integer,
|
|
2379
|
citation_id integer,
|
|
2380
|
primary key (id),
|
|
2381
|
unique (uuid)
|
|
2382
|
);
|
|
2383
|
|
|
2384
|
create table MediaKey_NamedArea (
|
|
2385
|
Media_id integer not null,
|
|
2386
|
geographicalscope_id integer not null,
|
|
2387
|
primary key (Media_id, geographicalscope_id)
|
|
2388
|
);
|
|
2389
|
|
|
2390
|
create table MediaKey_NamedArea_AUD (
|
|
2391
|
REV integer not null,
|
|
2392
|
Media_id integer not null,
|
|
2393
|
geographicalscope_id integer not null,
|
|
2394
|
revtype tinyint,
|
|
2395
|
primary key (REV, Media_id, geographicalscope_id)
|
|
2396
|
);
|
|
2397
|
|
|
2398
|
create table MediaKey_Scope (
|
|
2399
|
Media_id integer not null,
|
|
2400
|
scoperestrictions_id integer not null,
|
|
2401
|
primary key (Media_id, scoperestrictions_id)
|
|
2402
|
);
|
|
2403
|
|
|
2404
|
create table MediaKey_Scope_AUD (
|
|
2405
|
REV integer not null,
|
|
2406
|
Media_id integer not null,
|
|
2407
|
scoperestrictions_id integer not null,
|
|
2408
|
revtype tinyint,
|
|
2409
|
primary key (REV, Media_id, scoperestrictions_id)
|
|
2410
|
);
|
|
2411
|
|
|
2412
|
create table MediaKey_Taxon (
|
|
2413
|
mediaKey_id integer not null,
|
|
2414
|
taxon_id integer not null,
|
|
2415
|
primary key (mediaKey_id, taxon_id)
|
|
2416
|
);
|
|
2417
|
|
|
2418
|
create table MediaKey_Taxon_AUD (
|
|
2419
|
REV integer not null,
|
|
2420
|
mediaKey_id integer not null,
|
|
2421
|
taxon_id integer not null,
|
|
2422
|
revtype tinyint,
|
|
2423
|
primary key (REV, mediaKey_id, taxon_id)
|
|
2424
|
);
|
|
2425
|
|
|
2426
|
create table MediaRepresentation (
|
|
2427
|
id integer not null,
|
|
2428
|
created timestamp,
|
|
2429
|
uuid varchar(36),
|
|
2430
|
updated timestamp,
|
|
2431
|
mimetype varchar(255),
|
|
2432
|
suffix varchar(255),
|
|
2433
|
createdby_id integer,
|
|
2434
|
updatedby_id integer,
|
|
2435
|
media_id integer,
|
|
2436
|
primary key (id),
|
|
2437
|
unique (uuid)
|
|
2438
|
);
|
|
2439
|
|
|
2440
|
create table MediaRepresentationPart (
|
|
2441
|
DTYPE varchar(31) not null,
|
|
2442
|
id integer not null,
|
|
2443
|
created timestamp,
|
|
2444
|
uuid varchar(36),
|
|
2445
|
updated timestamp,
|
|
2446
|
size integer,
|
|
2447
|
uri varchar(255),
|
|
2448
|
duration integer,
|
|
2449
|
height integer,
|
|
2450
|
width integer,
|
|
2451
|
createdby_id integer,
|
|
2452
|
updatedby_id integer,
|
|
2453
|
representation_id integer not null,
|
|
2454
|
sortIndex integer,
|
|
2455
|
primary key (id),
|
|
2456
|
unique (uuid)
|
|
2457
|
);
|
|
2458
|
|
|
2459
|
create table MediaRepresentationPart_AUD (
|
|
2460
|
DTYPE varchar(31) not null,
|
|
2461
|
id integer not null,
|
|
2462
|
REV integer not null,
|
|
2463
|
revtype tinyint,
|
|
2464
|
created timestamp,
|
|
2465
|
uuid varchar(36),
|
|
2466
|
updated timestamp,
|
|
2467
|
size integer,
|
|
2468
|
uri varchar(255),
|
|
2469
|
createdby_id integer,
|
|
2470
|
updatedby_id integer,
|
|
2471
|
representation_id integer,
|
|
2472
|
duration integer,
|
|
2473
|
height integer,
|
|
2474
|
width integer,
|
|
2475
|
primary key (id, REV)
|
|
2476
|
);
|
|
2477
|
|
|
2478
|
create table MediaRepresentation_AUD (
|
|
2479
|
id integer not null,
|
|
2480
|
REV integer not null,
|
|
2481
|
revtype tinyint,
|
|
2482
|
created timestamp,
|
|
2483
|
uuid varchar(36),
|
|
2484
|
updated timestamp,
|
|
2485
|
mimetype varchar(255),
|
|
2486
|
suffix varchar(255),
|
|
2487
|
createdby_id integer,
|
|
2488
|
updatedby_id integer,
|
|
2489
|
media_id integer,
|
|
2490
|
primary key (id, REV)
|
|
2491
|
);
|
|
2492
|
|
|
2493
|
create table MediaRepresentation_MediaRepresentationPart_AUD (
|
|
2494
|
REV integer not null,
|
|
2495
|
representation_id integer not null,
|
|
2496
|
id integer not null,
|
|
2497
|
sortIndex integer not null,
|
|
2498
|
revtype tinyint,
|
|
2499
|
primary key (REV, representation_id, id, sortIndex)
|
|
2500
|
);
|
|
2501
|
|
|
2502
|
create table Media_AUD (
|
|
2503
|
DTYPE varchar(31) not null,
|
|
2504
|
id integer not null,
|
|
2505
|
REV integer not null,
|
|
2506
|
revtype tinyint,
|
|
2507
|
created timestamp,
|
|
2508
|
uuid varchar(36),
|
|
2509
|
updated timestamp,
|
|
2510
|
lsid_authority varchar(255),
|
|
2511
|
lsid_lsid varchar(255),
|
|
2512
|
lsid_namespace varchar(255),
|
|
2513
|
lsid_object varchar(255),
|
|
2514
|
lsid_revision varchar(255),
|
|
2515
|
protectedtitlecache bit,
|
|
2516
|
titleCache varchar(255),
|
|
2517
|
mediacreated timestamp,
|
|
2518
|
createdby_id integer,
|
|
2519
|
updatedby_id integer,
|
|
2520
|
artist_id integer,
|
|
2521
|
citationmicroreference varchar(255),
|
|
2522
|
citation_id integer,
|
|
2523
|
primary key (id, REV)
|
|
2524
|
);
|
|
2525
|
|
|
2526
|
create table Media_Annotation (
|
|
2527
|
Media_id integer not null,
|
|
2528
|
annotations_id integer not null,
|
|
2529
|
primary key (Media_id, annotations_id),
|
|
2530
|
unique (annotations_id)
|
|
2531
|
);
|
|
2532
|
|
|
2533
|
create table Media_Annotation_AUD (
|
|
2534
|
REV integer not null,
|
|
2535
|
Media_id integer not null,
|
|
2536
|
annotations_id integer not null,
|
|
2537
|
revtype tinyint,
|
|
2538
|
primary key (REV, Media_id, annotations_id)
|
|
2539
|
);
|
|
2540
|
|
|
2541
|
create table Media_Credit (
|
|
2542
|
Media_id integer not null,
|
|
2543
|
credits_id integer not null,
|
|
2544
|
sortIndex integer not null,
|
|
2545
|
primary key (Media_id, sortIndex),
|
|
2546
|
unique (credits_id)
|
|
2547
|
);
|
|
2548
|
|
|
2549
|
create table Media_Credit_AUD (
|
|
2550
|
REV integer not null,
|
|
2551
|
Media_id integer not null,
|
|
2552
|
credits_id integer not null,
|
|
2553
|
sortIndex integer not null,
|
|
2554
|
revtype tinyint,
|
|
2555
|
primary key (REV, Media_id, credits_id, sortIndex)
|
|
2556
|
);
|
|
2557
|
|
|
2558
|
create table Media_Description (
|
|
2559
|
Media_id integer not null,
|
|
2560
|
description_id integer not null,
|
|
2561
|
description_mapkey_id integer not null,
|
|
2562
|
primary key (Media_id, description_mapkey_id),
|
|
2563
|
unique (description_id)
|
|
2564
|
);
|
|
2565
|
|
|
2566
|
create table Media_Description_AUD (
|
|
2567
|
REV integer not null,
|
|
2568
|
Media_id integer not null,
|
|
2569
|
description_id integer not null,
|
|
2570
|
description_mapkey_id integer not null,
|
|
2571
|
revtype tinyint,
|
|
2572
|
primary key (REV, Media_id, description_id, description_mapkey_id)
|
|
2573
|
);
|
|
2574
|
|
|
2575
|
create table Media_Extension (
|
|
2576
|
Media_id integer not null,
|
|
2577
|
extensions_id integer not null,
|
|
2578
|
primary key (Media_id, extensions_id),
|
|
2579
|
unique (extensions_id)
|
|
2580
|
);
|
|
2581
|
|
|
2582
|
create table Media_Extension_AUD (
|
|
2583
|
REV integer not null,
|
|
2584
|
Media_id integer not null,
|
|
2585
|
extensions_id integer not null,
|
|
2586
|
revtype tinyint,
|
|
2587
|
primary key (REV, Media_id, extensions_id)
|
|
2588
|
);
|
|
2589
|
|
|
2590
|
create table Media_LanguageString (
|
|
2591
|
Media_id integer not null,
|
|
2592
|
title_id integer not null,
|
|
2593
|
title_mapkey_id integer not null,
|
|
2594
|
primary key (Media_id, title_mapkey_id),
|
|
2595
|
unique (title_id)
|
|
2596
|
);
|
|
2597
|
|
|
2598
|
create table Media_LanguageString_AUD (
|
|
2599
|
REV integer not null,
|
|
2600
|
Media_id integer not null,
|
|
2601
|
title_id integer not null,
|
|
2602
|
title_mapkey_id integer not null,
|
|
2603
|
revtype tinyint,
|
|
2604
|
primary key (REV, Media_id, title_id, title_mapkey_id)
|
|
2605
|
);
|
|
2606
|
|
|
2607
|
create table Media_Marker (
|
|
2608
|
Media_id integer not null,
|
|
2609
|
markers_id integer not null,
|
|
2610
|
primary key (Media_id, markers_id),
|
|
2611
|
unique (markers_id)
|
|
2612
|
);
|
|
2613
|
|
|
2614
|
create table Media_Marker_AUD (
|
|
2615
|
REV integer not null,
|
|
2616
|
Media_id integer not null,
|
|
2617
|
markers_id integer not null,
|
|
2618
|
revtype tinyint,
|
|
2619
|
primary key (REV, Media_id, markers_id)
|
|
2620
|
);
|
|
2621
|
|
|
2622
|
create table Media_OriginalSourceBase (
|
|
2623
|
Media_id integer not null,
|
|
2624
|
sources_id integer not null,
|
|
2625
|
primary key (Media_id, sources_id),
|
|
2626
|
unique (sources_id)
|
|
2627
|
);
|
|
2628
|
|
|
2629
|
create table Media_OriginalSourceBase_AUD (
|
|
2630
|
REV integer not null,
|
|
2631
|
Media_id integer not null,
|
|
2632
|
sources_id integer not null,
|
|
2633
|
revtype tinyint,
|
|
2634
|
primary key (REV, Media_id, sources_id)
|
|
2635
|
);
|
|
2636
|
|
|
2637
|
create table Media_Representation (
|
|
2638
|
Media_id integer not null,
|
|
2639
|
keyrepresentations_id integer not null,
|
|
2640
|
primary key (Media_id, keyrepresentations_id)
|
|
2641
|
);
|
|
2642
|
|
|
2643
|
create table Media_Representation_AUD (
|
|
2644
|
REV integer not null,
|
|
2645
|
Media_id integer not null,
|
|
2646
|
keyrepresentations_id integer not null,
|
|
2647
|
revtype tinyint,
|
|
2648
|
primary key (REV, Media_id, keyrepresentations_id)
|
|
2649
|
);
|
|
2650
|
|
|
2651
|
create table Media_Rights (
|
|
2652
|
Media_id integer not null,
|
|
2653
|
rights_id integer not null,
|
|
2654
|
primary key (Media_id, rights_id),
|
|
2655
|
unique (rights_id)
|
|
2656
|
);
|
|
2657
|
|
|
2658
|
create table Media_Rights_AUD (
|
|
2659
|
REV integer not null,
|
|
2660
|
Media_id integer not null,
|
|
2661
|
rights_id integer not null,
|
|
2662
|
revtype tinyint,
|
|
2663
|
primary key (REV, Media_id, rights_id)
|
|
2664
|
);
|
|
2665
|
|
|
2666
|
create table Media_Sequence (
|
|
2667
|
Media_id integer not null,
|
|
2668
|
usedsequences_id integer not null,
|
|
2669
|
primary key (Media_id, usedsequences_id),
|
|
2670
|
unique (usedsequences_id)
|
|
2671
|
);
|
|
2672
|
|
|
2673
|
create table Media_Sequence_AUD (
|
|
2674
|
REV integer not null,
|
|
2675
|
Media_id integer not null,
|
|
2676
|
usedsequences_id integer not null,
|
|
2677
|
revtype tinyint,
|
|
2678
|
primary key (REV, Media_id, usedsequences_id)
|
|
2679
|
);
|
|
2680
|
|
|
2681
|
create table Media_TaxonBase (
|
|
2682
|
Media_id integer not null,
|
|
2683
|
coveredtaxa_id integer not null,
|
|
2684
|
primary key (Media_id, coveredtaxa_id)
|
|
2685
|
);
|
|
2686
|
|
|
2687
|
create table Media_TaxonBase_AUD (
|
|
2688
|
REV integer not null,
|
|
2689
|
Media_id integer not null,
|
|
2690
|
coveredtaxa_id integer not null,
|
|
2691
|
revtype tinyint,
|
|
2692
|
primary key (REV, Media_id, coveredtaxa_id)
|
|
2693
|
);
|
|
2694
|
|
|
2695
|
create table MultiAccessKey_NamedArea (
|
|
2696
|
WorkingSet_id integer not null,
|
|
2697
|
geographicalscope_id integer not null,
|
|
2698
|
primary key (WorkingSet_id, geographicalscope_id)
|
|
2699
|
);
|
|
2700
|
|
|
2701
|
create table MultiAccessKey_NamedArea_AUD (
|
|
2702
|
REV integer not null,
|
|
2703
|
WorkingSet_id integer not null,
|
|
2704
|
geographicalscope_id integer not null,
|
|
2705
|
revtype tinyint,
|
|
2706
|
primary key (REV, WorkingSet_id, geographicalscope_id)
|
|
2707
|
);
|
|
2708
|
|
|
2709
|
create table MultiAccessKey_Scope (
|
|
2710
|
WorkingSet_id integer not null,
|
|
2711
|
scoperestrictions_id integer not null,
|
|
2712
|
primary key (WorkingSet_id, scoperestrictions_id)
|
|
2713
|
);
|
|
2714
|
|
|
2715
|
create table MultiAccessKey_Scope_AUD (
|
|
2716
|
REV integer not null,
|
|
2717
|
WorkingSet_id integer not null,
|
|
2718
|
scoperestrictions_id integer not null,
|
|
2719
|
revtype tinyint,
|
|
2720
|
primary key (REV, WorkingSet_id, scoperestrictions_id)
|
|
2721
|
);
|
|
2722
|
|
|
2723
|
create table MultiAccessKey_Taxon (
|
|
2724
|
multiAccessKey_id integer not null,
|
|
2725
|
taxon_id integer not null,
|
|
2726
|
primary key (multiAccessKey_id, taxon_id)
|
|
2727
|
);
|
|
2728
|
|
|
2729
|
create table MultiAccessKey_Taxon_AUD (
|
|
2730
|
REV integer not null,
|
|
2731
|
multiAccessKey_id integer not null,
|
|
2732
|
taxon_id integer not null,
|
|
2733
|
revtype tinyint,
|
|
2734
|
primary key (REV, multiAccessKey_id, taxon_id)
|
|
2735
|
);
|
|
2736
|
|
|
2737
|
create table NameRelationship (
|
|
2738
|
id integer not null,
|
|
2739
|
created timestamp,
|
|
2740
|
uuid varchar(36),
|
|
2741
|
updated timestamp,
|
|
2742
|
citationmicroreference varchar(255),
|
|
2743
|
originalnamestring varchar(255),
|
|
2744
|
doubtful bit not null,
|
|
2745
|
ruleconsidered varchar(255),
|
|
2746
|
createdby_id integer,
|
|
2747
|
updatedby_id integer,
|
|
2748
|
citation_id integer,
|
|
2749
|
relatedfrom_id integer,
|
|
2750
|
relatedto_id integer,
|
|
2751
|
type_id integer,
|
|
2752
|
primary key (id),
|
|
2753
|
unique (uuid)
|
|
2754
|
);
|
|
2755
|
|
|
2756
|
create table NameRelationship_AUD (
|
|
2757
|
id integer not null,
|
|
2758
|
REV integer not null,
|
|
2759
|
revtype tinyint,
|
|
2760
|
created timestamp,
|
|
2761
|
uuid varchar(36),
|
|
2762
|
updated timestamp,
|
|
2763
|
citationmicroreference varchar(255),
|
|
2764
|
originalnamestring varchar(255),
|
|
2765
|
doubtful bit,
|
|
2766
|
ruleconsidered varchar(255),
|
|
2767
|
createdby_id integer,
|
|
2768
|
updatedby_id integer,
|
|
2769
|
citation_id integer,
|
|
2770
|
relatedfrom_id integer,
|
|
2771
|
relatedto_id integer,
|
|
2772
|
type_id integer,
|
|
2773
|
primary key (id, REV)
|
|
2774
|
);
|
|
2775
|
|
|
2776
|
create table NameRelationship_Annotation (
|
|
2777
|
NameRelationship_id integer not null,
|
|
2778
|
annotations_id integer not null,
|
|
2779
|
primary key (NameRelationship_id, annotations_id),
|
|
2780
|
unique (annotations_id)
|
|
2781
|
);
|
|
2782
|
|
|
2783
|
create table NameRelationship_Annotation_AUD (
|
|
2784
|
REV integer not null,
|
|
2785
|
NameRelationship_id integer not null,
|
|
2786
|
annotations_id integer not null,
|
|
2787
|
revtype tinyint,
|
|
2788
|
primary key (REV, NameRelationship_id, annotations_id)
|
|
2789
|
);
|
|
2790
|
|
|
2791
|
create table NameRelationship_Marker (
|
|
2792
|
NameRelationship_id integer not null,
|
|
2793
|
markers_id integer not null,
|
|
2794
|
primary key (NameRelationship_id, markers_id),
|
|
2795
|
unique (markers_id)
|
|
2796
|
);
|
|
2797
|
|
|
2798
|
create table NameRelationship_Marker_AUD (
|
|
2799
|
REV integer not null,
|
|
2800
|
NameRelationship_id integer not null,
|
|
2801
|
markers_id integer not null,
|
|
2802
|
revtype tinyint,
|
|
2803
|
primary key (REV, NameRelationship_id, markers_id)
|
|
2804
|
);
|
|
2805
|
|
|
2806
|
create table NomenclaturalStatus (
|
|
2807
|
id integer not null,
|
|
2808
|
created timestamp,
|
|
2809
|
uuid varchar(36),
|
|
2810
|
updated timestamp,
|
|
2811
|
citationmicroreference varchar(255),
|
|
2812
|
originalnamestring varchar(255),
|
|
2813
|
ruleconsidered varchar(255),
|
|
2814
|
createdby_id integer,
|
|
2815
|
updatedby_id integer,
|
|
2816
|
citation_id integer,
|
|
2817
|
type_id integer,
|
|
2818
|
primary key (id),
|
|
2819
|
unique (uuid)
|
|
2820
|
);
|
|
2821
|
|
|
2822
|
create table NomenclaturalStatus_AUD (
|
|
2823
|
id integer not null,
|
|
2824
|
REV integer not null,
|
|
2825
|
revtype tinyint,
|
|
2826
|
created timestamp,
|
|
2827
|
uuid varchar(36),
|
|
2828
|
updated timestamp,
|
|
2829
|
citationmicroreference varchar(255),
|
|
2830
|
originalnamestring varchar(255),
|
|
2831
|
ruleconsidered varchar(255),
|
|
2832
|
createdby_id integer,
|
|
2833
|
updatedby_id integer,
|
|
2834
|
citation_id integer,
|
|
2835
|
type_id integer,
|
|
2836
|
primary key (id, REV)
|
|
2837
|
);
|
|
2838
|
|
|
2839
|
create table NomenclaturalStatus_Annotation (
|
|
2840
|
NomenclaturalStatus_id integer not null,
|
|
2841
|
annotations_id integer not null,
|
|
2842
|
primary key (NomenclaturalStatus_id, annotations_id),
|
|
2843
|
unique (annotations_id)
|
|
2844
|
);
|
|
2845
|
|
|
2846
|
create table NomenclaturalStatus_Annotation_AUD (
|
|
2847
|
REV integer not null,
|
|
2848
|
NomenclaturalStatus_id integer not null,
|
|
2849
|
annotations_id integer not null,
|
|
2850
|
revtype tinyint,
|
|
2851
|
primary key (REV, NomenclaturalStatus_id, annotations_id)
|
|
2852
|
);
|
|
2853
|
|
|
2854
|
create table NomenclaturalStatus_Marker (
|
|
2855
|
NomenclaturalStatus_id integer not null,
|
|
2856
|
markers_id integer not null,
|
|
2857
|
primary key (NomenclaturalStatus_id, markers_id),
|
|
2858
|
unique (markers_id)
|
|
2859
|
);
|
|
2860
|
|
|
2861
|
create table NomenclaturalStatus_Marker_AUD (
|
|
2862
|
REV integer not null,
|
|
2863
|
NomenclaturalStatus_id integer not null,
|
|
2864
|
markers_id integer not null,
|
|
2865
|
revtype tinyint,
|
|
2866
|
primary key (REV, NomenclaturalStatus_id, markers_id)
|
|
2867
|
);
|
|
2868
|
|
|
2869
|
create table OriginalSourceBase (
|
|
2870
|
DTYPE varchar(31) not null,
|
|
2871
|
id integer not null,
|
|
2872
|
created timestamp,
|
|
2873
|
uuid varchar(36),
|
|
2874
|
updated timestamp,
|
|
2875
|
citationmicroreference varchar(255),
|
|
2876
|
originalnamestring varchar(255),
|
|
2877
|
idinsource varchar(255),
|
|
2878
|
idnamespace varchar(255),
|
|
2879
|
sourcedObj_type varchar(255),
|
|
2880
|
sourcedObj_id integer not null,
|
|
2881
|
createdby_id integer,
|
|
2882
|
updatedby_id integer,
|
|
2883
|
citation_id integer,
|
|
2884
|
nameusedinsource_id integer,
|
|
2885
|
primary key (id),
|
|
2886
|
unique (uuid)
|
|
2887
|
);
|
|
2888
|
|
|
2889
|
create table OriginalSourceBase_AUD (
|
|
2890
|
DTYPE varchar(31) not null,
|
|
2891
|
id integer not null,
|
|
2892
|
REV integer not null,
|
|
2893
|
revtype tinyint,
|
|
2894
|
created timestamp,
|
|
2895
|
uuid varchar(36),
|
|
2896
|
updated timestamp,
|
|
2897
|
citationmicroreference varchar(255),
|
|
2898
|
originalnamestring varchar(255),
|
|
2899
|
idinsource varchar(255),
|
|
2900
|
idnamespace varchar(255),
|
|
2901
|
createdby_id integer,
|
|
2902
|
updatedby_id integer,
|
|
2903
|
citation_id integer,
|
|
2904
|
nameusedinsource_id integer,
|
|
2905
|
primary key (id, REV)
|
|
2906
|
);
|
|
2907
|
|
|
2908
|
create table OriginalSourceBase_Annotation (
|
|
2909
|
OriginalSourceBase_id integer not null,
|
|
2910
|
annotations_id integer not null,
|
|
2911
|
primary key (OriginalSourceBase_id, annotations_id),
|
|
2912
|
unique (annotations_id)
|
|
2913
|
);
|
|
2914
|
|
|
2915
|
create table OriginalSourceBase_Annotation_AUD (
|
|
2916
|
REV integer not null,
|
|
2917
|
OriginalSourceBase_id integer not null,
|
|
2918
|
annotations_id integer not null,
|
|
2919
|
revtype tinyint,
|
|
2920
|
primary key (REV, OriginalSourceBase_id, annotations_id)
|
|
2921
|
);
|
|
2922
|
|
|
2923
|
create table OriginalSourceBase_Marker (
|
|
2924
|
OriginalSourceBase_id integer not null,
|
|
2925
|
markers_id integer not null,
|
|
2926
|
primary key (OriginalSourceBase_id, markers_id),
|
|
2927
|
unique (markers_id)
|
|
2928
|
);
|
|
2929
|
|
|
2930
|
create table OriginalSourceBase_Marker_AUD (
|
|
2931
|
REV integer not null,
|
|
2932
|
OriginalSourceBase_id integer not null,
|
|
2933
|
markers_id integer not null,
|
|
2934
|
revtype tinyint,
|
|
2935
|
primary key (REV, OriginalSourceBase_id, markers_id)
|
|
2936
|
);
|
|
2937
|
|
|
2938
|
create table PermissionGroup (
|
|
2939
|
id integer not null,
|
|
2940
|
created timestamp,
|
|
2941
|
uuid varchar(36),
|
|
2942
|
name varchar(255),
|
|
2943
|
createdby_id integer,
|
|
2944
|
primary key (id),
|
|
2945
|
unique (uuid, name)
|
|
2946
|
);
|
|
2947
|
|
|
2948
|
create table PermissionGroup_GrantedAuthorityImpl (
|
|
2949
|
PermissionGroup_id integer not null,
|
|
2950
|
grantedauthorities_id integer not null,
|
|
2951
|
primary key (PermissionGroup_id, grantedauthorities_id)
|
|
2952
|
);
|
|
2953
|
|
|
2954
|
create table PolytomousKey (
|
|
2955
|
id integer not null,
|
|
2956
|
created timestamp,
|
|
2957
|
uuid varchar(36),
|
|
2958
|
updated timestamp,
|
|
2959
|
lsid_authority varchar(255),
|
|
2960
|
lsid_lsid varchar(255),
|
|
2961
|
lsid_namespace varchar(255),
|
|
2962
|
lsid_object varchar(255),
|
|
2963
|
lsid_revision varchar(255),
|
|
2964
|
protectedtitlecache bit not null,
|
|
2965
|
titleCache varchar(255),
|
|
2966
|
uri varchar(255),
|
|
2967
|
createdby_id integer,
|
|
2968
|
updatedby_id integer,
|
|
2969
|
root_id integer,
|
|
2970
|
primary key (id),
|
|
2971
|
unique (uuid)
|
|
2972
|
);
|
|
2973
|
|
|
2974
|
create table PolytomousKey_AUD (
|
|
2975
|
id integer not null,
|
|
2976
|
REV integer not null,
|
|
2977
|
revtype tinyint,
|
|
2978
|
created timestamp,
|
|
2979
|
uuid varchar(36),
|
|
2980
|
updated timestamp,
|
|
2981
|
lsid_authority varchar(255),
|
|
2982
|
lsid_lsid varchar(255),
|
|
2983
|
lsid_namespace varchar(255),
|
|
2984
|
lsid_object varchar(255),
|
|
2985
|
lsid_revision varchar(255),
|
|
2986
|
protectedtitlecache bit not null,
|
|
2987
|
titleCache varchar(255),
|
|
2988
|
uri varchar(255),
|
|
2989
|
createdby_id integer,
|
|
2990
|
updatedby_id integer,
|
|
2991
|
root_id integer,
|
|
2992
|
primary key (id, REV)
|
|
2993
|
);
|
|
2994
|
|
|
2995
|
create table PolytomousKey_Annotation (
|
|
2996
|
PolytomousKey_id integer not null,
|
|
2997
|
annotations_id integer not null,
|
|
2998
|
primary key (PolytomousKey_id, annotations_id),
|
|
2999
|
unique (annotations_id)
|
|
3000
|
);
|
|
3001
|
|
|
3002
|
create table PolytomousKey_Annotation_AUD (
|
|
3003
|
REV integer not null,
|
|
3004
|
PolytomousKey_id integer not null,
|
|
3005
|
annotations_id integer not null,
|
|
3006
|
revtype tinyint,
|
|
3007
|
primary key (REV, PolytomousKey_id, annotations_id)
|
|
3008
|
);
|
|
3009
|
|
|
3010
|
create table PolytomousKey_Credit (
|
|
3011
|
PolytomousKey_id integer not null,
|
|
3012
|
credits_id integer not null,
|
|
3013
|
sortIndex integer not null,
|
|
3014
|
primary key (PolytomousKey_id, sortIndex),
|
|
3015
|
unique (credits_id)
|
|
3016
|
);
|
|
3017
|
|
|
3018
|
create table PolytomousKey_Credit_AUD (
|
|
3019
|
REV integer not null,
|
|
3020
|
PolytomousKey_id integer not null,
|
|
3021
|
credits_id integer not null,
|
|
3022
|
sortIndex integer not null,
|
|
3023
|
revtype tinyint,
|
|
3024
|
primary key (REV, PolytomousKey_id, credits_id, sortIndex)
|
|
3025
|
);
|
|
3026
|
|
|
3027
|
create table PolytomousKey_Extension (
|
|
3028
|
PolytomousKey_id integer not null,
|
|
3029
|
extensions_id integer not null,
|
|
3030
|
primary key (PolytomousKey_id, extensions_id),
|
|
3031
|
unique (extensions_id)
|
|
3032
|
);
|
|
3033
|
|
|
3034
|
create table PolytomousKey_Extension_AUD (
|
|
3035
|
REV integer not null,
|
|
3036
|
PolytomousKey_id integer not null,
|
|
3037
|
extensions_id integer not null,
|
|
3038
|
revtype tinyint,
|
|
3039
|
primary key (REV, PolytomousKey_id, extensions_id)
|
|
3040
|
);
|
|
3041
|
|
|
3042
|
create table PolytomousKey_Marker (
|
|
3043
|
PolytomousKey_id integer not null,
|
|
3044
|
markers_id integer not null,
|
|
3045
|
primary key (PolytomousKey_id, markers_id),
|
|
3046
|
unique (markers_id)
|
|
3047
|
);
|
|
3048
|
|
|
3049
|
create table PolytomousKey_Marker_AUD (
|
|
3050
|
REV integer not null,
|
|
3051
|
PolytomousKey_id integer not null,
|
|
3052
|
markers_id integer not null,
|
|
3053
|
revtype tinyint,
|
|
3054
|
primary key (REV, PolytomousKey_id, markers_id)
|
|
3055
|
);
|
|
3056
|
|
|
3057
|
create table PolytomousKey_NamedArea (
|
|
3058
|
PolytomousKey_id integer not null,
|
|
3059
|
geographicalscope_id integer not null,
|
|
3060
|
primary key (PolytomousKey_id, geographicalscope_id)
|
|
3061
|
);
|
|
3062
|
|
|
3063
|
create table PolytomousKey_NamedArea_AUD (
|
|
3064
|
REV integer not null,
|
|
3065
|
PolytomousKey_id integer not null,
|
|
3066
|
geographicalscope_id integer not null,
|
|
3067
|
revtype tinyint,
|
|
3068
|
primary key (REV, PolytomousKey_id, geographicalscope_id)
|
|
3069
|
);
|
|
3070
|
|
|
3071
|
create table PolytomousKey_OriginalSourceBase (
|
|
3072
|
PolytomousKey_id integer not null,
|
|
3073
|
sources_id integer not null,
|
|
3074
|
primary key (PolytomousKey_id, sources_id),
|
|
3075
|
unique (sources_id)
|
|
3076
|
);
|
|
3077
|
|
|
3078
|
create table PolytomousKey_OriginalSourceBase_AUD (
|
|
3079
|
REV integer not null,
|
|
3080
|
PolytomousKey_id integer not null,
|
|
3081
|
sources_id integer not null,
|
|
3082
|
revtype tinyint,
|
|
3083
|
primary key (REV, PolytomousKey_id, sources_id)
|
|
3084
|
);
|
|
3085
|
|
|
3086
|
|
|
3087
|
create table PolytomousKey_Rights (
|
|
3088
|
PolytomousKey_id integer not null,
|
|
3089
|
rights_id integer not null,
|
|
3090
|
primary key (PolytomousKey_id, rights_id),
|
|
3091
|
unique (rights_id)
|
|
3092
|
);
|
|
3093
|
|
|
3094
|
create table PolytomousKey_Rights_AUD (
|
|
3095
|
REV integer not null,
|
|
3096
|
PolytomousKey_id integer not null,
|
|
3097
|
rights_id integer not null,
|
|
3098
|
revtype tinyint,
|
|
3099
|
primary key (REV, PolytomousKey_id, rights_id)
|
|
3100
|
);
|
|
3101
|
|
|
3102
|
create table PolytomousKey_Scope (
|
|
3103
|
PolytomousKey_id integer not null,
|
|
3104
|
scoperestrictions_id integer not null,
|
|
3105
|
primary key (PolytomousKey_id, scoperestrictions_id)
|
|
3106
|
);
|
|
3107
|
|
|
3108
|
create table PolytomousKey_Scope_AUD (
|
|
3109
|
REV integer not null,
|
|
3110
|
PolytomousKey_id integer not null,
|
|
3111
|
scoperestrictions_id integer not null,
|
|
3112
|
revtype tinyint,
|
|
3113
|
primary key (REV, PolytomousKey_id, scoperestrictions_id)
|
|
3114
|
);
|
|
3115
|
|
|
3116
|
create table PolytomousKey_Taxon (
|
|
3117
|
polytomousKey_id integer not null,
|
|
3118
|
taxon_id integer not null,
|
|
3119
|
primary key (polytomousKey_id, taxon_id)
|
|
3120
|
);
|
|
3121
|
|
|
3122
|
create table PolytomousKey_Taxon_AUD (
|
|
3123
|
REV integer not null,
|
|
3124
|
polytomousKey_id integer not null,
|
|
3125
|
taxon_id integer not null,
|
|
3126
|
revtype tinyint,
|
|
3127
|
primary key (REV, polytomousKey_id, taxon_id)
|
|
3128
|
);
|
|
3129
|
|
|
3130
|
create table PolytomousKey_TaxonBase (
|
|
3131
|
polytomousKey_id integer not null,
|
|
3132
|
coveredtaxa_id integer not null,
|
|
3133
|
primary key (polytomousKey_id, coveredtaxa_id)
|
|
3134
|
);
|
|
3135
|
|
|
3136
|
create table PolytomousKey_TaxonBase_AUD (
|
|
3137
|
REV integer not null,
|
|
3138
|
polytomousKey_id integer not null,
|
|
3139
|
coveredtaxa_id integer not null,
|
|
3140
|
revtype tinyint,
|
|
3141
|
primary key (REV, polytomousKey_id, coveredtaxa_id)
|
|
3142
|
);
|
|
3143
|
|
|
3144
|
|
|
3145
|
create table PolytomousKeyNode (
|
|
3146
|
id integer not null,
|
|
3147
|
created timestamp,
|
|
3148
|
uuid varchar(36),
|
|
3149
|
updated timestamp,
|
|
3150
|
nodenumber integer,
|
|
3151
|
sortindex integer,
|
|
3152
|
createdby_id integer,
|
|
3153
|
updatedby_id integer,
|
|
3154
|
key_id integer,
|
|
3155
|
parent_id integer,
|
|
3156
|
question_id integer,
|
|
3157
|
statement_id integer,
|
|
3158
|
feature_id integer,
|
|
3159
|
taxon_id integer,
|
|
3160
|
subkey_id integer,
|
|
3161
|
othernode_id integer,
|
|
3162
|
primary key (id),
|
|
3163
|
unique (uuid)
|
|
3164
|
);
|
|
3165
|
|
|
3166
|
create table PolytomousKeyNode_AUD (
|
|
3167
|
id integer not null,
|
|
3168
|
REV integer not null,
|
|
3169
|
revtype tinyint,
|
|
3170
|
created timestamp,
|
|
3171
|
uuid varchar(36),
|
|
3172
|
updated timestamp,
|
|
3173
|
nodenumber integer,
|
|
3174
|
sortindex integer,
|
|
3175
|
createdby_id integer,
|
|
3176
|
updatedby_id integer,
|
|
3177
|
key_id integer,
|
|
3178
|
parent_id integer,
|
|
3179
|
question_id integer,
|
|
3180
|
statement_id integer,
|
|
3181
|
feature_id integer,
|
|
3182
|
taxon_id integer,
|
|
3183
|
subkey_id integer,
|
|
3184
|
othernode_id integer,
|
|
3185
|
primary key (id, REV)
|
|
3186
|
);
|
|
3187
|
|
|
3188
|
create table PolytomousKeyNode_LanguageString (
|
|
3189
|
PolytomousKeyNode_id integer not null,
|
|
3190
|
modifyingtext_id integer not null,
|
|
3191
|
modifyingtext_mapkey_id integer not null,
|
|
3192
|
primary key (PolytomousKeyNode_id, modifyingtext_mapkey_id),
|
|
3193
|
unique (modifyingtext_id)
|
|
3194
|
)
|
|
3195
|
|
|
3196
|
create table PolytomousKeyNode_LanguageString_AUD (
|
|
3197
|
REV integer not null,
|
|
3198
|
revtype tinyint,
|
|
3199
|
PolytomousKeyNode_id integer not null,
|
|
3200
|
modifyingtext_id integer not null,
|
|
3201
|
modifyingtext_mapkey_id integer not null,
|
|
3202
|
primary key (REV, PolytomousKeyNode_id, modifyingtext_id, modifyingtext_mapkey_id)
|
|
3203
|
)
|
|
3204
|
|
|
3205
|
create table PolytomousKeyNode_PolytomousKeyNode_AUD(
|
|
3206
|
id integer not null,
|
|
3207
|
REV integer not null,
|
|
3208
|
revtype tinyint,
|
|
3209
|
parent_id integer,
|
|
3210
|
sortIndex integer
|
|
3211
|
)
|
|
3212
|
|
|
3213
|
create table Reference (
|
|
3214
|
DTYPE varchar(31) not null,
|
|
3215
|
id integer not null,
|
|
3216
|
created timestamp,
|
|
3217
|
uuid varchar(36),
|
|
3218
|
updated timestamp,
|
|
3219
|
lsid_authority varchar(255),
|
|
3220
|
lsid_lsid varchar(255),
|
|
3221
|
lsid_namespace varchar(255),
|
|
3222
|
lsid_object varchar(255),
|
|
3223
|
lsid_revision varchar(255),
|
|
3224
|
protectedtitlecache bit not null,
|
|
3225
|
titleCache varchar(255),
|
|
3226
|
datepublished_end varchar(255),
|
|
3227
|
datepublished_freetext varchar(255),
|
|
3228
|
datepublished_start varchar(255),
|
|
3229
|
edition varchar(255),
|
|
3230
|
editor varchar(255),
|
|
3231
|
isbn varchar(255),
|
|
3232
|
issn varchar(255),
|
|
3233
|
nomenclaturallyrelevant bit not null,
|
|
3234
|
organization varchar(255),
|
|
3235
|
pages varchar(255),
|
|
3236
|
parsingproblem integer not null,
|
|
3237
|
placepublished varchar(255),
|
|
3238
|
problemends integer not null,
|
|
3239
|
problemstarts integer not null,
|
|
3240
|
publisher varchar(255),
|
|
3241
|
referenceAbstract longvarchar,
|
|
3242
|
series varchar(255),
|
|
3243
|
seriespart varchar(255),
|
|
3244
|
title longvarchar,
|
|
3245
|
refType integer,
|
|
3246
|
uri varchar(255),
|
|
3247
|
volume varchar(255),
|
|
3248
|
createdby_id integer,
|
|
3249
|
updatedby_id integer,
|
|
3250
|
authorteam_id integer,
|
|
3251
|
inreference_id integer,
|
|
3252
|
institution_id integer,
|
|
3253
|
school_id integer,
|
|
3254
|
abbreviatedReference_id integer,
|
|
3255
|
fullReference_id integer,
|
|
3256
|
primary key (id),
|
|
3257
|
unique (uuid)
|
|
3258
|
);
|
|
3259
|
|
|
3260
|
create table Reference_AUD (
|
|
3261
|
DTYPE varchar(31) not null,
|
|
3262
|
id integer not null,
|
|
3263
|
REV integer not null,
|
|
3264
|
revtype tinyint,
|
|
3265
|
created timestamp,
|
|
3266
|
uuid varchar(36),
|
|
3267
|
updated timestamp,
|
|
3268
|
lsid_authority varchar(255),
|
|
3269
|
lsid_lsid varchar(255),
|
|
3270
|
lsid_namespace varchar(255),
|
|
3271
|
lsid_object varchar(255),
|
|
3272
|
lsid_revision varchar(255),
|
|
3273
|
protectedtitlecache bit,
|
|
3274
|
titleCache varchar(255),
|
|
3275
|
datepublished_end varchar(255),
|
|
3276
|
datepublished_freetext varchar(255),
|
|
3277
|
datepublished_start varchar(255),
|
|
3278
|
edition varchar(255),
|
|
3279
|
editor varchar(255),
|
|
3280
|
isbn varchar(255),
|
|
3281
|
issn varchar(255),
|
|
3282
|
nomenclaturallyrelevant bit,
|
|
3283
|
organization varchar(255),
|
|
3284
|
pages varchar(255),
|
|
3285
|
parsingproblem integer,
|
|
3286
|
placepublished varchar(255),
|
|
3287
|
problemends integer,
|
|
3288
|
problemstarts integer,
|
|
3289
|
publisher varchar(255),
|
|
3290
|
referenceAbstract longvarchar,
|
|
3291
|
series varchar(255),
|
|
3292
|
seriespart varchar(255),
|
|
3293
|
title longvarchar,
|
|
3294
|
refType integer,
|
|
3295
|
uri varchar(255),
|
|
3296
|
volume varchar(255),
|
|
3297
|
createdby_id integer,
|
|
3298
|
updatedby_id integer,
|
|
3299
|
authorteam_id integer,
|
|
3300
|
inreference_id integer,
|
|
3301
|
institution_id integer,
|
|
3302
|
school_id integer,
|
|
3303
|
abbreviatedReference_id integer,
|
|
3304
|
fullReference_id integer,
|
|
3305
|
primary key (id, REV)
|
|
3306
|
);
|
|
3307
|
|
|
3308
|
create table Reference_Annotation (
|
|
3309
|
Reference_id integer not null,
|
|
3310
|
annotations_id integer not null,
|
|
3311
|
primary key (Reference_id, annotations_id),
|
|
3312
|
unique (annotations_id)
|
|
3313
|
);
|
|
3314
|
|
|
3315
|
create table Reference_Annotation_AUD (
|
|
3316
|
REV integer not null,
|
|
3317
|
Reference_id integer not null,
|
|
3318
|
annotations_id integer not null,
|
|
3319
|
revtype tinyint,
|
|
3320
|
primary key (REV, Reference_id, annotations_id)
|
|
3321
|
);
|
|
3322
|
|
|
3323
|
create table Reference_Credit (
|
|
3324
|
Reference_id integer not null,
|
|
3325
|
credits_id integer not null,
|
|
3326
|
sortIndex integer not null,
|
|
3327
|
primary key (Reference_id, sortIndex),
|
|
3328
|
unique (credits_id)
|
|
3329
|
);
|
|
3330
|
|
|
3331
|
create table Reference_Credit_AUD (
|
|
3332
|
REV integer not null,
|
|
3333
|
Reference_id integer not null,
|
|
3334
|
credits_id integer not null,
|
|
3335
|
sortIndex integer not null,
|
|
3336
|
revtype tinyint,
|
|
3337
|
primary key (REV, Reference_id, credits_id, sortIndex)
|
|
3338
|
);
|
|
3339
|
|
|
3340
|
create table Reference_Extension (
|
|
3341
|
Reference_id integer not null,
|
|
3342
|
extensions_id integer not null,
|
|
3343
|
primary key (Reference_id, extensions_id),
|
|
3344
|
unique (extensions_id)
|
|
3345
|
);
|
|
3346
|
|
|
3347
|
create table Reference_Extension_AUD (
|
|
3348
|
REV integer not null,
|
|
3349
|
Reference_id integer not null,
|
|
3350
|
extensions_id integer not null,
|
|
3351
|
revtype tinyint,
|
|
3352
|
primary key (REV, Reference_id, extensions_id)
|
|
3353
|
);
|
|
3354
|
|
|
3355
|
create table Reference_Marker (
|
|
3356
|
Reference_id integer not null,
|
|
3357
|
markers_id integer not null,
|
|
3358
|
primary key (Reference_id, markers_id),
|
|
3359
|
unique (markers_id)
|
|
3360
|
);
|
|
3361
|
|
|
3362
|
create table Reference_Marker_AUD (
|
|
3363
|
REV integer not null,
|
|
3364
|
Reference_id integer not null,
|
|
3365
|
markers_id integer not null,
|
|
3366
|
revtype tinyint,
|
|
3367
|
primary key (REV, Reference_id, markers_id)
|
|
3368
|
);
|
|
3369
|
|
|
3370
|
create table Reference_Media (
|
|
3371
|
Reference_id integer not null,
|
|
3372
|
media_id integer not null,
|
|
3373
|
primary key (Reference_id, media_id)
|
|
3374
|
);
|
|
3375
|
|
|
3376
|
create table Reference_Media_AUD (
|
|
3377
|
REV integer not null,
|
|
3378
|
Reference_id integer not null,
|
|
3379
|
media_id integer not null,
|
|
3380
|
revtype tinyint,
|
|
3381
|
primary key (REV, Reference_id, media_id)
|
|
3382
|
);
|
|
3383
|
|
|
3384
|
create table Reference_OriginalSourceBase (
|
|
3385
|
Reference_id integer not null,
|
|
3386
|
sources_id integer not null,
|
|
3387
|
primary key (Reference_id, sources_id),
|
|
3388
|
unique (sources_id)
|
|
3389
|
);
|
|
3390
|
|
|
3391
|
create table Reference_OriginalSourceBase_AUD (
|
|
3392
|
REV integer not null,
|
|
3393
|
Reference_id integer not null,
|
|
3394
|
sources_id integer not null,
|
|
3395
|
revtype tinyint,
|
|
3396
|
primary key (REV, Reference_id, sources_id)
|
|
3397
|
);
|
|
3398
|
|
|
3399
|
create table Reference_Rights (
|
|
3400
|
Reference_id integer not null,
|
|
3401
|
rights_id integer not null,
|
|
3402
|
primary key (Reference_id, rights_id),
|
|
3403
|
unique (rights_id)
|
|
3404
|
);
|
|
3405
|
|
|
3406
|
create table Reference_Rights_AUD (
|
|
3407
|
REV integer not null,
|
|
3408
|
Reference_id integer not null,
|
|
3409
|
rights_id integer not null,
|
|
3410
|
revtype tinyint,
|
|
3411
|
primary key (REV, Reference_id, rights_id)
|
|
3412
|
);
|
|
3413
|
|
|
3414
|
create table RelationshipTermBase_inverseRepresentation (
|
|
3415
|
DefinedTermBase_id integer not null,
|
|
3416
|
inverserepresentations_id integer not null,
|
|
3417
|
primary key (DefinedTermBase_id, inverserepresentations_id),
|
|
3418
|
unique (inverserepresentations_id)
|
|
3419
|
);
|
|
3420
|
|
|
3421
|
create table RelationshipTermBase_inverseRepresentation_AUD (
|
|
3422
|
REV integer not null,
|
|
3423
|
DefinedTermBase_id integer not null,
|
|
3424
|
inverserepresentations_id integer not null,
|
|
3425
|
revtype tinyint,
|
|
3426
|
primary key (REV, DefinedTermBase_id, inverserepresentations_id)
|
|
3427
|
);
|
|
3428
|
|
|
3429
|
create table Representation (
|
|
3430
|
id integer not null,
|
|
3431
|
created timestamp,
|
|
3432
|
uuid varchar(36),
|
|
3433
|
updated timestamp,
|
|
3434
|
text longvarchar,
|
|
3435
|
abbreviatedlabel varchar(255),
|
|
3436
|
label varchar(255),
|
|
3437
|
createdby_id integer,
|
|
3438
|
updatedby_id integer,
|
|
3439
|
language_id integer,
|
|
3440
|
primary key (id),
|
|
3441
|
unique (uuid)
|
|
3442
|
);
|
|
3443
|
|
|
3444
|
create table Representation_AUD (
|
|
3445
|
id integer not null,
|
|
3446
|
REV integer not null,
|
|
3447
|
revtype tinyint,
|
|
3448
|
created timestamp,
|
|
3449
|
uuid varchar(36),
|
|
3450
|
updated timestamp,
|
|
3451
|
text longvarchar,
|
|
3452
|
abbreviatedlabel varchar(255),
|
|
3453
|
label varchar(255),
|
|
3454
|
createdby_id integer,
|
|
3455
|
updatedby_id integer,
|
|
3456
|
language_id integer,
|
|
3457
|
primary key (id, REV)
|
|
3458
|
);
|
|
3459
|
|
|
3460
|
create table Representation_Annotation (
|
|
3461
|
Representation_id integer not null,
|
|
3462
|
annotations_id integer not null,
|
|
3463
|
primary key (Representation_id, annotations_id),
|
|
3464
|
unique (annotations_id)
|
|
3465
|
);
|
|
3466
|
|
|
3467
|
create table Representation_Annotation_AUD (
|
|
3468
|
REV integer not null,
|
|
3469
|
Representation_id integer not null,
|
|
3470
|
annotations_id integer not null,
|
|
3471
|
revtype tinyint,
|
|
3472
|
primary key (REV, Representation_id, annotations_id)
|
|
3473
|
);
|
|
3474
|
|
|
3475
|
create table Representation_Marker (
|
|
3476
|
Representation_id integer not null,
|
|
3477
|
markers_id integer not null,
|
|
3478
|
primary key (Representation_id, markers_id),
|
|
3479
|
unique (markers_id)
|
|
3480
|
);
|
|
3481
|
|
|
3482
|
create table Representation_Marker_AUD (
|
|
3483
|
REV integer not null,
|
|
3484
|
Representation_id integer not null,
|
|
3485
|
markers_id integer not null,
|
|
3486
|
revtype tinyint,
|
|
3487
|
primary key (REV, Representation_id, markers_id)
|
|
3488
|
);
|
|
3489
|
|
|
3490
|
create table Rights (
|
|
3491
|
id integer not null,
|
|
3492
|
created timestamp,
|
|
3493
|
uuid varchar(36),
|
|
3494
|
updated timestamp,
|
|
3495
|
text longvarchar,
|
|
3496
|
abbreviatedtext varchar(255),
|
|
3497
|
uri varchar(255),
|
|
3498
|
createdby_id integer,
|
|
3499
|
updatedby_id integer,
|
|
3500
|
language_id integer,
|
|
3501
|
agent_id integer,
|
|
3502
|
type_id integer,
|
|
3503
|
primary key (id),
|
|
3504
|
unique (uuid)
|
|
3505
|
);
|
|
3506
|
|
|
3507
|
create table Rights_AUD (
|
|
3508
|
id integer not null,
|
|
3509
|
REV integer not null,
|
|
3510
|
revtype tinyint,
|
|
3511
|
created timestamp,
|
|
3512
|
uuid varchar(36),
|
|
3513
|
updated timestamp,
|
|
3514
|
text longvarchar,
|
|
3515
|
abbreviatedtext varchar(255),
|
|
3516
|
uri varchar(255),
|
|
3517
|
createdby_id integer,
|
|
3518
|
updatedby_id integer,
|
|
3519
|
language_id integer,
|
|
3520
|
agent_id integer,
|
|
3521
|
type_id integer,
|
|
3522
|
primary key (id, REV)
|
|
3523
|
);
|
|
3524
|
|
|
3525
|
create table Rights_Annotation (
|
|
3526
|
Rights_id integer not null,
|
|
3527
|
annotations_id integer not null,
|
|
3528
|
primary key (Rights_id, annotations_id),
|
|
3529
|
unique (annotations_id)
|
|
3530
|
);
|
|
3531
|
|
|
3532
|
create table Rights_Annotation_AUD (
|
|
3533
|
REV integer not null,
|
|
3534
|
Rights_id integer not null,
|
|
3535
|
annotations_id integer not null,
|
|
3536
|
revtype tinyint,
|
|
3537
|
primary key (REV, Rights_id, annotations_id)
|
|
3538
|
);
|
|
3539
|
|
|
3540
|
create table Rights_Marker (
|
|
3541
|
Rights_id integer not null,
|
|
3542
|
markers_id integer not null,
|
|
3543
|
primary key (Rights_id, markers_id),
|
|
3544
|
unique (markers_id)
|
|
3545
|
);
|
|
3546
|
|
|
3547
|
create table Rights_Marker_AUD (
|
|
3548
|
REV integer not null,
|
|
3549
|
Rights_id integer not null,
|
|
3550
|
markers_id integer not null,
|
|
3551
|
revtype tinyint,
|
|
3552
|
primary key (REV, Rights_id, markers_id)
|
|
3553
|
);
|
|
3554
|
|
|
3555
|
create table Sequence (
|
|
3556
|
id integer not null,
|
|
3557
|
created timestamp,
|
|
3558
|
uuid varchar(36),
|
|
3559
|
updated timestamp,
|
|
3560
|
lsid_authority varchar(255),
|
|
3561
|
lsid_lsid varchar(255),
|
|
3562
|
lsid_namespace varchar(255),
|
|
3563
|
lsid_object varchar(255),
|
|
3564
|
lsid_revision varchar(255),
|
|
3565
|
protectedtitlecache bit not null,
|
|
3566
|
titleCache varchar(255),
|
|
3567
|
barcode bit not null,
|
|
3568
|
citationmicroreference varchar(255),
|
|
3569
|
datesequenced timestamp,
|
|
3570
|
length integer,
|
|
3571
|
sequence varchar(255),
|
|
3572
|
createdby_id integer,
|
|
3573
|
updatedby_id integer,
|
|
3574
|
locus_id integer,
|
|
3575
|
publishedin_id integer,
|
|
3576
|
primary key (id),
|
|
3577
|
unique (uuid)
|
|
3578
|
);
|
|
3579
|
|
|
3580
|
create table Sequence_AUD (
|
|
3581
|
id integer not null,
|
|
3582
|
REV integer not null,
|
|
3583
|
revtype tinyint,
|
|
3584
|
created timestamp,
|
|
3585
|
uuid varchar(36),
|
|
3586
|
updated timestamp,
|
|
3587
|
lsid_authority varchar(255),
|
|
3588
|
lsid_lsid varchar(255),
|
|
3589
|
lsid_namespace varchar(255),
|
|
3590
|
lsid_object varchar(255),
|
|
3591
|
lsid_revision varchar(255),
|
|
3592
|
protectedtitlecache bit,
|
|
3593
|
titleCache varchar(255),
|
|
3594
|
barcode bit,
|
|
3595
|
citationmicroreference varchar(255),
|
|
3596
|
datesequenced timestamp,
|
|
3597
|
length integer,
|
|
3598
|
sequence varchar(255),
|
|
3599
|
createdby_id integer,
|
|
3600
|
updatedby_id integer,
|
|
3601
|
locus_id integer,
|
|
3602
|
publishedin_id integer,
|
|
3603
|
primary key (id, REV)
|
|
3604
|
);
|
|
3605
|
|
|
3606
|
create table Sequence_Annotation (
|
|
3607
|
Sequence_id integer not null,
|
|
3608
|
annotations_id integer not null,
|
|
3609
|
primary key (Sequence_id, annotations_id),
|
|
3610
|
unique (annotations_id)
|
|
3611
|
);
|
|
3612
|
|
|
3613
|
create table Sequence_Annotation_AUD (
|
|
3614
|
REV integer not null,
|
|
3615
|
Sequence_id integer not null,
|
|
3616
|
annotations_id integer not null,
|
|
3617
|
revtype tinyint,
|
|
3618
|
primary key (REV, Sequence_id, annotations_id)
|
|
3619
|
);
|
|
3620
|
|
|
3621
|
create table Sequence_Credit (
|
|
3622
|
Sequence_id integer not null,
|
|
3623
|
credits_id integer not null,
|
|
3624
|
sortIndex integer not null,
|
|
3625
|
primary key (Sequence_id, sortIndex),
|
|
3626
|
unique (credits_id)
|
|
3627
|
);
|
|
3628
|
|
|
3629
|
create table Sequence_Credit_AUD (
|
|
3630
|
REV integer not null,
|
|
3631
|
Sequence_id integer not null,
|
|
3632
|
credits_id integer not null,
|
|
3633
|
sortIndex integer not null,
|
|
3634
|
revtype tinyint,
|
|
3635
|
primary key (REV, Sequence_id, credits_id, sortIndex)
|
|
3636
|
);
|
|
3637
|
|
|
3638
|
create table Sequence_Extension (
|
|
3639
|
Sequence_id integer not null,
|
|
3640
|
extensions_id integer not null,
|
|
3641
|
primary key (Sequence_id, extensions_id),
|
|
3642
|
unique (extensions_id)
|
|
3643
|
);
|
|
3644
|
|
|
3645
|
create table Sequence_Extension_AUD (
|
|
3646
|
REV integer not null,
|
|
3647
|
Sequence_id integer not null,
|
|
3648
|
extensions_id integer not null,
|
|
3649
|
revtype tinyint,
|
|
3650
|
primary key (REV, Sequence_id, extensions_id)
|
|
3651
|
);
|
|
3652
|
|
|
3653
|
create table Sequence_GenBankAccession (
|
|
3654
|
Sequence_id integer not null,
|
|
3655
|
genbankaccession_id integer not null,
|
|
3656
|
primary key (Sequence_id, genbankaccession_id),
|
|
3657
|
unique (genbankaccession_id)
|
|
3658
|
);
|
|
3659
|
|
|
3660
|
create table Sequence_GenBankAccession_AUD (
|
|
3661
|
REV integer not null,
|
|
3662
|
Sequence_id integer not null,
|
|
3663
|
genbankaccession_id integer not null,
|
|
3664
|
revtype tinyint,
|
|
3665
|
primary key (REV, Sequence_id, genbankaccession_id)
|
|
3666
|
);
|
|
3667
|
|
|
3668
|
create table Sequence_Marker (
|
|
3669
|
Sequence_id integer not null,
|
|
3670
|
markers_id integer not null,
|
|
3671
|
primary key (Sequence_id, markers_id),
|
|
3672
|
unique (markers_id)
|
|
3673
|
);
|
|
3674
|
|
|
3675
|
create table Sequence_Marker_AUD (
|
|
3676
|
REV integer not null,
|
|
3677
|
Sequence_id integer not null,
|
|
3678
|
markers_id integer not null,
|
|
3679
|
revtype tinyint,
|
|
3680
|
primary key (REV, Sequence_id, markers_id)
|
|
3681
|
);
|
|
3682
|
|
|
3683
|
create table Sequence_Media (
|
|
3684
|
Sequence_id integer not null,
|
|
3685
|
chromatograms_id integer not null,
|
|
3686
|
primary key (Sequence_id, chromatograms_id),
|
|
3687
|
unique (chromatograms_id)
|
|
3688
|
);
|
|
3689
|
|
|
3690
|
create table Sequence_Media_AUD (
|
|
3691
|
REV integer not null,
|
|
3692
|
Sequence_id integer not null,
|
|
3693
|
chromatograms_id integer not null,
|
|
3694
|
revtype tinyint,
|
|
3695
|
primary key (REV, Sequence_id, chromatograms_id)
|
|
3696
|
);
|
|
3697
|
|
|
3698
|
create table Sequence_OriginalSourceBase (
|
|
3699
|
Sequence_id integer not null,
|
|
3700
|
sources_id integer not null,
|
|
3701
|
primary key (Sequence_id, sources_id),
|
|
3702
|
unique (sources_id)
|
|
3703
|
);
|
|
3704
|
|
|
3705
|
create table Sequence_OriginalSourceBase_AUD (
|
|
3706
|
REV integer not null,
|
|
3707
|
Sequence_id integer not null,
|
|
3708
|
sources_id integer not null,
|
|
3709
|
revtype tinyint,
|
|
3710
|
primary key (REV, Sequence_id, sources_id)
|
|
3711
|
);
|
|
3712
|
|
|
3713
|
create table Sequence_Reference (
|
|
3714
|
Sequence_id integer not null,
|
|
3715
|
citations_id integer not null,
|
|
3716
|
primary key (Sequence_id, citations_id),
|
|
3717
|
unique (citations_id)
|
|
3718
|
);
|
|
3719
|
|
|
3720
|
create table Sequence_Reference_AUD (
|
|
3721
|
REV integer not null,
|
|
3722
|
Sequence_id integer not null,
|
|
3723
|
citations_id integer not null,
|
|
3724
|
revtype tinyint,
|
|
3725
|
primary key (REV, Sequence_id, citations_id)
|
|
3726
|
);
|
|
3727
|
|
|
3728
|
create table Sequence_Rights (
|
|
3729
|
Sequence_id integer not null,
|
|
3730
|
rights_id integer not null,
|
|
3731
|
primary key (Sequence_id, rights_id),
|
|
3732
|
unique (rights_id)
|
|
3733
|
);
|
|
3734
|
|
|
3735
|
create table Sequence_Rights_AUD (
|
|
3736
|
REV integer not null,
|
|
3737
|
Sequence_id integer not null,
|
|
3738
|
rights_id integer not null,
|
|
3739
|
revtype tinyint,
|
|
3740
|
primary key (REV, Sequence_id, rights_id)
|
|
3741
|
);
|
|
3742
|
|
|
3743
|
create table SpecimenOrObservationBase (
|
|
3744
|
DTYPE varchar(31) not null,
|
|
3745
|
id integer not null,
|
|
3746
|
created timestamp,
|
|
3747
|
uuid varchar(36),
|
|
3748
|
updated timestamp,
|
|
3749
|
lsid_authority varchar(255),
|
|
3750
|
lsid_lsid varchar(255),
|
|
3751
|
lsid_namespace varchar(255),
|
|
3752
|
lsid_object varchar(255),
|
|
3753
|
lsid_revision varchar(255),
|
|
3754
|
protectedtitlecache bit not null,
|
|
3755
|
titleCache varchar(255),
|
|
3756
|
individualcount integer,
|
|
3757
|
accessionnumber varchar(255),
|
|
3758
|
catalognumber varchar(255),
|
|
3759
|
collectorsnumber varchar(255),
|
|
3760
|
barcode varchar(255),
|
|
3761
|
fieldnotes varchar(255),
|
|
3762
|
fieldnumber varchar(255),
|
|
3763
|
createdby_id integer,
|
|
3764
|
updatedby_id integer,
|
|
3765
|
lifestage_id integer,
|
|
3766
|
sex_id integer,
|
|
3767
|
exsiccatum varchar(255),
|
|
3768
|
primarycollector_id integer,
|
|
3769
|
collection_id integer,
|
|
3770
|
derivedfrom_id integer,
|
|
3771
|
storedunder_id integer,
|
|
3772
|
preservation_id integer,
|
|
3773
|
gatheringevent_id integer,
|
|
3774
|
primary key (id),
|
|
3775
|
unique (uuid)
|
|
3776
|
);
|
|
3777
|
|
|
3778
|
|
|
3779
|
create table SpecimenOrObservationBase_AUD (
|
|
3780
|
DTYPE varchar(31) not null,
|
|
3781
|
id integer not null,
|
|
3782
|
REV integer not null,
|
|
3783
|
revtype tinyint,
|
|
3784
|
created timestamp,
|
|
3785
|
uuid varchar(36),
|
|
3786
|
updated timestamp,
|
|
3787
|
lsid_authority varchar(255),
|
|
3788
|
lsid_lsid varchar(255),
|
|
3789
|
lsid_namespace varchar(255),
|
|
3790
|
lsid_object varchar(255),
|
|
3791
|
lsid_revision varchar(255),
|
|
3792
|
protectedtitlecache bit,
|
|
3793
|
titleCache varchar(255),
|
|
3794
|
individualcount integer,
|
|
3795
|
createdby_id integer,
|
|
3796
|
updatedby_id integer,
|
|
3797
|
lifestage_id integer,
|
|
3798
|
sex_id integer,
|
|
3799
|
fieldnotes varchar(255),
|
|
3800
|
fieldnumber varchar(255),
|
|
3801
|
barcode varchar(255),
|
|
3802
|
exsiccatum varchar(255),
|
|
3803
|
gatheringevent_id integer,
|
|
3804
|
accessionnumber varchar(255),
|
|
3805
|
catalognumber varchar(255),
|
|
3806
|
collectorsnumber varchar(255),
|
|
3807
|
primarycollector_id integer,
|
|
3808
|
collection_id integer,
|
|
3809
|
derivedfrom_id integer,
|
|
3810
|
storedunder_id integer,
|
|
3811
|
preservation_id integer,
|
|
3812
|
primary key (id, REV)
|
|
3813
|
);
|
|
3814
|
|
|
3815
|
create table SpecimenOrObservationBase_Annotation (
|
|
3816
|
SpecimenOrObservationBase_id integer not null,
|
|
3817
|
annotations_id integer not null,
|
|
3818
|
primary key (SpecimenOrObservationBase_id, annotations_id),
|
|
3819
|
unique (annotations_id)
|
|
3820
|
);
|
|
3821
|
|
|
3822
|
create table SpecimenOrObservationBase_Annotation_AUD (
|
|
3823
|
REV integer not null,
|
|
3824
|
SpecimenOrObservationBase_id integer not null,
|
|
3825
|
annotations_id integer not null,
|
|
3826
|
revtype tinyint,
|
|
3827
|
primary key (REV, SpecimenOrObservationBase_id, annotations_id)
|
|
3828
|
);
|
|
3829
|
|
|
3830
|
create table SpecimenOrObservationBase_Credit (
|
|
3831
|
SpecimenOrObservationBase_id integer not null,
|
|
3832
|
credits_id integer not null,
|
|
3833
|
sortIndex integer not null,
|
|
3834
|
primary key (SpecimenOrObservationBase_id, sortIndex),
|
|
3835
|
unique (credits_id)
|
|
3836
|
);
|
|
3837
|
|
|
3838
|
create table SpecimenOrObservationBase_Credit_AUD (
|
|
3839
|
REV integer not null,
|
|
3840
|
SpecimenOrObservationBase_id integer not null,
|
|
3841
|
credits_id integer not null,
|
|
3842
|
sortIndex integer not null,
|
|
3843
|
revtype tinyint,
|
|
3844
|
primary key (REV, SpecimenOrObservationBase_id, credits_id, sortIndex)
|
|
3845
|
);
|
|
3846
|
|
|
3847
|
create table SpecimenOrObservationBase_DerivationEvent (
|
|
3848
|
originals_id integer not null,
|
|
3849
|
derivationevents_id integer not null,
|
|
3850
|
primary key (originals_id, derivationevents_id)
|
|
3851
|
);
|
|
3852
|
|
|
3853
|
create table SpecimenOrObservationBase_DerivationEvent_AUD (
|
|
3854
|
REV integer not null,
|
|
3855
|
originals_id integer not null,
|
|
3856
|
derivationevents_id integer not null,
|
|
3857
|
revtype tinyint,
|
|
3858
|
primary key (REV, originals_id, derivationevents_id)
|
|
3859
|
);
|
|
3860
|
|
|
3861
|
create table SpecimenOrObservationBase_Extension (
|
|
3862
|
SpecimenOrObservationBase_id integer not null,
|
|
3863
|
extensions_id integer not null,
|
|
3864
|
primary key (SpecimenOrObservationBase_id, extensions_id),
|
|
3865
|
unique (extensions_id)
|
|
3866
|
);
|
|
3867
|
|
|
3868
|
create table SpecimenOrObservationBase_Extension_AUD (
|
|
3869
|
REV integer not null,
|
|
3870
|
SpecimenOrObservationBase_id integer not null,
|
|
3871
|
extensions_id integer not null,
|
|
3872
|
revtype tinyint,
|
|
3873
|
primary key (REV, SpecimenOrObservationBase_id, extensions_id)
|
|
3874
|
);
|
|
3875
|
|
|
3876
|
create table SpecimenOrObservationBase_LanguageString (
|
|
3877
|
SpecimenOrObservationBase_id integer not null,
|
|
3878
|
definition_id integer not null,
|
|
3879
|
definition_mapkey_id integer not null,
|
|
3880
|
primary key (SpecimenOrObservationBase_id, definition_mapkey_id),
|
|
3881
|
unique (definition_id)
|
|
3882
|
);
|
|
3883
|
|
|
3884
|
create table SpecimenOrObservationBase_LanguageString_AUD (
|
|
3885
|
REV integer not null,
|
|
3886
|
SpecimenOrObservationBase_id integer not null,
|
|
3887
|
definition_id integer not null,
|
|
3888
|
definition_mapkey_id integer not null,
|
|
3889
|
revtype tinyint,
|
|
3890
|
primary key (REV, SpecimenOrObservationBase_id, definition_id, definition_mapkey_id)
|
|
3891
|
);
|
|
3892
|
|
|
3893
|
create table SpecimenOrObservationBase_Marker (
|
|
3894
|
SpecimenOrObservationBase_id integer not null,
|
|
3895
|
markers_id integer not null,
|
|
3896
|
primary key (SpecimenOrObservationBase_id, markers_id),
|
|
3897
|
unique (markers_id)
|
|
3898
|
);
|
|
3899
|
|
|
3900
|
create table SpecimenOrObservationBase_Marker_AUD (
|
|
3901
|
REV integer not null,
|
|
3902
|
SpecimenOrObservationBase_id integer not null,
|
|
3903
|
markers_id integer not null,
|
|
3904
|
revtype tinyint,
|
|
3905
|
primary key (REV, SpecimenOrObservationBase_id, markers_id)
|
|
3906
|
);
|
|
3907
|
|
|
3908
|
create table SpecimenOrObservationBase_Media (
|
|
3909
|
SpecimenOrObservationBase_id integer not null,
|
|
3910
|
media_id integer not null,
|
|
3911
|
primary key (SpecimenOrObservationBase_id, media_id)
|
|
3912
|
);
|
|
3913
|
|
|
3914
|
create table SpecimenOrObservationBase_Media_AUD (
|
|
3915
|
REV integer not null,
|
|
3916
|
SpecimenOrObservationBase_id integer not null,
|
|
3917
|
media_id integer not null,
|
|
3918
|
revtype tinyint,
|
|
3919
|
primary key (REV, SpecimenOrObservationBase_id, media_id)
|
|
3920
|
);
|
|
3921
|
|
|
3922
|
create table SpecimenOrObservationBase_OriginalSourceBase (
|
|
3923
|
SpecimenOrObservationBase_id integer not null,
|
|
3924
|
sources_id integer not null,
|
|
3925
|
primary key (SpecimenOrObservationBase_id, sources_id),
|
|
3926
|
unique (sources_id)
|
|
3927
|
);
|
|
3928
|
|
|
3929
|
create table SpecimenOrObservationBase_OriginalSourceBase_AUD (
|
|
3930
|
REV integer not null,
|
|
3931
|
SpecimenOrObservationBase_id integer not null,
|
|
3932
|
sources_id integer not null,
|
|
3933
|
revtype tinyint,
|
|
3934
|
primary key (REV, SpecimenOrObservationBase_id, sources_id)
|
|
3935
|
);
|
|
3936
|
|
|
3937
|
create table SpecimenOrObservationBase_Rights (
|
|
3938
|
SpecimenOrObservationBase_id integer not null,
|
|
3939
|
rights_id integer not null,
|
|
3940
|
primary key (SpecimenOrObservationBase_id, rights_id),
|
|
3941
|
unique (rights_id)
|
|
3942
|
);
|
|
3943
|
|
|
3944
|
create table SpecimenOrObservationBase_Rights_AUD (
|
|
3945
|
REV integer not null,
|
|
3946
|
SpecimenOrObservationBase_id integer not null,
|
|
3947
|
rights_id integer not null,
|
|
3948
|
revtype tinyint,
|
|
3949
|
primary key (REV, SpecimenOrObservationBase_id, rights_id)
|
|
3950
|
);
|
|
3951
|
|
|
3952
|
create table SpecimenOrObservationBase_Sequence (
|
|
3953
|
SpecimenOrObservationBase_id integer not null,
|
|
3954
|
sequences_id integer not null,
|
|
3955
|
primary key (SpecimenOrObservationBase_id, sequences_id),
|
|
3956
|
unique (sequences_id)
|
|
3957
|
);
|
|
3958
|
|
|
3959
|
create table SpecimenOrObservationBase_Sequence_AUD (
|
|
3960
|
REV integer not null,
|
|
3961
|
SpecimenOrObservationBase_id integer not null,
|
|
3962
|
sequences_id integer not null,
|
|
3963
|
revtype tinyint,
|
|
3964
|
primary key (REV, SpecimenOrObservationBase_id, sequences_id)
|
|
3965
|
);
|
|
3966
|
|
|
3967
|
create table StateData (
|
|
3968
|
id integer not null,
|
|
3969
|
created timestamp,
|
|
3970
|
uuid varchar(36),
|
|
3971
|
updated timestamp,
|
|
3972
|
createdby_id integer,
|
|
3973
|
updatedby_id integer,
|
|
3974
|
state_id integer,
|
|
3975
|
primary key (id),
|
|
3976
|
unique (uuid)
|
|
3977
|
);
|
|
3978
|
|
|
3979
|
create table StateData_AUD (
|
|
3980
|
id integer not null,
|
|
3981
|
REV integer not null,
|
|
3982
|
revtype tinyint,
|
|
3983
|
created timestamp,
|
|
3984
|
uuid varchar(36),
|
|
3985
|
updated timestamp,
|
|
3986
|
createdby_id integer,
|
|
3987
|
updatedby_id integer,
|
|
3988
|
state_id integer,
|
|
3989
|
primary key (id, REV)
|
|
3990
|
);
|
|
3991
|
|
|
3992
|
create table StateData_DefinedTermBase (
|
|
3993
|
StateData_id integer not null,
|
|
3994
|
modifiers_id integer not null,
|
|
3995
|
primary key (StateData_id, modifiers_id),
|
|
3996
|
unique (modifiers_id)
|
|
3997
|
);
|
|
3998
|
|
|
3999
|
create table StateData_DefinedTermBase_AUD (
|
|
4000
|
REV integer not null,
|
|
4001
|
StateData_id integer not null,
|
|
4002
|
modifiers_id integer not null,
|
|
4003
|
revtype tinyint,
|
|
4004
|
primary key (REV, StateData_id, modifiers_id)
|
|
4005
|
);
|
|
4006
|
|
|
4007
|
create table StateData_LanguageString (
|
|
4008
|
StateData_id integer not null,
|
|
4009
|
modifyingtext_id integer not null,
|
|
4010
|
modifyingtext_mapkey_id integer not null,
|
|
4011
|
primary key (StateData_id, modifyingtext_mapkey_id),
|
|
4012
|
unique (modifyingtext_id)
|
|
4013
|
);
|
|
4014
|
|
|
4015
|
create table StateData_LanguageString_AUD (
|
|
4016
|
REV integer not null,
|
|
4017
|
StateData_id integer not null,
|
|
4018
|
modifyingtext_id integer not null,
|
|
4019
|
modifyingtext_mapkey_id integer not null,
|
|
4020
|
revtype tinyint,
|
|
4021
|
primary key (REV, StateData_id, modifyingtext_id, modifyingtext_mapkey_id)
|
|
4022
|
);
|
|
4023
|
|
|
4024
|
create table StatisticalMeasurementValue (
|
|
4025
|
id integer not null,
|
|
4026
|
created timestamp,
|
|
4027
|
uuid varchar(36),
|
|
4028
|
updated timestamp,
|
|
4029
|
value float not null,
|
|
4030
|
createdby_id integer,
|
|
4031
|
updatedby_id integer,
|
|
4032
|
type_id integer,
|
|
4033
|
primary key (id),
|
|
4034
|
unique (uuid)
|
|
4035
|
);
|
|
4036
|
|
|
4037
|
create table StatisticalMeasurementValue_AUD (
|
|
4038
|
id integer not null,
|
|
4039
|
REV integer not null,
|
|
4040
|
revtype tinyint,
|
|
4041
|
created timestamp,
|
|
4042
|
uuid varchar(36),
|
|
4043
|
updated timestamp,
|
|
4044
|
value float,
|
|
4045
|
createdby_id integer,
|
|
4046
|
updatedby_id integer,
|
|
4047
|
type_id integer,
|
|
4048
|
primary key (id, REV)
|
|
4049
|
);
|
|
4050
|
|
|
4051
|
create table StatisticalMeasurementValue_DefinedTermBase (
|
|
4052
|
StatisticalMeasurementValue_id integer not null,
|
|
4053
|
modifiers_id integer not null,
|
|
4054
|
primary key (StatisticalMeasurementValue_id, modifiers_id),
|
|
4055
|
unique (modifiers_id)
|
|
4056
|
);
|
|
4057
|
|
|
4058
|
create table StatisticalMeasurementValue_DefinedTermBase_AUD (
|
|
4059
|
REV integer not null,
|
|
4060
|
StatisticalMeasurementValue_id integer not null,
|
|
4061
|
modifiers_id integer not null,
|
|
4062
|
revtype tinyint,
|
|
4063
|
primary key (REV, StatisticalMeasurementValue_id, modifiers_id)
|
|
4064
|
);
|
|
4065
|
|
|
4066
|
create table SynonymRelationship (
|
|
4067
|
id integer not null,
|
|
4068
|
created timestamp,
|
|
4069
|
uuid varchar(36),
|
|
4070
|
updated timestamp,
|
|
4071
|
citationmicroreference varchar(255),
|
|
4072
|
originalnamestring varchar(255),
|
|
4073
|
doubtful bit not null,
|
|
4074
|
partial bit not null,
|
|
4075
|
proparte bit not null,
|
|
4076
|
createdby_id integer,
|
|
4077
|
updatedby_id integer,
|
|
4078
|
citation_id integer,
|
|
4079
|
relatedfrom_id integer,
|
|
4080
|
relatedto_id integer,
|
|
4081
|
type_id integer,
|
|
4082
|
primary key (id),
|
|
4083
|
unique (uuid)
|
|
4084
|
);
|
|
4085
|
|
|
4086
|
create table SynonymRelationship_AUD (
|
|
4087
|
id integer not null,
|
|
4088
|
REV integer not null,
|
|
4089
|
revtype tinyint,
|
|
4090
|
created timestamp,
|
|
4091
|
uuid varchar(36),
|
|
4092
|
updated timestamp,
|
|
4093
|
citationmicroreference varchar(255),
|
|
4094
|
originalnamestring varchar(255),
|
|
4095
|
doubtful bit,
|
|
4096
|
partial bit,
|
|
4097
|
proparte bit,
|
|
4098
|
createdby_id integer,
|
|
4099
|
updatedby_id integer,
|
|
4100
|
citation_id integer,
|
|
4101
|
relatedfrom_id integer,
|
|
4102
|
relatedto_id integer,
|
|
4103
|
type_id integer,
|
|
4104
|
primary key (id, REV)
|
|
4105
|
);
|
|
4106
|
|
|
4107
|
create table SynonymRelationship_Annotation (
|
|
4108
|
SynonymRelationship_id integer not null,
|
|
4109
|
annotations_id integer not null,
|
|
4110
|
primary key (SynonymRelationship_id, annotations_id),
|
|
4111
|
unique (annotations_id)
|
|
4112
|
);
|
|
4113
|
|
|
4114
|
create table SynonymRelationship_Annotation_AUD (
|
|
4115
|
REV integer not null,
|
|
4116
|
SynonymRelationship_id integer not null,
|
|
4117
|
annotations_id integer not null,
|
|
4118
|
revtype tinyint,
|
|
4119
|
primary key (REV, SynonymRelationship_id, annotations_id)
|
|
4120
|
);
|
|
4121
|
|
|
4122
|
create table SynonymRelationship_Marker (
|
|
4123
|
SynonymRelationship_id integer not null,
|
|
4124
|
markers_id integer not null,
|
|
4125
|
primary key (SynonymRelationship_id, markers_id),
|
|
4126
|
unique (markers_id)
|
|
4127
|
);
|
|
4128
|
|
|
4129
|
create table SynonymRelationship_Marker_AUD (
|
|
4130
|
REV integer not null,
|
|
4131
|
SynonymRelationship_id integer not null,
|
|
4132
|
markers_id integer not null,
|
|
4133
|
revtype tinyint,
|
|
4134
|
primary key (REV, SynonymRelationship_id, markers_id)
|
|
4135
|
);
|
|
4136
|
|
|
4137
|
create table TaxonBase (
|
|
4138
|
DTYPE varchar(31) not null,
|
|
4139
|
id integer not null,
|
|
4140
|
created timestamp,
|
|
4141
|
uuid varchar(36),
|
|
4142
|
updated timestamp,
|
|
4143
|
lsid_authority varchar(255),
|
|
4144
|
lsid_lsid varchar(255),
|
|
4145
|
lsid_namespace varchar(255),
|
|
4146
|
lsid_object varchar(255),
|
|
4147
|
lsid_revision varchar(255),
|
|
4148
|
protectedtitlecache bit not null,
|
|
4149
|
titleCache varchar(255),
|
|
4150
|
appendedphrase varchar(255),
|
|
4151
|
doubtful bit not null,
|
|
4152
|
usenamecache bit not null,
|
|
4153
|
taxonstatusunknown bit,
|
|
4154
|
unplaced bit,
|
|
4155
|
excluded bit,
|
|
4156
|
taxonomicchildrencount integer,
|
|
4157
|
createdby_id integer,
|
|
4158
|
updatedby_id integer,
|
|
4159
|
name_id integer,
|
|
4160
|
sec_id integer,
|
|
4161
|
taxonomicparentcache_id integer,
|
|
4162
|
primary key (id),
|
|
4163
|
unique (uuid)
|
|
4164
|
);
|
|
4165
|
|
|
4166
|
create table TaxonBase_AUD (
|
|
4167
|
DTYPE varchar(31) not null,
|
|
4168
|
id integer not null,
|
|
4169
|
REV integer not null,
|
|
4170
|
revtype tinyint,
|
|
4171
|
created timestamp,
|
|
4172
|
uuid varchar(36),
|
|
4173
|
updated timestamp,
|
|
4174
|
lsid_authority varchar(255),
|
|
4175
|
lsid_lsid varchar(255),
|
|
4176
|
lsid_namespace varchar(255),
|
|
4177
|
lsid_object varchar(255),
|
|
4178
|
lsid_revision varchar(255),
|
|
4179
|
protectedtitlecache bit,
|
|
4180
|
titleCache varchar(255),
|
|
4181
|
appendedphrase varchar(255),
|
|
4182
|
doubtful bit,
|
|
4183
|
usenamecache bit,
|
|
4184
|
createdby_id integer,
|
|
4185
|
updatedby_id integer,
|
|
4186
|
name_id integer,
|
|
4187
|
sec_id integer,
|
|
4188
|
taxonstatusunknown bit,
|
|
4189
|
unplaced bit,
|
|
4190
|
excluded bit,
|
|
4191
|
taxonomicchildrencount integer,
|
|
4192
|
taxonomicparentcache_id integer,
|
|
4193
|
primary key (id, REV)
|
|
4194
|
);
|
|
4195
|
|
|
4196
|
create table TaxonBase_Annotation (
|
|
4197
|
TaxonBase_id integer not null,
|
|
4198
|
annotations_id integer not null,
|
|
4199
|
primary key (TaxonBase_id, annotations_id),
|
|
4200
|
unique (annotations_id)
|
|
4201
|
);
|
|
4202
|
|
|
4203
|
create table TaxonBase_Annotation_AUD (
|
|
4204
|
REV integer not null,
|
|
4205
|
TaxonBase_id integer not null,
|
|
4206
|
annotations_id integer not null,
|
|
4207
|
revtype tinyint,
|
|
4208
|
primary key (REV, TaxonBase_id, annotations_id)
|
|
4209
|
);
|
|
4210
|
|
|
4211
|
create table TaxonBase_Credit (
|
|
4212
|
TaxonBase_id integer not null,
|
|
4213
|
credits_id integer not null,
|
|
4214
|
sortIndex integer not null,
|
|
4215
|
primary key (TaxonBase_id, sortIndex),
|
|
4216
|
unique (credits_id)
|
|
4217
|
);
|
|
4218
|
|
|
4219
|
create table TaxonBase_Credit_AUD (
|
|
4220
|
REV integer not null,
|
|
4221
|
TaxonBase_id integer not null,
|
|
4222
|
credits_id integer not null,
|
|
4223
|
sortIndex integer not null,
|
|
4224
|
revtype tinyint,
|
|
4225
|
primary key (REV, TaxonBase_id, credits_id, sortIndex)
|
|
4226
|
);
|
|
4227
|
|
|
4228
|
create table TaxonBase_Extension (
|
|
4229
|
TaxonBase_id integer not null,
|
|
4230
|
extensions_id integer not null,
|
|
4231
|
primary key (TaxonBase_id, extensions_id),
|
|
4232
|
unique (extensions_id)
|
|
4233
|
);
|
|
4234
|
|
|
4235
|
create table TaxonBase_Extension_AUD (
|
|
4236
|
REV integer not null,
|
|
4237
|
TaxonBase_id integer not null,
|
|
4238
|
extensions_id integer not null,
|
|
4239
|
revtype tinyint,
|
|
4240
|
primary key (REV, TaxonBase_id, extensions_id)
|
|
4241
|
);
|
|
4242
|
|
|
4243
|
create table TaxonBase_Marker (
|
|
4244
|
TaxonBase_id integer not null,
|
|
4245
|
markers_id integer not null,
|
|
4246
|
primary key (TaxonBase_id, markers_id),
|
|
4247
|
unique (markers_id)
|
|
4248
|
);
|
|
4249
|
|
|
4250
|
create table TaxonBase_Marker_AUD (
|
|
4251
|
REV integer not null,
|
|
4252
|
TaxonBase_id integer not null,
|
|
4253
|
markers_id integer not null,
|
|
4254
|
revtype tinyint,
|
|
4255
|
primary key (REV, TaxonBase_id, markers_id)
|
|
4256
|
);
|
|
4257
|
|
|
4258
|
create table TaxonBase_OriginalSourceBase (
|
|
4259
|
TaxonBase_id integer not null,
|
|
4260
|
sources_id integer not null,
|
|
4261
|
primary key (TaxonBase_id, sources_id),
|
|
4262
|
unique (sources_id)
|
|
4263
|
);
|
|
4264
|
|
|
4265
|
create table TaxonBase_OriginalSourceBase_AUD (
|
|
4266
|
REV integer not null,
|
|
4267
|
TaxonBase_id integer not null,
|
|
4268
|
sources_id integer not null,
|
|
4269
|
revtype tinyint,
|
|
4270
|
primary key (REV, TaxonBase_id, sources_id)
|
|
4271
|
);
|
|
4272
|
|
|
4273
|
create table TaxonBase_Rights (
|
|
4274
|
TaxonBase_id integer not null,
|
|
4275
|
rights_id integer not null,
|
|
4276
|
primary key (TaxonBase_id, rights_id),
|
|
4277
|
unique (rights_id)
|
|
4278
|
);
|
|
4279
|
|
|
4280
|
create table TaxonBase_Rights_AUD (
|
|
4281
|
REV integer not null,
|
|
4282
|
TaxonBase_id integer not null,
|
|
4283
|
rights_id integer not null,
|
|
4284
|
revtype tinyint,
|
|
4285
|
primary key (REV, TaxonBase_id, rights_id)
|
|
4286
|
);
|
|
4287
|
|
|
4288
|
create table TaxonInteraction_LanguageString (
|
|
4289
|
DescriptionElementBase_id integer not null,
|
|
4290
|
description_id integer not null,
|
|
4291
|
description_mapkey_id integer not null,
|
|
4292
|
primary key (DescriptionElementBase_id, description_mapkey_id),
|
|
4293
|
unique (description_id)
|
|
4294
|
);
|
|
4295
|
|
|
4296
|
create table TaxonInteraction_LanguageString_AUD (
|
|
4297
|
REV integer not null,
|
|
4298
|
DescriptionElementBase_id integer not null,
|
|
4299
|
description_id integer not null,
|
|
4300
|
description_mapkey_id integer not null,
|
|
4301
|
revtype tinyint,
|
|
4302
|
primary key (REV, DescriptionElementBase_id, description_id, description_mapkey_id)
|
|
4303
|
);
|
|
4304
|
|
|
4305
|
create table TaxonNameBase (
|
|
4306
|
DTYPE varchar(31) not null,
|
|
4307
|
id integer not null,
|
|
4308
|
created timestamp,
|
|
4309
|
uuid varchar(36),
|
|
4310
|
updated timestamp,
|
|
4311
|
lsid_authority varchar(255),
|
|
4312
|
lsid_lsid varchar(255),
|
|
4313
|
lsid_namespace varchar(255),
|
|
4314
|
lsid_object varchar(255),
|
|
4315
|
lsid_revision varchar(255),
|
|
4316
|
protectedtitlecache bit not null,
|
|
4317
|
titleCache varchar(255),
|
|
4318
|
appendedphrase varchar(255),
|
|
4319
|
fullTitleCache varchar(330),
|
|
4320
|
nomenclaturalmicroreference varchar(255),
|
|
4321
|
parsingproblem integer not null,
|
|
4322
|
problemends integer not null,
|
|
4323
|
problemstarts integer not null,
|
|
4324
|
protectedfulltitlecache bit not null,
|
|
4325
|
authorshipcache varchar(255),
|
|
4326
|
binomhybrid bit,
|
|
4327
|
genusoruninomial varchar(255),
|
|
4328
|
hybridformula bit,
|
|
4329
|
infragenericepithet varchar(255),
|
|
4330
|
infraspecificepithet varchar(255),
|
|
4331
|
monomhybrid bit,
|
|
4332
|
namecache varchar(255),
|
|
4333
|
protectedauthorshipcache bit,
|
|
4334
|
protectednamecache bit,
|
|
4335
|
specificepithet varchar(255),
|
|
4336
|
trinomhybrid bit,
|
|
4337
|
nameapprobation varchar(255),
|
|
4338
|
subgenusauthorship varchar(255),
|
|
4339
|
anamorphic bit,
|
|
4340
|
cultivarname varchar(255),
|
|
4341
|
acronym varchar(255),
|
|
4342
|
breed varchar(255),
|
|
4343
|
originalpublicationyear integer,
|
|
4344
|
publicationyear integer,
|
|
4345
|
createdby_id integer,
|
|
4346
|
updatedby_id integer,
|
|
4347
|
homotypicalgroup_id integer,
|
|
4348
|
nomenclaturalreference_id integer,
|
|
4349
|
rank_id integer,
|
|
4350
|
basionymauthorteam_id integer,
|
|
4351
|
combinationauthorteam_id integer,
|
|
4352
|
exbasionymauthorteam_id integer,
|
|
4353
|
excombinationauthorteam_id integer,
|
|
4354
|
primary key (id),
|
|
4355
|
unique (uuid)
|
|
4356
|
);
|
|
4357
|
|
|
4358
|
create table TaxonNameBase_AUD (
|
|
4359
|
DTYPE varchar(31) not null,
|
|
4360
|
id integer not null,
|
|
4361
|
REV integer not null,
|
|
4362
|
revtype tinyint,
|
|
4363
|
created timestamp,
|
|
4364
|
uuid varchar(36),
|
|
4365
|
updated timestamp,
|
|
4366
|
lsid_authority varchar(255),
|
|
4367
|
lsid_lsid varchar(255),
|
|
4368
|
lsid_namespace varchar(255),
|
|
4369
|
lsid_object varchar(255),
|
|
4370
|
lsid_revision varchar(255),
|
|
4371
|
protectedtitlecache bit,
|
|
4372
|
titleCache varchar(255),
|
|
4373
|
appendedphrase varchar(255),
|
|
4374
|
fullTitleCache varchar(330),
|
|
4375
|
nomenclaturalmicroreference varchar(255),
|
|
4376
|
parsingproblem integer,
|
|
4377
|
problemends integer,
|
|
4378
|
problemstarts integer,
|
|
4379
|
protectedfulltitlecache bit,
|
|
4380
|
createdby_id integer,
|
|
4381
|
updatedby_id integer,
|
|
4382
|
homotypicalgroup_id integer,
|
|
4383
|
nomenclaturalreference_id integer,
|
|
4384
|
rank_id integer,
|
|
4385
|
acronym varchar(255),
|
|
4386
|
authorshipcache varchar(255),
|
|
4387
|
binomhybrid bit,
|
|
4388
|
genusoruninomial varchar(255),
|
|
4389
|
hybridformula bit,
|
|
4390
|
infragenericepithet varchar(255),
|
|
4391
|
infraspecificepithet varchar(255),
|
|
4392
|
monomhybrid bit,
|
|
4393
|
namecache varchar(255),
|
|
4394
|
protectedauthorshipcache bit,
|
|
4395
|
protectednamecache bit,
|
|
4396
|
specificepithet varchar(255),
|
|
4397
|
trinomhybrid bit,
|
|
4398
|
basionymauthorteam_id integer,
|
|
4399
|
combinationauthorteam_id integer,
|
|
4400
|
exbasionymauthorteam_id integer,
|
|
4401
|
excombinationauthorteam_id integer,
|
|
4402
|
anamorphic bit,
|
|
4403
|
breed varchar(255),
|
|
4404
|
originalpublicationyear integer,
|
|
4405
|
publicationyear integer,
|
|
4406
|
cultivarname varchar(255),
|
|
4407
|
nameapprobation varchar(255),
|
|
4408
|
subgenusauthorship varchar(255),
|
|
4409
|
primary key (id, REV)
|
|
4410
|
);
|
|
4411
|
|
|
4412
|
create table TaxonNameBase_Annotation (
|
|
4413
|
TaxonNameBase_id integer not null,
|
|
4414
|
annotations_id integer not null,
|
|
4415
|
primary key (TaxonNameBase_id, annotations_id),
|
|
4416
|
unique (annotations_id)
|
|
4417
|
);
|
|
4418
|
|
|
4419
|
create table TaxonNameBase_Annotation_AUD (
|
|
4420
|
REV integer not null,
|
|
4421
|
TaxonNameBase_id integer not null,
|
|
4422
|
annotations_id integer not null,
|
|
4423
|
revtype tinyint,
|
|
4424
|
primary key (REV, TaxonNameBase_id, annotations_id)
|
|
4425
|
);
|
|
4426
|
|
|
4427
|
create table TaxonNameBase_Credit (
|
|
4428
|
TaxonNameBase_id integer not null,
|
|
4429
|
credits_id integer not null,
|
|
4430
|
sortIndex integer not null,
|
|
4431
|
primary key (TaxonNameBase_id, sortIndex),
|
|
4432
|
unique (credits_id)
|
|
4433
|
);
|
|
4434
|
|
|
4435
|
create table TaxonNameBase_Credit_AUD (
|
|
4436
|
REV integer not null,
|
|
4437
|
TaxonNameBase_id integer not null,
|
|
4438
|
credits_id integer not null,
|
|
4439
|
sortIndex integer not null,
|
|
4440
|
revtype tinyint,
|
|
4441
|
primary key (REV, TaxonNameBase_id, credits_id, sortIndex)
|
|
4442
|
);
|
|
4443
|
|
|
4444
|
create table TaxonNameBase_Extension (
|
|
4445
|
TaxonNameBase_id integer not null,
|
|
4446
|
extensions_id integer not null,
|
|
4447
|
primary key (TaxonNameBase_id, extensions_id),
|
|
4448
|
unique (extensions_id)
|
|
4449
|
);
|
|
4450
|
|
|
4451
|
create table TaxonNameBase_Extension_AUD (
|
|
4452
|
REV integer not null,
|
|
4453
|
TaxonNameBase_id integer not null,
|
|
4454
|
extensions_id integer not null,
|
|
4455
|
revtype tinyint,
|
|
4456
|
primary key (REV, TaxonNameBase_id, extensions_id)
|
|
4457
|
);
|
|
4458
|
|
|
4459
|
create table TaxonNameBase_Marker (
|
|
4460
|
TaxonNameBase_id integer not null,
|
|
4461
|
markers_id integer not null,
|
|
4462
|
primary key (TaxonNameBase_id, markers_id),
|
|
4463
|
unique (markers_id)
|
|
4464
|
);
|
|
4465
|
|
|
4466
|
create table TaxonNameBase_Marker_AUD (
|
|
4467
|
REV integer not null,
|
|
4468
|
TaxonNameBase_id integer not null,
|
|
4469
|
markers_id integer not null,
|
|
4470
|
revtype tinyint,
|
|
4471
|
primary key (REV, TaxonNameBase_id, markers_id)
|
|
4472
|
);
|
|
4473
|
|
|
4474
|
create table TaxonNameBase_NomenclaturalStatus (
|
|
4475
|
TaxonNameBase_id integer not null,
|
|
4476
|
status_id integer not null,
|
|
4477
|
primary key (TaxonNameBase_id, status_id),
|
|
4478
|
unique (status_id)
|
|
4479
|
);
|
|
4480
|
|
|
4481
|
create table TaxonNameBase_NomenclaturalStatus_AUD (
|
|
4482
|
REV integer not null,
|
|
4483
|
TaxonNameBase_id integer not null,
|
|
4484
|
status_id integer not null,
|
|
4485
|
revtype tinyint,
|
|
4486
|
primary key (REV, TaxonNameBase_id, status_id)
|
|
4487
|
);
|
|
4488
|
|
|
4489
|
create table TaxonNameBase_OriginalSourceBase (
|
|
4490
|
TaxonNameBase_id integer not null,
|
|
4491
|
sources_id integer not null,
|
|
4492
|
primary key (TaxonNameBase_id, sources_id),
|
|
4493
|
unique (sources_id)
|
|
4494
|
);
|
|
4495
|
|
|
4496
|
create table TaxonNameBase_OriginalSourceBase_AUD (
|
|
4497
|
REV integer not null,
|
|
4498
|
TaxonNameBase_id integer not null,
|
|
4499
|
sources_id integer not null,
|
|
4500
|
revtype tinyint,
|
|
4501
|
primary key (REV, TaxonNameBase_id, sources_id)
|
|
4502
|
);
|
|
4503
|
|
|
4504
|
create table TaxonNameBase_Rights (
|
|
4505
|
TaxonNameBase_id integer not null,
|
|
4506
|
rights_id integer not null,
|
|
4507
|
primary key (TaxonNameBase_id, rights_id),
|
|
4508
|
unique (rights_id)
|
|
4509
|
);
|
|
4510
|
|
|
4511
|
create table TaxonNameBase_Rights_AUD (
|
|
4512
|
REV integer not null,
|
|
4513
|
TaxonNameBase_id integer not null,
|
|
4514
|
rights_id integer not null,
|
|
4515
|
revtype tinyint,
|
|
4516
|
primary key (REV, TaxonNameBase_id, rights_id)
|
|
4517
|
);
|
|
4518
|
|
|
4519
|
create table TaxonNameBase_TypeDesignationBase (
|
|
4520
|
TaxonNameBase_id integer not null,
|
|
4521
|
typedesignations_id integer not null,
|
|
4522
|
primary key (TaxonNameBase_id, typedesignations_id)
|
|
4523
|
);
|
|
4524
|
|
|
4525
|
create table TaxonNameBase_TypeDesignationBase_AUD (
|
|
4526
|
REV integer not null,
|
|
4527
|
TaxonNameBase_id integer not null,
|
|
4528
|
typedesignations_id integer not null,
|
|
4529
|
revtype tinyint,
|
|
4530
|
primary key (REV, TaxonNameBase_id, typedesignations_id)
|
|
4531
|
);
|
|
4532
|
|
|
4533
|
create table TaxonNode (
|
|
4534
|
id integer not null,
|
|
4535
|
created timestamp,
|
|
4536
|
uuid varchar(36),
|
|
4537
|
updated timestamp,
|
|
4538
|
countchildren integer not null,
|
|
4539
|
microreferenceforparentchildrelation varchar(255),
|
|
4540
|
createdby_id integer,
|
|
4541
|
updatedby_id integer,
|
|
4542
|
parent_id integer,
|
|
4543
|
referenceforparentchildrelation_id integer,
|
|
4544
|
synonymtobeused_id integer,
|
|
4545
|
taxon_id integer,
|
|
4546
|
classification_id integer,
|
|
4547
|
primary key (id),
|
|
4548
|
unique (uuid)
|
|
4549
|
);
|
|
4550
|
|
|
4551
|
create table TaxonNode_AUD (
|
|
4552
|
id integer not null,
|
|
4553
|
REV integer not null,
|
|
4554
|
revtype tinyint,
|
|
4555
|
created timestamp,
|
|
4556
|
uuid varchar(36),
|
|
4557
|
updated timestamp,
|
|
4558
|
countchildren integer,
|
|
4559
|
microreferenceforparentchildrelation varchar(255),
|
|
4560
|
createdby_id integer,
|
|
4561
|
updatedby_id integer,
|
|
4562
|
parent_id integer,
|
|
4563
|
referenceforparentchildrelation_id integer,
|
|
4564
|
synonymtobeused_id integer,
|
|
4565
|
taxon_id integer,
|
|
4566
|
classification_id integer,
|
|
4567
|
primary key (id, REV)
|
|
4568
|
);
|
|
4569
|
|
|
4570
|
create table TaxonNode_Annotation (
|
|
4571
|
TaxonNode_id integer not null,
|
|
4572
|
annotations_id integer not null,
|
|
4573
|
primary key (TaxonNode_id, annotations_id),
|
|
4574
|
unique (annotations_id)
|
|
4575
|
);
|
|
4576
|
|
|
4577
|
create table TaxonNode_Annotation_AUD (
|
|
4578
|
REV integer not null,
|
|
4579
|
TaxonNode_id integer not null,
|
|
4580
|
annotations_id integer not null,
|
|
4581
|
revtype tinyint,
|
|
4582
|
primary key (REV, TaxonNode_id, annotations_id)
|
|
4583
|
);
|
|
4584
|
|
|
4585
|
create table TaxonNode_Marker (
|
|
4586
|
TaxonNode_id integer not null,
|
|
4587
|
markers_id integer not null,
|
|
4588
|
primary key (TaxonNode_id, markers_id),
|
|
4589
|
unique (markers_id)
|
|
4590
|
);
|
|
4591
|
|
|
4592
|
create table TaxonNode_Marker_AUD (
|
|
4593
|
REV integer not null,
|
|
4594
|
TaxonNode_id integer not null,
|
|
4595
|
markers_id integer not null,
|
|
4596
|
revtype tinyint,
|
|
4597
|
primary key (REV, TaxonNode_id, markers_id)
|
|
4598
|
);
|
|
4599
|
|
|
4600
|
create table TaxonRelationship (
|
|
4601
|
id integer not null,
|
|
4602
|
created timestamp,
|
|
4603
|
uuid varchar(36),
|
|
4604
|
updated timestamp,
|
|
4605
|
citationmicroreference varchar(255),
|
|
4606
|
originalnamestring varchar(255),
|
|
4607
|
doubtful bit not null,
|
|
4608
|
createdby_id integer,
|
|
4609
|
updatedby_id integer,
|
|
4610
|
citation_id integer,
|
|
4611
|
relatedfrom_id integer,
|
|
4612
|
relatedto_id integer,
|
|
4613
|
type_id integer,
|
|
4614
|
primary key (id),
|
|
4615
|
unique (uuid)
|
|
4616
|
);
|
|
4617
|
|
|
4618
|
create table TaxonRelationship_AUD (
|
|
4619
|
id integer not null,
|
|
4620
|
REV integer not null,
|
|
4621
|
revtype tinyint,
|
|
4622
|
created timestamp,
|
|
4623
|
uuid varchar(36),
|
|
4624
|
updated timestamp,
|
|
4625
|
citationmicroreference varchar(255),
|
|
4626
|
originalnamestring varchar(255),
|
|
4627
|
doubtful bit,
|
|
4628
|
createdby_id integer,
|
|
4629
|
updatedby_id integer,
|
|
4630
|
citation_id integer,
|
|
4631
|
relatedfrom_id integer,
|
|
4632
|
relatedto_id integer,
|
|
4633
|
type_id integer,
|
|
4634
|
primary key (id, REV)
|
|
4635
|
);
|
|
4636
|
|
|
4637
|
create table TaxonRelationship_Annotation (
|
|
4638
|
TaxonRelationship_id integer not null,
|
|
4639
|
annotations_id integer not null,
|
|
4640
|
primary key (TaxonRelationship_id, annotations_id),
|
|
4641
|
unique (annotations_id)
|
|
4642
|
);
|
|
4643
|
|
|
4644
|
create table TaxonRelationship_Annotation_AUD (
|
|
4645
|
REV integer not null,
|
|
4646
|
TaxonRelationship_id integer not null,
|
|
4647
|
annotations_id integer not null,
|
|
4648
|
revtype tinyint,
|
|
4649
|
primary key (REV, TaxonRelationship_id, annotations_id)
|
|
4650
|
);
|
|
4651
|
|
|
4652
|
create table TaxonRelationship_Marker (
|
|
4653
|
TaxonRelationship_id integer not null,
|
|
4654
|
markers_id integer not null,
|
|
4655
|
primary key (TaxonRelationship_id, markers_id),
|
|
4656
|
unique (markers_id)
|
|
4657
|
);
|
|
4658
|
|
|
4659
|
create table TaxonRelationship_Marker_AUD (
|
|
4660
|
REV integer not null,
|
|
4661
|
TaxonRelationship_id integer not null,
|
|
4662
|
markers_id integer not null,
|
|
4663
|
revtype tinyint,
|
|
4664
|
primary key (REV, TaxonRelationship_id, markers_id)
|
|
4665
|
);
|
|
4666
|
|
|
4667
|
create table TermVocabulary (
|
|
4668
|
DTYPE varchar(31) not null,
|
|
4669
|
id integer not null,
|
|
4670
|
created timestamp,
|
|
4671
|
uuid varchar(36),
|
|
4672
|
updated timestamp,
|
|
4673
|
lsid_authority varchar(255),
|
|
4674
|
lsid_lsid varchar(255),
|
|
4675
|
lsid_namespace varchar(255),
|
|
4676
|
lsid_object varchar(255),
|
|
4677
|
lsid_revision varchar(255),
|
|
4678
|
protectedtitlecache bit not null,
|
|
4679
|
titleCache varchar(255),
|
|
4680
|
uri varchar(255),
|
|
4681
|
termsourceuri varchar(255),
|
|
4682
|
createdby_id integer,
|
|
4683
|
updatedby_id integer,
|
|
4684
|
primary key (id),
|
|
4685
|
unique (uuid)
|
|
4686
|
);
|
|
4687
|
|
|
4688
|
create table TermVocabulary_AUD (
|
|
4689
|
DTYPE varchar(31) not null,
|
|
4690
|
id integer not null,
|
|
4691
|
REV integer not null,
|
|
4692
|
revtype tinyint,
|
|
4693
|
created timestamp,
|
|
4694
|
uuid varchar(36),
|
|
4695
|
updated timestamp,
|
|
4696
|
lsid_authority varchar(255),
|
|
4697
|
lsid_lsid varchar(255),
|
|
4698
|
lsid_namespace varchar(255),
|
|
4699
|
lsid_object varchar(255),
|
|
4700
|
lsid_revision varchar(255),
|
|
4701
|
protectedtitlecache bit,
|
|
4702
|
titleCache varchar(255),
|
|
4703
|
uri varchar(255),
|
|
4704
|
termsourceuri varchar(255),
|
|
4705
|
createdby_id integer,
|
|
4706
|
updatedby_id integer,
|
|
4707
|
primary key (id, REV)
|
|
4708
|
);
|
|
4709
|
|
|
4710
|
create table TermVocabulary_Annotation (
|
|
4711
|
TermVocabulary_id integer not null,
|
|
4712
|
annotations_id integer not null,
|
|
4713
|
primary key (TermVocabulary_id, annotations_id),
|
|
4714
|
unique (annotations_id)
|
|
4715
|
);
|
|
4716
|
|
|
4717
|
create table TermVocabulary_Annotation_AUD (
|
|
4718
|
REV integer not null,
|
|
4719
|
TermVocabulary_id integer not null,
|
|
4720
|
annotations_id integer not null,
|
|
4721
|
revtype tinyint,
|
|
4722
|
primary key (REV, TermVocabulary_id, annotations_id)
|
|
4723
|
);
|
|
4724
|
|
|
4725
|
create table TermVocabulary_Credit (
|
|
4726
|
TermVocabulary_id integer not null,
|
|
4727
|
credits_id integer not null,
|
|
4728
|
sortIndex integer not null,
|
|
4729
|
primary key (TermVocabulary_id, sortIndex),
|
|
4730
|
unique (credits_id)
|
|
4731
|
);
|
|
4732
|
|
|
4733
|
create table TermVocabulary_Credit_AUD (
|
|
4734
|
REV integer not null,
|
|
4735
|
TermVocabulary_id integer not null,
|
|
4736
|
credits_id integer not null,
|
|
4737
|
sortIndex integer not null,
|
|
4738
|
revtype tinyint,
|
|
4739
|
primary key (REV, TermVocabulary_id, credits_id, sortIndex)
|
|
4740
|
);
|
|
4741
|
|
|
4742
|
create table TermVocabulary_Extension (
|
|
4743
|
TermVocabulary_id integer not null,
|
|
4744
|
extensions_id integer not null,
|
|
4745
|
primary key (TermVocabulary_id, extensions_id),
|
|
4746
|
unique (extensions_id)
|
|
4747
|
);
|
|
4748
|
|
|
4749
|
create table TermVocabulary_Extension_AUD (
|
|
4750
|
REV integer not null,
|
|
4751
|
TermVocabulary_id integer not null,
|
|
4752
|
extensions_id integer not null,
|
|
4753
|
revtype tinyint,
|
|
4754
|
primary key (REV, TermVocabulary_id, extensions_id)
|
|
4755
|
);
|
|
4756
|
|
|
4757
|
create table TermVocabulary_Marker (
|
|
4758
|
TermVocabulary_id integer not null,
|
|
4759
|
markers_id integer not null,
|
|
4760
|
primary key (TermVocabulary_id, markers_id),
|
|
4761
|
unique (markers_id)
|
|
4762
|
);
|
|
4763
|
|
|
4764
|
create table TermVocabulary_Marker_AUD (
|
|
4765
|
REV integer not null,
|
|
4766
|
TermVocabulary_id integer not null,
|
|
4767
|
markers_id integer not null,
|
|
4768
|
revtype tinyint,
|
|
4769
|
primary key (REV, TermVocabulary_id, markers_id)
|
|
4770
|
);
|
|
4771
|
|
|
4772
|
create table TermVocabulary_OriginalSourceBase (
|
|
4773
|
TermVocabulary_id integer not null,
|
|
4774
|
sources_id integer not null,
|
|
4775
|
primary key (TermVocabulary_id, sources_id),
|
|
4776
|
unique (sources_id)
|
|
4777
|
);
|
|
4778
|
|
|
4779
|
create table TermVocabulary_OriginalSourceBase_AUD (
|
|
4780
|
REV integer not null,
|
|
4781
|
TermVocabulary_id integer not null,
|
|
4782
|
sources_id integer not null,
|
|
4783
|
revtype tinyint,
|
|
4784
|
primary key (REV, TermVocabulary_id, sources_id)
|
|
4785
|
);
|
|
4786
|
|
|
4787
|
create table TermVocabulary_Representation (
|
|
4788
|
TermVocabulary_id integer not null,
|
|
4789
|
representations_id integer not null,
|
|
4790
|
primary key (TermVocabulary_id, representations_id),
|
|
4791
|
unique (representations_id)
|
|
4792
|
);
|
|
4793
|
|
|
4794
|
create table TermVocabulary_Representation_AUD (
|
|
4795
|
REV integer not null,
|
|
4796
|
TermVocabulary_id integer not null,
|
|
4797
|
representations_id integer not null,
|
|
4798
|
revtype tinyint,
|
|
4799
|
primary key (REV, TermVocabulary_id, representations_id)
|
|
4800
|
);
|
|
4801
|
|
|
4802
|
create table TermVocabulary_Rights (
|
|
4803
|
TermVocabulary_id integer not null,
|
|
4804
|
rights_id integer not null,
|
|
4805
|
primary key (TermVocabulary_id, rights_id),
|
|
4806
|
unique (rights_id)
|
|
4807
|
);
|
|
4808
|
|
|
4809
|
create table TermVocabulary_Rights_AUD (
|
|
4810
|
REV integer not null,
|
|
4811
|
TermVocabulary_id integer not null,
|
|
4812
|
rights_id integer not null,
|
|
4813
|
revtype tinyint,
|
|
4814
|
primary key (REV, TermVocabulary_id, rights_id)
|
|
4815
|
);
|
|
4816
|
|
|
4817
|
create table TypeDesignationBase (
|
|
4818
|
DTYPE varchar(31) not null,
|
|
4819
|
id integer not null,
|
|
4820
|
created timestamp,
|
|
4821
|
uuid varchar(36),
|
|
4822
|
updated timestamp,
|
|
4823
|
citationmicroreference varchar(255),
|
|
4824
|
originalnamestring varchar(255),
|
|
4825
|
notdesignated bit not null,
|
|
4826
|
conservedtype bit,
|
|
4827
|
rejectedtype bit,
|
|
4828
|
createdby_id integer,
|
|
4829
|
updatedby_id integer,
|
|
4830
|
citation_id integer,
|
|
4831
|
homotypicalgroup_id integer,
|
|
4832
|
typestatus_id integer,
|
|
4833
|
typename_id integer,
|
|
4834
|
typespecimen_id integer,
|
|
4835
|
primary key (id),
|
|
4836
|
unique (uuid)
|
|
4837
|
);
|
|
4838
|
|
|
4839
|
create table TypeDesignationBase_AUD (
|
|
4840
|
DTYPE varchar(31) not null,
|
|
4841
|
id integer not null,
|
|
4842
|
REV integer not null,
|
|
4843
|
revtype tinyint,
|
|
4844
|
created timestamp,
|
|
4845
|
uuid varchar(36),
|
|
4846
|
updated timestamp,
|
|
4847
|
citationmicroreference varchar(255),
|
|
4848
|
originalnamestring varchar(255),
|
|
4849
|
notdesignated bit,
|
|
4850
|
createdby_id integer,
|
|
4851
|
updatedby_id integer,
|
|
4852
|
citation_id integer,
|
|
4853
|
homotypicalgroup_id integer,
|
|
4854
|
typestatus_id integer,
|
|
4855
|
typespecimen_id integer,
|
|
4856
|
conservedtype bit,
|
|
4857
|
rejectedtype bit,
|
|
4858
|
typename_id integer,
|
|
4859
|
primary key (id, REV)
|
|
4860
|
);
|
|
4861
|
|
|
4862
|
create table TypeDesignationBase_Annotation (
|
|
4863
|
TypeDesignationBase_id integer not null,
|
|
4864
|
annotations_id integer not null,
|
|
4865
|
primary key (TypeDesignationBase_id, annotations_id),
|
|
4866
|
unique (annotations_id)
|
|
4867
|
);
|
|
4868
|
|
|
4869
|
create table TypeDesignationBase_Annotation_AUD (
|
|
4870
|
REV integer not null,
|
|
4871
|
TypeDesignationBase_id integer not null,
|
|
4872
|
annotations_id integer not null,
|
|
4873
|
revtype tinyint,
|
|
4874
|
primary key (REV, TypeDesignationBase_id, annotations_id)
|
|
4875
|
);
|
|
4876
|
|
|
4877
|
create table TypeDesignationBase_Marker (
|
|
4878
|
TypeDesignationBase_id integer not null,
|
|
4879
|
markers_id integer not null,
|
|
4880
|
primary key (TypeDesignationBase_id, markers_id),
|
|
4881
|
unique (markers_id)
|
|
4882
|
);
|
|
4883
|
|
|
4884
|
create table TypeDesignationBase_Marker_AUD (
|
|
4885
|
REV integer not null,
|
|
4886
|
TypeDesignationBase_id integer not null,
|
|
4887
|
markers_id integer not null,
|
|
4888
|
revtype tinyint,
|
|
4889
|
primary key (REV, TypeDesignationBase_id, markers_id)
|
|
4890
|
);
|
|
4891
|
|
|
4892
|
create table UserAccount (
|
|
4893
|
id integer not null,
|
|
4894
|
created timestamp,
|
|
4895
|
uuid varchar(36),
|
|
4896
|
accountnonexpired bit not null,
|
|
4897
|
accountnonlocked bit not null,
|
|
4898
|
credentialsnonexpired bit not null,
|
|
4899
|
emailaddress varchar(255),
|
|
4900
|
enabled bit not null,
|
|
4901
|
password varchar(255),
|
|
4902
|
username varchar(255),
|
|
4903
|
createdby_id integer,
|
|
4904
|
person_id integer,
|
|
4905
|
primary key (id),
|
|
4906
|
unique (uuid, username)
|
|
4907
|
);
|
|
4908
|
|
|
4909
|
create table UserAccount_AUD (
|
|
4910
|
id integer not null,
|
|
4911
|
REV integer not null,
|
|
4912
|
revtype tinyint,
|
|
4913
|
created timestamp,
|
|
4914
|
uuid varchar(36),
|
|
4915
|
accountnonexpired bit,
|
|
4916
|
accountnonlocked bit,
|
|
4917
|
credentialsnonexpired bit,
|
|
4918
|
emailaddress varchar(255),
|
|
4919
|
enabled bit,
|
|
4920
|
username varchar(255),
|
|
4921
|
createdby_id integer,
|
|
4922
|
person_id integer,
|
|
4923
|
primary key (id, REV)
|
|
4924
|
);
|
|
4925
|
|
|
4926
|
create table UserAccount_GrantedAuthorityImpl (
|
|
4927
|
UserAccount_id integer not null,
|
|
4928
|
grantedauthorities_id integer not null,
|
|
4929
|
primary key (UserAccount_id, grantedauthorities_id)
|
|
4930
|
);
|
|
4931
|
|
|
4932
|
create table UserAccount_PermissionGroup (
|
|
4933
|
members_id integer not null,
|
|
4934
|
groups_id integer not null,
|
|
4935
|
primary key (members_id, groups_id)
|
|
4936
|
);
|
|
4937
|
|
|
4938
|
create table WorkingSet (
|
|
4939
|
DTYPE varchar(31) not null,
|
|
4940
|
id integer not null,
|
|
4941
|
created timestamp,
|
|
4942
|
uuid varchar(36),
|
|
4943
|
updated timestamp,
|
|
4944
|
createdby_id integer,
|
|
4945
|
updatedby_id integer,
|
|
4946
|
descriptivesystem_id integer,
|
|
4947
|
primary key (id),
|
|
4948
|
unique (uuid)
|
|
4949
|
);
|
|
4950
|
|
|
4951
|
create table WorkingSet_AUD (
|
|
4952
|
DTYPE varchar(31) not null,
|
|
4953
|
id integer not null,
|
|
4954
|
REV integer not null,
|
|
4955
|
revtype tinyint,
|
|
4956
|
created timestamp,
|
|
4957
|
uuid varchar(36),
|
|
4958
|
updated timestamp,
|
|
4959
|
createdby_id integer,
|
|
4960
|
updatedby_id integer,
|
|
4961
|
descriptivesystem_id integer,
|
|
4962
|
primary key (id, REV)
|
|
4963
|
);
|
|
4964
|
|
|
4965
|
create table WorkingSet_Annotation (
|
|
4966
|
WorkingSet_id integer not null,
|
|
4967
|
annotations_id integer not null,
|
|
4968
|
primary key (WorkingSet_id, annotations_id),
|
|
4969
|
unique (annotations_id)
|
|
4970
|
);
|
|
4971
|
|
|
4972
|
create table WorkingSet_Annotation_AUD (
|
|
4973
|
REV integer not null,
|
|
4974
|
WorkingSet_id integer not null,
|
|
4975
|
annotations_id integer not null,
|
|
4976
|
revtype tinyint,
|
|
4977
|
primary key (REV, WorkingSet_id, annotations_id)
|
|
4978
|
);
|
|
4979
|
|
|
4980
|
create table WorkingSet_DescriptionBase (
|
|
4981
|
WorkingSet_id integer not null,
|
|
4982
|
descriptions_id integer not null,
|
|
4983
|
primary key (WorkingSet_id, descriptions_id)
|
|
4984
|
);
|
|
4985
|
|
|
4986
|
create table WorkingSet_DescriptionBase_AUD (
|
|
4987
|
REV integer not null,
|
|
4988
|
WorkingSet_id integer not null,
|
|
4989
|
descriptions_id integer not null,
|
|
4990
|
revtype tinyint,
|
|
4991
|
primary key (REV, WorkingSet_id, descriptions_id)
|
|
4992
|
);
|
|
4993
|
|
|
4994
|
create table WorkingSet_Marker (
|
|
4995
|
WorkingSet_id integer not null,
|
|
4996
|
markers_id integer not null,
|
|
4997
|
primary key (WorkingSet_id, markers_id),
|
|
4998
|
unique (markers_id)
|
|
4999
|
);
|
|
5000
|
|
|
5001
|
create table WorkingSet_Marker_AUD (
|
|
5002
|
REV integer not null,
|
|
5003
|
WorkingSet_id integer not null,
|
|
5004
|
markers_id integer not null,
|
|
5005
|
revtype tinyint,
|
|
5006
|
primary key (REV, WorkingSet_id, markers_id)
|
|
5007
|
);
|
|
5008
|
|
|
5009
|
create table WorkingSet_Representation (
|
|
5010
|
WorkingSet_id integer not null,
|
|
5011
|
representations_id integer not null,
|
|
5012
|
primary key (WorkingSet_id, representations_id),
|
|
5013
|
unique (representations_id)
|
|
5014
|
);
|
|
5015
|
|
|
5016
|
create table WorkingSet_Representation_AUD (
|
|
5017
|
REV integer not null,
|
|
5018
|
WorkingSet_id integer not null,
|
|
5019
|
representations_id integer not null,
|
|
5020
|
revtype tinyint,
|
|
5021
|
primary key (REV, WorkingSet_id, representations_id)
|
|
5022
|
);
|
|
5023
|
|
|
5024
|
create table WorkingSet_TaxonBase (
|
|
5025
|
WorkingSet_id integer not null,
|
|
5026
|
coveredtaxa_id integer not null,
|
|
5027
|
primary key (WorkingSet_id, coveredtaxa_id)
|
|
5028
|
);
|
|
5029
|
|
|
5030
|
create table WorkingSet_TaxonBase_AUD (
|
|
5031
|
REV integer not null,
|
|
5032
|
WorkingSet_id integer not null,
|
|
5033
|
coveredtaxa_id integer not null,
|
|
5034
|
revtype tinyint,
|
|
5035
|
primary key (REV, WorkingSet_id, coveredtaxa_id)
|
|
5036
|
);
|
|
5037
|
|
|
5038
|
alter table Address
|
|
5039
|
add constraint FK1ED033D44FF2DB2C
|
|
5040
|
foreign key (createdby_id)
|
|
5041
|
references UserAccount;
|
|
5042
|
|
|
5043
|
alter table Address
|
|
5044
|
add constraint FK1ED033D4132A2FE8
|
|
5045
|
foreign key (location_referencesystem_id)
|
|
5046
|
references DefinedTermBase;
|
|
5047
|
|
|
5048
|
alter table Address
|
|
5049
|
add constraint FK1ED033D42687715A
|
|
5050
|
foreign key (country_id)
|
|
5051
|
references DefinedTermBase;
|
|
5052
|
|
|
5053
|
alter table Address
|
|
5054
|
add constraint FK1ED033D4BC5DA539
|
|
5055
|
foreign key (updatedby_id)
|
|
5056
|
references UserAccount;
|
|
5057
|
|
|
5058
|
alter table Address_AUD
|
|
5059
|
add constraint FK115657A534869AAE
|
|
5060
|
foreign key (REV)
|
|
5061
|
references AuditEvent;
|
|
5062
|
|
|
5063
|
create index agentTitleCacheIndex on AgentBase (titleCache);
|
|
5064
|
|
|
5065
|
alter table AgentBase
|
|
5066
|
add constraint FK1205D3564FF2DB2C
|
|
5067
|
foreign key (createdby_id)
|
|
5068
|
references UserAccount;
|
|
5069
|
|
|
5070
|
alter table AgentBase
|
|
5071
|
add constraint FK1205D356A830578
|
|
5072
|
foreign key (ispartof_id)
|
|
5073
|
references AgentBase;
|
|
5074
|
|
|
5075
|
alter table AgentBase
|
|
5076
|
add constraint FK1205D356BC5DA539
|
|
5077
|
foreign key (updatedby_id)
|
|
5078
|
references UserAccount;
|
|
5079
|
|
|
5080
|
alter table AgentBase_AUD
|
|
5081
|
add constraint FK29CC662734869AAE
|
|
5082
|
foreign key (REV)
|
|
5083
|
references AuditEvent;
|
|
5084
|
|
|
5085
|
alter table AgentBase_Address
|
|
5086
|
add constraint FK1EDFF7EB86EFC5D4
|
|
5087
|
foreign key (AgentBase_id)
|
|
5088
|
references AgentBase;
|
|
5089
|
|
|
5090
|
alter table AgentBase_Address
|
|
5091
|
add constraint FK1EDFF7EB50751EC5
|
|
5092
|
foreign key (contact_addresses_id)
|
|
5093
|
references Address;
|
|
5094
|
|
|
5095
|
alter table AgentBase_Address_AUD
|
|
5096
|
add constraint FK3D28383C34869AAE
|
|
5097
|
foreign key (REV)
|
|
5098
|
references AuditEvent;
|
|
5099
|
|
|
5100
|
alter table AgentBase_AgentBase
|
|
5101
|
add constraint FK4D34EDAD1C0E9907
|
|
5102
|
foreign key (AgentBase_id)
|
|
5103
|
references AgentBase;
|
|
5104
|
|
|
5105
|
alter table AgentBase_AgentBase
|
|
5106
|
add constraint FK4D34EDADE9E535F9
|
|
5107
|
foreign key (teammembers_id)
|
|
5108
|
references AgentBase;
|
|
5109
|
|
|
5110
|
alter table AgentBase_AgentBase_AUD
|
|
5111
|
add constraint FKA8A87CFE34869AAE
|
|
5112
|
foreign key (REV)
|
|
5113
|
references AuditEvent;
|
|
5114
|
|
|
5115
|
alter table AgentBase_Annotation
|
|
5116
|
add constraint FK44D5F7D886EFC5D4
|
|
5117
|
foreign key (AgentBase_id)
|
|
5118
|
references AgentBase;
|
|
5119
|
|
|
5120
|
alter table AgentBase_Annotation
|
|
5121
|
add constraint FK44D5F7D81E403E0B
|
|
5122
|
foreign key (annotations_id)
|
|
5123
|
references Annotation;
|
|
5124
|
|
|
5125
|
alter table AgentBase_Annotation_AUD
|
|
5126
|
add constraint FK771279A934869AAE
|
|
5127
|
foreign key (REV)
|
|
5128
|
references AuditEvent;
|
|
5129
|
|
|
5130
|
alter table AgentBase_Credit
|
|
5131
|
add constraint FK2636742286EFC5D4
|
|
5132
|
foreign key (AgentBase_id)
|
|
5133
|
references AgentBase;
|
|
5134
|
|
|
5135
|
alter table AgentBase_Credit
|
|
5136
|
add constraint FK2636742232D1B9F
|
|
5137
|
foreign key (credits_id)
|
|
5138
|
references Credit;
|
|
5139
|
|
|
5140
|
alter table AgentBase_Credit_AUD
|
|
5141
|
add constraint FK7FE7C0F334869AAE
|
|
5142
|
foreign key (REV)
|
|
5143
|
references AuditEvent;
|
|
5144
|
|
|
5145
|
alter table AgentBase_DefinedTermBase
|
|
5146
|
add constraint FK6665C77D8D9AB196
|
|
5147
|
foreign key (AgentBase_id)
|
|
5148
|
references AgentBase;
|
|
5149
|
|
|
5150
|
alter table AgentBase_DefinedTermBase
|
|
5151
|
add constraint FK6665C77D9A161BED
|
|
5152
|
foreign key (types_id)
|
|
5153
|
references DefinedTermBase;
|
|
5154
|
|
|
5155
|
alter table AgentBase_DefinedTermBase_AUD
|
|
5156
|
add constraint FKA737EECE34869AAE
|
|
5157
|
foreign key (REV)
|
|
5158
|
references AuditEvent;
|
|
5159
|
|
|
5160
|
alter table AgentBase_Extension
|
|
5161
|
add constraint FK8E1E567686EFC5D4
|
|
5162
|
foreign key (AgentBase_id)
|
|
5163
|
references AgentBase;
|
|
5164
|
|
|
5165
|
alter table AgentBase_Extension
|
|
5166
|
add constraint FK8E1E5676927DE9DF
|
|
5167
|
foreign key (extensions_id)
|
|
5168
|
references Extension;
|
|
5169
|
|
|
5170
|
alter table AgentBase_Extension_AUD
|
|
5171
|
add constraint FK11AE594734869AAE
|
|
5172
|
foreign key (REV)
|
|
5173
|
references AuditEvent;
|
|
5174
|
|
|
5175
|
alter table AgentBase_Marker
|
|
5176
|
add constraint FK365D5D63777265A1
|
|
5177
|
foreign key (markers_id)
|
|
5178
|
references Marker;
|
|
5179
|
|
|
5180
|
alter table AgentBase_Marker
|
|
5181
|
add constraint FK365D5D6386EFC5D4
|
|
5182
|
foreign key (AgentBase_id)
|
|
5183
|
references AgentBase;
|
|
5184
|
|
|
5185
|
alter table AgentBase_Marker_AUD
|
|
5186
|
add constraint FKE40621B434869AAE
|
|
5187
|
foreign key (REV)
|
|
5188
|
references AuditEvent;
|
|
5189
|
|
|
5190
|
alter table AgentBase_Media
|
|
5191
|
add constraint FKE8FC5D9B86EFC5D4
|
|
5192
|
foreign key (AgentBase_id)
|
|
5193
|
references AgentBase;
|
|
5194
|
|
|
5195
|
alter table AgentBase_Media
|
|
5196
|
add constraint FKE8FC5D9BC2C29593
|
|
5197
|
foreign key (media_id)
|
|
5198
|
references Media;
|
|
5199
|
|
|
5200
|
alter table AgentBase_Media_AUD
|
|
5201
|
add constraint FK323A45EC34869AAE
|
|
5202
|
foreign key (REV)
|
|
5203
|
references AuditEvent;
|
|
5204
|
|
|
5205
|
alter table AgentBase_OriginalSourceBase
|
|
5206
|
add constraint FKB482C5E686EFC5D4
|
|
5207
|
foreign key (AgentBase_id)
|
|
5208
|
references AgentBase;
|
|
5209
|
|
|
5210
|
alter table AgentBase_OriginalSourceBase
|
|
5211
|
add constraint FKB482C5E63A6735D9
|
|
5212
|
foreign key (sources_id)
|
|
5213
|
references OriginalSourceBase;
|
|
5214
|
|
|
5215
|
alter table AgentBase_OriginalSourceBase_AUD
|
|
5216
|
add constraint FK886D90B734869AAE
|
|
5217
|
foreign key (REV)
|
|
5218
|
references AuditEvent;
|
|
5219
|
|
|
5220
|
alter table AgentBase_Rights
|
|
5221
|
add constraint FK3F514B0086EFC5D4
|
|
5222
|
foreign key (AgentBase_id)
|
|
5223
|
references AgentBase;
|
|
5224
|
|
|
5225
|
alter table AgentBase_Rights
|
|
5226
|
add constraint FK3F514B00C13F7B21
|
|
5227
|
foreign key (rights_id)
|
|
5228
|
references Rights;
|
|
5229
|
|
|
5230
|
alter table AgentBase_Rights_AUD
|
|
5231
|
add constraint FK4FDFF8D134869AAE
|
|
5232
|
foreign key (REV)
|
|
5233
|
references AuditEvent;
|
|
5234
|
|
|
5235
|
alter table AgentBase_contact_emailaddresses
|
|
5236
|
add constraint FK4BD2B08E86EFC5D4
|
|
5237
|
foreign key (AgentBase_id)
|
|
5238
|
references AgentBase;
|
|
5239
|
|
|
5240
|
alter table AgentBase_contact_emailaddresses_AUD
|
|
5241
|
add constraint FKCAF7E75F34869AAE
|
|
5242
|
foreign key (REV)
|
|
5243
|
references AuditEvent;
|
|
5244
|
|
|
5245
|
alter table AgentBase_contact_faxnumbers
|
|
5246
|
add constraint FK52E1AD9586EFC5D4
|
|
5247
|
foreign key (AgentBase_id)
|
|
5248
|
references AgentBase;
|
|
5249
|
|
|
5250
|
alter table AgentBase_contact_faxnumbers_AUD
|
|
5251
|
add constraint FK88A308E634869AAE
|
|
5252
|
foreign key (REV)
|
|
5253
|
references AuditEvent;
|
|
5254
|
|
|
5255
|
alter table AgentBase_contact_phonenumbers
|
|
5256
|
add constraint FKC171CC2486EFC5D4
|
|
5257
|
foreign key (AgentBase_id)
|
|
5258
|
references AgentBase;
|
|
5259
|
|
|
5260
|
alter table AgentBase_contact_phonenumbers_AUD
|
|
5261
|
add constraint FKDDD347F534869AAE
|
|
5262
|
foreign key (REV)
|
|
5263
|
references AuditEvent;
|
|
5264
|
|
|
5265
|
alter table AgentBase_contact_urls
|
|
5266
|
add constraint FK9A9643EC86EFC5D4
|
|
5267
|
foreign key (AgentBase_id)
|
|
5268
|
references AgentBase;
|
|
5269
|
|
|
5270
|
alter table AgentBase_contact_urls_AUD
|
|
5271
|
add constraint FK1CE69BBD34869AAE
|
|
5272
|
foreign key (REV)
|
|
5273
|
references AuditEvent;
|
|
5274
|
|
|
5275
|
alter table Annotation
|
|
5276
|
add constraint FK1A21C74F4FF2DB2C
|
|
5277
|
foreign key (createdby_id)
|
|
5278
|
references UserAccount;
|
|
5279
|
|
|
5280
|
alter table Annotation
|
|
5281
|
add constraint FK1A21C74FE7692740
|
|
5282
|
foreign key (commentator_id)
|
|
5283
|
references AgentBase;
|
|
5284
|
|
|
5285
|
alter table Annotation
|
|
5286
|
add constraint FK1A21C74FDF299D00
|
|
5287
|
foreign key (annotationtype_id)
|
|
5288
|
references DefinedTermBase;
|
|
5289
|
|
|
5290
|
alter table Annotation
|
|
5291
|
add constraint FK1A21C74FE8D36B00
|
|
5292
|
foreign key (language_id)
|
|
5293
|
references DefinedTermBase;
|
|
5294
|
|
|
5295
|
alter table Annotation
|
|
5296
|
add constraint FK1A21C74FBC5DA539
|
|
5297
|
foreign key (updatedby_id)
|
|
5298
|
references UserAccount;
|
|
5299
|
|
|
5300
|
alter table Annotation_AUD
|
|
5301
|
add constraint FK1A6BB5A034869AAE
|
|
5302
|
foreign key (REV)
|
|
5303
|
references AuditEvent;
|
|
5304
|
|
|
5305
|
alter table Annotation_Annotation
|
|
5306
|
add constraint FKC99DFE3F994CCE20
|
|
5307
|
foreign key (Annotation_id)
|
|
5308
|
references Annotation;
|
|
5309
|
|
|
5310
|
alter table Annotation_Annotation
|
|
5311
|
add constraint FKC99DFE3F1E403E0B
|
|
5312
|
foreign key (annotations_id)
|
|
5313
|
references Annotation;
|
|
5314
|
|
|
5315
|
alter table Annotation_Annotation_AUD
|
|
5316
|
add constraint FKB212F49034869AAE
|
|
5317
|
foreign key (REV)
|
|
5318
|
references AuditEvent;
|
|
5319
|
|
|
5320
|
alter table Annotation_Marker
|
|
5321
|
add constraint FKB17EAF4A777265A1
|
|
5322
|
foreign key (markers_id)
|
|
5323
|
references Marker;
|
|
5324
|
|
|
5325
|
alter table Annotation_Marker
|
|
5326
|
add constraint FKB17EAF4A994CCE20
|
|
5327
|
foreign key (Annotation_id)
|
|
5328
|
references Annotation;
|
|
5329
|
|
|
5330
|
alter table Annotation_Marker_AUD
|
|
5331
|
add constraint FK68CE281B34869AAE
|
|
5332
|
foreign key (REV)
|
|
5333
|
references AuditEvent;
|
|
5334
|
|
|
5335
|
alter table CDM_VIEW
|
|
5336
|
add constraint FKC5DE8EF84FF2DB2C
|
|
5337
|
foreign key (createdby_id)
|
|
5338
|
references UserAccount;
|
|
5339
|
|
|
5340
|
alter table CDM_VIEW
|
|
5341
|
add constraint FKC5DE8EF8765B124B
|
|
5342
|
foreign key (reference_id)
|
|
5343
|
references Reference;
|
|
5344
|
|
|
5345
|
alter table CDM_VIEW_CDM_VIEW
|
|
5346
|
add constraint FK230A885F7208BB38
|
|
5347
|
foreign key (superviews_id)
|
|
5348
|
references CDM_VIEW;
|
|
5349
|
|
|
5350
|
alter table CDM_VIEW_CDM_VIEW
|
|
5351
|
add constraint FK230A885FC00D1213
|
|
5352
|
foreign key (CDM_VIEW_id)
|
|
5353
|
references CDM_VIEW;
|
|
5354
|
|
|
5355
|
create index collectionTitleCacheIndex on Collection (titleCache);
|
|
5356
|
|
|
5357
|
alter table Collection
|
|
5358
|
add constraint FKF078ABE4FF2DB2C
|
|
5359
|
foreign key (createdby_id)
|
|
5360
|
references UserAccount;
|
|
5361
|
|
|
5362
|
alter table Collection
|
|
5363
|
add constraint FKF078ABE16B9CA77
|
|
5364
|
foreign key (institute_id)
|
|
5365
|
references AgentBase;
|
|
5366
|
|
|
5367
|
alter table Collection
|
|
5368
|
add constraint FKF078ABECEB38EFF
|
|
5369
|
foreign key (supercollection_id)
|
|
5370
|
references Collection;
|
|
5371
|
|
|
5372
|
alter table Collection
|
|
5373
|
add constraint FKF078ABEBC5DA539
|
|
5374
|
foreign key (updatedby_id)
|
|
5375
|
references UserAccount;
|
|
5376
|
|
|
5377
|
alter table Collection_AUD
|
|
5378
|
add constraint FKD6D4298F34869AAE
|
|
5379
|
foreign key (REV)
|
|
5380
|
references AuditEvent;
|
|
5381
|
|
|
5382
|
alter table Collection_Annotation
|
|
5383
|
add constraint FKEA970F70EB62BE9A
|
|
5384
|
foreign key (Collection_id)
|
|
5385
|
references Collection;
|
|
5386
|
|
|
5387
|
alter table Collection_Annotation
|
|
5388
|
add constraint FKEA970F701E403E0B
|
|
5389
|
foreign key (annotations_id)
|
|
5390
|
references Annotation;
|
|
5391
|
|
|
5392
|
alter table Collection_Annotation_AUD
|
|
5393
|
add constraint FKA0CE054134869AAE
|
|
5394
|
foreign key (REV)
|
|
5395
|
references AuditEvent;
|
|
5396
|
|
|
5397
|
alter table Collection_Credit
|
|
5398
|
add constraint FKE0A317BAEB62BE9A
|
|
5399
|
foreign key (Collection_id)
|
|
5400
|
references Collection;
|
|
5401
|
|
|
5402
|
alter table Collection_Credit
|
|
5403
|
add constraint FKE0A317BA32D1B9F
|
|
5404
|
foreign key (credits_id)
|
|
5405
|
references Credit;
|
|
5406
|
|
|
5407
|
alter table Collection_Credit_AUD
|
|
5408
|
add constraint FK25A8D88B34869AAE
|
|
5409
|
foreign key (REV)
|
|
5410
|
references AuditEvent;
|
|
5411
|
|
|
5412
|
alter table Collection_Extension
|
|
5413
|
add constraint FKF68FEBDEEB62BE9A
|
|
5414
|
foreign key (Collection_id)
|
|
5415
|
references Collection;
|
|
5416
|
|
|
5417
|
alter table Collection_Extension
|
|
5418
|
add constraint FKF68FEBDE927DE9DF
|
|
5419
|
foreign key (extensions_id)
|
|
5420
|
references Extension;
|
|
5421
|
|
|
5422
|
alter table Collection_Extension_AUD
|
|
5423
|
add constraint FK1306FAAF34869AAE
|
|
5424
|
foreign key (REV)
|
|
5425
|
references AuditEvent;
|
|
5426
|
|
|
5427
|
alter table Collection_Marker
|
|
5428
|
add constraint FKF0CA00FBEB62BE9A
|
|
5429
|
foreign key (Collection_id)
|
|
5430
|
references Collection;
|
|
5431
|
|
|
5432
|
alter table Collection_Marker
|
|
5433
|
add constraint FKF0CA00FB777265A1
|
|
5434
|
foreign key (markers_id)
|
|
5435
|
references Marker;
|
|
5436
|
|
|
5437
|
alter table Collection_Marker_AUD
|
|
5438
|
add constraint FK89C7394C34869AAE
|
|
5439
|
foreign key (REV)
|
|
5440
|
references AuditEvent;
|
|
5441
|
|
|
5442
|
alter table Collection_Media
|
|
5443
|
add constraint FK7320E703EB62BE9A
|
|
5444
|
foreign key (Collection_id)
|
|
5445
|
references Collection;
|
|
5446
|
|
|
5447
|
alter table Collection_Media
|
|
5448
|
add constraint FK7320E703C2C29593
|
|
5449
|
foreign key (media_id)
|
|
5450
|
references Media;
|
|
5451
|
|
|
5452
|
alter table Collection_Media_AUD
|
|
5453
|
add constraint FK9AABDB5434869AAE
|
|
5454
|
foreign key (REV)
|
|
5455
|
references AuditEvent;
|
|
5456
|
|
|
5457
|
alter table Collection_OriginalSourceBase
|
|
5458
|
add constraint FK37DEC57EEB62BE9A
|
|
5459
|
foreign key (Collection_id)
|
|
5460
|
references Collection;
|
|
5461
|
|
|
5462
|
alter table Collection_OriginalSourceBase
|
|
5463
|
add constraint FK37DEC57E3A6735D9
|
|
5464
|
foreign key (sources_id)
|
|
5465
|
references OriginalSourceBase;
|
|
5466
|
|
|
5467
|
alter table Collection_OriginalSourceBase_AUD
|
|
5468
|
add constraint FKF810044F34869AAE
|
|
5469
|
foreign key (REV)
|
|
5470
|
references AuditEvent;
|
|
5471
|
|
|
5472
|
alter table Collection_Rights
|
|
5473
|
add constraint FKF9BDEE98EB62BE9A
|
|
5474
|
foreign key (Collection_id)
|
|
5475
|
references Collection;
|
|
5476
|
|
|
5477
|
alter table Collection_Rights
|
|
5478
|
add constraint FKF9BDEE98C13F7B21
|
|
5479
|
foreign key (rights_id)
|
|
5480
|
references Rights;
|
|
5481
|
|
|
5482
|
alter table Collection_Rights_AUD
|
|
5483
|
add constraint FKF5A1106934869AAE
|
|
5484
|
foreign key (REV)
|
|
5485
|
references AuditEvent;
|
|
5486
|
|
|
5487
|
alter table Credit
|
|
5488
|
add constraint FK78CA97194FF2DB2C
|
|
5489
|
foreign key (createdby_id)
|
|
5490
|
references UserAccount;
|
|
5491
|
|
|
5492
|
alter table Credit
|
|
5493
|
add constraint FK78CA9719F7976FC5
|
|
5494
|
foreign key (agent_id)
|
|
5495
|
references AgentBase;
|
|
5496
|
|
|
5497
|
alter table Credit
|
|
5498
|
add constraint FK78CA9719E8D36B00
|
|
5499
|
foreign key (language_id)
|
|
5500
|
references DefinedTermBase;
|
|
5501
|
|
|
5502
|
alter table Credit
|
|
5503
|
add constraint FK78CA9719BC5DA539
|
|
5504
|
foreign key (updatedby_id)
|
|
5505
|
references UserAccount;
|
|
5506
|
|
|
5507
|
alter table Credit_AUD
|
|
5508
|
add constraint FK5533906A34869AAE
|
|
5509
|
foreign key (REV)
|
|
5510
|
references AuditEvent;
|
|
5511
|
|
|
5512
|
alter table Credit_Annotation
|
|
5513
|
add constraint FKE8DA4C354CF694E0
|
|
5514
|
foreign key (Credit_id)
|
|
5515
|
references Credit;
|
|
5516
|
|
|
5517
|
alter table Credit_Annotation
|
|
5518
|
add constraint FKE8DA4C351E403E0B
|
|
5519
|
foreign key (annotations_id)
|
|
5520
|
references Annotation;
|
|
5521
|
|
|
5522
|
alter table Credit_Annotation_AUD
|
|
5523
|
add constraint FK1DEB578634869AAE
|
|
5524
|
foreign key (REV)
|
|
5525
|
references AuditEvent;
|
|
5526
|
|
|
5527
|
alter table Credit_Marker
|
|
5528
|
add constraint FK10CC6840777265A1
|
|
5529
|
foreign key (markers_id)
|
|
5530
|
references Marker;
|
|
5531
|
|
|
5532
|
alter table Credit_Marker
|
|
5533
|
add constraint FK10CC68404CF694E0
|
|
5534
|
foreign key (Credit_id)
|
|
5535
|
references Credit;
|
|
5536
|
|
|
5537
|
alter table Credit_Marker_AUD
|
|
5538
|
add constraint FK880A761134869AAE
|
|
5539
|
foreign key (REV)
|
|
5540
|
references AuditEvent;
|
|
5541
|
|
|
5542
|
alter table DefinedTermBase
|
|
5543
|
add constraint FK2E340A664FF2DB2C
|
|
5544
|
foreign key (createdby_id)
|
|
5545
|
references UserAccount;
|
|
5546
|
|
|
5547
|
alter table DefinedTermBase
|
|
5548
|
add constraint FK2E340A66D040DBF0
|
|
5549
|
foreign key (partof_id)
|
|
5550
|
references DefinedTermBase;
|
|
5551
|
|
|
5552
|
alter table DefinedTermBase
|
|
5553
|
add constraint FK2E340A66CC0240B6
|
|
5554
|
foreign key (shape_id)
|
|
5555
|
references Media;
|
|
5556
|
|
|
5557
|
alter table DefinedTermBase
|
|
5558
|
add constraint FK2E340A6647AF954C
|
|
5559
|
foreign key (vocabulary_id)
|
|
5560
|
references TermVocabulary;
|
|
5561
|
|
|
5562
|
alter table DefinedTermBase
|
|
5563
|
add constraint FK2E340A6624AF3F70
|
|
5564
|
foreign key (level_id)
|
|
5565
|
references DefinedTermBase;
|
|
5566
|
|
|
5567
|
alter table DefinedTermBase
|
|
5568
|
add constraint FK2E340A6688206484
|
|
5569
|
foreign key (type_id)
|
|
5570
|
references DefinedTermBase;
|
|
5571
|
|
|
5572
|
alter table DefinedTermBase
|
|
5573
|
add constraint FK2E340A6636C6F6F6
|
|
5574
|
foreign key (pointapproximation_referencesystem_id)
|
|
5575
|
references DefinedTermBase;
|
|
5576
|
|
|
5577
|
alter table DefinedTermBase
|
|
5578
|
add constraint FK2E340A663B0DA0EF
|
|
5579
|
foreign key (kindof_id)
|
|
5580
|
references DefinedTermBase;
|
|
5581
|
|
|
5582
|
alter table DefinedTermBase
|
|
5583
|
add constraint FK2E340A66BC5DA539
|
|
5584
|
foreign key (updatedby_id)
|
|
5585
|
references UserAccount;
|
|
5586
|
|
|
5587
|
alter table DefinedTermBase_AUD
|
|
5588
|
add constraint FK86E8953734869AAE
|
|
5589
|
foreign key (REV)
|
|
5590
|
references AuditEvent;
|
|
5591
|
|
|
5592
|
alter table DefinedTermBase_Annotation
|
|
5593
|
add constraint FK589B6C8C0DB4934
|
|
5594
|
foreign key (DefinedTermBase_id)
|
|
5595
|
references DefinedTermBase;
|
|
5596
|
|
|
5597
|
alter table DefinedTermBase_Annotation
|
|
5598
|
add constraint FK589B6C81E403E0B
|
|
5599
|
foreign key (annotations_id)
|
|
5600
|
references Annotation;
|
|
5601
|
|
|
5602
|
alter table DefinedTermBase_Annotation_AUD
|
|
5603
|
add constraint FK28ED409934869AAE
|
|
5604
|
foreign key (REV)
|
|
5605
|
references AuditEvent;
|
|
5606
|
|
|
5607
|
alter table DefinedTermBase_Continent
|
|
5608
|
add constraint FK45F60AFB3927C853
|
|
5609
|
foreign key (continents_id)
|
|
5610
|
references DefinedTermBase;
|
|
5611
|
|
|
5612
|
alter table DefinedTermBase_Continent
|
|
5613
|
add constraint FK45F60AFBE8CE10AA
|
|
5614
|
foreign key (DefinedTermBase_id)
|
|
5615
|
references DefinedTermBase;
|
|
5616
|
|
|
5617
|
alter table DefinedTermBase_Continent_AUD
|
|
5618
|
add constraint FKF5DE434C34869AAE
|
|
5619
|
foreign key (REV)
|
|
5620
|
references AuditEvent;
|
|
5621
|
|
|
5622
|
alter table DefinedTermBase_Credit
|
|
5623
|
add constraint FK78FF2B12C0DB4934
|
|
5624
|
foreign key (DefinedTermBase_id)
|
|
5625
|
references DefinedTermBase;
|
|
5626
|
|
|
5627
|
alter table DefinedTermBase_Credit
|
|
5628
|
add constraint FK78FF2B1232D1B9F
|
|
5629
|
foreign key (credits_id)
|
|
5630
|
references Credit;
|
|
5631
|
|
|
5632
|
alter table DefinedTermBase_Credit_AUD
|
|
5633
|
add constraint FK409B7FE334869AAE
|
|
5634
|
foreign key (REV)
|
|
5635
|
references AuditEvent;
|
|
5636
|
|
|
5637
|
alter table DefinedTermBase_Extension
|
|
5638
|
add constraint FK397EF986927DE9DF
|
|
5639
|
foreign key (extensions_id)
|
|
5640
|
references Extension;
|
|
5641
|
|
|
5642
|
alter table DefinedTermBase_Extension
|
|
5643
|
add constraint FK397EF986C0DB4934
|
|
5644
|
foreign key (DefinedTermBase_id)
|
|
5645
|
references DefinedTermBase;
|
|
5646
|
|
|
5647
|
alter table DefinedTermBase_Extension_AUD
|
|
5648
|
add constraint FK6E6F45734869AAE
|
|
5649
|
foreign key (REV)
|
|
5650
|
references AuditEvent;
|
|
5651
|
|
|
5652
|
alter table DefinedTermBase_Marker
|
|
5653
|
add constraint FK89261453777265A1
|
|
5654
|
foreign key (markers_id)
|
|
5655
|
references Marker;
|
|
5656
|
|
|
5657
|
alter table DefinedTermBase_Marker
|
|
5658
|
add constraint FK89261453C0DB4934
|
|
5659
|
foreign key (DefinedTermBase_id)
|
|
5660
|
references DefinedTermBase;
|
|
5661
|
|
|
5662
|
alter table DefinedTermBase_Marker_AUD
|
|
5663
|
add constraint FKA4B9E0A434869AAE
|
|
5664
|
foreign key (REV)
|
|
5665
|
references AuditEvent;
|
|
5666
|
|
|
5667
|
alter table DefinedTermBase_MeasurementUnit
|
|
5668
|
add constraint FKE9D17767D0BDAE9B
|
|
5669
|
foreign key (DefinedTermBase_id)
|
|
5670
|
references DefinedTermBase;
|
|
5671
|
|
|
5672
|
alter table DefinedTermBase_MeasurementUnit
|
|
5673
|
add constraint FKE9D17767F3BB39BD
|
|
5674
|
foreign key (recommendedmeasurementunits_id)
|
|
5675
|
references DefinedTermBase;
|
|
5676
|
|
|
5677
|
alter table DefinedTermBase_MeasurementUnit_AUD
|
|
5678
|
add constraint FK2C1599B834869AAE
|
|
5679
|
foreign key (REV)
|
|
5680
|
references AuditEvent;
|
|
5681
|
|
|
5682
|
alter table DefinedTermBase_Media
|
|
5683
|
add constraint FK6FC908ABC0DB4934
|
|
5684
|
foreign key (DefinedTermBase_id)
|
|
5685
|
references DefinedTermBase;
|
|
5686
|
|
|
5687
|
alter table DefinedTermBase_Media
|
|
5688
|
add constraint FK6FC908ABC2C29593
|
|
5689
|
foreign key (media_id)
|
|
5690
|
references Media;
|
|
5691
|
|
|
5692
|
alter table DefinedTermBase_Media_AUD
|
|
5693
|
add constraint FKDD9AE8FC34869AAE
|
|
5694
|
foreign key (REV)
|
|
5695
|
references AuditEvent;
|
|
5696
|
|
|
5697
|
alter table DefinedTermBase_OriginalSourceBase
|
|
5698
|
add constraint FKDCC094D6C0DB4934
|
|
5699
|
foreign key (DefinedTermBase_id)
|
|
5700
|
references DefinedTermBase;
|
|
5701
|
|
|
5702
|
alter table DefinedTermBase_OriginalSourceBase
|
|
5703
|
add constraint FKDCC094D63A6735D9
|
|
5704
|
foreign key (sources_id)
|
|
5705
|
references OriginalSourceBase;
|
|
5706
|
|
|
5707
|
alter table DefinedTermBase_OriginalSourceBase_AUD
|
|
5708
|
add constraint FKAE4A67A734869AAE
|
|
5709
|
foreign key (REV)
|
|
5710
|
references AuditEvent;
|
|
5711
|
|
|
5712
|
alter table DefinedTermBase_RecommendedModifierEnumeration
|
|
5713
|
add constraint FKA72FB5AED0BDAE9B
|
|
5714
|
foreign key (DefinedTermBase_id)
|
|
5715
|
references DefinedTermBase;
|
|
5716
|
|
|
5717
|
alter table DefinedTermBase_RecommendedModifierEnumeration
|
|
5718
|
add constraint FKA72FB5AE5255EAFD
|
|
5719
|
foreign key (recommendedmodifierenumeration_id)
|
|
5720
|
references TermVocabulary;
|
|
5721
|
|
|
5722
|
alter table DefinedTermBase_RecommendedModifierEnumeration_AUD
|
|
5723
|
add constraint FK780D5C7F34869AAE
|
|
5724
|
foreign key (REV)
|
|
5725
|
references AuditEvent;
|
|
5726
|
|
|
5727
|
alter table DefinedTermBase_Representation
|
|
5728
|
add constraint FKAAC8AFE6B31C4747
|
|
5729
|
foreign key (representations_id)
|
|
5730
|
references Representation;
|
|
5731
|
|
|
5732
|
alter table DefinedTermBase_Representation
|
|
5733
|
add constraint FKAAC8AFE6C0DB4934
|
|
5734
|
foreign key (DefinedTermBase_id)
|
|
5735
|
references DefinedTermBase;
|
|
5736
|
|
|
5737
|
alter table DefinedTermBase_Representation_AUD
|
|
5738
|
add constraint FKB5AE7AB734869AAE
|
|
5739
|
foreign key (REV)
|
|
5740
|
references AuditEvent;
|
|
5741
|
|
|
5742
|
alter table DefinedTermBase_Rights
|
|
5743
|
add constraint FK921A01F0C0DB4934
|
|
5744
|
foreign key (DefinedTermBase_id)
|
|
5745
|
references DefinedTermBase;
|
|
5746
|
|
|
5747
|
alter table DefinedTermBase_Rights
|
|
5748
|
add constraint FK921A01F0C13F7B21
|
|
5749
|
foreign key (rights_id)
|
|
5750
|
references Rights;
|
|
5751
|
|
|
5752
|
alter table DefinedTermBase_Rights_AUD
|
|
5753
|
add constraint FK1093B7C134869AAE
|
|
5754
|
foreign key (REV)
|
|
5755
|
references AuditEvent;
|
|
5756
|
|
|
5757
|
alter table DefinedTermBase_StatisticalMeasure
|
|
5758
|
add constraint FK6FF15DFCD0BDAE9B
|
|
5759
|
foreign key (DefinedTermBase_id)
|
|
5760
|
references DefinedTermBase;
|
|
5761
|