EDIorg / ecocomDP

A dataset design pattern and R package for ecological community data.
https://ediorg.github.io/ecocomDP/
Other
32 stars 13 forks source link

unique constraints for ecocomDP tables #22

Closed mobb closed 6 years ago

mobb commented 6 years ago

script should check that a group of fields in each table is unique: observation table:
observation_id, event_id, package_id, sampling_location_id, observation_datetime, taxon_id, variable_name

others tbd. expect the uniq group to be all the ids (except the record_id) up through variable_name (not value or unit). in other words, each row is uniq except for record_id, value, unit

clnsmth commented 6 years ago

I'll integrate this into the validate_ecocomDP function.

clnsmth commented 6 years ago

Done. Checks added to validate_ecocomDP include: