2014-03-18 schema changes conference call with Brad¶

decisions¶

VegBIEN schema¶

• the attribution-related schema changes will be postponed until after the validations are done, to avoid delaying the validations
• specimenreplicate.institution_id should instead be renamed to duplicate_institutions_sourcelist_id to indicate that it points to sourcelist

attribution schema¶

• dataset.primary_source_id should be made plural (dataset.primary_sources_id) to reflect that there can be multiple first publishers for a dataset (eg. a specimen can have multiple duplicate institutions)
• project.dataset should be required

aggregating validations¶

• use a LEFT JOIN instead of an inner join to connect locationevents to projects, to support plots datasources that don't have projects

to do for Aaron¶

schema/mappings changes¶

• rename specimenreplicate.institution_id to duplicate_institutions_sourcelist_id

aggregating validations¶

1. write specimens output queries see specimens output queries status
   • requires making sure the NY input queries on which these are based are in working order
2. write plots input queries