Revision 6741
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/CVS/cvs-archive-2012-12-04.schema.sql | ||
|---|---|---|
| 25 | 25 |
"administrativeArea" VARCHAR(50), |
| 26 | 26 |
"postalCode" VARCHAR(10), |
| 27 | 27 |
"country" VARCHAR(50), |
| 28 |
"currentFlag" BOOLEAN DEFAULT E'0',
|
|
| 28 |
"currentFlag" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 29 | 29 |
"addressStartDate" TIMESTAMP, |
| 30 | 30 |
"dba_src_ID" INTEGER, |
| 31 | 31 |
PRIMARY KEY ("ADDRESS_ID")
|
| ... | ... | |
| 90 | 90 |
"OBSERVATION_ID" INTEGER NOT NULL, |
| 91 | 91 |
"classStartDate" TIMESTAMP, |
| 92 | 92 |
"classStopDate" TIMESTAMP, |
| 93 |
"inspection" BOOLEAN DEFAULT E'0',
|
|
| 94 |
"tableAnalysis" BOOLEAN DEFAULT E'0',
|
|
| 95 |
"multivariateAnalysis" BOOLEAN DEFAULT E'0',
|
|
| 93 |
"inspection" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 94 |
"tableAnalysis" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 95 |
"multivariateAnalysis" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 96 | 96 |
"expertSystem" TEXT, |
| 97 | 97 |
"classPublication_ID" INTEGER, |
| 98 | 98 |
"classNotes" TEXT, |
| ... | ... | |
| 129 | 129 |
"common" VARCHAR(255), |
| 130 | 130 |
"commLevel" VARCHAR(80), |
| 131 | 131 |
"alliance" VARCHAR(255), |
| 132 |
"includeInPicklistNow" BOOLEAN DEFAULT E'-1',
|
|
| 132 |
"includeInPicklistNow" /*BOOLEAN*/INTEGER DEFAULT E'-1',
|
|
| 133 | 133 |
"PhysGroup" VARCHAR(255), |
| 134 | 134 |
"FormGroup" VARCHAR(255), |
| 135 | 135 |
"EcolGroup" VARCHAR(255), |
| ... | ... | |
| 173 | 173 |
"classConfidence" VARCHAR(15), |
| 174 | 174 |
"commAuthority_ID" INTEGER, |
| 175 | 175 |
"notes" TEXT, |
| 176 |
"type" BOOLEAN DEFAULT E'0',
|
|
| 177 |
"nomenclaturalType" BOOLEAN DEFAULT E'0',
|
|
| 176 |
"type" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 177 |
"nomenclaturalType" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 178 | 178 |
"dba_src_ID" INTEGER, |
| 179 | 179 |
"framework_id" INTEGER, |
| 180 |
"primaryDetermination" BOOLEAN DEFAULT E'0',
|
|
| 180 |
"primaryDetermination" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 181 | 181 |
"primaryDeterminationStatus" INTEGER DEFAULT 0, |
| 182 | 182 |
"primaryComments" TEXT, |
| 183 | 183 |
"primaryStartDate" TIMESTAMP, |
| ... | ... | |
| 185 | 185 |
"dba_interpretationStatus" VARCHAR(255), |
| 186 | 186 |
"previousFit" VARCHAR(50), |
| 187 | 187 |
"orderDeterminationForEvent" INTEGER, |
| 188 |
"duplicateDetermination" BOOLEAN DEFAULT E'0',
|
|
| 188 |
"duplicateDetermination" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 189 | 189 |
PRIMARY KEY ("COMMINTERPRETATION_ID")
|
| 190 | 190 |
); |
| 191 | 191 |
|
| ... | ... | |
| 271 | 271 |
"COVERINDEX_ID" SERIAL NOT NULL, |
| 272 | 272 |
"COVERMETHOD_ID" INTEGER NOT NULL, |
| 273 | 273 |
"coverCode" VARCHAR(10) NOT NULL, |
| 274 |
"upperLimit" DOUBLE PRECISION NULL,
|
|
| 275 |
"lowerLimit" DOUBLE PRECISION NULL,
|
|
| 276 |
"coverPercent" DOUBLE PRECISION NULL NOT NULL,
|
|
| 274 |
"upperLimit" DOUBLE PRECISION, |
|
| 275 |
"lowerLimit" DOUBLE PRECISION, |
|
| 276 |
"coverPercent" DOUBLE PRECISION NOT NULL, |
|
| 277 | 277 |
"indexDescription" TEXT, |
| 278 | 278 |
"dba_src_ID" INTEGER, |
| 279 | 279 |
PRIMARY KEY ("COVERINDEX_ID")
|
| ... | ... | |
| 306 | 306 |
"observation_ID" INTEGER, |
| 307 | 307 |
"module" VARCHAR(4), |
| 308 | 308 |
"corner" VARCHAR(4), |
| 309 |
"depth" DOUBLE PRECISION NULL,
|
|
| 309 |
"depth" DOUBLE PRECISION, |
|
| 310 | 310 |
PRIMARY KEY ("DepthID")
|
| 311 | 311 |
); |
| 312 | 312 |
|
| ... | ... | |
| 351 | 351 |
"OBSERVATION_ID" INTEGER NOT NULL, |
| 352 | 352 |
"disturbanceType" VARCHAR(30) NOT NULL, |
| 353 | 353 |
"disturbanceIntensity" VARCHAR(30), |
| 354 |
"disturbanceAge" DOUBLE PRECISION NULL,
|
|
| 355 |
"disturbanceExtent" DOUBLE PRECISION NULL,
|
|
| 354 |
"disturbanceAge" DOUBLE PRECISION, |
|
| 355 |
"disturbanceExtent" DOUBLE PRECISION, |
|
| 356 | 356 |
"disturbanceComment" TEXT, |
| 357 | 357 |
"dba_src_ID" INTEGER, |
| 358 | 358 |
PRIMARY KEY ("disturbanceObs_ID")
|
| ... | ... | |
| 383 | 383 |
|
| 384 | 384 |
CREATE TABLE "entry_cover" ( |
| 385 | 385 |
"HerbLineID" SERIAL NOT NULL, |
| 386 |
"AlternateOrder" DOUBLE PRECISION NULL,
|
|
| 386 |
"AlternateOrder" DOUBLE PRECISION, |
|
| 387 | 387 |
"plotID" INTEGER NOT NULL, |
| 388 | 388 |
"NC_Code" INTEGER, |
| 389 | 389 |
"altReference_ID" INTEGER, |
| ... | ... | |
| 464 | 464 |
"cvs_level" INTEGER, |
| 465 | 465 |
"date" TIMESTAMP, |
| 466 | 466 |
"depth" INTEGER, |
| 467 |
"Ares_H" DOUBLE PRECISION NULL,
|
|
| 467 |
"Ares_H" DOUBLE PRECISION, |
|
| 468 | 468 |
"notesPlot" VARCHAR(255), |
| 469 | 469 |
"str1" VARCHAR(10) DEFAULT E'H', |
| 470 | 470 |
"str2" VARCHAR(10) DEFAULT E'S', |
| ... | ... | |
| 505 | 505 |
"log_pmodifiedDate" TIMESTAMP DEFAULT E'Now()', |
| 506 | 506 |
"log_pmodifiedUser" VARCHAR(50), |
| 507 | 507 |
"vmd_year" INTEGER DEFAULT 0, |
| 508 |
"cp_entry_plotDone" BOOLEAN DEFAULT E'0',
|
|
| 508 |
"cp_entry_plotDone" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 509 | 509 |
"cp_yearNum" INTEGER, |
| 510 | 510 |
"cp_authorObsCode" VARCHAR(255), |
| 511 | 511 |
PRIMARY KEY ("plotID")
|
| ... | ... | |
| 524 | 524 |
"plot" VARCHAR(12), |
| 525 | 525 |
"cvs_level" INTEGER, |
| 526 | 526 |
"date" TIMESTAMP, |
| 527 |
"Ares" DOUBLE PRECISION NULL,
|
|
| 527 |
"Ares" DOUBLE PRECISION, |
|
| 528 | 528 |
"PlotSubSeedling" INTEGER, |
| 529 | 529 |
"PlotSubSapling" INTEGER, |
| 530 | 530 |
"PlotSubTree" INTEGER, |
| ... | ... | |
| 532 | 532 |
"notesPlot" VARCHAR(255), |
| 533 | 533 |
"notesPlot_indiv" VARCHAR(255), |
| 534 | 534 |
"headerrors" TEXT, |
| 535 |
"minimumDBH" DOUBLE PRECISION NULL,
|
|
| 536 |
"minimumdgh" DOUBLE PRECISION NULL,
|
|
| 537 |
"minimumHt" DOUBLE PRECISION NULL,
|
|
| 538 |
"AllStemsPlanted" BOOLEAN DEFAULT E'0',
|
|
| 535 |
"minimumDBH" DOUBLE PRECISION, |
|
| 536 |
"minimumdgh" DOUBLE PRECISION, |
|
| 537 |
"minimumHt" DOUBLE PRECISION, |
|
| 538 |
"AllStemsPlanted" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 539 | 539 |
"log_pcreateDate" TIMESTAMP DEFAULT E'Now()', |
| 540 | 540 |
"log_pcreateUser" VARCHAR(50), |
| 541 | 541 |
"log_pmodifiedDate" TIMESTAMP DEFAULT E'Now()', |
| 542 | 542 |
"log_pmodifiedUser" VARCHAR(50), |
| 543 | 543 |
"vmd_year" INTEGER DEFAULT 0, |
| 544 |
"cp_entry_plotDone" BOOLEAN DEFAULT E'0',
|
|
| 544 |
"cp_entry_plotDone" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 545 | 545 |
"cp_yearNum" INTEGER, |
| 546 | 546 |
"cp_authorObsCode" VARCHAR(255), |
| 547 |
"plotXYReversedOrientation" BOOLEAN DEFAULT E'0',
|
|
| 547 |
"plotXYReversedOrientation" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 548 | 548 |
PRIMARY KEY ("plotID")
|
| 549 | 549 |
); |
| 550 | 550 |
|
| ... | ... | |
| 556 | 556 |
|
| 557 | 557 |
CREATE TABLE "entry_stems" ( |
| 558 | 558 |
"TreeLineID" SERIAL NOT NULL, |
| 559 |
"AlternateOrder" DOUBLE PRECISION NULL,
|
|
| 559 |
"AlternateOrder" DOUBLE PRECISION, |
|
| 560 | 560 |
"plotID" INTEGER NOT NULL, |
| 561 | 561 |
"NC_Code" INTEGER, |
| 562 | 562 |
"altReference_ID" INTEGER, |
| ... | ... | |
| 595 | 595 |
"errors" TEXT, |
| 596 | 596 |
"NC_Code_History" TEXT, |
| 597 | 597 |
"duplicate" INTEGER DEFAULT 0, |
| 598 |
"TreeSummarySamplingCase" DOUBLE PRECISION NULL,
|
|
| 599 |
"IsIndividualRecord" BOOLEAN DEFAULT E'0',
|
|
| 598 |
"TreeSummarySamplingCase" DOUBLE PRECISION, |
|
| 599 |
"IsIndividualRecord" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 600 | 600 |
"stemIDCode" VARCHAR(20), |
| 601 | 601 |
"stemSource" VARCHAR(10), |
| 602 | 602 |
"stemHealth" VARCHAR(50), |
| 603 | 603 |
"stemComment" VARCHAR(200), |
| 604 |
"stemX" DOUBLE PRECISION NULL,
|
|
| 605 |
"stemY" DOUBLE PRECISION NULL,
|
|
| 606 |
"dgh" DOUBLE PRECISION NULL,
|
|
| 607 |
"Height" DOUBLE PRECISION NULL,
|
|
| 608 |
"DBH" DOUBLE PRECISION NULL,
|
|
| 609 |
"resprout" BOOLEAN DEFAULT E'0',
|
|
| 604 |
"stemX" DOUBLE PRECISION, |
|
| 605 |
"stemY" DOUBLE PRECISION, |
|
| 606 |
"dgh" DOUBLE PRECISION, |
|
| 607 |
"Height" DOUBLE PRECISION, |
|
| 608 |
"DBH" DOUBLE PRECISION, |
|
| 609 |
"resprout" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 610 | 610 |
"userDefined1" VARCHAR(255), |
| 611 | 611 |
"userDefined2" VARCHAR(255), |
| 612 | 612 |
"userDefined3" VARCHAR(255), |
| ... | ... | |
| 645 | 645 |
"fieldName" VARCHAR(50), |
| 646 | 646 |
"listValue" VARCHAR(255), |
| 647 | 647 |
"valueDesc" TEXT, |
| 648 |
"sortOrd" DOUBLE PRECISION NULL,
|
|
| 648 |
"sortOrd" DOUBLE PRECISION, |
|
| 649 | 649 |
"entry_displayValue" VARCHAR(255), |
| 650 | 650 |
"entry_description" TEXT, |
| 651 | 651 |
"entry_hideValue" INTEGER, |
| 652 |
"entry_sortingOrder" DOUBLE PRECISION NULL,
|
|
| 653 |
"entry_newRecord" BOOLEAN DEFAULT E'0',
|
|
| 654 |
"entry_obsoleteValue" BOOLEAN DEFAULT E'0',
|
|
| 652 |
"entry_sortingOrder" DOUBLE PRECISION, |
|
| 653 |
"entry_newRecord" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 654 |
"entry_obsoleteValue" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 655 | 655 |
"entry_obsoleteUseInstead" VARCHAR(255), |
| 656 | 656 |
PRIMARY KEY ("fieldList_ID")
|
| 657 | 657 |
); |
| ... | ... | |
| 801 | 801 |
"dateEntered" TIMESTAMP DEFAULT E'=Now()', |
| 802 | 802 |
"COVERMETHOD_ID" INTEGER, |
| 803 | 803 |
"coverDispersion" VARCHAR(30), |
| 804 |
"autoTaxonCover" BOOLEAN DEFAULT E'0',
|
|
| 804 |
"autoTaxonCover" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 805 | 805 |
"STRATUMMETHOD_ID" INTEGER, |
| 806 | 806 |
"methodNarrative" TEXT, |
| 807 |
"taxonObservationArea" DOUBLE PRECISION NULL,
|
|
| 808 |
"stemSizeLimit" DOUBLE PRECISION NULL,
|
|
| 809 |
"stemObservationArea" DOUBLE PRECISION NULL,
|
|
| 807 |
"taxonObservationArea" DOUBLE PRECISION, |
|
| 808 |
"stemSizeLimit" DOUBLE PRECISION, |
|
| 809 |
"stemObservationArea" DOUBLE PRECISION, |
|
| 810 | 810 |
"stemSampleMethod" VARCHAR(30), |
| 811 | 811 |
"originalData" TEXT, |
| 812 | 812 |
"effortLevel" VARCHAR(30), |
| ... | ... | |
| 821 | 821 |
"representativeness" VARCHAR(255), |
| 822 | 822 |
"standMaturity" VARCHAR(255), |
| 823 | 823 |
"successionalStatus" TEXT, |
| 824 |
"basalArea" DOUBLE PRECISION NULL,
|
|
| 824 |
"basalArea" DOUBLE PRECISION, |
|
| 825 | 825 |
"hydrologicRegime" VARCHAR(255), |
| 826 | 826 |
"soilMoistureRegime" VARCHAR(255), |
| 827 | 827 |
"soilDrainage" VARCHAR(255), |
| 828 | 828 |
"waterSalinity" VARCHAR(255), |
| 829 |
"waterDepth" DOUBLE PRECISION NULL,
|
|
| 830 |
"shoreDistance" DOUBLE PRECISION NULL,
|
|
| 831 |
"soilDepth" DOUBLE PRECISION NULL,
|
|
| 832 |
"organicDepth" DOUBLE PRECISION NULL,
|
|
| 829 |
"waterDepth" DOUBLE PRECISION, |
|
| 830 |
"shoreDistance" DOUBLE PRECISION, |
|
| 831 |
"soilDepth" DOUBLE PRECISION, |
|
| 832 |
"organicDepth" DOUBLE PRECISION, |
|
| 833 | 833 |
"SOILTAXON_ID" INTEGER, |
| 834 | 834 |
"soilTaxonSrc" VARCHAR(200), |
| 835 | 835 |
"soilTaxonComplex" VARCHAR(255), |
| 836 | 836 |
"soilMapUnit" VARCHAR(255), |
| 837 |
"percentBedRock" DOUBLE PRECISION NULL,
|
|
| 838 |
"percentRockGravel" DOUBLE PRECISION NULL,
|
|
| 839 |
"percentWood" DOUBLE PRECISION NULL,
|
|
| 840 |
"percentLitter" DOUBLE PRECISION NULL,
|
|
| 841 |
"percentBareSoil" DOUBLE PRECISION NULL,
|
|
| 842 |
"percentWater" DOUBLE PRECISION NULL,
|
|
| 843 |
"percentOther" DOUBLE PRECISION NULL,
|
|
| 837 |
"percentBedRock" DOUBLE PRECISION, |
|
| 838 |
"percentRockGravel" DOUBLE PRECISION, |
|
| 839 |
"percentWood" DOUBLE PRECISION, |
|
| 840 |
"percentLitter" DOUBLE PRECISION, |
|
| 841 |
"percentBareSoil" DOUBLE PRECISION, |
|
| 842 |
"percentWater" DOUBLE PRECISION, |
|
| 843 |
"percentOther" DOUBLE PRECISION, |
|
| 844 | 844 |
"nameOther" VARCHAR(30), |
| 845 |
"treeHt" DOUBLE PRECISION NULL,
|
|
| 846 |
"shrubHt" DOUBLE PRECISION NULL,
|
|
| 847 |
"fieldHt" DOUBLE PRECISION NULL,
|
|
| 848 |
"nonvascularHt" DOUBLE PRECISION NULL,
|
|
| 849 |
"submergedHt" DOUBLE PRECISION NULL,
|
|
| 850 |
"treeCover" DOUBLE PRECISION NULL,
|
|
| 851 |
"shrubCover" DOUBLE PRECISION NULL,
|
|
| 852 |
"fieldCover" DOUBLE PRECISION NULL,
|
|
| 853 |
"nonvascularCover" DOUBLE PRECISION NULL,
|
|
| 854 |
"floatingCover" DOUBLE PRECISION NULL,
|
|
| 855 |
"submergedCover" DOUBLE PRECISION NULL,
|
|
| 845 |
"treeHt" DOUBLE PRECISION, |
|
| 846 |
"shrubHt" DOUBLE PRECISION, |
|
| 847 |
"fieldHt" DOUBLE PRECISION, |
|
| 848 |
"nonvascularHt" DOUBLE PRECISION, |
|
| 849 |
"submergedHt" DOUBLE PRECISION, |
|
| 850 |
"treeCover" DOUBLE PRECISION, |
|
| 851 |
"shrubCover" DOUBLE PRECISION, |
|
| 852 |
"fieldCover" DOUBLE PRECISION, |
|
| 853 |
"nonvascularCover" DOUBLE PRECISION, |
|
| 854 |
"floatingCover" DOUBLE PRECISION, |
|
| 855 |
"submergedCover" DOUBLE PRECISION, |
|
| 856 | 856 |
"dominantStratum" VARCHAR(40), |
| 857 | 857 |
"growthform1Type" VARCHAR(40), |
| 858 | 858 |
"growthform2Type" VARCHAR(40), |
| 859 | 859 |
"growthform3Type" VARCHAR(40), |
| 860 |
"growthform1Cover" DOUBLE PRECISION NULL,
|
|
| 861 |
"growthform2Cover" DOUBLE PRECISION NULL,
|
|
| 862 |
"growthform3Cover" DOUBLE PRECISION NULL,
|
|
| 863 |
"totalCover" DOUBLE PRECISION NULL,
|
|
| 860 |
"growthform1Cover" DOUBLE PRECISION, |
|
| 861 |
"growthform2Cover" DOUBLE PRECISION, |
|
| 862 |
"growthform3Cover" DOUBLE PRECISION, |
|
| 863 |
"totalCover" DOUBLE PRECISION, |
|
| 864 | 864 |
"accessionCode" VARCHAR(100), |
| 865 |
"notesPublic" BOOLEAN DEFAULT E'0',
|
|
| 866 |
"notesMgt" BOOLEAN DEFAULT E'0',
|
|
| 867 |
"revisions" BOOLEAN DEFAULT E'0',
|
|
| 865 |
"notesPublic" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 866 |
"notesMgt" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 867 |
"revisions" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 868 | 868 |
"cust_cvs_CowardinSystem" VARCHAR(100), |
| 869 |
"cust_cvs_mcnab_LFI_asp" DOUBLE PRECISION NULL,
|
|
| 870 |
"cust_cvs_mcnab_LFI_45" DOUBLE PRECISION NULL,
|
|
| 871 |
"cust_cvs_mcnab_LFI_90" DOUBLE PRECISION NULL,
|
|
| 872 |
"cust_cvs_mcnab_LFI_135" DOUBLE PRECISION NULL,
|
|
| 873 |
"cust_cvs_mcnab_LFI_180" DOUBLE PRECISION NULL,
|
|
| 874 |
"cust_cvs_mcnab_LFI_225" DOUBLE PRECISION NULL,
|
|
| 875 |
"cust_cvs_mcnab_LFI_270" DOUBLE PRECISION NULL,
|
|
| 876 |
"cust_cvs_mcnab_LFI_315" DOUBLE PRECISION NULL,
|
|
| 877 |
"cust_cvs_mcnab_TSI_asp" DOUBLE PRECISION NULL,
|
|
| 878 |
"cust_cvs_mcnab_TSI_45" DOUBLE PRECISION NULL,
|
|
| 879 |
"cust_cvs_mcnab_TSI_90" DOUBLE PRECISION NULL,
|
|
| 880 |
"cust_cvs_mcnab_TSI_135" DOUBLE PRECISION NULL,
|
|
| 881 |
"cust_cvs_mcnab_TSI_180" DOUBLE PRECISION NULL,
|
|
| 882 |
"cust_cvs_mcnab_TSI_225" DOUBLE PRECISION NULL,
|
|
| 883 |
"cust_cvs_mcnab_TSI_270" DOUBLE PRECISION NULL,
|
|
| 884 |
"cust_cvs_mcnab_TSI_315" DOUBLE PRECISION NULL,
|
|
| 885 |
"cust_cvs_mcnab_LFI" DOUBLE PRECISION NULL,
|
|
| 886 |
"cust_cvs_mcnab_TSI" DOUBLE PRECISION NULL,
|
|
| 869 |
"cust_cvs_mcnab_LFI_asp" DOUBLE PRECISION, |
|
| 870 |
"cust_cvs_mcnab_LFI_45" DOUBLE PRECISION, |
|
| 871 |
"cust_cvs_mcnab_LFI_90" DOUBLE PRECISION, |
|
| 872 |
"cust_cvs_mcnab_LFI_135" DOUBLE PRECISION, |
|
| 873 |
"cust_cvs_mcnab_LFI_180" DOUBLE PRECISION, |
|
| 874 |
"cust_cvs_mcnab_LFI_225" DOUBLE PRECISION, |
|
| 875 |
"cust_cvs_mcnab_LFI_270" DOUBLE PRECISION, |
|
| 876 |
"cust_cvs_mcnab_LFI_315" DOUBLE PRECISION, |
|
| 877 |
"cust_cvs_mcnab_TSI_asp" DOUBLE PRECISION, |
|
| 878 |
"cust_cvs_mcnab_TSI_45" DOUBLE PRECISION, |
|
| 879 |
"cust_cvs_mcnab_TSI_90" DOUBLE PRECISION, |
|
| 880 |
"cust_cvs_mcnab_TSI_135" DOUBLE PRECISION, |
|
| 881 |
"cust_cvs_mcnab_TSI_180" DOUBLE PRECISION, |
|
| 882 |
"cust_cvs_mcnab_TSI_225" DOUBLE PRECISION, |
|
| 883 |
"cust_cvs_mcnab_TSI_270" DOUBLE PRECISION, |
|
| 884 |
"cust_cvs_mcnab_TSI_315" DOUBLE PRECISION, |
|
| 885 |
"cust_cvs_mcnab_LFI" DOUBLE PRECISION, |
|
| 886 |
"cust_cvs_mcnab_TSI" DOUBLE PRECISION, |
|
| 887 | 887 |
"cust_cvs_LeafType" VARCHAR(100), |
| 888 | 888 |
"cust_cvs_LeafPhenology" VARCHAR(100), |
| 889 |
"cust_cvs_CanopyHeight" DOUBLE PRECISION NULL,
|
|
| 889 |
"cust_cvs_CanopyHeight" DOUBLE PRECISION, |
|
| 890 | 890 |
"cust_cvs_compassType" VARCHAR(10), |
| 891 | 891 |
"cust_cvs_LocationSource" VARCHAR(50), |
| 892 |
"cust_cvs_GPSLocationX" DOUBLE PRECISION NULL,
|
|
| 893 |
"cust_cvs_GPSLocationY" DOUBLE PRECISION NULL,
|
|
| 892 |
"cust_cvs_GPSLocationX" DOUBLE PRECISION, |
|
| 893 |
"cust_cvs_GPSLocationY" DOUBLE PRECISION, |
|
| 894 | 894 |
"cust_cvs_Ownership" VARCHAR(100), |
| 895 | 895 |
"cust_cvs_taxaRichness" INTEGER, |
| 896 |
"cust_cvs_lengthSoilProbe" DOUBLE PRECISION NULL,
|
|
| 897 |
"cust_cvs_percentHistosol" DOUBLE PRECISION NULL,
|
|
| 898 |
"cust_cvs_percentBedrock" DOUBLE PRECISION NULL,
|
|
| 899 |
"cust_cvs_percentBoulder" DOUBLE PRECISION NULL,
|
|
| 900 |
"cust_cvs_percentGravelCobble" DOUBLE PRECISION NULL,
|
|
| 901 |
"cust_cvs_percentMineralSoil" DOUBLE PRECISION NULL,
|
|
| 902 |
"cust_cvs_percentCWD" DOUBLE PRECISION NULL,
|
|
| 903 |
"cust_cvs_percentFWD" DOUBLE PRECISION NULL,
|
|
| 904 |
"cust_cvs_percentDuff" DOUBLE PRECISION NULL,
|
|
| 905 |
"cust_cvs_percentLitter" DOUBLE PRECISION NULL,
|
|
| 906 |
"cust_cvs_percentNonVasc" DOUBLE PRECISION NULL,
|
|
| 907 |
"cust_cvs_percentWater" DOUBLE PRECISION NULL,
|
|
| 908 |
"cust_cvs_percentOther" DOUBLE PRECISION NULL,
|
|
| 896 |
"cust_cvs_lengthSoilProbe" DOUBLE PRECISION, |
|
| 897 |
"cust_cvs_percentHistosol" DOUBLE PRECISION, |
|
| 898 |
"cust_cvs_percentBedrock" DOUBLE PRECISION, |
|
| 899 |
"cust_cvs_percentBoulder" DOUBLE PRECISION, |
|
| 900 |
"cust_cvs_percentGravelCobble" DOUBLE PRECISION, |
|
| 901 |
"cust_cvs_percentMineralSoil" DOUBLE PRECISION, |
|
| 902 |
"cust_cvs_percentCWD" DOUBLE PRECISION, |
|
| 903 |
"cust_cvs_percentFWD" DOUBLE PRECISION, |
|
| 904 |
"cust_cvs_percentDuff" DOUBLE PRECISION, |
|
| 905 |
"cust_cvs_percentLitter" DOUBLE PRECISION, |
|
| 906 |
"cust_cvs_percentNonVasc" DOUBLE PRECISION, |
|
| 907 |
"cust_cvs_percentWater" DOUBLE PRECISION, |
|
| 908 |
"cust_cvs_percentOther" DOUBLE PRECISION, |
|
| 909 | 909 |
"cust_cvs_percentOtherName" VARCHAR(80), |
| 910 | 910 |
"cust_cvs_samplingLevel" INTEGER, |
| 911 | 911 |
"cust_cvs_postDsgPoly" VARCHAR(255), |
| 912 | 912 |
"cust_cvs_stemsSampled" INTEGER, |
| 913 | 913 |
"cust_cvs_stemSamplingNarrative" TEXT, |
| 914 | 914 |
"cust_eep_plotLastPlantedDate" TIMESTAMP, |
| 915 |
"cust_eep_plotNotSampled" BOOLEAN DEFAULT E'0',
|
|
| 915 |
"cust_eep_plotNotSampled" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 916 | 916 |
"cust_eep_plotNotSampledReason" TEXT, |
| 917 |
"entry_ares_herbs" DOUBLE PRECISION NULL,
|
|
| 918 |
"entry_ares_trees" DOUBLE PRECISION NULL,
|
|
| 917 |
"entry_ares_herbs" DOUBLE PRECISION, |
|
| 918 |
"entry_ares_trees" DOUBLE PRECISION, |
|
| 919 | 919 |
"entry_currentLandUse" TEXT, |
| 920 | 920 |
"entry_depth" INTEGER, |
| 921 | 921 |
"entry_elevationUnits" INTEGER, |
| 922 | 922 |
"entry_formerLandUse" TEXT, |
| 923 | 923 |
"entry_identificationNarrative" TEXT, |
| 924 | 924 |
"entry_IntensiveModuleList" VARCHAR(10), |
| 925 |
"entry_moduleSize_Overall" DOUBLE PRECISION NULL,
|
|
| 926 |
"entry_moduleSizeX" DOUBLE PRECISION NULL,
|
|
| 927 |
"entry_moduleSizeY" DOUBLE PRECISION NULL,
|
|
| 925 |
"entry_moduleSize_Overall" DOUBLE PRECISION, |
|
| 926 |
"entry_moduleSizeX" DOUBLE PRECISION, |
|
| 927 |
"entry_moduleSizeY" DOUBLE PRECISION, |
|
| 928 | 928 |
"entry_photosTaken" VARCHAR(255), |
| 929 | 929 |
"entry_physClass" VARCHAR(100), |
| 930 | 930 |
"entry_plot_X" INTEGER, |
| ... | ... | |
| 957 | 957 |
"ROLE_ID" INTEGER NOT NULL, |
| 958 | 958 |
"contributionDate" TIMESTAMP, |
| 959 | 959 |
"dba_src_ID" INTEGER, |
| 960 |
"unsure" BOOLEAN DEFAULT E'0',
|
|
| 960 |
"unsure" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 961 | 961 |
PRIMARY KEY ("OBSERVATIONCONTRIBUTOR_ID")
|
| 962 | 962 |
); |
| 963 | 963 |
|
| ... | ... | |
| 1032 | 1032 |
CREATE TABLE "place" ( |
| 1033 | 1033 |
"PLOTPLACE_ID" SERIAL NOT NULL, |
| 1034 | 1034 |
"PLOT_ID" INTEGER NOT NULL, |
| 1035 |
"calculated" BOOLEAN DEFAULT E'0',
|
|
| 1035 |
"calculated" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1036 | 1036 |
"NAMEDPLACE_ID" INTEGER NOT NULL, |
| 1037 | 1037 |
"dba_src_ID" INTEGER, |
| 1038 | 1038 |
PRIMARY KEY ("PLOTPLACE_ID")
|
| ... | ... | |
| 1069 | 1069 |
"denorm_quadName" VARCHAR(255), |
| 1070 | 1070 |
"denorm_hybridX" VARCHAR(50), |
| 1071 | 1071 |
"taxonLevel" VARCHAR(255), |
| 1072 |
"taxonRank" DOUBLE PRECISION NULL,
|
|
| 1072 |
"taxonRank" DOUBLE PRECISION, |
|
| 1073 | 1073 |
"lowestParentName" VARCHAR(255), |
| 1074 | 1074 |
"lowestParentConcept_ID" INTEGER, |
| 1075 |
"lowestChildRank" DOUBLE PRECISION NULL,
|
|
| 1075 |
"lowestChildRank" DOUBLE PRECISION, |
|
| 1076 | 1076 |
"commonName" VARCHAR(255), |
| 1077 | 1077 |
"growthForm_short" VARCHAR(255), |
| 1078 | 1078 |
"woody" VARCHAR(255), |
| ... | ... | |
| 1186 | 1186 |
"authorPlotCode" VARCHAR(255) NOT NULL, |
| 1187 | 1187 |
"reference_ID" INTEGER, |
| 1188 | 1188 |
"PARENT_ID" INTEGER, |
| 1189 |
"plotObsolete" BOOLEAN DEFAULT E'0',
|
|
| 1189 |
"plotObsolete" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1190 | 1190 |
"REPLACEMENTPLOT_ID" INTEGER, |
| 1191 |
"realLatitude" DOUBLE PRECISION NULL,
|
|
| 1192 |
"realLongitude" DOUBLE PRECISION NULL,
|
|
| 1193 |
"locationAccuracy" DOUBLE PRECISION NULL,
|
|
| 1191 |
"realLatitude" DOUBLE PRECISION, |
|
| 1192 |
"realLongitude" DOUBLE PRECISION, |
|
| 1193 |
"locationAccuracy" DOUBLE PRECISION, |
|
| 1194 | 1194 |
"confidentialityStatus" INTEGER, |
| 1195 | 1195 |
"confidentialityFieldsBlocked" INTEGER, |
| 1196 | 1196 |
"confidentialityReason" VARCHAR(200), |
| 1197 |
"latitude" DOUBLE PRECISION NULL,
|
|
| 1198 |
"longitude" DOUBLE PRECISION NULL,
|
|
| 1197 |
"latitude" DOUBLE PRECISION, |
|
| 1198 |
"longitude" DOUBLE PRECISION, |
|
| 1199 | 1199 |
"authorCoordinateType" VARCHAR(100), |
| 1200 | 1200 |
"authorCoordinateUnits" VARCHAR(100), |
| 1201 | 1201 |
"authorE" VARCHAR(20), |
| ... | ... | |
| 1205 | 1205 |
"authorLocation" VARCHAR(200), |
| 1206 | 1206 |
"locationNarrative" TEXT, |
| 1207 | 1207 |
"plotRationaleNarrative" TEXT, |
| 1208 |
"azimuth" DOUBLE PRECISION NULL,
|
|
| 1208 |
"azimuth" DOUBLE PRECISION, |
|
| 1209 | 1209 |
"dsgpoly" TEXT, |
| 1210 | 1210 |
"shape" VARCHAR(50), |
| 1211 |
"area" DOUBLE PRECISION NULL,
|
|
| 1211 |
"area" DOUBLE PRECISION, |
|
| 1212 | 1212 |
"standSize" VARCHAR(50), |
| 1213 | 1213 |
"placementMethod" VARCHAR(50), |
| 1214 |
"permanence" BOOLEAN DEFAULT E'0',
|
|
| 1214 |
"permanence" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1215 | 1215 |
"layoutNarrative" TEXT, |
| 1216 |
"elevation" DOUBLE PRECISION NULL,
|
|
| 1217 |
"elevationAccuracy" DOUBLE PRECISION NULL,
|
|
| 1218 |
"elevationRange" DOUBLE PRECISION NULL,
|
|
| 1219 |
"slopeAspect" DOUBLE PRECISION NULL,
|
|
| 1220 |
"minSlopeAspect" DOUBLE PRECISION NULL,
|
|
| 1221 |
"maxSlopeAspect" DOUBLE PRECISION NULL,
|
|
| 1222 |
"slopeGradient" DOUBLE PRECISION NULL,
|
|
| 1223 |
"minSlopeGradient" DOUBLE PRECISION NULL,
|
|
| 1224 |
"maxSlopeGradient" DOUBLE PRECISION NULL,
|
|
| 1216 |
"elevation" DOUBLE PRECISION, |
|
| 1217 |
"elevationAccuracy" DOUBLE PRECISION, |
|
| 1218 |
"elevationRange" DOUBLE PRECISION, |
|
| 1219 |
"slopeAspect" DOUBLE PRECISION, |
|
| 1220 |
"minSlopeAspect" DOUBLE PRECISION, |
|
| 1221 |
"maxSlopeAspect" DOUBLE PRECISION, |
|
| 1222 |
"slopeGradient" DOUBLE PRECISION, |
|
| 1223 |
"minSlopeGradient" DOUBLE PRECISION, |
|
| 1224 |
"maxSlopeGradient" DOUBLE PRECISION, |
|
| 1225 | 1225 |
"topoPosition" VARCHAR(255), |
| 1226 | 1226 |
"landform" VARCHAR(255), |
| 1227 | 1227 |
"surficialDeposits" VARCHAR(255), |
| ... | ... | |
| 1235 | 1235 |
"submitter_givenname" VARCHAR(100), |
| 1236 | 1236 |
"submitter_email" VARCHAR(100), |
| 1237 | 1237 |
"accessionCode" VARCHAR(100), |
| 1238 |
"notesPublic" BOOLEAN DEFAULT E'0',
|
|
| 1239 |
"notesMgt" BOOLEAN DEFAULT E'0',
|
|
| 1240 |
"revisions" BOOLEAN DEFAULT E'0',
|
|
| 1238 |
"notesPublic" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1239 |
"notesMgt" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1240 |
"revisions" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1241 | 1241 |
"cust_eep_reach" VARCHAR(255), |
| 1242 | 1242 |
"dba_src_ID" INTEGER, |
| 1243 | 1243 |
UNIQUE ("authorPlotCode"),
|
| ... | ... | |
| 1261 | 1261 |
"entry_projectCode" VARCHAR(10), |
| 1262 | 1262 |
"entry_projectCodeSource" VARCHAR(50), |
| 1263 | 1263 |
"entry_contactDetails" TEXT, |
| 1264 |
"entry_eep_length" DOUBLE PRECISION NULL,
|
|
| 1265 |
"entry_eep_width" DOUBLE PRECISION NULL,
|
|
| 1266 |
"entry_eep_area" DOUBLE PRECISION NULL,
|
|
| 1264 |
"entry_eep_length" DOUBLE PRECISION, |
|
| 1265 |
"entry_eep_width" DOUBLE PRECISION, |
|
| 1266 |
"entry_eep_area" DOUBLE PRECISION, |
|
| 1267 | 1267 |
"entry_eep_requiredPlots" INTEGER, |
| 1268 | 1268 |
"entry_eep_projectType" INTEGER DEFAULT 1, |
| 1269 | 1269 |
"entry_riverBasin_np_ID" INTEGER, |
| ... | ... | |
| 1327 | 1327 |
"additionalInfo" TEXT, |
| 1328 | 1328 |
"accessionCode" VARCHAR(100), |
| 1329 | 1329 |
"dba_src_ID" INTEGER, |
| 1330 |
"cust_cvs_IsTaxonomicManual" BOOLEAN DEFAULT E'0',
|
|
| 1330 |
"cust_cvs_IsTaxonomicManual" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1331 | 1331 |
"cust_cvs_unparsedAuthors" TEXT, |
| 1332 | 1332 |
"cust_cvs_referenceJournalName" VARCHAR(200), |
| 1333 | 1333 |
PRIMARY KEY ("reference_ID")
|
| ... | ... | |
| 1411 | 1411 |
"SOILOBS_ID" SERIAL NOT NULL, |
| 1412 | 1412 |
"OBSERVATION_ID" INTEGER NOT NULL, |
| 1413 | 1413 |
"soilHorizon" VARCHAR(15) NOT NULL, |
| 1414 |
"soilDepthTop" DOUBLE PRECISION NULL,
|
|
| 1415 |
"soilDepthBottom" DOUBLE PRECISION NULL,
|
|
| 1414 |
"soilDepthTop" DOUBLE PRECISION, |
|
| 1415 |
"soilDepthBottom" DOUBLE PRECISION, |
|
| 1416 | 1416 |
"soilColor" VARCHAR(30), |
| 1417 |
"soilOrganic" DOUBLE PRECISION NULL,
|
|
| 1417 |
"soilOrganic" DOUBLE PRECISION, |
|
| 1418 | 1418 |
"soilTexture" VARCHAR(50), |
| 1419 |
"soilSand" DOUBLE PRECISION NULL,
|
|
| 1420 |
"soilSilt" DOUBLE PRECISION NULL,
|
|
| 1421 |
"soilClay" DOUBLE PRECISION NULL,
|
|
| 1422 |
"soilCoarse" DOUBLE PRECISION NULL,
|
|
| 1423 |
"soilPH" DOUBLE PRECISION NULL,
|
|
| 1424 |
"exchangeCapacity" DOUBLE PRECISION NULL,
|
|
| 1425 |
"baseSaturation" DOUBLE PRECISION NULL,
|
|
| 1419 |
"soilSand" DOUBLE PRECISION, |
|
| 1420 |
"soilSilt" DOUBLE PRECISION, |
|
| 1421 |
"soilClay" DOUBLE PRECISION, |
|
| 1422 |
"soilCoarse" DOUBLE PRECISION, |
|
| 1423 |
"soilPH" DOUBLE PRECISION, |
|
| 1424 |
"exchangeCapacity" DOUBLE PRECISION, |
|
| 1425 |
"baseSaturation" DOUBLE PRECISION, |
|
| 1426 | 1426 |
"soilDescription" TEXT, |
| 1427 | 1427 |
"cust_cvs_collectionName" VARCHAR(50), |
| 1428 | 1428 |
"cust_cvs_Lab" VARCHAR(10), |
| 1429 |
"cust_cvs_N" DOUBLE PRECISION NULL,
|
|
| 1430 |
"cust_cvs_S" DOUBLE PRECISION NULL,
|
|
| 1431 |
"cust_cvs_P" DOUBLE PRECISION NULL,
|
|
| 1432 |
"cust_cvs_Ca_ppm" DOUBLE PRECISION NULL,
|
|
| 1433 |
"cust_cvs_Mg_ppm" DOUBLE PRECISION NULL,
|
|
| 1434 |
"cust_cvs_K_ppm" DOUBLE PRECISION NULL,
|
|
| 1435 |
"cust_cvs_Na_ppm" DOUBLE PRECISION NULL,
|
|
| 1436 |
"cust_cvs_percent_Ca" DOUBLE PRECISION NULL,
|
|
| 1437 |
"cust_cvs_percent_Mg" DOUBLE PRECISION NULL,
|
|
| 1438 |
"cust_cvs_percent_K" DOUBLE PRECISION NULL,
|
|
| 1439 |
"cust_cvs_percent_Na" DOUBLE PRECISION NULL,
|
|
| 1440 |
"cust_cvs_percent_Othr" DOUBLE PRECISION NULL,
|
|
| 1441 |
"cust_cvs_percent_H" DOUBLE PRECISION NULL,
|
|
| 1442 |
"cust_cvs_B_ppm" DOUBLE PRECISION NULL,
|
|
| 1443 |
"cust_cvs_Fe_ppm" DOUBLE PRECISION NULL,
|
|
| 1444 |
"cust_cvs_Mn_ppm" DOUBLE PRECISION NULL,
|
|
| 1445 |
"cust_cvs_Cu_ppm" DOUBLE PRECISION NULL,
|
|
| 1446 |
"cust_cvs_Zn_ppm" DOUBLE PRECISION NULL,
|
|
| 1447 |
"cust_cvs_Al_ppm" DOUBLE PRECISION NULL,
|
|
| 1448 |
"cust_cvs_Density" DOUBLE PRECISION NULL,
|
|
| 1449 |
"cust_cvs_Ca_over_Mg_ppm" DOUBLE PRECISION NULL,
|
|
| 1429 |
"cust_cvs_N" DOUBLE PRECISION, |
|
| 1430 |
"cust_cvs_S" DOUBLE PRECISION, |
|
| 1431 |
"cust_cvs_P" DOUBLE PRECISION, |
|
| 1432 |
"cust_cvs_Ca_ppm" DOUBLE PRECISION, |
|
| 1433 |
"cust_cvs_Mg_ppm" DOUBLE PRECISION, |
|
| 1434 |
"cust_cvs_K_ppm" DOUBLE PRECISION, |
|
| 1435 |
"cust_cvs_Na_ppm" DOUBLE PRECISION, |
|
| 1436 |
"cust_cvs_percent_Ca" DOUBLE PRECISION, |
|
| 1437 |
"cust_cvs_percent_Mg" DOUBLE PRECISION, |
|
| 1438 |
"cust_cvs_percent_K" DOUBLE PRECISION, |
|
| 1439 |
"cust_cvs_percent_Na" DOUBLE PRECISION, |
|
| 1440 |
"cust_cvs_percent_Othr" DOUBLE PRECISION, |
|
| 1441 |
"cust_cvs_percent_H" DOUBLE PRECISION, |
|
| 1442 |
"cust_cvs_B_ppm" DOUBLE PRECISION, |
|
| 1443 |
"cust_cvs_Fe_ppm" DOUBLE PRECISION, |
|
| 1444 |
"cust_cvs_Mn_ppm" DOUBLE PRECISION, |
|
| 1445 |
"cust_cvs_Cu_ppm" DOUBLE PRECISION, |
|
| 1446 |
"cust_cvs_Zn_ppm" DOUBLE PRECISION, |
|
| 1447 |
"cust_cvs_Al_ppm" DOUBLE PRECISION, |
|
| 1448 |
"cust_cvs_Density" DOUBLE PRECISION, |
|
| 1449 |
"cust_cvs_Ca_over_Mg_ppm" DOUBLE PRECISION, |
|
| 1450 | 1450 |
"dba_src_ID" INTEGER, |
| 1451 | 1451 |
PRIMARY KEY ("SOILOBS_ID")
|
| 1452 | 1452 |
); |
| ... | ... | |
| 1478 | 1478 |
CREATE TABLE "stemCount" ( |
| 1479 | 1479 |
"STEMCOUNT_ID" SERIAL NOT NULL, |
| 1480 | 1480 |
"TAXONIMPORTANCE_ID" INTEGER NOT NULL, |
| 1481 |
"stemDiameter" DOUBLE PRECISION NULL,
|
|
| 1482 |
"stemDiameterAccuracy" DOUBLE PRECISION NULL,
|
|
| 1483 |
"stemHeight" DOUBLE PRECISION NULL,
|
|
| 1484 |
"stemHeightAccuracy" DOUBLE PRECISION NULL,
|
|
| 1481 |
"stemDiameter" DOUBLE PRECISION, |
|
| 1482 |
"stemDiameterAccuracy" DOUBLE PRECISION, |
|
| 1483 |
"stemHeight" DOUBLE PRECISION, |
|
| 1484 |
"stemHeightAccuracy" DOUBLE PRECISION, |
|
| 1485 | 1485 |
"stemCount" INTEGER NOT NULL, |
| 1486 |
"stemTaxonArea" DOUBLE PRECISION NULL,
|
|
| 1486 |
"stemTaxonArea" DOUBLE PRECISION, |
|
| 1487 | 1487 |
"dba_src_ID" INTEGER, |
| 1488 |
"cust_cvs_ddh" DOUBLE PRECISION NULL,
|
|
| 1489 |
"cust_cvs_ddhAccuracy" DOUBLE PRECISION NULL,
|
|
| 1488 |
"cust_cvs_ddh" DOUBLE PRECISION, |
|
| 1489 |
"cust_cvs_ddhAccuracy" DOUBLE PRECISION, |
|
| 1490 | 1490 |
"cust_cvs_isPlanted" VARCHAR(2), |
| 1491 |
"cust_cvs_subsamplingFactor" DOUBLE PRECISION NULL,
|
|
| 1491 |
"cust_cvs_subsamplingFactor" DOUBLE PRECISION, |
|
| 1492 | 1492 |
"entry_herbLineID" INTEGER, |
| 1493 | 1493 |
"entry_treeLineID" INTEGER, |
| 1494 | 1494 |
"entry_recordCount" INTEGER, |
| 1495 |
"entry_sortOrder" DOUBLE PRECISION NULL,
|
|
| 1495 |
"entry_sortOrder" DOUBLE PRECISION, |
|
| 1496 | 1496 |
PRIMARY KEY ("STEMCOUNT_ID")
|
| 1497 | 1497 |
); |
| 1498 | 1498 |
|
| ... | ... | |
| 1506 | 1506 |
"STEMLOCATION_ID" SERIAL NOT NULL, |
| 1507 | 1507 |
"STEMCOUNT_ID" INTEGER NOT NULL, |
| 1508 | 1508 |
"stemCode" VARCHAR(20), |
| 1509 |
"stemXPosition" DOUBLE PRECISION NULL,
|
|
| 1510 |
"stemYPosition" DOUBLE PRECISION NULL,
|
|
| 1509 |
"stemXPosition" DOUBLE PRECISION, |
|
| 1510 |
"stemYPosition" DOUBLE PRECISION, |
|
| 1511 | 1511 |
"stemHealth" VARCHAR(50), |
| 1512 | 1512 |
"dba_src_ID" INTEGER, |
| 1513 | 1513 |
"cust_cvs_stemSource" VARCHAR(50), |
| 1514 | 1514 |
"cust_cvs_stemComment" TEXT, |
| 1515 |
"cust_cvs_resprout" BOOLEAN DEFAULT E'0',
|
|
| 1516 |
"entry_sortOrder" DOUBLE PRECISION NULL,
|
|
| 1515 |
"cust_cvs_resprout" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1516 |
"entry_sortOrder" DOUBLE PRECISION, |
|
| 1517 | 1517 |
PRIMARY KEY ("STEMLOCATION_ID")
|
| 1518 | 1518 |
); |
| 1519 | 1519 |
|
| ... | ... | |
| 1529 | 1529 |
"STRATUMTYPE_ID" INTEGER NOT NULL, |
| 1530 | 1530 |
"STRATUMMETHOD_ID" INTEGER, |
| 1531 | 1531 |
"stratumName" VARCHAR(30), |
| 1532 |
"stratumHeight" DOUBLE PRECISION NULL,
|
|
| 1533 |
"stratumBase" DOUBLE PRECISION NULL,
|
|
| 1534 |
"stratumCover" DOUBLE PRECISION NULL,
|
|
| 1532 |
"stratumHeight" DOUBLE PRECISION, |
|
| 1533 |
"stratumBase" DOUBLE PRECISION, |
|
| 1534 |
"stratumCover" DOUBLE PRECISION, |
|
| 1535 | 1535 |
"stratumDescription" VARCHAR(200), |
| 1536 | 1536 |
"dba_src_ID" INTEGER, |
| 1537 |
"stratumArea" DOUBLE PRECISION NULL,
|
|
| 1537 |
"stratumArea" DOUBLE PRECISION, |
|
| 1538 | 1538 |
"stratumLabel" VARCHAR(50), |
| 1539 | 1539 |
PRIMARY KEY ("STRATUM_ID")
|
| 1540 | 1540 |
); |
| ... | ... | |
| 1569 | 1569 |
"stratumName" VARCHAR(30), |
| 1570 | 1570 |
"stratumDescription" TEXT, |
| 1571 | 1571 |
"dba_src_ID" INTEGER, |
| 1572 |
"stratumOrder" DOUBLE PRECISION NULL,
|
|
| 1572 |
"stratumOrder" DOUBLE PRECISION, |
|
| 1573 | 1573 |
PRIMARY KEY ("STRATUMTYPE_ID")
|
| 1574 | 1574 |
); |
| 1575 | 1575 |
|
| ... | ... | |
| 1600 | 1600 |
"taxonImportance_ID" SERIAL NOT NULL, |
| 1601 | 1601 |
"taxonObservation_ID" INTEGER NOT NULL, |
| 1602 | 1602 |
"stratum_ID" INTEGER, |
| 1603 |
"cover" DOUBLE PRECISION NULL,
|
|
| 1604 |
"basalArea" DOUBLE PRECISION NULL,
|
|
| 1605 |
"biomass" DOUBLE PRECISION NULL,
|
|
| 1606 |
"inferenceArea" DOUBLE PRECISION NULL,
|
|
| 1603 |
"cover" DOUBLE PRECISION, |
|
| 1604 |
"basalArea" DOUBLE PRECISION, |
|
| 1605 |
"biomass" DOUBLE PRECISION, |
|
| 1606 |
"inferenceArea" DOUBLE PRECISION, |
|
| 1607 | 1607 |
"cust_cvs_StemFrequency" INTEGER, |
| 1608 | 1608 |
"dba_src_ID" INTEGER, |
| 1609 | 1609 |
"entry_herbLineID" INTEGER, |
| ... | ... | |
| 1634 | 1634 |
"ROLE_ID" INTEGER, |
| 1635 | 1635 |
"interpretationType" VARCHAR(30), |
| 1636 | 1636 |
"reference_ID" INTEGER, |
| 1637 |
"originalInterpretation" BOOLEAN NOT NULL DEFAULT E'0',
|
|
| 1638 |
"currentInterpretation" BOOLEAN NOT NULL DEFAULT E'0',
|
|
| 1637 |
"originalInterpretation" /*BOOLEAN*/INTEGER NOT NULL DEFAULT E'0',
|
|
| 1638 |
"currentInterpretation" /*BOOLEAN*/INTEGER NOT NULL DEFAULT E'0',
|
|
| 1639 | 1639 |
"taxonFit" VARCHAR(50), |
| 1640 | 1640 |
"taxonConfidence" VARCHAR(50), |
| 1641 | 1641 |
"collector_ID" INTEGER, |
| ... | ... | |
| 1645 | 1645 |
"museumAccessionNumber" VARCHAR(100), |
| 1646 | 1646 |
"groupType" VARCHAR(20), |
| 1647 | 1647 |
"notes" TEXT, |
| 1648 |
"notesPublic" BOOLEAN DEFAULT E'0',
|
|
| 1649 |
"notesMgt" BOOLEAN DEFAULT E'0',
|
|
| 1650 |
"revisions" BOOLEAN DEFAULT E'0',
|
|
| 1648 |
"notesPublic" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1649 |
"notesMgt" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1650 |
"revisions" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1651 | 1651 |
"dba_src_ID" INTEGER, |
| 1652 | 1652 |
"accessionCode" VARCHAR(100), |
| 1653 | 1653 |
PRIMARY KEY ("TAXONINTERPRETATION_ID")
|
| ... | ... | |
| 1665 | 1665 |
"authorPlantName" VARCHAR(255), |
| 1666 | 1666 |
"reference_ID" INTEGER, |
| 1667 | 1667 |
"currentTaxonInterpPlantConcept_ID" INTEGER, |
| 1668 |
"taxonInferenceArea" DOUBLE PRECISION NULL,
|
|
| 1668 |
"taxonInferenceArea" DOUBLE PRECISION, |
|
| 1669 | 1669 |
"accessionCode" VARCHAR(100), |
| 1670 | 1670 |
"dba_src_ID" INTEGER, |
| 1671 | 1671 |
"cust_cvs_corner1Presence" INTEGER, |
| ... | ... | |
| 1677 | 1677 |
"entry_treeLineID" INTEGER, |
| 1678 | 1678 |
"entry_sppID" INTEGER, |
| 1679 | 1679 |
"entry_unknownSp" VARCHAR(50), |
| 1680 |
"entry_sortOrder" DOUBLE PRECISION NULL,
|
|
| 1680 |
"entry_sortOrder" DOUBLE PRECISION, |
|
| 1681 | 1681 |
"cust_cvs_collectionFlag" VARCHAR(50), |
| 1682 | 1682 |
"taxonObservationNotes" TEXT, |
| 1683 |
"temp_taxonUpToDate" BOOLEAN DEFAULT E'0',
|
|
| 1683 |
"temp_taxonUpToDate" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1684 | 1684 |
PRIMARY KEY ("TAXONOBSERVATION_ID")
|
| 1685 | 1685 |
); |
| 1686 | 1686 |
|
| ... | ... | |
| 1786 | 1786 |
"tableModule" VARCHAR(50), |
| 1787 | 1787 |
"actualTableName" VARCHAR(50) NOT NULL, |
| 1788 | 1788 |
"entryTableName" VARCHAR(50), |
| 1789 |
"importOrder" DOUBLE PRECISION NULL,
|
|
| 1790 |
"Client" BOOLEAN DEFAULT E'0',
|
|
| 1791 |
"Backend" BOOLEAN DEFAULT E'0',
|
|
| 1792 |
"Temp" BOOLEAN DEFAULT E'0',
|
|
| 1793 |
"Archive" BOOLEAN DEFAULT E'0',
|
|
| 1789 |
"importOrder" DOUBLE PRECISION, |
|
| 1790 |
"Client" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1791 |
"Backend" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1792 |
"Temp" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1793 |
"Archive" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1794 | 1794 |
"countRecords" INTEGER, |
| 1795 | 1795 |
"countNewRecords" INTEGER, |
| 1796 | 1796 |
PRIMARY KEY ("actualTableName"),
|
| ... | ... | |
| 1817 | 1817 |
"fieldType" VARCHAR(50), |
| 1818 | 1818 |
"fieldLength" INTEGER, |
| 1819 | 1819 |
"fieldModule" VARCHAR(50), |
| 1820 |
"archiveField" BOOLEAN DEFAULT E'0',
|
|
| 1820 |
"archiveField" /*BOOLEAN*/INTEGER DEFAULT E'0',
|
|
| 1821 | 1821 |
"countNonNulls" INTEGER, |
| 1822 | 1822 |
PRIMARY KEY ("Z_field_ID"),
|
| 1823 | 1823 |
UNIQUE ("TableName", "FieldName")
|
Also available in: Unified diff
inputs/CVS/cvs-archive-2012-12-04.schema.sql: Fixed types using the steps at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Tools#MS-Access-database-MDB>