Revision 85ae680a
Added by Andreas Müller over 12 years ago
cdmlib-ext/src/test/resources/dbscripts/001_cdm.ddl | ||
---|---|---|
1 |
|
|
2 |
create table Address ( |
|
1 |
create table Address ( |
|
3 | 2 |
id integer not null, |
4 | 3 |
created timestamp, |
5 |
uuid varchar(255),
|
|
4 |
uuid varchar(36),
|
|
6 | 5 |
updated timestamp, |
7 | 6 |
locality varchar(255), |
8 | 7 |
location_errorradius integer, |
... | ... | |
16 | 15 |
updatedby_id integer, |
17 | 16 |
country_id integer, |
18 | 17 |
location_referencesystem_id integer, |
19 |
primary key (id) |
|
18 |
primary key (id), |
|
19 |
unique (uuid) |
|
20 | 20 |
); |
21 | 21 |
|
22 | 22 |
create table Address_AUD ( |
... | ... | |
24 | 24 |
REV integer not null, |
25 | 25 |
revtype tinyint, |
26 | 26 |
created timestamp, |
27 |
uuid varchar(255),
|
|
27 |
uuid varchar(36),
|
|
28 | 28 |
updated timestamp, |
29 | 29 |
locality varchar(255), |
30 | 30 |
location_errorradius integer, |
... | ... | |
45 | 45 |
DTYPE varchar(31) not null, |
46 | 46 |
id integer not null, |
47 | 47 |
created timestamp, |
48 |
uuid varchar(255),
|
|
48 |
uuid varchar(36),
|
|
49 | 49 |
updated timestamp, |
50 | 50 |
lsid_authority varchar(255), |
51 | 51 |
lsid_lsid varchar(255), |
... | ... | |
60 | 60 |
firstname varchar(255), |
61 | 61 |
lastname varchar(255), |
62 | 62 |
lifespan_end varchar(255), |
63 |
lifespan_freetext varchar(255), |
|
63 | 64 |
lifespan_start varchar(255), |
64 |
lifespan_freetext varchar(30), |
|
65 | 65 |
prefix varchar(255), |
66 | 66 |
suffix varchar(255), |
67 | 67 |
protectednomenclaturaltitlecache bit, |
68 | 68 |
createdby_id integer, |
69 | 69 |
updatedby_id integer, |
70 | 70 |
ispartof_id integer, |
71 |
primary key (id) |
|
71 |
primary key (id), |
|
72 |
unique (uuid) |
|
72 | 73 |
); |
73 | 74 |
|
74 | 75 |
create table AgentBase_AUD ( |
... | ... | |
77 | 78 |
REV integer not null, |
78 | 79 |
revtype tinyint, |
79 | 80 |
created timestamp, |
80 |
uuid varchar(255),
|
|
81 |
uuid varchar(36),
|
|
81 | 82 |
updated timestamp, |
82 | 83 |
lsid_authority varchar(255), |
83 | 84 |
lsid_lsid varchar(255), |
... | ... | |
92 | 93 |
name varchar(255), |
93 | 94 |
ispartof_id integer, |
94 | 95 |
nomenclaturaltitle varchar(255), |
95 |
protectednomenclaturaltitlecache bit, |
|
96 | 96 |
firstname varchar(255), |
97 | 97 |
lastname varchar(255), |
98 | 98 |
lifespan_end varchar(255), |
99 |
lifespan_freetext varchar(255), |
|
99 | 100 |
lifespan_start varchar(255), |
100 |
lifespan_freetext varchar(30), |
|
101 | 101 |
prefix varchar(255), |
102 | 102 |
suffix varchar(255), |
103 |
protectednomenclaturaltitlecache bit, |
|
103 | 104 |
primary key (id, REV) |
104 | 105 |
); |
105 | 106 |
|
... | ... | |
309 | 310 |
create table Annotation ( |
310 | 311 |
id integer not null, |
311 | 312 |
created timestamp, |
312 |
uuid varchar(255),
|
|
313 |
uuid varchar(36),
|
|
313 | 314 |
updated timestamp, |
314 | 315 |
text longvarchar, |
315 | 316 |
annotatedObj_type varchar(255), |
... | ... | |
320 | 321 |
language_id integer, |
321 | 322 |
annotationtype_id integer, |
322 | 323 |
commentator_id integer, |
323 |
primary key (id) |
|
324 |
primary key (id), |
|
325 |
unique (uuid) |
|
324 | 326 |
); |
325 | 327 |
|
326 | 328 |
create table Annotation_AUD ( |
... | ... | |
328 | 330 |
REV integer not null, |
329 | 331 |
revtype tinyint, |
330 | 332 |
created timestamp, |
331 |
uuid varchar(255),
|
|
333 |
uuid varchar(36),
|
|
332 | 334 |
updated timestamp, |
333 | 335 |
text longvarchar, |
334 | 336 |
linkbackurl varbinary(255), |
... | ... | |
381 | 383 |
create table CDM_VIEW ( |
382 | 384 |
id integer not null, |
383 | 385 |
created timestamp, |
384 |
uuid varchar(255),
|
|
386 |
uuid varchar(36),
|
|
385 | 387 |
description varchar(255), |
386 | 388 |
name varchar(255), |
387 | 389 |
createdby_id integer, |
388 | 390 |
reference_id integer, |
389 |
primary key (id) |
|
391 |
primary key (id), |
|
392 |
unique (uuid) |
|
390 | 393 |
); |
391 | 394 |
|
392 | 395 |
create table CDM_VIEW_CDM_VIEW ( |
... | ... | |
396 | 399 |
unique (superviews_id) |
397 | 400 |
); |
398 | 401 |
|
399 |
create table Classification ( |
|
402 |
|
|
403 |
create table Classification ( |
|
400 | 404 |
id integer not null, |
401 | 405 |
created timestamp, |
402 |
uuid varchar(255),
|
|
406 |
uuid varchar(36),
|
|
403 | 407 |
updated timestamp, |
404 | 408 |
lsid_authority varchar(255), |
405 | 409 |
lsid_lsid varchar(255), |
... | ... | |
413 | 417 |
updatedby_id integer, |
414 | 418 |
name_id integer, |
415 | 419 |
reference_id integer, |
416 |
primary key (id) |
|
420 |
primary key (id), |
|
421 |
unique (uuid) |
|
417 | 422 |
); |
418 | 423 |
|
419 | 424 |
create table Classification_AUD ( |
... | ... | |
421 | 426 |
REV integer not null, |
422 | 427 |
revtype tinyint, |
423 | 428 |
created timestamp, |
424 |
uuid varchar(255),
|
|
429 |
uuid varchar(36),
|
|
425 | 430 |
updated timestamp, |
426 | 431 |
lsid_authority varchar(255), |
427 | 432 |
lsid_lsid varchar(255), |
... | ... | |
545 | 550 |
primary key (REV, Classification_id, rootnodes_id) |
546 | 551 |
); |
547 | 552 |
|
553 |
|
|
548 | 554 |
create table Collection ( |
549 | 555 |
id integer not null, |
550 | 556 |
created timestamp, |
551 |
uuid varchar(255),
|
|
557 |
uuid varchar(36),
|
|
552 | 558 |
updated timestamp, |
553 | 559 |
lsid_authority varchar(255), |
554 | 560 |
lsid_lsid varchar(255), |
... | ... | |
565 | 571 |
updatedby_id integer, |
566 | 572 |
institute_id integer, |
567 | 573 |
supercollection_id integer, |
568 |
primary key (id) |
|
574 |
primary key (id), |
|
575 |
unique (uuid) |
|
569 | 576 |
); |
570 | 577 |
|
571 | 578 |
create table Collection_AUD ( |
... | ... | |
573 | 580 |
REV integer not null, |
574 | 581 |
revtype tinyint, |
575 | 582 |
created timestamp, |
576 |
uuid varchar(255),
|
|
583 |
uuid varchar(36),
|
|
577 | 584 |
updated timestamp, |
578 | 585 |
lsid_authority varchar(255), |
579 | 586 |
lsid_lsid varchar(255), |
... | ... | |
702 | 709 |
create table Credit ( |
703 | 710 |
id integer not null, |
704 | 711 |
created timestamp, |
705 |
uuid varchar(255),
|
|
712 |
uuid varchar(36),
|
|
706 | 713 |
updated timestamp, |
707 | 714 |
text longvarchar, |
708 | 715 |
abbreviatedtext varchar(255), |
... | ... | |
710 | 717 |
updatedby_id integer, |
711 | 718 |
language_id integer, |
712 | 719 |
agent_id integer, |
713 |
primary key (id) |
|
720 |
primary key (id), |
|
721 |
unique (uuid) |
|
714 | 722 |
); |
715 | 723 |
|
716 | 724 |
create table Credit_AUD ( |
... | ... | |
718 | 726 |
REV integer not null, |
719 | 727 |
revtype tinyint, |
720 | 728 |
created timestamp, |
721 |
uuid varchar(255),
|
|
729 |
uuid varchar(36),
|
|
722 | 730 |
updated timestamp, |
723 | 731 |
text longvarchar, |
724 | 732 |
abbreviatedtext varchar(255), |
... | ... | |
763 | 771 |
DTYPE varchar(31) not null, |
764 | 772 |
id integer not null, |
765 | 773 |
created timestamp, |
766 |
protectedtitlecache bit not null, |
|
767 |
titleCache varchar(255), |
|
768 |
uuid varchar(255), |
|
774 |
uuid varchar(36), |
|
769 | 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), |
|
770 | 783 |
uri varchar(255), |
771 |
orderindex integer, |
|
772 | 784 |
iso639_1 varchar(2), |
773 | 785 |
iso639_2 varchar(3), |
786 |
istechnical bit, |
|
787 |
orderindex integer, |
|
774 | 788 |
symmetrical bit, |
775 | 789 |
transitive bit, |
776 | 790 |
defaultcolor varchar(255), |
... | ... | |
785 | 799 |
pointapproximation_latitude double, |
786 | 800 |
pointapproximation_longitude double, |
787 | 801 |
validperiod_end varchar(255), |
802 |
validperiod_freetext varchar(255), |
|
788 | 803 |
validperiod_start varchar(255), |
789 |
validperiod_freetext varchar(30), |
|
790 | 804 |
iso3166_a2 varchar(2), |
791 |
isTechnical bit, |
|
792 |
createdby_id integer, |
|
805 |
createdby_id integer, |
|
793 | 806 |
updatedby_id integer, |
794 | 807 |
kindof_id integer, |
795 | 808 |
partof_id integer, |
... | ... | |
798 | 811 |
pointapproximation_referencesystem_id integer, |
799 | 812 |
shape_id integer, |
800 | 813 |
type_id integer, |
801 |
lsid_authority varchar(255), |
|
802 |
lsid_lsid varchar(255), |
|
803 |
lsid_namespace varchar(255), |
|
804 |
lsid_object varchar(255), |
|
805 |
lsid_revision varchar(255), |
|
806 |
primary key (id) |
|
814 |
primary key (id), |
|
815 |
unique (uuid) |
|
807 | 816 |
); |
808 | 817 |
|
809 | 818 |
create table DefinedTermBase_AUD ( |
... | ... | |
812 | 821 |
REV integer not null, |
813 | 822 |
revtype tinyint, |
814 | 823 |
created timestamp, |
815 |
protectedtitlecache bit not null, |
|
816 |
titleCache varchar(255), |
|
817 |
uuid varchar(255), |
|
824 |
uuid varchar(36), |
|
818 | 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), |
|
819 | 833 |
uri varchar(255), |
820 | 834 |
createdby_id integer, |
821 | 835 |
updatedby_id integer, |
822 | 836 |
kindof_id integer, |
823 | 837 |
partof_id integer, |
824 | 838 |
vocabulary_id integer, |
839 |
istechnical bit, |
|
825 | 840 |
orderindex integer, |
826 | 841 |
iso639_1 varchar(2), |
827 | 842 |
iso639_2 varchar(3), |
828 |
supportscategoricaldata bit, |
|
829 |
supportscommontaxonname bit, |
|
830 |
supportsdistribution bit, |
|
831 |
supportsindividualassociation bit, |
|
832 |
supportsquantitativedata bit, |
|
833 |
supportstaxoninteraction bit, |
|
834 |
supportstextdata bit, |
|
835 |
defaultcolor varchar(255), |
|
843 |
symmetrical bit, |
|
844 |
transitive bit, |
|
836 | 845 |
pointapproximation_errorradius integer, |
837 | 846 |
pointapproximation_latitude double, |
838 | 847 |
pointapproximation_longitude double, |
839 | 848 |
validperiod_end varchar(255), |
849 |
validperiod_freetext varchar(255), |
|
840 | 850 |
validperiod_start varchar(255), |
841 |
validperiod_freetext varchar(30), |
|
842 | 851 |
level_id integer, |
843 | 852 |
pointapproximation_referencesystem_id integer, |
844 | 853 |
shape_id integer, |
845 | 854 |
type_id integer, |
846 | 855 |
iso3166_a2 varchar(2), |
847 |
isTechnical bit,
|
|
848 |
symmetrical bit,
|
|
849 |
transitive bit,
|
|
850 |
lsid_authority varchar(255),
|
|
851 |
lsid_lsid varchar(255),
|
|
852 |
lsid_namespace varchar(255),
|
|
853 |
lsid_object varchar(255),
|
|
854 |
lsid_revision varchar(255),
|
|
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,
|
|
855 | 864 |
primary key (id, REV) |
856 | 865 |
); |
857 | 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 |
|
|
858 | 882 |
create table DefinedTermBase_Continent ( |
859 | 883 |
DefinedTermBase_id integer not null, |
860 | 884 |
continents_id integer not null, |
... | ... | |
869 | 893 |
primary key (REV, DefinedTermBase_id, continents_id) |
870 | 894 |
); |
871 | 895 |
|
872 |
create table DefinedTermBase_Annotation(
|
|
896 |
create table DefinedTermBase_Credit (
|
|
873 | 897 |
DefinedTermBase_id integer not null, |
874 |
annotations_id integer not null, |
|
875 |
primary key (DefinedTermBase_id, annotations_id) |
|
898 |
credits_id integer not null, |
|
899 |
sortIndex integer not null, |
|
900 |
primary key (DefinedTermBase_id, sortIndex), |
|
901 |
unique (credits_id) |
|
876 | 902 |
); |
877 | 903 |
|
878 |
create table DefinedTermBase_Annotation_AUD (
|
|
904 |
create table DefinedTermBase_Credit_AUD (
|
|
879 | 905 |
REV integer not null, |
880 | 906 |
DefinedTermBase_id integer not null, |
881 |
annotations_id integer not null, |
|
907 |
credits_id integer not null, |
|
908 |
sortIndex integer not null, |
|
882 | 909 |
revtype tinyint, |
883 |
primary key (REV, DefinedTermBase_id, annotations_id)
|
|
910 |
primary key (REV, DefinedTermBase_id, credits_id, sortIndex)
|
|
884 | 911 |
); |
885 | 912 |
|
886 | 913 |
create table DefinedTermBase_Extension ( |
887 | 914 |
DefinedTermBase_id integer not null, |
888 | 915 |
extensions_id integer not null, |
889 |
primary key (DefinedTermBase_id, extensions_id) |
|
916 |
primary key (DefinedTermBase_id, extensions_id), |
|
917 |
unique (extensions_id) |
|
890 | 918 |
); |
891 | 919 |
|
892 | 920 |
create table DefinedTermBase_Extension_AUD ( |
... | ... | |
897 | 925 |
primary key (REV, DefinedTermBase_id, extensions_id) |
898 | 926 |
); |
899 | 927 |
|
900 |
create table DefinedTermBase_Marker(
|
|
928 |
create table DefinedTermBase_Marker (
|
|
901 | 929 |
DefinedTermBase_id integer not null, |
902 | 930 |
markers_id integer not null, |
903 |
primary key (DefinedTermBase_id, markers_id) |
|
931 |
primary key (DefinedTermBase_id, markers_id), |
|
932 |
unique (markers_id) |
|
904 | 933 |
); |
905 | 934 |
|
906 | 935 |
create table DefinedTermBase_Marker_AUD ( |
... | ... | |
940 | 969 |
primary key (REV, DefinedTermBase_id, media_id) |
941 | 970 |
); |
942 | 971 |
|
943 |
create table DefinedTermBase_OriginalSourceBase(
|
|
944 |
DefinedTermBase_id integer not null,
|
|
972 |
create table DefinedTermBase_OriginalSourceBase (
|
|
973 |
DefinedTermBase_id integer not null,
|
|
945 | 974 |
sources_id integer not null, |
946 | 975 |
primary key (DefinedTermBase_id, sources_id), |
947 | 976 |
unique (sources_id) |
... | ... | |
988 | 1017 |
create table DefinedTermBase_Rights ( |
989 | 1018 |
DefinedTermBase_id integer not null, |
990 | 1019 |
rights_id integer not null, |
991 |
primary key (DefinedTermBase_id, rights_id) |
|
1020 |
primary key (DefinedTermBase_id, rights_id), |
|
1021 |
unique (rights_id) |
|
992 | 1022 |
); |
993 | 1023 |
|
994 | 1024 |
create table DefinedTermBase_Rights_AUD ( |
... | ... | |
1045 | 1075 |
create table DerivationEvent ( |
1046 | 1076 |
id integer not null, |
1047 | 1077 |
created timestamp, |
1048 |
uuid varchar(255),
|
|
1078 |
uuid varchar(36),
|
|
1049 | 1079 |
updated timestamp, |
1050 | 1080 |
description varchar(255), |
1051 | 1081 |
timeperiod_end varchar(255), |
1082 |
timeperiod_freetext varchar(255), |
|
1052 | 1083 |
timeperiod_start varchar(255), |
1053 |
timeperiod_freetext varchar(30), |
|
1054 | 1084 |
createdby_id integer, |
1055 | 1085 |
updatedby_id integer, |
1056 | 1086 |
actor_id integer, |
1057 | 1087 |
type_id integer, |
1058 |
primary key (id) |
|
1088 |
primary key (id), |
|
1089 |
unique (uuid) |
|
1059 | 1090 |
); |
1060 | 1091 |
|
1061 | 1092 |
create table DerivationEvent_AUD ( |
... | ... | |
1063 | 1094 |
REV integer not null, |
1064 | 1095 |
revtype tinyint, |
1065 | 1096 |
created timestamp, |
1066 |
uuid varchar(255),
|
|
1097 |
uuid varchar(36),
|
|
1067 | 1098 |
updated timestamp, |
1068 | 1099 |
description varchar(255), |
1069 | 1100 |
timeperiod_end varchar(255), |
1101 |
timeperiod_freetext varchar(255), |
|
1070 | 1102 |
timeperiod_start varchar(255), |
1071 |
timeperiod_freetext varchar(30), |
|
1072 | 1103 |
createdby_id integer, |
1073 | 1104 |
updatedby_id integer, |
1074 | 1105 |
actor_id integer, |
... | ... | |
1110 | 1141 |
DTYPE varchar(31) not null, |
1111 | 1142 |
id integer not null, |
1112 | 1143 |
created timestamp, |
1113 |
uuid varchar(255),
|
|
1144 |
uuid varchar(36),
|
|
1114 | 1145 |
updated timestamp, |
1115 | 1146 |
lsid_authority varchar(255), |
1116 | 1147 |
lsid_lsid varchar(255), |
... | ... | |
1123 | 1154 |
createdby_id integer, |
1124 | 1155 |
updatedby_id integer, |
1125 | 1156 |
taxon_id integer, |
1126 |
taxonName_id integer, |
|
1127 |
primary key (id) |
|
1157 |
taxonname_id integer, |
|
1158 |
primary key (id), |
|
1159 |
unique (uuid) |
|
1128 | 1160 |
); |
1129 | 1161 |
|
1130 | 1162 |
create table DescriptionBase_AUD ( |
... | ... | |
1133 | 1165 |
REV integer not null, |
1134 | 1166 |
revtype tinyint, |
1135 | 1167 |
created timestamp, |
1136 |
uuid varchar(255),
|
|
1168 |
uuid varchar(36),
|
|
1137 | 1169 |
updated timestamp, |
1138 | 1170 |
lsid_authority varchar(255), |
1139 | 1171 |
lsid_lsid varchar(255), |
... | ... | |
1146 | 1178 |
createdby_id integer, |
1147 | 1179 |
updatedby_id integer, |
1148 | 1180 |
taxon_id integer, |
1149 |
taxonName_id integer,
|
|
1181 |
taxonname_id integer,
|
|
1150 | 1182 |
primary key (id, REV) |
1151 | 1183 |
); |
1152 | 1184 |
|
... | ... | |
1316 | 1348 |
DTYPE varchar(31) not null, |
1317 | 1349 |
id integer not null, |
1318 | 1350 |
created timestamp, |
1319 |
uuid varchar(255),
|
|
1351 |
uuid varchar(36),
|
|
1320 | 1352 |
updated timestamp, |
1321 |
citationmicroreference varchar(255), |
|
1322 |
originalnamestring varchar(255), |
|
1323 | 1353 |
orderrelevant bit, |
1324 | 1354 |
name varchar(255), |
1325 | 1355 |
createdby_id integer, |
1326 | 1356 |
updatedby_id integer, |
1327 |
citation_id integer, |
|
1328 | 1357 |
feature_id integer, |
1329 | 1358 |
indescription_id integer, |
1330 |
nameusedinreference_id integer, |
|
1331 | 1359 |
language_id integer, |
1332 | 1360 |
area_id integer, |
1333 | 1361 |
status_id integer, |
... | ... | |
1335 | 1363 |
unit_id integer, |
1336 | 1364 |
taxon2_id integer, |
1337 | 1365 |
format_id integer, |
1338 |
primary key (id) |
|
1366 |
primary key (id), |
|
1367 |
unique (uuid) |
|
1339 | 1368 |
); |
1340 | 1369 |
|
1341 | 1370 |
create table DescriptionElementBase_AUD ( |
... | ... | |
1344 | 1373 |
REV integer not null, |
1345 | 1374 |
revtype tinyint, |
1346 | 1375 |
created timestamp, |
1347 |
uuid varchar(255),
|
|
1376 |
uuid varchar(36),
|
|
1348 | 1377 |
updated timestamp, |
1349 |
citationmicroreference varchar(255), |
|
1350 |
originalnamestring varchar(255), |
|
1351 | 1378 |
createdby_id integer, |
1352 | 1379 |
updatedby_id integer, |
1353 |
citation_id integer, |
|
1354 | 1380 |
feature_id integer, |
1355 | 1381 |
indescription_id integer, |
1356 |
nameusedinreference_id integer, |
|
1357 |
format_id integer, |
|
1358 |
taxon2_id integer, |
|
1359 |
unit_id integer, |
|
1360 |
associatedspecimenorobservation_id integer, |
|
1361 | 1382 |
orderrelevant bit, |
1383 |
associatedspecimenorobservation_id integer, |
|
1362 | 1384 |
name varchar(255), |
1363 | 1385 |
language_id integer, |
1386 |
taxon2_id integer, |
|
1364 | 1387 |
area_id integer, |
1365 | 1388 |
status_id integer, |
1389 |
unit_id integer, |
|
1390 |
format_id integer, |
|
1366 | 1391 |
primary key (id, REV) |
1367 | 1392 |
); |
1368 | 1393 |
|
... | ... | |
1417 | 1442 |
DescriptionElementBase_id integer not null, |
1418 | 1443 |
media_id integer not null, |
1419 | 1444 |
sortIndex integer not null, |
1420 |
primary key (DescriptionElementBase_id, media_id)
|
|
1445 |
primary key (DescriptionElementBase_id, sortIndex)
|
|
1421 | 1446 |
); |
1422 | 1447 |
|
1423 | 1448 |
create table DescriptionElementBase_Media_AUD ( |
... | ... | |
1426 | 1451 |
media_id integer not null, |
1427 | 1452 |
sortIndex integer not null, |
1428 | 1453 |
revtype tinyint, |
1429 |
primary key (REV, DescriptionElementBase_id, media_id) |
|
1454 |
primary key (REV, DescriptionElementBase_id, media_id, sortIndex)
|
|
1430 | 1455 |
); |
1431 | 1456 |
|
1432 | 1457 |
create table DescriptionElementBase_Modifier ( |
... | ... | |
1506 | 1531 |
create table DeterminationEvent ( |
1507 | 1532 |
id integer not null, |
1508 | 1533 |
created timestamp, |
1509 |
uuid varchar(255),
|
|
1534 |
uuid varchar(36),
|
|
1510 | 1535 |
updated timestamp, |
1511 | 1536 |
description varchar(255), |
1512 | 1537 |
timeperiod_end varchar(255), |
1538 |
timeperiod_freetext varchar(255), |
|
1513 | 1539 |
timeperiod_start varchar(255), |
1514 |
timeperiod_freetext varchar(30), |
|
1515 | 1540 |
preferredflag bit not null, |
1516 | 1541 |
createdby_id integer, |
1517 | 1542 |
updatedby_id integer, |
... | ... | |
1519 | 1544 |
identifiedunit_id integer, |
1520 | 1545 |
modifier_id integer, |
1521 | 1546 |
taxon_id integer, |
1522 |
primary key (id) |
|
1547 |
primary key (id), |
|
1548 |
unique (uuid) |
|
1523 | 1549 |
); |
1524 | 1550 |
|
1525 | 1551 |
create table DeterminationEvent_AUD ( |
... | ... | |
1527 | 1553 |
REV integer not null, |
1528 | 1554 |
revtype tinyint, |
1529 | 1555 |
created timestamp, |
1530 |
uuid varchar(255),
|
|
1556 |
uuid varchar(36),
|
|
1531 | 1557 |
updated timestamp, |
1532 | 1558 |
description varchar(255), |
1533 | 1559 |
timeperiod_end varchar(255), |
1560 |
timeperiod_freetext varchar(255), |
|
1534 | 1561 |
timeperiod_start varchar(255), |
1535 |
timeperiod_freetext varchar(30), |
|
1536 | 1562 |
preferredflag bit, |
1537 | 1563 |
createdby_id integer, |
1538 | 1564 |
updatedby_id integer, |
... | ... | |
1590 | 1616 |
create table Extension ( |
1591 | 1617 |
id integer not null, |
1592 | 1618 |
created timestamp, |
1593 |
uuid varchar(255),
|
|
1619 |
uuid varchar(36),
|
|
1594 | 1620 |
updated timestamp, |
1595 | 1621 |
extendedObj_type varchar(255), |
1596 | 1622 |
extendedObj_id integer not null, |
1597 |
value varchar(255),
|
|
1623 |
value longvarchar,
|
|
1598 | 1624 |
createdby_id integer, |
1599 | 1625 |
updatedby_id integer, |
1600 | 1626 |
type_id integer, |
1601 |
primary key (id) |
|
1627 |
primary key (id), |
|
1628 |
unique (uuid) |
|
1602 | 1629 |
); |
1603 | 1630 |
|
1604 | 1631 |
create table Extension_AUD ( |
... | ... | |
1606 | 1633 |
REV integer not null, |
1607 | 1634 |
revtype tinyint, |
1608 | 1635 |
created timestamp, |
1609 |
uuid varchar(255),
|
|
1636 |
uuid varchar(36),
|
|
1610 | 1637 |
updated timestamp, |
1611 |
value varchar(255),
|
|
1638 |
value longvarchar,
|
|
1612 | 1639 |
createdby_id integer, |
1613 | 1640 |
updatedby_id integer, |
1614 | 1641 |
type_id integer, |
... | ... | |
1618 | 1645 |
create table FeatureNode ( |
1619 | 1646 |
id integer not null, |
1620 | 1647 |
created timestamp, |
1621 |
uuid varchar(255),
|
|
1648 |
uuid varchar(36),
|
|
1622 | 1649 |
updated timestamp, |
1623 | 1650 |
createdby_id integer, |
1624 | 1651 |
updatedby_id integer, |
1625 | 1652 |
featureTree_id integer not null, |
1626 | 1653 |
feature_id integer, |
1627 | 1654 |
parent_id integer, |
1628 |
primary key (id) |
|
1655 |
primary key (id), |
|
1656 |
unique (uuid) |
|
1629 | 1657 |
); |
1630 | 1658 |
|
1631 | 1659 |
create table FeatureNode_AUD ( |
... | ... | |
1633 | 1661 |
REV integer not null, |
1634 | 1662 |
revtype tinyint, |
1635 | 1663 |
created timestamp, |
1636 |
uuid varchar(255),
|
|
1664 |
uuid varchar(36),
|
|
1637 | 1665 |
updated timestamp, |
1638 | 1666 |
createdby_id integer, |
1639 | 1667 |
updatedby_id integer, |
1640 |
featureTree_id integer not null,
|
|
1668 |
featureTree_id integer not null,
|
|
1641 | 1669 |
feature_id integer, |
1642 | 1670 |
parent_id integer, |
1643 | 1671 |
primary key (id, REV) |
1644 | 1672 |
); |
1645 | 1673 |
|
1646 |
create table FeatureNode_DefinedTermBase_OnlyApplicable (
|
|
1674 |
create table FeatureNode_DefinedTermBase_InapplicableIf (
|
|
1647 | 1675 |
FeatureNode_id integer not null, |
1648 |
OnlyApplicable_id integer not null,
|
|
1649 |
primary key (FeatureNode_id, OnlyApplicable_id)
|
|
1676 |
inapplicableif_id integer not null,
|
|
1677 |
primary key (FeatureNode_id, inapplicableif_id)
|
|
1650 | 1678 |
); |
1651 | 1679 |
|
1652 |
create table FeatureNode_DefinedTermBase_OnlyApplicable_AUD (
|
|
1680 |
create table FeatureNode_DefinedTermBase_InapplicableIf_AUD (
|
|
1653 | 1681 |
REV integer not null, |
1654 | 1682 |
FeatureNode_id integer not null, |
1655 |
OnlyApplicable_id integer not null,
|
|
1683 |
inapplicableif_id integer not null,
|
|
1656 | 1684 |
revtype tinyint, |
1657 |
primary key (REV, FeatureNode_id, OnlyApplicable_id)
|
|
1685 |
primary key (REV, FeatureNode_id, inapplicableif_id)
|
|
1658 | 1686 |
); |
1659 | 1687 |
|
1660 |
create table FeatureNode_DefinedTermBase_InapplicableIf (
|
|
1688 |
create table FeatureNode_DefinedTermBase_OnlyApplicable (
|
|
1661 | 1689 |
FeatureNode_id integer not null, |
1662 |
InapplicableIf_id integer not null,
|
|
1663 |
primary key (FeatureNode_id, InapplicableIf_id)
|
|
1690 |
onlyapplicableif_id integer not null,
|
|
1691 |
primary key (FeatureNode_id, onlyapplicableif_id)
|
|
1664 | 1692 |
); |
1665 | 1693 |
|
1666 |
create table FeatureNode_DefinedTermBase_InapplicableIf_AUD (
|
|
1694 |
create table FeatureNode_DefinedTermBase_OnlyApplicable_AUD (
|
|
1667 | 1695 |
REV integer not null, |
1668 | 1696 |
FeatureNode_id integer not null, |
1669 |
InapplicableIf_id integer not null,
|
|
1697 |
onlyapplicableif_id integer not null,
|
|
1670 | 1698 |
revtype tinyint, |
1671 |
primary key (REV, FeatureNode_id, InapplicableIf_id)
|
|
1699 |
primary key (REV, FeatureNode_id, onlyapplicableif_id)
|
|
1672 | 1700 |
); |
1673 | 1701 |
|
1674 | 1702 |
create table FeatureTree ( |
1675 | 1703 |
id integer not null, |
1676 | 1704 |
created timestamp, |
1677 |
uuid varchar(255),
|
|
1705 |
uuid varchar(36),
|
|
1678 | 1706 |
updated timestamp, |
1707 |
lsid_authority varchar(255), |
|
1708 |
lsid_lsid varchar(255), |
|
1709 |
lsid_namespace varchar(255), |
|
1710 |
lsid_object varchar(255), |
|
1711 |
lsid_revision varchar(255), |
|
1712 |
protectedtitlecache bit not null, |
|
1713 |
titleCache varchar(255), |
|
1679 | 1714 |
uri varchar(255), |
1680 | 1715 |
descriptionseparated bit not null, |
1681 | 1716 |
createdby_id integer, |
1682 | 1717 |
updatedby_id integer, |
1683 | 1718 |
root_id integer, |
1684 |
primary key (id) |
|
1719 |
primary key (id), |
|
1720 |
unique (uuid) |
|
1685 | 1721 |
); |
1686 | 1722 |
|
1687 | 1723 |
create table FeatureTree_AUD ( |
1724 |
DTYPE varchar(31) not null, |
|
1688 | 1725 |
id integer not null, |
1689 | 1726 |
REV integer not null, |
1690 | 1727 |
revtype tinyint, |
1691 | 1728 |
created timestamp, |
1692 |
uuid varchar(255),
|
|
1729 |
uuid varchar(36),
|
|
1693 | 1730 |
updated timestamp, |
1731 |
lsid_authority varchar(255), |
|
1732 |
lsid_lsid varchar(255), |
|
1733 |
lsid_namespace varchar(255), |
|
1734 |
lsid_object varchar(255), |
|
1735 |
lsid_revision varchar(255), |
|
1736 |
protectedtitlecache bit, |
|
1737 |
titleCache varchar(255), |
|
1694 | 1738 |
uri varchar(255), |
1695 | 1739 |
descriptionseparated bit, |
1696 | 1740 |
createdby_id integer, |
... | ... | |
1699 | 1743 |
primary key (id, REV) |
1700 | 1744 |
); |
1701 | 1745 |
|
1702 |
create table FeatureTree_Representation (
|
|
1746 |
create table FeatureTree_Annotation (
|
|
1703 | 1747 |
FeatureTree_id integer not null, |
1704 |
representations_id integer not null,
|
|
1705 |
primary key (FeatureTree_id, representations_id),
|
|
1706 |
unique (representations_id)
|
|
1748 |
annotations_id integer not null,
|
|
1749 |
primary key (FeatureTree_id, annotations_id),
|
|
1750 |
unique (annotations_id)
|
|
1707 | 1751 |
); |
1708 | 1752 |
|
1709 |
create table FeatureTree_Representation_AUD (
|
|
1753 |
create table FeatureTree_Annotation_AUD (
|
|
1710 | 1754 |
REV integer not null, |
1711 | 1755 |
FeatureTree_id integer not null, |
1712 |
representations_id integer not null,
|
|
1756 |
annotations_id integer not null,
|
|
1713 | 1757 |
revtype tinyint, |
1714 |
primary key (REV, FeatureTree_id, representations_id)
|
|
1758 |
primary key (REV, FeatureTree_id, annotations_id)
|
|
1715 | 1759 |
); |
1716 | 1760 |
|
1717 |
create table GatheringEvent ( |
|
1718 |
id integer not null, |
|
1719 |
created timestamp, |
|
1720 |
uuid varchar(255), |
|
1721 |
updated timestamp, |
|
1722 |
description varchar(255), |
|
1723 |
timeperiod_end varchar(255), |
|
1724 |
timeperiod_start varchar(255), |
|
1725 |
timeperiod_freetext varchar(30), |
|
1726 |
absoluteelevation integer, |
|
1727 |
absoluteelevationerror integer, |
|
1728 |
collectingmethod varchar(255), |
|
1729 |
distancetoground integer, |
|
1730 |
distancetowatersurface integer, |
|
1731 |
exactlocation_errorradius integer, |
|
1732 |
exactlocation_latitude double, |
|
1733 |
exactlocation_longitude double, |
|
1734 |
createdby_id integer, |
|
1735 |
updatedby_id integer, |
|
1736 |
country_id integer, |
|
1737 |
actor_id integer, |
|
1738 |
exactlocation_referencesystem_id integer, |
|
1739 |
locality_id integer, |
|
1740 |
primary key (id) |
|
1761 |
create table FeatureTree_Credit ( |
|
1762 |
FeatureTree_id integer not null, |
|
1763 |
credits_id integer not null, |
|
1764 |
sortIndex integer not null, |
|
1765 |
primary key (FeatureTree_id, sortIndex), |
|
1766 |
unique (credits_id) |
|
1741 | 1767 |
); |
1742 | 1768 |
|
1743 |
create table GatheringEvent_AUD ( |
|
1744 |
id integer not null, |
|
1769 |
create table FeatureTree_Credit_AUD ( |
|
1745 | 1770 |
REV integer not null, |
1771 |
FeatureTree_id integer not null, |
|
1772 |
credits_id integer not null, |
|
1773 |
sortIndex integer not null, |
|
1746 | 1774 |
revtype tinyint, |
1747 |
created timestamp, |
|
1748 |
uuid varchar(255), |
|
1749 |
updated timestamp, |
|
1750 |
description varchar(255), |
|
1751 |
timeperiod_end varchar(255), |
|
1752 |
timeperiod_start varchar(255), |
|
1753 |
timeperiod_freetext varchar(30), |
|
1754 |
absoluteelevation integer, |
|
1755 |
absoluteelevationerror integer, |
|
1756 |
collectingmethod varchar(255), |
|
1757 |
distancetoground integer, |
|
1758 |
distancetowatersurface integer, |
|
1759 |
exactlocation_errorradius integer, |
|
1775 |
primary key (REV, FeatureTree_id, credits_id, sortIndex) |
|
1776 |
); |
|
1777 |
|
|
1778 |
create table FeatureTree_Extension ( |
|
1779 |
FeatureTree_id integer not null, |
|
1780 |
extensions_id integer not null, |
|
1781 |
primary key (FeatureTree_id, extensions_id), |
|
1782 |
unique (extensions_id) |
|
1783 |
); |
|
1784 |
|
|
1785 |
create table FeatureTree_Extension_AUD ( |
|
1786 |
REV integer not null, |
|
1787 |
FeatureTree_id integer not null, |
|
1788 |
extensions_id integer not null, |
|
1789 |
revtype tinyint, |
|
1790 |
primary key (REV, FeatureTree_id, extensions_id) |
|
1791 |
); |
|
1792 |
|
|
1793 |
create table FeatureTree_Marker ( |
|
1794 |
FeatureTree_id integer not null, |
|
1795 |
markers_id integer not null, |
|
1796 |
primary key (FeatureTree_id, markers_id), |
|
1797 |
unique (markers_id) |
|
1798 |
); |
|
1799 |
|
|
1800 |
create table FeatureTree_Marker_AUD ( |
|
1801 |
REV integer not null, |
|
1802 |
FeatureTree_id integer not null, |
|
1803 |
markers_id integer not null, |
|
1804 |
revtype tinyint, |
|
1805 |
primary key (REV, FeatureTree_id, markers_id) |
|
1806 |
); |
|
1807 |
|
|
1808 |
create table FeatureTree_OriginalSourceBase ( |
|
1809 |
FeatureTree_id integer not null, |
|
1810 |
sources_id integer not null, |
|
1811 |
primary key (FeatureTree_id, sources_id), |
|
1812 |
unique (sources_id) |
|
1813 |
); |
|
1814 |
|
|
1815 |
create table FeatureTree_OriginalSourceBase_AUD ( |
|
1816 |
REV integer not null, |
|
1817 |
FeatureTree_id integer not null, |
|
1818 |
sources_id integer not null, |
|
1819 |
revtype tinyint, |
|
1820 |
primary key (REV, FeatureTree_id, sources_id) |
|
1821 |
); |
|
1822 |
|
|
1823 |
create table FeatureTree_Representation ( |
|
1824 |
FeatureTree_id integer not null, |
|
1825 |
representations_id integer not null, |
|
1826 |
primary key (FeatureTree_id, representations_id), |
|
1827 |
unique (representations_id) |
|
1828 |
); |
|
1829 |
|
|
1830 |
create table FeatureTree_Representation_AUD ( |
|
1831 |
REV integer not null, |
|
1832 |
FeatureTree_id integer not null, |
|
1833 |
representations_id integer not null, |
|
1834 |
revtype tinyint, |
|
1835 |
primary key (REV, FeatureTree_id, representations_id) |
|
1836 |
); |
|
1837 |
|
|
1838 |
create table FeatureTree_Rights ( |
|
1839 |
FeatureTree_id integer not null, |
|
1840 |
rights_id integer not null, |
|
1841 |
primary key (FeatureTree_id, rights_id), |
|
1842 |
unique (rights_id) |
|
1843 |
); |
|
1844 |
|
|
1845 |
create table FeatureTree_Rights_AUD ( |
|
1846 |
REV integer not null, |
|
1847 |
FeatureTree_id integer not null, |
|
1848 |
rights_id integer not null, |
|
1849 |
revtype tinyint, |
|
1850 |
primary key (REV, FeatureTree_id, rights_id) |
|
1851 |
); |
|
1852 |
|
|
1853 |
create table FeatureTree_TaxonBase ( |
|
1854 |
FeatureTree_id integer not null, |
|
1855 |
coveredtaxa_id integer not null, |
|
1856 |
primary key (FeatureTree_id, coveredtaxa_id) |
|
1857 |
); |
|
1858 |
|
|
1859 |
create table FeatureTree_TaxonBase_AUD ( |
|
1860 |
REV integer not null, |
|
1861 |
FeatureTree_id integer not null, |
|
1862 |
coveredtaxa_id integer not null, |
|
1863 |
revtype tinyint, |
|
1864 |
primary key (REV, FeatureTree_id, coveredtaxa_id) |
|
1865 |
); |
|
1866 |
|
|
1867 |
create table GatheringEvent ( |
|
1868 |
id integer not null, |
|
1869 |
created timestamp, |
|
1870 |
uuid varchar(36), |
|
1871 |
updated timestamp, |
|
1872 |
description varchar(255), |
|
1873 |
timeperiod_end varchar(255), |
|
1874 |
timeperiod_freetext varchar(255), |
|
1875 |
timeperiod_start varchar(255), |
|
1876 |
absoluteelevation integer, |
|
1877 |
absoluteelevationerror integer, |
|
1878 |
collectingmethod varchar(255), |
|
1879 |
distancetoground integer, |
|
1880 |
distancetowatersurface integer, |
|
1881 |
exactlocation_errorradius integer, |
|
1882 |
exactlocation_latitude double, |
|
1883 |
exactlocation_longitude double, |
|
1884 |
createdby_id integer, |
|
1885 |
updatedby_id integer, |
|
1886 |
country_id integer, |
|
1887 |
actor_id integer, |
|
1888 |
exactlocation_referencesystem_id integer, |
|
1889 |
locality_id integer, |
|
1890 |
primary key (id), |
|
1891 |
unique (uuid) |
|
1892 |
); |
|
1893 |
|
|
1894 |
create table GatheringEvent_AUD ( |
|
1895 |
id integer not null, |
|
1896 |
REV integer not null, |
|
1897 |
revtype tinyint, |
|
1898 |
created timestamp, |
|
1899 |
uuid varchar(36), |
|
1900 |
updated timestamp, |
|
1901 |
description varchar(255), |
|
1902 |
timeperiod_end varchar(255), |
|
1903 |
timeperiod_freetext varchar(255), |
|
1904 |
timeperiod_start varchar(255), |
|
1905 |
absoluteelevation integer, |
|
1906 |
absoluteelevationerror integer, |
|
1907 |
collectingmethod varchar(255), |
|
1908 |
distancetoground integer, |
|
1909 |
distancetowatersurface integer, |
|
1910 |
exactlocation_errorradius integer, |
|
1760 | 1911 |
exactlocation_latitude double, |
1761 | 1912 |
exactlocation_longitude double, |
1762 | 1913 |
createdby_id integer, |
... | ... | |
1815 | 1966 |
create table GenBankAccession ( |
1816 | 1967 |
id integer not null, |
1817 | 1968 |
created timestamp, |
1818 |
uuid varchar(255),
|
|
1969 |
uuid varchar(36),
|
|
1819 | 1970 |
updated timestamp, |
1820 | 1971 |
accessionnumber varchar(255), |
1821 | 1972 |
uri varchar(255), |
1822 | 1973 |
createdby_id integer, |
1823 | 1974 |
updatedby_id integer, |
1824 |
primary key (id) |
|
1975 |
primary key (id), |
|
1976 |
unique (uuid) |
|
1825 | 1977 |
); |
1826 | 1978 |
|
1827 | 1979 |
create table GenBankAccession_AUD ( |
... | ... | |
1829 | 1981 |
REV integer not null, |
1830 | 1982 |
revtype tinyint, |
1831 | 1983 |
created timestamp, |
1832 |
uuid varchar(255),
|
|
1984 |
uuid varchar(36),
|
|
1833 | 1985 |
updated timestamp, |
1834 | 1986 |
accessionnumber varchar(255), |
1835 | 1987 |
uri varchar(255), |
... | ... | |
1841 | 1993 |
create table GrantedAuthorityImpl ( |
1842 | 1994 |
id integer not null, |
1843 | 1995 |
created timestamp, |
1844 |
uuid varchar(255),
|
|
1996 |
uuid varchar(36),
|
|
1845 | 1997 |
authority varchar(255), |
1846 | 1998 |
createdby_id integer, |
1847 | 1999 |
primary key (id), |
1848 |
unique (authority) |
|
2000 |
unique (uuid, authority)
|
|
1849 | 2001 |
); |
1850 | 2002 |
|
1851 | 2003 |
create table hibernate_sequences ( |
... | ... | |
1857 | 2009 |
create table HomotypicalGroup ( |
1858 | 2010 |
id integer not null, |
1859 | 2011 |
created timestamp, |
1860 |
uuid varchar(255),
|
|
2012 |
uuid varchar(36),
|
|
1861 | 2013 |
updated timestamp, |
1862 | 2014 |
createdby_id integer, |
1863 | 2015 |
updatedby_id integer, |
1864 |
primary key (id) |
|
2016 |
primary key (id), |
|
2017 |
unique (uuid) |
|
1865 | 2018 |
); |
1866 | 2019 |
|
1867 | 2020 |
create table HomotypicalGroup_AUD ( |
... | ... | |
1869 | 2022 |
REV integer not null, |
1870 | 2023 |
revtype tinyint, |
1871 | 2024 |
created timestamp, |
1872 |
uuid varchar(255),
|
|
2025 |
uuid varchar(36),
|
|
1873 | 2026 |
updated timestamp, |
1874 | 2027 |
createdby_id integer, |
1875 | 2028 |
updatedby_id integer, |
... | ... | |
1909 | 2062 |
create table HybridRelationship ( |
1910 | 2063 |
id integer not null, |
1911 | 2064 |
created timestamp, |
1912 |
uuid varchar(255),
|
|
2065 |
uuid varchar(36),
|
|
1913 | 2066 |
updated timestamp, |
1914 | 2067 |
citationmicroreference varchar(255), |
1915 | 2068 |
originalnamestring varchar(255), |
... | ... | |
1921 | 2074 |
relatedfrom_id integer, |
1922 | 2075 |
relatedto_id integer, |
1923 | 2076 |
type_id integer, |
1924 |
primary key (id) |
|
2077 |
primary key (id), |
|
2078 |
unique (uuid) |
|
1925 | 2079 |
); |
1926 | 2080 |
|
1927 | 2081 |
create table HybridRelationship_AUD ( |
... | ... | |
1929 | 2083 |
REV integer not null, |
1930 | 2084 |
revtype tinyint, |
1931 | 2085 |
created timestamp, |
1932 |
uuid varchar(255),
|
|
2086 |
uuid varchar(36),
|
|
1933 | 2087 |
updated timestamp, |
1934 | 2088 |
citationmicroreference varchar(255), |
1935 | 2089 |
originalnamestring varchar(255), |
... | ... | |
1994 | 2148 |
create table InstitutionalMembership ( |
1995 | 2149 |
id integer not null, |
1996 | 2150 |
created timestamp, |
1997 |
uuid varchar(255),
|
|
2151 |
uuid varchar(36),
|
|
1998 | 2152 |
updated timestamp, |
1999 | 2153 |
department varchar(255), |
2000 | 2154 |
period_end varchar(255), |
2155 |
period_freetext varchar(255), |
|
2001 | 2156 |
period_start varchar(255), |
2002 |
period_freetext varchar(30), |
|
2003 | 2157 |
role varchar(255), |
2004 | 2158 |
createdby_id integer, |
2005 | 2159 |
updatedby_id integer, |
2006 | 2160 |
institute_id integer, |
2007 | 2161 |
person_id integer, |
2008 |
primary key (id) |
|
2162 |
primary key (id), |
|
2163 |
unique (uuid) |
|
2009 | 2164 |
); |
2010 | 2165 |
|
2011 | 2166 |
create table InstitutionalMembership_AUD ( |
... | ... | |
2013 | 2168 |
REV integer not null, |
2014 | 2169 |
revtype tinyint, |
2015 | 2170 |
created timestamp, |
2016 |
uuid varchar(255),
|
|
2171 |
uuid varchar(36),
|
|
2017 | 2172 |
updated timestamp, |
2018 | 2173 |
department varchar(255), |
2019 | 2174 |
period_end varchar(255), |
2175 |
period_freetext varchar(255), |
|
2020 | 2176 |
period_start varchar(255), |
2021 |
period_freetext varchar(30), |
|
2022 | 2177 |
role varchar(255), |
2023 | 2178 |
createdby_id integer, |
2024 | 2179 |
updatedby_id integer, |
... | ... | |
2026 | 2181 |
person_id integer, |
2027 | 2182 |
primary key (id, REV) |
2028 | 2183 |
); |
2029 |
|
|
2030 |
|
|
2184 |
|
|
2031 | 2185 |
create table KeyStatement ( |
2032 | 2186 |
id integer not null, |
2033 | 2187 |
created timestamp, |
... | ... | |
2068 | 2222 |
primary key (REV, keyStatement_id, label_id, label_mapkey_id) |
2069 | 2223 |
); |
2070 | 2224 |
|
2071 |
|
|
2072 | 2225 |
create table LSIDAuthority ( |
2073 | 2226 |
id integer not null, |
2074 | 2227 |
created timestamp, |
2075 |
uuid varchar(255),
|
|
2228 |
uuid varchar(36),
|
|
2076 | 2229 |
authority varchar(255), |
2077 | 2230 |
authoritywsdl longvarchar, |
2078 | 2231 |
port integer not null, |
... | ... | |
2080 | 2233 |
url varchar(255), |
2081 | 2234 |
createdby_id integer, |
2082 | 2235 |
primary key (id), |
2083 |
unique (authority) |
|
2236 |
unique (uuid, authority)
|
|
2084 | 2237 |
); |
2085 | 2238 |
|
2086 | 2239 |
create table LSIDAuthority_namespaces ( |
... | ... | |
2093 | 2246 |
create table LanguageString ( |
2094 | 2247 |
id integer not null, |
2095 | 2248 |
created timestamp, |
2096 |
uuid varchar(255),
|
|
2249 |
uuid varchar(36),
|
|
2097 | 2250 |
updated timestamp, |
2098 | 2251 |
text longvarchar, |
2099 | 2252 |
createdby_id integer, |
2100 | 2253 |
updatedby_id integer, |
2101 | 2254 |
language_id integer, |
2102 |
primary key (id) |
|
2255 |
primary key (id), |
|
2256 |
unique (uuid) |
|
2103 | 2257 |
); |
2104 | 2258 |
|
2105 | 2259 |
create table LanguageString_AUD ( |
... | ... | |
2107 | 2261 |
REV integer not null, |
2108 | 2262 |
revtype tinyint, |
2109 | 2263 |
created timestamp, |
2110 |
uuid varchar(255),
|
|
2264 |
uuid varchar(36),
|
|
2111 | 2265 |
updated timestamp, |
2112 | 2266 |
text longvarchar, |
2113 | 2267 |
createdby_id integer, |
... | ... | |
2149 | 2303 |
create table Locus ( |
2150 | 2304 |
id integer not null, |
2151 | 2305 |
created timestamp, |
2152 |
uuid varchar(255),
|
|
2306 |
uuid varchar(36),
|
|
2153 | 2307 |
updated timestamp, |
2154 | 2308 |
description varchar(255), |
2155 | 2309 |
name varchar(255), |
2156 | 2310 |
createdby_id integer, |
2157 | 2311 |
updatedby_id integer, |
2158 |
primary key (id) |
|
2312 |
primary key (id), |
|
2313 |
unique (uuid) |
|
2159 | 2314 |
); |
2160 | 2315 |
|
2161 | 2316 |
create table Locus_AUD ( |
... | ... | |
2163 | 2318 |
REV integer not null, |
2164 | 2319 |
revtype tinyint, |
2165 | 2320 |
created timestamp, |
2166 |
uuid varchar(255),
|
|
2321 |
uuid varchar(36),
|
|
2167 | 2322 |
updated timestamp, |
2168 | 2323 |
description varchar(255), |
2169 | 2324 |
name varchar(255), |
... | ... | |
2175 | 2330 |
create table Marker ( |
2176 | 2331 |
id integer not null, |
2177 | 2332 |
created timestamp, |
2178 |
uuid varchar(255),
|
|
2333 |
uuid varchar(36),
|
|
2179 | 2334 |
updated timestamp, |
2180 | 2335 |
flag bit not null, |
2181 | 2336 |
markedObj_type varchar(255), |
... | ... | |
2183 | 2338 |
createdby_id integer, |
2184 | 2339 |
updatedby_id integer, |
2185 | 2340 |
markertype_id integer, |
2186 |
primary key (id) |
|
2341 |
primary key (id), |
|
2342 |
unique (uuid) |
|
2187 | 2343 |
); |
2188 | 2344 |
|
2189 | 2345 |
create table Marker_AUD ( |
... | ... | |
2191 | 2347 |
REV integer not null, |
2192 | 2348 |
revtype tinyint, |
2193 | 2349 |
created timestamp, |
2194 |
uuid varchar(255),
|
|
2350 |
uuid varchar(36),
|
|
2195 | 2351 |
updated timestamp, |
2196 | 2352 |
flag bit, |
2197 |
createdby_id integer,
|
|
2353 |
createdby_id integer,
|
|
2198 | 2354 |
updatedby_id integer, |
2199 | 2355 |
markertype_id integer, |
2200 | 2356 |
primary key (id, REV) |
... | ... | |
2204 | 2360 |
DTYPE varchar(31) not null, |
2205 | 2361 |
id integer not null, |
2206 | 2362 |
created timestamp, |
2207 |
uuid varchar(255),
|
|
2363 |
uuid varchar(36),
|
|
2208 | 2364 |
updated timestamp, |
2209 |
mediacreated date, |
|
2210 |
citationmicroreference varchar(255), |
|
2211 |
createdby_id integer, |
|
2212 |
updatedby_id integer, |
|
2213 |
artist_id integer, |
|
2214 |
citation_id integer, |
|
2215 |
lsid_authority varchar(255), |
|
2365 |
lsid_authority varchar(255), |
|
2216 | 2366 |
lsid_lsid varchar(255), |
2217 | 2367 |
lsid_namespace varchar(255), |
2218 | 2368 |
lsid_object varchar(255), |
2219 | 2369 |
lsid_revision varchar(255), |
2220 | 2370 |
protectedtitlecache bit not null, |
2221 | 2371 |
titleCache varchar(255), |
2222 |
primary key (id) |
|
2223 |
); |
|
2224 |
|
|
2225 |
create table Media_AUD ( |
|
2226 |
DTYPE varchar(31) not null, |
|
2227 |
REV integer not null, |
|
2228 |
revtype tinyint, |
|
2229 |
id integer not null, |
|
2230 |
created timestamp, |
|
2231 |
uuid varchar(36), |
|
2232 |
updated timestamp, |
|
2233 | 2372 |
mediacreated timestamp, |
2234 | 2373 |
citationmicroreference varchar(255), |
2235 | 2374 |
createdby_id integer, |
2236 | 2375 |
updatedby_id integer, |
2237 | 2376 |
artist_id integer, |
2238 | 2377 |
citation_id integer, |
2239 |
lsid_authority varchar(255), |
|
2240 |
lsid_lsid varchar(255), |
|
2241 |
lsid_namespace varchar(255), |
|
2242 |
lsid_object varchar(255), |
|
2243 |
lsid_revision varchar(255), |
|
2244 |
protectedtitlecache bit not null, |
|
2245 |
titleCache varchar(255), |
|
2246 | 2378 |
primary key (id), |
2247 | 2379 |
unique (uuid) |
2248 | 2380 |
); |
2249 | 2381 |
|
2250 |
create table MediaKey_CoveredTaxon ( |
|
2251 |
mediaKey_id integer not null, |
|
2252 |
coveredTaxon_id integer not null, |
|
2253 |
primary key (mediaKey_id, coveredTaxon_id) |
|
2254 |
); |
|
2255 |
|
|
2256 |
create table MediaKey_CoveredTaxon_AUD ( |
|
2257 |
REV integer not null, |
|
2258 |
mediaKey_id integer not null, |
|
2259 |
coveredTaxon_id integer not null, |
|
2260 |
revtype tinyint, |
|
2261 |
primary key (REV, mediaKey_id, coveredTaxon_id) |
|
2262 |
); |
|
2263 |
|
|
2264 | 2382 |
create table MediaKey_NamedArea ( |
2265 |
media_id integer not null,
|
|
2266 |
geographicalScope_id integer not null,
|
|
2267 |
primary key (media_id, geographicalScope_id)
|
|
2383 |
Media_id integer not null,
|
|
2384 |
geographicalscope_id integer not null,
|
|
2385 |
primary key (Media_id, geographicalscope_id)
|
|
2268 | 2386 |
); |
2269 | 2387 |
|
2270 | 2388 |
create table MediaKey_NamedArea_AUD ( |
2271 | 2389 |
REV integer not null, |
2272 |
media_id integer not null,
|
|
2273 |
geographicalScope_id integer not null,
|
|
2390 |
Media_id integer not null,
|
|
2391 |
geographicalscope_id integer not null,
|
|
2274 | 2392 |
revtype tinyint, |
2275 |
primary key (REV, media_id, geographicalScope_id)
|
|
2393 |
primary key (REV, Media_id, geographicalscope_id)
|
|
2276 | 2394 |
); |
2277 | 2395 |
|
2278 |
create table MediaKey_Scope (
|
|
2279 |
MediaKey_id integer not null,
|
|
2280 |
scopes_id integer not null, |
|
2281 |
primary key (MediaKey_id, scopes_id)
|
|
2396 |
create table MediaKey_Scope (
|
|
2397 |
Media_id integer not null, |
|
2398 |
scoperestrictions_id integer not null,
|
|
2399 |
primary key (Media_id, scoperestrictions_id)
|
|
2282 | 2400 |
); |
2283 | 2401 |
|
2284 | 2402 |
create table MediaKey_Scope_AUD ( |
2285 | 2403 |
REV integer not null, |
2286 |
MediaKey_id integer not null,
|
|
2287 |
scopes_id integer not null, |
|
2404 |
Media_id integer not null, |
|
2405 |
scoperestrictions_id integer not null,
|
|
2288 | 2406 |
revtype tinyint, |
2289 |
primary key (REV, MediaKey_id, scopes_id)
|
|
2407 |
primary key (REV, Media_id, scoperestrictions_id)
|
|
2290 | 2408 |
); |
2291 | 2409 |
|
2292 | 2410 |
create table MediaKey_Taxon ( |
... | ... | |
2306 | 2424 |
create table MediaRepresentation ( |
2307 | 2425 |
id integer not null, |
2308 | 2426 |
created timestamp, |
2309 |
uuid varchar(255),
|
|
2427 |
uuid varchar(36),
|
|
2310 | 2428 |
updated timestamp, |
2311 | 2429 |
mimetype varchar(255), |
2312 | 2430 |
suffix varchar(255), |
2313 | 2431 |
createdby_id integer, |
2314 | 2432 |
updatedby_id integer, |
2315 | 2433 |
media_id integer, |
2316 |
primary key (id) |
|
2434 |
primary key (id), |
|
2435 |
unique (uuid) |
|
2317 | 2436 |
); |
2318 | 2437 |
|
2319 | 2438 |
create table MediaRepresentationPart ( |
2320 | 2439 |
DTYPE varchar(31) not null, |
2321 | 2440 |
id integer not null, |
2322 | 2441 |
created timestamp, |
2323 |
uuid varchar(255),
|
|
2442 |
uuid varchar(36),
|
|
2324 | 2443 |
updated timestamp, |
2325 | 2444 |
size integer, |
2326 | 2445 |
uri varchar(255), |
... | ... | |
2331 | 2450 |
updatedby_id integer, |
2332 | 2451 |
representation_id integer not null, |
2333 | 2452 |
sortIndex integer, |
2334 |
primary key (id) |
|
2453 |
primary key (id), |
|
2454 |
unique (uuid) |
|
2335 | 2455 |
); |
2336 | 2456 |
|
2337 | 2457 |
create table MediaRepresentationPart_AUD ( |
... | ... | |
2340 | 2460 |
REV integer not null, |
2341 | 2461 |
revtype tinyint, |
2342 | 2462 |
created timestamp, |
2343 |
uuid varchar(255),
|
|
2463 |
uuid varchar(36),
|
|
2344 | 2464 |
updated timestamp, |
2345 | 2465 |
size integer, |
2346 | 2466 |
uri varchar(255), |
... | ... | |
2358 | 2478 |
REV integer not null, |
2359 | 2479 |
revtype tinyint, |
2360 | 2480 |
created timestamp, |
2361 |
uuid varchar(255),
|
|
2481 |
uuid varchar(36),
|
|
2362 | 2482 |
updated timestamp, |
2363 | 2483 |
mimetype varchar(255), |
2364 | 2484 |
suffix varchar(255), |
... | ... | |
2377 | 2497 |
primary key (REV, representation_id, id, sortIndex) |
2378 | 2498 |
); |
2379 | 2499 |
|
2500 |
create table Media_AUD ( |
|
2501 |
DTYPE varchar(31) not null, |
|
2502 |
id integer not null, |
|
2503 |
REV integer not null, |
|
2504 |
revtype tinyint, |
|
2505 |
created timestamp, |
|
2506 |
uuid varchar(36), |
|
2507 |
updated timestamp, |
|
2508 |
lsid_authority varchar(255), |
|
2509 |
lsid_lsid varchar(255), |
|
2510 |
lsid_namespace varchar(255), |
|
2511 |
lsid_object varchar(255), |
|
2512 |
lsid_revision varchar(255), |
|
2513 |
protectedtitlecache bit, |
|
2514 |
titleCache varchar(255), |
|
2515 |
mediacreated timestamp, |
|
2516 |
createdby_id integer, |
|
2517 |
updatedby_id integer, |
|
2518 |
artist_id integer, |
|
2519 |
citationmicroreference varchar(255), |
|
2520 |
citation_id integer, |
|
2521 |
primary key (id, REV) |
|
2522 |
); |
|
2523 |
|
|
2380 | 2524 |
create table Media_Annotation ( |
2381 | 2525 |
Media_id integer not null, |
2382 | 2526 |
annotations_id integer not null, |
... | ... | |
2392 | 2536 |
primary key (REV, Media_id, annotations_id) |
2393 | 2537 |
); |
2394 | 2538 |
|
2395 |
create table Media_DefinedTermBase (
|
|
2539 |
create table Media_Credit (
|
|
2396 | 2540 |
Media_id integer not null, |
2397 |
geoscopes_id integer not null, |
|
2398 |
primary key (Media_id, geoscopes_id) |
|
2541 |
credits_id integer not null, |
|
2542 |
sortIndex integer not null, |
|
2543 |
primary key (Media_id, sortIndex), |
|
2544 |
unique (credits_id) |
|
2399 | 2545 |
); |
2400 | 2546 |
|
2401 |
create table Media_DefinedTermBase_AUD (
|
|
2547 |
create table Media_Credit_AUD (
|
|
2402 | 2548 |
REV integer not null, |
2403 | 2549 |
Media_id integer not null, |
2404 |
geoscopes_id integer not null, |
|
2550 |
credits_id integer not null, |
|
2551 |
sortIndex integer not null, |
|
2405 | 2552 |
revtype tinyint, |
2406 |
primary key (REV, Media_id, geoscopes_id)
|
|
2553 |
primary key (REV, Media_id, credits_id, sortIndex)
|
|
2407 | 2554 |
); |
2408 | 2555 |
|
2409 | 2556 |
create table Media_Description ( |
... | ... | |
2423 | 2570 |
primary key (REV, Media_id, description_id, description_mapkey_id) |
2424 | 2571 |
); |
2425 | 2572 |
|
2426 |
create table Media_LanguageString (
|
|
2573 |
create table Media_Extension (
|
|
2427 | 2574 |
Media_id integer not null, |
2428 |
title_id integer not null, |
|
2429 |
title_mapkey_id integer not null, |
|
2430 |
primary key (Media_id, title_mapkey_id), |
|
2431 |
unique (title_id) |
|
2575 |
extensions_id integer not null, |
|
2576 |
primary key (Media_id, extensions_id), |
|
2577 |
unique (extensions_id) |
|
2432 | 2578 |
); |
2433 | 2579 |
|
2434 |
create table Media_LanguageString_AUD ( |
|
2580 |
create table Media_Extension_AUD ( |
|
2581 |
REV integer not null, |
|
2582 |
Media_id integer not null, |
|
2583 |
extensions_id integer not null, |
|
2584 |
revtype tinyint, |
|
2585 |
primary key (REV, Media_id, extensions_id) |
|
2586 |
); |
|
2587 |
|
|
2588 |
create table Media_LanguageString ( |
|
2589 |
Media_id integer not null, |
|
2590 |
title_id integer not null, |
|
2591 |
title_mapkey_id integer not null, |
|
2592 |
primary key (Media_id, title_mapkey_id), |
|
2593 |
unique (title_id) |
|
2594 |
); |
|
2595 |
|
|
2596 |
create table Media_LanguageString_AUD ( |
|
2435 | 2597 |
REV integer not null, |
Also available in: Unified diff
synchronize dlls and dtds for tests