Revision 841
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 50 | 50 |
address_id int(11) NOT NULL, |
| 51 | 51 |
party_id int(11) NOT NULL, |
| 52 | 52 |
organization_id int(11), |
| 53 |
orgposition character varying(50),
|
|
| 54 |
email character varying(100),
|
|
| 55 |
deliverypoint character varying(200),
|
|
| 56 |
city character varying(50),
|
|
| 57 |
administrativearea character varying(50),
|
|
| 58 |
postalcode character varying(10),
|
|
| 59 |
country character varying(50),
|
|
| 53 |
orgposition text,
|
|
| 54 |
email text,
|
|
| 55 |
deliverypoint text,
|
|
| 56 |
city text,
|
|
| 57 |
administrativearea text,
|
|
| 58 |
postalcode text,
|
|
| 59 |
country text,
|
|
| 60 | 60 |
currentflag int(1), |
| 61 | 61 |
addressstartdate timestamp NULL |
| 62 | 62 |
); |
| ... | ... | |
| 90 | 90 |
stratumbase double precision, |
| 91 | 91 |
stratumheight double precision, |
| 92 | 92 |
emb_aggregateoccurrence int(11), |
| 93 |
covercode character varying(10),
|
|
| 93 |
covercode text,
|
|
| 94 | 94 |
count int(11), |
| 95 |
accessioncode character varying(255),
|
|
| 96 |
sourceaccessioncode character varying(100),
|
|
| 95 |
accessioncode text,
|
|
| 96 |
sourceaccessioncode text,
|
|
| 97 | 97 |
plantobservation_id int(11), |
| 98 | 98 |
stratum_id int(11), |
| 99 | 99 |
sizeclass_id int(11), |
| ... | ... | |
| 169 | 169 |
multivariateanalysis int(1), |
| 170 | 170 |
classpublication_id int(11), |
| 171 | 171 |
classnotes text, |
| 172 |
commname character varying(200),
|
|
| 173 |
commcode character varying(200),
|
|
| 174 |
commframework character varying(200),
|
|
| 175 |
commlevel character varying(200),
|
|
| 172 |
commname text,
|
|
| 173 |
commcode text,
|
|
| 174 |
commframework text,
|
|
| 175 |
commlevel text,
|
|
| 176 | 176 |
classstartdate timestamp NULL, |
| 177 | 177 |
classstopdate timestamp NULL, |
| 178 | 178 |
emb_commclass int(11), |
| 179 | 179 |
expertsystem text, |
| 180 |
accessioncode character varying(255)
|
|
| 180 |
accessioncode text
|
|
| 181 | 181 |
); |
| 182 | 182 |
|
| 183 | 183 |
|
| ... | ... | |
| 207 | 207 |
d_obscount int(11), |
| 208 | 208 |
commname text, |
| 209 | 209 |
d_currentaccepted int(1), |
| 210 |
accessioncode character varying(255)
|
|
| 210 |
accessioncode text
|
|
| 211 | 211 |
); |
| 212 | 212 |
|
| 213 | 213 |
|
| ... | ... | |
| 233 | 233 |
commcorrelation_id int(11) NOT NULL, |
| 234 | 234 |
commstatus_id int(11) NOT NULL, |
| 235 | 235 |
commconcept_id int(11) NOT NULL, |
| 236 |
commconvergence character varying(20) NOT NULL,
|
|
| 236 |
commconvergence text NOT NULL,
|
|
| 237 | 237 |
correlationstart timestamp NOT NULL, |
| 238 | 238 |
correlationstop timestamp NULL |
| 239 | 239 |
); |
| ... | ... | |
| 261 | 261 |
commdetermination_id int(11) NOT NULL, |
| 262 | 262 |
commclass_id int(11) NOT NULL, |
| 263 | 263 |
commconcept_id int(11), |
| 264 |
commcode character varying(34),
|
|
| 265 |
commname character varying(200),
|
|
| 266 |
classfit character varying(50),
|
|
| 267 |
classconfidence character varying(15),
|
|
| 264 |
commcode text,
|
|
| 265 |
commname text,
|
|
| 266 |
classfit text,
|
|
| 267 |
classconfidence text,
|
|
| 268 | 268 |
commauthority_id int(11), |
| 269 | 269 |
notes text, |
| 270 | 270 |
type int(1), |
| ... | ... | |
| 346 | 346 |
commstatus_id int(11) NOT NULL, |
| 347 | 347 |
commconcept_id int(11) NOT NULL, |
| 348 | 348 |
reference_id int(11), |
| 349 |
commconceptstatus character varying(20) NOT NULL,
|
|
| 349 |
commconceptstatus text NOT NULL,
|
|
| 350 | 350 |
commparent_id int(11), |
| 351 |
commlevel character varying(80),
|
|
| 351 |
commlevel text,
|
|
| 352 | 352 |
commpartycomments text, |
| 353 | 353 |
party_id int(11) NOT NULL, |
| 354 | 354 |
startdate timestamp NOT NULL, |
| 355 | 355 |
stopdate timestamp NULL, |
| 356 |
accessioncode character varying(255)
|
|
| 356 |
accessioncode text
|
|
| 357 | 357 |
); |
| 358 | 358 |
|
| 359 | 359 |
|
| ... | ... | |
| 380 | 380 |
commname_id int(11) NOT NULL, |
| 381 | 381 |
commname text, |
| 382 | 382 |
commconcept_id int(11), |
| 383 |
commnamestatus character varying(20),
|
|
| 384 |
classsystem character varying(50),
|
|
| 383 |
commnamestatus text,
|
|
| 384 |
classsystem text,
|
|
| 385 | 385 |
party_id int(11), |
| 386 | 386 |
commstatus_id int(11), |
| 387 | 387 |
usagestart timestamp NULL, |
| ... | ... | |
| 410 | 410 |
CREATE TABLE coverindex ( |
| 411 | 411 |
coverindex_id int(11) NOT NULL, |
| 412 | 412 |
covermethod_id int(11) NOT NULL, |
| 413 |
covercode character varying(10) NOT NULL,
|
|
| 413 |
covercode text NOT NULL,
|
|
| 414 | 414 |
upperlimit double precision, |
| 415 | 415 |
lowerlimit double precision, |
| 416 | 416 |
coverpercent double precision NOT NULL, |
| ... | ... | |
| 439 | 439 |
CREATE TABLE covermethod ( |
| 440 | 440 |
covermethod_id int(11) NOT NULL, |
| 441 | 441 |
reference_id int(11), |
| 442 |
covertype character varying(30) NOT NULL,
|
|
| 443 |
coverestimationmethod character varying(80),
|
|
| 444 |
accessioncode character varying(255)
|
|
| 442 |
covertype text NOT NULL,
|
|
| 443 |
coverestimationmethod text,
|
|
| 444 |
accessioncode text
|
|
| 445 | 445 |
); |
| 446 | 446 |
|
| 447 | 447 |
|
| ... | ... | |
| 465 | 465 |
|
| 466 | 466 |
CREATE TABLE dba_confidentialitystatus ( |
| 467 | 467 |
confidentialitystatus int(11) NOT NULL, |
| 468 |
confidentialitytext character varying(100),
|
|
| 469 |
confidentialityshorttext character varying(100)
|
|
| 468 |
confidentialitytext text,
|
|
| 469 |
confidentialityshorttext text
|
|
| 470 | 470 |
); |
| 471 | 471 |
|
| 472 | 472 |
|
| ... | ... | |
| 476 | 476 |
|
| 477 | 477 |
CREATE TABLE dba_cookie ( |
| 478 | 478 |
cookie_id int(11) NOT NULL, |
| 479 |
cookiename character varying(75) NOT NULL,
|
|
| 480 |
defaultvalue character varying(75) NOT NULL,
|
|
| 481 |
viewname character varying(25) NOT NULL,
|
|
| 479 |
cookiename text NOT NULL,
|
|
| 480 |
defaultvalue text NOT NULL,
|
|
| 481 |
viewname text NOT NULL,
|
|
| 482 | 482 |
description text, |
| 483 | 483 |
examplepk int(11) NOT NULL, |
| 484 | 484 |
sortorder int(11), |
| ... | ... | |
| 508 | 508 |
|
| 509 | 509 |
CREATE TABLE dba_cookielabels ( |
| 510 | 510 |
cookielabel_id int(11) NOT NULL, |
| 511 |
vieworcookie character varying(50) NOT NULL,
|
|
| 511 |
vieworcookie text NOT NULL,
|
|
| 512 | 512 |
description text |
| 513 | 513 |
); |
| 514 | 514 |
|
| ... | ... | |
| 535 | 535 |
|
| 536 | 536 |
CREATE TABLE dba_datacache ( |
| 537 | 537 |
dba_datacache_id int(11) NOT NULL, |
| 538 |
cache_key character varying(200) NOT NULL,
|
|
| 539 |
cache_label character varying(200),
|
|
| 538 |
cache_key text NOT NULL,
|
|
| 539 |
cache_label text,
|
|
| 540 | 540 |
cache_order double precision, |
| 541 |
data1 character varying(255),
|
|
| 542 |
data2 character varying(255),
|
|
| 543 |
data3 character varying(255),
|
|
| 544 |
data4 character varying(255),
|
|
| 545 |
data5 character varying(255),
|
|
| 546 |
data6 character varying(255),
|
|
| 547 |
data7 character varying(255),
|
|
| 548 |
data8 character varying(255),
|
|
| 549 |
data9 character varying(255),
|
|
| 550 |
data10 character varying(255)
|
|
| 541 |
data1 text,
|
|
| 542 |
data2 text,
|
|
| 543 |
data3 text,
|
|
| 544 |
data4 text,
|
|
| 545 |
data5 text,
|
|
| 546 |
data6 text,
|
|
| 547 |
data7 text,
|
|
| 548 |
data8 text,
|
|
| 549 |
data9 text,
|
|
| 550 |
data10 text
|
|
| 551 | 551 |
); |
| 552 | 552 |
|
| 553 | 553 |
|
| ... | ... | |
| 571 | 571 |
|
| 572 | 572 |
CREATE TABLE dba_datamodelversion ( |
| 573 | 573 |
dba_datamodelversion_id int(11) NOT NULL, |
| 574 |
versiontext character varying(20) NOT NULL,
|
|
| 574 |
versiontext text NOT NULL,
|
|
| 575 | 575 |
versionimplemented timestamp NULL |
| 576 | 576 |
); |
| 577 | 577 |
|
| ... | ... | |
| 601 | 601 |
statdate timestamp NULL, |
| 602 | 602 |
statpkg int(11), |
| 603 | 603 |
statname text, |
| 604 |
stattable character varying(100),
|
|
| 604 |
stattable text,
|
|
| 605 | 605 |
minpk int(11), |
| 606 | 606 |
maxpk int(11), |
| 607 | 607 |
countrecs int(11) |
| ... | ... | |
| 630 | 630 |
|
| 631 | 631 |
CREATE TABLE dba_fielddescription ( |
| 632 | 632 |
dba_fielddescription_id int(11) NOT NULL, |
| 633 |
tablename character varying(75),
|
|
| 634 |
fieldname character varying(75),
|
|
| 635 |
fieldlabel character varying(200),
|
|
| 636 |
fieldmodel character varying(50),
|
|
| 637 |
fieldnulls character varying(10),
|
|
| 638 |
fieldtype character varying(30),
|
|
| 639 |
fieldkey character varying(10),
|
|
| 640 |
fieldreferences character varying(200),
|
|
| 641 |
fieldlist character varying(50),
|
|
| 633 |
tablename text,
|
|
| 634 |
fieldname text,
|
|
| 635 |
fieldlabel text,
|
|
| 636 |
fieldmodel text,
|
|
| 637 |
fieldnulls text,
|
|
| 638 |
fieldtype text,
|
|
| 639 |
fieldkey text,
|
|
| 640 |
fieldreferences text,
|
|
| 641 |
fieldlist text,
|
|
| 642 | 642 |
fieldnotes text, |
| 643 | 643 |
fielddefinition text, |
| 644 | 644 |
fieldkeywords text |
| ... | ... | |
| 665 | 665 |
|
| 666 | 666 |
CREATE TABLE dba_fieldlist ( |
| 667 | 667 |
dba_fieldlist_id int(11) NOT NULL, |
| 668 |
tablename character varying(75),
|
|
| 669 |
fieldname character varying(75),
|
|
| 670 |
listvalue character varying(255),
|
|
| 668 |
tablename text,
|
|
| 669 |
fieldname text,
|
|
| 670 |
listvalue text,
|
|
| 671 | 671 |
listvaluedescription text, |
| 672 | 672 |
listvaluesortorder double precision |
| 673 | 673 |
); |
| ... | ... | |
| 717 | 717 |
CREATE TABLE dba_preassignacccode ( |
| 718 | 718 |
dba_preassignacccode_id int(11) NOT NULL, |
| 719 | 719 |
dba_requestnumber int(11) NOT NULL, |
| 720 |
databasekey character varying(20) NOT NULL,
|
|
| 721 |
tableabbrev character varying(10) NOT NULL,
|
|
| 722 |
confirmcode character varying(70) NOT NULL,
|
|
| 720 |
databasekey text NOT NULL,
|
|
| 721 |
tableabbrev text NOT NULL,
|
|
| 722 |
confirmcode text NOT NULL,
|
|
| 723 | 723 |
codeisused int(1), |
| 724 |
accessioncode character varying(255)
|
|
| 724 |
accessioncode text
|
|
| 725 | 725 |
); |
| 726 | 726 |
|
| 727 | 727 |
|
| ... | ... | |
| 752 | 752 |
|
| 753 | 753 |
CREATE TABLE dba_tabledescription ( |
| 754 | 754 |
dba_tabledescription_id int(11) NOT NULL, |
| 755 |
tablename character varying(75),
|
|
| 756 |
tablelabel character varying(200),
|
|
| 755 |
tablename text,
|
|
| 756 |
tablelabel text,
|
|
| 757 | 757 |
tablenotes text, |
| 758 | 758 |
tabledescription text, |
| 759 | 759 |
tablekeywords text |
| ... | ... | |
| 780 | 780 |
|
| 781 | 781 |
CREATE TABLE dba_xmlcache ( |
| 782 | 782 |
xml blob, |
| 783 |
accessioncode character varying(255)
|
|
| 783 |
accessioncode text
|
|
| 784 | 784 |
); |
| 785 | 785 |
|
| 786 | 786 |
|
| ... | ... | |
| 819 | 819 |
CREATE TABLE disturbanceobs ( |
| 820 | 820 |
disturbanceobs_id int(11) NOT NULL, |
| 821 | 821 |
locationevent_id int(11) NOT NULL, |
| 822 |
disturbancetype character varying(30) NOT NULL,
|
|
| 823 |
disturbanceintensity character varying(30),
|
|
| 822 |
disturbancetype text NOT NULL,
|
|
| 823 |
disturbanceintensity text,
|
|
| 824 | 824 |
disturbanceage double precision, |
| 825 | 825 |
disturbanceextent double precision, |
| 826 | 826 |
disturbancecomment text, |
| ... | ... | |
| 877 | 877 |
CREATE TABLE graphic ( |
| 878 | 878 |
graphic_id int(11) NOT NULL, |
| 879 | 879 |
locationevent_id int(11) NOT NULL, |
| 880 |
graphicname character varying(30),
|
|
| 880 |
graphicname text,
|
|
| 881 | 881 |
graphiclocation text, |
| 882 | 882 |
graphicdescription text, |
| 883 |
graphictype character varying(20),
|
|
| 883 |
graphictype text,
|
|
| 884 | 884 |
graphicdata int(11), |
| 885 | 885 |
graphicdate timestamp NULL, |
| 886 |
accessioncode character varying(255)
|
|
| 886 |
accessioncode text
|
|
| 887 | 887 |
); |
| 888 | 888 |
|
| 889 | 889 |
|
| ... | ... | |
| 929 | 929 |
|
| 930 | 930 |
CREATE TABLE location ( |
| 931 | 931 |
location_id int(11) NOT NULL, |
| 932 |
authorlocationcode character varying(30),
|
|
| 932 |
authorlocationcode text,
|
|
| 933 | 933 |
reference_id int(11), |
| 934 | 934 |
parent_id int(11), |
| 935 | 935 |
reallatitude double precision, |
| 936 | 936 |
reallongitude double precision, |
| 937 | 937 |
locationaccuracy double precision, |
| 938 | 938 |
confidentialitystatus int(11) DEFAULT 0 NOT NULL, |
| 939 |
confidentialityreason character varying(200),
|
|
| 939 |
confidentialityreason text,
|
|
| 940 | 940 |
publiclatitude double precision, |
| 941 | 941 |
publiclongitude double precision, |
| 942 |
accessioncode character varying(255),
|
|
| 942 |
accessioncode text,
|
|
| 943 | 943 |
sublocationxposition double precision, |
| 944 | 944 |
sublocationyposition double precision, |
| 945 |
authore character varying(20),
|
|
| 946 |
authorn character varying(20),
|
|
| 947 |
authorzone character varying(20),
|
|
| 948 |
authordatum character varying(20),
|
|
| 949 |
authorlocation character varying(200),
|
|
| 945 |
authore text,
|
|
| 946 |
authorn text,
|
|
| 947 |
authorzone text,
|
|
| 948 |
authordatum text,
|
|
| 949 |
authorlocation text,
|
|
| 950 | 950 |
locationnarrative text, |
| 951 | 951 |
azimuth double precision, |
| 952 | 952 |
dsgpoly text, |
| 953 |
shape character varying(50),
|
|
| 953 |
shape text,
|
|
| 954 | 954 |
area double precision, |
| 955 |
standsize character varying(50),
|
|
| 956 |
placementmethod character varying(50),
|
|
| 955 |
standsize text,
|
|
| 956 |
placementmethod text,
|
|
| 957 | 957 |
permanence int(1), |
| 958 | 958 |
layoutnarrative text, |
| 959 | 959 |
elevation double precision, |
| ... | ... | |
| 965 | 965 |
slopegradient double precision, |
| 966 | 966 |
minslopegradient double precision, |
| 967 | 967 |
maxslopegradient double precision, |
| 968 |
topoposition character varying(90),
|
|
| 969 |
landform character varying(50),
|
|
| 970 |
surficialdeposits character varying(90),
|
|
| 971 |
rocktype character varying(90),
|
|
| 972 |
stateprovince character varying(55),
|
|
| 973 |
country character varying(100),
|
|
| 974 |
submitter_surname character varying(100),
|
|
| 975 |
submitter_givenname character varying(100),
|
|
| 976 |
submitter_email character varying(100),
|
|
| 968 |
topoposition text,
|
|
| 969 |
landform text,
|
|
| 970 |
surficialdeposits text,
|
|
| 971 |
rocktype text,
|
|
| 972 |
stateprovince text,
|
|
| 973 |
country text,
|
|
| 974 |
submitter_surname text,
|
|
| 975 |
submitter_givenname text,
|
|
| 976 |
submitter_email text,
|
|
| 977 | 977 |
notespublic int(1), |
| 978 | 978 |
notesmgt int(1), |
| 979 | 979 |
revisions int(1), |
| ... | ... | |
| 1006 | 1006 |
previous_id int(11), |
| 1007 | 1007 |
location_id int(11), |
| 1008 | 1008 |
project_id int(11), |
| 1009 |
authoreventcode character varying(30),
|
|
| 1010 |
accessioncode character varying(255),
|
|
| 1011 |
sourceaccessioncode character varying(100),
|
|
| 1012 |
dateaccuracy character varying(30),
|
|
| 1009 |
authoreventcode text,
|
|
| 1010 |
accessioncode text,
|
|
| 1011 |
sourceaccessioncode text,
|
|
| 1012 |
dateaccuracy text,
|
|
| 1013 | 1013 |
covermethod_id int(11), |
| 1014 |
coverdispersion character varying(30),
|
|
| 1014 |
coverdispersion text,
|
|
| 1015 | 1015 |
autotaxoncover int(1), |
| 1016 | 1016 |
methodnarrative text, |
| 1017 | 1017 |
taxonoccurrencearea double precision, |
| 1018 | 1018 |
stemsizelimit double precision, |
| 1019 | 1019 |
stemarea double precision, |
| 1020 |
stemsamplemethod character varying(30),
|
|
| 1020 |
stemsamplemethod text,
|
|
| 1021 | 1021 |
originaldata text, |
| 1022 |
effortlevel character varying(30),
|
|
| 1022 |
effortlevel text,
|
|
| 1023 | 1023 |
locationvalidationlevel int(11), |
| 1024 |
floristicquality character varying(30),
|
|
| 1025 |
bryophytequality character varying(30),
|
|
| 1026 |
lichenquality character varying(30),
|
|
| 1024 |
floristicquality text,
|
|
| 1025 |
bryophytequality text,
|
|
| 1026 |
lichenquality text,
|
|
| 1027 | 1027 |
locationeventnarrative text, |
| 1028 | 1028 |
landscapenarrative text, |
| 1029 |
homogeneity character varying(50),
|
|
| 1030 |
phenologicaspect character varying(30),
|
|
| 1031 |
representativeness character varying(255),
|
|
| 1032 |
standmaturity character varying(50),
|
|
| 1029 |
homogeneity text,
|
|
| 1030 |
phenologicaspect text,
|
|
| 1031 |
representativeness text,
|
|
| 1032 |
standmaturity text,
|
|
| 1033 | 1033 |
successionalstatus text, |
| 1034 | 1034 |
basalarea double precision, |
| 1035 |
hydrologicregime character varying(30),
|
|
| 1036 |
soilmoistureregime character varying(30),
|
|
| 1037 |
soildrainage character varying(30),
|
|
| 1038 |
watersalinity character varying(30),
|
|
| 1035 |
hydrologicregime text,
|
|
| 1036 |
soilmoistureregime text,
|
|
| 1037 |
soildrainage text,
|
|
| 1038 |
watersalinity text,
|
|
| 1039 | 1039 |
waterdepth double precision, |
| 1040 | 1040 |
shoredistance double precision, |
| 1041 | 1041 |
soildepth double precision, |
| 1042 | 1042 |
organicdepth double precision, |
| 1043 | 1043 |
soiltaxon_id int(11), |
| 1044 |
soiltaxonsrc character varying(200),
|
|
| 1044 |
soiltaxonsrc text,
|
|
| 1045 | 1045 |
percentbedrock double precision, |
| 1046 | 1046 |
percentrockgravel double precision, |
| 1047 | 1047 |
percentwood double precision, |
| ... | ... | |
| 1049 | 1049 |
percentbaresoil double precision, |
| 1050 | 1050 |
percentwater double precision, |
| 1051 | 1051 |
percentother double precision, |
| 1052 |
nameother character varying(30),
|
|
| 1052 |
nameother text,
|
|
| 1053 | 1053 |
treeht double precision, |
| 1054 | 1054 |
shrubht double precision, |
| 1055 | 1055 |
fieldht double precision, |
| ... | ... | |
| 1061 | 1061 |
nonvascularcover double precision, |
| 1062 | 1062 |
floatingcover double precision, |
| 1063 | 1063 |
submergedcover double precision, |
| 1064 |
dominantstratum character varying(40),
|
|
| 1065 |
growthform1type character varying(40),
|
|
| 1066 |
growthform2type character varying(40),
|
|
| 1067 |
growthform3type character varying(40),
|
|
| 1064 |
dominantstratum text,
|
|
| 1065 |
growthform1type text,
|
|
| 1066 |
growthform2type text,
|
|
| 1067 |
growthform3type text,
|
|
| 1068 | 1068 |
growthform1cover double precision, |
| 1069 | 1069 |
growthform2cover double precision, |
| 1070 | 1070 |
growthform3cover double precision, |
| ... | ... | |
| 1094 | 1094 |
interp_bestfit_code text, |
| 1095 | 1095 |
interp_bestfit_party_id int(11), |
| 1096 | 1096 |
interp_bestfit_partyname text, |
| 1097 |
toptaxon1name character varying(255),
|
|
| 1098 |
toptaxon2name character varying(255),
|
|
| 1099 |
toptaxon3name character varying(255),
|
|
| 1100 |
toptaxon4name character varying(255),
|
|
| 1101 |
toptaxon5name character varying(255),
|
|
| 1097 |
toptaxon1name text,
|
|
| 1098 |
toptaxon2name text,
|
|
| 1099 |
toptaxon3name text,
|
|
| 1100 |
toptaxon4name text,
|
|
| 1101 |
toptaxon5name text,
|
|
| 1102 | 1102 |
numberoftaxa int(11) |
| 1103 | 1103 |
); |
| 1104 | 1104 |
|
| ... | ... | |
| 1164 | 1164 |
synonymcomment text, |
| 1165 | 1165 |
classstartdate timestamp NULL NOT NULL, |
| 1166 | 1166 |
classstopdate timestamp NULL, |
| 1167 |
accessioncode character varying(255)
|
|
| 1167 |
accessioncode text
|
|
| 1168 | 1168 |
); |
| 1169 | 1169 |
|
| 1170 | 1170 |
|
| ... | ... | |
| 1214 | 1214 |
|
| 1215 | 1215 |
CREATE TABLE namedplace ( |
| 1216 | 1216 |
namedplace_id int(11) NOT NULL, |
| 1217 |
placesystem character varying(50),
|
|
| 1218 |
placename character varying(100) NOT NULL,
|
|
| 1217 |
placesystem text,
|
|
| 1218 |
placename text NOT NULL,
|
|
| 1219 | 1219 |
placedescription text, |
| 1220 |
placecode character varying(15),
|
|
| 1221 |
owner character varying(100),
|
|
| 1220 |
placecode text,
|
|
| 1221 |
owner text,
|
|
| 1222 | 1222 |
reference_id int(11), |
| 1223 | 1223 |
d_obscount int(11), |
| 1224 |
accessioncode character varying(255)
|
|
| 1224 |
accessioncode text
|
|
| 1225 | 1225 |
); |
| 1226 | 1226 |
|
| 1227 | 1227 |
|
| ... | ... | |
| 1247 | 1247 |
namedplacecorrelation_id int(11) NOT NULL, |
| 1248 | 1248 |
parentplace_id int(11) NOT NULL, |
| 1249 | 1249 |
childplace_id int(11) NOT NULL, |
| 1250 |
placeconvergence character varying(20) NOT NULL
|
|
| 1250 |
placeconvergence text NOT NULL
|
|
| 1251 | 1251 |
); |
| 1252 | 1252 |
|
| 1253 | 1253 |
|
| ... | ... | |
| 1274 | 1274 |
notelink_id int(11) NOT NULL, |
| 1275 | 1275 |
party_id int(11) NOT NULL, |
| 1276 | 1276 |
role_id int(11) NOT NULL, |
| 1277 |
notetype character varying(20) NOT NULL,
|
|
| 1277 |
notetype text NOT NULL,
|
|
| 1278 | 1278 |
notetext text NOT NULL, |
| 1279 | 1279 |
notedate timestamp NULL, |
| 1280 |
accessioncode character varying(255)
|
|
| 1280 |
accessioncode text
|
|
| 1281 | 1281 |
); |
| 1282 | 1282 |
|
| 1283 | 1283 |
|
| ... | ... | |
| 1301 | 1301 |
|
| 1302 | 1302 |
CREATE TABLE notelink ( |
| 1303 | 1303 |
notelink_id int(11) NOT NULL, |
| 1304 |
tablename character varying(50) NOT NULL,
|
|
| 1305 |
attributename character varying(50),
|
|
| 1304 |
tablename text NOT NULL,
|
|
| 1305 |
attributename text,
|
|
| 1306 | 1306 |
tablerecord int(11) NOT NULL |
| 1307 | 1307 |
); |
| 1308 | 1308 |
|
| ... | ... | |
| 1327 | 1327 |
|
| 1328 | 1328 |
CREATE TABLE party ( |
| 1329 | 1329 |
party_id int(11) NOT NULL, |
| 1330 |
salutation character varying(20),
|
|
| 1331 |
givenname character varying(50),
|
|
| 1332 |
middlename character varying(50),
|
|
| 1333 |
surname character varying(50),
|
|
| 1334 |
organizationname character varying(100),
|
|
| 1330 |
salutation text,
|
|
| 1331 |
givenname text,
|
|
| 1332 |
middlename text,
|
|
| 1333 |
surname text,
|
|
| 1334 |
organizationname text,
|
|
| 1335 | 1335 |
currentname_id int(11), |
| 1336 | 1336 |
contactinstructions text, |
| 1337 |
email character varying(120),
|
|
| 1338 |
partytype character varying(40),
|
|
| 1337 |
email text,
|
|
| 1338 |
partytype text,
|
|
| 1339 | 1339 |
partypublic int(1) DEFAULT true, |
| 1340 | 1340 |
d_obscount int(11), |
| 1341 |
accessioncode character varying(255)
|
|
| 1341 |
accessioncode text
|
|
| 1342 | 1342 |
); |
| 1343 | 1343 |
|
| 1344 | 1344 |
|
| ... | ... | |
| 1426 | 1426 |
plantconcept_id int(11) NOT NULL, |
| 1427 | 1427 |
plantname_id int(11) NOT NULL, |
| 1428 | 1428 |
reference_id int(11), |
| 1429 |
plantcode character varying(23),
|
|
| 1429 |
plantcode text,
|
|
| 1430 | 1430 |
plantdescription text, |
| 1431 | 1431 |
d_obscount int(11), |
| 1432 | 1432 |
d_currentaccepted int(1), |
| 1433 |
accessioncode character varying(255)
|
|
| 1433 |
accessioncode text
|
|
| 1434 | 1434 |
); |
| 1435 | 1435 |
|
| 1436 | 1436 |
|
| ... | ... | |
| 1456 | 1456 |
plantcorrelation_id int(11) NOT NULL, |
| 1457 | 1457 |
plantstatus_id int(11) NOT NULL, |
| 1458 | 1458 |
plantconcept_id int(11) NOT NULL, |
| 1459 |
plantconvergence character varying(20) NOT NULL,
|
|
| 1459 |
plantconvergence text NOT NULL,
|
|
| 1460 | 1460 |
correlationstart timestamp NOT NULL, |
| 1461 | 1461 |
correlationstop timestamp NULL |
| 1462 | 1462 |
); |
| ... | ... | |
| 1507 | 1507 |
|
| 1508 | 1508 |
CREATE TABLE plantname ( |
| 1509 | 1509 |
plantname_id int(11) NOT NULL, |
| 1510 |
plantname character varying(255) NOT NULL,
|
|
| 1510 |
plantname text NOT NULL,
|
|
| 1511 | 1511 |
reference_id int(11), |
| 1512 | 1512 |
dateentered timestamp NULL |
| 1513 | 1513 |
); |
| ... | ... | |
| 1536 | 1536 |
overallheight double precision, |
| 1537 | 1537 |
overallheightaccuracy double precision, |
| 1538 | 1538 |
emb_plantobservation int(11), |
| 1539 |
authorplantcode character varying(20),
|
|
| 1540 |
accessioncode character varying(255),
|
|
| 1539 |
authorplantcode text,
|
|
| 1540 |
accessioncode text,
|
|
| 1541 | 1541 |
stemcount int(11), |
| 1542 |
sourceaccessioncode character varying(100),
|
|
| 1542 |
sourceaccessioncode text,
|
|
| 1543 | 1543 |
plant_id int(11) |
| 1544 | 1544 |
); |
| 1545 | 1545 |
|
| ... | ... | |
| 1573 | 1573 |
plantstatus_id int(11) NOT NULL, |
| 1574 | 1574 |
plantconcept_id int(11) NOT NULL, |
| 1575 | 1575 |
reference_id int(11), |
| 1576 |
plantconceptstatus character varying(20) DEFAULT 'undetermined',
|
|
| 1576 |
plantconceptstatus text DEFAULT 'undetermined',
|
|
| 1577 | 1577 |
plantpartycomments text, |
| 1578 |
plantparentname character varying(200),
|
|
| 1578 |
plantparentname text,
|
|
| 1579 | 1579 |
plantparentconcept_id int(11), |
| 1580 | 1580 |
plantparent_id int(11), |
| 1581 |
plantlevel character varying(80),
|
|
| 1581 |
plantlevel text,
|
|
| 1582 | 1582 |
party_id int(11), |
| 1583 | 1583 |
startdate timestamp NULL, |
| 1584 | 1584 |
stopdate timestamp NULL, |
| 1585 |
accessioncode character varying(255)
|
|
| 1585 |
accessioncode text
|
|
| 1586 | 1586 |
); |
| 1587 | 1587 |
|
| 1588 | 1588 |
|
| ... | ... | |
| 1609 | 1609 |
CREATE TABLE planttag ( |
| 1610 | 1610 |
planttag_id int(11) NOT NULL, |
| 1611 | 1611 |
plantobservation_id int(11) NOT NULL, |
| 1612 |
tag character varying(255) NOT NULL,
|
|
| 1612 |
tag text NOT NULL,
|
|
| 1613 | 1613 |
iscurrent int(1) DEFAULT true NOT NULL |
| 1614 | 1614 |
); |
| 1615 | 1615 |
|
| ... | ... | |
| 1638 | 1638 |
plantusage_id int(11) NOT NULL, |
| 1639 | 1639 |
plantname_id int(11) NOT NULL, |
| 1640 | 1640 |
plantconcept_id int(11), |
| 1641 |
plantnamestatus character varying(20),
|
|
| 1642 |
plantname character varying(220),
|
|
| 1643 |
classsystem character varying(50),
|
|
| 1644 |
acceptedsynonym character varying(220),
|
|
| 1641 |
plantnamestatus text,
|
|
| 1642 |
plantname text,
|
|
| 1643 |
classsystem text,
|
|
| 1644 |
acceptedsynonym text,
|
|
| 1645 | 1645 |
party_id int(11), |
| 1646 | 1646 |
plantstatus_id int(11), |
| 1647 | 1647 |
usagestart timestamp NULL, |
| ... | ... | |
| 1669 | 1669 |
|
| 1670 | 1670 |
CREATE TABLE project ( |
| 1671 | 1671 |
project_id int(11) NOT NULL, |
| 1672 |
projectname character varying(150) NOT NULL,
|
|
| 1672 |
projectname text NOT NULL,
|
|
| 1673 | 1673 |
projectdescription text, |
| 1674 | 1674 |
startdate timestamp NULL, |
| 1675 | 1675 |
stopdate timestamp NULL, |
| 1676 | 1676 |
d_obscount int(11), |
| 1677 | 1677 |
d_lastlocationaddeddate timestamp NULL, |
| 1678 |
accessioncode character varying(255),
|
|
| 1678 |
accessioncode text,
|
|
| 1679 | 1679 |
reference_id int(11) |
| 1680 | 1680 |
); |
| 1681 | 1681 |
|
| ... | ... | |
| 1703 | 1703 |
project_id int(11) NOT NULL, |
| 1704 | 1704 |
party_id int(11) NOT NULL, |
| 1705 | 1705 |
role_id int(11), |
| 1706 |
surname character varying(50),
|
|
| 1707 |
cheatrole character varying(50)
|
|
| 1706 |
surname text,
|
|
| 1707 |
cheatrole text
|
|
| 1708 | 1708 |
); |
| 1709 | 1709 |
|
| 1710 | 1710 |
|
| ... | ... | |
| 1728 | 1728 |
|
| 1729 | 1729 |
CREATE TABLE reference ( |
| 1730 | 1730 |
reference_id int(11) NOT NULL, |
| 1731 |
shortname character varying(250),
|
|
| 1731 |
shortname text,
|
|
| 1732 | 1732 |
fulltext__ text, |
| 1733 |
referencetype character varying(250),
|
|
| 1734 |
title character varying(250),
|
|
| 1735 |
titlesuperior character varying(250),
|
|
| 1733 |
referencetype text,
|
|
| 1734 |
title text,
|
|
| 1735 |
titlesuperior text,
|
|
| 1736 | 1736 |
referencejournal_id int(11), |
| 1737 |
volume character varying(250),
|
|
| 1738 |
issue character varying(250),
|
|
| 1739 |
pagerange character varying(250),
|
|
| 1737 |
volume text,
|
|
| 1738 |
issue text,
|
|
| 1739 |
pagerange text,
|
|
| 1740 | 1740 |
totalpages int(11), |
| 1741 |
publisher character varying(250),
|
|
| 1742 |
publicationplace character varying(250),
|
|
| 1743 |
isbn character varying(250),
|
|
| 1744 |
edition character varying(250),
|
|
| 1741 |
publisher text,
|
|
| 1742 |
publicationplace text,
|
|
| 1743 |
isbn text,
|
|
| 1744 |
edition text,
|
|
| 1745 | 1745 |
numberofvolumes int(11), |
| 1746 | 1746 |
chapternumber int(11), |
| 1747 | 1747 |
reportnumber int(11), |
| 1748 |
communicationtype character varying(250),
|
|
| 1749 |
degree character varying(250),
|
|
| 1748 |
communicationtype text,
|
|
| 1749 |
degree text,
|
|
| 1750 | 1750 |
url text, |
| 1751 | 1751 |
doi text, |
| 1752 | 1752 |
additionalinfo text, |
| 1753 | 1753 |
pubdate timestamp NULL, |
| 1754 | 1754 |
accessdate timestamp NULL, |
| 1755 | 1755 |
conferencedate timestamp NULL, |
| 1756 |
accessioncode character varying(255)
|
|
| 1756 |
accessioncode text
|
|
| 1757 | 1757 |
); |
| 1758 | 1758 |
|
| 1759 | 1759 |
|
| ... | ... | |
| 1778 | 1778 |
CREATE TABLE referencealtident ( |
| 1779 | 1779 |
referencealtident_id int(11) NOT NULL, |
| 1780 | 1780 |
reference_id int(11) NOT NULL, |
| 1781 |
system character varying(250),
|
|
| 1782 |
identifier character varying(250) NOT NULL
|
|
| 1781 |
system text,
|
|
| 1782 |
identifier text NOT NULL
|
|
| 1783 | 1783 |
); |
| 1784 | 1784 |
|
| 1785 | 1785 |
|
| ... | ... | |
| 1805 | 1805 |
referencecontributor_id int(11) NOT NULL, |
| 1806 | 1806 |
reference_id int(11) NOT NULL, |
| 1807 | 1807 |
referenceparty_id int(11) NOT NULL, |
| 1808 |
roletype character varying(250),
|
|
| 1808 |
roletype text,
|
|
| 1809 | 1809 |
`position` int(11) |
| 1810 | 1810 |
); |
| 1811 | 1811 |
|
| ... | ... | |
| 1830 | 1830 |
|
| 1831 | 1831 |
CREATE TABLE referencejournal ( |
| 1832 | 1832 |
referencejournal_id int(11) NOT NULL, |
| 1833 |
journal character varying(250) NOT NULL,
|
|
| 1834 |
issn character varying(250),
|
|
| 1835 |
abbreviation character varying(250),
|
|
| 1836 |
accessioncode character varying(255)
|
|
| 1833 |
journal text NOT NULL,
|
|
| 1834 |
issn text,
|
|
| 1835 |
abbreviation text,
|
|
| 1836 |
accessioncode text
|
|
| 1837 | 1837 |
); |
| 1838 | 1838 |
|
| 1839 | 1839 |
|
| ... | ... | |
| 1857 | 1857 |
|
| 1858 | 1858 |
CREATE TABLE referenceparty ( |
| 1859 | 1859 |
referenceparty_id int(11) NOT NULL, |
| 1860 |
type character varying(250),
|
|
| 1861 |
positionname character varying(250),
|
|
| 1862 |
salutation character varying(250),
|
|
| 1863 |
givenname character varying(250),
|
|
| 1864 |
surname character varying(250),
|
|
| 1865 |
suffix character varying(250),
|
|
| 1866 |
organizationname character varying(250),
|
|
| 1860 |
type text,
|
|
| 1861 |
positionname text,
|
|
| 1862 |
salutation text,
|
|
| 1863 |
givenname text,
|
|
| 1864 |
surname text,
|
|
| 1865 |
suffix text,
|
|
| 1866 |
organizationname text,
|
|
| 1867 | 1867 |
currentparty_id int(11), |
| 1868 |
accessioncode character varying(255)
|
|
| 1868 |
accessioncode text
|
|
| 1869 | 1869 |
); |
| 1870 | 1870 |
|
| 1871 | 1871 |
|
| ... | ... | |
| 1889 | 1889 |
|
| 1890 | 1890 |
CREATE TABLE revision ( |
| 1891 | 1891 |
revision_id int(11) NOT NULL, |
| 1892 |
tablename character varying(50) NOT NULL,
|
|
| 1893 |
tableattribute character varying(50) NOT NULL,
|
|
| 1892 |
tablename text NOT NULL,
|
|
| 1893 |
tableattribute text NOT NULL,
|
|
| 1894 | 1894 |
tablerecord int(11) NOT NULL, |
| 1895 | 1895 |
previousvaluetext text NOT NULL, |
| 1896 |
previousvaluetype character varying(20) NOT NULL,
|
|
| 1896 |
previousvaluetype text NOT NULL,
|
|
| 1897 | 1897 |
previousrevision_id int(11), |
| 1898 | 1898 |
revisiondate timestamp NOT NULL |
| 1899 | 1899 |
); |
| ... | ... | |
| 1919 | 1919 |
|
| 1920 | 1920 |
CREATE TABLE role ( |
| 1921 | 1921 |
role_id int(11) NOT NULL, |
| 1922 |
rolecode character varying(30) NOT NULL,
|
|
| 1923 |
roledescription character varying(200),
|
|
| 1922 |
rolecode text NOT NULL,
|
|
| 1923 |
roledescription text,
|
|
| 1924 | 1924 |
roleproject int(11), |
| 1925 | 1925 |
roleobservation int(11), |
| 1926 | 1926 |
roletaxonint int(11), |
| 1927 | 1927 |
roleclassint int(11), |
| 1928 |
accessioncode character varying(255)
|
|
| 1928 |
accessioncode text
|
|
| 1929 | 1929 |
); |
| 1930 | 1930 |
|
| 1931 | 1931 |
|
| ... | ... | |
| 1955 | 1955 |
minheight double precision, |
| 1956 | 1956 |
maxdiameter double precision, |
| 1957 | 1957 |
maxheight double precision, |
| 1958 |
accessioncode character varying(255)
|
|
| 1958 |
accessioncode text
|
|
| 1959 | 1959 |
); |
| 1960 | 1960 |
|
| 1961 | 1961 |
|
| ... | ... | |
| 1989 | 1989 |
CREATE TABLE soilobs ( |
| 1990 | 1990 |
soilobs_id int(11) NOT NULL, |
| 1991 | 1991 |
locationevent_id int(11) NOT NULL, |
| 1992 |
soilhorizon character varying(15) NOT NULL,
|
|
| 1992 |
soilhorizon text NOT NULL,
|
|
| 1993 | 1993 |
soildepthtop double precision, |
| 1994 | 1994 |
soildepthbottom double precision, |
| 1995 |
soilcolor character varying(30),
|
|
| 1995 |
soilcolor text,
|
|
| 1996 | 1996 |
soilorganic double precision, |
| 1997 |
soiltexture character varying(50),
|
|
| 1997 |
soiltexture text,
|
|
| 1998 | 1998 |
soilsand double precision, |
| 1999 | 1999 |
soilsilt double precision, |
| 2000 | 2000 |
soilclay double precision, |
| ... | ... | |
| 2027 | 2027 |
|
| 2028 | 2028 |
CREATE TABLE soiltaxon ( |
| 2029 | 2029 |
soiltaxon_id int(11) NOT NULL, |
| 2030 |
soilcode character varying(15),
|
|
| 2031 |
soilname character varying(100),
|
|
| 2030 |
soilcode text,
|
|
| 2031 |
soilname text,
|
|
| 2032 | 2032 |
soillevel int(11), |
| 2033 | 2033 |
soilparent_id int(11), |
| 2034 |
soilframework character varying(33),
|
|
| 2035 |
accessioncode character varying(255)
|
|
| 2034 |
soilframework text,
|
|
| 2035 |
accessioncode text
|
|
| 2036 | 2036 |
); |
| 2037 | 2037 |
|
| 2038 | 2038 |
|
| ... | ... | |
| 2089 | 2089 |
CREATE TABLE specimenreplicate ( |
| 2090 | 2090 |
specimenreplicate_id int(11) NOT NULL, |
| 2091 | 2091 |
reference_id int(11) NOT NULL, |
| 2092 |
collectioncode_dwc character varying(255),
|
|
| 2093 |
catalognumber_dwc character varying(255),
|
|
| 2092 |
collectioncode_dwc text,
|
|
| 2093 |
catalognumber_dwc text,
|
|
| 2094 | 2094 |
collectiondate timestamp NULL, |
| 2095 | 2095 |
museum_id int(11), |
| 2096 |
sourceaccessioncode character varying(100),
|
|
| 2097 |
accessioncode character varying(255),
|
|
| 2096 |
sourceaccessioncode text,
|
|
| 2097 |
accessioncode text,
|
|
| 2098 | 2098 |
taxonoccurrence_id int(11) NOT NULL, |
| 2099 |
verbatimcollectorname character varying(255),
|
|
| 2100 |
collectionnumber character varying(255),
|
|
| 2099 |
verbatimcollectorname text,
|
|
| 2100 |
collectionnumber text,
|
|
| 2101 | 2101 |
specimen_id int(11) |
| 2102 | 2102 |
); |
| 2103 | 2103 |
|
| ... | ... | |
| 2146 | 2146 |
CREATE TABLE stemobservation ( |
| 2147 | 2147 |
stemobservation_id int(11) NOT NULL, |
| 2148 | 2148 |
plantobservation_id int(11) NOT NULL, |
| 2149 |
authorstemcode character varying(20),
|
|
| 2149 |
authorstemcode text,
|
|
| 2150 | 2150 |
xposition double precision, |
| 2151 | 2151 |
yposition double precision, |
| 2152 |
health character varying(50),
|
|
| 2152 |
health text,
|
|
| 2153 | 2153 |
emb_stemobservation int(11), |
| 2154 | 2154 |
diameter double precision, |
| 2155 | 2155 |
height double precision, |
| 2156 | 2156 |
heightaccuracy double precision, |
| 2157 | 2157 |
age double precision, |
| 2158 |
accessioncode character varying(255),
|
|
| 2158 |
accessioncode text,
|
|
| 2159 | 2159 |
diameteraccuracy double precision, |
| 2160 |
sourceaccessioncode character varying(100)
|
|
| 2160 |
sourceaccessioncode text
|
|
| 2161 | 2161 |
); |
| 2162 | 2162 |
|
| 2163 | 2163 |
|
| ... | ... | |
| 2218 | 2218 |
CREATE TABLE stratummethod ( |
| 2219 | 2219 |
stratummethod_id int(11) NOT NULL, |
| 2220 | 2220 |
reference_id int(11), |
| 2221 |
stratummethodname character varying(30) NOT NULL,
|
|
| 2221 |
stratummethodname text NOT NULL,
|
|
| 2222 | 2222 |
stratummethoddescription text, |
| 2223 |
stratumassignment character varying(50),
|
|
| 2224 |
accessioncode character varying(255)
|
|
| 2223 |
stratumassignment text,
|
|
| 2224 |
accessioncode text
|
|
| 2225 | 2225 |
); |
| 2226 | 2226 |
|
| 2227 | 2227 |
|
| ... | ... | |
| 2246 | 2246 |
CREATE TABLE stratumtype ( |
| 2247 | 2247 |
stratumtype_id int(11) NOT NULL, |
| 2248 | 2248 |
stratummethod_id int(11) NOT NULL, |
| 2249 |
stratumindex character varying(10),
|
|
| 2250 |
stratumname character varying(30),
|
|
| 2249 |
stratumindex text,
|
|
| 2250 |
stratumname text,
|
|
| 2251 | 2251 |
stratumdescription text |
| 2252 | 2252 |
); |
| 2253 | 2253 |
|
| ... | ... | |
| 2274 | 2274 |
taxonalt_id int(11) NOT NULL, |
| 2275 | 2275 |
taxondetermination_id int(11) NOT NULL, |
| 2276 | 2276 |
plantconcept_id int(11) NOT NULL, |
| 2277 |
taxonaltfit character varying(50),
|
|
| 2278 |
taxonaltconfidence character varying(50),
|
|
| 2277 |
taxonaltfit text,
|
|
| 2278 |
taxonaltconfidence text,
|
|
| 2279 | 2279 |
taxonaltnotes text, |
| 2280 | 2280 |
emb_taxonalt int(11) |
| 2281 | 2281 |
); |
| ... | ... | |
| 2305 | 2305 |
plantconcept_id int(11) NOT NULL, |
| 2306 | 2306 |
party_id int(11), |
| 2307 | 2307 |
role_id int(11) NOT NULL, |
| 2308 |
determinationtype character varying(30),
|
|
| 2308 |
determinationtype text,
|
|
| 2309 | 2309 |
reference_id int(11), |
| 2310 | 2310 |
isoriginal int(1) DEFAULT false NOT NULL, |
| 2311 | 2311 |
iscurrent int(1) DEFAULT false NOT NULL, |
| 2312 |
taxonfit character varying(50),
|
|
| 2313 |
taxonconfidence character varying(50),
|
|
| 2314 |
grouptype character varying(20),
|
|
| 2312 |
taxonfit text,
|
|
| 2313 |
taxonconfidence text,
|
|
| 2314 |
grouptype text,
|
|
| 2315 | 2315 |
notes text, |
| 2316 | 2316 |
notespublic int(1), |
| 2317 | 2317 |
notesmgt int(1), |
| 2318 | 2318 |
revisions int(1), |
| 2319 | 2319 |
determinationdate timestamp NULL, |
| 2320 | 2320 |
emb_taxondetermination int(11), |
| 2321 |
accessioncode character varying(255)
|
|
| 2321 |
accessioncode text
|
|
| 2322 | 2322 |
); |
| 2323 | 2323 |
|
| 2324 | 2324 |
|
| ... | ... | |
| 2350 | 2350 |
CREATE TABLE taxonoccurrence ( |
| 2351 | 2351 |
taxonoccurrence_id int(11) NOT NULL, |
| 2352 | 2352 |
locationevent_id int(11), |
| 2353 |
authorplantname character varying(255),
|
|
| 2353 |
authorplantname text,
|
|
| 2354 | 2354 |
reference_id int(11), |
| 2355 | 2355 |
emb_taxonoccurrence int(11), |
| 2356 |
accessioncode character varying(255)
|
|
| 2356 |
accessioncode text
|
|
| 2357 | 2357 |
); |
| 2358 | 2358 |
|
| 2359 | 2359 |
|
| ... | ... | |
| 2385 | 2385 |
CREATE TABLE telephone ( |
| 2386 | 2386 |
telephone_id int(11) NOT NULL, |
| 2387 | 2387 |
party_id int(11) NOT NULL, |
| 2388 |
phonenumber character varying(30) NOT NULL,
|
|
| 2389 |
phonetype character varying(20) NOT NULL
|
|
| 2388 |
phonenumber text NOT NULL,
|
|
| 2389 |
phonetype text NOT NULL
|
|
| 2390 | 2390 |
); |
| 2391 | 2391 |
|
| 2392 | 2392 |
|
| ... | ... | |
| 2410 | 2410 |
|
| 2411 | 2411 |
CREATE TABLE temptbl_std_commnames ( |
| 2412 | 2412 |
commconcept_id int(11) NOT NULL, |
| 2413 |
sciname character varying(255),
|
|
| 2414 |
translated character varying(255),
|
|
| 2415 |
code character varying(255),
|
|
| 2416 |
common character varying(255)
|
|
| 2413 |
sciname text,
|
|
| 2414 |
translated text,
|
|
| 2415 |
code text,
|
|
| 2416 |
common text
|
|
| 2417 | 2417 |
); |
| 2418 | 2418 |
|
| 2419 | 2419 |
|
| ... | ... | |
| 2437 | 2437 |
|
| 2438 | 2438 |
CREATE TABLE temptbl_std_plantnames ( |
| 2439 | 2439 |
plantconcept_id int(11) NOT NULL, |
| 2440 |
plantname character varying(255),
|
|
| 2441 |
sciname character varying(255),
|
|
| 2442 |
scinamenoauth character varying(255),
|
|
| 2443 |
code character varying(255),
|
|
| 2444 |
common character varying(255)
|
|
| 2440 |
plantname text,
|
|
| 2441 |
sciname text,
|
|
| 2442 |
scinamenoauth text,
|
|
| 2443 |
code text,
|
|
| 2444 |
common text
|
|
| 2445 | 2445 |
); |
| 2446 | 2446 |
|
| 2447 | 2447 |
|
| ... | ... | |
| 2468 | 2468 |
CREATE TABLE trait ( |
| 2469 | 2469 |
trait_id int(11) NOT NULL, |
| 2470 | 2470 |
stemobservation_id int(11) NOT NULL, |
| 2471 |
type character varying(255) NOT NULL,
|
|
| 2472 |
value character varying(255)
|
|
| 2471 |
type text NOT NULL,
|
|
| 2472 |
value text
|
|
| 2473 | 2473 |
); |
| 2474 | 2474 |
|
| 2475 | 2475 |
|
| ... | ... | |
| 2498 | 2498 |
usr_id int(11) NOT NULL, |
| 2499 | 2499 |
current_cert_level int(11) NOT NULL, |
| 2500 | 2500 |
requested_cert_level int(11) NOT NULL, |
| 2501 |
highest_degree character varying(50),
|
|
| 2502 |
degree_year character varying(50),
|
|
| 2503 |
degree_institution character varying(50),
|
|
| 2504 |
current_org character varying(50),
|
|
| 2505 |
current_pos character varying(200),
|
|
| 2501 |
highest_degree text,
|
|
| 2502 |
degree_year text,
|
|
| 2503 |
degree_institution text,
|
|
| 2504 |
current_org text,
|
|
| 2505 |
current_pos text,
|
|
| 2506 | 2506 |
esa_member int(1), |
| 2507 | 2507 |
prof_exp text, |
| 2508 | 2508 |
relevant_pubs text, |
| ... | ... | |
| 2512 | 2512 |
vb_exp text, |
| 2513 | 2513 |
vb_intention text, |
| 2514 | 2514 |
tools_exp text, |
| 2515 |
esa_sponsor_name_a character varying(120),
|
|
| 2516 |
esa_sponsor_email_a character varying(120),
|
|
| 2517 |
esa_sponsor_name_b character varying(120),
|
|
| 2518 |
esa_sponsor_email_b character varying(120),
|
|
| 2515 |
esa_sponsor_name_a text,
|
|
| 2516 |
esa_sponsor_email_a text,
|
|
| 2517 |
esa_sponsor_name_b text,
|
|
| 2518 |
esa_sponsor_email_b text,
|
|
| 2519 | 2519 |
peer_review int(1), |
| 2520 | 2520 |
addl_stmt text, |
| 2521 |
certificationstatus character varying(30),
|
|
| 2521 |
certificationstatus text,
|
|
| 2522 | 2522 |
certificationstatuscomments text, |
| 2523 | 2523 |
exp_region_a text, |
| 2524 | 2524 |
exp_region_b text, |
| ... | ... | |
| 2556 | 2556 |
CREATE TABLE userdataset ( |
| 2557 | 2557 |
userdataset_id int(11) NOT NULL, |
| 2558 | 2558 |
usr_id int(11), |
| 2559 |
datasetname character varying(100) NOT NULL,
|
|
| 2559 |
datasetname text NOT NULL,
|
|
| 2560 | 2560 |
datasetdescription text, |
| 2561 |
datasettype character varying(50),
|
|
| 2562 |
datasetsharing character varying(30),
|
|
| 2563 |
datasetpassword character varying(50),
|
|
| 2561 |
datasettype text,
|
|
| 2562 |
datasetsharing text,
|
|
| 2563 |
datasetpassword text,
|
|
| 2564 | 2564 |
datasetstop timestamp NULL, |
| 2565 | 2565 |
datasetstart timestamp NULL , |
| 2566 |
accessioncode character varying(255)
|
|
| 2566 |
accessioncode text
|
|
| 2567 | 2567 |
); |
| 2568 | 2568 |
|
| 2569 | 2569 |
|
| ... | ... | |
| 2588 | 2588 |
CREATE TABLE userdatasetitem ( |
| 2589 | 2589 |
userdatasetitem_id int(11) NOT NULL, |
| 2590 | 2590 |
userdataset_id int(11) NOT NULL, |
| 2591 |
itemaccessioncode character varying(100) NOT NULL,
|
|
| 2592 |
itemtype character varying(50),
|
|
| 2591 |
itemaccessioncode text NOT NULL,
|
|
| 2592 |
itemtype text,
|
|
| 2593 | 2593 |
notes text, |
| 2594 | 2594 |
itemstart timestamp NULL NOT NULL, |
| 2595 | 2595 |
itemstop timestamp NULL, |
| 2596 |
externalaccessioncode character varying(100),
|
|
| 2597 |
itemdatabase character varying(50) NOT NULL,
|
|
| 2598 |
itemtable character varying(50) NOT NULL,
|
|
| 2596 |
externalaccessioncode text,
|
|
| 2597 |
itemdatabase text NOT NULL,
|
|
| 2598 |
itemtable text NOT NULL,
|
|
| 2599 | 2599 |
itemrecord int(11) NOT NULL |
| 2600 | 2600 |
); |
| 2601 | 2601 |
|
| ... | ... | |
| 2620 | 2620 |
|
| 2621 | 2621 |
CREATE TABLE userdefined ( |
| 2622 | 2622 |
userdefined_id int(11) NOT NULL, |
| 2623 |
userdefinedname character varying(50),
|
|
| 2623 |
userdefinedname text,
|
|
| 2624 | 2624 |
userdefinedmetadata text, |
| 2625 |
userdefinedcategory character varying(30),
|
|
| 2626 |
userdefinedtype character varying(20) DEFAULT 'text',
|
|
| 2627 |
tablename character varying(50) NOT NULL,
|
|
| 2628 |
accessioncode character varying(255)
|
|
| 2625 |
userdefinedcategory text,
|
|
| 2626 |
userdefinedtype text DEFAULT 'text',
|
|
| 2627 |
tablename text NOT NULL,
|
|
| 2628 |
accessioncode text
|
|
| 2629 | 2629 |
); |
| 2630 | 2630 |
|
| 2631 | 2631 |
|
| ... | ... | |
| 2650 | 2650 |
CREATE TABLE usernotify ( |
| 2651 | 2651 |
usernotify_id int(11) NOT NULL, |
| 2652 | 2652 |
usr_id int(11) NOT NULL, |
| 2653 |
notifyname character varying(100),
|
|
| 2653 |
notifyname text,
|
|
| 2654 | 2654 |
notifydescription text, |
| 2655 | 2655 |
notifysql text, |
| 2656 | 2656 |
notifystart timestamp NULL , |
| ... | ... | |
| 2709 | 2709 |
CREATE TABLE userpreference ( |
| 2710 | 2710 |
userpreference_id int(11) NOT NULL, |
| 2711 | 2711 |
usr_id int(11) NOT NULL, |
| 2712 |
preferencename character varying(100),
|
|
| 2712 |
preferencename text,
|
|
| 2713 | 2713 |
preferencevalue text, |
| 2714 | 2714 |
preferencepriority double precision, |
| 2715 | 2715 |
preferencestop timestamp NULL, |
| ... | ... | |
| 2738 | 2738 |
CREATE TABLE userquery ( |
| 2739 | 2739 |
userquery_id int(11) NOT NULL, |
| 2740 | 2740 |
usr_id int(11) NOT NULL, |
| 2741 |
queryname character varying(100),
|
|
| 2741 |
queryname text,
|
|
| 2742 | 2742 |
querydescription text, |
| 2743 | 2743 |
querysql text, |
| 2744 |
querytype character varying(50),
|
|
| 2745 |
querysharing character varying(30),
|
|
| 2746 |
querypassword character varying(50),
|
|
| 2744 |
querytype text,
|
|
| 2745 |
querysharing text,
|
|
| 2746 |
querypassword text,
|
|
| 2747 | 2747 |
querystop timestamp NULL, |
| 2748 | 2748 |
querystart timestamp NULL , |
| 2749 |
accessioncode character varying(255)
|
|
| 2749 |
accessioncode text
|
|
| 2750 | 2750 |
); |
| 2751 | 2751 |
|
| 2752 | 2752 |
|
| ... | ... | |
| 2771 | 2771 |
CREATE TABLE userrecordowner ( |
| 2772 | 2772 |
userrecordowner_id int(11) NOT NULL, |
| 2773 | 2773 |
usr_id int(11) NOT NULL, |
| 2774 |
tablename character varying(50) NOT NULL,
|
|
| 2774 |
tablename text NOT NULL,
|
|
| 2775 | 2775 |
tablerecord int(11) NOT NULL, |
| 2776 |
ownertype character varying(30) NOT NULL,
|
|
| 2776 |
ownertype text NOT NULL,
|
|
| 2777 | 2777 |
recordcreationdate timestamp NOT NULL, |
| 2778 | 2778 |
ownerstop timestamp NULL, |
| 2779 | 2779 |
ownerstart timestamp NULL NOT NULL |
| ... | ... | |
| 2801 | 2801 |
CREATE TABLE userregionalexp ( |
| 2802 | 2802 |
userregionalexp_id int(11) NOT NULL, |
| 2803 | 2803 |
usercertification_id int(11) NOT NULL, |
| 2804 |
region character varying(50) NOT NULL,
|
|
| 2805 |
vegetation character varying(50),
|
|
| 2806 |
floristics character varying(50),
|
|
| 2807 |
nvc_ivc character varying(50)
|
|
| 2804 |
region text NOT NULL,
|
|
| 2805 |
vegetation text,
|
|
| 2806 |
floristics text,
|
|
| 2807 |
nvc_ivc text
|
|
| 2808 | 2808 |
); |
| 2809 | 2809 |
|
| 2810 | 2810 |
|
| ... | ... | |
| 2831 | 2831 |
party_id int(11) NOT NULL, |
| 2832 | 2832 |
permission_type int(11) NOT NULL, |
| 2833 | 2833 |
ticket_count int(11), |
| 2834 |
email_address character varying(100) NOT NULL,
|
|
| 2835 |
preferred_name character varying(100),
|
|
| 2836 |
remote_address character varying(100),
|
|
| 2834 |
email_address text NOT NULL,
|
|
| 2835 |
preferred_name text,
|
|
| 2836 |
remote_address text,
|
|
| 2837 | 2837 |
last_connect timestamp NULL, |
| 2838 | 2838 |
begin_time timestamp NULL, |
| 2839 |
password character varying(512)
|
|
| 2839 |
password text
|
|
| 2840 | 2840 |
); |
| 2841 | 2841 |
|
| 2842 | 2842 |
|
| ... | ... | |
| 2864 | 2864 |
voucher_id int(11) NOT NULL, |
| 2865 | 2865 |
taxonoccurrence_id int(11) NOT NULL, |
| 2866 | 2866 |
specimenreplicate_id int(11) NOT NULL, |
| 2867 |
accessioncode character varying(255)
|
|
| 2867 |
accessioncode text
|
|
| 2868 | 2868 |
); |
| 2869 | 2869 |
|
| 2870 | 2870 |
|
Also available in: Unified diff
vegbien.sql: Replaced all "character varying" types with text, removing the length limits. Note that in PostgreSQL, text and "character varying" are stored the same way internally, so this does not affect performance or indexes.