Project

General

Profile

Actions
Copy link

Task #302

closed

Make changes to VegBIEN schema

Added by Aaron Marcuse-Kubitza over 12 years ago. Updated over 12 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Aaron Marcuse-Kubitza
Start date:
12/15/2011
Due date:
% Done:

100%

Estimated time:
Activity type:
Actions
Copy link
 #1

Updated by Aaron Marcuse-Kubitza over 12 years ago

  • % Done changed from 0 to 30

Bob Peet's changes are at VegBIEN from VegBank

E-mail from Bob Peet on 2011-12-22:

I promised to summarize our proposed changes in the VegBank data model as developed at the last BIEN meeting. Please consult the attached abbreviated data dictionary to see if you think I have done this correctly, and to see if you have further suggestions for more or fewer changes. I look forward to yoru comments

Actions
Copy link
 #2

Updated by Aaron Marcuse-Kubitza over 12 years ago

  • % Done changed from 30 to 60

All functions that used to output to VegBank now output to VegBIEN db.
The VegBIEN schema is automatically generated from the VegBank schema based on a set of search-and-replace operations.
VegBIEN schema incorporates renamed tables.

Actions
Copy link
 #3

Updated by Aaron Marcuse-Kubitza over 12 years ago

The vegbien db now contains some of the modifications Bob Peet made to the VegBank schema for VegBIEN, so some table names will be different to those familiar with VegBank.

Actions
Copy link
 #4

Updated by Aaron Marcuse-Kubitza over 12 years ago

I asked Bob a few questions about the new Collection table in the VegBIEN modifications:

  • Is the Collection table meant to refer to a single museum specimen or a collection of specimens?
  • If it should refer to a collection of specimens (as the name implies), why does it have an IndividualPlant_ID attribute linking it to a single organism?
  • In what situation would a Collection be mapped to a TaxonOccurrence vs. an IndividualPlant?
  • Which DarwinCore attributes did you want to include in the Collection table?

Note that I'm using the photo of the whiteboard sketch to supplement the spreadsheet.

Actions
Copy link
 #5

Updated by Aaron Marcuse-Kubitza over 12 years ago

  • % Done changed from 60 to 80

Added new tables and moved/updated columns

Actions
Copy link
 #6

Updated by Aaron Marcuse-Kubitza over 12 years ago

  • % Done changed from 80 to 90

I have applied most of Bob's changes to the VegBIEN schema, as well as many of Mark's suggestions. I posted a summary of the changes under VegBIEN schema.

Actions
Copy link
 #7

Updated by Aaron Marcuse-Kubitza over 12 years ago

  • Status changed from New to Resolved
  • % Done changed from 90 to 100

Extensive changes have been made

Actions
Copy link

Also available in: Atom PDF