Revision 13655
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4250 | 4250 |
|
| 4251 | 4251 |
|
| 4252 | 4252 |
-- |
| 4253 |
-- Name: COLUMN analytical_stem_view.`coordinateSource_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4254 |
-- |
|
| 4255 |
|
|
| 4256 |
|
|
| 4257 |
|
|
| 4258 |
|
|
| 4259 |
-- |
|
| 4260 |
-- Name: COLUMN analytical_stem_view.`georeferenceProtocol_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4261 |
-- |
|
| 4262 |
|
|
| 4263 |
|
|
| 4264 |
|
|
| 4265 |
|
|
| 4266 |
-- |
|
| 4267 |
-- Name: COLUMN analytical_stem_view.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4268 |
-- |
|
| 4269 |
|
|
| 4270 |
|
|
| 4271 |
|
|
| 4272 |
|
|
| 4273 |
-- |
|
| 4274 |
-- Name: COLUMN analytical_stem_view.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4275 |
-- |
|
| 4276 |
|
|
| 4277 |
|
|
| 4278 |
|
|
| 4279 |
|
|
| 4280 |
-- |
|
| 4281 |
-- Name: COLUMN analytical_stem_view.`projectID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4282 |
-- |
|
| 4283 |
|
|
| 4284 |
|
|
| 4285 |
|
|
| 4286 |
|
|
| 4287 |
-- |
|
| 4288 |
-- Name: COLUMN analytical_stem_view.project_contributors; Type: COMMENT; Schema: public; Owner: - |
|
| 4289 |
-- |
|
| 4290 |
|
|
| 4291 |
|
|
| 4292 |
|
|
| 4293 |
|
|
| 4294 |
-- |
|
| 4253 | 4295 |
-- Name: COLUMN analytical_stem_view.`locationID`; Type: COMMENT; Schema: public; Owner: - |
| 4254 | 4296 |
-- |
| 4255 | 4297 |
|
| ... | ... | |
| 4264 | 4306 |
|
| 4265 | 4307 |
|
| 4266 | 4308 |
-- |
| 4309 |
-- Name: COLUMN analytical_stem_view.subplot; Type: COMMENT; Schema: public; Owner: - |
|
| 4310 |
-- |
|
| 4311 |
|
|
| 4312 |
|
|
| 4313 |
|
|
| 4314 |
|
|
| 4315 |
-- |
|
| 4316 |
-- Name: COLUMN analytical_stem_view.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4317 |
-- |
|
| 4318 |
|
|
| 4319 |
|
|
| 4320 |
|
|
| 4321 |
|
|
| 4322 |
-- |
|
| 4323 |
-- Name: COLUMN analytical_stem_view.locationevent__pkey; Type: COMMENT; Schema: public; Owner: - |
|
| 4324 |
-- |
|
| 4325 |
|
|
| 4326 |
|
|
| 4327 |
|
|
| 4328 |
|
|
| 4329 |
-- |
|
| 4267 | 4330 |
-- Name: COLUMN analytical_stem_view.`eventDate`; Type: COMMENT; Schema: public; Owner: - |
| 4268 | 4331 |
-- |
| 4269 | 4332 |
|
| ... | ... | |
| 4278 | 4341 |
|
| 4279 | 4342 |
|
| 4280 | 4343 |
-- |
| 4344 |
-- Name: COLUMN analytical_stem_view.`slopeAspect`; Type: COMMENT; Schema: public; Owner: - |
|
| 4345 |
-- |
|
| 4346 |
|
|
| 4347 |
|
|
| 4348 |
|
|
| 4349 |
|
|
| 4350 |
-- |
|
| 4351 |
-- Name: COLUMN analytical_stem_view.`slopeGradient`; Type: COMMENT; Schema: public; Owner: - |
|
| 4352 |
-- |
|
| 4353 |
|
|
| 4354 |
|
|
| 4355 |
|
|
| 4356 |
|
|
| 4357 |
-- |
|
| 4358 |
-- Name: COLUMN analytical_stem_view.`plotArea_ha`; Type: COMMENT; Schema: public; Owner: - |
|
| 4359 |
-- |
|
| 4360 |
|
|
| 4361 |
|
|
| 4362 |
|
|
| 4363 |
|
|
| 4364 |
-- |
|
| 4281 | 4365 |
-- Name: COLUMN analytical_stem_view.`samplingProtocol`; Type: COMMENT; Schema: public; Owner: - |
| 4282 | 4366 |
-- |
| 4283 | 4367 |
|
| ... | ... | |
| 4285 | 4369 |
|
| 4286 | 4370 |
|
| 4287 | 4371 |
-- |
| 4372 |
-- Name: COLUMN analytical_stem_view.`temperature_C`; Type: COMMENT; Schema: public; Owner: - |
|
| 4373 |
-- |
|
| 4374 |
|
|
| 4375 |
|
|
| 4376 |
|
|
| 4377 |
|
|
| 4378 |
-- |
|
| 4379 |
-- Name: COLUMN analytical_stem_view.precipitation_m; Type: COMMENT; Schema: public; Owner: - |
|
| 4380 |
-- |
|
| 4381 |
|
|
| 4382 |
|
|
| 4383 |
|
|
| 4384 |
|
|
| 4385 |
-- |
|
| 4386 |
-- Name: COLUMN analytical_stem_view.stratum__name; Type: COMMENT; Schema: public; Owner: - |
|
| 4387 |
-- |
|
| 4388 |
|
|
| 4389 |
|
|
| 4390 |
|
|
| 4391 |
|
|
| 4392 |
-- |
|
| 4393 |
-- Name: COLUMN analytical_stem_view.communities; Type: COMMENT; Schema: public; Owner: - |
|
| 4394 |
-- |
|
| 4395 |
|
|
| 4396 |
|
|
| 4397 |
|
|
| 4398 |
|
|
| 4399 |
-- |
|
| 4400 |
-- Name: COLUMN analytical_stem_view.plot__collectors; Type: COMMENT; Schema: public; Owner: - |
|
| 4401 |
-- |
|
| 4402 |
|
|
| 4403 |
|
|
| 4404 |
|
|
| 4405 |
|
|
| 4406 |
-- |
|
| 4407 |
-- Name: COLUMN analytical_stem_view.`specimenHolderInstitutions`; Type: COMMENT; Schema: public; Owner: - |
|
| 4408 |
-- |
|
| 4409 |
|
|
| 4410 |
|
|
| 4411 |
|
|
| 4412 |
|
|
| 4413 |
-- |
|
| 4288 | 4414 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: - |
| 4289 | 4415 |
-- |
| 4290 | 4416 |
|
| ... | ... | |
| 4292 | 4418 |
|
| 4293 | 4419 |
|
| 4294 | 4420 |
-- |
| 4421 |
-- Name: COLUMN analytical_stem_view.`accessionNumber`; Type: COMMENT; Schema: public; Owner: - |
|
| 4422 |
-- |
|
| 4423 |
|
|
| 4424 |
|
|
| 4425 |
|
|
| 4426 |
|
|
| 4427 |
-- |
|
| 4295 | 4428 |
-- Name: COLUMN analytical_stem_view.`occurrenceID`; Type: COMMENT; Schema: public; Owner: - |
| 4296 | 4429 |
-- |
| 4297 | 4430 |
|
| ... | ... | |
| 4355 | 4488 |
|
| 4356 | 4489 |
|
| 4357 | 4490 |
-- |
| 4491 |
-- Name: COLUMN analytical_stem_view.family_matched; Type: COMMENT; Schema: public; Owner: - |
|
| 4492 |
-- |
|
| 4493 |
|
|
| 4494 |
|
|
| 4495 |
|
|
| 4496 |
|
|
| 4497 |
-- |
|
| 4498 |
-- Name: COLUMN analytical_stem_view.`taxonName_matched`; Type: COMMENT; Schema: public; Owner: - |
|
| 4499 |
-- |
|
| 4500 |
|
|
| 4501 |
|
|
| 4502 |
|
|
| 4503 |
|
|
| 4504 |
-- |
|
| 4505 |
-- Name: COLUMN analytical_stem_view.`scientificNameAuthorship_matched`; Type: COMMENT; Schema: public; Owner: - |
|
| 4506 |
-- |
|
| 4507 |
|
|
| 4508 |
|
|
| 4509 |
|
|
| 4510 |
|
|
| 4511 |
-- |
|
| 4512 |
-- Name: COLUMN analytical_stem_view.`higherPlantGroup_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4513 |
-- |
|
| 4514 |
|
|
| 4515 |
|
|
| 4516 |
|
|
| 4517 |
|
|
| 4518 |
-- |
|
| 4358 | 4519 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: - |
| 4359 | 4520 |
-- |
| 4360 | 4521 |
|
| ... | ... | |
| 4362 | 4523 |
|
| 4363 | 4524 |
|
| 4364 | 4525 |
-- |
| 4526 |
-- Name: COLUMN analytical_stem_view.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 4527 |
-- |
|
| 4528 |
|
|
| 4529 |
|
|
| 4530 |
|
|
| 4531 |
|
|
| 4532 |
-- |
|
| 4533 |
-- Name: COLUMN analytical_stem_view.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 4534 |
-- |
|
| 4535 |
|
|
| 4536 |
|
|
| 4537 |
|
|
| 4538 |
|
|
| 4539 |
-- |
|
| 4540 |
-- Name: COLUMN analytical_stem_view.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 4541 |
-- |
|
| 4542 |
|
|
| 4543 |
|
|
| 4544 |
|
|
| 4545 |
|
|
| 4546 |
-- |
|
| 4547 |
-- Name: COLUMN analytical_stem_view.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 4548 |
-- |
|
| 4549 |
|
|
| 4550 |
|
|
| 4551 |
|
|
| 4552 |
|
|
| 4553 |
-- |
|
| 4554 |
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4555 |
-- |
|
| 4556 |
|
|
| 4557 |
|
|
| 4558 |
|
|
| 4559 |
|
|
| 4560 |
-- |
|
| 4561 |
-- Name: COLUMN analytical_stem_view.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4562 |
-- |
|
| 4563 |
|
|
| 4564 |
|
|
| 4565 |
|
|
| 4566 |
|
|
| 4567 |
-- |
|
| 4568 |
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4569 |
-- |
|
| 4570 |
|
|
| 4571 |
|
|
| 4572 |
|
|
| 4573 |
|
|
| 4574 |
-- |
|
| 4575 |
-- Name: COLUMN analytical_stem_view.scrubbed_morphospecies_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 4576 |
-- |
|
| 4577 |
|
|
| 4578 |
|
|
| 4579 |
|
|
| 4580 |
|
|
| 4581 |
-- |
|
| 4582 |
-- Name: COLUMN analytical_stem_view.`growthForm`; Type: COMMENT; Schema: public; Owner: - |
|
| 4583 |
-- |
|
| 4584 |
|
|
| 4585 |
|
|
| 4586 |
|
|
| 4587 |
|
|
| 4588 |
-- |
|
| 4365 | 4589 |
-- Name: COLUMN analytical_stem_view.`reproductiveCondition`; Type: COMMENT; Schema: public; Owner: - |
| 4366 | 4590 |
-- |
| 4367 | 4591 |
|
| ... | ... | |
| 4369 | 4593 |
|
| 4370 | 4594 |
|
| 4371 | 4595 |
-- |
| 4596 |
-- Name: COLUMN analytical_stem_view.threatened_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4597 |
-- |
|
| 4598 |
|
|
| 4599 |
|
|
| 4600 |
|
|
| 4601 |
|
|
| 4602 |
-- |
|
| 4603 |
-- Name: COLUMN analytical_stem_view.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4604 |
-- |
|
| 4605 |
|
|
| 4606 |
|
|
| 4607 |
|
|
| 4608 |
|
|
| 4609 |
-- |
|
| 4610 |
-- Name: COLUMN analytical_stem_view.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4611 |
-- |
|
| 4612 |
|
|
| 4613 |
|
|
| 4614 |
|
|
| 4615 |
|
|
| 4616 |
-- |
|
| 4372 | 4617 |
-- Name: COLUMN analytical_stem_view.`occurrenceRemarks`; Type: COMMENT; Schema: public; Owner: - |
| 4373 | 4618 |
-- |
| 4374 | 4619 |
|
| ... | ... | |
| 4376 | 4621 |
|
| 4377 | 4622 |
|
| 4378 | 4623 |
-- |
| 4624 |
-- Name: COLUMN analytical_stem_view.`coverPercent`; Type: COMMENT; Schema: public; Owner: - |
|
| 4625 |
-- |
|
| 4626 |
|
|
| 4627 |
|
|
| 4628 |
|
|
| 4629 |
|
|
| 4630 |
-- |
|
| 4631 |
-- Name: COLUMN analytical_stem_view.`diameterBreastHeight_cm`; Type: COMMENT; Schema: public; Owner: - |
|
| 4632 |
-- |
|
| 4633 |
|
|
| 4634 |
|
|
| 4635 |
|
|
| 4636 |
|
|
| 4637 |
-- |
|
| 4638 |
-- Name: COLUMN analytical_stem_view.height_m; Type: COMMENT; Schema: public; Owner: - |
|
| 4639 |
-- |
|
| 4640 |
|
|
| 4641 |
|
|
| 4642 |
|
|
| 4643 |
|
|
| 4644 |
-- |
|
| 4645 |
-- Name: COLUMN analytical_stem_view.tag; Type: COMMENT; Schema: public; Owner: - |
|
| 4646 |
-- |
|
| 4647 |
|
|
| 4648 |
|
|
| 4649 |
|
|
| 4650 |
|
|
| 4651 |
-- |
|
| 4652 |
-- Name: COLUMN analytical_stem_view.`organismX_m`; Type: COMMENT; Schema: public; Owner: - |
|
| 4653 |
-- |
|
| 4654 |
|
|
| 4655 |
|
|
| 4656 |
|
|
| 4657 |
|
|
| 4658 |
-- |
|
| 4659 |
-- Name: COLUMN analytical_stem_view.`organismY_m`; Type: COMMENT; Schema: public; Owner: - |
|
| 4660 |
-- |
|
| 4661 |
|
|
| 4662 |
|
|
| 4663 |
|
|
| 4664 |
|
|
| 4665 |
-- |
|
| 4666 |
-- Name: COLUMN analytical_stem_view.`taxonOccurrenceID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4667 |
-- |
|
| 4668 |
|
|
| 4669 |
|
|
| 4670 |
|
|
| 4671 |
|
|
| 4672 |
-- |
|
| 4673 |
-- Name: COLUMN analytical_stem_view.`authorTaxonCode`; Type: COMMENT; Schema: public; Owner: - |
|
| 4674 |
-- |
|
| 4675 |
|
|
| 4676 |
|
|
| 4677 |
|
|
| 4678 |
|
|
| 4679 |
-- |
|
| 4680 |
-- Name: COLUMN analytical_stem_view.`aggregateOrganismObservationID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4681 |
-- |
|
| 4682 |
|
|
| 4683 |
|
|
| 4684 |
|
|
| 4685 |
|
|
| 4686 |
-- |
|
| 4687 |
-- Name: COLUMN analytical_stem_view.`individualObservationID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4688 |
-- |
|
| 4689 |
|
|
| 4690 |
|
|
| 4691 |
|
|
| 4692 |
|
|
| 4693 |
-- |
|
| 4694 |
-- Name: COLUMN analytical_stem_view.`individualCode`; Type: COMMENT; Schema: public; Owner: - |
|
| 4695 |
-- |
|
| 4696 |
|
|
| 4697 |
|
|
| 4698 |
|
|
| 4699 |
|
|
| 4700 |
-- |
|
| 4701 |
-- Name: COLUMN analytical_stem_view.`individualCount`; Type: COMMENT; Schema: public; Owner: - |
|
| 4702 |
-- |
|
| 4703 |
|
|
| 4704 |
|
|
| 4705 |
|
|
| 4706 |
|
|
| 4707 |
-- |
|
| 4708 |
-- Name: COLUMN analytical_stem_view.`authorStemCode`; Type: COMMENT; Schema: public; Owner: - |
|
| 4709 |
-- |
|
| 4710 |
|
|
| 4711 |
|
|
| 4712 |
|
|
| 4713 |
|
|
| 4714 |
-- |
|
| 4379 | 4715 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 4380 | 4716 |
-- |
| 4381 | 4717 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: indicated provenance of the rest of the terms