Revision 10444
Added by Aaron Marcuse-Kubitza over 11 years ago
| MySQL.schema.sql | ||
|---|---|---|
| 93 | 93 |
"coord_source" varchar(100) DEFAULT NULL, |
| 94 | 94 |
"georeferenceverificationstatus" varchar(150) DEFAULT NULL, |
| 95 | 95 |
"date_entered" text/*timestamp*/ NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 96 |
"is_duplicate" integer DEFAULT NULL, |
|
| 97 |
"deleted" integer NOT NULL DEFAULT '0', |
|
| 98 |
"deleted_reason" varchar(250) DEFAULT NULL, |
|
| 99 |
"determination_date" text/*date*/ DEFAULT NULL, |
|
| 96 |
"is_duplicate" integer DEFAULT NULL /*COMMENT '=1 if possible duplicate record; otherwise 0 or null'*/,
|
|
| 97 |
"deleted" integer NOT NULL DEFAULT '0' /*COMMENT '=1 if deleted; otherwise 0'*/,
|
|
| 98 |
"deleted_reason" varchar(250) DEFAULT NULL /*COMMENT 'Reason for flagging for deletion'*/,
|
|
| 99 |
"determination_date" text/*date*/ DEFAULT NULL /*COMMENT 'Keep this field DATE not DATETIME'*/,
|
|
| 100 | 100 |
"det_day" integer DEFAULT NULL, |
| 101 | 101 |
"det_mo" integer DEFAULT NULL, |
| 102 | 102 |
"det_yr" integer DEFAULT NULL, |
| 103 | 103 |
"deaccessioned" integer NOT NULL DEFAULT '0', |
| 104 |
"dupes" integer DEFAULT '1', |
|
| 105 |
"sheets" integer DEFAULT '1', |
|
| 106 |
"collnum_numeric" double precision DEFAULT NULL, |
|
| 107 |
"needs_label" integer DEFAULT '0', |
|
| 104 |
"dupes" integer DEFAULT '1' /*COMMENT 'Total duplicates per specimen'*/,
|
|
| 105 |
"sheets" integer DEFAULT '1' /*COMMENT 'Total sheets per specimen'*/,
|
|
| 106 |
"collnum_numeric" double precision DEFAULT NULL /*COMMENT 'Artificial decimal value based on collnumprefix, collnumber & collnumsuffix; for natural sorting'*/,
|
|
| 107 |
"needs_label" integer DEFAULT '0' /*COMMENT '1=Yes, needs label; 0=No, already labelled'*/,
|
|
| 108 | 108 |
"is_arboretum" integer DEFAULT '0', |
| 109 | 109 |
"arboretum_id" integer DEFAULT NULL, |
| 110 | 110 |
"notes_display" integer DEFAULT '0', |
| 111 | 111 |
"elev_est_display" integer DEFAULT '0', |
| 112 |
"security" integer NOT NULL DEFAULT '1', |
|
| 113 |
"temp_dbsn" integer DEFAULT NULL |
|
| 112 |
"security" integer NOT NULL DEFAULT '1' /*COMMENT '1=no security, 2=hide locality info'*/,
|
|
| 113 |
"temp_dbsn" integer DEFAULT NULL /*COMMENT 'used during bulk record transfer to update FKs; afterwards reset to NULL'*/
|
|
| 114 | 114 |
); |
| 115 | 115 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 116 | 116 |
|
| ... | ... | |
| 230 | 230 |
"Notes" varchar(2000) DEFAULT NULL, |
| 231 | 231 |
"explicitExclude" integer DEFAULT NULL, |
| 232 | 232 |
"source" varchar(250) DEFAULT NULL, |
| 233 |
"Nativity" varchar(50) DEFAULT NULL, |
|
| 233 |
"Nativity" varchar(50) DEFAULT NULL /*COMMENT 'native, introducted'*/,
|
|
| 234 | 234 |
"Endemic" varchar(25) DEFAULT NULL, |
| 235 | 235 |
"internalnotes" varchar(250) DEFAULT NULL, |
| 236 | 236 |
"InitialTimeStamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| ... | ... | |
| 842 | 842 |
"X" double precision DEFAULT NULL, |
| 843 | 843 |
"TXT" text, |
| 844 | 844 |
"PseudoTrait" integer DEFAULT '0', |
| 845 |
"Frequency" integer NOT NULL DEFAULT '5', |
|
| 845 |
"Frequency" integer NOT NULL DEFAULT '5' /*COMMENT 'Frequency of occurrence; 1 = rare... 5 = common'*/,
|
|
| 846 | 846 |
"Inherited" varchar(50) DEFAULT NULL, |
| 847 | 847 |
"Source" varchar(100) DEFAULT NULL, |
| 848 | 848 |
"Seq" integer DEFAULT NULL, |
| ... | ... | |
| 953 | 953 |
"occid" integer NOT NULL, |
| 954 | 954 |
"occidassociate" integer DEFAULT NULL, |
| 955 | 955 |
"relationship" varchar(150) NOT NULL, |
| 956 |
"identifier" varchar(250) DEFAULT NULL, |
|
| 956 |
"identifier" varchar(250) DEFAULT NULL /*COMMENT 'e.g. GUID'*/,
|
|
| 957 | 957 |
"resourceurl" varchar(250) DEFAULT NULL, |
| 958 | 958 |
"notes" varchar(250) DEFAULT NULL, |
| 959 | 959 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| ... | ... | |
| 1017 | 1017 |
"latitudedecimal" double precision DEFAULT NULL, |
| 1018 | 1018 |
"longitudedecimal" double precision DEFAULT NULL, |
| 1019 | 1019 |
"icon" varchar(250) DEFAULT NULL, |
| 1020 |
"CollType" varchar(45) NOT NULL DEFAULT 'Preserved Specimens', |
|
| 1021 |
"ManagementType" varchar(45) DEFAULT 'Snapshot', |
|
| 1020 |
"CollType" varchar(45) NOT NULL DEFAULT 'Preserved Specimens' /*COMMENT 'Preserved Specimens, General Observations, Observations'*/,
|
|
| 1021 |
"ManagementType" varchar(45) DEFAULT 'Snapshot' /*COMMENT 'Snapshot, Live Data'*/,
|
|
| 1022 | 1022 |
"PublicEdits" integer NOT NULL DEFAULT '1', |
| 1023 | 1023 |
"guidtarget" varchar(45) DEFAULT NULL, |
| 1024 | 1024 |
"rightsHolder" varchar(250) DEFAULT NULL, |
| ... | ... | |
| 1124 | 1124 |
"collid" integer NOT NULL, |
| 1125 | 1125 |
"instructions" text, |
| 1126 | 1126 |
"trainingurl" varchar(500) DEFAULT NULL, |
| 1127 |
"editorlevel" integer NOT NULL DEFAULT '0', |
|
| 1127 |
"editorlevel" integer NOT NULL DEFAULT '0' /*COMMENT '0=public, 1=public limited, 2=private'*/,
|
|
| 1128 | 1128 |
"notes" varchar(250) DEFAULT NULL, |
| 1129 | 1129 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 1130 | 1130 |
PRIMARY KEY ("omcsid"),
|
| ... | ... | |
| 1145 | 1145 |
"idomcrowdsourcequeue" integer NOT NULL, |
| 1146 | 1146 |
"omcsid" integer NOT NULL, |
| 1147 | 1147 |
"occid" integer NOT NULL, |
| 1148 |
"reviewstatus" integer NOT NULL DEFAULT '0', |
|
| 1148 |
"reviewstatus" integer NOT NULL DEFAULT '0' /*COMMENT '0=open,5=pending review, 10=closed'*/,
|
|
| 1149 | 1149 |
"uidprocessor" integer DEFAULT NULL, |
| 1150 |
"points" integer DEFAULT NULL, |
|
| 1150 |
"points" integer DEFAULT NULL /*COMMENT '0=fail, 1=minor edits, 2=no edits <default>, 3=excelled'*/,
|
|
| 1151 | 1151 |
"notes" varchar(250) DEFAULT NULL, |
| 1152 | 1152 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 1153 | 1153 |
PRIMARY KEY ("idomcrowdsourcequeue"),
|
| ... | ... | |
| 1366 | 1366 |
"FieldName" varchar(45) NOT NULL, |
| 1367 | 1367 |
"FieldValueNew" text NOT NULL, |
| 1368 | 1368 |
"FieldValueOld" text NOT NULL, |
| 1369 |
"ReviewStatus" integer NOT NULL DEFAULT '1', |
|
| 1370 |
"AppliedStatus" integer NOT NULL DEFAULT '0', |
|
| 1369 |
"ReviewStatus" integer NOT NULL DEFAULT '1' /*COMMENT '1=Open;2=Pending;3=Closed'*/,
|
|
| 1370 |
"AppliedStatus" integer NOT NULL DEFAULT '0' /*COMMENT '0=Not Applied;1=Applied'*/,
|
|
| 1371 | 1371 |
"uid" integer NOT NULL, |
| 1372 | 1372 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 1373 | 1373 |
PRIMARY KEY ("ocedid"),
|
| ... | ... | |
| 1536 | 1536 |
"occid" integer NOT NULL, |
| 1537 | 1537 |
"collid" integer NOT NULL, |
| 1538 | 1538 |
"dbpk" varchar(45) DEFAULT NULL, |
| 1539 |
"basisOfRecord" varchar(32) DEFAULT 'PreservedSpecimen', |
|
| 1540 |
"occurrenceID" varchar(255) DEFAULT NULL, |
|
| 1539 |
"basisOfRecord" varchar(32) DEFAULT 'PreservedSpecimen' /*COMMENT 'PreservedSpecimen, LivingSpecimen, HumanObservation'*/,
|
|
| 1540 |
"occurrenceID" varchar(255) DEFAULT NULL /*COMMENT 'UniqueGlobalIdentifier'*/,
|
|
| 1541 | 1541 |
"catalogNumber" varchar(32) DEFAULT NULL, |
| 1542 | 1542 |
"institutionID" varchar(255) DEFAULT NULL, |
| 1543 | 1543 |
"collectionID" varchar(255) DEFAULT NULL, |
| ... | ... | |
| 1560 | 1560 |
"dateIdentified" varchar(45) DEFAULT NULL, |
| 1561 | 1561 |
"identificationReferences" text, |
| 1562 | 1562 |
"identificationRemarks" text, |
| 1563 |
"identificationQualifier" varchar(255) DEFAULT NULL, |
|
| 1563 |
"identificationQualifier" varchar(255) DEFAULT NULL /*COMMENT 'cf, aff, etc'*/,
|
|
| 1564 | 1564 |
"typeStatus" varchar(255) DEFAULT NULL, |
| 1565 |
"recordedBy" varchar(255) DEFAULT NULL, |
|
| 1566 |
"recordNumber" varchar(45) DEFAULT NULL, |
|
| 1565 |
"recordedBy" varchar(255) DEFAULT NULL /*COMMENT 'Collector(s)'*/,
|
|
| 1566 |
"recordNumber" varchar(45) DEFAULT NULL /*COMMENT 'Collector Number'*/,
|
|
| 1567 | 1567 |
"recordedById" integer DEFAULT NULL, |
| 1568 |
"associatedCollectors" varchar(255) DEFAULT NULL, |
|
| 1568 |
"associatedCollectors" varchar(255) DEFAULT NULL /*COMMENT 'not DwC'*/,
|
|
| 1569 | 1569 |
"eventDate" text/*date*/ DEFAULT NULL, |
| 1570 | 1570 |
"year" integer DEFAULT NULL, |
| 1571 | 1571 |
"month" integer DEFAULT NULL, |
| ... | ... | |
| 1573 | 1573 |
"startDayOfYear" integer DEFAULT NULL, |
| 1574 | 1574 |
"endDayOfYear" integer DEFAULT NULL, |
| 1575 | 1575 |
"verbatimEventDate" varchar(255) DEFAULT NULL, |
| 1576 |
"habitat" text, |
|
| 1576 |
"habitat" text /*COMMENT 'Habitat, substrait, etc'*/,
|
|
| 1577 | 1577 |
"substrate" varchar(500) DEFAULT NULL, |
| 1578 | 1578 |
"fieldNotes" text, |
| 1579 | 1579 |
"fieldnumber" varchar(45) DEFAULT NULL, |
| 1580 |
"occurrenceRemarks" text, |
|
| 1580 |
"occurrenceRemarks" text /*COMMENT 'General Notes'*/,
|
|
| 1581 | 1581 |
"informationWithheld" varchar(250) DEFAULT NULL, |
| 1582 | 1582 |
"dataGeneralizations" varchar(250) DEFAULT NULL, |
| 1583 | 1583 |
"associatedOccurrences" text, |
| 1584 |
"associatedTaxa" text, |
|
| 1584 |
"associatedTaxa" text /*COMMENT 'Associated Species'*/,
|
|
| 1585 | 1585 |
"dynamicProperties" text, |
| 1586 | 1586 |
"verbatimAttributes" text, |
| 1587 |
"attributes" text, |
|
| 1588 |
"reproductiveCondition" varchar(255) DEFAULT NULL, |
|
| 1589 |
"cultivationStatus" integer DEFAULT NULL, |
|
| 1590 |
"establishmentMeans" varchar(45) DEFAULT NULL, |
|
| 1587 |
"attributes" text /*COMMENT 'Plant Description?'*/,
|
|
| 1588 |
"reproductiveCondition" varchar(255) DEFAULT NULL /*COMMENT 'Phenology: flowers, fruit, sterile'*/,
|
|
| 1589 |
"cultivationStatus" integer DEFAULT NULL /*COMMENT '0 = wild, 1 = cultivated'*/,
|
|
| 1590 |
"establishmentMeans" varchar(45) DEFAULT NULL /*COMMENT 'cultivated, invasive, escaped from captivity, wild, native'*/,
|
|
| 1591 | 1591 |
"lifeStage" varchar(45) DEFAULT NULL, |
| 1592 | 1592 |
"sex" varchar(45) DEFAULT NULL, |
| 1593 | 1593 |
"individualCount" varchar(45) DEFAULT NULL, |
| ... | ... | |
| 1598 | 1598 |
"county" varchar(255) DEFAULT NULL, |
| 1599 | 1599 |
"municipality" varchar(255) DEFAULT NULL, |
| 1600 | 1600 |
"locality" text, |
| 1601 |
"localitySecurity" integer DEFAULT '0', |
|
| 1601 |
"localitySecurity" integer DEFAULT '0' /*COMMENT '0 = no security; 1 = hidden locality'*/,
|
|
| 1602 | 1602 |
"localitySecurityReason" varchar(100) DEFAULT NULL, |
| 1603 | 1603 |
"decimalLatitude" double precision DEFAULT NULL, |
| 1604 | 1604 |
"decimalLongitude" double precision DEFAULT NULL, |
| ... | ... | |
| 1621 | 1621 |
"disposition" varchar(100) DEFAULT NULL, |
| 1622 | 1622 |
"genericcolumn1" varchar(100) DEFAULT NULL, |
| 1623 | 1623 |
"genericcolumn2" varchar(100) DEFAULT NULL, |
| 1624 |
"modified" text/*datetime*/ DEFAULT NULL, |
|
| 1624 |
"modified" text/*datetime*/ DEFAULT NULL /*COMMENT 'DateLastModified'*/,
|
|
| 1625 | 1625 |
"language" varchar(20) DEFAULT NULL, |
| 1626 | 1626 |
"duplicateid" integer DEFAULT NULL, |
| 1627 | 1627 |
"observeruid" integer DEFAULT NULL, |
| ... | ... | |
| 1868 | 1868 |
"Source" varchar(250) DEFAULT NULL, |
| 1869 | 1869 |
"Notes" varchar(250) DEFAULT NULL, |
| 1870 | 1870 |
"Hybrid" varchar(50) DEFAULT NULL, |
| 1871 |
"fnaprikey" integer DEFAULT NULL, |
|
| 1871 |
"fnaprikey" integer DEFAULT NULL /*COMMENT 'Primary key for FNA project'*/,
|
|
| 1872 | 1872 |
"UsdaSymbol" varchar(50) DEFAULT NULL, |
| 1873 |
"SecurityStatus" integer NOT NULL DEFAULT '0', |
|
| 1873 |
"SecurityStatus" integer NOT NULL DEFAULT '0' /*COMMENT '0 = no security; 1 = hidden locality'*/,
|
|
| 1874 | 1874 |
PRIMARY KEY ("TID"),
|
| 1875 | 1875 |
/*CONSTRAINT "sciname_unique" */UNIQUE ("SciName"),
|
| 1876 | 1876 |
/*KEY "rankid_index" ("RankId")*/CHECK (true),
|
| ... | ... | |
| 1894 | 1894 |
"source" varchar(250) DEFAULT NULL, |
| 1895 | 1895 |
"sourceurl" varchar(250) DEFAULT NULL, |
| 1896 | 1896 |
"language" varchar(45) DEFAULT 'English', |
| 1897 |
"displaylevel" integer NOT NULL DEFAULT '1', |
|
| 1897 |
"displaylevel" integer NOT NULL DEFAULT '1' /*COMMENT '1 = short descr, 2 = intermediate descr'*/,
|
|
| 1898 | 1898 |
"uid" integer NOT NULL, |
| 1899 | 1899 |
"notes" varchar(250) DEFAULT NULL, |
| 1900 | 1900 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| ... | ... | |
| 1982 | 1982 |
CREATE TABLE "taxamapparams" ( |
| 1983 | 1983 |
"dmid" integer NOT NULL, |
| 1984 | 1984 |
"name" varchar(45) NOT NULL, |
| 1985 |
"maptype" varchar(45) NOT NULL, |
|
| 1985 |
"maptype" varchar(45) NOT NULL /*COMMENT 'custom; google dynamic'*/,
|
|
| 1986 | 1986 |
"regionofinterest" varchar(45) DEFAULT NULL, |
| 1987 | 1987 |
"basefilepath" varchar(250) DEFAULT NULL, |
| 1988 | 1988 |
"maptargetpath" varchar(250) NOT NULL, |
| ... | ... | |
| 2123 | 2123 |
CREATE TABLE "taxstatus" ( |
| 2124 | 2124 |
"tid" integer NOT NULL, |
| 2125 | 2125 |
"tidaccepted" integer NOT NULL, |
| 2126 |
"taxauthid" integer NOT NULL, |
|
| 2126 |
"taxauthid" integer NOT NULL /*COMMENT 'taxon authority id'*/,
|
|
| 2127 | 2127 |
"parenttid" integer DEFAULT NULL, |
| 2128 | 2128 |
"hierarchystr" varchar(200) DEFAULT NULL, |
| 2129 | 2129 |
"uppertaxonomy" varchar(50) DEFAULT NULL, |
| ... | ... | |
| 2161 | 2161 |
"TSN" varchar(255) DEFAULT NULL, |
| 2162 | 2162 |
"Determiner" varchar(255) DEFAULT NULL, |
| 2163 | 2163 |
"DateDetermined" varchar(45) DEFAULT NULL, |
| 2164 |
"SpecNotes" text, |
|
| 2165 |
"PlantDesc" text, |
|
| 2166 |
"Habitat" text, |
|
| 2167 |
"AssocSpp" text, |
|
| 2168 |
"FirstColl" varchar(255) DEFAULT NULL, |
|
| 2169 |
"CollNum" varchar(45) DEFAULT NULL, |
|
| 2164 |
"SpecNotes" text /*COMMENT 'General Notes'*/,
|
|
| 2165 |
"PlantDesc" text /*COMMENT 'Plant Description?'*/,
|
|
| 2166 |
"Habitat" text /*COMMENT 'Habitat, substrait, etc'*/,
|
|
| 2167 |
"AssocSpp" text /*COMMENT 'Associated Species'*/,
|
|
| 2168 |
"FirstColl" varchar(255) DEFAULT NULL /*COMMENT 'Collector(s)'*/,
|
|
| 2169 |
"CollNum" varchar(45) DEFAULT NULL /*COMMENT 'Collector Number'*/,
|
|
| 2170 | 2170 |
"DateColl" text/*date*/ DEFAULT NULL, |
| 2171 | 2171 |
"Country" varchar(64) DEFAULT NULL, |
| 2172 | 2172 |
"State" varchar(255) DEFAULT NULL, |
| ... | ... | |
| 2349 | 2349 |
"usmid" integer NOT NULL, |
| 2350 | 2350 |
"uspid" integer NOT NULL, |
| 2351 | 2351 |
"sourcefield" varchar(45) NOT NULL, |
| 2352 |
"symbdatatype" varchar(45) NOT NULL DEFAULT 'string', |
|
| 2352 |
"symbdatatype" varchar(45) NOT NULL DEFAULT 'string' /*COMMENT 'string, numeric, text/*datetime*/'*/,
|
|
| 2353 | 2353 |
"symbspecfield" varchar(45) NOT NULL, |
| 2354 | 2354 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 2355 | 2355 |
PRIMARY KEY ("usmid"),
|
| ... | ... | |
| 2368 | 2368 |
CREATE TABLE "uploadspecparameters" ( |
| 2369 | 2369 |
"uspid" integer NOT NULL, |
| 2370 | 2370 |
"CollID" integer NOT NULL, |
| 2371 |
"UploadType" integer NOT NULL DEFAULT '1', |
|
| 2371 |
"UploadType" integer NOT NULL DEFAULT '1' /*COMMENT '1 = Direct; 2 = DiGIR; 3 = File'*/,
|
|
| 2372 | 2372 |
"title" varchar(45) NOT NULL, |
| 2373 |
"Platform" varchar(45) DEFAULT '1', |
|
| 2373 |
"Platform" varchar(45) DEFAULT '1' /*COMMENT '1 = MySQL; 2 = MSSQL; 3 = ORACLE; 11 = MS Access; 12 = FileMaker'*/,
|
|
| 2374 | 2374 |
"server" varchar(150) DEFAULT NULL, |
| 2375 | 2375 |
"port" integer DEFAULT NULL, |
| 2376 | 2376 |
"driver" varchar(45) DEFAULT NULL, |
| ... | ... | |
| 2401 | 2401 |
"collid" integer NOT NULL, |
| 2402 | 2402 |
"dbpk" varchar(45) DEFAULT NULL, |
| 2403 | 2403 |
"occid" integer DEFAULT NULL, |
| 2404 |
"basisOfRecord" varchar(32) DEFAULT 'PreservedSpecimen', |
|
| 2405 |
"occurrenceID" varchar(255) DEFAULT NULL, |
|
| 2404 |
"basisOfRecord" varchar(32) DEFAULT 'PreservedSpecimen' /*COMMENT 'PreservedSpecimen, LivingSpecimen, HumanObservation'*/,
|
|
| 2405 |
"occurrenceID" varchar(255) DEFAULT NULL /*COMMENT 'UniqueGlobalIdentifier'*/,
|
|
| 2406 | 2406 |
"catalogNumber" varchar(32) DEFAULT NULL, |
| 2407 | 2407 |
"otherCatalogNumbers" varchar(255) DEFAULT NULL, |
| 2408 | 2408 |
"ownerInstitutionCode" varchar(32) DEFAULT NULL, |
| ... | ... | |
| 2425 | 2425 |
"dateIdentified" varchar(45) DEFAULT NULL, |
| 2426 | 2426 |
"identificationReferences" text, |
| 2427 | 2427 |
"identificationRemarks" text, |
| 2428 |
"identificationQualifier" varchar(255) DEFAULT NULL, |
|
| 2428 |
"identificationQualifier" varchar(255) DEFAULT NULL /*COMMENT 'cf, aff, etc'*/,
|
|
| 2429 | 2429 |
"typeStatus" varchar(255) DEFAULT NULL, |
| 2430 |
"recordedBy" varchar(255) DEFAULT NULL, |
|
| 2431 |
"recordNumber" varchar(32) DEFAULT NULL, |
|
| 2432 |
"CollectorFamilyName" varchar(255) DEFAULT NULL, |
|
| 2433 |
"CollectorInitials" varchar(255) DEFAULT NULL, |
|
| 2434 |
"associatedCollectors" varchar(255) DEFAULT NULL, |
|
| 2430 |
"recordedBy" varchar(255) DEFAULT NULL /*COMMENT 'Collector(s)'*/,
|
|
| 2431 |
"recordNumber" varchar(32) DEFAULT NULL /*COMMENT 'Collector Number'*/,
|
|
| 2432 |
"CollectorFamilyName" varchar(255) DEFAULT NULL /*COMMENT 'not DwC'*/,
|
|
| 2433 |
"CollectorInitials" varchar(255) DEFAULT NULL /*COMMENT 'not DwC'*/,
|
|
| 2434 |
"associatedCollectors" varchar(255) DEFAULT NULL /*COMMENT 'not DwC'*/,
|
|
| 2435 | 2435 |
"eventDate" text/*date*/ DEFAULT NULL, |
| 2436 | 2436 |
"year" integer DEFAULT NULL, |
| 2437 | 2437 |
"month" integer DEFAULT NULL, |
| ... | ... | |
| 2440 | 2440 |
"endDayOfYear" integer DEFAULT NULL, |
| 2441 | 2441 |
"LatestDateCollected" text/*date*/ DEFAULT NULL, |
| 2442 | 2442 |
"verbatimEventDate" varchar(255) DEFAULT NULL, |
| 2443 |
"habitat" text, |
|
| 2443 |
"habitat" text /*COMMENT 'Habitat, substrait, etc'*/,
|
|
| 2444 | 2444 |
"substrate" varchar(500) DEFAULT NULL, |
| 2445 | 2445 |
"fieldNotes" text, |
| 2446 | 2446 |
"fieldnumber" varchar(45) DEFAULT NULL, |
| 2447 |
"occurrenceRemarks" text, |
|
| 2447 |
"occurrenceRemarks" text /*COMMENT 'General Notes'*/,
|
|
| 2448 | 2448 |
"informationWithheld" varchar(250) DEFAULT NULL, |
| 2449 | 2449 |
"dataGeneralizations" varchar(250) DEFAULT NULL, |
| 2450 | 2450 |
"associatedOccurrences" text, |
| 2451 |
"associatedTaxa" text, |
|
| 2452 |
"dynamicProperties" text, |
|
| 2451 |
"associatedTaxa" text /*COMMENT 'Associated Species'*/,
|
|
| 2452 |
"dynamicProperties" text /*COMMENT 'Plant Description?'*/,
|
|
| 2453 | 2453 |
"verbatimAttributes" text, |
| 2454 | 2454 |
"attributes" text, |
| 2455 |
"reproductiveCondition" varchar(255) DEFAULT NULL, |
|
| 2456 |
"cultivationStatus" integer DEFAULT NULL, |
|
| 2457 |
"establishmentMeans" varchar(32) DEFAULT NULL, |
|
| 2455 |
"reproductiveCondition" varchar(255) DEFAULT NULL /*COMMENT 'Phenology: flowers, fruit, sterile'*/,
|
|
| 2456 |
"cultivationStatus" integer DEFAULT NULL /*COMMENT '0 = wild, 1 = cultivated'*/,
|
|
| 2457 |
"establishmentMeans" varchar(32) DEFAULT NULL /*COMMENT 'cultivated, invasive, escaped from captivity, wild, native'*/,
|
|
| 2458 | 2458 |
"lifeStage" varchar(45) DEFAULT NULL, |
| 2459 | 2459 |
"sex" varchar(45) DEFAULT NULL, |
| 2460 | 2460 |
"individualCount" varchar(45) DEFAULT NULL, |
| ... | ... | |
| 2465 | 2465 |
"county" varchar(255) DEFAULT NULL, |
| 2466 | 2466 |
"municipality" varchar(255) DEFAULT NULL, |
| 2467 | 2467 |
"locality" text, |
| 2468 |
"localitySecurity" integer DEFAULT '0', |
|
| 2468 |
"localitySecurity" integer DEFAULT '0' /*COMMENT '0 = display locality, 1 = hide locality'*/,
|
|
| 2469 | 2469 |
"localitySecurityReason" varchar(100) DEFAULT NULL, |
| 2470 | 2470 |
"decimalLatitude" double precision DEFAULT NULL, |
| 2471 | 2471 |
"decimalLongitude" double precision DEFAULT NULL, |
| ... | ... | |
| 2496 | 2496 |
"maximumElevationInMeters" integer DEFAULT NULL, |
| 2497 | 2497 |
"verbatimElevation" varchar(255) DEFAULT NULL, |
| 2498 | 2498 |
"previousIdentifications" text, |
| 2499 |
"disposition" varchar(32) DEFAULT NULL, |
|
| 2499 |
"disposition" varchar(32) DEFAULT NULL /*COMMENT 'Dups to'*/,
|
|
| 2500 | 2500 |
"genericcolumn1" varchar(100) DEFAULT NULL, |
| 2501 | 2501 |
"genericcolumn2" varchar(100) DEFAULT NULL, |
| 2502 |
"modified" text/*datetime*/ DEFAULT NULL, |
|
| 2502 |
"modified" text/*datetime*/ DEFAULT NULL /*COMMENT 'DateLastModified'*/,
|
|
| 2503 | 2503 |
"language" varchar(2) DEFAULT NULL, |
| 2504 | 2504 |
"recordEnteredBy" varchar(250) DEFAULT NULL, |
| 2505 | 2505 |
"duplicateQuantity" integer DEFAULT NULL, |
| ... | ... | |
| 2550 | 2550 |
"UnitInd3" varchar(7) DEFAULT NULL, |
| 2551 | 2551 |
"UnitName3" varchar(35) DEFAULT NULL, |
| 2552 | 2552 |
"Author" varchar(100) DEFAULT NULL, |
| 2553 |
"Acceptance" integer DEFAULT '1', |
|
| 2553 |
"Acceptance" integer DEFAULT '1' /*COMMENT '0 = not accepted; 1 = accepted'*/,
|
|
| 2554 | 2554 |
"TidAccepted" integer DEFAULT NULL, |
| 2555 | 2555 |
"AcceptedStr" varchar(250) DEFAULT NULL, |
| 2556 | 2556 |
"SourceAcceptedId" integer DEFAULT NULL, |
| ... | ... | |
| 2558 | 2558 |
"ParentTid" integer DEFAULT NULL, |
| 2559 | 2559 |
"ParentStr" varchar(250) DEFAULT NULL, |
| 2560 | 2560 |
"SourceParentId" integer DEFAULT NULL, |
| 2561 |
"SecurityStatus" integer NOT NULL DEFAULT '0', |
|
| 2561 |
"SecurityStatus" integer NOT NULL DEFAULT '0' /*COMMENT '0 = no security; 1 = hidden locality'*/,
|
|
| 2562 | 2562 |
"Source" varchar(250) DEFAULT NULL, |
| 2563 | 2563 |
"Notes" varchar(250) DEFAULT NULL, |
| 2564 | 2564 |
"vernacular" varchar(80) DEFAULT NULL, |
| ... | ... | |
| 2602 | 2602 |
/*!40101 SET character_set_client = utf8 */; |
| 2603 | 2603 |
CREATE TABLE "userpermissions" ( |
| 2604 | 2604 |
"uid" integer NOT NULL, |
| 2605 |
"pname" varchar(45) NOT NULL, |
|
| 2605 |
"pname" varchar(45) NOT NULL /*COMMENT 'SuperAdmin, TaxonProfile, IdentKey, RareSpecies, coll-1, cl-1, proj-1'*/,
|
|
| 2606 | 2606 |
"assignedby" varchar(45) DEFAULT NULL, |
| 2607 | 2607 |
"initialtimestamp" text/*timestamp*/ NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 2608 | 2608 |
PRIMARY KEY ("uid","pname"),
|
Also available in: Unified diff
bin/my2pg: comment out COMMENTs instead of removing them so that they will be included in the PostgreSQL translation. COMMENTs contain important metadata about columns, such as definitions and the meanings of integer flag values.