Revision 7415
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 520 | 520 |
parent_id int(11), |
| 521 | 521 |
taxonepithet varchar(255), |
| 522 | 522 |
rank varchar(255), |
| 523 |
taxonomicname varchar(255), |
|
| 524 |
accessioncode varchar(255) |
|
| 523 |
taxonomicname varchar(255) |
|
| 525 | 524 |
); |
| 526 | 525 |
|
| 527 | 526 |
|
| ... | ... | |
| 684 | 683 |
coverindex_id int(11), |
| 685 | 684 |
occurrencestatus_dwc varchar(255) DEFAULT 'present' NOT NULL, |
| 686 | 685 |
method_id int(11), |
| 687 |
notes varchar(255), |
|
| 688 |
accessioncode varchar(255) |
|
| 686 |
notes varchar(255) |
|
| 689 | 687 |
); |
| 690 | 688 |
|
| 691 | 689 |
|
| ... | ... | |
| 939 | 937 |
notesmgt int(1), |
| 940 | 938 |
revisions int(1), |
| 941 | 939 |
dateentered date , |
| 942 |
locationrationalenarrative varchar(255), |
|
| 943 |
accessioncode varchar(255) |
|
| 940 |
locationrationalenarrative varchar(255) |
|
| 944 | 941 |
); |
| 945 | 942 |
|
| 946 | 943 |
|
| ... | ... | |
| 1031 | 1028 |
toptaxon3name varchar(255), |
| 1032 | 1029 |
toptaxon4name varchar(255), |
| 1033 | 1030 |
toptaxon5name varchar(255), |
| 1034 |
numberoftaxa int(11), |
|
| 1035 |
accessioncode varchar(255) |
|
| 1031 |
numberoftaxa int(11) |
|
| 1036 | 1032 |
); |
| 1037 | 1033 |
|
| 1038 | 1034 |
|
| ... | ... | |
| 1090 | 1086 |
samplearea_m2 double precision, |
| 1091 | 1087 |
subplotspacing_m double precision, |
| 1092 | 1088 |
subplotmethod_id int(11), |
| 1093 |
pointsperline int(11), |
|
| 1094 |
accessioncode varchar(255) |
|
| 1089 |
pointsperline int(11) |
|
| 1095 | 1090 |
); |
| 1096 | 1091 |
|
| 1097 | 1092 |
|
| ... | ... | |
| 1248 | 1243 |
contactinstructions varchar(255), |
| 1249 | 1244 |
email varchar(255), |
| 1250 | 1245 |
partytype varchar(255), |
| 1251 |
partypublic int(1) DEFAULT true, |
|
| 1252 |
accessioncode varchar(255) |
|
| 1246 |
partypublic int(1) DEFAULT true |
|
| 1253 | 1247 |
); |
| 1254 | 1248 |
|
| 1255 | 1249 |
|
| ... | ... | |
| 1266 | 1260 |
overallheightaccuracy_m double precision, |
| 1267 | 1261 |
authorplantcode varchar(255), |
| 1268 | 1262 |
stemcount int(11), |
| 1269 |
plant_id int(11), |
|
| 1270 |
accessioncode varchar(255) |
|
| 1263 |
plant_id int(11) |
|
| 1271 | 1264 |
); |
| 1272 | 1265 |
|
| 1273 | 1266 |
|
| ... | ... | |
| 1296 | 1289 |
projectname varchar(255), |
| 1297 | 1290 |
projectdescription varchar(255), |
| 1298 | 1291 |
startdate date, |
| 1299 |
stopdate date, |
|
| 1300 |
accessioncode varchar(255) |
|
| 1292 |
stopdate date |
|
| 1301 | 1293 |
); |
| 1302 | 1294 |
|
| 1303 | 1295 |
|
| ... | ... | |
| 1335 | 1327 |
additionalinfo varchar(255), |
| 1336 | 1328 |
pubdate date, |
| 1337 | 1329 |
accessdate date, |
| 1338 |
conferencedate date, |
|
| 1339 |
accessioncode varchar(255) |
|
| 1330 |
conferencedate date |
|
| 1340 | 1331 |
); |
| 1341 | 1332 |
|
| 1342 | 1333 |
|
| ... | ... | |
| 1365 | 1356 |
catalognumber_dwc varchar(255), |
| 1366 | 1357 |
collectionnumber varchar(255), |
| 1367 | 1358 |
description varchar(255), |
| 1368 |
specimen_id int(11), |
|
| 1369 |
accessioncode varchar(255) |
|
| 1359 |
specimen_id int(11) |
|
| 1370 | 1360 |
); |
| 1371 | 1361 |
|
| 1372 | 1362 |
|
| ... | ... | |
| 1412 | 1402 |
heightfirstbranch_m double precision, |
| 1413 | 1403 |
heightaccuracy_m double precision, |
| 1414 | 1404 |
health varchar(255), |
| 1415 |
age double precision, |
|
| 1416 |
accessioncode varchar(255) |
|
| 1405 |
age double precision |
|
| 1417 | 1406 |
); |
| 1418 | 1407 |
|
| 1419 | 1408 |
|
| ... | ... | |
| 1452 | 1441 |
grouptype varchar(255), |
| 1453 | 1442 |
notes varchar(255), |
| 1454 | 1443 |
revisions int(1), |
| 1455 |
determinationdate date, |
|
| 1456 |
accessioncode varchar(255) |
|
| 1444 |
determinationdate date |
|
| 1457 | 1445 |
); |
| 1458 | 1446 |
|
| 1459 | 1447 |
|
| ... | ... | |
| 1478 | 1466 |
growthform varchar(255), |
| 1479 | 1467 |
iscultivated int(1), |
| 1480 | 1468 |
cultivatedbasis varchar(255), |
| 1481 |
isnative int(1), |
|
| 1482 |
accessioncode varchar(255) |
|
| 1469 |
isnative int(1) |
|
| 1483 | 1470 |
); |
| 1484 | 1471 |
|
| 1485 | 1472 |
|
| ... | ... | |
| 1662 | 1649 |
commlevel varchar(255), |
| 1663 | 1650 |
classstartdate date, |
| 1664 | 1651 |
classstopdate date, |
| 1665 |
expertsystem varchar(255), |
|
| 1666 |
accessioncode varchar(255) |
|
| 1652 |
expertsystem varchar(255) |
|
| 1667 | 1653 |
); |
| 1668 | 1654 |
|
| 1669 | 1655 |
|
| ... | ... | |
| 1696 | 1682 |
commname_id int(11) NOT NULL, |
| 1697 | 1683 |
reference_id int(11), |
| 1698 | 1684 |
commdescription varchar(255), |
| 1699 |
commname varchar(255), |
|
| 1700 |
accessioncode varchar(255) |
|
| 1685 |
commname varchar(255) |
|
| 1701 | 1686 |
); |
| 1702 | 1687 |
|
| 1703 | 1688 |
|
| ... | ... | |
| 1871 | 1856 |
commpartycomments varchar(255), |
| 1872 | 1857 |
party_id int(11) NOT NULL, |
| 1873 | 1858 |
startdate date NOT NULL, |
| 1874 |
stopdate date, |
|
| 1875 |
accessioncode varchar(255) |
|
| 1859 |
stopdate date |
|
| 1876 | 1860 |
); |
| 1877 | 1861 |
|
| 1878 | 1862 |
|
| ... | ... | |
| 1997 | 1981 |
covermethod_id int(11) NOT NULL, |
| 1998 | 1982 |
source_id int(11), |
| 1999 | 1983 |
covertype varchar(255) NOT NULL, |
| 2000 |
coverestimationmethod varchar(255), |
|
| 2001 |
accessioncode varchar(255) |
|
| 1984 |
coverestimationmethod varchar(255) |
|
| 2002 | 1985 |
); |
| 2003 | 1986 |
|
| 2004 | 1987 |
|
| ... | ... | |
| 2134 | 2117 |
graphicdescription varchar(255), |
| 2135 | 2118 |
graphictype varchar(255), |
| 2136 | 2119 |
graphicdata int(11), |
| 2137 |
graphicdate date, |
|
| 2138 |
accessioncode varchar(255) |
|
| 2120 |
graphicdate date |
|
| 2139 | 2121 |
); |
| 2140 | 2122 |
|
| 2141 | 2123 |
|
| ... | ... | |
| 2254 | 2236 |
role varchar(255) NOT NULL, |
| 2255 | 2237 |
synonymcomment varchar(255), |
| 2256 | 2238 |
classstartdate date NOT NULL, |
| 2257 |
classstopdate date, |
|
| 2258 |
accessioncode varchar(255) |
|
| 2239 |
classstopdate date |
|
| 2259 | 2240 |
); |
| 2260 | 2241 |
|
| 2261 | 2242 |
|
| ... | ... | |
| 2378 | 2359 |
role varchar(255) NOT NULL, |
| 2379 | 2360 |
notetype varchar(255) NOT NULL, |
| 2380 | 2361 |
notetext varchar(255) NOT NULL, |
| 2381 |
notedate date, |
|
| 2382 |
accessioncode varchar(255) |
|
| 2362 |
notedate date |
|
| 2383 | 2363 |
); |
| 2384 | 2364 |
|
| 2385 | 2365 |
|
| ... | ... | |
| 2835 | 2815 |
soilname varchar(255), |
| 2836 | 2816 |
soillevel int(11), |
| 2837 | 2817 |
soilparent_id int(11), |
| 2838 |
soilframework varchar(255), |
|
| 2839 |
accessioncode varchar(255) |
|
| 2818 |
soilframework varchar(255) |
|
| 2840 | 2819 |
); |
| 2841 | 2820 |
|
| 2842 | 2821 |
|
| ... | ... | |
| 3316 | 3295 |
source_id int(11), |
| 3317 | 3296 |
plantpartycomments varchar(255), |
| 3318 | 3297 |
startdate date, |
| 3319 |
stopdate date, |
|
| 3320 |
accessioncode varchar(255) |
|
| 3298 |
stopdate date |
|
| 3321 | 3299 |
); |
| 3322 | 3300 |
|
| 3323 | 3301 |
|
| ... | ... | |
| 3451 | 3429 |
userdefinedmetadata varchar(255), |
| 3452 | 3430 |
userdefinedcategory varchar(255), |
| 3453 | 3431 |
userdefinedtype varchar(255) DEFAULT 'text' NOT NULL, |
| 3454 |
tablename varchar(255) NOT NULL, |
|
| 3455 |
accessioncode varchar(255) |
|
| 3432 |
tablename varchar(255) NOT NULL |
|
| 3456 | 3433 |
); |
| 3457 | 3434 |
|
| 3458 | 3435 |
|
| ... | ... | |
| 5113 | 5090 |
|
| 5114 | 5091 |
|
| 5115 | 5092 |
-- |
| 5116 |
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5117 |
-- |
|
| 5118 |
|
|
| 5119 |
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass (accessioncode); |
|
| 5120 |
|
|
| 5121 |
|
|
| 5122 |
-- |
|
| 5123 | 5093 |
-- Name: commclass_classpublication_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5124 | 5094 |
-- |
| 5125 | 5095 |
|
| ... | ... | |
| 5134 | 5104 |
|
| 5135 | 5105 |
|
| 5136 | 5106 |
-- |
| 5137 |
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5138 |
-- |
|
| 5139 |
|
|
| 5140 |
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept (accessioncode); |
|
| 5141 |
|
|
| 5142 |
|
|
| 5143 |
-- |
|
| 5144 | 5107 |
-- Name: commconcept_reference_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5145 | 5108 |
-- |
| 5146 | 5109 |
|
| ... | ... | |
| 5197 | 5160 |
|
| 5198 | 5161 |
|
| 5199 | 5162 |
-- |
| 5200 |
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5201 |
-- |
|
| 5202 |
|
|
| 5203 |
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus (accessioncode); |
|
| 5204 |
|
|
| 5205 |
|
|
| 5206 |
-- |
|
| 5207 | 5163 |
-- Name: commstatus_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5208 | 5164 |
-- |
| 5209 | 5165 |
|
| ... | ... | |
| 5274 | 5230 |
|
| 5275 | 5231 |
|
| 5276 | 5232 |
-- |
| 5277 |
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5278 |
-- |
|
| 5279 |
|
|
| 5280 |
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod (accessioncode); |
|
| 5281 |
|
|
| 5282 |
|
|
| 5283 |
-- |
|
| 5284 | 5233 |
-- Name: covermethod_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5285 | 5234 |
-- |
| 5286 | 5235 |
|
| ... | ... | |
| 5295 | 5244 |
|
| 5296 | 5245 |
|
| 5297 | 5246 |
-- |
| 5298 |
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5299 |
-- |
|
| 5300 |
|
|
| 5301 |
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic (accessioncode); |
|
| 5302 |
|
|
| 5303 |
|
|
| 5304 |
-- |
|
| 5305 | 5247 |
-- Name: graphic_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5306 | 5248 |
-- |
| 5307 | 5249 |
|
| ... | ... | |
| 5316 | 5258 |
|
| 5317 | 5259 |
|
| 5318 | 5260 |
-- |
| 5319 |
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5320 |
-- |
|
| 5321 |
|
|
| 5322 |
CREATE UNIQUE INDEX location_accessioncode_index ON location (accessioncode); |
|
| 5323 |
|
|
| 5324 |
|
|
| 5325 |
-- |
|
| 5326 | 5261 |
-- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5327 | 5262 |
-- |
| 5328 | 5263 |
|
| ... | ... | |
| 5358 | 5293 |
|
| 5359 | 5294 |
|
| 5360 | 5295 |
-- |
| 5361 |
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5362 |
-- |
|
| 5363 |
|
|
| 5364 |
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent (accessioncode); |
|
| 5365 |
|
|
| 5366 |
|
|
| 5367 |
-- |
|
| 5368 | 5296 |
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5369 | 5297 |
-- |
| 5370 | 5298 |
|
| ... | ... | |
| 5463 | 5391 |
|
| 5464 | 5392 |
|
| 5465 | 5393 |
-- |
| 5466 |
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5467 |
-- |
|
| 5468 |
|
|
| 5469 |
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym (accessioncode); |
|
| 5470 |
|
|
| 5471 |
|
|
| 5472 |
-- |
|
| 5473 | 5394 |
-- Name: locationeventsynonym_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5474 | 5395 |
-- |
| 5475 | 5396 |
|
| ... | ... | |
| 5512 | 5433 |
|
| 5513 | 5434 |
|
| 5514 | 5435 |
-- |
| 5515 |
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5516 |
-- |
|
| 5517 |
|
|
| 5518 |
CREATE UNIQUE INDEX method_accessioncode ON method (accessioncode); |
|
| 5519 |
|
|
| 5520 |
|
|
| 5521 |
-- |
|
| 5522 | 5436 |
-- Name: method_covermethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5523 | 5437 |
-- |
| 5524 | 5438 |
|
| ... | ... | |
| 5554 | 5468 |
|
| 5555 | 5469 |
|
| 5556 | 5470 |
-- |
| 5557 |
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5558 |
-- |
|
| 5559 |
|
|
| 5560 |
CREATE UNIQUE INDEX note_accessioncode_index ON note (accessioncode); |
|
| 5561 |
|
|
| 5562 |
|
|
| 5563 |
-- |
|
| 5564 | 5471 |
-- Name: note_notelink_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5565 | 5472 |
-- |
| 5566 | 5473 |
|
| ... | ... | |
| 5575 | 5482 |
|
| 5576 | 5483 |
|
| 5577 | 5484 |
-- |
| 5578 |
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5579 |
-- |
|
| 5580 |
|
|
| 5581 |
CREATE UNIQUE INDEX party_accessioncode_index ON party (accessioncode); |
|
| 5582 |
|
|
| 5583 |
|
|
| 5584 |
-- |
|
| 5585 | 5485 |
-- Name: party_currentname_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5586 | 5486 |
-- |
| 5587 | 5487 |
|
| ... | ... | |
| 5722 | 5622 |
|
| 5723 | 5623 |
|
| 5724 | 5624 |
-- |
| 5725 |
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5726 |
-- |
|
| 5727 |
|
|
| 5728 |
CREATE UNIQUE INDEX project_accessioncode_index ON project (accessioncode); |
|
| 5729 |
|
|
| 5730 |
|
|
| 5731 |
-- |
|
| 5732 | 5625 |
-- Name: project_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5733 | 5626 |
-- |
| 5734 | 5627 |
|
| ... | ... | |
| 5771 | 5664 |
|
| 5772 | 5665 |
|
| 5773 | 5666 |
-- |
| 5774 |
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5775 |
-- |
|
| 5776 |
|
|
| 5777 |
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon (accessioncode); |
|
| 5778 |
|
|
| 5779 |
|
|
| 5780 |
-- |
|
| 5781 | 5667 |
-- Name: soiltaxon_soilparent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5782 | 5668 |
-- |
| 5783 | 5669 |
|
| ... | ... | |
| 5785 | 5671 |
|
| 5786 | 5672 |
|
| 5787 | 5673 |
-- |
| 5788 |
-- Name: source_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5789 |
-- |
|
| 5790 |
|
|
| 5791 |
CREATE UNIQUE INDEX source_accessioncode_index ON source (accessioncode); |
|
| 5792 |
|
|
| 5793 |
|
|
| 5794 |
-- |
|
| 5795 | 5674 |
-- Name: source_matched_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5796 | 5675 |
-- |
| 5797 | 5676 |
|
| ... | ... | |
| 5981 | 5860 |
|
| 5982 | 5861 |
|
| 5983 | 5862 |
-- |
| 5984 |
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5985 |
-- |
|
| 5986 |
|
|
| 5987 |
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination (accessioncode); |
|
| 5988 |
|
|
| 5989 |
|
|
| 5990 |
-- |
|
| 5991 | 5863 |
-- Name: taxondetermination_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5992 | 5864 |
-- |
| 5993 | 5865 |
|
| ... | ... | |
| 6058 | 5930 |
|
| 6059 | 5931 |
|
| 6060 | 5932 |
-- |
| 6061 |
-- Name: taxonlabel_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6062 |
-- |
|
| 6063 |
|
|
| 6064 |
CREATE UNIQUE INDEX taxonlabel_accessioncode_index ON taxonlabel (accessioncode); |
|
| 6065 |
|
|
| 6066 |
|
|
| 6067 |
-- |
|
| 6068 | 5933 |
-- Name: taxonlabel_canon_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6069 | 5934 |
-- |
| 6070 | 5935 |
|
| ... | ... | |
| 6121 | 5986 |
|
| 6122 | 5987 |
|
| 6123 | 5988 |
-- |
| 6124 |
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6125 |
-- |
|
| 6126 |
|
|
| 6127 |
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence (accessioncode); |
|
| 6128 |
|
|
| 6129 |
|
|
| 6130 |
-- |
|
| 6131 | 5989 |
-- Name: taxonoccurrence_collector_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6132 | 5990 |
-- |
| 6133 | 5991 |
|
| ... | ... | |
| 6163 | 6021 |
|
| 6164 | 6022 |
|
| 6165 | 6023 |
-- |
| 6166 |
-- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6167 |
-- |
|
| 6168 |
|
|
| 6169 |
CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus (accessioncode); |
|
| 6170 |
|
|
| 6171 |
|
|
| 6172 |
-- |
|
| 6173 | 6024 |
-- Name: taxonstatus_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6174 | 6025 |
-- |
| 6175 | 6026 |
|
| ... | ... | |
| 6205 | 6056 |
|
| 6206 | 6057 |
|
| 6207 | 6058 |
-- |
| 6208 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6209 |
-- |
|
| 6210 |
|
|
| 6211 |
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined (accessioncode); |
|
| 6212 |
|
|
| 6213 |
|
|
| 6214 |
-- |
|
| 6215 | 6059 |
-- Name: voucher_specimenreplicate_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6216 | 6060 |
-- |
| 6217 | 6061 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1236 | 1236 |
taxonepithet text, |
| 1237 | 1237 |
rank taxonrank, |
| 1238 | 1238 |
taxonomicname text, |
| 1239 |
accessioncode text, |
|
| 1240 | 1239 |
CONSTRAINT taxonlabel_required_key CHECK ((((sourceaccessioncode IS NOT NULL) OR (taxonepithet IS NOT NULL)) OR (taxonomicname IS NOT NULL))) |
| 1241 | 1240 |
); |
| 1242 | 1241 |
|
| ... | ... | |
| 1535 | 1534 |
occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL, |
| 1536 | 1535 |
method_id integer, |
| 1537 | 1536 |
notes text, |
| 1538 |
accessioncode text, |
|
| 1539 | 1537 |
CONSTRAINT aggregateoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (taxonoccurrence_id IS NOT NULL))) |
| 1540 | 1538 |
); |
| 1541 | 1539 |
|
| ... | ... | |
| 1797 | 1795 |
revisions boolean, |
| 1798 | 1796 |
dateentered date DEFAULT now(), |
| 1799 | 1797 |
locationrationalenarrative text, |
| 1800 |
accessioncode text, |
|
| 1801 | 1798 |
CONSTRAINT location_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (authorlocationcode IS NOT NULL))) |
| 1802 | 1799 |
); |
| 1803 | 1800 |
|
| ... | ... | |
| 1890 | 1887 |
toptaxon4name text, |
| 1891 | 1888 |
toptaxon5name text, |
| 1892 | 1889 |
numberoftaxa integer, |
| 1893 |
accessioncode text, |
|
| 1894 | 1890 |
CONSTRAINT locationevent_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (location_id IS NOT NULL))) |
| 1895 | 1891 |
); |
| 1896 | 1892 |
|
| ... | ... | |
| 1950 | 1946 |
subplotspacing_m double precision, |
| 1951 | 1947 |
subplotmethod_id integer, |
| 1952 | 1948 |
pointsperline integer, |
| 1953 |
accessioncode text, |
|
| 1954 | 1949 |
CONSTRAINT method_required_key CHECK ((((name IS NOT NULL) OR (description IS NOT NULL)) OR (observationmeasure IS NOT NULL))) |
| 1955 | 1950 |
); |
| 1956 | 1951 |
|
| ... | ... | |
| 2132 | 2127 |
email text, |
| 2133 | 2128 |
partytype text, |
| 2134 | 2129 |
partypublic boolean DEFAULT true, |
| 2135 |
accessioncode text, |
|
| 2136 | 2130 |
CONSTRAINT party_required_key CHECK (((organizationname IS NOT NULL) OR ((source_id <> party_id) AND ((fullname IS NOT NULL) OR (surname IS NOT NULL))))) |
| 2137 | 2131 |
); |
| 2138 | 2132 |
|
| ... | ... | |
| 2151 | 2145 |
authorplantcode text, |
| 2152 | 2146 |
stemcount integer, |
| 2153 | 2147 |
plant_id integer, |
| 2154 |
accessioncode text, |
|
| 2155 | 2148 |
CONSTRAINT plantobservation_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (aggregateoccurrence_id IS NOT NULL))) |
| 2156 | 2149 |
); |
| 2157 | 2150 |
|
| ... | ... | |
| 2182 | 2175 |
projectdescription text, |
| 2183 | 2176 |
startdate date, |
| 2184 | 2177 |
stopdate date, |
| 2185 |
accessioncode text, |
|
| 2186 | 2178 |
CONSTRAINT project_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (projectname IS NOT NULL))) |
| 2187 | 2179 |
); |
| 2188 | 2180 |
|
| ... | ... | |
| 2221 | 2213 |
additionalinfo text, |
| 2222 | 2214 |
pubdate date, |
| 2223 | 2215 |
accessdate date, |
| 2224 |
conferencedate date, |
|
| 2225 |
accessioncode text |
|
| 2216 |
conferencedate date |
|
| 2226 | 2217 |
); |
| 2227 | 2218 |
|
| 2228 | 2219 |
|
| ... | ... | |
| 2252 | 2243 |
collectionnumber text, |
| 2253 | 2244 |
description text, |
| 2254 | 2245 |
specimen_id integer, |
| 2255 |
accessioncode text, |
|
| 2256 | 2246 |
CONSTRAINT specimenreplicate_required_key CHECK ((((plantobservation_id IS NOT NULL) OR (sourceaccessioncode IS NOT NULL)) OR (catalognumber_dwc IS NOT NULL))) |
| 2257 | 2247 |
); |
| 2258 | 2248 |
|
| ... | ... | |
| 2300 | 2290 |
heightaccuracy_m double precision, |
| 2301 | 2291 |
health text, |
| 2302 | 2292 |
age double precision, |
| 2303 |
accessioncode text, |
|
| 2304 | 2293 |
CONSTRAINT stemobservation_non_empty CHECK (((((((((sourceaccessioncode IS NOT NULL) OR (authorstemcode IS NOT NULL)) OR (tag IS NOT NULL)) OR (xposition_m IS NOT NULL)) OR (diameterbreastheight_m IS NOT NULL)) OR (basaldiameter_m IS NOT NULL)) OR (height_m IS NOT NULL)) OR (heightfirstbranch_m IS NOT NULL))) |
| 2305 | 2294 |
); |
| 2306 | 2295 |
|
| ... | ... | |
| 2340 | 2329 |
grouptype text, |
| 2341 | 2330 |
notes text, |
| 2342 | 2331 |
revisions boolean, |
| 2343 |
determinationdate date, |
|
| 2344 |
accessioncode text |
|
| 2332 |
determinationdate date |
|
| 2345 | 2333 |
); |
| 2346 | 2334 |
|
| 2347 | 2335 |
|
| ... | ... | |
| 2367 | 2355 |
iscultivated boolean, |
| 2368 | 2356 |
cultivatedbasis text, |
| 2369 | 2357 |
isnative boolean, |
| 2370 |
accessioncode text, |
|
| 2371 | 2358 |
CONSTRAINT taxonoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (locationevent_id IS NOT NULL))) |
| 2372 | 2359 |
); |
| 2373 | 2360 |
|
| ... | ... | |
| 2562 | 2549 |
commlevel text, |
| 2563 | 2550 |
classstartdate date, |
| 2564 | 2551 |
classstopdate date, |
| 2565 |
expertsystem text, |
|
| 2566 |
accessioncode text |
|
| 2552 |
expertsystem text |
|
| 2567 | 2553 |
); |
| 2568 | 2554 |
|
| 2569 | 2555 |
|
| ... | ... | |
| 2601 | 2587 |
commname_id integer NOT NULL, |
| 2602 | 2588 |
reference_id integer, |
| 2603 | 2589 |
commdescription text, |
| 2604 |
commname text, |
|
| 2605 |
accessioncode text |
|
| 2590 |
commname text |
|
| 2606 | 2591 |
); |
| 2607 | 2592 |
|
| 2608 | 2593 |
|
| ... | ... | |
| 2801 | 2786 |
commpartycomments text, |
| 2802 | 2787 |
party_id integer NOT NULL, |
| 2803 | 2788 |
startdate date NOT NULL, |
| 2804 |
stopdate date, |
|
| 2805 |
accessioncode text |
|
| 2789 |
stopdate date |
|
| 2806 | 2790 |
); |
| 2807 | 2791 |
|
| 2808 | 2792 |
|
| ... | ... | |
| 2947 | 2931 |
covermethod_id integer NOT NULL, |
| 2948 | 2932 |
source_id integer, |
| 2949 | 2933 |
covertype text NOT NULL, |
| 2950 |
coverestimationmethod text, |
|
| 2951 |
accessioncode text |
|
| 2934 |
coverestimationmethod text |
|
| 2952 | 2935 |
); |
| 2953 | 2936 |
|
| 2954 | 2937 |
|
| ... | ... | |
| 3105 | 3088 |
graphicdescription text, |
| 3106 | 3089 |
graphictype text, |
| 3107 | 3090 |
graphicdata oid, |
| 3108 |
graphicdate date, |
|
| 3109 |
accessioncode text |
|
| 3091 |
graphicdate date |
|
| 3110 | 3092 |
); |
| 3111 | 3093 |
|
| 3112 | 3094 |
|
| ... | ... | |
| 3245 | 3227 |
role role NOT NULL, |
| 3246 | 3228 |
synonymcomment text, |
| 3247 | 3229 |
classstartdate date DEFAULT now() NOT NULL, |
| 3248 |
classstopdate date, |
|
| 3249 |
accessioncode text |
|
| 3230 |
classstopdate date |
|
| 3250 | 3231 |
); |
| 3251 | 3232 |
|
| 3252 | 3233 |
|
| ... | ... | |
| 3390 | 3371 |
role role NOT NULL, |
| 3391 | 3372 |
notetype text NOT NULL, |
| 3392 | 3373 |
notetext text NOT NULL, |
| 3393 |
notedate date, |
|
| 3394 |
accessioncode text |
|
| 3374 |
notedate date |
|
| 3395 | 3375 |
); |
| 3396 | 3376 |
|
| 3397 | 3377 |
|
| ... | ... | |
| 3915 | 3895 |
soilname text, |
| 3916 | 3896 |
soillevel integer, |
| 3917 | 3897 |
soilparent_id integer, |
| 3918 |
soilframework text, |
|
| 3919 |
accessioncode text |
|
| 3898 |
soilframework text |
|
| 3920 | 3899 |
); |
| 3921 | 3900 |
|
| 3922 | 3901 |
|
| ... | ... | |
| 4474 | 4453 |
source_id integer, |
| 4475 | 4454 |
plantpartycomments text, |
| 4476 | 4455 |
startdate date, |
| 4477 |
stopdate date, |
|
| 4478 |
accessioncode text |
|
| 4456 |
stopdate date |
|
| 4479 | 4457 |
); |
| 4480 | 4458 |
|
| 4481 | 4459 |
|
| ... | ... | |
| 4632 | 4610 |
userdefinedmetadata text, |
| 4633 | 4611 |
userdefinedcategory text, |
| 4634 | 4612 |
userdefinedtype text DEFAULT 'text'::text NOT NULL, |
| 4635 |
tablename text NOT NULL, |
|
| 4636 |
accessioncode text |
|
| 4613 |
tablename text NOT NULL |
|
| 4637 | 4614 |
); |
| 4638 | 4615 |
|
| 4639 | 4616 |
|
| ... | ... | |
| 6304 | 6281 |
|
| 6305 | 6282 |
|
| 6306 | 6283 |
-- |
| 6307 |
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6308 |
-- |
|
| 6309 |
|
|
| 6310 |
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass USING btree (accessioncode); |
|
| 6311 |
|
|
| 6312 |
|
|
| 6313 |
-- |
|
| 6314 | 6284 |
-- Name: commclass_classpublication_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6315 | 6285 |
-- |
| 6316 | 6286 |
|
| ... | ... | |
| 6325 | 6295 |
|
| 6326 | 6296 |
|
| 6327 | 6297 |
-- |
| 6328 |
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6329 |
-- |
|
| 6330 |
|
|
| 6331 |
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept USING btree (accessioncode); |
|
| 6332 |
|
|
| 6333 |
|
|
| 6334 |
-- |
|
| 6335 | 6298 |
-- Name: commconcept_reference_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6336 | 6299 |
-- |
| 6337 | 6300 |
|
| ... | ... | |
| 6388 | 6351 |
|
| 6389 | 6352 |
|
| 6390 | 6353 |
-- |
| 6391 |
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6392 |
-- |
|
| 6393 |
|
|
| 6394 |
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus USING btree (accessioncode); |
|
| 6395 |
|
|
| 6396 |
|
|
| 6397 |
-- |
|
| 6398 | 6354 |
-- Name: commstatus_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6399 | 6355 |
-- |
| 6400 | 6356 |
|
| ... | ... | |
| 6465 | 6421 |
|
| 6466 | 6422 |
|
| 6467 | 6423 |
-- |
| 6468 |
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6469 |
-- |
|
| 6470 |
|
|
| 6471 |
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod USING btree (accessioncode); |
|
| 6472 |
|
|
| 6473 |
|
|
| 6474 |
-- |
|
| 6475 | 6424 |
-- Name: covermethod_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6476 | 6425 |
-- |
| 6477 | 6426 |
|
| ... | ... | |
| 6486 | 6435 |
|
| 6487 | 6436 |
|
| 6488 | 6437 |
-- |
| 6489 |
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6490 |
-- |
|
| 6491 |
|
|
| 6492 |
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic USING btree (accessioncode); |
|
| 6493 |
|
|
| 6494 |
|
|
| 6495 |
-- |
|
| 6496 | 6438 |
-- Name: graphic_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6497 | 6439 |
-- |
| 6498 | 6440 |
|
| ... | ... | |
| 6507 | 6449 |
|
| 6508 | 6450 |
|
| 6509 | 6451 |
-- |
| 6510 |
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6511 |
-- |
|
| 6512 |
|
|
| 6513 |
CREATE UNIQUE INDEX location_accessioncode_index ON location USING btree (accessioncode); |
|
| 6514 |
|
|
| 6515 |
|
|
| 6516 |
-- |
|
| 6517 | 6452 |
-- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6518 | 6453 |
-- |
| 6519 | 6454 |
|
| ... | ... | |
| 6549 | 6484 |
|
| 6550 | 6485 |
|
| 6551 | 6486 |
-- |
| 6552 |
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6553 |
-- |
|
| 6554 |
|
|
| 6555 |
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent USING btree (accessioncode); |
|
| 6556 |
|
|
| 6557 |
|
|
| 6558 |
-- |
|
| 6559 | 6487 |
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6560 | 6488 |
-- |
| 6561 | 6489 |
|
| ... | ... | |
| 6654 | 6582 |
|
| 6655 | 6583 |
|
| 6656 | 6584 |
-- |
| 6657 |
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6658 |
-- |
|
| 6659 |
|
|
| 6660 |
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym USING btree (accessioncode); |
|
| 6661 |
|
|
| 6662 |
|
|
| 6663 |
-- |
|
| 6664 | 6585 |
-- Name: locationeventsynonym_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6665 | 6586 |
-- |
| 6666 | 6587 |
|
| ... | ... | |
| 6703 | 6624 |
|
| 6704 | 6625 |
|
| 6705 | 6626 |
-- |
| 6706 |
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6707 |
-- |
|
| 6708 |
|
|
| 6709 |
CREATE UNIQUE INDEX method_accessioncode ON method USING btree (accessioncode); |
|
| 6710 |
|
|
| 6711 |
|
|
| 6712 |
-- |
|
| 6713 | 6627 |
-- Name: method_covermethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6714 | 6628 |
-- |
| 6715 | 6629 |
|
| ... | ... | |
| 6745 | 6659 |
|
| 6746 | 6660 |
|
| 6747 | 6661 |
-- |
| 6748 |
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6749 |
-- |
|
| 6750 |
|
|
| 6751 |
CREATE UNIQUE INDEX note_accessioncode_index ON note USING btree (accessioncode); |
|
| 6752 |
|
|
| 6753 |
|
|
| 6754 |
-- |
|
| 6755 | 6662 |
-- Name: note_notelink_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6756 | 6663 |
-- |
| 6757 | 6664 |
|
| ... | ... | |
| 6766 | 6673 |
|
| 6767 | 6674 |
|
| 6768 | 6675 |
-- |
| 6769 |
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6770 |
-- |
|
| 6771 |
|
|
| 6772 |
CREATE UNIQUE INDEX party_accessioncode_index ON party USING btree (accessioncode); |
|
| 6773 |
|
|
| 6774 |
|
|
| 6775 |
-- |
|
| 6776 | 6676 |
-- Name: party_currentname_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6777 | 6677 |
-- |
| 6778 | 6678 |
|
| ... | ... | |
| 6913 | 6813 |
|
| 6914 | 6814 |
|
| 6915 | 6815 |
-- |
| 6916 |
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6917 |
-- |
|
| 6918 |
|
|
| 6919 |
CREATE UNIQUE INDEX project_accessioncode_index ON project USING btree (accessioncode); |
|
| 6920 |
|
|
| 6921 |
|
|
| 6922 |
-- |
|
| 6923 | 6816 |
-- Name: project_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6924 | 6817 |
-- |
| 6925 | 6818 |
|
| ... | ... | |
| 6962 | 6855 |
|
| 6963 | 6856 |
|
| 6964 | 6857 |
-- |
| 6965 |
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6966 |
-- |
|
| 6967 |
|
|
| 6968 |
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon USING btree (accessioncode); |
|
| 6969 |
|
|
| 6970 |
|
|
| 6971 |
-- |
|
| 6972 | 6858 |
-- Name: soiltaxon_soilparent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6973 | 6859 |
-- |
| 6974 | 6860 |
|
| ... | ... | |
| 6976 | 6862 |
|
| 6977 | 6863 |
|
| 6978 | 6864 |
-- |
| 6979 |
-- Name: source_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6980 |
-- |
|
| 6981 |
|
|
| 6982 |
CREATE UNIQUE INDEX source_accessioncode_index ON source USING btree (accessioncode); |
|
| 6983 |
|
|
| 6984 |
|
|
| 6985 |
-- |
|
| 6986 | 6865 |
-- Name: source_matched_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6987 | 6866 |
-- |
| 6988 | 6867 |
|
| ... | ... | |
| 7172 | 7051 |
|
| 7173 | 7052 |
|
| 7174 | 7053 |
-- |
| 7175 |
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7176 |
-- |
|
| 7177 |
|
|
| 7178 |
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination USING btree (accessioncode); |
|
| 7179 |
|
|
| 7180 |
|
|
| 7181 |
-- |
|
| 7182 | 7054 |
-- Name: taxondetermination_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7183 | 7055 |
-- |
| 7184 | 7056 |
|
| ... | ... | |
| 7249 | 7121 |
|
| 7250 | 7122 |
|
| 7251 | 7123 |
-- |
| 7252 |
-- Name: taxonlabel_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7253 |
-- |
|
| 7254 |
|
|
| 7255 |
CREATE UNIQUE INDEX taxonlabel_accessioncode_index ON taxonlabel USING btree (accessioncode); |
|
| 7256 |
|
|
| 7257 |
|
|
| 7258 |
-- |
|
| 7259 | 7124 |
-- Name: taxonlabel_canon_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7260 | 7125 |
-- |
| 7261 | 7126 |
|
| ... | ... | |
| 7312 | 7177 |
|
| 7313 | 7178 |
|
| 7314 | 7179 |
-- |
| 7315 |
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7316 |
-- |
|
| 7317 |
|
|
| 7318 |
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence USING btree (accessioncode); |
|
| 7319 |
|
|
| 7320 |
|
|
| 7321 |
-- |
|
| 7322 | 7180 |
-- Name: taxonoccurrence_collector_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7323 | 7181 |
-- |
| 7324 | 7182 |
|
| ... | ... | |
| 7354 | 7212 |
|
| 7355 | 7213 |
|
| 7356 | 7214 |
-- |
| 7357 |
-- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7358 |
-- |
|
| 7359 |
|
|
| 7360 |
CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus USING btree (accessioncode); |
|
| 7361 |
|
|
| 7362 |
|
|
| 7363 |
-- |
|
| 7364 | 7215 |
-- Name: taxonstatus_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7365 | 7216 |
-- |
| 7366 | 7217 |
|
| ... | ... | |
| 7396 | 7247 |
|
| 7397 | 7248 |
|
| 7398 | 7249 |
-- |
| 7399 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7400 |
-- |
|
| 7401 |
|
|
| 7402 |
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined USING btree (accessioncode); |
|
| 7403 |
|
|
| 7404 |
|
|
| 7405 |
-- |
|
| 7406 | 7250 |
-- Name: voucher_specimenreplicate_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7407 | 7251 |
-- |
| 7408 | 7252 |
|
Also available in: Unified diff
schemas/vegbien.sql: removed all accessioncode fields, as VegBIEN does not use them