Revision 6429
Added by Aaron Marcuse-Kubitza almost 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 235 | 235 |
|
| 236 | 236 |
|
| 237 | 237 |
-- |
| 238 |
-- Name: _taxon_family_require_std(text); Type: FUNCTION; Schema: public; Owner: -
|
|
| 238 |
-- Name: _taxon_family_require_std(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 239 | 239 |
-- |
| 240 | 240 |
|
| 241 | 241 |
|
| ... | ... | |
| 298 | 298 |
matched_place_id int(11), |
| 299 | 299 |
coordinates_id int(11), |
| 300 | 300 |
placename_id int(11), |
| 301 |
continent text,
|
|
| 302 |
country text,
|
|
| 303 |
stateprovince text,
|
|
| 304 |
county text,
|
|
| 305 |
description text,
|
|
| 301 |
continent varchar(255),
|
|
| 302 |
country varchar(255),
|
|
| 303 |
stateprovince varchar(255),
|
|
| 304 |
county varchar(255),
|
|
| 305 |
description varchar(255),
|
|
| 306 | 306 |
geovalid int(1), |
| 307 | 307 |
distance_to_country_m double precision, |
| 308 | 308 |
distance_to_state_m double precision, |
| ... | ... | |
| 360 | 360 |
|
| 361 | 361 |
|
| 362 | 362 |
-- |
| 363 |
-- Name: source_by_shortname(text); Type: FUNCTION; Schema: public; Owner: -
|
|
| 363 |
-- Name: source_by_shortname(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 364 | 364 |
-- |
| 365 | 365 |
|
| 366 | 366 |
|
| ... | ... | |
| 436 | 436 |
CREATE TABLE taxonlabel ( |
| 437 | 437 |
taxonlabel_id int(11) NOT NULL, |
| 438 | 438 |
source_id int(11) NOT NULL, |
| 439 |
sourceaccessioncode text,
|
|
| 439 |
sourceaccessioncode varchar(255),
|
|
| 440 | 440 |
creationdate date, |
| 441 |
taxonstatus text,
|
|
| 441 |
taxonstatus varchar(255),
|
|
| 442 | 442 |
canon_label_id int(11), |
| 443 | 443 |
matched_label_id int(11), |
| 444 | 444 |
matched_label_fit_fraction double precision, |
| 445 | 445 |
parent_id int(11), |
| 446 |
taxonepithet text,
|
|
| 447 |
rank text,
|
|
| 448 |
taxonomicname text,
|
|
| 449 |
accessioncode text
|
|
| 446 |
taxonepithet varchar(255),
|
|
| 447 |
rank varchar(255),
|
|
| 448 |
taxonomicname varchar(255),
|
|
| 449 |
accessioncode varchar(255)
|
|
| 450 | 450 |
); |
| 451 | 451 |
|
| 452 | 452 |
|
| ... | ... | |
| 556 | 556 |
|
| 557 | 557 |
|
| 558 | 558 |
-- |
| 559 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
|
|
| 559 |
-- Name: concat(varchar(255)); Type: AGGREGATE; Schema: public; Owner: -
|
|
| 560 | 560 |
-- |
| 561 | 561 |
|
| 562 | 562 |
|
| ... | ... | |
| 570 | 570 |
address_id int(11) NOT NULL, |
| 571 | 571 |
party_id int(11) NOT NULL, |
| 572 | 572 |
organization_id int(11), |
| 573 |
orgposition text,
|
|
| 574 |
email text,
|
|
| 575 |
street text,
|
|
| 576 |
street2 text,
|
|
| 577 |
city text,
|
|
| 578 |
stateprovince text,
|
|
| 579 |
postalcode text,
|
|
| 580 |
country text,
|
|
| 573 |
orgposition varchar(255),
|
|
| 574 |
email varchar(255),
|
|
| 575 |
street varchar(255),
|
|
| 576 |
street2 varchar(255),
|
|
| 577 |
city varchar(255),
|
|
| 578 |
stateprovince varchar(255),
|
|
| 579 |
postalcode varchar(255),
|
|
| 580 |
country varchar(255),
|
|
| 581 | 581 |
currentflag int(1), |
| 582 | 582 |
addressstartdate date |
| 583 | 583 |
); |
| ... | ... | |
| 610 | 610 |
CREATE TABLE aggregateoccurrence ( |
| 611 | 611 |
aggregateoccurrence_id int(11) NOT NULL, |
| 612 | 612 |
source_id int(11) NOT NULL, |
| 613 |
sourceaccessioncode text,
|
|
| 613 |
sourceaccessioncode varchar(255),
|
|
| 614 | 614 |
taxonoccurrence_id int(11), |
| 615 | 615 |
collectiondate date, |
| 616 | 616 |
cover_fraction double precision, |
| ... | ... | |
| 621 | 621 |
count int(11), |
| 622 | 622 |
stratum_id int(11), |
| 623 | 623 |
coverindex_id int(11), |
| 624 |
occurrencestatus_dwc text DEFAULT 'present' NOT NULL,
|
|
| 624 |
occurrencestatus_dwc varchar(255) DEFAULT 'present' NOT NULL,
|
|
| 625 | 625 |
method_id int(11), |
| 626 |
notes text,
|
|
| 627 |
accessioncode text
|
|
| 626 |
notes varchar(255),
|
|
| 627 |
accessioncode varchar(255)
|
|
| 628 | 628 |
); |
| 629 | 629 |
|
| 630 | 630 |
|
| ... | ... | |
| 674 | 674 |
-- |
| 675 | 675 |
|
| 676 | 676 |
CREATE TABLE analytical_aggregate ( |
| 677 |
`institutionCode` text NOT NULL,
|
|
| 678 |
country text,
|
|
| 679 |
`stateProvince` text,
|
|
| 680 |
county text,
|
|
| 677 |
`institutionCode` varchar(255) NOT NULL,
|
|
| 678 |
country varchar(255),
|
|
| 679 |
`stateProvince` varchar(255),
|
|
| 680 |
county varchar(255),
|
|
| 681 | 681 |
`decimalLatitude` double precision, |
| 682 | 682 |
`decimalLongitude` double precision, |
| 683 | 683 |
`coordinateUncertaintyInMeters` double precision, |
| ... | ... | |
| 685 | 685 |
`isNewWorld` int(1), |
| 686 | 686 |
`distanceToCountry_km` double precision, |
| 687 | 687 |
`distanceToStateProvince_km` double precision, |
| 688 |
`plotName` text NOT NULL,
|
|
| 688 |
`plotName` varchar(255) NOT NULL,
|
|
| 689 | 689 |
`elevationInMeters` double precision, |
| 690 | 690 |
`plotArea_ha` double precision, |
| 691 |
`samplingProtocol` text,
|
|
| 691 |
`samplingProtocol` varchar(255),
|
|
| 692 | 692 |
`dateCollected` date NOT NULL, |
| 693 |
`higherPlantGroup` text,
|
|
| 694 |
family text,
|
|
| 695 |
genus text,
|
|
| 696 |
`speciesBinomial` text,
|
|
| 697 |
`scientificName` text,
|
|
| 698 |
`scientificNameAuthorship` text,
|
|
| 699 |
`scientificNameWithMorphospecies` text NOT NULL,
|
|
| 693 |
`higherPlantGroup` varchar(255),
|
|
| 694 |
family varchar(255),
|
|
| 695 |
genus varchar(255),
|
|
| 696 |
`speciesBinomial` varchar(255),
|
|
| 697 |
`scientificName` varchar(255),
|
|
| 698 |
`scientificNameAuthorship` varchar(255),
|
|
| 699 |
`scientificNameWithMorphospecies` varchar(255) NOT NULL,
|
|
| 700 | 700 |
threatened int(1), |
| 701 |
`identifiedBy` text,
|
|
| 702 |
`growthForm` text,
|
|
| 701 |
`identifiedBy` varchar(255),
|
|
| 702 |
`growthForm` varchar(255),
|
|
| 703 | 703 |
cultivated int(1), |
| 704 |
`cultivatedBasis` text,
|
|
| 704 |
`cultivatedBasis` varchar(255),
|
|
| 705 | 705 |
`coverPercent` double precision, |
| 706 |
`individualCount` text,
|
|
| 707 |
`individualCount_1cm_or_more` text,
|
|
| 708 |
`individualCount_2_5cm_or_more` text,
|
|
| 709 |
`individualCount_10cm_or_more` text
|
|
| 706 |
`individualCount` varchar(255),
|
|
| 707 |
`individualCount_1cm_or_more` varchar(255),
|
|
| 708 |
`individualCount_2_5cm_or_more` varchar(255),
|
|
| 709 |
`individualCount_10cm_or_more` varchar(255)
|
|
| 710 | 710 |
); |
| 711 | 711 |
|
| 712 | 712 |
|
| ... | ... | |
| 715 | 715 |
-- |
| 716 | 716 |
|
| 717 | 717 |
CREATE TABLE analytical_stem ( |
| 718 |
`institutionCode` text NOT NULL,
|
|
| 719 |
country text,
|
|
| 720 |
`stateProvince` text,
|
|
| 721 |
county text,
|
|
| 718 |
`institutionCode` varchar(255) NOT NULL,
|
|
| 719 |
country varchar(255),
|
|
| 720 |
`stateProvince` varchar(255),
|
|
| 721 |
county varchar(255),
|
|
| 722 | 722 |
`decimalLatitude` double precision, |
| 723 | 723 |
`decimalLongitude` double precision, |
| 724 | 724 |
`coordinateUncertaintyInMeters` double precision, |
| ... | ... | |
| 726 | 726 |
`isNewWorld` int(1), |
| 727 | 727 |
`distanceToCountry_km` double precision, |
| 728 | 728 |
`distanceToStateProvince_km` double precision, |
| 729 |
`plotName` text NOT NULL,
|
|
| 729 |
`plotName` varchar(255) NOT NULL,
|
|
| 730 | 730 |
`elevationInMeters` double precision, |
| 731 | 731 |
`plotArea_ha` double precision, |
| 732 |
`samplingProtocol` text,
|
|
| 732 |
`samplingProtocol` varchar(255),
|
|
| 733 | 733 |
`dateCollected` date NOT NULL, |
| 734 |
`higherPlantGroup` text,
|
|
| 735 |
family text,
|
|
| 736 |
genus text,
|
|
| 737 |
`speciesBinomial` text,
|
|
| 738 |
`scientificName` text,
|
|
| 739 |
`scientificNameAuthorship` text,
|
|
| 740 |
`scientificNameWithMorphospecies` text NOT NULL,
|
|
| 734 |
`higherPlantGroup` varchar(255),
|
|
| 735 |
family varchar(255),
|
|
| 736 |
genus varchar(255),
|
|
| 737 |
`speciesBinomial` varchar(255),
|
|
| 738 |
`scientificName` varchar(255),
|
|
| 739 |
`scientificNameAuthorship` varchar(255),
|
|
| 740 |
`scientificNameWithMorphospecies` varchar(255) NOT NULL,
|
|
| 741 | 741 |
threatened int(1), |
| 742 |
`identifiedBy` text,
|
|
| 743 |
`growthForm` text,
|
|
| 742 |
`identifiedBy` varchar(255),
|
|
| 743 |
`growthForm` varchar(255),
|
|
| 744 | 744 |
cultivated int(1), |
| 745 |
`cultivatedBasis` text,
|
|
| 745 |
`cultivatedBasis` varchar(255),
|
|
| 746 | 746 |
`coverPercent` double precision, |
| 747 | 747 |
`diameterBreastHeight_cm` double precision, |
| 748 | 748 |
height_m double precision, |
| 749 |
tag text,
|
|
| 749 |
tag varchar(255),
|
|
| 750 | 750 |
`organismX_m` double precision, |
| 751 | 751 |
`organismY_m` double precision, |
| 752 |
`recordedBy` text,
|
|
| 753 |
`recordNumber` text NOT NULL
|
|
| 752 |
`recordedBy` varchar(255),
|
|
| 753 |
`recordNumber` varchar(255) NOT NULL
|
|
| 754 | 754 |
); |
| 755 | 755 |
|
| 756 | 756 |
|
| ... | ... | |
| 770 | 770 |
source_id int(11) NOT NULL, |
| 771 | 771 |
latitude_deg double precision NOT NULL, |
| 772 | 772 |
longitude_deg double precision NOT NULL, |
| 773 |
verbatimlatitude text,
|
|
| 774 |
verbatimlongitude text,
|
|
| 775 |
verbatimcoordinates text,
|
|
| 776 |
footprintgeometry_dwc text,
|
|
| 773 |
verbatimlatitude varchar(255),
|
|
| 774 |
verbatimlongitude varchar(255),
|
|
| 775 |
verbatimcoordinates varchar(255),
|
|
| 776 |
footprintgeometry_dwc varchar(255),
|
|
| 777 | 777 |
coordsaccuracy_m double precision |
| 778 | 778 |
); |
| 779 | 779 |
|
| ... | ... | |
| 797 | 797 |
-- |
| 798 | 798 |
|
| 799 | 799 |
CREATE TABLE family_higher_plant_group ( |
| 800 |
family text NOT NULL,
|
|
| 801 |
higher_plant_group text
|
|
| 800 |
family varchar(255) NOT NULL,
|
|
| 801 |
higher_plant_group varchar(255)
|
|
| 802 | 802 |
); |
| 803 | 803 |
|
| 804 | 804 |
|
| ... | ... | |
| 809 | 809 |
CREATE TABLE location ( |
| 810 | 810 |
location_id int(11) NOT NULL, |
| 811 | 811 |
source_id int(11) NOT NULL, |
| 812 |
sourceaccessioncode text,
|
|
| 812 |
sourceaccessioncode varchar(255),
|
|
| 813 | 813 |
parent_id int(11), |
| 814 |
authorlocationcode text,
|
|
| 815 |
accesslevel text,
|
|
| 816 |
accessconditions text,
|
|
| 814 |
authorlocationcode varchar(255),
|
|
| 815 |
accesslevel varchar(255),
|
|
| 816 |
accessconditions varchar(255),
|
|
| 817 | 817 |
sublocationxposition_m double precision, |
| 818 | 818 |
sublocationyposition_m double precision, |
| 819 | 819 |
iscultivated int(1), |
| 820 |
authorzone text,
|
|
| 821 |
authordatum text,
|
|
| 822 |
authorlocation text,
|
|
| 823 |
locationnarrative text,
|
|
| 820 |
authorzone varchar(255),
|
|
| 821 |
authordatum varchar(255),
|
|
| 822 |
authorlocation varchar(255),
|
|
| 823 |
locationnarrative varchar(255),
|
|
| 824 | 824 |
azimuth double precision, |
| 825 |
shape text,
|
|
| 825 |
shape varchar(255),
|
|
| 826 | 826 |
area_m2 double precision, |
| 827 |
standsize text,
|
|
| 828 |
placementmethod text,
|
|
| 827 |
standsize varchar(255),
|
|
| 828 |
placementmethod varchar(255),
|
|
| 829 | 829 |
permanence int(1), |
| 830 |
layoutnarrative text,
|
|
| 830 |
layoutnarrative varchar(255),
|
|
| 831 | 831 |
elevation_m double precision, |
| 832 | 832 |
elevationaccuracy_m double precision, |
| 833 | 833 |
elevationrange_m double precision, |
| 834 |
verbatimelevation text,
|
|
| 834 |
verbatimelevation varchar(255),
|
|
| 835 | 835 |
slopeaspect_deg double precision, |
| 836 | 836 |
minslopeaspect_deg double precision, |
| 837 | 837 |
maxslopeaspect_deg double precision, |
| 838 | 838 |
slopegradient_fraction double precision, |
| 839 | 839 |
minslopegradient_fraction double precision, |
| 840 | 840 |
maxslopegradient_fraction double precision, |
| 841 |
topoposition text,
|
|
| 842 |
landform text,
|
|
| 843 |
surficialdeposits text,
|
|
| 844 |
rocktype text,
|
|
| 845 |
submitter_surname text,
|
|
| 846 |
submitter_givenname text,
|
|
| 847 |
submitter_email text,
|
|
| 841 |
topoposition varchar(255),
|
|
| 842 |
landform varchar(255),
|
|
| 843 |
surficialdeposits varchar(255),
|
|
| 844 |
rocktype varchar(255),
|
|
| 845 |
submitter_surname varchar(255),
|
|
| 846 |
submitter_givenname varchar(255),
|
|
| 847 |
submitter_email varchar(255),
|
|
| 848 | 848 |
notespublic int(1), |
| 849 | 849 |
notesmgt int(1), |
| 850 | 850 |
revisions int(1), |
| 851 | 851 |
dateentered date , |
| 852 |
locationrationalenarrative text,
|
|
| 853 |
accessioncode text
|
|
| 852 |
locationrationalenarrative varchar(255),
|
|
| 853 |
accessioncode varchar(255)
|
|
| 854 | 854 |
); |
| 855 | 855 |
|
| 856 | 856 |
|
| ... | ... | |
| 868 | 868 |
CREATE TABLE locationevent ( |
| 869 | 869 |
locationevent_id int(11) NOT NULL, |
| 870 | 870 |
source_id int(11) NOT NULL, |
| 871 |
sourceaccessioncode text,
|
|
| 872 |
accesslevel text,
|
|
| 871 |
sourceaccessioncode varchar(255),
|
|
| 872 |
accesslevel varchar(255),
|
|
| 873 | 873 |
parent_id int(11), |
| 874 | 874 |
location_id int(11), |
| 875 | 875 |
project_id int(11), |
| 876 |
authoreventcode text,
|
|
| 876 |
authoreventcode varchar(255),
|
|
| 877 | 877 |
previous_id int(11), |
| 878 | 878 |
obsstartdate date, |
| 879 | 879 |
obsenddate date, |
| 880 |
dateaccuracy text,
|
|
| 880 |
dateaccuracy varchar(255),
|
|
| 881 | 881 |
method_id int(11), |
| 882 | 882 |
temperature_c double precision, |
| 883 | 883 |
precipitation_m double precision, |
| 884 | 884 |
autotaxoncover int(1), |
| 885 |
originaldata text,
|
|
| 886 |
effortlevel text,
|
|
| 887 |
floristicquality text,
|
|
| 888 |
bryophytequality text,
|
|
| 889 |
lichenquality text,
|
|
| 890 |
locationeventnarrative text,
|
|
| 891 |
landscapenarrative text,
|
|
| 892 |
homogeneity text,
|
|
| 893 |
phenologicaspect text,
|
|
| 894 |
representativeness text,
|
|
| 895 |
standmaturity text,
|
|
| 896 |
successionalstatus text,
|
|
| 885 |
originaldata varchar(255),
|
|
| 886 |
effortlevel varchar(255),
|
|
| 887 |
floristicquality varchar(255),
|
|
| 888 |
bryophytequality varchar(255),
|
|
| 889 |
lichenquality varchar(255),
|
|
| 890 |
locationeventnarrative varchar(255),
|
|
| 891 |
landscapenarrative varchar(255),
|
|
| 892 |
homogeneity varchar(255),
|
|
| 893 |
phenologicaspect varchar(255),
|
|
| 894 |
representativeness varchar(255),
|
|
| 895 |
standmaturity varchar(255),
|
|
| 896 |
successionalstatus varchar(255),
|
|
| 897 | 897 |
basalarea double precision, |
| 898 |
hydrologicregime text,
|
|
| 899 |
soilmoistureregime text,
|
|
| 900 |
soildrainage text,
|
|
| 901 |
watersalinity text,
|
|
| 898 |
hydrologicregime varchar(255),
|
|
| 899 |
soilmoistureregime varchar(255),
|
|
| 900 |
soildrainage varchar(255),
|
|
| 901 |
watersalinity varchar(255),
|
|
| 902 | 902 |
waterdepth_m double precision, |
| 903 | 903 |
shoredistance double precision, |
| 904 | 904 |
soildepth double precision, |
| 905 | 905 |
organicdepth double precision, |
| 906 | 906 |
soiltaxon_id int(11), |
| 907 |
soiltaxonsrc text,
|
|
| 907 |
soiltaxonsrc varchar(255),
|
|
| 908 | 908 |
percentbedrock double precision, |
| 909 | 909 |
percentrockgravel double precision, |
| 910 | 910 |
percentwood double precision, |
| ... | ... | |
| 912 | 912 |
percentbaresoil double precision, |
| 913 | 913 |
percentwater double precision, |
| 914 | 914 |
percentother double precision, |
| 915 |
nameother text,
|
|
| 915 |
nameother varchar(255),
|
|
| 916 | 916 |
treeht double precision, |
| 917 | 917 |
shrubht double precision, |
| 918 | 918 |
fieldht double precision, |
| ... | ... | |
| 924 | 924 |
nonvascularcover double precision, |
| 925 | 925 |
floatingcover double precision, |
| 926 | 926 |
submergedcover double precision, |
| 927 |
dominantstratum text,
|
|
| 928 |
growthform1type text,
|
|
| 929 |
growthform2type text,
|
|
| 930 |
growthform3type text,
|
|
| 927 |
dominantstratum varchar(255),
|
|
| 928 |
growthform1type varchar(255),
|
|
| 929 |
growthform2type varchar(255),
|
|
| 930 |
growthform3type varchar(255),
|
|
| 931 | 931 |
growthform1cover double precision, |
| 932 | 932 |
growthform2cover double precision, |
| 933 | 933 |
growthform3cover double precision, |
| ... | ... | |
| 936 | 936 |
notesmgt int(1), |
| 937 | 937 |
revisions int(1), |
| 938 | 938 |
dateentered date , |
| 939 |
toptaxon1name text,
|
|
| 940 |
toptaxon2name text,
|
|
| 941 |
toptaxon3name text,
|
|
| 942 |
toptaxon4name text,
|
|
| 943 |
toptaxon5name text,
|
|
| 939 |
toptaxon1name varchar(255),
|
|
| 940 |
toptaxon2name varchar(255),
|
|
| 941 |
toptaxon3name varchar(255),
|
|
| 942 |
toptaxon4name varchar(255),
|
|
| 943 |
toptaxon5name varchar(255),
|
|
| 944 | 944 |
numberoftaxa int(11), |
| 945 |
accessioncode text
|
|
| 945 |
accessioncode varchar(255)
|
|
| 946 | 946 |
); |
| 947 | 947 |
|
| 948 | 948 |
|
| ... | ... | |
| 979 | 979 |
CREATE TABLE method ( |
| 980 | 980 |
method_id int(11) NOT NULL, |
| 981 | 981 |
source_id int(11) NOT NULL, |
| 982 |
name text,
|
|
| 983 |
description text,
|
|
| 982 |
name varchar(255),
|
|
| 983 |
description varchar(255),
|
|
| 984 | 984 |
diameterheight_m double precision, |
| 985 | 985 |
mindiameter_m double precision, |
| 986 | 986 |
maxdiameter_m double precision, |
| 987 | 987 |
minheight_m double precision, |
| 988 | 988 |
maxheight_m double precision, |
| 989 |
observationtype text,
|
|
| 990 |
observationmeasure text,
|
|
| 989 |
observationtype varchar(255),
|
|
| 990 |
observationmeasure varchar(255),
|
|
| 991 | 991 |
covermethod_id int(11), |
| 992 | 992 |
samplingfactor double precision DEFAULT 1 NOT NULL, |
| 993 |
coverbasis text,
|
|
| 994 |
stemsamplemethod text,
|
|
| 995 |
shape text,
|
|
| 993 |
coverbasis varchar(255),
|
|
| 994 |
stemsamplemethod varchar(255),
|
|
| 995 |
shape varchar(255),
|
|
| 996 | 996 |
length_m double precision, |
| 997 | 997 |
width_m double precision, |
| 998 | 998 |
radius_m double precision, |
| ... | ... | |
| 1001 | 1001 |
subplotspacing_m double precision, |
| 1002 | 1002 |
subplotmethod_id int(11), |
| 1003 | 1003 |
pointsperline int(11), |
| 1004 |
accessioncode text
|
|
| 1004 |
accessioncode varchar(255)
|
|
| 1005 | 1005 |
); |
| 1006 | 1006 |
|
| 1007 | 1007 |
|
| ... | ... | |
| 1145 | 1145 |
CREATE TABLE party ( |
| 1146 | 1146 |
party_id int(11) NOT NULL, |
| 1147 | 1147 |
source_id int(11) NOT NULL, |
| 1148 |
fullname text,
|
|
| 1149 |
salutation text,
|
|
| 1150 |
givenname text,
|
|
| 1151 |
middlename text,
|
|
| 1152 |
surname text,
|
|
| 1153 |
suffix text,
|
|
| 1154 |
department text,
|
|
| 1155 |
organizationname text,
|
|
| 1148 |
fullname varchar(255),
|
|
| 1149 |
salutation varchar(255),
|
|
| 1150 |
givenname varchar(255),
|
|
| 1151 |
middlename varchar(255),
|
|
| 1152 |
surname varchar(255),
|
|
| 1153 |
suffix varchar(255),
|
|
| 1154 |
department varchar(255),
|
|
| 1155 |
organizationname varchar(255),
|
|
| 1156 | 1156 |
currentname_id int(11), |
| 1157 |
contactinstructions text,
|
|
| 1158 |
email text,
|
|
| 1159 |
partytype text,
|
|
| 1157 |
contactinstructions varchar(255),
|
|
| 1158 |
email varchar(255),
|
|
| 1159 |
partytype varchar(255),
|
|
| 1160 | 1160 |
partypublic int(1) DEFAULT true, |
| 1161 |
accessioncode text
|
|
| 1161 |
accessioncode varchar(255)
|
|
| 1162 | 1162 |
); |
| 1163 | 1163 |
|
| 1164 | 1164 |
|
| ... | ... | |
| 1169 | 1169 |
CREATE TABLE plantobservation ( |
| 1170 | 1170 |
plantobservation_id int(11) NOT NULL, |
| 1171 | 1171 |
source_id int(11) NOT NULL, |
| 1172 |
sourceaccessioncode text,
|
|
| 1172 |
sourceaccessioncode varchar(255),
|
|
| 1173 | 1173 |
aggregateoccurrence_id int(11), |
| 1174 | 1174 |
overallheight_m double precision, |
| 1175 | 1175 |
overallheightaccuracy_m double precision, |
| 1176 |
collectionnumber text,
|
|
| 1176 |
collectionnumber varchar(255),
|
|
| 1177 | 1177 |
stemcount int(11), |
| 1178 | 1178 |
plant_id int(11), |
| 1179 |
accessioncode text
|
|
| 1179 |
accessioncode varchar(255)
|
|
| 1180 | 1180 |
); |
| 1181 | 1181 |
|
| 1182 | 1182 |
|
| ... | ... | |
| 1202 | 1202 |
source_id int(11) NOT NULL, |
| 1203 | 1203 |
matched_source_id int(11), |
| 1204 | 1204 |
parent_id int(11), |
| 1205 |
shortname text NOT NULL,
|
|
| 1206 |
citation text,
|
|
| 1207 |
sourcetype text,
|
|
| 1208 |
accesslevel text,
|
|
| 1209 |
accessconditions text,
|
|
| 1210 |
title text,
|
|
| 1211 |
titlesuperior text,
|
|
| 1212 |
volume text,
|
|
| 1213 |
issue text,
|
|
| 1214 |
pagerange text,
|
|
| 1205 |
shortname varchar(255) NOT NULL,
|
|
| 1206 |
citation varchar(255),
|
|
| 1207 |
sourcetype varchar(255),
|
|
| 1208 |
accesslevel varchar(255),
|
|
| 1209 |
accessconditions varchar(255),
|
|
| 1210 |
title varchar(255),
|
|
| 1211 |
titlesuperior varchar(255),
|
|
| 1212 |
volume varchar(255),
|
|
| 1213 |
issue varchar(255),
|
|
| 1214 |
pagerange varchar(255),
|
|
| 1215 | 1215 |
totalpages int(11), |
| 1216 |
publisher text,
|
|
| 1217 |
publicationplace text,
|
|
| 1218 |
isbn text,
|
|
| 1219 |
edition text,
|
|
| 1216 |
publisher varchar(255),
|
|
| 1217 |
publicationplace varchar(255),
|
|
| 1218 |
isbn varchar(255),
|
|
| 1219 |
edition varchar(255),
|
|
| 1220 | 1220 |
numberofvolumes int(11), |
| 1221 | 1221 |
chapternumber int(11), |
| 1222 | 1222 |
reportnumber int(11), |
| 1223 |
communicationtype text,
|
|
| 1224 |
degree text,
|
|
| 1225 |
url text,
|
|
| 1226 |
doi text,
|
|
| 1227 |
additionalinfo text,
|
|
| 1223 |
communicationtype varchar(255),
|
|
| 1224 |
degree varchar(255),
|
|
| 1225 |
url varchar(255),
|
|
| 1226 |
doi varchar(255),
|
|
| 1227 |
additionalinfo varchar(255),
|
|
| 1228 | 1228 |
pubdate date, |
| 1229 | 1229 |
accessdate date, |
| 1230 | 1230 |
conferencedate date, |
| 1231 |
accessioncode text
|
|
| 1231 |
accessioncode varchar(255)
|
|
| 1232 | 1232 |
); |
| 1233 | 1233 |
|
| 1234 | 1234 |
|
| ... | ... | |
| 1239 | 1239 |
CREATE TABLE stemobservation ( |
| 1240 | 1240 |
stemobservation_id int(11) NOT NULL, |
| 1241 | 1241 |
source_id int(11) NOT NULL, |
| 1242 |
sourceaccessioncode text,
|
|
| 1242 |
sourceaccessioncode varchar(255),
|
|
| 1243 | 1243 |
plantobservation_id int(11) NOT NULL, |
| 1244 |
authorstemcode text,
|
|
| 1245 |
tag text,
|
|
| 1246 |
tags text,
|
|
| 1244 |
authorstemcode varchar(255),
|
|
| 1245 |
tag varchar(255),
|
|
| 1246 |
tags varchar(255),
|
|
| 1247 | 1247 |
xposition_m double precision, |
| 1248 | 1248 |
yposition_m double precision, |
| 1249 | 1249 |
diameterbreastheight_m double precision, |
| ... | ... | |
| 1252 | 1252 |
height_m double precision, |
| 1253 | 1253 |
heightfirstbranch_m double precision, |
| 1254 | 1254 |
heightaccuracy_m double precision, |
| 1255 |
health text,
|
|
| 1255 |
health varchar(255),
|
|
| 1256 | 1256 |
age double precision, |
| 1257 |
accessioncode text
|
|
| 1257 |
accessioncode varchar(255)
|
|
| 1258 | 1258 |
); |
| 1259 | 1259 |
|
| 1260 | 1260 |
|
| ... | ... | |
| 1281 | 1281 |
taxonoccurrence_id int(11) NOT NULL, |
| 1282 | 1282 |
taxonverbatim_id int(11) NOT NULL, |
| 1283 | 1283 |
party_id int(11), |
| 1284 |
role text DEFAULT 'unknown' NOT NULL,
|
|
| 1285 |
determinationtype text,
|
|
| 1284 |
role varchar(255) DEFAULT 'unknown' NOT NULL,
|
|
| 1285 |
determinationtype varchar(255),
|
|
| 1286 | 1286 |
source_id int(11), |
| 1287 | 1287 |
isoriginal int(1) DEFAULT false NOT NULL, |
| 1288 | 1288 |
iscurrent int(1) DEFAULT false NOT NULL, |
| 1289 |
taxonfit text,
|
|
| 1290 |
taxonconfidence text,
|
|
| 1291 |
grouptype text,
|
|
| 1292 |
notes text,
|
|
| 1289 |
taxonfit varchar(255),
|
|
| 1290 |
taxonconfidence varchar(255),
|
|
| 1291 |
grouptype varchar(255),
|
|
| 1292 |
notes varchar(255),
|
|
| 1293 | 1293 |
notespublic int(1), |
| 1294 | 1294 |
notesmgt int(1), |
| 1295 | 1295 |
revisions int(1), |
| 1296 | 1296 |
determinationdate date, |
| 1297 |
accessioncode text
|
|
| 1297 |
accessioncode varchar(255)
|
|
| 1298 | 1298 |
); |
| 1299 | 1299 |
|
| 1300 | 1300 |
|
| ... | ... | |
| 1312 | 1312 |
CREATE TABLE taxonoccurrence ( |
| 1313 | 1313 |
taxonoccurrence_id int(11) NOT NULL, |
| 1314 | 1314 |
source_id int(11) NOT NULL, |
| 1315 |
sourceaccessioncode text,
|
|
| 1315 |
sourceaccessioncode varchar(255),
|
|
| 1316 | 1316 |
locationevent_id int(11), |
| 1317 |
authortaxoncode text,
|
|
| 1317 |
authortaxoncode varchar(255),
|
|
| 1318 | 1318 |
collector_id int(11), |
| 1319 |
growthform text,
|
|
| 1319 |
growthform varchar(255),
|
|
| 1320 | 1320 |
iscultivated int(1), |
| 1321 |
cultivatedbasis text,
|
|
| 1321 |
cultivatedbasis varchar(255),
|
|
| 1322 | 1322 |
isnative int(1), |
| 1323 |
accessioncode text
|
|
| 1323 |
accessioncode varchar(255)
|
|
| 1324 | 1324 |
); |
| 1325 | 1325 |
|
| 1326 | 1326 |
|
| ... | ... | |
| 1359 | 1359 |
CREATE TABLE taxonverbatim ( |
| 1360 | 1360 |
taxonverbatim_id int(11) NOT NULL, |
| 1361 | 1361 |
taxonlabel_id int(11) NOT NULL, |
| 1362 |
verbatimrank text,
|
|
| 1363 |
taxonomicname text,
|
|
| 1364 |
taxonname text,
|
|
| 1365 |
author text,
|
|
| 1366 |
family text,
|
|
| 1367 |
genus text,
|
|
| 1368 |
specific_epithet text,
|
|
| 1369 |
morphospecies text,
|
|
| 1370 |
growthform text,
|
|
| 1371 |
description text
|
|
| 1362 |
verbatimrank varchar(255),
|
|
| 1363 |
taxonomicname varchar(255),
|
|
| 1364 |
taxonname varchar(255),
|
|
| 1365 |
author varchar(255),
|
|
| 1366 |
family varchar(255),
|
|
| 1367 |
genus varchar(255),
|
|
| 1368 |
specific_epithet varchar(255),
|
|
| 1369 |
morphospecies varchar(255),
|
|
| 1370 |
growthform varchar(255),
|
|
| 1371 |
description varchar(255)
|
|
| 1372 | 1372 |
); |
| 1373 | 1373 |
|
| 1374 | 1374 |
|
| ... | ... | |
| 1459 | 1459 |
classcontributor_id int(11) NOT NULL, |
| 1460 | 1460 |
commclass_id int(11) NOT NULL, |
| 1461 | 1461 |
party_id int(11) NOT NULL, |
| 1462 |
role text
|
|
| 1462 |
role varchar(255)
|
|
| 1463 | 1463 |
); |
| 1464 | 1464 |
|
| 1465 | 1465 |
|
| ... | ... | |
| 1494 | 1494 |
tableanalysis int(1), |
| 1495 | 1495 |
multivariateanalysis int(1), |
| 1496 | 1496 |
classpublication_id int(11), |
| 1497 |
classnotes text,
|
|
| 1498 |
commname text,
|
|
| 1499 |
commcode text,
|
|
| 1500 |
commframework text,
|
|
| 1501 |
commlevel text,
|
|
| 1497 |
classnotes varchar(255),
|
|
| 1498 |
commname varchar(255),
|
|
| 1499 |
commcode varchar(255),
|
|
| 1500 |
commframework varchar(255),
|
|
| 1501 |
commlevel varchar(255),
|
|
| 1502 | 1502 |
classstartdate date, |
| 1503 | 1503 |
classstopdate date, |
| 1504 |
expertsystem text,
|
|
| 1505 |
accessioncode text
|
|
| 1504 |
expertsystem varchar(255),
|
|
| 1505 |
accessioncode varchar(255)
|
|
| 1506 | 1506 |
); |
| 1507 | 1507 |
|
| 1508 | 1508 |
|
| ... | ... | |
| 1534 | 1534 |
commconcept_id int(11) NOT NULL, |
| 1535 | 1535 |
commname_id int(11) NOT NULL, |
| 1536 | 1536 |
source_id int(11), |
| 1537 |
commdescription text,
|
|
| 1538 |
commname text,
|
|
| 1539 |
accessioncode text
|
|
| 1537 |
commdescription varchar(255),
|
|
| 1538 |
commname varchar(255),
|
|
| 1539 |
accessioncode varchar(255)
|
|
| 1540 | 1540 |
); |
| 1541 | 1541 |
|
| 1542 | 1542 |
|
| ... | ... | |
| 1568 | 1568 |
commcorrelation_id int(11) NOT NULL, |
| 1569 | 1569 |
commstatus_id int(11) NOT NULL, |
| 1570 | 1570 |
commconcept_id int(11) NOT NULL, |
| 1571 |
commconvergence text NOT NULL,
|
|
| 1571 |
commconvergence varchar(255) NOT NULL,
|
|
| 1572 | 1572 |
correlationstart date NOT NULL, |
| 1573 | 1573 |
correlationstop date |
| 1574 | 1574 |
); |
| ... | ... | |
| 1602 | 1602 |
commdetermination_id int(11) NOT NULL, |
| 1603 | 1603 |
commclass_id int(11) NOT NULL, |
| 1604 | 1604 |
commconcept_id int(11) NOT NULL, |
| 1605 |
commcode text,
|
|
| 1606 |
commname text,
|
|
| 1607 |
classfit text,
|
|
| 1608 |
classconfidence text,
|
|
| 1605 |
commcode varchar(255),
|
|
| 1606 |
commname varchar(255),
|
|
| 1607 |
classfit varchar(255),
|
|
| 1608 |
classconfidence varchar(255),
|
|
| 1609 | 1609 |
commauthority_id int(11), |
| 1610 |
notes text,
|
|
| 1610 |
notes varchar(255),
|
|
| 1611 | 1611 |
type int(1), |
| 1612 | 1612 |
nomenclaturaltype int(1) |
| 1613 | 1613 |
); |
| ... | ... | |
| 1670 | 1670 |
|
| 1671 | 1671 |
CREATE TABLE commname ( |
| 1672 | 1672 |
commname_id int(11) NOT NULL, |
| 1673 |
commname text NOT NULL,
|
|
| 1673 |
commname varchar(255) NOT NULL,
|
|
| 1674 | 1674 |
source_id int(11), |
| 1675 | 1675 |
dateentered date |
| 1676 | 1676 |
); |
| ... | ... | |
| 1704 | 1704 |
commstatus_id int(11) NOT NULL, |
| 1705 | 1705 |
commconcept_id int(11) NOT NULL, |
| 1706 | 1706 |
source_id int(11), |
| 1707 |
commconceptstatus text NOT NULL,
|
|
| 1707 |
commconceptstatus varchar(255) NOT NULL,
|
|
| 1708 | 1708 |
commparent_id int(11), |
| 1709 |
commlevel text,
|
|
| 1710 |
commpartycomments text,
|
|
| 1709 |
commlevel varchar(255),
|
|
| 1710 |
commpartycomments varchar(255),
|
|
| 1711 | 1711 |
party_id int(11) NOT NULL, |
| 1712 | 1712 |
startdate date NOT NULL, |
| 1713 | 1713 |
stopdate date, |
| 1714 |
accessioncode text
|
|
| 1714 |
accessioncode varchar(255)
|
|
| 1715 | 1715 |
); |
| 1716 | 1716 |
|
| 1717 | 1717 |
|
| ... | ... | |
| 1742 | 1742 |
CREATE TABLE commusage ( |
| 1743 | 1743 |
commusage_id int(11) NOT NULL, |
| 1744 | 1744 |
commname_id int(11) NOT NULL, |
| 1745 |
commname text,
|
|
| 1745 |
commname varchar(255),
|
|
| 1746 | 1746 |
commconcept_id int(11), |
| 1747 |
commnamestatus text,
|
|
| 1748 |
classsystem text,
|
|
| 1747 |
commnamestatus varchar(255),
|
|
| 1748 |
classsystem varchar(255),
|
|
| 1749 | 1749 |
party_id int(11), |
| 1750 | 1750 |
commstatus_id int(11), |
| 1751 | 1751 |
usagestart date, |
| ... | ... | |
| 1800 | 1800 |
CREATE TABLE coverindex ( |
| 1801 | 1801 |
coverindex_id int(11) NOT NULL, |
| 1802 | 1802 |
covermethod_id int(11) NOT NULL, |
| 1803 |
covercode text NOT NULL,
|
|
| 1803 |
covercode varchar(255) NOT NULL,
|
|
| 1804 | 1804 |
upperlimit double precision, |
| 1805 | 1805 |
lowerlimit double precision, |
| 1806 | 1806 |
coverpercent double precision NOT NULL, |
| 1807 |
indexdescription text
|
|
| 1807 |
indexdescription varchar(255)
|
|
| 1808 | 1808 |
); |
| 1809 | 1809 |
|
| 1810 | 1810 |
|
| ... | ... | |
| 1835 | 1835 |
CREATE TABLE covermethod ( |
| 1836 | 1836 |
covermethod_id int(11) NOT NULL, |
| 1837 | 1837 |
source_id int(11), |
| 1838 |
covertype text NOT NULL,
|
|
| 1839 |
coverestimationmethod text,
|
|
| 1840 |
accessioncode text
|
|
| 1838 |
covertype varchar(255) NOT NULL,
|
|
| 1839 |
coverestimationmethod varchar(255),
|
|
| 1840 |
accessioncode varchar(255)
|
|
| 1841 | 1841 |
); |
| 1842 | 1842 |
|
| 1843 | 1843 |
|
| ... | ... | |
| 1882 | 1882 |
definedvalue_id int(11) NOT NULL, |
| 1883 | 1883 |
userdefined_id int(11) NOT NULL, |
| 1884 | 1884 |
tablerecord_id int(11) NOT NULL, |
| 1885 |
definedvalue text
|
|
| 1885 |
definedvalue varchar(255)
|
|
| 1886 | 1886 |
); |
| 1887 | 1887 |
|
| 1888 | 1888 |
|
| ... | ... | |
| 1913 | 1913 |
CREATE TABLE disturbanceobs ( |
| 1914 | 1914 |
disturbanceobs_id int(11) NOT NULL, |
| 1915 | 1915 |
locationevent_id int(11) NOT NULL, |
| 1916 |
disturbancetype text NOT NULL,
|
|
| 1917 |
disturbanceintensity text,
|
|
| 1916 |
disturbancetype varchar(255) NOT NULL,
|
|
| 1917 |
disturbanceintensity varchar(255),
|
|
| 1918 | 1918 |
disturbanceage double precision, |
| 1919 | 1919 |
disturbanceextent double precision, |
| 1920 |
disturbancecomment text
|
|
| 1920 |
disturbancecomment varchar(255)
|
|
| 1921 | 1921 |
); |
| 1922 | 1922 |
|
| 1923 | 1923 |
|
| ... | ... | |
| 1946 | 1946 |
-- |
| 1947 | 1947 |
|
| 1948 | 1948 |
CREATE TABLE geoscrub_input ( |
| 1949 |
country text,
|
|
| 1950 |
`stateProvince` text,
|
|
| 1951 |
county text,
|
|
| 1949 |
country varchar(255),
|
|
| 1950 |
`stateProvince` varchar(255),
|
|
| 1951 |
county varchar(255),
|
|
| 1952 | 1952 |
`decimalLatitude` double precision, |
| 1953 | 1953 |
`decimalLongitude` double precision |
| 1954 | 1954 |
); |
| ... | ... | |
| 1968 | 1968 |
CREATE TABLE graphic ( |
| 1969 | 1969 |
graphic_id int(11) NOT NULL, |
| 1970 | 1970 |
locationevent_id int(11) NOT NULL, |
| 1971 |
graphicname text,
|
|
| 1972 |
graphiclocation text,
|
|
| 1973 |
graphicdescription text,
|
|
| 1974 |
graphictype text,
|
|
| 1971 |
graphicname varchar(255),
|
|
| 1972 |
graphiclocation varchar(255),
|
|
| 1973 |
graphicdescription varchar(255),
|
|
| 1974 |
graphictype varchar(255),
|
|
| 1975 | 1975 |
graphicdata int(11), |
| 1976 | 1976 |
graphicdate date, |
| 1977 |
accessioncode text
|
|
| 1977 |
accessioncode varchar(255)
|
|
| 1978 | 1978 |
); |
| 1979 | 1979 |
|
| 1980 | 1980 |
|
| ... | ... | |
| 2003 | 2003 |
-- |
| 2004 | 2004 |
|
| 2005 | 2005 |
CREATE TABLE higher_plant_group_nodes ( |
| 2006 |
higher_plant_group text,
|
|
| 2007 |
node_name text NOT NULL
|
|
| 2006 |
higher_plant_group varchar(255),
|
|
| 2007 |
node_name varchar(255) NOT NULL
|
|
| 2008 | 2008 |
); |
| 2009 | 2009 |
|
| 2010 | 2010 |
|
| ... | ... | |
| 2056 | 2056 |
locationeventcontributor_id int(11) NOT NULL, |
| 2057 | 2057 |
locationevent_id int(11) NOT NULL, |
| 2058 | 2058 |
party_id int(11) NOT NULL, |
| 2059 |
role text NOT NULL,
|
|
| 2059 |
role varchar(255) NOT NULL,
|
|
| 2060 | 2060 |
contributiondate date |
| 2061 | 2061 |
); |
| 2062 | 2062 |
|
| ... | ... | |
| 2090 | 2090 |
synonymlocationevent_id int(11) NOT NULL, |
| 2091 | 2091 |
primarylocationevent_id int(11) NOT NULL, |
| 2092 | 2092 |
party_id int(11) NOT NULL, |
| 2093 |
role text NOT NULL,
|
|
| 2094 |
synonymcomment text,
|
|
| 2093 |
role varchar(255) NOT NULL,
|
|
| 2094 |
synonymcomment varchar(255),
|
|
| 2095 | 2095 |
classstartdate date NOT NULL, |
| 2096 | 2096 |
classstopdate date, |
| 2097 |
accessioncode text
|
|
| 2097 |
accessioncode varchar(255)
|
|
| 2098 | 2098 |
); |
| 2099 | 2099 |
|
| 2100 | 2100 |
|
| ... | ... | |
| 2168 | 2168 |
taxonlabel_id int(11), |
| 2169 | 2169 |
included int(1) NOT NULL, |
| 2170 | 2170 |
submethod_id int(11), |
| 2171 |
taxonclass text
|
|
| 2171 |
taxonclass varchar(255)
|
|
| 2172 | 2172 |
); |
| 2173 | 2173 |
|
| 2174 | 2174 |
|
| ... | ... | |
| 2214 | 2214 |
note_id int(11) NOT NULL, |
| 2215 | 2215 |
notelink_id int(11) NOT NULL, |
| 2216 | 2216 |
party_id int(11) NOT NULL, |
| 2217 |
role text NOT NULL,
|
|
| 2218 |
notetype text NOT NULL,
|
|
| 2219 |
notetext text NOT NULL,
|
|
| 2217 |
role varchar(255) NOT NULL,
|
|
| 2218 |
notetype varchar(255) NOT NULL,
|
|
| 2219 |
notetext varchar(255) NOT NULL,
|
|
| 2220 | 2220 |
notedate date, |
| 2221 |
accessioncode text
|
|
| 2221 |
accessioncode varchar(255)
|
|
| 2222 | 2222 |
); |
| 2223 | 2223 |
|
| 2224 | 2224 |
|
| ... | ... | |
| 2248 | 2248 |
|
| 2249 | 2249 |
CREATE TABLE notelink ( |
| 2250 | 2250 |
notelink_id int(11) NOT NULL, |
| 2251 |
tablename text NOT NULL,
|
|
| 2252 |
attributename text,
|
|
| 2251 |
tablename varchar(255) NOT NULL,
|
|
| 2252 |
attributename varchar(255),
|
|
| 2253 | 2253 |
tablerecord int(11) NOT NULL |
| 2254 | 2254 |
); |
| 2255 | 2255 |
|
| ... | ... | |
| 2302 | 2302 |
partymember_id int(11) NOT NULL, |
| 2303 | 2303 |
parentparty_id int(11) NOT NULL, |
| 2304 | 2304 |
childparty_id int(11) NOT NULL, |
| 2305 |
role text,
|
|
| 2305 |
role varchar(255),
|
|
| 2306 | 2306 |
memberstart date NOT NULL, |
| 2307 | 2307 |
memberstop date |
| 2308 | 2308 |
); |
| ... | ... | |
| 2356 | 2356 |
placecorrelation_id int(11) NOT NULL, |
| 2357 | 2357 |
parentplace_id int(11) NOT NULL, |
| 2358 | 2358 |
childplace_id int(11) NOT NULL, |
| 2359 |
placeconvergence text NOT NULL
|
|
| 2359 |
placeconvergence varchar(255) NOT NULL
|
|
| 2360 | 2360 |
); |
| 2361 | 2361 |
|
| 2362 | 2362 |
|
| ... | ... | |
| 2387 | 2387 |
CREATE TABLE placename ( |
| 2388 | 2388 |
placename_id int(11) NOT NULL, |
| 2389 | 2389 |
parent_id int(11), |
| 2390 |
rank text NOT NULL,
|
|
| 2391 |
placename text NOT NULL
|
|
| 2390 |
rank varchar(255) NOT NULL,
|
|
| 2391 |
placename varchar(255) NOT NULL
|
|
| 2392 | 2392 |
); |
| 2393 | 2393 |
|
| 2394 | 2394 |
|
| ... | ... | |
| 2499 | 2499 |
CREATE TABLE project ( |
| 2500 | 2500 |
project_id int(11) NOT NULL, |
| 2501 | 2501 |
source_id int(11) NOT NULL, |
| 2502 |
sourceaccessioncode text,
|
|
| 2503 |
projectname text,
|
|
| 2504 |
projectdescription text,
|
|
| 2502 |
sourceaccessioncode varchar(255),
|
|
| 2503 |
projectname varchar(255),
|
|
| 2504 |
projectdescription varchar(255),
|
|
| 2505 | 2505 |
startdate date, |
| 2506 | 2506 |
stopdate date, |
| 2507 |
accessioncode text
|
|
| 2507 |
accessioncode varchar(255)
|
|
| 2508 | 2508 |
); |
| 2509 | 2509 |
|
| 2510 | 2510 |
|
| ... | ... | |
| 2536 | 2536 |
projectcontributor_id int(11) NOT NULL, |
| 2537 | 2537 |
project_id int(11) NOT NULL, |
| 2538 | 2538 |
party_id int(11) NOT NULL, |
| 2539 |
role text
|
|
| 2539 |
role varchar(255)
|
|
| 2540 | 2540 |
); |
| 2541 | 2541 |
|
| 2542 | 2542 |
|
| ... | ... | |
| 2566 | 2566 |
|
| 2567 | 2567 |
CREATE TABLE revision ( |
| 2568 | 2568 |
revision_id int(11) NOT NULL, |
| 2569 |
tablename text NOT NULL,
|
|
| 2570 |
tableattribute text NOT NULL,
|
|
| 2569 |
tablename varchar(255) NOT NULL,
|
|
| 2570 |
tableattribute varchar(255) NOT NULL,
|
|
| 2571 | 2571 |
tablerecord int(11) NOT NULL, |
| 2572 |
previousvaluetext text NOT NULL,
|
|
| 2573 |
previousvaluetype text NOT NULL,
|
|
| 2572 |
previousvaluetext varchar(255) NOT NULL,
|
|
| 2573 |
previousvaluetype varchar(255) NOT NULL,
|
|
| 2574 | 2574 |
previousrevision_id int(11), |
| 2575 | 2575 |
revisiondate date NOT NULL |
| 2576 | 2576 |
); |
| ... | ... | |
| 2603 | 2603 |
CREATE TABLE soilobs ( |
| 2604 | 2604 |
soilobs_id int(11) NOT NULL, |
| 2605 | 2605 |
locationevent_id int(11) NOT NULL, |
| 2606 |
horizon text DEFAULT 'unknown' NOT NULL,
|
|
| 2607 |
description text,
|
|
| 2606 |
horizon varchar(255) DEFAULT 'unknown' NOT NULL,
|
|
| 2607 |
description varchar(255),
|
|
| 2608 | 2608 |
depthtop_m double precision, |
| 2609 | 2609 |
depthbottom_m double precision, |
| 2610 |
color text,
|
|
| 2611 |
texture text,
|
|
| 2610 |
color varchar(255),
|
|
| 2611 |
texture varchar(255),
|
|
| 2612 | 2612 |
organic_fraction double precision, |
| 2613 | 2613 |
sand_fraction double precision, |
| 2614 | 2614 |
silt_fraction double precision, |
| ... | ... | |
| 2655 | 2655 |
|
| 2656 | 2656 |
CREATE TABLE soiltaxon ( |
| 2657 | 2657 |
soiltaxon_id int(11) NOT NULL, |
| 2658 |
soilcode text,
|
|
| 2659 |
soilname text,
|
|
| 2658 |
soilcode varchar(255),
|
|
| 2659 |
soilname varchar(255),
|
|
| 2660 | 2660 |
soillevel int(11), |
| 2661 | 2661 |
soilparent_id int(11), |
| 2662 |
soilframework text,
|
|
| 2663 |
accessioncode text
|
|
| 2662 |
soilframework varchar(255),
|
|
| 2663 |
accessioncode varchar(255)
|
|
| 2664 | 2664 |
); |
| 2665 | 2665 |
|
| 2666 | 2666 |
|
| ... | ... | |
| 2712 | 2712 |
sourcecontributor_id int(11) NOT NULL, |
| 2713 | 2713 |
source_id int(11) NOT NULL, |
| 2714 | 2714 |
sourceparty_id int(11) NOT NULL, |
| 2715 |
role text,
|
|
| 2715 |
role varchar(255),
|
|
| 2716 | 2716 |
`order` int(11) |
| 2717 | 2717 |
); |
| 2718 | 2718 |
|
| ... | ... | |
| 2744 | 2744 |
CREATE TABLE sourcename ( |
| 2745 | 2745 |
sourcename_id int(11) NOT NULL, |
| 2746 | 2746 |
source_id int(11) NOT NULL, |
| 2747 |
system text,
|
|
| 2748 |
name text NOT NULL,
|
|
| 2747 |
system varchar(255),
|
|
| 2748 |
name varchar(255) NOT NULL,
|
|
| 2749 | 2749 |
matched_source_id int(11) |
| 2750 | 2750 |
); |
| 2751 | 2751 |
|
| ... | ... | |
| 2813 | 2813 |
CREATE TABLE specimenreplicate ( |
| 2814 | 2814 |
specimenreplicate_id int(11) NOT NULL, |
| 2815 | 2815 |
source_id int(11) NOT NULL, |
| 2816 |
sourceaccessioncode text,
|
|
| 2816 |
sourceaccessioncode varchar(255),
|
|
| 2817 | 2817 |
plantobservation_id int(11), |
| 2818 | 2818 |
institution_id int(11), |
| 2819 |
collectioncode_dwc text,
|
|
| 2820 |
catalognumber_dwc text,
|
|
| 2821 |
description text,
|
|
| 2819 |
collectioncode_dwc varchar(255),
|
|
| 2820 |
catalognumber_dwc varchar(255),
|
|
| 2821 |
description varchar(255),
|
|
| 2822 | 2822 |
specimen_id int(11), |
| 2823 |
accessioncode text
|
|
| 2823 |
accessioncode varchar(255)
|
|
| 2824 | 2824 |
); |
| 2825 | 2825 |
|
| 2826 | 2826 |
|
| ... | ... | |
| 2928 | 2928 |
taxonalt_id int(11) NOT NULL, |
| 2929 | 2929 |
taxondetermination_id int(11) NOT NULL, |
| 2930 | 2930 |
taxonlabel_id int(11) NOT NULL, |
| 2931 |
taxonaltfit text,
|
|
| 2932 |
taxonaltconfidence text,
|
|
| 2933 |
taxonaltnotes text
|
|
| 2931 |
taxonaltfit varchar(255),
|
|
| 2932 |
taxonaltconfidence varchar(255),
|
|
| 2933 |
taxonaltnotes varchar(255)
|
|
| 2934 | 2934 |
); |
| 2935 | 2935 |
|
| 2936 | 2936 |
|
| ... | ... | |
| 3006 | 3006 |
taxoncorrelation_id int(11) NOT NULL, |
| 3007 | 3007 |
taxonstatus_id int(11) NOT NULL, |
| 3008 | 3008 |
taxonlabel_id int(11) NOT NULL, |
| 3009 |
plantconvergence text NOT NULL,
|
|
| 3009 |
plantconvergence varchar(255) NOT NULL,
|
|
| 3010 | 3010 |
correlationstart date NOT NULL, |
| 3011 | 3011 |
correlationstop date |
| 3012 | 3012 |
); |
| ... | ... | |
| 3059 | 3059 |
CREATE TABLE taxonlabel_relationship ( |
| 3060 | 3060 |
descendant_id int(11) NOT NULL, |
| 3061 | 3061 |
ancestor_id int(11) NOT NULL, |
| 3062 |
relationship text DEFAULT 'is included in' NOT NULL
|
|
| 3062 |
relationship varchar(255) DEFAULT 'is included in' NOT NULL
|
|
| 3063 | 3063 |
); |
| 3064 | 3064 |
|
| 3065 | 3065 |
|
| ... | ... | |
| 3156 | 3156 |
taxonstatus_id int(11) NOT NULL, |
| 3157 | 3157 |
taxonlabel_id int(11) NOT NULL, |
| 3158 | 3158 |
party_id int(11), |
| 3159 |
taxonlabelstatus text DEFAULT 'undetermined' NOT NULL,
|
|
| 3159 |
taxonlabelstatus varchar(255) DEFAULT 'undetermined' NOT NULL,
|
|
| 3160 | 3160 |
source_id int(11), |
| 3161 |
plantpartycomments text,
|
|
| 3161 |
plantpartycomments varchar(255),
|
|
| 3162 | 3162 |
startdate date, |
| 3163 | 3163 |
stopdate date, |
| 3164 |
accessioncode text
|
|
| 3164 |
accessioncode varchar(255)
|
|
| 3165 | 3165 |
); |
| 3166 | 3166 |
|
| 3167 | 3167 |
|
| ... | ... | |
| 3212 | 3212 |
CREATE TABLE telephone ( |
| 3213 | 3213 |
telephone_id int(11) NOT NULL, |
| 3214 | 3214 |
party_id int(11) NOT NULL, |
| 3215 |
phonenumber text NOT NULL,
|
|
| 3216 |
phonetype text NOT NULL
|
|
| 3215 |
phonenumber varchar(255) NOT NULL,
|
|
| 3216 |
phonetype varchar(255) NOT NULL
|
|
| 3217 | 3217 |
); |
| 3218 | 3218 |
|
| 3219 | 3219 |
|
| ... | ... | |
| 3258 | 3258 |
CREATE TABLE trait ( |
| 3259 | 3259 |
trait_id int(11) NOT NULL, |
| 3260 | 3260 |
stemobservation_id int(11) NOT NULL, |
| 3261 |
type text NOT NULL,
|
|
| 3262 |
value text
|
|
| 3261 |
type varchar(255) NOT NULL,
|
|
| 3262 |
value varchar(255)
|
|
| 3263 | 3263 |
); |
| 3264 | 3264 |
|
| 3265 | 3265 |
|
| ... | ... | |
| 3289 | 3289 |
|
| 3290 | 3290 |
CREATE TABLE userdefined ( |
| 3291 | 3291 |
userdefined_id int(11) NOT NULL, |
| 3292 |
userdefinedname text NOT NULL,
|
|
| 3293 |
userdefinedmetadata text,
|
|
| 3294 |
userdefinedcategory text,
|
|
| 3295 |
userdefinedtype text DEFAULT 'text' NOT NULL,
|
|
| 3296 |
tablename text NOT NULL,
|
|
| 3297 |
accessioncode text
|
|
| 3292 |
userdefinedname varchar(255) NOT NULL,
|
|
| 3293 |
userdefinedmetadata varchar(255),
|
|
| 3294 |
userdefinedcategory varchar(255),
|
|
| 3295 |
userdefinedtype varchar(255) DEFAULT 'varchar(255)' NOT NULL,
|
|
| 3296 |
tablename varchar(255) NOT NULL,
|
|
| 3297 |
accessioncode varchar(255)
|
|
| 3298 | 3298 |
); |
| 3299 | 3299 |
|
| 3300 | 3300 |
|
Also available in: Unified diff
lib/PostgreSQL-MySQL.csv: Change text to varchar(255) because text columns can't be used in indexes in MySQL