Revision 14611
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 5350 | 5350 |
|
| 5351 | 5351 |
|
| 5352 | 5352 |
-- |
| 5353 |
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5353 |
-- Name: collected_dates; Type: VIEW; Schema: public; Owner: -
|
|
| 5354 | 5354 |
-- |
| 5355 | 5355 |
|
| 5356 |
CREATE TABLE coordinates ( |
|
| 5357 |
coordinates_id int(11) NOT NULL, |
|
| 5358 |
source_id int(11) NOT NULL, |
|
| 5359 |
latitude_deg double NOT NULL, |
|
| 5360 |
longitude_deg double NOT NULL, |
|
| 5361 |
verbatimlatitude varchar(255), |
|
| 5362 |
verbatimlongitude varchar(255), |
|
| 5363 |
verbatimcoordinates varchar(255), |
|
| 5364 |
footprintgeometry_dwc varchar(255), |
|
| 5365 |
coordsaccuracy_m double |
|
| 5366 |
); |
|
| 5367 | 5356 |
|
| 5368 | 5357 |
|
| 5369 |
-- |
|
| 5370 |
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 5371 |
-- |
|
| 5372 | 5358 |
|
| 5373 |
|
|
| 5374 |
|
|
| 5375 |
|
|
| 5376 | 5359 |
-- |
| 5377 |
-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5360 |
-- Name: COLUMN collected_dates.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5378 | 5361 |
-- |
| 5379 | 5362 |
|
| 5380 | 5363 |
|
| 5381 | 5364 |
|
| 5382 | 5365 |
|
| 5383 | 5366 |
-- |
| 5384 |
-- Name: cultivated_family_locations; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5367 |
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5385 | 5368 |
-- |
| 5386 | 5369 |
|
| 5387 |
CREATE TABLE cultivated_family_locations ( |
|
| 5388 |
family varchar(255) NOT NULL, |
|
| 5389 |
country varchar(255) NOT NULL |
|
| 5370 |
CREATE TABLE commclass ( |
|
| 5371 |
commclass_id int(11) NOT NULL, |
|
| 5372 |
locationevent_id int(11) NOT NULL, |
|
| 5373 |
inspection int(1), |
|
| 5374 |
tableanalysis int(1), |
|
| 5375 |
multivariateanalysis int(1), |
|
| 5376 |
classpublication_id int(11), |
|
| 5377 |
classnotes varchar(255), |
|
| 5378 |
commname varchar(255), |
|
| 5379 |
commcode varchar(255), |
|
| 5380 |
commframework varchar(255), |
|
| 5381 |
commlevel varchar(255), |
|
| 5382 |
classstartdate date, |
|
| 5383 |
classstopdate date, |
|
| 5384 |
expertsystem varchar(255) |
|
| 5390 | 5385 |
); |
| 5391 | 5386 |
|
| 5392 | 5387 |
|
| 5393 | 5388 |
-- |
| 5394 |
-- Name: TABLE cultivated_family_locations; Type: COMMENT; Schema: public; Owner: -
|
|
| 5389 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5395 | 5390 |
-- |
| 5396 | 5391 |
|
| 5397 | 5392 |
|
| 5398 | 5393 |
|
| 5399 | 5394 |
|
| 5400 | 5395 |
-- |
| 5401 |
-- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5396 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5402 | 5397 |
-- |
| 5403 | 5398 |
|
| 5404 |
CREATE TABLE family_higher_plant_group ( |
|
| 5405 |
family varchar(255) NOT NULL, |
|
| 5406 |
higher_plant_group varchar(255) |
|
| 5407 |
); |
|
| 5408 | 5399 |
|
| 5409 | 5400 |
|
| 5401 |
|
|
| 5410 | 5402 |
-- |
| 5411 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5403 |
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5412 | 5404 |
-- |
| 5413 | 5405 |
|
| 5414 |
CREATE TABLE location ( |
|
| 5415 |
location_id int(11) NOT NULL, |
|
| 5416 |
source_id int(11) NOT NULL, |
|
| 5417 |
sourceaccessioncode varchar(255), |
|
| 5418 |
plot_location_id int(11) NOT NULL, |
|
| 5419 |
parent_id int(11), |
|
| 5420 |
authorlocationcode varchar(255), |
|
| 5421 |
place_id int(11), |
|
| 5422 |
accesslevel varchar(255), |
|
| 5423 |
accessconditions varchar(255), |
|
| 5424 |
sublocationxposition_m double, |
|
| 5425 |
sublocationyposition_m double, |
|
| 5426 |
iscultivated int(1), |
|
| 5427 |
authorzone varchar(255), |
|
| 5428 |
authordatum varchar(255), |
|
| 5429 |
authorlocation varchar(255), |
|
| 5430 |
locationnarrative varchar(255), |
|
| 5431 |
azimuth double, |
|
| 5432 |
shape varchar(255), |
|
| 5433 |
area_m2 double, |
|
| 5434 |
standsize varchar(255), |
|
| 5435 |
placementmethod varchar(255), |
|
| 5436 |
permanence int(1), |
|
| 5437 |
layoutnarrative varchar(255), |
|
| 5438 |
elevation_m double, |
|
| 5439 |
elevationaccuracy_m double, |
|
| 5440 |
elevationrange_m double, |
|
| 5441 |
verbatimelevation varchar(255), |
|
| 5442 |
slopeaspect_deg double, |
|
| 5443 |
minslopeaspect_deg double, |
|
| 5444 |
maxslopeaspect_deg double, |
|
| 5445 |
slopegradient_fraction double, |
|
| 5446 |
minslopegradient_fraction double, |
|
| 5447 |
maxslopegradient_fraction double, |
|
| 5448 |
topoposition varchar(255), |
|
| 5449 |
landform varchar(255), |
|
| 5450 |
surficialdeposits varchar(255), |
|
| 5451 |
rocktype varchar(255), |
|
| 5452 |
submitter_surname varchar(255), |
|
| 5453 |
submitter_givenname varchar(255), |
|
| 5454 |
submitter_email varchar(255), |
|
| 5455 |
notespublic int(1), |
|
| 5456 |
notesmgt int(1), |
|
| 5457 |
revisions int(1), |
|
| 5458 |
dateentered date , |
|
| 5459 |
locationrationalenarrative varchar(255) |
|
| 5406 |
CREATE TABLE commconcept ( |
|
| 5407 |
commconcept_id int(11) NOT NULL, |
|
| 5408 |
commname_id int(11) NOT NULL, |
|
| 5409 |
reference_id int(11), |
|
| 5410 |
commdescription varchar(255), |
|
| 5411 |
commname varchar(255) |
|
| 5460 | 5412 |
); |
| 5461 | 5413 |
|
| 5462 | 5414 |
|
| 5463 | 5415 |
-- |
| 5464 |
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
|
|
| 5416 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5465 | 5417 |
-- |
| 5466 | 5418 |
|
| 5467 | 5419 |
|
| 5468 | 5420 |
|
| 5469 | 5421 |
|
| 5470 | 5422 |
-- |
| 5471 |
-- Name: COLUMN location.plot_location_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5423 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5472 | 5424 |
-- |
| 5473 | 5425 |
|
| 5474 | 5426 |
|
| 5475 | 5427 |
|
| 5476 | 5428 |
|
| 5477 | 5429 |
-- |
| 5478 |
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5430 |
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5479 | 5431 |
-- |
| 5480 | 5432 |
|
| 5481 |
CREATE TABLE locationevent ( |
|
| 5482 |
locationevent_id int(11) NOT NULL, |
|
| 5483 |
source_id int(11) NOT NULL, |
|
| 5484 |
sourceaccessioncode varchar(255), |
|
| 5485 |
accesslevel varchar(255), |
|
| 5486 |
place_visit_id int(11) NOT NULL, |
|
| 5487 |
parent_id int(11), |
|
| 5488 |
plot_id int(11), |
|
| 5489 |
location_id int(11), |
|
| 5490 |
project_id int(11), |
|
| 5491 |
stratum_id int(11), |
|
| 5492 |
authoreventcode varchar(255), |
|
| 5493 |
previous_id int(11), |
|
| 5494 |
obsstartdate date, |
|
| 5495 |
obsenddate date, |
|
| 5496 |
dateaccuracy varchar(255), |
|
| 5497 |
method_id int(11), |
|
| 5498 |
temperature_c double, |
|
| 5499 |
precipitation_m double, |
|
| 5500 |
autotaxoncover int(1), |
|
| 5501 |
originaldata varchar(255), |
|
| 5502 |
effortlevel varchar(255), |
|
| 5503 |
floristicquality varchar(255), |
|
| 5504 |
bryophytequality varchar(255), |
|
| 5505 |
lichenquality varchar(255), |
|
| 5506 |
locationeventnarrative varchar(255), |
|
| 5507 |
landscapenarrative varchar(255), |
|
| 5508 |
homogeneity varchar(255), |
|
| 5509 |
phenologicaspect varchar(255), |
|
| 5510 |
representativeness varchar(255), |
|
| 5511 |
standmaturity varchar(255), |
|
| 5512 |
successionalstatus varchar(255), |
|
| 5513 |
basalarea double, |
|
| 5514 |
hydrologicregime varchar(255), |
|
| 5515 |
soilmoistureregime varchar(255), |
|
| 5516 |
soildrainage varchar(255), |
|
| 5517 |
watersalinity varchar(255), |
|
| 5518 |
waterdepth_m double, |
|
| 5519 |
shoredistance double, |
|
| 5520 |
soildepth double, |
|
| 5521 |
organicdepth double, |
|
| 5522 |
soiltaxon_id int(11), |
|
| 5523 |
soiltaxonsrc varchar(255), |
|
| 5524 |
percentbedrock double, |
|
| 5525 |
percentrockgravel double, |
|
| 5526 |
percentwood double, |
|
| 5527 |
percentlitter double, |
|
| 5528 |
percentbaresoil double, |
|
| 5529 |
percentwater double, |
|
| 5530 |
percentother double, |
|
| 5531 |
nameother varchar(255), |
|
| 5532 |
treeht double, |
|
| 5533 |
shrubht double, |
|
| 5534 |
fieldht double, |
|
| 5535 |
nonvascularht double, |
|
| 5536 |
submergedht double, |
|
| 5537 |
treecover double, |
|
| 5538 |
shrubcover double, |
|
| 5539 |
fieldcover double, |
|
| 5540 |
nonvascularcover double, |
|
| 5541 |
floatingcover double, |
|
| 5542 |
submergedcover double, |
|
| 5543 |
dominantstratum varchar(255), |
|
| 5544 |
growthform1type varchar(255), |
|
| 5545 |
growthform2type varchar(255), |
|
| 5546 |
growthform3type varchar(255), |
|
| 5547 |
growthform1cover double, |
|
| 5548 |
growthform2cover double, |
|
| 5549 |
growthform3cover double, |
|
| 5550 |
totalcover double, |
|
| 5551 |
notespublic int(1), |
|
| 5552 |
notesmgt int(1), |
|
| 5553 |
revisions int(1), |
|
| 5554 |
dateentered date , |
|
| 5555 |
toptaxon1name varchar(255), |
|
| 5556 |
toptaxon2name varchar(255), |
|
| 5557 |
toptaxon3name varchar(255), |
|
| 5558 |
toptaxon4name varchar(255), |
|
| 5559 |
toptaxon5name varchar(255), |
|
| 5560 |
numberoftaxa int(11) |
|
| 5433 |
CREATE TABLE commcorrelation ( |
|
| 5434 |
commcorrelation_id int(11) NOT NULL, |
|
| 5435 |
commstatus_id int(11) NOT NULL, |
|
| 5436 |
commconcept_id int(11) NOT NULL, |
|
| 5437 |
commconvergence varchar(255) NOT NULL, |
|
| 5438 |
correlationstart date NOT NULL, |
|
| 5439 |
correlationstop date |
|
| 5561 | 5440 |
); |
| 5562 | 5441 |
|
| 5563 | 5442 |
|
| 5564 | 5443 |
-- |
| 5565 |
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
|
|
| 5444 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5566 | 5445 |
-- |
| 5567 | 5446 |
|
| 5568 | 5447 |
|
| 5569 | 5448 |
|
| 5570 | 5449 |
|
| 5571 | 5450 |
-- |
| 5572 |
-- Name: COLUMN locationevent.place_visit_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5451 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5573 | 5452 |
-- |
| 5574 | 5453 |
|
| 5575 | 5454 |
|
| 5576 | 5455 |
|
| 5577 | 5456 |
|
| 5578 | 5457 |
-- |
| 5579 |
-- Name: COLUMN locationevent.plot_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5458 |
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5580 | 5459 |
-- |
| 5581 | 5460 |
|
| 5461 |
CREATE TABLE commdetermination ( |
|
| 5462 |
commdetermination_id int(11) NOT NULL, |
|
| 5463 |
commclass_id int(11) NOT NULL, |
|
| 5464 |
commconcept_id int(11) NOT NULL, |
|
| 5465 |
commcode varchar(255), |
|
| 5466 |
commname varchar(255), |
|
| 5467 |
classfit varchar(255), |
|
| 5468 |
classconfidence varchar(255), |
|
| 5469 |
commauthority_id int(11), |
|
| 5470 |
notes varchar(255), |
|
| 5471 |
type int(1), |
|
| 5472 |
nomenclaturaltype int(1) |
|
| 5473 |
); |
|
| 5582 | 5474 |
|
| 5583 | 5475 |
|
| 5584 |
|
|
| 5585 | 5476 |
-- |
| 5586 |
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5477 |
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5587 | 5478 |
-- |
| 5588 | 5479 |
|
| 5589 |
CREATE TABLE method ( |
|
| 5590 |
method_id int(11) NOT NULL, |
|
| 5591 |
source_id int(11) NOT NULL, |
|
| 5592 |
name varchar(255), |
|
| 5593 |
description varchar(255), |
|
| 5594 |
diameterheight_m double, |
|
| 5595 |
mindiameter_m double, |
|
| 5596 |
maxdiameter_m double, |
|
| 5597 |
minheight_m double, |
|
| 5598 |
maxheight_m double, |
|
| 5599 |
observationtype varchar(255), |
|
| 5600 |
observationmeasure varchar(255), |
|
| 5601 |
covermethod_id int(11), |
|
| 5602 |
samplingfactor double DEFAULT 1 NOT NULL, |
|
| 5603 |
coverbasis varchar(255), |
|
| 5604 |
stemsamplemethod varchar(255), |
|
| 5605 |
shape varchar(255), |
|
| 5606 |
length_m double, |
|
| 5607 |
width_m double, |
|
| 5608 |
radius_m double, |
|
| 5609 |
area_m2 double, |
|
| 5610 |
samplearea_m2 double, |
|
| 5611 |
subplotspacing_m double, |
|
| 5612 |
subplotmethod_id int(11), |
|
| 5613 |
pointsperline int(11) |
|
| 5614 |
); |
|
| 5615 | 5480 |
|
| 5616 | 5481 |
|
| 5482 |
|
|
| 5617 | 5483 |
-- |
| 5618 |
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
|
|
| 5484 |
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5619 | 5485 |
-- |
| 5620 | 5486 |
|
| 5621 | 5487 |
|
| 5622 | 5488 |
|
| 5623 | 5489 |
|
| 5624 | 5490 |
-- |
| 5625 |
-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5491 |
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5626 | 5492 |
-- |
| 5627 | 5493 |
|
| 5494 |
CREATE TABLE commlineage ( |
|
| 5495 |
commlineage_id int(11) NOT NULL, |
|
| 5496 |
parentcommstatus_id int(11) NOT NULL, |
|
| 5497 |
childcommstatus_id int(11) NOT NULL |
|
| 5498 |
); |
|
| 5628 | 5499 |
|
| 5629 | 5500 |
|
| 5630 |
|
|
| 5631 | 5501 |
-- |
| 5632 |
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
|
|
| 5502 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5633 | 5503 |
-- |
| 5634 | 5504 |
|
| 5635 | 5505 |
|
| 5636 | 5506 |
|
| 5637 | 5507 |
|
| 5638 | 5508 |
-- |
| 5639 |
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
|
|
| 5509 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5640 | 5510 |
-- |
| 5641 | 5511 |
|
| 5642 | 5512 |
|
| 5643 | 5513 |
|
| 5644 | 5514 |
|
| 5645 | 5515 |
-- |
| 5646 |
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5516 |
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5647 | 5517 |
-- |
| 5648 | 5518 |
|
| 5519 |
CREATE TABLE commname ( |
|
| 5520 |
commname_id int(11) NOT NULL, |
|
| 5521 |
commname varchar(255) NOT NULL, |
|
| 5522 |
source_id int(11), |
|
| 5523 |
dateentered date |
|
| 5524 |
); |
|
| 5649 | 5525 |
|
| 5650 | 5526 |
|
| 5651 |
|
|
| 5652 | 5527 |
-- |
| 5653 |
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5528 |
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5654 | 5529 |
-- |
| 5655 | 5530 |
|
| 5656 | 5531 |
|
| 5657 | 5532 |
|
| 5658 | 5533 |
|
| 5659 | 5534 |
-- |
| 5660 |
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5535 |
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5661 | 5536 |
-- |
| 5662 | 5537 |
|
| 5663 | 5538 |
|
| 5664 | 5539 |
|
| 5665 | 5540 |
|
| 5666 | 5541 |
-- |
| 5667 |
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5542 |
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5668 | 5543 |
-- |
| 5669 | 5544 |
|
| 5545 |
CREATE TABLE commstatus ( |
|
| 5546 |
commstatus_id int(11) NOT NULL, |
|
| 5547 |
commconcept_id int(11) NOT NULL, |
|
| 5548 |
source_id int(11), |
|
| 5549 |
commconceptstatus varchar(255) NOT NULL, |
|
| 5550 |
commparent_id int(11), |
|
| 5551 |
commlevel varchar(255), |
|
| 5552 |
commpartycomments varchar(255), |
|
| 5553 |
party_id int(11) NOT NULL, |
|
| 5554 |
startdate date NOT NULL, |
|
| 5555 |
stopdate date |
|
| 5556 |
); |
|
| 5670 | 5557 |
|
| 5671 | 5558 |
|
| 5672 |
|
|
| 5673 | 5559 |
-- |
| 5674 |
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5560 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5675 | 5561 |
-- |
| 5676 | 5562 |
|
| 5677 | 5563 |
|
| 5678 | 5564 |
|
| 5679 | 5565 |
|
| 5680 | 5566 |
-- |
| 5681 |
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
|
|
| 5567 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5682 | 5568 |
-- |
| 5683 | 5569 |
|
| 5684 | 5570 |
|
| 5685 | 5571 |
|
| 5686 | 5572 |
|
| 5687 | 5573 |
-- |
| 5688 |
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
|
|
| 5574 |
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5689 | 5575 |
-- |
| 5690 | 5576 |
|
| 5577 |
CREATE TABLE commusage ( |
|
| 5578 |
commusage_id int(11) NOT NULL, |
|
| 5579 |
commname_id int(11) NOT NULL, |
|
| 5580 |
commname varchar(255), |
|
| 5581 |
commconcept_id int(11), |
|
| 5582 |
commnamestatus varchar(255), |
|
| 5583 |
classsystem varchar(255), |
|
| 5584 |
party_id int(11), |
|
| 5585 |
commstatus_id int(11), |
|
| 5586 |
usagestart date, |
|
| 5587 |
usagestop date |
|
| 5588 |
); |
|
| 5691 | 5589 |
|
| 5692 | 5590 |
|
| 5693 |
|
|
| 5694 | 5591 |
-- |
| 5695 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
|
|
| 5592 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5696 | 5593 |
-- |
| 5697 | 5594 |
|
| 5698 | 5595 |
|
| 5699 | 5596 |
|
| 5700 | 5597 |
|
| 5701 | 5598 |
-- |
| 5702 |
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 5599 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5703 | 5600 |
-- |
| 5704 | 5601 |
|
| 5705 | 5602 |
|
| 5706 | 5603 |
|
| 5707 | 5604 |
|
| 5708 | 5605 |
-- |
| 5709 |
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
|
|
| 5606 |
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5710 | 5607 |
-- |
| 5711 | 5608 |
|
| 5609 |
CREATE TABLE coordinates ( |
|
| 5610 |
coordinates_id int(11) NOT NULL, |
|
| 5611 |
source_id int(11) NOT NULL, |
|
| 5612 |
latitude_deg double NOT NULL, |
|
| 5613 |
longitude_deg double NOT NULL, |
|
| 5614 |
verbatimlatitude varchar(255), |
|
| 5615 |
verbatimlongitude varchar(255), |
|
| 5616 |
verbatimcoordinates varchar(255), |
|
| 5617 |
footprintgeometry_dwc varchar(255), |
|
| 5618 |
coordsaccuracy_m double |
|
| 5619 |
); |
|
| 5712 | 5620 |
|
| 5713 | 5621 |
|
| 5714 |
|
|
| 5715 | 5622 |
-- |
| 5716 |
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
|
|
| 5623 |
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 5717 | 5624 |
-- |
| 5718 | 5625 |
|
| 5719 | 5626 |
|
| 5720 | 5627 |
|
| 5721 | 5628 |
|
| 5722 | 5629 |
-- |
| 5723 |
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
|
|
| 5630 |
-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5724 | 5631 |
-- |
| 5725 | 5632 |
|
| 5726 | 5633 |
|
| 5727 | 5634 |
|
| 5728 | 5635 |
|
| 5729 | 5636 |
-- |
| 5730 |
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5637 |
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5731 | 5638 |
-- |
| 5732 | 5639 |
|
| 5733 | 5640 |
|
| 5734 | 5641 |
|
| 5735 | 5642 |
|
| 5736 | 5643 |
-- |
| 5737 |
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5644 |
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5738 | 5645 |
-- |
| 5739 | 5646 |
|
| 5740 | 5647 |
|
| 5741 | 5648 |
|
| 5742 | 5649 |
|
| 5743 | 5650 |
-- |
| 5744 |
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
|
|
| 5651 |
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5745 | 5652 |
-- |
| 5746 | 5653 |
|
| 5654 |
CREATE TABLE coverindex ( |
|
| 5655 |
coverindex_id int(11) NOT NULL, |
|
| 5656 |
covermethod_id int(11) NOT NULL, |
|
| 5657 |
covercode varchar(255) NOT NULL, |
|
| 5658 |
upperlimit double, |
|
| 5659 |
lowerlimit double, |
|
| 5660 |
coverpercent double NOT NULL, |
|
| 5661 |
indexdescription varchar(255) |
|
| 5662 |
); |
|
| 5747 | 5663 |
|
| 5748 | 5664 |
|
| 5665 |
-- |
|
| 5666 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 5667 |
-- |
|
| 5749 | 5668 |
|
| 5669 |
|
|
| 5670 |
|
|
| 5671 |
|
|
| 5750 | 5672 |
-- |
| 5751 |
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5673 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5752 | 5674 |
-- |
| 5753 | 5675 |
|
| 5754 |
CREATE TABLE party ( |
|
| 5755 |
party_id int(11) NOT NULL, |
|
| 5756 |
source_id int(11) NOT NULL, |
|
| 5757 |
sourceaccessioncode varchar(255), |
|
| 5758 |
fullname varchar(255), |
|
| 5759 |
salutation varchar(255), |
|
| 5760 |
givenname varchar(255), |
|
| 5761 |
middlename varchar(255), |
|
| 5762 |
surname varchar(255), |
|
| 5763 |
suffix varchar(255), |
|
| 5764 |
department varchar(255), |
|
| 5765 |
organizationname varchar(255), |
|
| 5766 |
currentname_id int(11), |
|
| 5767 |
contactinstructions varchar(255), |
|
| 5768 |
email varchar(255), |
|
| 5769 |
partytype varchar(255), |
|
| 5770 |
partypublic int(1) DEFAULT true |
|
| 5771 |
); |
|
| 5772 | 5676 |
|
| 5773 | 5677 |
|
| 5678 |
|
|
| 5774 | 5679 |
-- |
| 5775 |
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5680 |
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5776 | 5681 |
-- |
| 5777 | 5682 |
|
| 5778 |
CREATE TABLE plantobservation ( |
|
| 5779 |
plantobservation_id int(11) NOT NULL, |
|
| 5780 |
source_id int(11) NOT NULL, |
|
| 5781 |
sourceaccessioncode varchar(255), |
|
| 5782 |
aggregateoccurrence_id int(11), |
|
| 5783 |
overallheight_m double, |
|
| 5784 |
overallheightaccuracy_m double, |
|
| 5785 |
authorplantcode varchar(255), |
|
| 5786 |
stemcount int(11), |
|
| 5787 |
reproductivecondition varchar(255), |
|
| 5788 |
plant_id int(11) |
|
| 5683 |
CREATE TABLE covermethod ( |
|
| 5684 |
covermethod_id int(11) NOT NULL, |
|
| 5685 |
source_id int(11), |
|
| 5686 |
covertype varchar(255) NOT NULL, |
|
| 5687 |
coverestimationmethod varchar(255) |
|
| 5789 | 5688 |
); |
| 5790 | 5689 |
|
| 5791 | 5690 |
|
| 5792 | 5691 |
-- |
| 5793 |
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
|
|
| 5692 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5794 | 5693 |
-- |
| 5795 | 5694 |
|
| 5796 | 5695 |
|
| 5797 | 5696 |
|
| 5798 | 5697 |
|
| 5799 | 5698 |
-- |
| 5800 |
-- Name: COLUMN plantobservation.authorplantcode; Type: COMMENT; Schema: public; Owner: -
|
|
| 5699 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5801 | 5700 |
-- |
| 5802 | 5701 |
|
| 5803 | 5702 |
|
| 5804 | 5703 |
|
| 5805 | 5704 |
|
| 5806 | 5705 |
-- |
| 5807 |
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5706 |
-- Name: cultivated_family_locations; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5808 | 5707 |
-- |
| 5809 | 5708 |
|
| 5810 |
CREATE TABLE project ( |
|
| 5811 |
project_id int(11) NOT NULL, |
|
| 5812 |
source_id int(11) NOT NULL, |
|
| 5813 |
sourceaccessioncode varchar(255), |
|
| 5814 |
projectname varchar(255), |
|
| 5815 |
projectdescription varchar(255), |
|
| 5816 |
startdate date, |
|
| 5817 |
stopdate date |
|
| 5709 |
CREATE TABLE cultivated_family_locations ( |
|
| 5710 |
family varchar(255) NOT NULL, |
|
| 5711 |
country varchar(255) NOT NULL |
|
| 5818 | 5712 |
); |
| 5819 | 5713 |
|
| 5820 | 5714 |
|
| 5821 | 5715 |
-- |
| 5822 |
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5716 |
-- Name: TABLE cultivated_family_locations; Type: COMMENT; Schema: public; Owner: -
|
|
| 5823 | 5717 |
-- |
| 5824 | 5718 |
|
| 5825 |
CREATE TABLE stratum ( |
|
| 5826 |
stratum_id int(11) NOT NULL, |
|
| 5827 |
source_id int(11) NOT NULL, |
|
| 5828 |
stratumname varchar(255) NOT NULL, |
|
| 5829 |
stratumheight double, |
|
| 5830 |
stratumbase double, |
|
| 5831 |
stratumcover double, |
|
| 5832 |
area double, |
|
| 5833 |
method_id int(11) |
|
| 5834 |
); |
|
| 5835 | 5719 |
|
| 5836 | 5720 |
|
| 5721 |
|
|
| 5837 | 5722 |
-- |
| 5838 |
-- Name: plot.**; Type: VIEW; Schema: public; Owner: -
|
|
| 5723 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5839 | 5724 |
-- |
| 5840 | 5725 |
|
| 5841 | 5726 |
|
| 5842 | 5727 |
|
| 5843 | 5728 |
|
| 5844 | 5729 |
-- |
| 5845 |
-- Name: COLUMN `plot.**`.datasource; Type: COMMENT; Schema: public; Owner: -
|
|
| 5730 |
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5846 | 5731 |
-- |
| 5847 | 5732 |
|
| 5733 |
CREATE TABLE definedvalue ( |
|
| 5734 |
definedvalue_id int(11) NOT NULL, |
|
| 5735 |
userdefined_id int(11) NOT NULL, |
|
| 5736 |
tablerecord_id int(11) NOT NULL, |
|
| 5737 |
definedvalue varchar(255) |
|
| 5738 |
); |
|
| 5848 | 5739 |
|
| 5849 | 5740 |
|
| 5850 |
|
|
| 5851 | 5741 |
-- |
| 5852 |
-- Name: COLUMN `plot.**`.country; Type: COMMENT; Schema: public; Owner: -
|
|
| 5742 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5853 | 5743 |
-- |
| 5854 | 5744 |
|
| 5855 | 5745 |
|
| 5856 | 5746 |
|
| 5857 | 5747 |
|
| 5858 | 5748 |
-- |
| 5859 |
-- Name: COLUMN `plot.**`.state_province; Type: COMMENT; Schema: public; Owner: -
|
|
| 5749 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5860 | 5750 |
-- |
| 5861 | 5751 |
|
| 5862 | 5752 |
|
| 5863 | 5753 |
|
| 5864 | 5754 |
|
| 5865 | 5755 |
-- |
| 5866 |
-- Name: COLUMN `plot.**`.county; Type: COMMENT; Schema: public; Owner: -
|
|
| 5756 |
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5867 | 5757 |
-- |
| 5868 | 5758 |
|
| 5759 |
CREATE TABLE disturbanceobs ( |
|
| 5760 |
disturbanceobs_id int(11) NOT NULL, |
|
| 5761 |
locationevent_id int(11) NOT NULL, |
|
| 5762 |
disturbancetype varchar(255) NOT NULL, |
|
| 5763 |
disturbanceintensity varchar(255), |
|
| 5764 |
disturbanceage double, |
|
| 5765 |
disturbanceextent double, |
|
| 5766 |
disturbancecomment varchar(255) |
|
| 5767 |
); |
|
| 5869 | 5768 |
|
| 5870 | 5769 |
|
| 5871 |
|
|
| 5872 | 5770 |
-- |
| 5873 |
-- Name: COLUMN `plot.**`.locality; Type: COMMENT; Schema: public; Owner: -
|
|
| 5771 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5874 | 5772 |
-- |
| 5875 | 5773 |
|
| 5876 | 5774 |
|
| 5877 | 5775 |
|
| 5878 | 5776 |
|
| 5879 | 5777 |
-- |
| 5880 |
-- Name: COLUMN `plot.**`.latitude; Type: COMMENT; Schema: public; Owner: -
|
|
| 5778 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5881 | 5779 |
-- |
| 5882 | 5780 |
|
| 5883 | 5781 |
|
| 5884 | 5782 |
|
| 5885 | 5783 |
|
| 5886 | 5784 |
-- |
| 5887 |
-- Name: COLUMN `plot.**`.longitude; Type: COMMENT; Schema: public; Owner: -
|
|
| 5785 |
-- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5888 | 5786 |
-- |
| 5889 | 5787 |
|
| 5788 |
CREATE TABLE family_higher_plant_group ( |
|
| 5789 |
family varchar(255) NOT NULL, |
|
| 5790 |
higher_plant_group varchar(255) |
|
| 5791 |
); |
|
| 5890 | 5792 |
|
| 5891 | 5793 |
|
| 5892 |
|
|
| 5893 | 5794 |
-- |
| 5894 |
-- Name: COLUMN `plot.**`.coord_uncertainty_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5795 |
-- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5895 | 5796 |
-- |
| 5896 | 5797 |
|
| 5798 |
CREATE TABLE geoscrub_input ( |
|
| 5799 |
country varchar(255), |
|
| 5800 |
`stateProvince` varchar(255), |
|
| 5801 |
county varchar(255), |
|
| 5802 |
`decimalLatitude` double, |
|
| 5803 |
`decimalLongitude` double |
|
| 5804 |
); |
|
| 5897 | 5805 |
|
| 5898 | 5806 |
|
| 5899 |
|
|
| 5900 | 5807 |
-- |
| 5901 |
-- Name: COLUMN `plot.**`.georef_sources; Type: COMMENT; Schema: public; Owner: -
|
|
| 5808 |
-- Name: geoscrub_input_new; Type: VIEW; Schema: public; Owner: -
|
|
| 5902 | 5809 |
-- |
| 5903 | 5810 |
|
| 5904 | 5811 |
|
| 5905 | 5812 |
|
| 5906 | 5813 |
|
| 5907 | 5814 |
-- |
| 5908 |
-- Name: COLUMN `plot.**`.georef_protocol; Type: COMMENT; Schema: public; Owner: -
|
|
| 5815 |
-- Name: geoscrub_input_view; Type: VIEW; Schema: public; Owner: -
|
|
| 5909 | 5816 |
-- |
| 5910 | 5817 |
|
| 5911 | 5818 |
|
| 5912 | 5819 |
|
| 5913 | 5820 |
|
| 5914 | 5821 |
-- |
| 5915 |
-- Name: COLUMN `plot.**`.is_geovalid; Type: COMMENT; Schema: public; Owner: -
|
|
| 5822 |
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5916 | 5823 |
-- |
| 5917 | 5824 |
|
| 5825 |
CREATE TABLE graphic ( |
|
| 5826 |
graphic_id int(11) NOT NULL, |
|
| 5827 |
locationevent_id int(11) NOT NULL, |
|
| 5828 |
graphicname varchar(255), |
|
| 5829 |
graphiclocation varchar(255), |
|
| 5830 |
graphicdescription varchar(255), |
|
| 5831 |
graphictype varchar(255), |
|
| 5832 |
graphicdata int(11), |
|
| 5833 |
graphicdate date |
|
| 5834 |
); |
|
| 5918 | 5835 |
|
| 5919 | 5836 |
|
| 5920 |
|
|
| 5921 | 5837 |
-- |
| 5922 |
-- Name: COLUMN `plot.**`.is_new_world; Type: COMMENT; Schema: public; Owner: -
|
|
| 5838 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5923 | 5839 |
-- |
| 5924 | 5840 |
|
| 5925 | 5841 |
|
| 5926 | 5842 |
|
| 5927 | 5843 |
|
| 5928 | 5844 |
-- |
| 5929 |
-- Name: COLUMN `plot.**`.project_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5845 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5930 | 5846 |
-- |
| 5931 | 5847 |
|
| 5932 | 5848 |
|
| 5933 | 5849 |
|
| 5934 | 5850 |
|
| 5935 | 5851 |
-- |
| 5936 |
-- Name: COLUMN `plot.**`.project_contributors; Type: COMMENT; Schema: public; Owner: -
|
|
| 5852 |
-- Name: higher_plant_group_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5937 | 5853 |
-- |
| 5938 | 5854 |
|
| 5855 |
CREATE TABLE higher_plant_group_nodes ( |
|
| 5856 |
higher_plant_group varchar(255), |
|
| 5857 |
node_name varchar(255) NOT NULL |
|
| 5858 |
); |
|
| 5939 | 5859 |
|
| 5940 | 5860 |
|
| 5941 |
|
|
| 5942 | 5861 |
-- |
| 5943 |
-- Name: COLUMN `plot.**`.location_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5862 |
-- Name: iucn_red_list_view; Type: VIEW; Schema: public; Owner: -
|
|
| 5944 | 5863 |
-- |
| 5945 | 5864 |
|
| 5946 | 5865 |
|
| 5947 | 5866 |
|
| 5948 | 5867 |
|
| 5949 | 5868 |
-- |
| 5950 |
-- Name: COLUMN `plot.**`.plot_name; Type: COMMENT; Schema: public; Owner: -
|
|
| 5869 |
-- Name: VIEW iucn_red_list_view; Type: COMMENT; Schema: public; Owner: -
|
|
| 5951 | 5870 |
-- |
| 5952 | 5871 |
|
| 5953 | 5872 |
|
| 5954 | 5873 |
|
| 5955 | 5874 |
|
| 5956 | 5875 |
-- |
| 5957 |
-- Name: COLUMN `plot.**`.subplot; Type: COMMENT; Schema: public; Owner: -
|
|
| 5876 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5958 | 5877 |
-- |
| 5959 | 5878 |
|
| 5879 |
CREATE TABLE location ( |
|
| 5880 |
location_id int(11) NOT NULL, |
|
| 5881 |
source_id int(11) NOT NULL, |
|
| 5882 |
sourceaccessioncode varchar(255), |
|
| 5883 |
plot_location_id int(11) NOT NULL, |
|
| 5884 |
parent_id int(11), |
|
| 5885 |
authorlocationcode varchar(255), |
|
| 5886 |
place_id int(11), |
|
| 5887 |
accesslevel varchar(255), |
|
| 5888 |
accessconditions varchar(255), |
|
| 5889 |
sublocationxposition_m double, |
|
| 5890 |
sublocationyposition_m double, |
|
| 5891 |
iscultivated int(1), |
|
| 5892 |
authorzone varchar(255), |
|
| 5893 |
authordatum varchar(255), |
|
| 5894 |
authorlocation varchar(255), |
|
| 5895 |
locationnarrative varchar(255), |
|
| 5896 |
azimuth double, |
|
| 5897 |
shape varchar(255), |
|
| 5898 |
area_m2 double, |
|
| 5899 |
standsize varchar(255), |
|
| 5900 |
placementmethod varchar(255), |
|
| 5901 |
permanence int(1), |
|
| 5902 |
layoutnarrative varchar(255), |
|
| 5903 |
elevation_m double, |
|
| 5904 |
elevationaccuracy_m double, |
|
| 5905 |
elevationrange_m double, |
|
| 5906 |
verbatimelevation varchar(255), |
|
| 5907 |
slopeaspect_deg double, |
|
| 5908 |
minslopeaspect_deg double, |
|
| 5909 |
maxslopeaspect_deg double, |
|
| 5910 |
slopegradient_fraction double, |
|
| 5911 |
minslopegradient_fraction double, |
|
| 5912 |
maxslopegradient_fraction double, |
|
| 5913 |
topoposition varchar(255), |
|
| 5914 |
landform varchar(255), |
|
| 5915 |
surficialdeposits varchar(255), |
|
| 5916 |
rocktype varchar(255), |
|
| 5917 |
submitter_surname varchar(255), |
|
| 5918 |
submitter_givenname varchar(255), |
|
| 5919 |
submitter_email varchar(255), |
|
| 5920 |
notespublic int(1), |
|
| 5921 |
notesmgt int(1), |
|
| 5922 |
revisions int(1), |
|
| 5923 |
dateentered date , |
|
| 5924 |
locationrationalenarrative varchar(255) |
|
| 5925 |
); |
|
| 5960 | 5926 |
|
| 5961 | 5927 |
|
| 5962 |
|
|
| 5963 | 5928 |
-- |
| 5964 |
-- Name: COLUMN `plot.**`.is_location_cultivated; Type: COMMENT; Schema: public; Owner: -
|
|
| 5929 |
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
|
|
| 5965 | 5930 |
-- |
| 5966 | 5931 |
|
| 5967 | 5932 |
|
| 5968 | 5933 |
|
| 5969 | 5934 |
|
| 5970 | 5935 |
-- |
| 5971 |
-- Name: COLUMN `plot.**`.locationevent_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5936 |
-- Name: COLUMN location.plot_location_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5972 | 5937 |
-- |
| 5973 | 5938 |
|
| 5974 | 5939 |
|
| 5975 | 5940 |
|
| 5976 | 5941 |
|
| 5977 | 5942 |
-- |
| 5978 |
-- Name: COLUMN `plot.**`.event_date; Type: COMMENT; Schema: public; Owner: -
|
|
| 5943 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5979 | 5944 |
-- |
| 5980 | 5945 |
|
| 5981 | 5946 |
|
| 5982 | 5947 |
|
| 5983 | 5948 |
|
| 5984 | 5949 |
-- |
| 5985 |
-- Name: COLUMN `plot.**`.elevation_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5950 |
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5986 | 5951 |
-- |
| 5987 | 5952 |
|
| 5988 | 5953 |
|
| 5989 | 5954 |
|
| 5990 | 5955 |
|
| 5991 | 5956 |
-- |
| 5992 |
-- Name: COLUMN `plot.**`.slope_aspect_deg; Type: COMMENT; Schema: public; Owner: -
|
|
| 5957 |
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5993 | 5958 |
-- |
| 5994 | 5959 |
|
| 5960 |
CREATE TABLE locationevent ( |
|
| 5961 |
locationevent_id int(11) NOT NULL, |
|
| 5962 |
source_id int(11) NOT NULL, |
|
| 5963 |
sourceaccessioncode varchar(255), |
|
| 5964 |
accesslevel varchar(255), |
|
| 5965 |
place_visit_id int(11) NOT NULL, |
|
| 5966 |
parent_id int(11), |
|
| 5967 |
plot_id int(11), |
|
| 5968 |
location_id int(11), |
|
| 5969 |
project_id int(11), |
|
| 5970 |
stratum_id int(11), |
|
| 5971 |
authoreventcode varchar(255), |
|
| 5972 |
previous_id int(11), |
|
| 5973 |
obsstartdate date, |
|
| 5974 |
obsenddate date, |
|
| 5975 |
dateaccuracy varchar(255), |
|
| 5976 |
method_id int(11), |
|
| 5977 |
temperature_c double, |
|
| 5978 |
precipitation_m double, |
|
| 5979 |
autotaxoncover int(1), |
|
| 5980 |
originaldata varchar(255), |
|
| 5981 |
effortlevel varchar(255), |
|
| 5982 |
floristicquality varchar(255), |
|
| 5983 |
bryophytequality varchar(255), |
|
| 5984 |
lichenquality varchar(255), |
|
| 5985 |
locationeventnarrative varchar(255), |
|
| 5986 |
landscapenarrative varchar(255), |
|
| 5987 |
homogeneity varchar(255), |
|
| 5988 |
phenologicaspect varchar(255), |
|
| 5989 |
representativeness varchar(255), |
|
| 5990 |
standmaturity varchar(255), |
|
| 5991 |
successionalstatus varchar(255), |
|
| 5992 |
basalarea double, |
|
| 5993 |
hydrologicregime varchar(255), |
|
| 5994 |
soilmoistureregime varchar(255), |
|
| 5995 |
soildrainage varchar(255), |
|
| 5996 |
watersalinity varchar(255), |
|
| 5997 |
waterdepth_m double, |
|
| 5998 |
shoredistance double, |
|
| 5999 |
soildepth double, |
|
| 6000 |
organicdepth double, |
|
| 6001 |
soiltaxon_id int(11), |
|
| 6002 |
soiltaxonsrc varchar(255), |
|
| 6003 |
percentbedrock double, |
|
| 6004 |
percentrockgravel double, |
|
| 6005 |
percentwood double, |
|
| 6006 |
percentlitter double, |
|
| 6007 |
percentbaresoil double, |
|
| 6008 |
percentwater double, |
|
| 6009 |
percentother double, |
|
| 6010 |
nameother varchar(255), |
|
| 6011 |
treeht double, |
|
| 6012 |
shrubht double, |
|
| 6013 |
fieldht double, |
|
| 6014 |
nonvascularht double, |
|
| 6015 |
submergedht double, |
|
| 6016 |
treecover double, |
|
| 6017 |
shrubcover double, |
|
| 6018 |
fieldcover double, |
|
| 6019 |
nonvascularcover double, |
|
| 6020 |
floatingcover double, |
|
| 6021 |
submergedcover double, |
|
| 6022 |
dominantstratum varchar(255), |
|
| 6023 |
growthform1type varchar(255), |
|
| 6024 |
growthform2type varchar(255), |
|
| 6025 |
growthform3type varchar(255), |
|
| 6026 |
growthform1cover double, |
|
| 6027 |
growthform2cover double, |
|
| 6028 |
growthform3cover double, |
|
| 6029 |
totalcover double, |
|
| 6030 |
notespublic int(1), |
|
| 6031 |
notesmgt int(1), |
|
| 6032 |
revisions int(1), |
|
| 6033 |
dateentered date , |
|
| 6034 |
toptaxon1name varchar(255), |
|
| 6035 |
toptaxon2name varchar(255), |
|
| 6036 |
toptaxon3name varchar(255), |
|
| 6037 |
toptaxon4name varchar(255), |
|
| 6038 |
toptaxon5name varchar(255), |
|
| 6039 |
numberoftaxa int(11) |
|
| 6040 |
); |
|
| 5995 | 6041 |
|
| 5996 | 6042 |
|
| 5997 |
|
|
| 5998 | 6043 |
-- |
| 5999 |
-- Name: COLUMN `plot.**`.slope_gradient_deg; Type: COMMENT; Schema: public; Owner: -
|
|
| 6044 |
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
|
|
| 6000 | 6045 |
-- |
| 6001 | 6046 |
|
| 6002 | 6047 |
|
| 6003 | 6048 |
|
| 6004 | 6049 |
|
| 6005 | 6050 |
-- |
| 6006 |
-- Name: COLUMN `plot.**`.plot_area_ha; Type: COMMENT; Schema: public; Owner: -
|
|
| 6051 |
-- Name: COLUMN locationevent.place_visit_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6007 | 6052 |
-- |
| 6008 | 6053 |
|
| 6009 | 6054 |
|
| 6010 | 6055 |
|
| 6011 | 6056 |
|
| 6012 | 6057 |
-- |
| 6013 |
-- Name: COLUMN `plot.**`.sampling_protocol; Type: COMMENT; Schema: public; Owner: -
|
|
| 6058 |
-- Name: COLUMN locationevent.plot_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6014 | 6059 |
-- |
| 6015 | 6060 |
|
| 6016 | 6061 |
|
| 6017 | 6062 |
|
| 6018 | 6063 |
|
| 6019 | 6064 |
-- |
| 6020 |
-- Name: COLUMN `plot.**`.temperature_c; Type: COMMENT; Schema: public; Owner: -
|
|
| 6065 |
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6021 | 6066 |
-- |
| 6022 | 6067 |
|
| 6023 | 6068 |
|
| 6024 | 6069 |
|
| 6025 | 6070 |
|
| 6026 | 6071 |
-- |
| 6027 |
-- Name: COLUMN `plot.**`.precip_mm; Type: COMMENT; Schema: public; Owner: -
|
|
| 6072 |
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6028 | 6073 |
-- |
| 6029 | 6074 |
|
| 6030 | 6075 |
|
| 6031 | 6076 |
|
| 6032 | 6077 |
|
| 6033 | 6078 |
-- |
| 6034 |
-- Name: COLUMN `plot.**`.stratum_name; Type: COMMENT; Schema: public; Owner: -
|
|
| 6079 |
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6035 | 6080 |
-- |
| 6036 | 6081 |
|
| 6082 |
CREATE TABLE locationeventcontributor ( |
|
| 6083 |
locationeventcontributor_id int(11) NOT NULL, |
|
| 6084 |
locationevent_id int(11) NOT NULL, |
|
| 6085 |
party_id int(11) NOT NULL, |
|
| 6086 |
role varchar(255), |
|
| 6087 |
contributiondate date |
|
| 6088 |
); |
|
| 6037 | 6089 |
|
| 6038 | 6090 |
|
| 6039 |
|
|
| 6040 | 6091 |
-- |
| 6041 |
-- Name: COLUMN `plot.**`.community_concept_name; Type: COMMENT; Schema: public; Owner: -
|
|
| 6092 |
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6042 | 6093 |
-- |
| 6043 | 6094 |
|
| 6044 | 6095 |
|
| 6045 | 6096 |
|
| 6046 | 6097 |
|
| 6047 | 6098 |
-- |
| 6048 |
-- Name: COLUMN `plot.**`.observation_contributors; Type: COMMENT; Schema: public; Owner: -
|
|
| 6099 |
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6049 | 6100 |
-- |
| 6050 | 6101 |
|
| 6051 | 6102 |
|
| 6052 | 6103 |
|
| 6053 | 6104 |
|
| 6054 | 6105 |
-- |
| 6055 |
-- Name: sourcelist; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6106 |
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6056 | 6107 |
-- |
| 6057 | 6108 |
|
| 6058 |
CREATE TABLE sourcelist ( |
|
| 6059 |
sourcelist_id int(11) NOT NULL, |
|
| 6060 |
source_id int(11) NOT NULL, |
|
| 6061 |
name varchar(255) NOT NULL |
|
| 6109 |
CREATE TABLE locationeventsynonym ( |
|
| 6110 |
locationeventsynonym_id int(11) NOT NULL, |
|
| 6111 |
synonymlocationevent_id int(11) NOT NULL, |
|
| 6112 |
primarylocationevent_id int(11) NOT NULL, |
|
| 6113 |
party_id int(11) NOT NULL, |
|
| 6114 |
role varchar(255) NOT NULL, |
|
| 6115 |
synonymcomment varchar(255), |
|
| 6116 |
classstartdate date NOT NULL, |
|
| 6117 |
classstopdate date |
|
| 6062 | 6118 |
); |
| 6063 | 6119 |
|
| 6064 | 6120 |
|
| 6065 | 6121 |
-- |
| 6066 |
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6122 |
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6067 | 6123 |
-- |
| 6068 | 6124 |
|
| 6069 |
CREATE TABLE specimenreplicate ( |
|
| 6070 |
specimenreplicate_id int(11) NOT NULL, |
|
| 6071 |
source_id int(11) NOT NULL, |
|
| 6072 |
sourceaccessioncode varchar(255), |
|
| 6073 |
plantobservation_id int(11), |
|
| 6074 |
duplicate_institutions_sourcelist_id int(11), |
|
| 6075 |
collectioncode_dwc varchar(255), |
|
| 6076 |
catalognumber_dwc varchar(255), |
|
| 6077 |
collectionnumber varchar(255), |
|
| 6078 |
description varchar(255), |
|
| 6079 |
specimen_id int(11) |
|
| 6080 |
); |
|
| 6081 | 6125 |
|
| 6082 | 6126 |
|
| 6127 |
|
|
| 6083 | 6128 |
-- |
| 6084 |
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
|
|
| 6129 |
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6085 | 6130 |
-- |
| 6086 | 6131 |
|
| 6087 | 6132 |
|
| 6088 | 6133 |
|
| 6089 | 6134 |
|
| 6090 | 6135 |
-- |
| 6091 |
-- Name: COLUMN specimenreplicate.duplicate_institutions_sourcelist_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6136 |
-- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6092 | 6137 |
-- |
| 6093 | 6138 |
|
| 6139 |
CREATE TABLE locationplace ( |
|
| 6140 |
locationplace_id int(11) NOT NULL, |
|
| 6141 |
location_id int(11) NOT NULL, |
|
| 6142 |
place_id int(11) NOT NULL, |
|
| 6143 |
identifier_id int(11) |
|
| 6144 |
); |
|
| 6094 | 6145 |
|
| 6095 | 6146 |
|
| 6096 |
|
|
| 6097 | 6147 |
-- |
| 6098 |
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 6148 |
-- Name: TABLE locationplace; Type: COMMENT; Schema: public; Owner: -
|
|
| 6099 | 6149 |
-- |
| 6100 | 6150 |
|
| 6101 | 6151 |
|
| 6102 | 6152 |
|
| 6103 | 6153 |
|
| 6104 | 6154 |
-- |
| 6105 |
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6155 |
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6106 | 6156 |
-- |
| 6107 | 6157 |
|
| 6108 |
CREATE TABLE taxondetermination ( |
|
| 6109 |
taxondetermination_id int(11) NOT NULL, |
|
| 6110 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 6111 |
source_id int(11) NOT NULL, |
|
| 6112 |
taxonverbatim_id int(11) NOT NULL, |
|
| 6113 |
party_id int(11), |
|
| 6114 |
role varchar(255) DEFAULT 'unknown' NOT NULL, |
|
| 6115 |
determinationtype varchar(255), |
|
| 6116 |
reference_id int(11), |
|
| 6117 |
isoriginal int(1), |
|
| 6118 |
iscurrent__verbatim int(1), |
|
| 6119 |
iscurrent int(1) DEFAULT false NOT NULL, |
|
| 6120 |
taxonfit varchar(255), |
|
| 6121 |
taxonconfidence varchar(255), |
|
| 6122 |
grouptype varchar(255), |
|
| 6123 |
notes varchar(255), |
|
| 6124 |
revisions int(1), |
|
| 6125 |
determinationdate date |
|
| 6126 |
); |
|
| 6127 | 6158 |
|
| 6128 | 6159 |
|
| 6160 |
|
|
| 6129 | 6161 |
-- |
| 6130 |
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
|
|
| 6162 |
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6131 | 6163 |
-- |
| 6132 | 6164 |
|
| 6133 | 6165 |
|
| 6134 | 6166 |
|
| 6135 | 6167 |
|
| 6136 | 6168 |
-- |
| 6137 |
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6169 |
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6138 | 6170 |
-- |
| 6139 | 6171 |
|
| 6140 |
CREATE TABLE taxonoccurrence (
|
|
| 6141 |
taxonoccurrence_id int(11) NOT NULL,
|
|
| 6172 |
CREATE TABLE method (
|
|
| 6173 |
method_id int(11) NOT NULL,
|
|
| 6142 | 6174 |
source_id int(11) NOT NULL, |
| 6143 |
sourceaccessioncode varchar(255), |
|
| 6144 |
locationevent_id int(11), |
|
| 6145 |
authortaxoncode varchar(255), |
|
| 6146 |
collector_id int(11), |
|
| 6147 |
growthform varchar(255), |
|
| 6148 |
iscultivated int(1), |
|
| 6149 |
cultivatedbasis varchar(255), |
|
| 6150 |
isnative int(1) |
|
| 6175 |
name varchar(255), |
|
| 6176 |
description varchar(255), |
|
| 6177 |
diameterheight_m double, |
|
| 6178 |
mindiameter_m double, |
|
| 6179 |
maxdiameter_m double, |
|
| 6180 |
minheight_m double, |
|
| 6181 |
maxheight_m double, |
|
| 6182 |
observationtype varchar(255), |
|
| 6183 |
observationmeasure varchar(255), |
|
| 6184 |
covermethod_id int(11), |
|
| 6185 |
samplingfactor double DEFAULT 1 NOT NULL, |
|
| 6186 |
coverbasis varchar(255), |
|
| 6187 |
stemsamplemethod varchar(255), |
|
| 6188 |
shape varchar(255), |
|
| 6189 |
length_m double, |
|
| 6190 |
width_m double, |
|
| 6191 |
radius_m double, |
|
| 6192 |
area_m2 double, |
|
| 6193 |
samplearea_m2 double, |
|
| 6194 |
subplotspacing_m double, |
|
| 6195 |
subplotmethod_id int(11), |
|
| 6196 |
pointsperline int(11) |
|
| 6151 | 6197 |
); |
| 6152 | 6198 |
|
| 6153 | 6199 |
|
| 6154 | 6200 |
-- |
| 6155 |
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
|
|
| 6201 |
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
|
|
| 6156 | 6202 |
-- |
| 6157 | 6203 |
|
| 6158 | 6204 |
|
| 6159 | 6205 |
|
| 6160 | 6206 |
|
| 6161 | 6207 |
-- |
| 6162 |
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
|
|
| 6208 |
-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6163 | 6209 |
-- |
| 6164 | 6210 |
|
| 6165 | 6211 |
|
| 6166 | 6212 |
|
| 6167 | 6213 |
|
| 6168 | 6214 |
-- |
| 6169 |
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 6215 |
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
|
|
| 6170 | 6216 |
-- |
| 6171 | 6217 |
|
| 6172 | 6218 |
|
| 6173 | 6219 |
|
| 6174 | 6220 |
|
| 6175 | 6221 |
-- |
| 6176 |
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
|
|
| 6222 |
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
|
|
| 6177 | 6223 |
-- |
| 6178 | 6224 |
|
| 6179 | 6225 |
|
| 6180 | 6226 |
|
| 6181 | 6227 |
|
| 6182 | 6228 |
-- |
| 6183 |
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6229 |
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6184 | 6230 |
-- |
| 6185 | 6231 |
|
| 6186 |
CREATE TABLE taxonverbatim ( |
|
| 6187 |
taxonverbatim_id int(11) NOT NULL, |
|
| 6188 |
source_id int(11) NOT NULL, |
|
| 6189 |
taxonlabel_id int(11), |
|
| 6190 |
verbatimrank varchar(255), |
|
| 6191 |
taxonomicname varchar(255), |
|
| 6192 |
taxonname varchar(255), |
|
| 6193 |
author varchar(255), |
|
| 6194 |
family varchar(255), |
|
| 6195 |
genus varchar(255), |
|
| 6196 |
specific_epithet varchar(255), |
|
| 6197 |
subspecies varchar(255), |
|
| 6198 |
morphospecies varchar(255), |
|
| 6199 |
morphoname varchar(255), |
|
| 6200 |
growthform varchar(255), |
|
| 6201 |
description varchar(255) |
|
| 6202 |
); |
|
| 6203 | 6232 |
|
| 6204 | 6233 |
|
| 6234 |
|
|
| 6205 | 6235 |
-- |
| 6206 |
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
|
|
| 6236 |
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6207 | 6237 |
-- |
| 6208 | 6238 |
|
| 6209 | 6239 |
|
| 6210 | 6240 |
|
| 6211 | 6241 |
|
| 6212 | 6242 |
-- |
| 6213 |
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
|
|
| 6243 |
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6214 | 6244 |
-- |
| 6215 | 6245 |
|
| 6216 | 6246 |
|
| 6217 | 6247 |
|
| 6218 | 6248 |
|
| 6219 | 6249 |
-- |
| 6220 |
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
|
|
| 6250 |
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6221 | 6251 |
-- |
| 6222 | 6252 |
|
| 6223 | 6253 |
|
| 6224 | 6254 |
|
| 6225 | 6255 |
|
| 6226 | 6256 |
-- |
| 6227 |
-- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: -
|
|
| 6257 |
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6228 | 6258 |
-- |
| 6229 | 6259 |
|
| 6230 | 6260 |
|
| 6231 | 6261 |
|
| 6232 | 6262 |
|
| 6233 | 6263 |
-- |
| 6234 |
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
|
|
| 6264 |
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
|
|
| 6235 | 6265 |
-- |
| 6236 | 6266 |
|
| 6237 | 6267 |
|
| 6238 | 6268 |
|
| 6239 | 6269 |
|
| 6240 | 6270 |
-- |
| 6241 |
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
|
|
| 6271 |
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
|
|
| 6242 | 6272 |
-- |
| 6243 | 6273 |
|
| 6244 | 6274 |
|
| 6245 | 6275 |
|
| 6246 | 6276 |
|
| 6247 | 6277 |
-- |
| 6248 |
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 6278 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
|
|
| 6249 | 6279 |
-- |
| 6250 | 6280 |
|
| 6251 | 6281 |
|
| 6252 | 6282 |
|
| 6253 | 6283 |
|
| 6254 | 6284 |
-- |
| 6255 |
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 6285 |
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 6256 | 6286 |
-- |
| 6257 | 6287 |
|
| 6258 | 6288 |
|
| 6259 | 6289 |
|
| 6260 | 6290 |
|
| 6261 | 6291 |
-- |
| 6262 |
-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -
|
|
| 6292 |
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
|
|
| 6263 | 6293 |
-- |
| 6264 | 6294 |
|
| 6265 | 6295 |
|
| 6266 | 6296 |
|
| 6267 | 6297 |
|
| 6268 | 6298 |
-- |
| 6269 |
-- Name: view_full_occurrence_individual_view; Type: VIEW; Schema: public; Owner: -
|
|
| 6299 |
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
|
|
| 6270 | 6300 |
-- |
| 6271 | 6301 |
|
| 6272 | 6302 |
|
| 6273 | 6303 |
|
| 6274 | 6304 |
|
| 6275 | 6305 |
-- |
| 6276 |
-- Name: VIEW view_full_occurrence_individual_view; Type: COMMENT; Schema: public; Owner: -
|
|
| 6306 |
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
|
|
| 6277 | 6307 |
-- |
| 6278 | 6308 |
|
| 6279 | 6309 |
|
| 6280 | 6310 |
|
| 6281 | 6311 |
|
| 6282 | 6312 |
-- |
| 6283 |
-- Name: COLUMN view_full_occurrence_individual_view.datasource; Type: COMMENT; Schema: public; Owner: -
|
|
| 6313 |
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6284 | 6314 |
-- |
| 6285 | 6315 |
|
| 6286 | 6316 |
|
| 6287 | 6317 |
|
| 6288 | 6318 |
|
| 6289 | 6319 |
-- |
| 6290 |
-- Name: COLUMN view_full_occurrence_individual_view.country; Type: COMMENT; Schema: public; Owner: -
|
|
| 6320 |
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6291 | 6321 |
-- |
| 6292 | 6322 |
|
| 6293 | 6323 |
|
| 6294 | 6324 |
|
| 6295 | 6325 |
|
| 6296 | 6326 |
-- |
| 6297 |
-- Name: COLUMN view_full_occurrence_individual_view.state_province; Type: COMMENT; Schema: public; Owner: -
|
|
| 6327 |
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
|
|
| 6298 | 6328 |
-- |
| 6299 | 6329 |
|
| 6300 | 6330 |
|
| 6301 | 6331 |
|
| 6302 | 6332 |
|
| 6303 | 6333 |
-- |
| 6304 |
-- Name: COLUMN view_full_occurrence_individual_view.county; Type: COMMENT; Schema: public; Owner: -
|
|
| 6334 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6305 | 6335 |
-- |
| 6306 | 6336 |
|
| 6307 | 6337 |
|
| 6308 | 6338 |
|
| 6309 | 6339 |
|
| 6310 | 6340 |
-- |
| 6311 |
-- Name: COLUMN view_full_occurrence_individual_view.locality; Type: COMMENT; Schema: public; Owner: -
|
|
| 6341 |
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6312 | 6342 |
-- |
| 6313 | 6343 |
|
| 6314 | 6344 |
|
| 6315 | 6345 |
|
| 6316 | 6346 |
|
| 6317 | 6347 |
-- |
| 6318 |
-- Name: COLUMN view_full_occurrence_individual_view.latitude; Type: COMMENT; Schema: public; Owner: -
|
|
| 6348 |
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 6319 | 6349 |
-- |
| 6320 | 6350 |
|
| 6351 |
CREATE TABLE methodtaxonclass ( |
|
| 6352 |
methodtaxonclass_id int(11) NOT NULL, |
|
| 6353 |
method_id int(11) NOT NULL, |
|
| 6354 |
taxonlabel_id int(11), |
|
| 6355 |
included int(1) NOT NULL, |
|
| 6356 |
submethod_id int(11), |
|
| 6357 |
taxonclass varchar(255) |
|
| 6358 |
); |
|
| 6321 | 6359 |
|
| 6322 | 6360 |
|
| 6323 |
|
|
| 6324 | 6361 |
-- |
| 6325 |
-- Name: COLUMN view_full_occurrence_individual_view.longitude; Type: COMMENT; Schema: public; Owner: -
|
|
| 6362 |
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
|
|
| 6326 | 6363 |
-- |
| 6327 | 6364 |
|
| 6328 | 6365 |
|
| 6329 | 6366 |
|
| 6330 | 6367 |
|
| 6331 | 6368 |
-- |
| 6332 |
-- Name: COLUMN view_full_occurrence_individual_view.coord_uncertainty_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 6369 |
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 6333 | 6370 |
-- |
| 6334 | 6371 |
|
| 6335 | 6372 |
|
| 6336 | 6373 |
|
| 6337 | 6374 |
|
Also available in: Unified diff
schemas/public_.sql: views that use view_full_occurrence_individual_view: use the view_full_occurrence_individual table instead, now that this is materialized.